public JsonResult SavePassRemark()
{
try
{
BasePassRemark model = new BasePassRemark();
model.PKID = Request.Params["ParkingID"];
model.Remark = Request.Params["Remark"];
model.PassType = (PassRemarkType)int.Parse(Request.Params["PassType"].ToString());
bool result = PassRemarkServices.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 static bool Update(BasePassRemark model)
{
if (model == null)
{
throw new ArgumentNullException("model");
}
IPassRemark factory = PassRemarkFactory.GetFactory();
bool result = factory.Update(model);
if (result)
{
OperateLogServices.AddOperateLog <BasePassRemark>(model, OperateType.Update);
}
return(result);
}
public static bool Add(BasePassRemark model)
{
if (model == null)
{
throw new ArgumentNullException("model");
}
model.RecordID = GuidGenerator.GetGuidString();
IPassRemark factory = PassRemarkFactory.GetFactory();
bool result = factory.Add(model);
if (result)
{
OperateLogServices.AddOperateLog <BasePassRemark>(model, OperateType.Add);
}
return(result);
}
public bool Update(BasePassRemark model)
{
using (DbOperator dbOperator = ConnectionManager.CreateConnection())
{
model.LastUpdateTime = DateTime.Now;
model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag;
StringBuilder strSql = new StringBuilder();
strSql.Append("update BasePassRemark set PassType=@PassType,Remark=@Remark,LastUpdateTime=@LastUpdateTime,HaveUpdate=@HaveUpdate");
strSql.Append(" where RecordID=@RecordID");
dbOperator.ClearParameters();
dbOperator.AddParameter("RecordID", model.RecordID);
dbOperator.AddParameter("PassType", (int)model.PassType);
dbOperator.AddParameter("Remark", model.Remark);
dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime);
dbOperator.AddParameter("HaveUpdate", model.HaveUpdate);
return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0);
}
}
public bool Add(BasePassRemark 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 BasePassRemark(RecordID,PassType,Remark,PKID,LastUpdateTime,HaveUpdate,DataStatus)");
strSql.Append(" values(@RecordID,@PassType,@Remark,@PKID,@LastUpdateTime,@HaveUpdate,@DataStatus)");
dbOperator.ClearParameters();
dbOperator.AddParameter("RecordID", model.RecordID);
dbOperator.AddParameter("PassType", (int)model.PassType);
dbOperator.AddParameter("Remark", model.Remark);
dbOperator.AddParameter("PKID", model.PKID);
dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime);
dbOperator.AddParameter("HaveUpdate", model.HaveUpdate);
dbOperator.AddParameter("DataStatus", (int)model.DataStatus);
return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0);
}
}
