/// <summary>
/// 用户列表修改保存
/// </summary>
/// <param name="BCheckPersonnel"></param>
/// <returns></returns>
public ActionResult UpdataCheckPer(B_CheckPersonnel BCheckPersonnel)
{
string strMsg = "fali";
var pdACheckPersonnel = (from tbCheckPer in myModels.B_CheckPersonnel
where
tbCheckPer.CheckPersonnelID == BCheckPersonnel.CheckPersonnelID
select tbCheckPer).Single();
if (pdACheckPersonnel != null)
{
pdACheckPersonnel.CheckName = BCheckPersonnel.CheckName;
pdACheckPersonnel.CheckUserName = BCheckPersonnel.CheckUserName;
pdACheckPersonnel.SexID = BCheckPersonnel.SexID;
pdACheckPersonnel.MaillSite = BCheckPersonnel.MaillSite;
pdACheckPersonnel.PhoneCode = BCheckPersonnel.PhoneCode;
pdACheckPersonnel.RegisterTime = BCheckPersonnel.RegisterTime;
pdACheckPersonnel.FinallyEnterTime = BCheckPersonnel.FinallyEnterTime;
pdACheckPersonnel.UserStateID = BCheckPersonnel.UserStateID;
myModels.Entry(pdACheckPersonnel).State = System.Data.Entity.EntityState.Modified;
if (myModels.SaveChanges() > 0)
{
strMsg = "success";
}
}
return(Json(strMsg, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 查询最后一条数据的用户名
/// </summary>
/// <returns></returns>
public ActionResult SelectCheckName()
{
string strRoleName = "";
var listRoleName = (from tbName in myModels.B_CheckPersonnel
orderby tbName.CheckPersonnelID,
tbName.CheckName
select tbName).ToList();
if (listRoleName.Count > 0)
{
int count = listRoleName.Count;
B_CheckPersonnel modelUR = listRoleName[count - 1]; //获取表的最后一条数据
strRoleName = modelUR.CheckName.ToString(); //获取最后一个用户名
}
return(Json(strRoleName, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 用户列表删除数据
/// </summary>
/// <returns></returns>
public ActionResult DeleteCheckper(int CheckPersonnelID)
{
string strMsg = "fail";
try
{
B_CheckPersonnel dbCheckPer = (from tbCheckPer in myModels.B_CheckPersonnel
where tbCheckPer.CheckPersonnelID == CheckPersonnelID
select tbCheckPer).Single();
myModels.B_CheckPersonnel.Remove(dbCheckPer);
myModels.SaveChanges();
strMsg = "success";
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(Json(strMsg, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 用户列表新增
/// </summary>
/// <param name="CheckName"></param>
/// <param name="CheckUserName"></param>
/// <param name="SexID"></param>
/// <param name="MaillSite"></param>
/// <param name="PhoneCode"></param>
/// <param name="RegisterTime"></param>
/// <param name="FinallyEnterTime"></param>
/// <param name="UserStateID"></param>
/// <returns></returns>
public ActionResult InsertCheckPersonnel(string CheckName, string CheckUserName, int SexID, string MaillSite, string PhoneCode, DateTime RegisterTime, DateTime FinallyEnterTime, int UserStateID)
{
string strMsg = "fail";
try
{
int oldCheckPersonnel = (from tbCheckPersonnel in myModels.B_CheckPersonnel
where
tbCheckPersonnel.CheckName == CheckName &&
tbCheckPersonnel.CheckUserName == CheckUserName &&
tbCheckPersonnel.SexID == SexID &&
tbCheckPersonnel.MaillSite == MaillSite &&
tbCheckPersonnel.PhoneCode == PhoneCode &&
tbCheckPersonnel.RegisterTime == RegisterTime &&
tbCheckPersonnel.FinallyEnterTime == FinallyEnterTime &&
tbCheckPersonnel.UserStateID == UserStateID
select tbCheckPersonnel).Count();
if (oldCheckPersonnel == 0)
{
B_CheckPersonnel myCheckPersonnel = new B_CheckPersonnel();
myCheckPersonnel.CheckName = CheckName;
myCheckPersonnel.CheckUserName = CheckUserName;
myCheckPersonnel.SexID = SexID;
myCheckPersonnel.MaillSite = MaillSite;
myCheckPersonnel.PhoneCode = PhoneCode;
myCheckPersonnel.RegisterTime = RegisterTime;
myCheckPersonnel.FinallyEnterTime = FinallyEnterTime;
myCheckPersonnel.UserStateID = UserStateID;
myModels.B_CheckPersonnel.Add(myCheckPersonnel);
if (myModels.SaveChanges() > 0)
{
strMsg = "success";
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(Json(strMsg, JsonRequestBehavior.AllowGet));
}
