/// <summary> /// 新增帐号 /// </summary> /// <param name="data"></param> /// <param name="nOpStaffId"></param> /// <param name="strOpStaffName"></param> /// <param name="strErrText"></param> /// <returns></returns> public long InsertAccount(Account data, long nOpStaffId, string strOpStaffName, out string strErrText) { //创建存储过程参数 SqlParameter[] Params = { MakeParam(ID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Output, (object)data.Id), MakeParam(NAME_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.Name), MakeParam(PASSWORD_PARAM, SqlDbType.NVarChar, 50, ParameterDirection.Input, (object)data.Password), MakeParam(ACCOUNTTYPE_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.AccountType), MakeParam(ORGANID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.OrganId), MakeParam(STAFFID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.StaffId), MakeParam(STAFFNAME_PARAM, SqlDbType.NVarChar, 50, ParameterDirection.Input, (object)data.StaffName), MakeParam(OPSTAFFID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)nOpStaffId), MakeParam(OPSTAFFNAME_PARAM, SqlDbType.NVarChar, 50, ParameterDirection.Input, (object)strOpStaffName), }; SqlParameterCollection outParams; if (Execute("InsertAccount", Params, out outParams, out strErrText) < 0) { return 0; } else { return (long)outParams[ID_PARAM].Value; } }
/// <summary> /// 新增帐号 /// </summary> /// <param name="data"></param> /// <param name="nOpStaffId"></param> /// <param name="strOpStaffName"></param> /// <param name="strErrText"></param> /// <returns></returns> public long InsertAccount(Account data, long nOpStaffId, string strOpStaffName, out string strErrText) { long nId = 0; try { //生成登录密码MD5码,密码默认为123456 data.Password = Utils.GetMD5Hash(data.Name + "@" + "123456"); using (TransactionScope transScope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0))) { using (AuthenticateDAO dao = new AuthenticateDAO()) { nId = dao.InsertAccount(data, nOpStaffId, strOpStaffName, out strErrText); if (nId <= 0) return 0; } transScope.Complete(); } return nId; } catch (Exception e) { strErrText = e.Message; return 0; } }
/// <summary> /// 新增登录日志记录 /// </summary> /// <param name="data">登录帐号数据集</param> /// <param name="strErrText">出错信息</param> /// <returns>成功返回True,否则返回False</returns> public bool InsertLoginLog(Account data, long nOpStaffId, string strOpStaffName, out string strErrText) { //创建存储过程参数 SqlParameter[] Params = { MakeParam(ORGANID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.OrganId), MakeParam(ORGANNAME_PARAM, SqlDbType.NVarChar, 50, ParameterDirection.Input, (object)data.OrganFullName), MakeParam(STAFFID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.StaffId), MakeParam(STAFFNAME_PARAM, SqlDbType.NVarChar, 50, ParameterDirection.Input, (object)data.StaffName), MakeParam(HOSTIP_PARAM, SqlDbType.NVarChar, 30, ParameterDirection.Input, (object)string.Empty), MakeParam(HOSTNAME_PARAM, SqlDbType.NVarChar, 50, ParameterDirection.Input, (object)string.Empty), MakeParam(OPSTAFFID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)nOpStaffId), MakeParam(OPSTAFFNAME_PARAM, SqlDbType.NVarChar, 50, ParameterDirection.Input, (object)strOpStaffName), }; if (Execute("InsertLoginLog", Params, out strErrText) < 0) return false; else return true; }
/// <summary> /// 新增帐号 /// </summary> /// <param name="data"></param> /// <param name="nOpStaffId"></param> /// <param name="strOpStaffName"></param> /// <param name="strErrText"></param> /// <returns></returns> public long InsertAccount(Account data, long nOpStaffId, string strOpStaffName, out string strErrText) { AuthenticateRule rule = new AuthenticateRule(); return rule.InsertAccount(data, nOpStaffId, strOpStaffName, out strErrText); }
/// <summary> /// 修改帐号 /// </summary> /// <param name="data"></param> /// <param name="nOpStaffId"></param> /// <param name="strOpStaffName"></param> /// <param name="strErrText"></param> /// <returns></returns> public bool UpdateAccount(Account data, long nOpStaffId, string strOpStaffName, out string strErrText) { try { using (TransactionScope transScope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0))) { using (AuthenticateDAO dao = new AuthenticateDAO()) { if (!dao.UpdateAccount(data, nOpStaffId, strOpStaffName, out strErrText)) return false; } transScope.Complete(); } return true; } catch (Exception e) { strErrText = e.Message; return false; } }
public ActionResult NewAccount(AccountViewModel model) { if (ModelState.IsValid) { if (model.AccountType == InnoSoft.LS.Resources.Options.Staff) { if (model.OrganId == 0) { return Json(InnoSoft.LS.Resources.Strings.NotSelectedOrgan); } if (model.StaffId == 0) { return Json(InnoSoft.LS.Resources.Strings.NotSelectedStaff); } } else { if (model.CustomerId == 0) { return Json(InnoSoft.LS.Resources.Strings.NotSelectedCustomer); } if (model.ContactName.Trim() == string.Empty) { return Json(InnoSoft.LS.Resources.Strings.NotEnterContactName); } } //创建数据 Account data = new Account(); data.Name = model.Name; data.AccountType = model.AccountType; data.OrganId = model.AccountType == InnoSoft.LS.Resources.Options.Staff ? model.OrganId : model.CustomerId; data.StaffId = model.AccountType == InnoSoft.LS.Resources.Options.Staff ? model.StaffId : 0; data.StaffName = model.AccountType == InnoSoft.LS.Resources.Options.Staff ? string.Empty : model.ContactName; //保存数据 string strErrText; AuthenticateSystem auth = new AuthenticateSystem(); if (auth.InsertAccount(data, LoginAccountId, LoginStaffName, out strErrText) > 0) { return Json(string.Empty); } else { return Json(strErrText); } } return View(model); }
/// <summary> /// 修改帐号 /// </summary> /// <param name="data"></param> /// <param name="nOpStaffId"></param> /// <param name="strOpStaffName"></param> /// <param name="strErrText"></param> /// <returns></returns> public bool UpdateAccount(Account data, long nOpStaffId, string strOpStaffName, out string strErrText) { //创建存储过程参数 SqlParameter[] Params = { MakeParam(ID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.Id), MakeParam(NAME_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.Name), MakeParam(PASSWORD_PARAM, SqlDbType.NVarChar, 50, ParameterDirection.Input, (object)data.Password), MakeParam(ACCOUNTTYPE_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.AccountType), MakeParam(ORGANID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.OrganId), MakeParam(STAFFID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.StaffId), MakeParam(STAFFNAME_PARAM, SqlDbType.NVarChar, 50, ParameterDirection.Input, (object)data.StaffName), MakeParam(ISCANCEL_PARAM, SqlDbType.Bit, 1, ParameterDirection.Input, (object)data.IsCancel), MakeParam(OPSTAFFID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)nOpStaffId), MakeParam(OPSTAFFNAME_PARAM, SqlDbType.NVarChar, 50, ParameterDirection.Input, (object)strOpStaffName), }; if (Execute("UpdateAccount", Params, out strErrText) >= 0) return true; else return false; }