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); }