public JsonResult SaveBlackList(ParkBlacklist model) { try { model.PlateNumber = model.PlateNumber.ToPlateNo(); if (string.IsNullOrWhiteSpace(model.RecordID)) { bool result = ParkBlacklistServices.Add(model); if (!result) { throw new MyException("保存失败"); } } else { bool result = ParkBlacklistServices.Update(model); if (!result) { throw new MyException("保存失败"); } } return(Json(MyResult.Success())); } catch (MyException ex) { return(Json(MyResult.Error(ex.Message))); } catch (Exception ex) { ExceptionsServices.AddExceptions(ex, "保存黑名单信息失败"); return(Json(MyResult.Error("保存失败"))); } }
public static bool Update(ParkBlacklist model) { if (model == null) { throw new ArgumentNullException("model"); } IParkBlacklist factory = ParkBlacklistFactory.GetFactory(); ParkBlacklist dbModel = factory.Query(model.PKID, model.PlateNumber); if (dbModel != null && dbModel.RecordID != model.RecordID) { throw new MyException("当前车场的黑名单中已存在该车牌了"); } bool result = factory.Update(model); if (result) { OperateLogServices.AddOperateLog <ParkBlacklist>(model, OperateType.Update); } return(result); }
public static bool Add(ParkBlacklist model) { if (model == null) { throw new ArgumentNullException("model"); } model.RecordID = GuidGenerator.GetGuid().ToString(); IParkBlacklist factory = ParkBlacklistFactory.GetFactory(); ParkBlacklist dbModel = factory.Query(model.PKID, model.PlateNumber); if (dbModel != null) { throw new MyException("当前车场的黑名单中已存在该车牌了"); } bool result = factory.Add(model); if (result) { OperateLogServices.AddOperateLog <ParkBlacklist>(model, OperateType.Add); } return(result); }
public bool Update(ParkBlacklist model) { using (DbOperator dbOperator = ConnectionManager.CreateConnection()) { model.DataStatus = DataStatus.Normal; model.LastUpdateTime = DateTime.Now; model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag; StringBuilder strSql = new StringBuilder(); strSql.Append("update ParkBlacklist set PKID=@PKID,PlateNumber=@PlateNumber,Remark=@Remark,Status=@Status"); strSql.Append(",LastUpdateTime=@LastUpdateTime,HaveUpdate=@HaveUpdate where RecordID=@RecordID"); dbOperator.ClearParameters(); dbOperator.AddParameter("RecordID", model.RecordID); dbOperator.AddParameter("PKID", model.PKID); dbOperator.AddParameter("PlateNumber", model.PlateNumber); dbOperator.AddParameter("Remark", model.Remark); dbOperator.AddParameter("Status", (int)model.Status); dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime); dbOperator.AddParameter("HaveUpdate", model.HaveUpdate); return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0); } }
public bool Add(ParkBlacklist model) { using (DbOperator dbOperator = ConnectionManager.CreateConnection()) { model.DataStatus = DataStatus.Normal; model.LastUpdateTime = DateTime.Now; model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ParkBlacklist(RecordID,PKID,PlateNumber,Remark,Status,LastUpdateTime,HaveUpdate,DataStatus)"); strSql.Append(" values(@RecordID,@PKID,@PlateNumber,@Remark,@Status,@LastUpdateTime,@HaveUpdate,@DataStatus)"); dbOperator.ClearParameters(); dbOperator.AddParameter("RecordID", model.RecordID); dbOperator.AddParameter("PKID", model.PKID); dbOperator.AddParameter("PlateNumber", model.PlateNumber); dbOperator.AddParameter("Remark", model.Remark); dbOperator.AddParameter("Status", (int)model.Status); dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime); dbOperator.AddParameter("HaveUpdate", model.HaveUpdate); dbOperator.AddParameter("DataStatus", (int)model.DataStatus); return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0); } }