private bool isUpload = false; //控制文件不要进行多次上传
/// <summary>
/// 提交成功后进行文件上传
/// </summary>
/// <param name="e"></param>
public override void AfterDoOperation(AfterDoOperationEventArgs e)
{
base.AfterDoOperation(e);
if (this.Context.ClientType.ToString() != "Mobile")
{
var opKey = e.Operation.Operation.ToString();
if (opKey == "Save" && !isUpload) //点击保存，且附件未上传过
{
//如果生成了单据编号，进行附件上传
var _BillNo = this.View.Model.DataObject["BillNo"];
if (_BillNo != null)
{
SetSubmitType();
BindForm_UploadAttach();
isUpload = true;
}
}
else if (opKey == "Submit" && !isUpload)//点击提交，且附件未上传过
{
//如果生成了单据编号，进行附件上传
var _BillNo = this.View.Model.DataObject["BillNo"];
if (_BillNo != null)
{
SetSubmitType();
BindForm_UploadAttach();
isUpload = true;
}
}
}
}
public override void AfterDoOperation(AfterDoOperationEventArgs e)
{
base.AfterDoOperation(e);
switch (e.Operation.Operation.ToUpperInvariant())
{
case "SAVE":
ReWriteLastDailyTask();
ReWriteAssignTask(true);
//无需反写本月
//ReWriteAssignTask(false);
break;
case "SUBMIT":
ReWriteLastDailyTask();
ReWriteAssignTask(true);
//无需反写本月
//ReWriteAssignTask(false);
break;
case "AUDIT":
ReWriteLastDailyTask();
ReWriteAssignTask(true);
//无需反写本月
//ReWriteAssignTask(false);
break;
}
}
/// <summary>
/// 保存后的一些操作
/// </summary>
/// <param name="e"></param>
public override void AfterDoOperation(AfterDoOperationEventArgs e)
{
base.AfterDoOperation(e);
if (this.View.ClientType.ToString() != "Mobile")
{
string opKey = e.Operation.Operation.ToUpperInvariant();
string FClueNo = "";
switch (opKey)
{
case "SAVE":
FClueNo = CZ_GetValue("FClueID");
if (FClueNo != "")
{
//反写线索状态为已转化商机
string sql = String.Format("update ora_CRM_Clue set FClueStatus=3 where FBillNo='{0}'", FClueNo);
CZDB_GetData(sql);
}
break;
case "SUBMIT":
FClueNo = CZ_GetValue("FClueID");
if (FClueNo != "")
{
//反写线索状态为已转化商机
string sql = String.Format("update ora_CRM_Clue set FClueStatus=3 where FBillNo='{0}'", FClueNo);
CZDB_GetData(sql);
}
break;
}
}
}
public override void AfterDoOperation(AfterDoOperationEventArgs e)
{
base.AfterDoOperation(e);
var date = this.Model.DataObject["Date"].ToString();
this.View.UpdateView();
this.View.ShowMessage(date);
}
public override void AfterDoOperation(AfterDoOperationEventArgs e)
{
base.AfterDoOperation(e);
switch (e.Operation.Operation.ToUpper())
{
case "CEOTEPI":
ExecuteOperate(this.Context);
break;
}
}
public override void AfterDoOperation(AfterDoOperationEventArgs e)
{
base.AfterDoOperation(e);
string op = e.Operation.Operation.ToUpperInvariant();
switch (op)
{
case "SAVE":
//Jump2Audit();
break;
}
}
public override void AfterDoOperation(AfterDoOperationEventArgs e)
{
base.AfterDoOperation(e);
string key = e.Operation.Operation.ToUpperInvariant();
switch (key)
{
case "SUBMIT":
Act_CreateBillRelation();
break;
}
}
public override void AfterDoOperation(AfterDoOperationEventArgs e)
{
base.AfterDoOperation(e);
if (e.Operation.Operation.CompareTo(SynOperationType.AUDIT.ToString()) == 0 && e.ExecuteResult)
{
IEnumerable <AbsSynchroDataInfo> custs = GetK3Datas(this.Context);
IEnumerable <AbsSynchroDataInfo> synCusts = NeedSynchro2HC(custs);
SynK3Datas2HC(this.Context, synCusts);
UpdateDiscountRate(this.Context, custs);
}
}
/// <summary>
/// 单据持有事件发生后需要完成的功能
/// </summary>
/// <param name="e"></param>
public override void AfterDoOperation(AfterDoOperationEventArgs e)
{
switch (e.Operation.Operation.ToUpperInvariant())
{
//case "SAVE": 表单定义的事件都可以在这里执行，需要通过事件的代码[大写]区分不同事件
//break;
case "":
break;
default:
break;
}
}
public override void AfterDoOperation(AfterDoOperationEventArgs e)
{
base.AfterDoOperation(e);
string opKey = e.Operation.Operation.ToUpperInvariant();
switch (opKey)
{
case "SAVE":
CZ_DoFileUpLoad();
break;
case "SUBMIT":
CZ_DoFileUpLoad();
break;
}
}
public override void AfterDoOperation(AfterDoOperationEventArgs e)
{
base.AfterDoOperation(e);
string oper = e.Operation.Operation;
if (!string.IsNullOrWhiteSpace(oper))
{
if (e.ExecuteResult)
{
IEnumerable <AbsSynchroDataInfo> datas = null;
if (oper.ToUpper().CompareTo(SynOperationType.AUDIT.ToString()) == 0 || oper.ToUpper().CompareTo(SynOperationType.FORBID.ToString()) == 0 ||
oper.ToUpper().CompareTo(SynOperationType.ENABLE.ToString()) == 0 || oper.ToUpper().CompareTo(SynOperationType.DELETE.ToString()) == 0)
{
datas = GetK3Datas(this.Context);
}
if (datas != null && datas.Count() > 0)
{
if (oper.ToUpper().CompareTo(SynOperationType.AUDIT.ToString()) == 0)
{
datas = datas.Select(d => (Material)d).ToList().Where(m => m.FDocumentStatus.CompareTo("C") == 0).ToList();
BatchSynK3Datas2HC(this.Context, datas, batch);
UpdateMaterialInfo(this.Context, datas);
}
else if (oper.ToUpper().CompareTo(SynOperationType.FORBID.ToString()) == 0)
{
datas = datas.Select(d => (Material)d).ToList().Where(m => m.FForbidStatus.CompareTo("A") == 0).ToList();
BatchSynK3Datas2HC(this.Context, datas, batch);
UpdateMaterialInfo(this.Context, datas);
}
else if (oper.ToUpper().CompareTo(SynOperationType.ENABLE.ToString()) == 0)
{
datas = datas.Select(d => (Material)d).ToList().Where(m => m.FForbidStatus.CompareTo("B") == 0).ToList();
BatchSynK3Datas2HC(this.Context, datas, batch);
UpdateMaterialInfo(this.Context, datas);
}
if (oper.ToUpper().CompareTo(SynOperationType.DELETE.ToString()) == 0)
{
datas = datas.Select(d => (Material)d).ToList().Where(m => m.FForbidStatus.CompareTo("C") == 0).ToList();
BatchSynK3Datas2HC(this.Context, delDatas, batch);
}
}
}
}
}
public override void AfterDoOperation(AfterDoOperationEventArgs e)
{
base.AfterDoOperation(e);
string op = e.Operation.Operation.ToUpperInvariant();
switch (op)
{
case "SUBMIT":
string Flag = this.View.OpenParameter.GetCustomParameter("Flag") == null ? "" : this.View.OpenParameter.GetCustomParameter("Flag").ToString();
if (Flag == "ADD")
{
//如果是下推生成的单据，则建立起它们的关联关系
CreateBillRelation();
}
break;
}
}
public override void AfterDoOperation(AfterDoOperationEventArgs e)
{
base.AfterDoOperation(e);
CZ_DoFileUpLoad();
string opKey = e.Operation.Operation.ToUpperInvariant();
switch (opKey)
{
case "SUBMIT":
string FID = this.View.BillModel.DataObject["Id"].ToString();
Act_CreateDefaultContract(FID);
this.View.ShowMessage("提交成功！", MessageBoxOptions.OK, (result) =>
{
this.View.Close();
});
break;
}
}
public override void AfterDoOperation(AfterDoOperationEventArgs e)
{
base.AfterDoOperation(e);
string op = e.Operation.Operation.ToUpperInvariant();
switch (op)
{
case "SUBMIT":
//如果是下推生成的单据，则建立起它们的关联关系
CreateBillRelation();
CheckRptChanged();
break;
case "SAVE":
//如果是下推生成的单据，则建立起它们的关联关系
CreateBillRelation();
break;
}
}
/// <summary>
/// 单据持有事件发生后需要完成的功能
/// </summary>
/// <param name="e"></param>
public override void AfterDoOperation(AfterDoOperationEventArgs e)
{
string _opKey = e.Operation.Operation.ToUpperInvariant();
switch (_opKey)
{
//case "SAVE": 表单定义的事件都可以在这里执行，需要通过事件的代码[大写]区分不同事件
//break;
case "AUDIT": //操作代码 Audit
Act_ABO_AfterAudit(e);
break;
case "UNAUDIT": //操作代码 UnAudit
Act_ABO_AfterAudit(e);
break;
default:
break;
}
base.AfterDoOperation(e);
}
public override void AfterDoOperation(AfterDoOperationEventArgs e)
{
}
public override void AfterDoOperation(AfterDoOperationEventArgs e)
{
base.AfterDoOperation(e);
}
/// <summary>
/// 操作事件后 审核 执行后
/// </summary>
/// <param name="e"></param>
private void Act_ABO_AfterAudit(AfterDoOperationEventArgs e)
{
string _FSplitFlag = this.CZ_GetValue_DF("FSplitFlag", "0");
//if (_FSplitFlag != "1")
//{
// //仅转货款时有后续动作
// return;
//}
#region 原始SQL语句 2020-04-23 此SQL语句已校验
/*
* ----复写手工记帐单 已收款金额\r\n Spilt｜Split
* --select d.FReceiptEID,je.F_Ora_SpiltAmount,isnull(d.FSplitAmt,0),je.F_Ora_SpiltAmountFor,j.FExchangeRate*isnull(d.FSplitAmt,0)
* update je set je.F_Ora_SpiltAmount=isnull(d.FSplitAmt,0),je.F_Ora_SpiltAmountFor=j.FExchangeRate*isnull(d.FSplitAmt,0)
* from(select FReceiptEID from T_CZ_ReceiptSplitDetail where FID=100005)z
* inner join T_CN_JOURNALENTRY je on z.FReceiptEID=je.FEntryID inner join T_CN_JOURNAL j on je.FID=j.FID
* left join(select z.FReceiptEID,sum(r.FSplitAmt)FSplitAmt
* from(select FReceiptEID from T_CZ_ReceiptSplitDetail where FID=100005)z
* inner join T_CZ_ReceiptSplitDetail rd on z.FReceiptEID=rd.FReceiptEID
* inner join T_CZ_ReceiptSplit r on rd.FID=r.FID and r.FDocumentStatus='C'
* group by z.FReceiptEID )d on z.FReceiptEID=d.FReceiptEID ;
*
* ----复写销售订单收款计划 已收款金额 \r\n
* --select op.FEntryID,op.F_Ora_SplitAmount,isnull(d.FSplitAmount,0),F_Ora_SplitAmountFor,isnull(d.FSplitAmountFor,0)
* update op set op.F_Ora_SplitAmount=isnull(d.FSplitAmount,0),op.FRecAmount=isnull(d.FSplitAmount,0),F_Ora_SplitAmountFor=isnull(d.FSplitAmountFor,0)
* from(select FOrderPlanEID from T_CZ_ReceiptSplitOrderPlan where FID=100005)z
* inner join t_Sal_OrderPlan op on z.FOrderPlanEID=op.FEntryID
* left join(select z.FOrderPlanEID,sum(rp.FSplitAmount)FSplitAmount,sum(FSplitAmountFor)FSplitAmountFor
* from(select FOrderPlanEID from T_CZ_ReceiptSplitOrderPlan where FID=100005)z
* inner join T_CZ_ReceiptSplitOrderPlan rp on z.FOrderPlanEID=rp.FOrderPlanEID
* inner join T_CZ_ReceiptSplit r on rp.FID=r.FID and r.FDocumentStatus='C'
* group by z.FOrderPlanEID )d on z.FOrderPlanEID=d.FOrderPlanEID
*/
#endregion
string _FID = this.CZ_GetFormID();
StringBuilder _sb = new StringBuilder();
_sb.Append("/*dialect*/");
//----复写手工记帐单 已收款金额
//--select d.FReceiptEID,je.F_Ora_SpiltAmount,isnull(d.FSplitAmt,0),je.F_Ora_SpiltAmountFor,j.FExchangeRate*isnull(d.FSplitAmt,0)
_sb.Append("update je set je.F_Ora_SplitAmount=isnull(d.FSplitAmt,0),je.F_Ora_SplitAmountFor=j.FExchangeRate*isnull(d.FSplitAmt,0) ");
_sb.Append("from(select FReceiptEID from T_CZ_ReceiptSplitDetail where FID=" + _FID + ")z ");
_sb.Append("inner join T_CN_JOURNALENTRY je on z.FReceiptEID=je.FEntryID inner join T_CN_JOURNAL j on je.FID=j.FID ");
_sb.Append("left join(select z.FReceiptEID,sum(r.FSplitAmt)FSplitAmt ");
_sb.Append("from(select FReceiptEID from T_CZ_ReceiptSplitDetail where FID=" + _FID + ")z ");
_sb.Append("inner join T_CZ_ReceiptSplitDetail rd on z.FReceiptEID=rd.FReceiptEID ");
_sb.Append("inner join T_CZ_ReceiptSplit r on rd.FID=r.FID and r.FDocumentStatus='C' ");
_sb.Append("group by z.FReceiptEID )d on z.FReceiptEID=d.FReceiptEID ;");
//----复写销售订单收款计划 已收款金额
//--select op.FEntryID,op.F_Ora_ReceiveAmount,isnull(d.FSplitAmount,0),F_Ora_ReceiveAmountFor,isnull(d.FSplitAmountFor,0)
//_sb.Append("update op set op.F_Ora_SplitAmount=isnull(d.FSplitAmount,0),op.FRecAmount=isnull(d.FSplitAmount,0), ");
//_sb.Append("F_Ora_SplitAmountFor=isnull(d.FSplitAmountFor,0) ");
_sb.Append("update op set op.F_Ora_SplitAmount=isnull(d.FSplitAmount,0),F_Ora_SplitAmountFor=isnull(d.FSplitAmountFor,0) ");
_sb.Append("from(select FOrderPlanEID from T_CZ_ReceiptSplitOrderPlan where FID=" + _FID + ")z ");
_sb.Append("inner join t_Sal_OrderPlan op on z.FOrderPlanEID=op.FEntryID ");
_sb.Append("left join(select z.FOrderPlanEID,sum(rp.FSplitAmount)FSplitAmount,sum(FSplitAmountFor)FSplitAmountFor ");
_sb.Append("from(select FOrderPlanEID from T_CZ_ReceiptSplitOrderPlan where FID=" + _FID + ")z ");
_sb.Append("inner join T_CZ_ReceiptSplitOrderPlan rp on z.FOrderPlanEID=rp.FOrderPlanEID ");
_sb.Append("inner join T_CZ_ReceiptSplit r on rp.FID=r.FID and r.FDocumentStatus='C' ");
_sb.Append("group by z.FOrderPlanEID )d on z.FOrderPlanEID=d.FOrderPlanEID ");
try
{
DBServiceHelper.Execute(base.Context, _sb.ToString());
}
catch (Exception ex)
{
this.View.ShowErrMessage("执行更新发生错误");
}
}
