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