public ActionResult Edit(int id)
{
var userInfo = new UserInfoBaseBLL().GetEntity(o => o.pkid == id);
ViewBag.UserInfoBase = userInfo;
return(View());
}
public void testSql()
{
//MySql.Data.MySqlClient.MySqlParameter
UserInfoBaseBLL userinfobll = new UserInfoBaseBLL();
userinfobll.ExecuteSqlCommand("update t_userinfo_base set usernameen = '{usernameen}' ", new MySqlParameter("usernameen", MySqlDbType.VarChar));
}
public void TestGetEntity()
{
UserInfoBaseBLL userinfobll = new UserInfoBaseBLL();
var model = userinfobll.GetEntity(o => o.pkid == 1);
Assert.AreNotEqual(null, model);
}
private bool UpdateUserBase(t_user_resume resume, UserStatus userStatus)
{
var userInfoBaseBll = new UserInfoBaseBLL();
var userInfo = userInfoBaseBll.GetEntity(o => o.pkid == resume.userid);
userInfo.updatetime = DateTime.Now;
userInfo.updateuserid = userStatus.UserID;
return(userInfoBaseBll.UpdateEntity(userInfo));
}
private bool UpdateUserInfo(t_user_deptchange deptChange, UserStatus userStatus)
{
var userInfoBaseBLL = new UserInfoBaseBLL();
var userInfo = userInfoBaseBLL.GetEntity(o => o.pkid == deptChange.userid);
userInfo.departid = deptChange.newdeptid;
userInfo.updatetime = DateTime.Now;
userInfo.updateuserid = userStatus.UserID;
return(userInfoBaseBLL.UpdateEntity(userInfo));
}
private bool UpdateUserInfo(t_user_titlechange titleChange, UserStatus userStatus)
{
var userInfoBaseBLL = new UserInfoBaseBLL();
var userInfo = userInfoBaseBLL.GetEntity(o => o.pkid == titleChange.userid);
userInfo.lasttitle = titleChange.title;
userInfo.updatetime = DateTime.Now;
userInfo.updateuserid = userStatus.UserID;
return(userInfoBaseBLL.UpdateEntity(userInfo));
}
private bool UpdateUserInfo(t_user_postchange postChange, UserStatus userStatus)
{
var userInfoBaseBLL = new UserInfoBaseBLL();
var userInfo = userInfoBaseBLL.GetEntity(o => o.pkid == postChange.userid);
userInfo.lastjobpost = postChange.post;
userInfo.updatetime = DateTime.Now;
userInfo.updateuserid = userStatus.UserID;
return(userInfoBaseBLL.UpdateEntity(userInfo));
}
public ActionResult EditSave(int id)
{
UserInfoBaseBLL userInfoBaseBll = new UserInfoBaseBLL();
t_userinfo_base userInfoBase = userInfoBaseBll.GetEntity(o => o.pkid == id);
GenerateUserInfoFromRequest(userInfoBase, Request);
bool res = userInfoBaseBll.AddEntity(userInfoBase);
return(Json(""));
}
public ActionResult CreateSave()
{
t_userinfo_base userInfoBase = new t_userinfo_base();
GenerateUserInfoFromRequest(userInfoBase, Request);
UserInfoBaseBLL userInfoBaseBll = new UserInfoBaseBLL();
bool res = userInfoBaseBll.AddEntity(userInfoBase);
return(Json(""));
}
private bool UpdateUserInfo(t_user_picchange picChange, UserStatus userStatus)
{
var userInfoBaseBLL = new UserInfoBaseBLL();
var userInfo = userInfoBaseBLL.GetEntity(o => o.pkid == picChange.userid);
userInfo.userselfpic = picChange.pic;
userInfo.userselfpictype = picChange.pictype;
userInfo.updatetime = DateTime.Now;
userInfo.updateuserid = userStatus.UserID;
return(userInfoBaseBLL.UpdateEntity(userInfo));
}
public void TestAdd()
{
UserInfoBaseBLL userinfobll = new UserInfoBaseBLL();
t_userinfo_base userinfo = new t_userinfo_base();
userinfo.basecityid = 1;
userinfo.birthcity = 1;
userinfo.birthcountry = 1;
userinfo.birthday = DateTime.Now.AddYears(20);
userinfo.callnums = "13305331614";
userinfo.checkindate = new DateTime(2018, 10, 10);
userinfo.checkoutdate = null;
userinfo.costcenterid = 1;
userinfo.departid = 1;
userinfo.emailcom = "*****@*****.**";
userinfo.emailself = "*****@*****.**";
userinfo.faxnums = "123245";
userinfo.gender = "男";
userinfo.groupid = 1;
userinfo.inpartydate = DateTime.Now.AddYears(-3);
userinfo.isdeleted = 0;
userinfo.lastjobpost = 1;
userinfo.lastlevel = 1;
userinfo.lastlogdate = DateTime.Now;
userinfo.lastschool = "beida";
userinfo.lastschooldate = DateTime.Now.AddYears(-5);
userinfo.lastspeciality = "computer";
userinfo.lasttitle = 1;
userinfo.nationalityid = 1;
userinfo.nickname = "niickname";
userinfo.officenum = "12345";
userinfo.phonenums = "1233457";
userinfo.politicalid = 2;
userinfo.pycodefull = "zhangsan";
userinfo.pycodeshort = "zs";
userinfo.secuserid1 = 4;
userinfo.secuserid2 = 5;
userinfo.statusid = 0;
userinfo.subcomid = 10;
userinfo.towerid = 12;
userinfo.updatetime = DateTime.Now;
userinfo.updateuserid = 1;
userinfo.usercode = "asd";
userinfo.userhrpic = null;
userinfo.userhrpictype = null;
userinfo.usernameen = "张三";
userinfo.userselfpic = null;
userinfo.userselfpictype = null;
userinfo.workcityid = 10;
bool b = userinfobll.AddEntity(userinfo);
Assert.AreEqual(true, b);
}
/// <summary>
/// 删除学历 同时更新主表学历内容
/// </summary>
/// <param name="useredu"></param>
/// <param name="userStatus"></param>
/// <returns></returns>
public bool DeleteEduRecord(t_user_edu useredu, UserStatus userStatus)
{
UserInfoBaseBLL userInfoBll = new UserInfoBaseBLL();
var userInfo = userInfoBll.GetEntity(o => o.pkid == useredu.userid);
if (userInfo == null)
{
return(false);
}
bool b = DeleteEntity(useredu);
var lastRecord = GetList(null)?.OrderByDescending(o => o.startdate).FirstOrDefault();
b = b & UpdateUserInfo(userInfo, lastRecord, userStatus);
return(b);
}
/// <summary>
/// 更新edu 相关的t_userinfo_base
/// </summary>
/// <param name="userInfo"></param>
/// <param name="lastRecord"></param>
/// <param name="userStatus"></param>
/// <returns></returns>
private bool UpdateUserInfo(t_userinfo_base userInfo, t_user_edu lastRecord, UserStatus userStatus)
{
bool res = true;
if (lastRecord != null && userInfo.lastrecord != lastRecord.education)
{
userInfo.lastrecord = lastRecord.education;
userInfo.lastschool = lastRecord.university;
userInfo.lastschooldate = lastRecord.enddate;
userInfo.lastspeciality = lastRecord.major;
}
if (lastRecord == null)
{
userInfo.lastrecord = null;
userInfo.lastschool = null;
userInfo.lastschooldate = null;
userInfo.lastspeciality = null;
}
userInfo.updatetime = DateTime.Now;
userInfo.updateuserid = userStatus.UserID;
res = new UserInfoBaseBLL().UpdateEntity(userInfo);
return(res);
}