public IActionResult AddorUpdate(b_region model)
{
//实例化行政区划接口
var Region = this.GetInstance <IB_Region>();
//查询行政区划列表
var result = Region.AddorUpdate(model)?.Result;
return(Json(result));
}
/// <summary>
/// 新增或者修改行政区划信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ResponseModel AddorUpdate(b_region model)
{
//待返回对象
var result = new ResponseModel(ResponseCode.Error, "保存行政区划失败!");
var row = 0;
try
{
using (var db = new DbContext())
{
//判断行政区划编码是否存在
var dataList = db.Select("b_region").Columns("id").Where("code", model.code).GetModelList <b_region>();
model.pinyin = Basics.Utils.Strings.GetFirstPY(model.name.Trim());
if (model.id.IsNullOrEmpty())
{
var guid = Guid.NewGuid().ToString();
model.id = guid;
if (dataList != null && dataList.Any())
{
result.msg = "编码重复！";
return(result);
}
row = db.Insert("b_region").Column("id", model.id).Column("code", model.code).Column("parent_code", model.parent_code).Column("name", model.name).Column("pinyin", model.pinyin).Column("prop", model.prop).Column("status", model.status).Column("location_coordinate", model.location_coordinate).Column("range_coordinate", model.range_coordinate).Column("source", model.source).Column("update_time", DateTime.Now).Column("year", model.year).Execute();
}
else
{
//判断行政区划编码是否存在
if (dataList != null && dataList.Any(d => d.id != model.id))
{
result.msg = "编码重复！";
return(result);
}
row = db.Update("b_region").Column("id", model.id).Column("code", model.code).Column("parent_code", model.parent_code).Column("name", model.name).Column("pinyin", model.pinyin).Column("prop", model.prop).Column("status", model.status).Column("location_coordinate", model.location_coordinate).Column("range_coordinate", model.range_coordinate).Column("source", model.source).Column("update_time", DateTime.Now).Column("year", model.year).Where("id", model.id).Execute();
}
if (row == 1)
{
result.msg = "保存成功";
result.code = (int)ResponseCode.Success;
return(result);
}
}
}
catch (Exception ex)
{
Logger.Instance.Error("保存行政区划失败", ex);
result.msg = "服务器内部异常";
}
return(result);
}
/// <summary>
/// 新增或者修改行政区划信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public Task <ResponseModel> AddorUpdate(b_region model)
{
return(Task.FromResult(this.Logic.AddorUpdate(model)));
}
