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