/// <summary>
/// 更新违章查询省份配置
/// </summary>
/// <param name="province"></param>
/// <param name="user"></param>
/// <returns></returns>
public bool UpdatePeccancyProvinceConfig(PeccancyQueryProvinceModel province, string user)
{
var result = false;
try
{
var oldValue = DalPeccancyQueryConfig.GetPeccancyProvinceConfigByProvinceId(province.ProvinceId);
if (oldValue != null)
{
using (var dbhelper = new Tuhu.Component.Common.SqlDbHelper(grconnectionString))
{
result = DalPeccancyQueryConfig.UpdatePeccancyProvinceConfig(dbhelper, province);
}
if (result)
{
var log = new PeccancyConfigOprLogModel
{
LogType = "PeccancyProvinceConfig",
IdentityId = $"{province.ProvinceId}",
OperationType = "Update",
OldValue = JsonConvert.SerializeObject(oldValue),
NewValue = JsonConvert.SerializeObject(province),
Remarks = $"更新 违章查询省份:{province.ProvinceName} 的配置",
Operator = user,
};
LoggerManager.InsertLog("PeccancyConfigOprLog", log);
}
}
}
catch (Exception ex)
{
Logger.Error("UpdatePeccancyProvinceConfig", ex);
}
return(result);
}
/// <summary>
/// 添加违章查询省份配置
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ActionResult AddPeccancyProvinceConfig(PeccancyQueryProvinceModel model)
{
if (model.ProvinceId < 1 || string.IsNullOrWhiteSpace(model.ProvinceName) || string.IsNullOrWhiteSpace(model.ProvinceSimpleName))
{
return(Json(new { Status = false, Msg = "请确认省份信息" }, JsonRequestBehavior.AllowGet));
}
var manager = new PeccancyQueryConfigManager();
var existModel = manager.GetRepeatPeccancyProvinceConfig(model);
if (existModel != null)
{
return(Json(new { Status = false, Msg = $"存在重复数据:省份Id{existModel.ProvinceId},省份名称{existModel.ProvinceName},省份简称{existModel.ProvinceSimpleName}" }, JsonRequestBehavior.AllowGet));
}
var user = User.Identity.Name;
var result = manager.AddPeccancyProvinceConfig(model, user);
if (result)
{
return(Json(new { Status = true, Msg = "添加成功" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { Status = false, Msg = "添加失败" }, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// 根据省份Id获取违章查询省份配置
/// </summary>
/// <param name="provinceId"></param>
/// <returns></returns>
public PeccancyQueryProvinceModel GetPeccancyProvinceConfigByProvinceId(int provinceId)
{
PeccancyQueryProvinceModel model = null;
try
{
model = DalPeccancyQueryConfig.GetPeccancyProvinceConfigByProvinceId(provinceId);
}
catch (Exception ex)
{
Logger.Error("GetPeccancyProvinceConfigByProvinceId", ex);
}
return(model);
}
/// <summary>
/// 省份配置是否重复
/// </summary>
/// <param name="peccancyProvinceModel"></param>
/// <returns></returns>
public PeccancyQueryProvinceModel GetRepeatPeccancyProvinceConfig(PeccancyQueryProvinceModel peccancyProvinceModel)
{
PeccancyQueryProvinceModel result = null;
try
{
result = DalPeccancyQueryConfig.GetRepeatPeccancyProvinceConfig(peccancyProvinceModel);
}
catch (Exception ex)
{
Logger.Error("GetRepeatPeccancyProvinceConfig", ex);
}
return(result);
}
/// <summary>
/// 更新违章查询省份配置
/// </summary>
/// <param name="dbhelper"></param>
/// <param name="peccancyQueryProvinceModel"></param>
/// <returns></returns>
public static bool UpdatePeccancyProvinceConfig(SqlDbHelper dbhelper, PeccancyQueryProvinceModel peccancyQueryProvinceModel)
{
var sql = @"UPDATE Gungnir..tbl_peccancyProvince
SET Province = @ProvinceName ,
ProvinceSimple = @ProvinceSimpleName
WHERE ID = @ProvinceId;";
using (var cmd = new SqlCommand(sql))
{
cmd.Parameters.AddWithValue("@ProvinceName", peccancyQueryProvinceModel.ProvinceName);
cmd.Parameters.AddWithValue("@ProvinceSimpleName", peccancyQueryProvinceModel.ProvinceSimpleName);
cmd.Parameters.AddWithValue("@ProvinceId", peccancyQueryProvinceModel.ProvinceId);
var count = dbhelper.ExecuteNonQuery(cmd);
return(count > 0);
}
}
/// <summary>
/// 更新违章查询省份配置
/// </summary>
/// <param name="province"></param>
/// <returns></returns>
public ActionResult UpdatePeccancyQueryProvinceConfig(PeccancyQueryProvinceModel province)
{
if (province.ProvinceId < 1 || string.IsNullOrWhiteSpace(province.ProvinceName) || string.IsNullOrWhiteSpace(province.ProvinceSimpleName))
{
return(Json(new { Status = false, Msg = "请确认省份信息" }, JsonRequestBehavior.AllowGet));
}
var manager = new PeccancyQueryConfigManager();
var user = User.Identity.Name;
var result = manager.UpdatePeccancyProvinceConfig(province, user);
if (result)
{
return(Json(new { Status = true, Msg = "修改成功" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { Status = false, Msg = "修改失败" }, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// 判断省份配置是否重复
/// </summary>
/// <param name="peccancyQueryModel"></param>
/// <returns></returns>
public static PeccancyQueryProvinceModel GetRepeatPeccancyProvinceConfig(PeccancyQueryProvinceModel peccancyQueryModel)
{
var sql = @"SELECT ID AS ProvinceId ,
Province AS ProvinceName ,
ProvinceSimple AS ProvinceSimpleName
FROM Gungnir..tbl_PeccancyProvince WITH ( NOLOCK )
WHERE ID = @ProvinceId OR Province=@ProvinceName OR ProvinceSimple=@ProvinceSimpleName;";
using (var dbhelper = new SqlDbHelper(grReadconnectionString))
{
using (var cmd = new SqlCommand(sql))
{
cmd.Parameters.AddWithValue("@ProvinceId", peccancyQueryModel.ProvinceId);
cmd.Parameters.AddWithValue("@ProvinceName", peccancyQueryModel.ProvinceName);
cmd.Parameters.AddWithValue("@ProvinceSimpleName", peccancyQueryModel.ProvinceSimpleName);
var result = dbhelper.ExecuteDataTable(cmd).ConvertTo <PeccancyQueryProvinceModel>().FirstOrDefault();
return(result);
}
}
}
/// <summary>
/// 添加违章查询省份配置
/// </summary>
/// <param name="dbhelper"></param>
/// <param name="peccancyQueryProvinceModel"></param>
/// <returns></returns>
public static bool AddPeccancyProvinceConfig(SqlDbHelper dbhelper, PeccancyQueryProvinceModel peccancyQueryProvinceModel)
{
var sql = @"INSERT INTO Gungnir..tbl_peccancyProvince
( ID ,
Province ,
ProvinceSimple
)
VALUES ( @ProvinceId ,
@ProvinceName ,
@ProvinceSimpleName
);";
using (var cmd = new SqlCommand(sql))
{
cmd.Parameters.AddWithValue("@ProvinceId", peccancyQueryProvinceModel.ProvinceId);
cmd.Parameters.AddWithValue("@ProvinceName", peccancyQueryProvinceModel.ProvinceName);
cmd.Parameters.AddWithValue("@ProvinceSimpleName", peccancyQueryProvinceModel.ProvinceSimpleName);
var count = dbhelper.ExecuteNonQuery(cmd);
return(count > 0);
}
}
