public static bool Add(string strUsrPhoneNum, string strUsrAccount, string strPassWord, string strUserName, string strUsrDeptId, int usrState, string strOperUserId, int iUsrType, int?iUsrVerifyState, List <string> strRoleIdList) { string strUsrId = Guid.NewGuid().ToString(); Model.Usr usrModel = new Model.Usr() { usrId = strUsrId, usrPhoneNum = strUsrPhoneNum, usrAccount = strUsrAccount, usrPsw = strPassWord, usrName = strUserName, usrDeptId = strUsrDeptId, /*默认0为未审核通过,1为审核通过*/ usrVerifyState = iUsrVerifyState, /*默认1为部门账号,2为正式人员,3为试用人员,4为普通用户*/ usrType = iUsrType, /*用户数据状态0为标识删除,1为新增,2为修改*/ usrState = 1, crdt = DateTime.Now, crUsrId = strOperUserId, updt = DateTime.Now, upUsrId = strOperUserId }; UserRole.Set(Guid.NewGuid().ToString(), strUsrId, strRoleIdList, 1, strOperUserId); return(Repository.Usr.Add(usrModel)); }
/// <summary> /// 增加一条数据 /// </summary> public static bool Add(Model.Usr model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into usr("); strSql.Append("usrId,usrPhoneNum,usrAccount,usrPsw,usrName,usrDeptId,usrVerifyState,usrType,usrState,crdt,crUsrId,updt,upUsrId)"); strSql.Append(" values ("); strSql.Append("?usrId,?usrPhoneNum,?usrAccount,?usrPsw,?usrName,?usrDeptId,?usrVerifyState,?usrType,?usrState,?crdt,?crUsrId,?updt,?upUsrId)"); DynamicParameters parameters = new DynamicParameters(); parameters.Add("?usrId", model.usrId); parameters.Add("?usrPhoneNum", model.usrPhoneNum); parameters.Add("?usrAccount", model.usrAccount); parameters.Add("?usrPsw", model.usrPsw); parameters.Add("?usrName", model.usrName); parameters.Add("?usrDeptId", model.usrDeptId); parameters.Add("?usrVerifyState", model.usrVerifyState); parameters.Add("?usrType", model.usrType); parameters.Add("?usrState", model.usrState); parameters.Add("?crdt", model.crdt); parameters.Add("?crUsrId", model.crUsrId); parameters.Add("?updt", model.updt); parameters.Add("?upUsrId", model.upUsrId); int rows = mysql.ExcuteNonQuery <Model.Usr>(DapperMySQLHelper.ConnectionString, strSql.ToString(), parameters, false); return(rows > 0); }
public static bool Update(string usrId, string strDeptId, string strPreDeptId, string strDeptName, string strDeptNO, string strDeptAccount, string strDeptPsw) { Model.Dept deptModel = new Model.Dept() { deptAccount = strDeptAccount, deptId = strDeptId, deptName = strDeptName, deptNO = strDeptNO, preDeptId = strPreDeptId, updt = DateTime.Now, upUsrId = usrId }; Model.DeptAccount deptAccountModel = new Model.DeptAccount() { deptId = strDeptId, deptAccount = strDeptAccount, deptAccountId = Guid.NewGuid().ToString(), deptPsw = strDeptPsw, updt = DateTime.Now, upUsrId = usrId }; Model.Usr usrModel = new Model.Usr() { updt = DateTime.Now, upUsrId = strDeptId, usrAccount = strDeptAccount, usrName = strDeptName, usrDeptId = strDeptId, usrPsw = strDeptPsw }; return(Repository.Dept.Update(deptModel, deptAccountModel, usrModel)); }
public static bool Login(string strUserName, string strPassWord, out Model.Usr usrInfoModel) { usrInfoModel = Repository.Usr.GetModel(strUserName, strPassWord); if (usrInfoModel != null) { usrInfoModel.UsrRoleLst = UserRole.GetModelByUserId(usrInfoModel.usrId); } return(null != usrInfoModel); }
public static bool Update(Model.Usr model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update usr set "); strSql.Append("usrPhoneNum=?usrPhoneNum,"); strSql.Append("usrAccount=?usrAccount,"); if (!string.IsNullOrEmpty(model.usrPsw)) { strSql.Append("usrPsw=?usrPsw,"); } ; strSql.Append("usrName=?usrName,"); strSql.Append("usrDeptId=?usrDeptId,"); strSql.Append("usrVerifyState=?usrVerifyState,"); strSql.Append("usrType=?usrType,"); strSql.Append("usrState=?usrState,"); strSql.Append("updt=?updt,"); strSql.Append("upUsrId=?upUsrId"); strSql.Append(" where usrId=?usrId "); DynamicParameters parameters = new DynamicParameters(); parameters.Add("?usrId", model.usrId); parameters.Add("?usrPhoneNum", model.usrPhoneNum); parameters.Add("?usrAccount", model.usrAccount); if (!string.IsNullOrEmpty(model.usrPsw)) { parameters.Add("?usrPsw", model.usrPsw); } ; parameters.Add("?usrName", model.usrName); parameters.Add("?usrDeptId", model.usrDeptId); parameters.Add("?usrVerifyState", model.usrVerifyState); parameters.Add("?usrType", model.usrType); parameters.Add("?usrState", model.usrState); parameters.Add("?updt", model.updt); parameters.Add("?upUsrId", model.upUsrId); int rows = mysql.ExcuteNonQuery <Model.Usr>(DapperMySQLHelper.ConnectionString, strSql.ToString(), parameters, false); return(rows > 0); }
public static bool Update(string strUsrId, string strUsrPhoneNum, string strUsrAccount, string strUsrPsw, string strUsrName, string strUsrDeptId, int usrState, string strUpUsrId, int?_usrType, int?_usrVerifyState, List <string> strRoleIdList) { Model.Usr usrModel = new Model.Usr() { usrId = strUsrId, usrPhoneNum = strUsrPhoneNum, usrAccount = strUsrAccount, usrPsw = strUsrPsw, usrName = strUsrName, usrDeptId = strUsrDeptId, usrState = usrState, updt = DateTime.Now, upUsrId = strUpUsrId, usrType = _usrType, usrVerifyState = _usrVerifyState }; UserRole.Set(Guid.NewGuid().ToString(), strUsrId, strRoleIdList, 1, strUpUsrId); return(Repository.Usr.Update(usrModel)); }
/// <summary> /// 更新一条数据 /// </summary> public static bool Update(Model.Dept deptModel, Model.DeptAccount deptAccountModel, Model.Usr usrModel) { DynamicParameters parameters = new DynamicParameters(); parameters.Add("_deptId", deptModel.deptId); parameters.Add("_deptName", deptModel.deptName); parameters.Add("_deptAccount", deptModel.deptAccount); parameters.Add("_deptPsw", usrModel.usrPsw); parameters.Add("_preDeptId", deptModel.preDeptId); parameters.Add("_updt", deptModel.updt); parameters.Add("_upUsrId", deptModel.upUsrId); parameters.Add("isErr", dbType: DbType.Int32, direction: ParameterDirection.Output); mysql.ExcuteNonQuery <Model.Dept>(DapperMySQLHelper.ConnectionString, "SP_UPDATE_DEPT_ACCOUNT", parameters, true); return(parameters.Get <int>("isErr") == 0); }
/// <summary> /// 新增部门 /// </summary> /// <param name="usrId">当前登录用户ID</param> /// <param name="strPreDeptId">上级部门ID</param> /// <param name="strDeptName">当前部门名称</param> /// <param name="strDeptAccount">部门账号</param> /// <param name="strDeptPsw">部门账号的密码</param> /// <param name="tips">输出提示</param> /// <returns></returns> public static bool Add(string usrId, string strPreDeptId, string strDeptName, string strDeptAccount, string strDeptPsw, out string tips) { if (!Usr.CheckAccount(strDeptAccount)) { tips = ResponseMessageTips.MSG_DEPT_ACCOUNT_IS_EXIST; return(false); } var preModel = Repository.Dept.GetModel(strPreDeptId); string strdeptNO = "1" + "0".PadLeft(3, '0'); if (preModel != null) { //1000 //1000 000 strdeptNO = preModel.deptNO + "0".PadLeft(3, '0'); } var deptNO = Repository.Dept.GetMaxDeptNumByPreDeptId(strPreDeptId); if (null != deptNO) { long.TryParse(deptNO, out long maxNO); strdeptNO = (maxNO + 1).ToString(); } string strDeptId = Guid.NewGuid().ToString(); Model.Dept deptModel = new Model.Dept() { crdt = DateTime.Now, crUsrId = usrId, deptId = strDeptId, deptName = strDeptName, deptNO = strdeptNO, deptState = 1, preDeptId = strPreDeptId, updt = DateTime.Now, upUsrId = usrId }; Model.DeptAccount deptAccountModel = new Model.DeptAccount() { crdt = DateTime.Now, crUsrId = usrId, deptId = strDeptId, deptAccount = strDeptAccount, deptAccountId = Guid.NewGuid().ToString(), deptPsw = strDeptPsw, updt = DateTime.Now, upUsrId = usrId }; Model.Usr usrModel = new Model.Usr() { usrId = Guid.NewGuid().ToString(), crdt = DateTime.Now, crUsrId = usrId, updt = DateTime.Now, upUsrId = usrId, usrAccount = strDeptAccount, usrName = strDeptName, usrDeptId = strDeptId, usrPhoneNum = strDeptAccount, usrPsw = strDeptPsw, usrState = 1, usrType = 1, usrVerifyState = 1 }; UserRole.Set(Guid.NewGuid().ToString(), usrModel.usrId, new List <string>() { }, 1, usrId); bool result = Repository.Dept.Add(deptModel, deptAccountModel); tips = result ? ResponseMessageTips.MSG_DEPT_ADD_SUCCESS : ResponseMessageTips.MSG_DEPT_ADD_FAIL; return(result); }