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