/// <summary>
/// 修改档案
/// </summary>
/// <param name="model">Model</param>
/// <returns></returns>
public int ModifyInfo(Models.S.User model)
{
try
{
SqlParameter[] param =
{
new SqlParameter("@id", SqlDbType.Int),
new SqlParameter("@realName", SqlDbType.NVarChar, 20),
new SqlParameter("@email", SqlDbType.VarChar, 50),
new SqlParameter("@mobile", SqlDbType.VarChar, 50),
new SqlParameter("@tel", SqlDbType.VarChar, 50)
};
param[0].Value = model.Id;
param[1].Value = model.RealName;
param[2].Value = model.Email;
param[3].Value = model.Mobile;
param[4].Value = model.Tel;
return(SqlHelper.ExecuteNonQuery(DefaultConnection.ConnectionStringByDefaultDB, CommandType.Text, "UPDATE [S_USER] SET U_REALNAME=@realName,U_EMAIL=@email,U_MOBILE=@mobile,U_TEL=@tel,U_UPDATETIME=GETDATE() WHERE U_ID=@id", param));
}
catch (ArgumentNullException ex)
{
logger.Error("调用方法ModifyInfo(Models.S.User model)发生ArgumentNullException", ex);
}
catch (SqlException ex)
{
logger.Error("调用方法ModifyInfo(Models.S.User model)发生SqlException", ex);
}
catch (Exception ex)
{
logger.Error("调用方法ModifyInfo(Models.S.User model)发生Exception", ex);
}
return(-1);
}
/// <summary>
/// 修改档案
/// </summary>
/// <param name="model">Model</param>
/// <returns></returns>
public int ModifyInfo(Models.S.User model)
{
return(dal.ModifyInfo(model));
}