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);
}
