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));
}
/// <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);
}
public static bool Add(Model.Dept deptModel, Model.DeptAccount deptAccountModel)
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("_deptId", deptModel.deptId);
parameters.Add("_deptNO", deptModel.deptNO);
parameters.Add("_deptName", deptModel.deptName);
parameters.Add("_deptState", deptModel.deptState);
parameters.Add("_preDeptId", deptModel.preDeptId);
parameters.Add("_deptAccountId", deptAccountModel.deptAccountId);
parameters.Add("_deptAccount", deptAccountModel.deptAccount);
parameters.Add("_deptPsw", deptAccountModel.deptPsw);
parameters.Add("_crUsrId", deptAccountModel.crUsrId);
parameters.Add("_crdt", deptAccountModel.crdt);
parameters.Add("_updt", deptAccountModel.updt);
parameters.Add("_upUsrId", deptAccountModel.upUsrId);
parameters.Add("isErr", dbType: DbType.Int32, direction: ParameterDirection.Output);
/*调用存储过程进行事务处理*/
mysql.ExcuteNonQuery <Model.Dept>(DapperMySQLHelper.ConnectionString, "SP_ADD_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);
}
