/// <summary>
/// 保存后触发
/// </summary>
/// <param name="e"></param>
public override void AfterSave(AfterSaveEventArgs e)
{
string sql = @"/*dialect*/ insert into PAEZ_t_BillRecordLog
(FUSERID,FDATETIME,FORGID,FSUBSYSTEMID,FOPERATENAME,FCLIENTIP,F_PAEZ_Bill,F_PAEZ_ColumnName,F_PAEZ_OldValue,F_PAEZ_NewValue,F_PAEZ_DataRowNumber,F_PAEZ_BILLNAME,F_PAEZ_BILLKEY)
values('{0}','{1}','{2}','','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}')";
foreach (var item in colist)
{
if (item["Old"] != item["New"])
{
DBServiceHelper.Execute(this.Context, string.Format(sql,
Context.UserName,
DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
Context.CurrentOrganizationInfo.Name,
item["OperateName"],
Context.ClientInfo.IpAddress,
View.BillBusinessInfo.Elements[0].Name,
item["Column"],
item["Old"],
item["New"],
item["Row"],
billname,
billkey));
}
item["Old"] = item["New"];
//item["New"] = "";
}
//colist.Clear();
}
/// <summary>
/// 保存后,写入日志操作
/// </summary>
/// <param name="e"></param>
public override void AfterSave(AfterSaveEventArgs e)
{
//List<SqlParam> lsp;
//string sql = @"/*dialect*/ insert into PAEZ_t_BillRecordLog
//(FUSERID,FDATETIME,FORGID,FSUBSYSTEMID,FOPERATENAME,FCLIENTIP,F_PAEZ_Bill,F_PAEZ_ColumnName,F_PAEZ_OldValue,F_PAEZ_NewValue,F_PAEZ_DataRowNumber)
//values(@UserName,@time,@forgid,'','',@IP,@Bill,@ColumnName,@OldValue,@NewValue,@DataRowNumber)";
//foreach (var item in colist)
//{
// lsp = new List<SqlParam>() {
// new SqlParam("@UserName",KDDbType.String,this.Context.UserName),
// new SqlParam("@time",KDDbType.DateTime,System.DateTime.Now),
// new SqlParam("@forgid",KDDbType.String,this.Context.CurrentOrganizationInfo.Name),
// new SqlParam("@IP",KDDbType.String,this.Context.ClientInfo.IpAddress),
// new SqlParam("@Bill",KDDbType.String,this.View.BillBusinessInfo.Elements[0].Name),
// new SqlParam("@ColumnName",KDDbType.String,item["Column"]),
// new SqlParam("@OldValue",KDDbType.String,item["Old"]),
// new SqlParam("@NewValue",KDDbType.String,item["New"]),
// new SqlParam("@DataRowNumber",KDDbType.String,item["Row"]),
// };
// DBServiceHelper.Execute(this.Context, sql, lsp);
//}
string sql = @"/*dialect*/ insert into PAEZ_t_BillRecordLog
(FUSERID,FDATETIME,FORGID,FSUBSYSTEMID,FOPERATENAME,FCLIENTIP,F_PAEZ_Bill,F_PAEZ_ColumnName,F_PAEZ_OldValue,F_PAEZ_NewValue,F_PAEZ_DataRowNumber)
values('{0}','{1}','{2}','','','{3}','{4}','{5}','{6}','{7}','{8}')";
foreach (var item in colist)
{
DBServiceHelper.Execute(this.Context, string.Format(sql, Context.UserName, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), Context.CurrentOrganizationInfo.Name
, Context.ClientInfo.IpAddress, View.BillBusinessInfo.Elements[0].Name, item["Column"], item["Old"], item["New"], item["Row"]));
}
colist.Clear();
}
public override void AfterSave(AfterSaveEventArgs e)
{
base.AfterSave(e);
if (base.View.OpenParameter.Status == OperationStatus.ADDNEW)
{
this.AddActivityForm();
}
}
protected virtual void OnAfterSave(AfterSaveEventArgs afterSaveEvent)
{
EventHandler <AfterSaveEventArgs> handler = this.AfterSave;
if (handler != null)
{
handler(this, afterSaveEvent);
}
}
public void OnAfterSave(AfterSaveEventArgs e)
{
var handler = AfterSave;
if (handler != null)
{
handler(this, e);
}
}
public virtual ResultList SaveChanges()
{
OnBeforeSave();
var result = new AfterSaveEventArgs();
var resultList = this.DataManager.Execute();
result.Results = resultList;
OnAfterSave(result);
return(resultList);
}
/// <summary>
/// 保存后触发
/// </summary>
/// <param name="e"></param>
public override void AfterSave(AfterSaveEventArgs e)
{
string sql = @"/*dialect*/ insert into PAEZ_t_BillRecordLog
(FUSERID,FDATETIME,FORGID,FSUBSYSTEMID,FOPERATENAME,FCLIENTIP,F_PAEZ_Bill,F_PAEZ_ColumnName,F_PAEZ_OldValue,F_PAEZ_NewValue,F_PAEZ_DataRowNumber,F_PAEZ_BILLNAME,F_PAEZ_BILLKEY)
values('{0}','{1}','{2}','','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}')";
foreach (var item in colist)
{
if (item["Old"] != item["New"])
{
DBServiceHelper.Execute(this.Context, string.Format(sql,
Context.UserName, //用户
DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), //操作时间
Context.CurrentOrganizationInfo.Name, //组织
item["OperateName"], //操作类型
Context.ClientInfo.IpAddress, //IP
View.BillBusinessInfo.Elements[0].Name, //单据
item["Column"], //字段名
item["Old"], //改前
item["New"], //改后
item["Row"], //行
billname, //表名
billkey)); //表标识
}
item["Old"] = item["New"];
//表体
foreach (var olditem in oldvaluesfoItem)
{
if (olditem.ContainsKey(item["ColEntityKey"]) && olditem["Row"] == item["Row"])
{
if (olditem[item["ColEntityKey"]] != item["New"])
{
olditem[item["ColEntityKey"]] = item["New"];
StaticClass.oldvaluesfoItem = oldvaluesfoItem;
break;
}
}
}
//主表
if (oldvaluefoSubject.ContainsKey(item["ColEntityKey"]))
{
if (oldvaluefoSubject[item["ColEntityKey"]] != item["New"])
{
oldvaluefoSubject[item["ColEntityKey"]] = item["New"];
StaticClass.oldvaluefoSubject = oldvaluefoSubject;
}
}
}
colist = colist.FindAll(item => item["Old"] != item["New"]);
}
protected virtual void OnAfterSaveChanges(AfterSaveEventArgs args) => AfterSaveChanges?.Invoke(this, args);
private void AfterSaveForncedor(object sender, AfterSaveEventArgs e)
{
BsDialog.Row["CodFornecedor"] = e.Row["CodFornecedor"];
drConsulta1.SetConsulta(BsDialog.Row["CodFornecedor"].ToString());
}
