/// <summary>
/// 添加用用户信息
/// </summary>
/// <param name="user"></param>
/// <param name="UserID"></param>
/// <returns></returns>
public bool AddUser(UserInfo user, out int UserID)
{
UserID = 0;
string procName = "OA_SP_SM_User_Add";
LogBuilder log = new LogBuilder();
#region 日志信息
log.Desc = "添加用用户信息";
log.Method = MethodBase.GetCurrentMethod().Name;
log.Path = MethodBase.GetCurrentMethod().DeclaringType.FullName;
log.StroreProcedure = procName;
log.Append("UserInfo", user);
#endregion
try
{
int rowsAffected;
SqlParameter[] parameters = {
new SqlParameter("@UserAccount", SqlDbType.VarChar,50),
new SqlParameter("@Pwd", SqlDbType.VarChar,50),
new SqlParameter("@UserName", SqlDbType.VarChar,50),
new SqlParameter("@DepID", SqlDbType.Int,10),
new SqlParameter("@DutyID", SqlDbType.Int,10),
new SqlParameter("@Email", SqlDbType.VarChar,100),
new SqlParameter("@Remark", SqlDbType.VarChar,200),
new SqlParameter("@Creator", SqlDbType.Int,10),
new SqlParameter("@UserID", SqlDbType.Int,10)
};
parameters[0].Value = user.UserAccount;
parameters[1].Value = user.Pwd;
parameters[2].Value = user.UserName;
parameters[3].Value = user.DepID;
parameters[4].Value = user.DutyID;
parameters[5].Value = user.Email;
parameters[6].Value = user.Remark;
parameters[7].Value = user.Creator;
parameters[8].Direction = ParameterDirection.Output;
Mssql.ExecuteProc(procName, parameters, out rowsAffected);
if (rowsAffected > 0)
{
if (parameters[0] != null)
{
UserID = (int)parameters[8].Value;
log.Append("UserID", UserID, ParamDirection.OUT);
}
}
}
catch (Exception ex)
{
log.Exception = ex.ToString();
log.Error();
}
finally
{
log.Debug();
}
return UserID > 0;
}
/// <summary>
/// 编辑用户信息
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public bool UpdateUser(UserInfo user)
{
string procName = "OA_SP_SM_User_Update";
LogBuilder log = new LogBuilder();
#region 日志信息
log.Desc = "更新职位";
log.Method = MethodBase.GetCurrentMethod().Name;
log.Path = MethodBase.GetCurrentMethod().DeclaringType.FullName;
log.StroreProcedure = procName;
log.Append("UserInfo", user);
#endregion
try
{
int rowsAffected = 0;
SqlParameter[] parameters = {
new SqlParameter("@UserID", SqlDbType.Int,10),
new SqlParameter("@UserName", SqlDbType.VarChar,50),
new SqlParameter("@DepID", SqlDbType.Int,10),
new SqlParameter("@DutyID", SqlDbType.Int,10),
new SqlParameter("@Email", SqlDbType.VarChar,100),
new SqlParameter("@Remark", SqlDbType.VarChar,200),
new SqlParameter("@Modifier", SqlDbType.Int,10)};
parameters[0].Value = user.UserID;
parameters[1].Value = user.UserName;
parameters[2].Value = user.DepID;
parameters[3].Value = user.DutyID;
parameters[4].Value = user.Email;
parameters[5].Value = user.Remark;
parameters[6].Value = user.Creator;
Mssql.ExecuteProc(procName, parameters, out rowsAffected);
if (rowsAffected > 0)
{
return true;
}
}
catch (Exception ex)
{
log.Exception = ex.ToString();
log.Error();
}
finally
{
log.Debug();
}
return false;
}
