internal static int UpdateInfo(EmployeeUser info)
{
int result = 0;
if (info.PId != 5)
{
SQLHelper.ProcNoQuery("usp_EmployeeUserOldModify", new SqlParameter("@pid", info.PId));
result = SQLHelper.ExecuteNonQuery("update T_position set employeeid=@eid where id=@pid", info.Id, info.PId);
}
result = SQLHelper.ProcNoQuery("usp_EmployeeUserUpdateInfo", new SqlParameter("@id", info.Id), new SqlParameter("@name", info.Name), new SqlParameter("@pid", info.PId), new SqlParameter("did", info.DId), new SqlParameter("spid", info.SPId), new SqlParameter("@loginname", info.LoginName), new SqlParameter("@userlevel", info.UserLevel));
return(result);
}
internal static int AddInfo(EmployeeUser info)
{
object obj = SQLHelper.ExecuteScalar("insert into T_employee(name, positionid, departmentid, superiorposid) output inserted.id values(@name, @positionid, @departmentid, @superiorposid)", info.Name, info.PId, info.DId, info.SPId);
info.Id = Convert.ToInt32(obj);
int result = SQLHelper.ExecuteNonQuery("insert into T_user(eid, loginname, userlevel) output inserted.id values(@eid, @loginname, @userlevel)", info.Id, info.LoginName, info.UserLevel);
if (info.PId != 5)
{
result = SQLHelper.ExecuteNonQuery("update T_position set employeeid=@eid where id=@pid", info.Id, info.PId);
}
return(result);
}
internal static EmployeeUser GetInfoById(int id)
{
EmployeeUser info = new EmployeeUser();
DataTable dt = SQLHelper.ProcDataTable("usp_EmployeeUserGetById", new SqlParameter("@id", id));
info.Id = id;
info.Name = dt.Rows[0]["name"].ToString();
info.PId = Convert.ToInt32(dt.Rows[0]["pid"]);
info.DId = Convert.ToInt32(dt.Rows[0]["did"]);
info.SPId = Convert.ToInt32(dt.Rows[0]["spid"]);
info.UId = Convert.ToInt32(dt.Rows[0]["uid"]);
info.LoginName = dt.Rows[0]["loginname"].ToString();
info.UserLevel = Convert.ToInt32(dt.Rows[0]["userlevel"]);
return(info);
}
internal static List <EmployeeUser> GetList()
{
DataTable dt = SQLHelper.ProcDataTable("usp_EmployeeUserList");
List <EmployeeUser> list = new List <EmployeeUser>();
foreach (DataRow row in dt.Rows)
{
EmployeeUser info = new EmployeeUser();
info.Id = Convert.ToInt32(row["id"]);
info.Name = row["name"].ToString();
info.PName = row["pname"].ToString();
info.DName = row["dname"].ToString();
info.SPName = row["spname"].ToString();
info.LoginName = row["loginname"].ToString();
info.IsOnJob = Convert.ToBoolean(row["isonjob"]);
list.Add(info);
}
return(list);
}
