public static bool Add(ParkDerateConfig model)
{
if (model == null)
{
throw new ArgumentNullException("model");
}
model.RecordID = GuidGenerator.GetGuidString();
IParkDerateConfig factory = ParkDerateConfigFactory.GetFactory();
List <ParkDerateConfig> configs = factory.QueryByParkingId(model.PKID);
configs = configs.Where(p => (p.ConsumeStartAmount <= model.ConsumeStartAmount && p.ConsumeEndAmount >= model.ConsumeStartAmount) ||
(p.ConsumeStartAmount <= model.ConsumeEndAmount && p.ConsumeEndAmount >= model.ConsumeEndAmount)).ToList();
if (configs.Count > 0)
{
throw new MyException("消费金额重复");
}
bool result = factory.Add(model);
if (result)
{
OperateLogServices.AddOperateLog <ParkDerateConfig>(model, OperateType.Add);
}
return(result);
}
public JsonResult SaveDerateConfig(ParkDerateConfig model)
{
try
{
if (model.ConsumeStartAmount < 0 || model.ConsumeEndAmount < 0)
{
throw new MyException("消费开始金额或结束金额格式不正确");
}
if (model.ConsumeStartAmount >= model.ConsumeEndAmount)
{
throw new MyException("消费开始金额不能大于消费结束金额");
}
if (model.DerateValue < 0)
{
throw new MyException("消费减免值格式不正确");
}
if (!string.IsNullOrWhiteSpace(model.RecordID))
{
bool result = ParkDerateConfigServices.Update(model);
if (!result)
{
throw new MyException("修改车场优免配置失败");
}
}
else
{
bool result = ParkDerateConfigServices.Add(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 bool Update(ParkDerateConfig model)
{
using (DbOperator dbOperator = ConnectionManager.CreateConnection())
{
model.LastUpdateTime = DateTime.Now;
model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag;
StringBuilder strSql = new StringBuilder();
strSql.Append("update ParkDerateConfig set ConsumeStartAmount=@ConsumeStartAmount,ConsumeEndAmount=@ConsumeEndAmount,DerateType=@DerateType,DerateValue=@DerateValue,LastUpdateTime=@LastUpdateTime,HaveUpdate=@HaveUpdate ");
strSql.Append(" where RecordID=@RecordID");
dbOperator.ClearParameters();
dbOperator.AddParameter("RecordID", model.RecordID);
dbOperator.AddParameter("ConsumeStartAmount", model.ConsumeStartAmount);
dbOperator.AddParameter("ConsumeEndAmount", model.ConsumeEndAmount);
dbOperator.AddParameter("DerateType", model.DerateType);
dbOperator.AddParameter("DerateValue", model.DerateValue);
dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime);
dbOperator.AddParameter("HaveUpdate", model.HaveUpdate);
return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0);
}
}
public bool Add(ParkDerateConfig 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 ParkDerateConfig(RecordID,PKID,ConsumeStartAmount,ConsumeEndAmount,DerateType,DerateValue,LastUpdateTime,HaveUpdate,DataStatus)");
strSql.Append(" values(@RecordID,@PKID,@ConsumeStartAmount,@ConsumeEndAmount,@DerateType,@DerateValue,@LastUpdateTime,@HaveUpdate,@DataStatus)");
dbOperator.ClearParameters();
dbOperator.AddParameter("RecordID", model.RecordID);
dbOperator.AddParameter("PKID", model.PKID);
dbOperator.AddParameter("ConsumeStartAmount", model.ConsumeStartAmount);
dbOperator.AddParameter("ConsumeEndAmount", model.ConsumeEndAmount);
dbOperator.AddParameter("DerateType", model.DerateType);
dbOperator.AddParameter("DerateValue", model.DerateValue);
dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime);
dbOperator.AddParameter("HaveUpdate", model.HaveUpdate);
dbOperator.AddParameter("DataStatus", (int)model.DataStatus);
return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0);
}
}
