问题描述
假设我已经注册了一名员工
InsertEmployee();
现在,下一条语句我想获取该最后一位注册雇员的信息,因为我的要求是根据该雇员的入职日期计算的,因此我需要计算一些值. //此代码在asp.cs文件中的autoid
私人void Autoid()
{
字符串模式="M";
pr.Mode =模式;
dt = new DataTable();
dt = logic.Maxid(pr);
if(dt.Rows [0] [0] .ToString()!=")
{
txtEMPId.Text =(int.Parse(dt.Rows [0] [0] .ToString())+1).ToString();
}
其他
txtRMPId.Text ="1";
}
//inclass cs文件
公共DataTable InsertEmployeeFormat(ParametersBusinessObjects Schbo)
{
DataTable dt = new DataTable();
DataAcessHelper dashp =新的DataAcessHelper();
如果(Schbo.Mode!="M")
{
SqlCommand cmd = dashp.CreateCommand("sp_Employeedetails");
dashp.AddParameter(cmd,"@EmpIdid",SqlDbType.Int,ParameterDirection.Input,4,Schbo.School);
dashp.AddParameter(cmd,"@EmpName",SqlDbType.VarChar,ParameterDirection.Input,30,Schbo.SchoolName);
dashp.AddParameter(cmd,"@LandlineNo",SqlDbType.VarChar,ParameterDirection.Input,20,Schbo.LandlineNo);
dashp.AddParameter(cmd,"@MobileNo",SqlDbType.VarChar,ParameterDirection.Input,20,Schbo.MobileNo);
dashp.AddParameter(cmd,"@Address",SqlDbType.VarChar,ParameterDirection.Input,30,Schbo.Address);
dashp.AddParameter(cmd,"@ DateofBirth",SqlDbType.Date,ParameterDirection.Input,30,Schbo.strDate);
dashp.AddParameter(cmd,"@EndDate",SqlDbType.Date,ParameterDirection.Input,30,Schbo.EndDate);
dashp.AddParameter(cmd,"@Flag",SqlDbType.VarChar,ParameterDirection.Input,2,Schbo.Mode);
if(Schbo.Mode!="A" && Schbo.Mode!="S" && Schbo.Mode!="G" && Schbo.Mode!="N")
{
dashp.ExecuteStoredProcedure(cmd);
}
其他
{
dt = dashp.GetDataTable(cmd);
}
}
其他
{
SqlCommand cmd = dashp.CreateCommand("sp_maxid");
dt = dashp.GetDataTable(cmd);
}
return dt;
}
//存储过程
ALTER PROCEDURE sp_maxid
/*
(
@ parameter1 int = 5,
@ parameter2数据类型OUTPUT
)
*/
AS
从EmployeeDetailsInfo中选择max(intEmployeeId)
返回
你试试这个.............
Suppose I have registered an employee
InsertEmployee();
Now next statement I want to get information for that last registered employee because my requirement is according to the date of joining of that employee I need to calculate some value.
这篇关于如何获取在线系统中最后一位注册员工的信息?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!