/// <summary> /// 检查是否重复 /// </summary> /// <param name="Model.Oil"></param> /// <returns></returns> public static bool CheckRepeat(Model.Oil model) { try { string sql = "select * from Oil where Name = @Name and Id <> @Id"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@Name", model.Name.Trim()), new SqlParameter("@Id", model.Id) }; DataTable temp = DBHelper.ExecuteGetDataTable(CommandType.Text, sql, para); if (temp.Rows.Count > 0) { return(true); } else { return(false); } } catch (Exception ex) { ErrorLog e = new ErrorLog(); e.TargetIds = model.Id.ToString(); e.CodeTag = "CheckRepeat"; e.LogName = "检查是否重复-ForOil"; e.ErrorMsg = ex.Message.ToString(); ErrorLogService.AddErrorLog <Model.Oil>(e, model); return(true); } }
private bool tryPut(ref Model.Oil model, out string errMsg) { errMsg = ""; bool re = false; model.Modifier = this.auth.UserId; model.ModifiedDate = DateTime.Now; if (OilManager.ModifyOilById(ref model, out errMsg)) { re = true; } return(re); }
/// <summary> /// 添加油品 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool AddOil(ref Model.Oil model, out string errMsg) { errMsg = ""; try { model.Name = model.Name.Trim(); model.Description = model.Description.Trim(); SqlParameter[] para = new SqlParameter[] { new SqlParameter("@Name", model.Name), new SqlParameter("@YellowRate", model.YellowRate), new SqlParameter("@RedRate", model.RedRate), new SqlParameter("@Description", model.Description), new SqlParameter("@Creater", model.Creater), new SqlParameter("@CreatedDate", model.CreatedDate), new SqlParameter("@Modifier", model.Modifier), new SqlParameter("@ModifiedDate", model.ModifiedDate), new SqlParameter("@return", SqlDbType.Int) }; para[8].Direction = ParameterDirection.ReturnValue; int i = DBHelper.ExecuteNonQuery(CommandType.StoredProcedure, "proc_OilInsert", para); if (i > 0) { model.Id = int.Parse(para[8].Value.ToString()); EventLog e = new EventLog(); e.TargetIds = para[8].Value.ToString(); e.CodeTag = "AddOil"; e.LogName = "添加油品"; EventLogService.AddEventLog <Model.Oil>(e, model); return(true); } else { errMsg = "添加记录失败,受影响行数为0"; return(false); } } catch (Exception ex) { errMsg = ex.Message; ErrorLog e = new ErrorLog(); e.TargetIds = "0"; e.CodeTag = "AddOil"; e.LogName = "添加油品"; e.ErrorMsg = ex.Message.ToString(); ErrorLogService.AddErrorLog <Model.Oil>(e, model); return(false); } }
/// <summary> /// 根据id修改油品 /// </summary> /// <param name="Model.Oil"></param> /// <returns></returns> public static bool ModifyOilById(ref Model.Oil model, out string errMsg) { errMsg = ""; try { model.Name = model.Name.Trim(); model.Description = model.Description.Trim(); SqlParameter[] para = new SqlParameter[] { new SqlParameter("@Id", model.Id), new SqlParameter("@Name", model.Name), new SqlParameter("@YellowRate", model.YellowRate), new SqlParameter("@RedRate", model.RedRate), new SqlParameter("@Description", model.Description), new SqlParameter("@Modifier", model.Modifier), new SqlParameter("@ModifiedDate", model.ModifiedDate) }; int i = DBHelper.ExecuteNonQuery(CommandType.StoredProcedure, "proc_OilByIdUpdate", para); if (i > 0) { EventLog e = new EventLog(); e.TargetIds = model.Id.ToString(); e.CodeTag = "ModifyOilById"; e.LogName = "修改油品"; EventLogService.AddEventLog <Model.Oil>(e, model); return(true); } else { errMsg = "该记录已被删除,不能修改!"; return(false); } } catch (Exception ex) { errMsg = ex.Message; ErrorLog e = new ErrorLog(); e.TargetIds = model.Id.ToString(); e.CodeTag = "ModifyOilById"; e.LogName = "修改油品"; e.ErrorMsg = ex.Message.ToString(); ErrorLogService.AddErrorLog <Model.Oil>(e, model); return(false); } }
private bool tryValidate(Model.Oil model, out string errMsg) { errMsg = ""; bool re = true; if (model.Name == null || model.Name.Length == 0 || model.Name.Length > 20 || model.Description.Length > 200) { errMsg = "输入数据不合法"; re = false; } if (re && OilManager.CheckRepeat(model)) { errMsg = "不能重复"; re = false; } if (re && model.Modifier != auth.UserId) { errMsg = "登录信息异常,请刷新浏览器以重启应用(APP请退出应用后重新打开)"; re = false; } return(re); }
/// <summary> /// 检查是否重复 /// </summary> /// <param name="Model.Oil"></param> /// <returns></returns> public static bool CheckRepeat(Model.Oil model) { return(OilService.CheckRepeat(model)); }
/// <summary> /// 根据id修改油品 /// </summary> /// <param name="Model.Oil"></param> /// <returns></returns> public static bool ModifyOilById(ref Model.Oil model, out string errMsg) { return(OilService.ModifyOilById(ref model, out errMsg)); }
/// <summary> /// 添加油品 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool AddOil(ref Model.Oil model, out string errMsg) { return(OilService.AddOil(ref model, out errMsg)); }