/// <summary>
/// 更新违章查询城市配置
/// </summary>
/// <param name="dbhelper"></param>
/// <param name="peccancyQueryCityModel"></param>
/// <returns></returns>
public static bool UpdatePeccancyCityConfig(SqlDbHelper dbhelper, PeccancyQueryCityModel peccancyQueryCityModel)
{
#region sql
var sql = @"UPDATE Gungnir..tbl_PeccancyCity
SET provinceId = @ProvinceId ,
cityCode = @CityCode ,
city = @CityName ,
needEngine = @NeedEngine ,
needFrame = @NeedFrame ,
engineLen = @EngineLen ,
frameLen = @FrameLen ,
isEnabled = @IsEnabled
WHERE ID = @CityId;";
#endregion
using (var cmd = new SqlCommand(sql))
{
cmd.Parameters.AddWithValue("@ProvinceId", peccancyQueryCityModel.ProvinceId);
cmd.Parameters.AddWithValue("@CityId", peccancyQueryCityModel.CityId);
cmd.Parameters.AddWithValue("@CityCode", peccancyQueryCityModel.CityCode);
cmd.Parameters.AddWithValue("@CityName", peccancyQueryCityModel.CityName);
cmd.Parameters.AddWithValue("@NeedEngine", peccancyQueryCityModel.NeedEngine);
cmd.Parameters.AddWithValue("@NeedFrame", peccancyQueryCityModel.NeedFrame);
cmd.Parameters.AddWithValue("@EngineLen", peccancyQueryCityModel.EngineLen);
cmd.Parameters.AddWithValue("@FrameLen", peccancyQueryCityModel.FrameLen);
cmd.Parameters.AddWithValue("@IsEnabled", peccancyQueryCityModel.IsEnabled);
var count = dbhelper.ExecuteNonQuery(cmd);
return(count > 0);
}
}
/// <summary>
/// 更新违章查询城市配置
/// </summary>
/// <param name="model"></param>
/// <param name="user"></param>
/// <returns></returns>
public bool UpdatePeccancyCityConfig(PeccancyQueryCityModel model, string user)
{
var result = false;
try
{
var oldValue = DalPeccancyQueryConfig.GetPeccancyCityConfigByCityId(model.CityId);
if (oldValue != null)
{
using (var dbhelper = new Tuhu.Component.Common.SqlDbHelper(grconnectionString))
{
result = DalPeccancyQueryConfig.UpdatePeccancyCityConfig(dbhelper, model);
}
if (result)
{
var log = new PeccancyConfigOprLogModel
{
LogType = "PeccancyCityConfig",
IdentityId = $"{model.CityId}",
OperationType = "Update",
OldValue = JsonConvert.SerializeObject(oldValue),
NewValue = JsonConvert.SerializeObject(model),
Remarks = $"更新 违章查询城市:{model.CityName} 的配置",
Operator = user,
};
LoggerManager.InsertLog("PeccancyConfigOprLog", log);
}
}
}
catch (Exception ex)
{
Logger.Error("UpdatePeccancyCityConfig", ex);
}
return(result);
}
/// <summary>
/// 更新违章查询城市配置
/// </summary>
/// <param name="peccancyCityModel"></param>
/// <returns></returns>
public ActionResult UpdatePeccancyQueryCityConfig(PeccancyQueryCityModel peccancyCityModel)
{
if (peccancyCityModel.ProvinceId < 1)
{
return(Json(new { Status = false, Msg = "请确认省份信息" }, JsonRequestBehavior.AllowGet));
}
if (peccancyCityModel.CityId < 1 || peccancyCityModel.CityCode < 1 || string.IsNullOrWhiteSpace(peccancyCityModel.CityName))
{
return(Json(new { Status = false, Msg = "请确认城市信息" }, JsonRequestBehavior.AllowGet));
}
else if (peccancyCityModel.NeedEngine && peccancyCityModel.EngineLen < 1)
{
return(Json(new { Status = false, Msg = "发动机号如必要，请输入发动机号长度" }, JsonRequestBehavior.AllowGet));
}
else if (peccancyCityModel.NeedFrame && peccancyCityModel.FrameLen < 1)
{
return(Json(new { Status = false, Msg = "车架号如必要，请输入车架号长度" }, JsonRequestBehavior.AllowGet));
}
var manager = new PeccancyQueryConfigManager();
var user = User.Identity.Name;
var result = manager.UpdatePeccancyCityConfig(peccancyCityModel, 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="cityId"></param>
/// <returns></returns>
public PeccancyQueryCityModel GetPeccancyCityConfigByCityId(int cityId)
{
PeccancyQueryCityModel peccancyCityModel = null;
try
{
peccancyCityModel = DalPeccancyQueryConfig.GetPeccancyCityConfigByCityId(cityId);
}
catch (Exception ex)
{
Logger.Error("GetPeccancyCityConfigByCityId", ex);
}
return(peccancyCityModel);
}
/// <summary>
/// 添加违章查询城市配置
/// </summary>
/// <param name="dbhelper"></param>
/// <param name="peccancyQueryCityModel"></param>
/// <returns></returns>
public static bool AddPeccancyCityConfig(SqlDbHelper dbhelper, PeccancyQueryCityModel peccancyQueryCityModel)
{
#region SQL
var sql = @"INSERT INTO Gungnir..tbl_PeccancyCity
( ID ,
provinceID ,
cityCode ,
city ,
engineLen ,
frameLen ,
needEngine,
needFrame,
isEnabled
)
VALUES ( @CityId ,
@ProvinceId ,
@CityCode ,
@CityName ,
@EngineLen ,
@FrameLen ,
@NeedEngine ,
@NeedFrame ,
@IsEnabled
);";
#endregion
using (var cmd = new SqlCommand(sql))
{
cmd.Parameters.AddWithValue("@CityId", peccancyQueryCityModel.CityId);
cmd.Parameters.AddWithValue("@ProvinceId", peccancyQueryCityModel.ProvinceId);
cmd.Parameters.AddWithValue("@CityCode", peccancyQueryCityModel.CityCode);
cmd.Parameters.AddWithValue("@CityName", peccancyQueryCityModel.CityName);
cmd.Parameters.AddWithValue("@NeedEngine", peccancyQueryCityModel.NeedEngine);
cmd.Parameters.AddWithValue("@NeedFrame", peccancyQueryCityModel.NeedFrame);
cmd.Parameters.AddWithValue("@EngineLen", peccancyQueryCityModel.EngineLen);
cmd.Parameters.AddWithValue("@FrameLen", peccancyQueryCityModel.FrameLen);
cmd.Parameters.AddWithValue("@IsEnabled", peccancyQueryCityModel.IsEnabled);
var count = dbhelper.ExecuteNonQuery(cmd);
return(count > 0);
};
}
/// <summary>
/// 添加违章查询城市配置
/// </summary>
/// <param name="peccancyCityModel"></param>
/// <returns></returns>
public ActionResult AddPeccancyQueryCityConfig(PeccancyQueryCityModel peccancyCityModel)
{
if (peccancyCityModel.ProvinceId < 1)
{
return(Json(new { Status = false, Msg = "请确认省份信息" }, JsonRequestBehavior.AllowGet));
}
if (peccancyCityModel.CityId < 1 || peccancyCityModel.CityCode < 1 || string.IsNullOrWhiteSpace(peccancyCityModel.CityName))
{
return(Json(new { Status = false, Msg = "请确认城市信息" }, JsonRequestBehavior.AllowGet));
}
else if (peccancyCityModel.NeedEngine && peccancyCityModel.EngineLen < 1)
{
return(Json(new { Status = false, Msg = "发动机号如必要，请输入发动机号长度" }, JsonRequestBehavior.AllowGet));
}
else if (peccancyCityModel.NeedFrame && peccancyCityModel.FrameLen < 1)
{
return(Json(new { Status = false, Msg = "车架号如必要，请输入车架号长度" }, JsonRequestBehavior.AllowGet));
}
var manager = new PeccancyQueryConfigManager();
var existModel = manager.GetPeccancyCityConfigByCityId(peccancyCityModel.CityId);
if (existModel != null)
{
return(Json(new { Status = false, Msg = $"已存在城市Id为{existModel.CityId}的城市！城市名称{existModel.CityName},城市代码{existModel.CityCode}" }));
}
var user = User.Identity.Name;
var result = manager.AddPeccancyCityConfig(peccancyCityModel, user);
if (result)
{
return(Json(new { Status = true, Msg = "添加成功" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { Status = false, Msg = "添加失败" }, JsonRequestBehavior.AllowGet));
}
}
