public bool AddVehicleOnlineAnnualInspectionAgent(VehicleAnnualInspectionAgentModel model, string user)
{
var result = false;
try
{
var oldValue = GetVehicleOnlineAnnualInspectionAgent(model.ServicePid, model.Province, model.City, model.Village);
if (oldValue == null)
{
var pkid = dbScopeManagerConfiguration.Execute
(conn => DalVehicleAnnualInspectionAgent.AddVehicleOnlineAnnualInspectionAgent(conn, model));
result = pkid > 0;
model.PKID = pkid;
}
else if (oldValue.IsDeleted)
{
model.PKID = oldValue.PKID;
result = dbScopeManagerConfiguration.Execute
(conn => DalVehicleAnnualInspectionAgent.UpdateVehicleOnlineAnnualInspectionAgent(conn, model));
}
model.CreateDateTime = DateTime.Now;
model.LastUpdateDateTime = DateTime.Now;
var log = new AnnualInspectionOprLogModel
{
LogType = "VehicleOnlineAnnualInspectionAgent",
IdentityId = $"{model.Province}_{model.City}_{model.Village}",
OperationType = "Add",
OldValue = null,
NewValue = JsonConvert.SerializeObject(model),
Remarks = $"添加{model.Province}_{model.City}_{model.Village},供应商:{model.VenderShortName}," +
$"服务Pid:{model.ServicePid},联系电话:{model.TelNum},联系邮箱:{model.Email} " +
$"的{model.ServiceName}服务",
Operator = user,
};
LoggerManager.InsertLog("AnnualInspectOprLog", log);
}
catch (Exception ex)
{
result = false;
Logger.Error("AddVehicleOnlineAnnualInspectionAgent", ex);
}
return(result);
}
/// <summary>
/// 删除年检代办配置
/// </summary>
/// <param name="carNoPrefix"></param>
/// <param name="telNum"></param>
/// <param name="servicePid"></param>
/// <param name="user"></param>
/// <returns></returns>
public bool DeleteVehicleOnlineAnnualInspectionAgent
(string servicePid, string province, string city, string village, string user)
{
var result = false;
try
{
var oldValue = GetVehicleOnlineAnnualInspectionAgent(servicePid, province, city, village);
if (oldValue != null && !oldValue.IsDeleted)
{
result = dbScopeManagerConfiguration.Execute(conn => DalVehicleAnnualInspectionAgent.DeleteVehicleAnnualInspectionAgent(conn, oldValue.PKID));
if (!result)
{
throw new Exception($"DeleteVehicleOnlineAnnualInspectionAgent,待删除数据{JsonConvert.SerializeObject(oldValue)}");
}
var log = new AnnualInspectionOprLogModel
{
LogType = "VehicleAnnualInspectionAgent",
IdentityId = $"{province}_{city}_{village}",
OperationType = "Delete",
OldValue = JsonConvert.SerializeObject(oldValue),
NewValue = null,
Remarks = $"删除{oldValue.Province}_{oldValue.City}_{oldValue.Village},供应商:{oldValue.VenderShortName}," +
"服务Pid:{model.ServicePid},联系电话:{model.TelNum},联系邮箱:{model.Email}" +
"的{model.ServiceName}服务的年检代办服务",
Operator = user,
};
LoggerManager.InsertLog("AnnualInspectOprLog", log);
}
else
{
result = true;
}
}
catch (Exception ex)
{
result = false;
Logger.Error("DeleteVehicleOnlineAnnualInspectionAgent", ex);
}
return(result);
}
/// <summary>
/// 删除年检代办配置
/// </summary>
/// <param name="carNoPrefix"></param>
/// <param name="telNum"></param>
/// <param name="servicePid"></param>
/// <param name="user"></param>
/// <returns></returns>
public bool DeleteVehicleAnnualInspectionAgent
(string servicePid, string telNum, string carNoPrefix, string user)
{
var result = false;
try
{
var oldValue = GetVehicleAnnualInspectionAgent(servicePid, telNum, carNoPrefix);
if (oldValue != null && !oldValue.IsDeleted)
{
result = dbScopeManagerConfiguration.Execute(conn => DalVehicleAnnualInspectionAgent.DeleteVehicleAnnualInspectionAgent(conn, oldValue.PKID));
if (!result)
{
throw new Exception($"DeleteVehicleAnnualInspectionAgent失败,待删除数据{JsonConvert.SerializeObject(oldValue)}");
}
var log = new AnnualInspectionOprLogModel
{
LogType = "VehicleAnnualInspectionAgent",
IdentityId = $"{carNoPrefix}_{servicePid}_{telNum}",
OperationType = "Delete",
OldValue = JsonConvert.SerializeObject(oldValue),
NewValue = null,
Remarks = $"删除{oldValue.CarNoPrefix},供应商:{oldValue.VenderShortName},服务Pid:{oldValue.ServicePid}," +
$"联系人:{oldValue.Contact},联系电话:{oldValue.TelNum}的年检代办服务",
Operator = user,
};
LoggerManager.InsertLog("AnnualInspectOprLog", log);
}
else
{
result = true;
}
}
catch (Exception ex)
{
result = false;
Logger.Error("DeleteVehicleAnnualInspectionAgent", ex);
}
return(result);
}
/// <summary>
/// 更新年检代办配置
/// </summary>
/// <param name="model"></param>
/// <param name="user"></param>
/// <returns></returns>
public bool UpdateVehicleAnnualInspectionAgent
(VehicleAnnualInspectionAgentModel model, string user)
{
var result = false;
try
{
var oldValue = GetVehicleAnnualInspectionAgent(model.ServicePid, model.TelNum, model.CarNoPrefix);
if (oldValue != null)
{
result = dbScopeManagerConfiguration.Execute(conn =>
DalVehicleAnnualInspectionAgent.UpdateVehicleAnnualInspectionAgent(conn, model));
if (!result)
{
throw new Exception($"UpdateVehicleAnnualInspectionAgent失败,待更新数据{JsonConvert.SerializeObject(model)}");
}
model.CreateDateTime = oldValue.CreateDateTime;
model.LastUpdateDateTime = DateTime.Now;
var log = new AnnualInspectionOprLogModel
{
LogType = "VehicleAnnualInspectionAgent",
IdentityId = $"{model.CarNoPrefix}_{model.ServicePid}_{model.TelNum}",
OperationType = "Update",
OldValue = JsonConvert.SerializeObject(oldValue),
NewValue = JsonConvert.SerializeObject(model),
Remarks = $"更新{model.CarNoPrefix},供应商:{model.VenderShortName},服务Pid:{model.ServicePid}," +
$"联系人:{model.Contact},联系电话{model.TelNum}的{model.ServiceName}服务",
Operator = user,
};
LoggerManager.InsertLog("AnnualInspectOprLog", log);
}
}
catch (Exception ex)
{
result = false;
Logger.Error("UpdateVehicleAnnualInspectionAgent", ex);
}
return(result);
}
