public JsonResult EditDataById(Api_EquipmentData model, int flag = 0)
{
JsonStateResult result = new JsonStateResult();
try
{
if (flag > 0)//新增
{
if (_dataApiService.IsExistEquipmentData(model.EquipmentId, model.Mark.ToUpper()) != null)
{
result.Error = 1;
result.Msg = "已存在标识为“" + model.Mark + "”的数据了，请勿重复添加";
return(Json(result, JsonRequestBehavior.AllowGet));
}
_dataApiService.InsertEquipmentData(model);
result.Error = 0;
result.Msg = "添加成功";
return(Json(result, JsonRequestBehavior.AllowGet));
}
_dataApiService.UpdateEquimentData(model);
result.Error = 0;
result.Msg = "修改成功";
return(Json(result, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
result.Error = 1;
result.Msg = "修改失败";
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name="data"></param>
public void UpdateEquimentData(Api_EquipmentData model)
{
if (model.EquipmentId > 0)
{
StringBuilder sb = new StringBuilder();
if (!string.IsNullOrEmpty(model.Name))
{
sb.Append(" Name=@Name,");
}
if (!string.IsNullOrEmpty(model.Unit))
{
sb.Append(" Unit=@Unit,");
}
if (model.IsDelete != null)
{
sb.Append(" IsDelete=@IsDelete,");
}
if (!string.IsNullOrEmpty(model.Method))
{
sb.Append(" Method=@Method,");
}
if (model.MoneyMethod > 0)
{
sb.Append(" MoneyMethod=@MoneyMethod,");
}
if (model.SortingIndex != null && model.SortingIndex >= 0)
{
sb.Append(" SortingIndex=@SortingIndex,");
}
string updateSql = sb.ToString().TrimEnd(',');
if (!string.IsNullOrEmpty(updateSql))
{
_db.ExecuteSqlCommand(string.Format("update Api_EquipmentData set {0} where EquipmentId=@EquipmentId and Mark=@Mark", updateSql), new { @Name = model.Name, @Unit = model.Unit, @IsDelete = model.IsDelete, @EquipmentId = model.EquipmentId, @Mark = model.Mark, @Method = model.Method, @MoneyMethod = model.MoneyMethod, @SortingIndex = model.SortingIndex });
}
}
}
public void InsertEquipmentData(Api_EquipmentData model)
{
model.IsDelete = false;
_dataDb.Insert(model);
}
