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 EditFormList(RequestWrapper formWrapper, RequestWrapper listWrapper, JObject data)
{
var rowsAffected = 0;
var dbContext = db.UseTransaction(true);
using (dbContext)//开启事务
{
Logger("编辑记录", () =>
{
var result1 = EditForm(formWrapper, data, dbContext);
var result2 = EditList(listWrapper, data, dbContext);
if (result1 > 0 || result2 > 0)
{
rowsAffected = result1 + result2;
dbContext.Commit();
}
}, e => dbContext.Rollback());
}
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);
}
