public async Task <HandleResult> Edit(JObject form, string accountNum) { var num = form["num"].ToStr(); var columnNum = form["columnNum"].ToStr(); if (columnNum.IsEmpty()) { return(HandleResult.Error("无效的提交数据")); } var cm = await _columnService.GetModelByNum(columnNum); if (cm == null) { return(HandleResult.Error("无效的提交数据")); } var column = cm?.Column; var model = cm?.ModelTable; var oldData = num.IsEmpty() ? null : await _dapper.GetByNum(model.SqlCategoryTableName, num); var id = oldData?.Id ?? 0; var parentNum = form["parentNum"].ToStr(); if (oldData != null && oldData.Num == parentNum) { return(HandleResult.Error("父类别不能是自身")); } var contentEdit = new DynamicTableSqlHelper(model.SqlCategoryTableName); contentEdit.AddFieldAndValue("Name", form["name"].ToStr()); contentEdit.AddFieldAndValue("ParentNum", parentNum); if (id > 0) { contentEdit.AddFieldAndValue("UpdateAccountNum", accountNum); contentEdit.AddFieldAndValue("UpdateDate", DateTime.Now); } else { contentEdit.AddFieldAndValue("Num", RandomHelper.CreateNum()); contentEdit.AddFieldAndValue("CreateDate", DateTime.Now); contentEdit.AddFieldAndValue("UpdateDate", DateTime.Now); contentEdit.AddFieldAndValue("CreateAccountNum", accountNum); contentEdit.AddFieldAndValue("UpdateAccountNum", accountNum); contentEdit.AddFieldAndValue("IsDel", false); contentEdit.AddFieldAndValue("Status", 0); contentEdit.AddFieldAndValue("SiteNum", column.SiteNum); contentEdit.AddFieldAndValue("ColumnNum", columnNum); } var sql = id > 0 ? contentEdit.GetUpdateSql(id) : contentEdit.GetAddSql(); var res = await _dapper.Execute(sql, contentEdit.GetValue()); return(res > 0 ? HandleResult.Success() : HandleResult.Error("操作失败")); }
public async Task <HandleResult> Update(DynamicTableSqlHelper form, int id) { var sql = form.GetUpdateSql(id); if (sql.IsEmpty()) { return(HandleResult.Error()); } var res = await _dapper.Execute(sql, form.GetValue()); return(res > 0 ? HandleResult.Success() : HandleResult.Error("操作失败")); }