public bool Update(ParkCarModel model) { model.LastUpdateTime = DateTime.Now; model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag; StringBuilder strSql = new StringBuilder(); strSql.Append("update ParkCarModel set CarModelName=@CarModelName,IsDefault=@IsDefault,LastUpdateTime=@LastUpdateTime,HaveUpdate=@HaveUpdate,MaxUseMoney=@MaxUseMoney,IsNaturalDay=@IsNaturalDay,PlateColor=@PlateColor "); strSql.Append(",DayMaxMoney=@DayMaxMoney,NightMaxMoney=@NightMaxMoney,DayStartTime=@DayStartTime,DayEndTime=@DayEndTime,NightStartTime=@NightStartTime,NightEndTime=@NightEndTime where CarModelID=@CarModelID"); using (DbOperator dbOperator = ConnectionManager.CreateConnection()) { UpdateDefault(model, dbOperator); dbOperator.ClearParameters(); dbOperator.AddParameter("CarModelName", model.CarModelName); dbOperator.AddParameter("IsDefault", (int)model.IsDefault); dbOperator.AddParameter("CarModelID", model.CarModelID); dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime); dbOperator.AddParameter("HaveUpdate", model.HaveUpdate); dbOperator.AddParameter("MaxUseMoney", model.MaxUseMoney); dbOperator.AddParameter("IsNaturalDay", model.IsNaturalDay); dbOperator.AddParameter("PlateColor", model.PlateColor); dbOperator.AddParameter("DayMaxMoney", model.DayMaxMoney); dbOperator.AddParameter("NightMaxMoney", model.NightMaxMoney); dbOperator.AddParameter("DayStartTime", model.DayStartTime); dbOperator.AddParameter("DayEndTime", model.DayEndTime); dbOperator.AddParameter("NightStartTime", model.NightStartTime); dbOperator.AddParameter("NightEndTime", model.NightEndTime); return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0); } }
public ParkFeeRuleView ToParkFeeRuleView(ParkFeeRule rule, List <ParkArea> areas, List <ParkCarType> carTyeps, List <ParkCarModel> carModels) { this.AreaID = rule.AreaID; ParkArea area = areas.FirstOrDefault(p => p.AreaID == rule.AreaID); if (area != null) { this.AreaName = area.AreaName; } this.CarTypeID = rule.CarTypeID; ParkCarType card = carTyeps.FirstOrDefault(p => p.CarTypeID == rule.CarTypeID); if (card != null) { this.CarTypeName = card.CarTypeName; } this.CarModelID = rule.CarModelID; ParkCarModel carModel = carModels.FirstOrDefault(p => p.CarModelID == rule.CarModelID); if (carModel != null) { this.CarModelName = carModel.CarModelName; } this.RuleName = rule.RuleName; this.FeeRuleID = rule.FeeRuleID; this.FeeType = rule.FeeType; this.RuleText = rule.RuleText; this.FeeTypeName = ((FeeType)rule.FeeType).GetDescription(); this.LastUpdateTime = rule.LastUpdateTime; this.IsOffline = rule.IsOffline; FillParkFeeRuleDetail(rule.ParkFeeRuleDetails); return(this); }
public bool Add(ParkCarModel model) { if (model == null) { return(false); } using (DbOperator dbOperator = ConnectionManager.CreateConnection()) { UpdateDefault(model, dbOperator); return(Add(new List <ParkCarModel>() { model }, dbOperator)); } }
public static ParkGrant GenerateParkGrantModel(string PKID, EmployeePlate plate, BaseCard card, string pkLot, string carModelId, string carTypeId, string AreaIDS, string GateID) { ParkGrant model = new ParkGrant(); model.PKID = PKID; model.CardID = card.CardID; model.PlateID = plate.PlateID; model.PlateNo = plate.PlateNo; model.PKLot = pkLot; model.PKLotNum = 0; ParkCarModel carModel = ParkCarModelServices.QueryByRecordId(carModelId); if (carModel == null) { throw new MyException("选择的车型不存在"); } model.CarModelID = carModel.CarModelID; ParkCarType carType = ParkCarTypeServices.QueryParkCarTypeByRecordId(carTypeId); if (carType == null) { throw new MyException("选择的车类不存在"); } model.CarTypeID = carType.CarTypeID; if (string.IsNullOrWhiteSpace(AreaIDS)) { throw new MyException("获取选择的车场区域失败"); } model.AreaIDS = AreaIDS == "-1" ? string.Empty : AreaIDS; if (string.IsNullOrWhiteSpace(GateID)) { throw new MyException("获取选择的车场通道失败"); } model.GateID = GateID == "-1" ? string.Empty : GateID; return(model); }
public static bool Add(ParkCarModel model) { if (model == null) { throw new ArgumentNullException("model"); } model.CarModelName = model.CarModelName.Trim(); model.CarModelID = GuidGenerator.GetGuidString(); IParkCarModel factory = ParkCarModelFactory.GetFactory(); List <ParkCarModel> carModels = factory.QueryByParkingId(model.PKID); if (carModels.Count(p => p.CarModelName == model.CarModelName) != 0) { throw new MyException("车型名称已存在,请更改名称"); } bool result = factory.Add(model); if (result) { OperateLogServices.AddOperateLog <ParkCarModel>(model, OperateType.Add); } return(result); }
private void UpdateDefault(ParkCarModel model, DbOperator dbOperator) { if (model.IsDefault == YesOrNo.No) { return; } StringBuilder strSql = new StringBuilder(); strSql.Append("update ParkCarModel set IsDefault=@IsDefault,LastUpdateTime=@LastUpdateTime,HaveUpdate=@HaveUpdate,PlateColor=@PlateColor"); strSql.Append(" where PKID=@PKID and IsDefault=@IsDefault1 and CarModelID!=@CarModelID"); dbOperator.ClearParameters(); dbOperator.AddParameter("PKID", model.PKID); dbOperator.AddParameter("CarModelID", model.CarModelID); dbOperator.AddParameter("IsDefault", (int)YesOrNo.No); dbOperator.AddParameter("IsDefault1", (int)YesOrNo.Yes); dbOperator.AddParameter("LastUpdateTime", DateTime.Now); dbOperator.AddParameter("HaveUpdate", SystemDefaultConfig.DataUpdateFlag); dbOperator.AddParameter("PlateColor", model.PlateColor); dbOperator.ExecuteNonQuery(strSql.ToString()); }