public ActionResult Details(int id)
{
ViewBag.Perm = GetPermission();
SysUserModel model = userBLL.GetEntityById(id);
return(View("Details", model));
}
public JsonResult CheckLogin(string UserName, string Password, string Code)
{
//if (Session["Code"] == null)
//{
// return Json(JsonHandler.CreateMessage(0, "请重新刷新验证码！"), JsonRequestBehavior.AllowGet);
//}
//if (Session["Code"].ToString().ToLower() != Code.ToLower())
//{
// return Json(JsonHandler.CreateMessage(0, "验证码错误！"), JsonRequestBehavior.AllowGet);
//}
SysUser user = accountBLL.Login(UserName, ValueConvert.MD5(Password));
if (user == null)
{
return(Json(JsonHandler.CreateMessage(0, "用户名或密码错误！"), JsonRequestBehavior.AllowGet));
}
else if (!Convert.ToBoolean(user.State))
{
return(Json(JsonHandler.CreateMessage(0, "账户被系统禁用！"), JsonRequestBehavior.AllowGet));
}
SysUserModel account = new SysUserModel();
account.Id = user.Id;
account.TrueName = user.TrueName;
Session["Account"] = account;
return(Json(JsonHandler.CreateMessage(1, "登陆成功！"), JsonRequestBehavior.AllowGet));
}
public virtual bool Create(SysUserModel model)
{
try
{
tbl_SysUser entity = m_Rep.GetById(model.UserId);
if (entity != null)
{
return(false);
}
entity = new tbl_SysUser();
entity.UserId = model.UserId;
entity.UserName = model.UserName;
entity.PassWord = model.PassWord;
entity.PhoneNumber = model.PhoneNumber;
entity.SchoolCard = model.SchoolCard;
entity.Sex = model.Sex;
entity.DepId = model.DepId;
entity.PosId = model.PosId;
if (m_Rep.Create(entity))
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
public JsonResult Edit(SysUserModel info)
{
if (info != null && ModelState.IsValid)
{
Apps.IService.IServiceSession serviceSession = OpeCur.ServiceSession;
serviceSession.SysUser.Edit(ref errors, info);
string ErrorCol = errors.Error;
if (serviceSession.SaveChange() > 0)
{
OpeCur.SetOtherHMC(info.Id);
OpeCur.AccountNow.AllMerchant = false;
LogHandler.WriteServiceLog(OpeCur.AccountNow.Id, "Id:" + info.Id + ",Name:" + info.UserName, "成功", "修改", "用户设置");
return(OpeCur.AjaxMsgOK("修改成功！" + ErrorCol));
}
else
{
LogHandler.WriteServiceLog(OpeCur.AccountNow.Id, "Id:" + info.Id + ",Name:" + info.UserName + "," + ErrorCol, "失败", "修改", "用户设置");
return(OpeCur.AjaxMsgNOOK("修改失败！" + ErrorCol));
}
}
else
{
return(OpeCur.AjaxMsgNOOK(Resource.ModelStateValidFail));
}
}
public SysUserModel Login(string username, string pwd)
{
SysUser entity = accountRepository.Login(username, pwd);
if (entity == null)
{
return(null);
}
else
{
SysUserModel model = new SysUserModel();
model.Id = entity.Id;
model.UserName = entity.UserName;
model.Password = entity.Password;
model.TrueName = entity.TrueName;
model.Card = entity.Card;
model.MobileNumber = entity.MobileNumber;
model.Address = entity.Address;
model.Province = entity.Province;
model.City = entity.City;
model.Village = entity.Village;
model.State = entity.State;
model.CreateTime = entity.CreateTime;
model.CreatePerson = entity.CreatePerson;
model.Sex = entity.Sex;
model.Birthday = entity.Birthday;
model.DepId = entity.DepId;
model.PosId = entity.PosId;
model.Expertise = entity.Expertise;
model.Photo = entity.Photo;
model.Lead = entity.Lead;
model.LeadName = entity.LeadName;
return(model);
}
}
public JsonResult UserUpdate(SysUserModel user)
{
object[] message = new object[2];
int code = -1;
string mess = "";
CDatabaseLam db = new CDatabaseLam();
DataSet ds = new DataSet();
try
{
if (user != null)
{
if (Session[CConfig.SESSION_USERID] != null)
{
user.ID = Int32.Parse(Session[CConfig.SESSION_USERID].ToString());
user.Modifyby = Int32.Parse(Session[CConfig.SESSION_USERID].ToString());
db.UserUpdate(user, ref code, ref mess);
message[0] = mess;
message[1] = code;
}
}
}
catch (Exception ex)
{
throw ex;
}
return(Json(new { mess = message }, JsonRequestBehavior.AllowGet));
}
public JsonResult Create(SysUserModel model)
{
if (model != null && ModelState.IsValid)
{
Apps.IService.IServiceSession serviceSession = OpeCur.ServiceSession;
string curUserId = OpeCur.AccountNow.Id;
model.Id = ResultHelper.NewId;
model.CreateTime = ResultHelper.NowTime;
model.Password = ValueConvert.MD5(model.Password);
model.CreatePerson = OpeCur.AccountNow.TrueName;
model.State = true;
serviceSession.SysUser.Create(ref errors, model);
if (serviceSession.SaveChange() > 0)
{
LogHandler.WriteServiceLog(curUserId, "Id:" + model.Id + ",Name:" + model.UserName, "成功", "创建", "用户设置");
return(OpeCur.AjaxMsgOK("创建成功！"));
}
else
{
string ErrorCol = errors.Error;
LogHandler.WriteServiceLog(curUserId, "Id:" + model.Id + ",Name:" + model.UserName + "," + ErrorCol,
"失败", "创建", "用户设置");
return(OpeCur.AjaxMsgNOOK("创建失败！" + ErrorCol));
}
}
else
{
return(OpeCur.AjaxMsgNOOK(Resource.ModelStateValidFail));
}
}
//CDatabaseNam db = new CDatabaseNam();
//
// GET: /FloorPlan
public ActionResult Index()
{
userinformation = TempData["userinfo"] as SysUserModel;
if (TempData["userinfo"] == null)
{
try
{
LoginModel mdlogin = new LoginModel();
mdlogin.UserName = "";
mdlogin.Email = "";
/*Get thông tin user đăng nhập*/
userinformation = data.AccountGetInfomation(mdlogin, Int32.Parse(Session[CConfig.SESSION_USERID].ToString()));
}
catch (Exception ex)
{
return(RedirectToAction("Index500", "Error"));
}
TempData["userinfo"] = userinformation;
TempData.Keep("userinfo");
}
TempData["FullName"] = userinformation.FullName;
TempData["HotelCode"] = userinformation.CodeSysHotel;
TempData["HotelName"] = userinformation.NameSysHotel;
return(View());
}
public JsonResult Create(SysUserModel model)
{
if (model != null && ModelState.IsValid)
{
model.Id = ResultHelper.NewId;
model.CreateTime = ResultHelper.NowTime;
model.Password = ValueConvert.MD5(model.Password);
model.CreatePerson = GetUserTrueName();
model.State = true;
if (m_BLL.Create(ref errors, model))
{
LogHandler.WriteServiceLog(GetUserId(), "Id:" + model.Id + ",Name:" + model.UserName, "成功", "创建", "用户设置");
return(Json(JsonHandler.CreateMessage(1, Resource.InsertSucceed), JsonRequestBehavior.AllowGet));
}
else
{
string ErrorCol = errors.Error;
LogHandler.WriteServiceLog(GetUserId(), "Id:" + model.Id + ",Name:" + model.UserName + "," + ErrorCol,
"失败", "创建", "用户设置");
return(Json(JsonHandler.CreateMessage(0, Resource.InsertFail + ErrorCol),
JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(JsonHandler.CreateMessage(0, Resource.InsertFail), JsonRequestBehavior.AllowGet));
}
}
public JsonResult Create(SysUserModel model)
{
model.CreatePerson = GetUserId();
model.CreateTime = ResultHelper.NowTime;
model.JoinDate = ResultHelper.NowTime;
model.Birthday = ResultHelper.NowTime;
model.PosId = "20001";
model.DepId = "20000";
//var error = ModelState.Values.SelectMany(r => r.Errors);
if (model != null && ModelState.IsValid)
{
if (userBLL.Create(ref errors, model))
{
LogHandler.WriteServiceLog(GetUserId(), "Id" + model.Id + ",UserName" + model.UserName, "成功", "创建", "SysUser");
return(Json(JsonHandler.CreateMessage(1, Suggestion.InsertSucceed)));
}
else
{
string ErrorCol = errors.Error;
LogHandler.WriteServiceLog(GetUserId(), "Id" + model.Id + ",UserName" + model.UserName + "," + ErrorCol, "失败", "创建", "SysUser");
return(Json(JsonHandler.CreateMessage(0, Suggestion.InsertFail + ErrorCol)));
}
}
else
{
return(Json(JsonHandler.CreateMessage(0, Suggestion.InsertFail)));
}
}
private void ToEntity(SysUserModel model, ref SystemUser entity)
{
var ignoreList = new List <string>();
ignoreList.Add("CREATE_USER");
ignoreList.Add("CREATE_DATE");
ignoreList.Add("LASTUPDATE_USER");
ignoreList.Add("LASTUPDATE_DATE");
new ObjectHelper().CopyValue(model, entity, ignoreList);
if (entity.ID == 0)
{
entity.CREATE_USER = UserInfo.Id;
entity.CREATE_DATE = DateTime.Now;
}
else
{
entity.UPDATE_DATE = DateTime.Now;
entity.UPDATE_USER = UserInfo.Id;
}
if (model.Enabled == "True")
{
entity.Enabled = "Y";
}
else
{
entity.Enabled = "N";
}
}
public string EditModule(SysUserModel model)
{
var a = moduleBLL.Edit(model);
var jsondata = js.Serialize(new { flag = a });
return(jsondata);
}
public bool Update(SysUserModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update SYS_USER set ");
builder.Append("UserID=@UserID,");
builder.Append("UserName=@UserName,");
builder.Append("PassWord=@PassWord,");
builder.Append("Addr=@Addr,");
builder.Append("Tel=@Tel,");
builder.Append("Status=@Status,");
builder.Append("Remark=@Remark,");
builder.Append("ResetPassword=@ResetPassword,");
builder.Append("Isuk=@Isuk,");
builder.Append("Email=@Email,");
builder.Append("Sex=@Sex,");
builder.Append("ProvinceID=@ProvinceID,");
builder.Append("CityID=@CityID,");
builder.Append("DistrictID=@DistrictID,");
builder.Append("TownID=@TownID,");
builder.Append("VillageID=@VillageID");
builder.Append(" where ID=@ID ");
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@UserID", MySqlDbType.String),
new MySqlParameter("@UserName", MySqlDbType.String),
new MySqlParameter("@PassWord", MySqlDbType.String),
new MySqlParameter("@Addr", MySqlDbType.String),
new MySqlParameter("@Tel", MySqlDbType.String),
new MySqlParameter("@Status", MySqlDbType.String),
new MySqlParameter("@Remark", MySqlDbType.String),
new MySqlParameter("@ResetPassword", MySqlDbType.String),
new MySqlParameter("@Isuk", MySqlDbType.String),
new MySqlParameter("@Email", MySqlDbType.String),
new MySqlParameter("@Sex", MySqlDbType.String),
new MySqlParameter("@ProvinceID", MySqlDbType.String),
new MySqlParameter("@CityID", MySqlDbType.String),
new MySqlParameter("@DistrictID", MySqlDbType.String),
new MySqlParameter("@TownID", MySqlDbType.String),
new MySqlParameter("@VillageID", MySqlDbType.String),
new MySqlParameter("@ID", MySqlDbType.String),
};
cmdParms[0].Value = model.UserID;
cmdParms[1].Value = model.UserName;
cmdParms[2].Value = model.PassWord;
cmdParms[3].Value = model.Addr;
cmdParms[4].Value = model.Tel;
cmdParms[5].Value = model.Status;
cmdParms[6].Value = model.Remark;
cmdParms[7].Value = model.ResetPassword;
cmdParms[8].Value = model.Isuk;
cmdParms[9].Value = model.Email;
cmdParms[10].Value = model.Sex;
cmdParms[11].Value = model.ProvinceID;
cmdParms[12].Value = model.CityID;
cmdParms[13].Value = model.DistrictID;
cmdParms[14].Value = model.TownID;
cmdParms[15].Value = model.VillageID;
cmdParms[16].Value = model.ID;
return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public List <SysUserModel> ListInforSysUser()
{
List <SysUserModel> list = new List <SysUserModel>();
try
{
DataSet ds = new CDatabase().GetInforSysUser();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
SysUserModel obj = new SysUserModel();
obj.ID = Int32.Parse(ds.Tables[0].Rows[i]["ID"].ToString());
obj.FullName = ds.Tables[0].Rows[i]["FullName"].ToString();
obj.UserName = ds.Tables[0].Rows[i]["UserName"].ToString();
obj.Mobile = ds.Tables[0].Rows[i]["Mobile"].ToString();
obj.IdentityNumber = ds.Tables[0].Rows[i]["IdentityNumber"].ToString();
obj.Status = Int32.Parse(ds.Tables[0].Rows[i]["Status"].ToString());
obj.IsActive = Int32.Parse(ds.Tables[0].Rows[i]["IsActive"].ToString());
obj.NameSysHotelID = ds.Tables[0].Rows[i]["Name"].ToString();
obj.NameModifyby = ds.Tables[0].Rows[i]["EditName"].ToString();
//obj.NameParentID = ds.Tables[0].Rows[0]["ParentID"].ToString();
obj.NameCreateby = ds.Tables[0].Rows[i]["CreateName"].ToString();
if (obj.IsActive != 0)
{
list.Add(obj);
}
}
return(list);
}
catch (Exception)
{
return(list);
}
}
public ActionResult Details(string id)
{
ViewBag.Perm = GetPermission();
SysUserModel entity = m_BLL.GetById(id);
return(View(entity));
}
public ReplayBase EditSysUser(SysUserModel sysuserinfo)
{
SysManagerService sms = new SysManagerService();
sms.SysUserInfo = sysuserinfo;
ReplayBase result = sms.SaveUser();
if (result.ReturnCode == EnumErrorCode.Success)
{
//发起者
SysUserLogModel log = new SysUserLogModel()
{
Describe = "添加/编辑用户:" + sms.SysUserInfo.FullName,
SysUserId = User.Identity.Name
};
SysManagerService.CreateSysUserLog(log);
SysManagerService sms1 = new SysManagerService();//操作员
sms1.GetSysUser(User.Identity.Name);
//被记录
SysUserLogModel log1 = new SysUserLogModel()
{
SysUserId = result.ReturnMessage,
Describe = "用户被创建By" + sms1.SysUserInfo.FullName
};
SysManagerService.CreateSysUserLog(log1);
}
return(result);
}
/*TrungND 21/10/16 gán thông tin cho khách sạn*/
public List <SysUserModel> GetAllUser()
{
List <SysUserModel> list = new List <SysUserModel>();
try
{
DataTable dt = new CDatabase().GetAllSysUser().Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
SysUserModel obj = new SysUserModel();
obj.ID = Int32.Parse(dt.Rows[i]["ID"].ToString());
obj.FullName = dt.Rows[i]["FullName"].ToString();
obj.Address = dt.Rows[i]["Address"].ToString();
obj.IdentityNumber = dt.Rows[i]["IdentityNumber"].ToString();
obj.Mobile = dt.Rows[i]["Mobile"].ToString();
obj.ParentID = Int32.Parse(dt.Rows[i]["ParentID"].ToString());
obj.Status = Int32.Parse(dt.Rows[i]["Status"].ToString());
obj.Department = Int32.Parse(dt.Rows[i]["Department"].ToString());
obj.IsActive = dt.Rows[i]["IsActive"].ToString() == "" ? 0 : Int32.Parse(dt.Rows[i]["IsActive"].ToString());
//obj.ModifyDate = string.IsNullOrEmpty(dt.Rows[i]["ModifyDate"].ToString()) ? null : DateTime.Parse(dt.Rows[i]["ModifyDate"].ToString());
//obj.Modifyby = Int32.Parse(dt.Rows[i]["Modifyby"].ToString());
//obj.Createby = Int32.Parse(dt.Rows[i]["Createby"].ToString());
//obj.CreateDate = DateTime.Parse(dt.Rows[i]["CreateDate"].ToString());
list.Add(obj);
}
return(list);
}
catch (Exception)
{
return(null);
}
}
public ActionResult AddNew(SysUserModel model)
{
var item = new SystemUser();
var errMsg = Save(model, item, EntityState.Added);
return(ResultHandler(errMsg, model));
}
public ActionResult Update(SysUserModel model)
{
var item = _Service.GetByKey(model.ID);
var errMsg = Save(model, item, EntityState.Modified);
return(ResultHandler(errMsg, model));
}
public bool EditPwd(ref ValidationErrors errors, SysUserModel model)
{
try
{
SysUser entity = m_Rep.GetById(model.Id);
if (entity == null)
{
errors.Add(Resource.Disable);
return(false);
}
entity.Password = model.Password;
if (m_Rep.Edit(entity))
{
return(true);
}
else
{
errors.Add(Resource.NoDataChange);
return(false);
}
}
catch (Exception ex)
{
errors.Add(ex.Message);
ExceptionHander.WriteException(ex);
return(false);
}
}
public ActionResult Edit(string id)
{
ViewBag.perm = GetPermission();
SysUserModel entity = userBLL.GetById(id);
return(View(entity));
}
public ActionResult Edit(int?id)
{
ViewBag.Perm = GetPermission();
SysUserModel model = userBLL.GetEntityById(id ?? 0);
return(View("Edit", model));
}
public string delete(SysUserModel model)
{
var a = moduleBLL.Delete(model.UserId);
var jsondata = js.Serialize(new { flag = a });
return(jsondata);
}
public SysUserModel DataRowToModel(DataRow row)
{
SysUserModel sysUserModel = new SysUserModel();
if (row != null)
{
sysUserModel.ID = row["ID"].ToString();
if ((row["UserID"] != null) && (row["UserID"] != DBNull.Value))
{
sysUserModel.UserID = row["UserID"].ToString();
}
if ((row["UserName"] != null) && (row["UserName"] != DBNull.Value))
{
sysUserModel.UserName = row["UserName"].ToString();
}
if ((row["PassWord"] != null) && (row["PassWord"] != DBNull.Value))
{
sysUserModel.PassWord = row["PassWord"].ToString();
}
if ((row["Addr"] != null) && (row["Addr"] != DBNull.Value))
{
sysUserModel.Addr = row["Addr"].ToString();
}
if ((row["Tel"] != null) && (row["Tel"] != DBNull.Value))
{
sysUserModel.Tel = row["Tel"].ToString();
}
if ((row["Status"] != null) && (row["Status"] != DBNull.Value))
{
sysUserModel.Status = row["Status"].ToString();
}
if ((row["Remark"] != null) && (row["Remark"] != DBNull.Value))
{
sysUserModel.Remark = row["Remark"].ToString();
}
if ((row["ResetPassword"] != null) && (row["ResetPassword"] != DBNull.Value))
{
sysUserModel.ResetPassword = row["ResetPassword"].ToString();
}
if ((row["Isuk"] != null) && (row["Isuk"] != DBNull.Value))
{
sysUserModel.Isuk = row["Isuk"].ToString();
}
if ((row["Email"] != null) && (row["Email"] != DBNull.Value))
{
sysUserModel.Email = row["Email"].ToString();
}
if ((row["Sex"] != null) && (row["Sex"] != DBNull.Value))
{
sysUserModel.Sex = row["Sex"].ToString();
}
sysUserModel.ProvinceID = row["ProvinceID"].ToString();
sysUserModel.CityID = row["CityID"].ToString();
sysUserModel.DistrictID = row["DistrictID"].ToString();
sysUserModel.TownID = row["TownID"].ToString();
sysUserModel.VillageID = row["VillageID"].ToString();
}
return(sysUserModel);
}
public void Edit(ref ValidationErrors errors, SysUserModel model)
{
SysUser entity = m_Rep.GetById(model.Id);
if (entity == null)
{
errors.Add(Resource.Disable);
return;
}
entity.UserName = model.UserName;
entity.TrueName = model.TrueName;
entity.Card = model.Card;
entity.MobileNumber = model.MobileNumber;
entity.PhoneNumber = model.PhoneNumber;
entity.QQ = model.QQ;
entity.EmailAddress = model.EmailAddress;
entity.OtherContact = model.OtherContact;
entity.Province = model.Province;
entity.City = model.City;
entity.Village = model.Village;
entity.Address = model.Address;
entity.State = model.State;
//entity.CreateTime = model.CreateTime;
//entity.CreatePerson = model.CreatePerson;
entity.Sex = model.Sex;
entity.Birthday = model.Birthday;
entity.JoinDate = model.JoinDate;
entity.Marital = model.Marital;
entity.Political = model.Political;
entity.Nationality = model.Nationality;
entity.Native = model.Native;
entity.School = model.School;
entity.Professional = model.Professional;
entity.Degree = model.Degree;
entity.DepId = model.DepId;
entity.PosId = model.PosId;
entity.Expertise = model.Expertise;
entity.Photo = model.Photo;
entity.Attach = model.Attach;
entity.Lead = model.Lead;
entity.LeadName = model.LeadName;
m_Rep.Modify(entity);
DBSession.SysUserMerchantCode.RemoveByEntities(entity.SysUserMerchantCode);
foreach (var item in model.PostedMerchantCodes)
{
entity.SysUserMerchantCode.Add(new SysUserMerchantCode()
{
Id = ResultHelper.NewId, UserId = entity.Id, MerchantCode = item
});
}
}
public ActionResult Edit(string id)
{
ViewBag.Areas = new SelectList(areasBLL.GetList("0"), "Id", "Name");
SysUserModel entity = m_BLL.GetById(id);
return(View(entity));
}
public async Task <string> UpdatePwd(SysUserModel user)
{
if (!await DBOper.SysUser.GetToken(user.access_id, user.access_token))
{
return("请重新登录");
}
return(await DBOper.SysUser.UpdatePwd(user.id, user.login_pwd, user.login_name));
}
public bool Create(ref ValidationErrors errors, SysUserModel model)
{
try
{
SysUser entity = m_Rep.GetById(model.Id);
if (entity != null)
{
errors.Add(Suggestion.PrimaryRepeat);
return(false);
}
entity = new SysUser();
entity.Address = model.Address;
entity.Attach = model.Attach;
entity.Birthday = model.Birthday;
entity.Card = model.Card;
entity.City = model.City;
entity.CreatePerson = model.CreatePerson;
entity.CreateTime = model.CreateTime;
entity.Degree = model.Degree;
entity.DepId = model.DepId;
entity.EmailAddress = model.EmailAddress;
entity.Expertise = model.Expertise;
entity.Id = model.Id;
entity.JobState = model.JobState;
entity.JoinDate = model.JoinDate;
entity.Marital = model.Marital;
entity.MobileNumber = model.MobileNumber;
entity.Nationality = model.Nationality;
entity.Native = model.Native;
entity.OtherContact = model.OtherContact;
entity.Password = model.Password;
entity.PhoneNumber = model.PhoneNumber;
entity.Photo = model.Photo;
entity.Political = model.Political;
entity.PosId = model.PosId;
entity.Professional = model.Professional;
entity.Province = model.Province;
entity.QQ = model.QQ;
entity.School = model.School;
entity.Sex = model.Sex;
entity.State = model.Enable;
entity.TrueName = model.TrueName;
entity.UserName = model.UserName;
entity.Village = model.Village;
if (m_Rep.Create(entity) == 1)
{
return(true);
}
errors.Add(Suggestion.InsertFail);
return(false);
}
catch (Exception ex)
{
errors.Add(ex.Message);
ExceptionHandler.WriteException(ex);
return(false);
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(SysUserModel model)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("INSERT INTO SYS_USER");
sql.AppendLine(" (USER_CODE,");
sql.AppendLine(" USER_NAME,");
sql.AppendLine(" USER_SEX,");
sql.AppendLine(" USER_PWD,");
sql.AppendLine(" USER_POST,");
sql.AppendLine(" USER_EMAIL,");
sql.AppendLine(" USER_TEL,");
sql.AppendLine(" USER_DESC,");
sql.AppendLine(" QR_CODE,");
sql.AppendLine(" IS_ABLED,");
sql.AppendLine(" IS_C_PWD,");
sql.AppendLine(" DEPT_CODE,");
sql.AppendLine(" BOSS_ID,");
sql.AppendLine(" CREATE_USER,");
sql.AppendLine(" LM_USER)");
sql.AppendLine("VALUES");
sql.AppendLine(" ($USER_CODE,");
sql.AppendLine(" $USER_NAME,");
sql.AppendLine(" $USER_SEX,");
sql.AppendLine(" $USER_PWD,");
sql.AppendLine(" $USER_POST,");
sql.AppendLine(" $USER_EMAIL,");
sql.AppendLine(" $USER_TEL,");
sql.AppendLine(" $USER_DESC,");
sql.AppendLine(" $QR_CODE,");
sql.AppendLine(" $IS_ABLED,");
sql.AppendLine(" $IS_C_PWD,");
sql.AppendLine(" $DEPT_CODE,");
sql.AppendLine(" $BOSS_ID,");
sql.AppendLine(" $CREATE_USER,");
sql.AppendLine(" $LM_USER)");
SQLParameter[] parms =
{
new SQLParameter("USER_CODE", typeof(string), model.USER_CODE),
new SQLParameter("USER_NAME", typeof(string), model.USER_NAME),
new SQLParameter("USER_SEX", typeof(int), model.USER_SEX),
new SQLParameter("USER_PWD", typeof(string), model.USER_PWD),
new SQLParameter("USER_POST", typeof(string), model.USER_POST),
new SQLParameter("USER_EMAIL", typeof(string), model.USER_EMAIL),
new SQLParameter("USER_TEL", typeof(string), model.USER_TEL),
new SQLParameter("USER_DESC", typeof(string), model.USER_DESC),
new SQLParameter("QR_CODE", typeof(string), model.QR_CODE),
new SQLParameter("IS_ABLED", typeof(int), model.IS_ABLED),
new SQLParameter("IS_C_PWD", typeof(int), model.IS_C_PWD),
new SQLParameter("DEPT_CODE", typeof(string), model.DEPT_CODE),
new SQLParameter("BOSS_ID", typeof(string), model.BOSS_ID),
new SQLParameter("CREATE_USER", typeof(string), model.CREATE_USER),
new SQLParameter("LM_USER", typeof(string), model.LM_USER)
};
int result = DB.CustomExecuteWithReturn(new SQLParamCondition(sql.ToString(), parms));
return(result);
}
/// <summary>
/// app注册
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public string RegUser(SysUserModel user, out string message)
{
message = string.Empty;
if (null == user)
{
return(null);
}
//1.判断当前用户在A01表是否存在记录
List <A01> a01 = DBSession.IA01DAL.Select(s => s.A0177.Equals(user.user_identify));
if (a01 == null || a01.Count <= 0)
{
message = "当前注册用户非系统工人，系统拒绝注册！";
return(null);
}
//2.判断当前用户是否注册过
List <T_User> lu = Select(s => s.user_identify.Equals(user.user_identify));
if (null != lu && lu.Count > 0)
{
message = "注册失败，当前身份证已注册过！";
return(null);
}
//3.判断登录名是否被占用
List <T_User> au = Select(s => s.login_name.Equals(user.login_name));
if (au != null && au.Count > 0)
{
message = "当前登录名已被占用，请重新设置！";
return(null);
}
//4.构建用户对象
T_User t_user = new T_User()
{
user_name = user.user_name,
login_name = user.login_name,
user_pwd = EncryptHelper.Md5Encryption(user.user_password),
user_identify = user.user_identify,
user_phone = user.user_phone,
user_sex = "男",
user_type = "01", //默认注册农民工
user_guid = EncryptHelper.CreateGuidValue(),
reg_from = 1 //接口默认注册来源为APP
};
int mark = Add(t_user);
//5.将人员注册到具体单位下面
DBSession.IT_Org_UserDAL.Add(new T_Org_User()
{
user_id = t_user.user_id, UnitID = a01[0].UnitID
});
if (mark > 0)
{
return(t_user.user_guid);
}
return(null);
}
