private int EditForm(RequestWrapper formWrapper, JObject data, IDbContext dbContext) { if (formWrapper == null || data["form"] == null) { return(0); } var rowsAffected = 0; var editArgs = new EditEventArgs { db = dbContext, form = data["form"] }; editArgs.wrapper = formWrapper; var rtnBefore = this.OnBeforEditMaster(editArgs); if (rtnBefore) { editArgs.type = OptType.Mod; var pUpdate = formWrapper.SetRequestData(editArgs.form).ToParamUpdate(); //在before事件中更改了form中的值,刷新更新时的值 rowsAffected = dbContext.Sql(BuilderParse(pUpdate)).Execute(); if (rowsAffected == 0) { editArgs.type = OptType.Add; rowsAffected = dbContext.Sql(BuilderParse(formWrapper.ToParamInsert())).Execute(); } editArgs.executeValue = rowsAffected; this.OnAfterEditMaster(editArgs); } return(rowsAffected); }
private int EditList(RequestWrapper listWrapper, JObject data, IDbContext dbContext) { if (listWrapper == null || data["list"] == null) { return(0); } var rowsAffected = 0; var editArgs = new EditEventArgs { db = dbContext, list = data["list"], wrapper = listWrapper }; foreach (JProperty item in data["list"].Children()) { if (!types.ContainsKey(item.Name)) { continue; } foreach (var row in item.Value.Children()) { editArgs.row = row; editArgs.type = types[item.Name]; var rtnBefore = this.OnBeforEditDetail(editArgs); if (!rtnBefore) { continue; } var wrapper = listWrapper.SetRequestData(row); if (types[item.Name] == OptType.Del) { editArgs.type = OptType.Del; editArgs.executeValue = dbContext.Sql(BuilderDelSql(wrapper.ToParamDelete())).Execute(); } else { //update editArgs.type = OptType.Mod; editArgs.executeValue = dbContext.Sql(BuilderParse(wrapper.ToParamUpdate())).Execute(); if (editArgs.executeValue < 1) { // insert editArgs.type = OptType.Add; editArgs.executeValue = dbContext.Sql(BuilderParse(wrapper.ToParamInsert())).Execute(); } } rowsAffected += editArgs.executeValue; this.OnAfterEditDetail(editArgs); } } return(rowsAffected); }
public int Edit(RequestWrapper formWrapper, RequestWrapper listWrapper, JObject data) { var rowsAffected = 0; var dbContext = db.UseTransaction(true); using (dbContext)//开启事务 { Logger("编辑记录", () => { var editArgs = new EditEventArgs { db = dbContext, form = data["form"], list = data["list"] }; editArgs.IdentityVal = -1; if (formWrapper != null && data["form"] != null) { editArgs.wrapper = formWrapper; //var pUpdate = formWrapper.SetRequestData(editArgs.form).ToParamUpdate(); //if (pUpdate.GetData().Columns.Count > 0)//更新主表 //{ var rtnBefore = this.OnBeforEditMaster(editArgs); if (rtnBefore) { editArgs.type = OptType.Mod; var pUpdate = formWrapper.SetRequestData(editArgs.form).ToParamUpdate(); //在before事件中更改了form中的值,刷新更新时的值 rowsAffected = dbContext.Sql(BuilderParse(pUpdate)).Execute(); if (rowsAffected == 0) { editArgs.type = OptType.Add; rowsAffected = dbContext.Sql(BuilderParse(formWrapper.ToParamInsert())).Execute(); if (APP.DbProvider == DbProviderEnum.SqlServer) { editArgs.IdentityVal = dbContext.Sql("SELECT @@IDENTITY;").QuerySingle <int>(); } } editArgs.executeValue = rowsAffected; this.OnAfterEditMaster(editArgs); } // } } if (listWrapper != null && data["list"] != null) { #region 定义变量 var types = new Dictionary <string, OptType> { { "deleted", OptType.Del }, { "updated", OptType.Mod }, { "inserted", OptType.Add } }; var handles = new Dictionary <string, Func <RequestWrapper, int> > { { "deleted", x => dbContext.Sql(BuilderDelSql(x.ToParamDelete())).Execute() }, { "updated", x => dbContext.Sql(BuilderParse(x.ToParamUpdate())).Execute() }, { "inserted", x => dbContext.Sql(BuilderParse(x.ToParamInsert())).Execute() } }; #endregion editArgs.wrapper = listWrapper; foreach (JProperty item in data["list"].Children()) { if (!handles.ContainsKey(item.Name)) { continue; } foreach (var row in item.Value.Children()) { editArgs.row = row; editArgs.type = types[item.Name]; var rtnBefore = this.OnBeforEditDetail(editArgs); if (!rtnBefore) { continue; } editArgs.executeValue = handles[item.Name](listWrapper.SetRequestData(row)); rowsAffected += editArgs.executeValue; this.OnAfterEditDetail(editArgs); } } } editArgs.executeValue = rowsAffected; //editArgs.wrapper = formWrapper; //this.OnAfterEdit(editArgs); if (rowsAffected > 0) { dbContext.Commit(); if (editArgs.IdentityVal > 0) { rowsAffected = editArgs.IdentityVal; } //Msg.Set(MsgType.Success, APP.MSG_SAVE_SUCCESS); } }, e => dbContext.Rollback()); } return(rowsAffected); }
public bool SaveExchangedData(RequestWrapper requestWrapper, JArray jdata, ServiceBase service, string dateColumn) { if (requestWrapper == null || jdata == null) { return(false); } var rowsAffected = 0; var sqlTest = ""; var dbContext = service.db.UseTransaction(true); try { using (dbContext)//开启事务 { //Logger("数据交换", () => //{ foreach (JToken row in jdata) { var pUpdate = requestWrapper.SetRequestData(row).ToParamUpdate(); var editArgs = new EditEventArgs { form = row, db = dbContext, TableName = pUpdate.GetData().Update }; var editBefore = OnBeforEditMaster(editArgs); if (!editBefore) { continue; } var sqlData = pUpdate.GetData(); var selSql = string.Format("SELECT {0} FROM {1} WHERE {2}", dateColumn, sqlData.Update, sqlData.WhereSql); var updateDate = dbContext.Sql(selSql).QuerySingle <string>(); if (updateDate != null)//更新 { //日期大于数据库中的日期 if (Convert.ToDateTime(row[dateColumn]) > Convert.ToDateTime(updateDate)) { sqlTest = BuilderParse(pUpdate); rowsAffected += dbContext.Sql(BuilderParse(pUpdate)).Execute(); } } else//新增 { rowsAffected += dbContext.Sql(BuilderParse(requestWrapper.ToParamInsert())).Execute(); } OnAfterEditMaster(editArgs); } dbContext.Commit(); } } catch (Exception ex) { rowsAffected = -1; dbContext.Rollback(); throw new Exception(ex.StackTrace); } return(rowsAffected >= 0); }
public int EditPage(JObject data, RequestWrapper formWrapper, List <RequestWrapper> tabsWrapper) { const string DATA_TYPE_DELETED = "deleted"; const string DATA_TYPE_UPDATED = "updated"; const string DATA_TYPE_INSERTED = "inserted"; const string DATA_TYPE_FORM = "form"; const string DATA_TYPE_TABS = "tabs"; const string DATA_TYPE_ARRAY = "Array"; Dictionary <string, OptType> actionTypes = new Dictionary <string, OptType> { { DATA_TYPE_DELETED, OptType.Del }, { DATA_TYPE_UPDATED, OptType.Mod }, { DATA_TYPE_INSERTED, OptType.Add } }; var handles = new Dictionary <string, Func <RequestWrapper, int> > { { DATA_TYPE_DELETED, x => db.Sql(BuilderDelSql(x.ToParamDelete())).Execute() }, { DATA_TYPE_UPDATED, x => db.Sql(BuilderParse(x.ToParamUpdate())).Execute() }, { DATA_TYPE_INSERTED, x => db.Sql(BuilderParse(x.ToParamInsert())).Execute() } }; var rowsAffected = 0; Logger("编辑记录", () => { var formData = data[DATA_TYPE_FORM]; var tabsData = data[DATA_TYPE_TABS]; var editArgs = new EditPageEventArgs() { db = db, data = data, formWrapper = formWrapper, tabsWrapper = tabsWrapper }; //开启事务 db.UseTransaction(true); //更新全部数据之前事件 var rtnBefore = this.OnBeforeEditPage(editArgs); if (!rtnBefore) { return; } //更新主表 if (formData != null && formWrapper != null) { formWrapper.SetRequestData(formData); var changedFieldCount = formWrapper.ToParamUpdate().GetData().Columns.Count; //如果有字段被修改则更新 if (changedFieldCount > 0) { //到数据库中取得旧值 var command = GetPreparedDbCommand(BuilderParse(formWrapper.ToParamQuery()).Data); var formOld = command.QuerySingle <dynamic>(); var strAction = (formOld == null) ? DATA_TYPE_INSERTED : DATA_TYPE_UPDATED; //事件参数 editArgs.dataNew = formData; editArgs.dataOld = formOld ?? new JObject(); editArgs.dataAction = actionTypes[strAction]; editArgs.dataWrapper = formWrapper; //主表编辑前事件 rtnBefore = this.OnBeforeEditPageForm(editArgs); if (!rtnBefore) { return; } //主表数据处理 formWrapper.SetRequestData(editArgs.dataNew); editArgs.executeValue = handles[strAction](formWrapper); rowsAffected += editArgs.executeValue; //把未修改的数据更新到form新值上,避免在后面的事件中使用formNew值时为null出现错误 if (editArgs.dataAction == OptType.Mod) { EachHelper.EachObjectProperty(editArgs.dataOld as object, (i, name, value) => { if (editArgs.dataNew[name] == null) { editArgs.dataNew[name] = JToken.FromObject(value ?? string.Empty); } }); } //主表编辑结束事件 this.OnAfterEditPageForm(editArgs); } } //更新tabs if (tabsData != null && tabsWrapper != null) { var current = 0; var wrapperCount = tabsWrapper.Count; foreach (JToken tab in tabsData.Children()) { //如果Tab数据长度大于wrapper长度,则结束 if (current > wrapperCount - 1) { break; } //如果数据为null或未配置相应的wrapper则跳过处理 var wrapper = tabsWrapper[current++]; if (tab == null || wrapper == null) { continue; } //判断是form类型还是grid类型 bool IsGrid = (tab[DATA_TYPE_DELETED] != null && tab[DATA_TYPE_DELETED].Type.ToString() == DATA_TYPE_ARRAY) || (tab[DATA_TYPE_UPDATED] != null && tab[DATA_TYPE_UPDATED].Type.ToString() == DATA_TYPE_ARRAY) || (tab[DATA_TYPE_INSERTED] != null && tab[DATA_TYPE_INSERTED].Type.ToString() == DATA_TYPE_ARRAY); //事件参数 editArgs.dataWrapper = wrapper; editArgs.tabIndex = current; editArgs.tabType = IsGrid ? TabType.Grid : TabType.Form; editArgs.tabData = tab; if (IsGrid) { foreach (JProperty item in tab.Children()) { //只处理deleted updated inserted三个节点 if (!handles.ContainsKey(item.Name)) { continue; } //循环每一行数据 foreach (var row in item.Value.Children()) { //到数据库中取得旧值 wrapper.SetRequestData(row); var command = GetPreparedDbCommand(BuilderParse(wrapper.ToParamQuery()).Data); var rowOld = command.QuerySingle <dynamic>(); //事件参数 editArgs.dataNew = row; editArgs.dataOld = rowOld ?? new JObject(); editArgs.dataAction = actionTypes[item.Name]; //行编辑前事件 rtnBefore = this.OnBeforeEditPageRow(editArgs); if (!rtnBefore) { return; } //数据处理 wrapper.SetRequestData(editArgs.dataNew); editArgs.executeValue = handles[item.Name](wrapper); rowsAffected += editArgs.executeValue; //行编辑后事件 this.OnAfterEditPageRow(editArgs); } } } else { wrapper.SetRequestData(tab); var changedFieldCount = wrapper.ToParamUpdate().GetData().Columns.Count; //如果有字段被修改则更新 if (changedFieldCount > 0)//更新主表 { //到数据库中取得旧值 var command = GetPreparedDbCommand(BuilderParse(wrapper.ToParamQuery()).Data); var formOld = command.QuerySingle <dynamic>(); //var formOld = BuilderParse(wrapper.ToParamQuery()).QuerySingleDynamic(); var strAction = (formOld == null) ? DATA_TYPE_INSERTED : DATA_TYPE_UPDATED; //事件参数 editArgs.dataNew = tab; editArgs.dataOld = formOld ?? new JObject(); editArgs.dataAction = actionTypes[strAction]; editArgs.dataWrapper = wrapper; //Form编辑前事件 rtnBefore = this.OnBeforeEditPageRow(editArgs); if (!rtnBefore) { return; } //Form数据处理 wrapper.SetRequestData(editArgs.dataNew); editArgs.executeValue = handles[strAction](wrapper); rowsAffected += editArgs.executeValue; //把未修改的数据更新到form新值上 if (editArgs.dataAction == OptType.Mod) { EachHelper.EachObjectProperty(editArgs.dataOld as object, (i, name, value) => { if (editArgs.dataNew[name] == null) { editArgs.dataNew[name] = JToken.FromObject(value ?? string.Empty); } }); } //Form编辑结束事件 this.OnAfterEditPageRow(editArgs); } } } //更新全部数据之后事件 editArgs.executeValue = rowsAffected; this.OnAfterEditPage(editArgs); //提交事务 if (rowsAffected > 0) { db.Commit(); Msg.Set(MsgType.Success, APP.MSG_SAVE_SUCCESS); } } }, e => db.Rollback()); return(rowsAffected); }