public override void BeginOperationTransaction(BeginOperationTransactionArgs e)
{
base.BeginOperationTransaction(e);
if (e.DataEntitys.Count <DynamicObject>() != 0)
{
List <int> list = new List <int>();
BudgetAdjustService service = new BudgetAdjustService();
Dictionary <int, IOperationResult> dictionary = new Dictionary <int, IOperationResult>();
foreach (DynamicObject obj2 in e.DataEntitys)
{
int fid = Convert.ToInt32(obj2["Id"]);
IOperationResult result = service.BuildBugdetAdjustReport(base.Context, fid);
if (result.IsSuccess)
{
list.Add(fid);
if (result.SuccessDataEnity != null)
{
obj2["Report"] = (result.SuccessDataEnity as List <DynamicObject>)[0]["SampleID_Id"];
}
}
dictionary.Add(fid, result);
}
this.UpdatebudgetValue(e);
}
}
public override void BeginOperationTransaction(BeginOperationTransactionArgs e)
{
base.BeginOperationTransaction(e);
if (e.DataEntitys == null)
{
return;
}
List <long> lstPkIds = new List <long>();
foreach (DynamicObject billDataEntity in e.DataEntitys)
{
lstPkIds.Add(Convert.ToInt64(billDataEntity["Id"]));
}
if (lstPkIds == null || lstPkIds.Count == 0)
{
return;
}
string sql = string.Format(@" SELECT t.FBILLNO, t.FID,t1.FENTRYID,t1.FSEQ, FStockOrgId AS FSTOCKORGID, FKeeperTypeId AS FKEEPERTYPEID, FKEEPERID AS FKEEPERID,
t1.FOwnerTypeId AS FOWNERTYPEID, t1.FOWNERID AS FOWNERID, FStockId AS FSTOCKID,
FStockLocId AS FSTOCKPLACEID, TM.FMASTERID AS FMATERIALID, FAUXPROPID AS FAUXPROPERTYID,
FSTOCKSTATUSID AS FSTOCKSTATUSID, FLOT AS FLOT, FPRODUCEDATE AS FPRODUCTDATE,
FEXPIRYDATE AS FVALIDATETO, FBOMID AS FBOMID, FMTONO AS FMTONO,FPROJECTNO AS FPROJECTNO,
FBaseActualQty AS FBASEQTY, FBASEUNITID AS FBASEUNITID, FSecActualQty AS FSECQTY, FSECUNITID AS FSECUNITID,FUNITID AS FUNITID,t2.FACTUALQTY AS FQTY
FROM T_PRD_FEEDMTRL t INNER JOIN T_PRD_FEEDMTRLDATA t1 ON t.FID=t1.FID
INNER JOIN T_PRD_FEEDMTRLDATA_Q t2 ON t1.FENTRYID=t2.FENTRYID
inner join T_BD_MATERIAL TM on t1.FMATERIALID=TM.FMATERIALID
WHERE t.FID in ({0}) ", string.Join(",", lstPkIds));
Common.LockCommon.LockInventory(this.Context, this.OperationResult, sql, "PRD_FeedMtrl");
this.OperationResult.IsShowMessage = true;
}
public override void BeginOperationTransaction(BeginOperationTransactionArgs e)
{
base.BeginOperationTransaction(e);
if (e.DataEntitys == null)
{
return;
}
List <long> lstPkIds = new List <long>();
foreach (DynamicObject billDataEntity in e.DataEntitys)
{
lstPkIds.Add(Convert.ToInt64(billDataEntity["Id"]));
}
if (lstPkIds == null || lstPkIds.Count == 0)
{
return;
}
string sql = string.Format(@" SELECT t.FBILLNO, t.FID,t1.FENTRYID,t1.FSEQ, FSTOCKOUTORGID AS FSTOCKORGID, FKEEPERTYPEOUTID AS FKEEPERTYPEID, FKEEPEROUTID AS FKEEPERID,
t1.FOWNERTYPEOUTID AS FOWNERTYPEID, t1.FOWNEROUTID AS FOWNERID, FSRCSTOCKID AS FSTOCKID,
FSRCSTOCKLOCID AS FSTOCKPLACEID, TM.FMASTERID AS FMATERIALID, FAUXPROPID AS FAUXPROPERTYID,
FSRCSTOCKSTATUSID AS FSTOCKSTATUSID, FLOT AS FLOT, FPRODUCEDATE AS FPRODUCTDATE,
FEXPIRYDATE AS FVALIDATETO, FBOMID AS FBOMID, FMTONO AS FMTONO,FPROJECTNO AS FPROJECTNO,
FBASEQTY AS FBASEQTY, FBASEUNITID AS FBASEUNITID, FSECQTY AS FSECQTY, FSECUNITID AS FSECUNITID,FUNITID AS FUNITID,t1.FQTY AS FQTY
FROM T_STK_STKTRANSFERIN t INNER JOIN T_STK_STKTRANSFERINENTRY t1 ON t.FID=t1.FID
inner join T_BD_MATERIAL TM on t1.FMATERIALID=TM.FMATERIALID
WHERE t.FID in ({0}) ", string.Join(",", lstPkIds));
Common.LockCommon.LockInventory(this.Context, this.OperationResult, sql, "STK_TransferDirect");
this.OperationResult.IsShowMessage = true;
}
public override void BeginOperationTransaction(BeginOperationTransactionArgs e)
{
try
{
if (e.DataEntitys != null && e.DataEntitys.Count <DynamicObject>() > 0)
{
foreach (DynamicObject item in e.DataEntitys)
{
string sql = string.Empty;
//销售出库单id
string Fid = item["Id"].ToString();
sql += string.Format(@"/*dialect*/ update T_SAL_OUTSTOCKENTRY set FTotalARFNOTAXAMOUNTFOR=FAMOUNT,FTotalARFALLAMOUNTFOR=FALLAMOUNT
from T_SAL_OUTSTOCKENTRY a inner join T_SAL_OUTSTOCKENTRY_F b on b.FENTRYID=a.FENTRYID where a.FID={0} and FTotalARFNOTAXAMOUNTFOR=0", Fid);
sql += string.Format(@"/*dialect*/ update T_SAL_OUTSTOCK set FTotalARFNOTAXAMOUNTFOR_H=FBILLAMOUNT_LC,FTotalARFALLAMOUNTFOR_H=FBILLALLAMOUNT_LC from
T_SAL_OUTSTOCK a inner join T_SAL_OUTSTOCKFIN b on a.fid=b.fid where a.FID={0} and FTotalARFNOTAXAMOUNTFOR_H=0", Fid);
//更新销售出库单
DBServiceHelper.Execute(Context, sql);
}
}
}
catch (Exception ex)
{
throw new KDException("", "保存失败：" + ex.ToString());
}
}
public override void BeginOperationTransaction(BeginOperationTransactionArgs e)
{
base.BeginOperationTransaction(e);
if (e.DataEntitys == null)
{
return;
}
List <long> lstPkIds = new List <long>();
foreach (DynamicObject billDataEntity in e.DataEntitys)
{
lstPkIds.Add(Convert.ToInt64(billDataEntity["Id"]));
}
if (lstPkIds == null || lstPkIds.Count == 0)
{
return;
}
string sql = string.Format(@"select TKE.FENTRYID as Id,TKE.FSUPPLYINTERID as FInvDetailID,TKH.FDEMANDENTRYID as BillDetailID,TKE.FBASEQTY as FBASEQTY,TKE.FSECQTY as FSECQTY
from T_PLN_RESERVELINKENTRY TKE
inner join T_PLN_RESERVELINK TKH on TKE.FID = TKH.FID
inner join T_STK_INVENTORY TV on TKE.FSUPPLYINTERID = TV.FID and TKE.FSUPPLYFORMID = 'STK_Inventory'
inner join T_SAL_OUTSTOCKENTRY BP on TKH.FDEMANDENTRYID = BP.FEntryID
inner join T_SAL_OUTSTOCK TB on BP.FID = TB.FID and TKH.FDEMANDBILLNO = TB.FBILLNO
where TKH.FSRCFORMID='SAL_OUTSTOCK'
AND BP.FID in({0})" , string.Join(",", lstPkIds));
DynamicObjectCollection dyUnLockInfo = DBUtils.ExecuteDynamicObject(this.Context, sql);
Common.LockCommon.UnLockInventory(this.Context, dyUnLockInfo, "SAL_OUTSTOCK");
this.OperationResult.IsShowMessage = true;
}
public override void BeginOperationTransaction(BeginOperationTransactionArgs e)
{
base.BeginOperationTransaction(e);
if (IsUsingBdgSys())
{
InsertFlow(e);
}
}
public override void BeginOperationTransaction(BeginOperationTransactionArgs e)
{
if (((e.DataEntitys != null) && (e.DataEntitys.Length > 0)) && (e.DataEntitys[0]["BudgetCalendarType"].ToString() == "1"))
{
DynamicObject obj2 = e.DataEntitys[0]["ACId"] as DynamicObject;
if (obj2 != null)
{
e.DataEntitys[0]["StartDate"] = obj2["STARTDATE"];
e.DataEntitys[0]["EndDate"] = obj2["ENDDATE"];
}
}
}
public override void BeginOperationTransaction(BeginOperationTransactionArgs e)
{
base.BeginOperationTransaction(e);
DynamicObject obj2 = this.CreateLogDy(base.Context, e);
if (obj2 != null)
{
BudgetCtrlLog log = new BudgetCtrlLog(base.Context);
List <int> ruleIds = (from dy in e.DataEntitys select dy.GetDynamicObjectItemValue <int>("Id", 0)).ToList <int>();
log.UpdateLogForRule(ruleIds);
log.SaveLogByDys(new DynamicObject[] { obj2 });
}
}
/// <summary>
/// 操作开始前功能处理
/// </summary>
/// <param name="e"></param>
public override void BeginOperationTransaction(BeginOperationTransactionArgs e)
{
foreach (DynamicObject o in e.DataEntitys)
{
string strSql = string.Format("SELECT A.F_PCQE_TSSDID,A.F_PCQE_SDBTG,A.F_PCQE_SDTG,A.F_PCQE_SDXZG,A.F_PCQE_WXSD,B.F_PCQE_ZGYJ FROM PCQE_T_TSSSD A LEFT JOIN PCQE_T_TSSSD_L B ON A.FID = B.FID AND B.FLocaleID=2052 AND A.FID = '{0}'", Convert.ToInt64(o["ID"].ToString()));
DynamicObjectCollection obj = DBUtils.ExecuteDynamicObject(this.Context, strSql);
DynamicObject tempobj = obj[0];
strSql = "Update PCQE_t_TSSDJSJ SET F_PCQE_WSD =0, F_PCQE_SDBTG='" + tempobj["F_PCQE_SDBTG"].ToString() + "'," +
"F_PCQE_SDTG='" + tempobj["F_PCQE_SDTG"].ToString() + "'," +
"F_PCQE_SDXZG='" + tempobj["F_PCQE_SDXZG"].ToString() + "'," +
"F_PCQE_WXSD='" + tempobj["F_PCQE_WXSD"].ToString() + "' WHERE FID=" + Convert.ToInt32(tempobj["F_PCQE_TSSDID"]) +
" Update PCQE_t_TSSDJSJ_L SET F_PCQE_ZGYJ='" + tempobj["F_PCQE_ZGYJ"].ToString() + "' WHERE FLocaleID=2052 AND FID=" + Convert.ToInt32(tempobj["F_PCQE_TSSDID"]);
DBUtils.Execute(this.Context, strSql);
}
}
/// <summary>
/// 区域订货
/// 有区域门店订货
/// 无区域门店订货
/// 营建订货
/// </summary>
/// <param name="e"></param>
public override void BeginOperationTransaction(BeginOperationTransactionArgs e)
{
base.BeginOperationTransaction(e);
if (e.DataEntitys != null && e.DataEntitys.Count() > 0)
{
foreach (DynamicObject dataEntity in e.DataEntitys)
{
long ApplicationOrgId = Convert.ToInt64(dataEntity["ApplicationOrgId_Id"]); //申请组织ID
Customer cust = XSXServiceHelper.XSXServiceHelper.GetIntCustomerProperty(this.Context, ApplicationOrgId);
DynamicObject custObject = XSXServiceHelper.XSXServiceHelper.GetBasicObject(this.Context, "BD_Customer", cust.custID); //申请客户
DynamicObject BelongCust = cust.BelongCustID > 0 ? XSXServiceHelper.XSXServiceHelper.GetBasicObject(this.Context, "BD_Customer", cust.BelongCustID) : null;
//DynamicObject BelongCust = XSXServiceHelper.XSXServiceHelper.GetBasicObject(this.Context, "BD_Customer", cust.BelongCustID);//服务端获取所属区域对象
DynamicObject CustType = XSXServiceHelper.XSXServiceHelper.GetBasicObject(this.Context, "PAEZ_CUSTTYPE", cust.CustTypeID); //服务端获取客户类别
DynamicObject Brand = XSXServiceHelper.XSXServiceHelper.GetBasicObject(this.Context, "ORG_Organizations", cust.BrandID); //服务端获取所属品牌对象,组织基础资料
DynamicObject Region = XSXServiceHelper.XSXServiceHelper.GetBasicObject(this.Context, "PAEZ_REGION", cust.RegionID); //服务端获取所属大区对象
DynamicObject OrgType = ((DynamicObject)dataEntity["ApplicationOrgId"])["FORGTYPE"] as DynamicObject; //组织类型
dataEntity["FApplyCust"] = custObject;
dataEntity["FApplyCust_Id"] = cust.custID;
if (BelongCust != null)
{
dataEntity["FBelongCust"] = BelongCust;
dataEntity["FBelongCust_Id"] = cust.BelongCustID;
}
dataEntity["FCUSTTYPE"] = CustType;
dataEntity["FCUSTTYPE_Id"] = cust.CustTypeID;
dataEntity["FORGTYPE"] = OrgType;
dataEntity["FORGTYPE_Id"] = Convert.ToInt64(OrgType["Id"]);
dataEntity["FSHBRAND"] = Brand;
dataEntity["FSHBRAND_Id"] = cust.BrandID;
dataEntity["FSHREGION"] = Region;
dataEntity["FSHREGION_Id"] = cust.RegionID;
////客户类型：区域客户QY，组织类型：区域QY
//if (Convert.ToString(CustType["Number"]).Equals("QY")&&Convert.ToString(OrgType["Number"]).Equals("QY"))
//{
// //收款用途：订货保证金：No,SFKYT004 Id:108875 *************按照实际情况进行修改***********
// //组织类型：生产：No，SC，ID：108867 *************按照实际情况进行修改***********
// dataEntity["FOrderAmount"] = XSXServiceHelper.XSXServiceHelper.GetQYAmount(this.Context, cust.custNo);
//}
////客户类型：门店客户MD，组织类型：门店MD
//if (Convert.ToString(CustType["Number"]).Equals("MD01") && Convert.ToString(OrgType["Number"]).Equals("MD01"))
//{
// dataEntity["FOrderAmount"] = XSXServiceHelper.XSXServiceHelper.GetMDAmount(this.Context,cust.custNo, cust.custID);
//}
}
}
}
public override void BeginOperationTransaction(BeginOperationTransactionArgs e)
{
base.BeginOperationTransaction(e);
//using (KDTransactionScope scope = new KDTransactionScope(TransactionScopeOption.Required))
//{
string strSql = "INSERT INTO t_demo_purServTest(FID,FNAME,FCREATEDATE) VALUES(@ID,@NAME,@CREATEDATE)";
List <SqlParam> paras = new List <SqlParam> {
new SqlParam("@ID", KDDbType.Int32, DateTime.Now.Second),
new SqlParam("@Name", KDDbType.String, "BeginOperationTransaction"),
new SqlParam("@CREATEDATE", KDDbType.DateTime, DateTime.Now)
};
DBUtils.Execute(this.Context, strSql, paras);
// scope.Complete();
// throw new Exception("新建事务抛出异常");
//}
}
public override void BeginOperationTransaction(BeginOperationTransactionArgs e)
{
base.BeginOperationTransaction(e);
if (e.DataEntitys != null && e.DataEntitys.Count() > 0)
{
foreach (DynamicObject item in e.DataEntitys)
{
DynamicObjectCollection SRCENTRY = item["PAYBILLSRCENTRY"] as DynamicObjectCollection;
DynamicObjectCollection ENTRY = item["PAYBILLENTRY"] as DynamicObjectCollection;
if (SRCENTRY != null && SRCENTRY.Count() > 0)
{
ENTRY[0]["OpenAddressRec"] = Convert.ToString(SRCENTRY[0]["FBankAddr"]) != null && !Convert.ToString(SRCENTRY[0]["FBankAddr"]).Equals(" ") ? Convert.ToString(SRCENTRY[0]["FBankAddr"]) : string.Empty;
ENTRY[0]["CNAPS"] = Convert.ToString(SRCENTRY[0]["FBankCode"]) != null && !Convert.ToString(SRCENTRY[0]["FBankCode"]).Equals(" ") ? Convert.ToString(SRCENTRY[0]["FBankCode"]) : string.Empty;
ENTRY[0]["BankTypeRec"] = (DynamicObject)SRCENTRY[0]["FDueBank"] != null ? (DynamicObject)SRCENTRY[0]["FDueBank"] : null;
}
}
}
}
public override void BeginOperationTransaction(BeginOperationTransactionArgs e)
{
DynamicObjectCollection allCustomFunctions = new BudgetFormulaService().GetAllCustomFunctions(base.Context);
foreach (DynamicObject obj2 in e.DataEntitys)
{
string input = Convert.ToString(obj2["Express"]).ToLowerInvariant();
List <string> values = new List <string>();
foreach (DynamicObject obj3 in allCustomFunctions)
{
Regex regex = new Regex(string.Format(@"\s*({0})\s*\(", Convert.ToString(obj3["FNumber"])), RegexOptions.IgnoreCase);
if (regex.Match(input).Success)
{
values.Add("_" + Convert.ToString(obj3["FID"]) + "_");
}
}
obj2["FunctionIds"] = string.Join(",", values);
}
}
private DynamicObject CreateLogDy(Context ctx, BeginOperationTransactionArgs e)
{
DynamicObject obj2 = null;
if (e.DataEntitys.Count <DynamicObject>() <= 0)
{
return(obj2);
}
FormMetadata metadata = ServiceHelper.GetService <IMetaDataService>().Load(ctx, "BM_BUDGETCTRLLOG", true) as FormMetadata;
BusinessInfo businessInfo = metadata.BusinessInfo;
DynamicObject obj3 = (DynamicObject)metadata.BusinessInfo.GetDynamicObjectType().CreateInstance();
obj3["BillFormID_Id"] = " ";
obj3["FBillNo"] = " ";
obj3["OperationId"] = 3;
obj3["OperationNumber"] = "Delete";
obj3["FCreateDate"] = DateTime.Now;
obj3["FCreatorId_Id"] = ctx.UserId;
obj3["Description"] = ResManager.LoadKDString("预算控制规则-删除", "0032056000021791", SubSystemType.FIN, new object[0]);
int num = 1;
string str = ResManager.LoadKDString("预算控制规则删除", "0032056000021794", SubSystemType.FIN, new object[0]);
string format = ResManager.LoadKDString("预算控制规则:{0}[{1}]删除", "0032056000021795", SubSystemType.FIN, new object[0]);
foreach (DynamicObject obj4 in e.DataEntitys)
{
DynamicObjectCollection objects = obj3["LOGENTITY"] as DynamicObjectCollection;
DynamicObject item = objects.DynamicCollectionItemPropertyType.CreateInstance() as DynamicObject;
item["SEQ"] = num++;
int num2 = obj4.GetDynamicObjectItemValue <int>("Id", 0);
string name = this.GetName(obj4.GetDynamicObjectItemValue <LocaleValue>("name", null));
item["RuleID"] = num2;
item["RuleName"] = name;
item["LogTime"] = DateTime.Now;
item["Descriptions"] = str;
item["Detailed"] = string.Format(format, name, num2);
item["Level"] = 0;
item["LogType"] = 100.ToString();
objects.Add(item);
}
return(obj3);
}
//操作初始化时确认操作执行参数
public override void BeginOperationTransaction(BeginOperationTransactionArgs e)
{
base.BeginOperationTransaction(e);
string strSql = string.Format(@"/*dialect*/select A.FSTOCKSTATUSID from t_BD_StockStatus A inner join t_Bd_Stockstatus_l B on A.FSTOCKSTATUSID = B.FSTOCKSTATUSID where B.FNAME = '不参与核算'");
long result = DBUtils.ExecuteScalar <long>(base.Context, strSql, -1, null);
DynamicObject[] entitys = e.DataEntitys;
if (result > 0)
{
IMetaDataService metaService = ServiceHelper.GetService <IMetaDataService>(); //元数据服务
IViewService view = ServiceHelper.GetService <IViewService>(); //界面服务
FormMetadata Meta = metaService.Load(base.Context, "BD_StockStatus") as FormMetadata; //获取基础资料元数据
BasicObject = view.LoadSingle(base.Context, result, Meta.BusinessInfo.GetDynamicObjectType()); //不参与核算的库存状态ID
}
foreach (DynamicObject entity in entitys)
{//FSTOCKSTATUSID库存状态 编码 07040000 07040004
if (entity != null)
{
DynamicObjectCollection entityInfo = entity["TransferDirectEntry"] as DynamicObjectCollection;
for (int i = 0; i < entityInfo.Count; i++)
{
DynamicObject material = entityInfo[i]["MATERIALID"] as DynamicObject;
if (material["Number"].Equals("07040000") || material["Number"].Equals("07040004"))
{
if (BasicObject != null)
{
//string updateStr = string.Format(@"/*dialect*/Update T_STK_MISCELLANEOUSENTRY set FSTOCKSTATUSID = {0} where fentryid = {1}", result, Convert.ToInt64(entityInfo[i]["Id"]));
//DBUtils.Execute(base.Context, updateStr);
entityInfo[i]["SrcStockStatusId"] = BasicObject;
entityInfo[i]["SrcStockStatusId_Id"] = result;
entityInfo[i]["DestStockStatusId"] = BasicObject;
entityInfo[i]["DestStockStatusId_Id"] = result;
}
}
}
}
}
}
public override void BeginOperationTransaction(BeginOperationTransactionArgs e)
{
base.BeginOperationTransaction(e);
if (e.DataEntitys != null && e.DataEntitys.Count() > 0)
{
foreach (DynamicObject dataEntity in e.DataEntitys)
{
long StockOrgId = Convert.ToInt64(dataEntity["StockOrgId_Id"]); //退货组织ID
Customer cust = XSXServiceHelper.XSXServiceHelper.GetIntCustomerProperty(this.Context, StockOrgId);
DynamicObject custObject = XSXServiceHelper.XSXServiceHelper.GetBasicObject(this.Context, "BD_Customer", cust.custID); //申请客户
DynamicObject BelongCust = XSXServiceHelper.XSXServiceHelper.GetBasicObject(this.Context, "BD_Customer", cust.BelongCustID); //服务端获取所属区域对象
DynamicObject CustType = XSXServiceHelper.XSXServiceHelper.GetBasicObject(this.Context, "PAEZ_CUSTTYPE", cust.CustTypeID); //服务端获取所属区域对象//客户类别
DynamicObject OrgType = ((DynamicObject)dataEntity["ApplicationOrgId"])["FORGTYPE"] as DynamicObject; //组织类型
dataEntity["FApplyCust"] = custObject;
dataEntity["FApplyCust_Id"] = cust.custID;
dataEntity["FBelongCust"] = BelongCust;
dataEntity["FBelongCust_Id"] = cust.BelongCustID;
dataEntity["FCUSTTYPE"] = CustType;
dataEntity["FCUSTTYPE_Id"] = cust.CustTypeID;
dataEntity["FORGTYPE"] = OrgType;
dataEntity["FORGTYPE_Id"] = Convert.ToInt64(OrgType["Id"]);
}
}
}
public override void BeginOperationTransaction(BeginOperationTransactionArgs e)
{
base.BeginOperationTransaction(e);
var billIds = e.DataEntitys.Select(data => data.PkId()).ToArray();
var connectorService = PHMSWMSServiceFactory.Instance.GetLocalService <IConnectorService>();
var args = connectorService.GetGenTargetSource(this.Context, GenTargetSourceSqlFromOutNotice.Instance, this.BusinessInfo.GetForm().Id, billIds);
if (!args.Any())
{
throw new KDBusinessException(string.Empty, "未获取到回撤目标单据的数据源！");
}//end if
var op = connectorService.Pull(this.Context, args);
this.OperationResult.MergeResult(op);
//标记生成状态。
var dataEntities = args.Join(e.DataEntitys,
left => left.BillId.ToChangeType <long>(),
right => right.PkId <long>(),
(left, right) => right).ToArray();
connectorService.MarkGenStatus(this.Context, this.BusinessInfo, e.DataEntitys, LogicStatus.Instance.No());
}
/// <summary>
/// 操作开始前功能处理
/// </summary>
/// <param name="e"></param>
public override void BeginOperationTransaction(BeginOperationTransactionArgs e)
{
base.BeginOperationTransaction(e);
UpdateSupplierId(e.DataEntitys.ToList <DynamicObject>());
}
} //end method
public override void BeginOperationTransaction(BeginOperationTransactionArgs e)
{
base.BeginOperationTransaction(e);
//保存
if (!e.CancelOperation &&
!e.CancelOperation &&
!this.Option.GetOutOfTransaction() &&
this.Option.GetCutoffOperation().Adaptive(number => number.IsNullOrEmptyOrWhiteSpace() ||
number.EqualsIgnoreCase(FormOperationEnum.Save.ToString()) ||
number.EqualsIgnoreCase(FormOperationEnum.Submit.ToString()) ||
number.EqualsIgnoreCase(FormOperationEnum.Audit.ToString())))
{
e.DataEntitys.Save(this.Context, this.BusinessInfo, this.Option).Adaptive(result =>
{
if (!result.IsSuccess)
{
e.CancelFormService = true;
e.CancelOperation = true;
this.OperationResult.MergeResult(result);
if (this.Option.GetThrowWhenUnSuccess())
{
this.OperationResult.ThrowWhenUnSuccess(false);
}
} //end if
});
} //end if
//提交
if (!e.CancelOperation &&
!e.CancelOperation &&
this.Option.GetCutoffOperation().Adaptive(number => number.IsNullOrEmptyOrWhiteSpace() ||
number.EqualsIgnoreCase(FormOperationEnum.Submit.ToString()) ||
number.EqualsIgnoreCase(FormOperationEnum.Audit.ToString())))
{
e.DataEntitys.Submit(this.Context, this.BusinessInfo, this.Option).Adaptive(result =>
{
if (!result.IsSuccess)
{
e.CancelFormService = true;
e.CancelOperation = true;
this.OperationResult.MergeResult(result);
if (this.Option.GetThrowWhenUnSuccess())
{
this.OperationResult.ThrowWhenUnSuccess(false);
}
} //end if
});
} //end if
//审核
if (!e.CancelOperation &&
!e.CancelOperation &&
this.Option.GetCutoffOperation().Adaptive(number => number.IsNullOrEmptyOrWhiteSpace() ||
number.EqualsIgnoreCase(FormOperationEnum.Audit.ToString())))
{
e.DataEntitys.Audit(this.Context, this.BusinessInfo, this.Option).Adaptive(result =>
{
if (!result.IsSuccess)
{
e.CancelFormService = true;
e.CancelOperation = true;
this.OperationResult.MergeResult(result);
if (this.Option.GetThrowWhenUnSuccess())
{
this.OperationResult.ThrowWhenUnSuccess(false);
}
} //end if
});
} //end if
} //end method
public override void BeginOperationTransaction(BeginOperationTransactionArgs e)
{
base.BeginOperationTransaction(e);
var documentStatusField = this.BusinessInfo.GetField(this.BusinessInfo.GetForm().DocumentStatusFieldKey).AsType <BillStatusField>();
//如果数据状态是审核中，需先执行撤销操作。
if (!e.CancelFormService && !e.CancelOperation)
{
var dataEntities = e.DataEntitys
.Where(data => data.FieldProperty <string>(documentStatusField).EqualsIgnoreCase(DocumentStatus.Instance.Approving()))
.ToArray();
if (dataEntities.Any())
{
dataEntities.CancelAssign(this.Context, this.BusinessInfo, this.Option).Adaptive(result =>
{
if (!result.IsSuccess)
{
e.CancelFormService = true;
e.CancelOperation = true;
this.OperationResult.MergeResult(result);
if (this.Option.GetThrowWhenUnSuccess())
{
this.OperationResult.ThrowWhenUnSuccess(false);
}
} //end if
});
} //end if
} //end if
//如果数据状态是已审核，需先执行反审核操作。
if (!e.CancelFormService && !e.CancelOperation)
{
var dataEntities = e.DataEntitys
.Where(data => data.FieldProperty <string>(documentStatusField).EqualsIgnoreCase(DocumentStatus.Instance.Approved()))
.ToArray();
if (dataEntities.Any())
{
dataEntities.UnAudit(this.Context, this.BusinessInfo, this.Option).Adaptive(result =>
{
if (!result.IsSuccess)
{
e.CancelFormService = true;
e.CancelOperation = true;
this.OperationResult.MergeResult(result);
if (this.Option.GetThrowWhenUnSuccess())
{
this.OperationResult.ThrowWhenUnSuccess(false);
}
} //end if
});
} //end if
} //end if
//删除
if (!e.CancelFormService && !e.CancelOperation)
{
e.DataEntitys.Delete(this.Context, this.BusinessInfo, this.Option).Adaptive(result =>
{
if (!result.IsSuccess)
{
e.CancelFormService = true;
e.CancelOperation = true;
this.OperationResult.MergeResult(result);
if (this.Option.GetThrowWhenUnSuccess())
{
this.OperationResult.ThrowWhenUnSuccess(false);
}
} //end if
});
} //end if
} //end method
private void UpdatebudgetValue(BeginOperationTransactionArgs e)
{
new BudgetAdjustService().UpdatebudgetValue(base.Context, e, false);
}
/// <summary>
/// 在此事件中给DataEntity本次操作数据包复制，可通过保存操作直接赋值到界面
/// </summary>
/// <param name="e"></param>
public override void BeginOperationTransaction(BeginOperationTransactionArgs e)
{
base.BeginOperationTransaction(e);
if (e.DataEntitys != null && e.DataEntitys.Count() > 0)
{
foreach (DynamicObject DataEntity in e.DataEntitys)
{
string WLUnitsType = Convert.ToString(DataEntity["CONTACTUNITTYPE"]);//往来单位类型
if (WLUnitsType.EqualsIgnoreCase("BD_Customer"))
{
/*
* 1.只要不是吉祥的门店，我们的逻辑都可以处理
* 2.如果是有区域的门店，需要调用GetCustomerProperty()方法获取所属区域并赋值
* 3.如果是没有区域的门店，需要调用GetWQYCustomerProperty()方法获取客户属性，部队所属区域赋值
* 4.根据账号用途进行收付款用途的判断赋值
* 5.根据不同收付款用途，进行业务类型的赋值
* 6.所有收款单自动进行提交审核。
* 7.只有有区域的门店加盟才进行费用申请的计提
*/
//判断是否是吉祥门店，非吉祥门店进行逻辑处理
if (!XSXServiceHelper.XSXServiceHelper.IsJXCust(this.Context, Convert.ToInt64(DataEntity["CONTACTUNIT_Id"])))
{
if (XSXServiceHelper.XSXServiceHelper.IsYQYCust(this.Context, Convert.ToInt64(DataEntity["CONTACTUNIT_Id"])) || XSXServiceHelper.XSXServiceHelper.IsWQYCust(this.Context, Convert.ToInt64(DataEntity["CONTACTUNIT_Id"])))
{
DynamicObjectCollection RECEIVEBILLENTRY = DataEntity["RECEIVEBILLENTRY"] as DynamicObjectCollection;
DynamicObject AccountUsage = ((DynamicObject)RECEIVEBILLENTRY[0]["ACCOUNTID"])["FACCOUNTUSAGE"] as DynamicObject;//账户用途
Customer cust = XSXServiceHelper.XSXServiceHelper.IsYQYCust(this.Context, Convert.ToInt64(DataEntity["CONTACTUNIT_Id"])) ? XSXServiceHelper.XSXServiceHelper.GetCustomerProperty(this.Context, Convert.ToInt64(DataEntity["CONTACTUNIT_Id"])) : XSXServiceHelper.XSXServiceHelper.GetWQYCustomerProperty(this.Context, Convert.ToInt64(DataEntity["CONTACTUNIT_Id"]));
// Customer cust = XSXServiceHelper.XSXServiceHelper.GetCustomerProperty(this.Context, Convert.ToInt64(DataEntity["CONTACTUNIT_Id"]));
DynamicObject BelongCust = XSXServiceHelper.XSXServiceHelper.IsYQYCust(this.Context, Convert.ToInt64(DataEntity["CONTACTUNIT_Id"])) ? XSXServiceHelper.XSXServiceHelper.GetBasicObject(this.Context, "BD_Customer", cust.BelongCustID) : null;
//DynamicObject BelongCust = XSXServiceHelper.XSXServiceHelper.GetBasicObject(this.Context, "BD_Customer", cust.BelongCustID);//服务端获取所属区域对象
DynamicObject CustType = XSXServiceHelper.XSXServiceHelper.GetBasicObject(this.Context, "PAEZ_CUSTTYPE", cust.CustTypeID); //服务端获取客户类别对象
DynamicObject Brand = XSXServiceHelper.XSXServiceHelper.GetBasicObject(this.Context, "ORG_Organizations", cust.BrandID); //服务端获取所属品牌对象,组织基础资料
DynamicObject Region = XSXServiceHelper.XSXServiceHelper.GetBasicObject(this.Context, "PAEZ_REGION", cust.RegionID); //服务端获取所属大区对象
DynamicObject OrgType = ((DynamicObject)DataEntity["FPAYORGID"])["FORGTYPE"] as DynamicObject; //组织类型
if (BelongCust != null)
{
DataEntity["FBelongCust"] = BelongCust;
DataEntity["FBelongCust_Id"] = cust.BelongCustID;
}
DataEntity["FCUSTTYPE"] = CustType;
DataEntity["FCUSTTYPE_Id"] = cust.CustTypeID;
DataEntity["FORGTYPE"] = OrgType;
DataEntity["FORGTYPE_Id"] = Convert.ToInt64(OrgType["Id"]);
DataEntity["FSHBRAND"] = Brand;
DataEntity["FSHBRAND_Id"] = cust.BrandID;
DataEntity["FSHREGION"] = Region;
DataEntity["FSHREGION_Id"] = cust.RegionID;
RECEIVEBILLENTRY[0]["FACCOUNTUSAGE"] = AccountUsage;
RECEIVEBILLENTRY[0]["FACCOUNTUSAGE_Id"] = Convert.ToInt64(AccountUsage["Id"]);
//根据账号用途进行收付款用途对应，业务类型对应
if (Convert.ToString(AccountUsage["Number"]) != null && !Convert.ToString(AccountUsage["Number"]).EqualsIgnoreCase(" "))
{
if (XSXServiceHelper.XSXServiceHelper.GetSFKYT(this.Context, Convert.ToString(AccountUsage["Number"])) != 0)
{
DynamicObject ReceivePurposeObject = XSXServiceHelper.XSXServiceHelper.GetBasicObject(this.Context, "CN_RECPAYPURPOSE", XSXServiceHelper.XSXServiceHelper.GetSFKYT(this.Context, Convert.ToString(AccountUsage["Number"])));
((DynamicObjectCollection)DataEntity["RECEIVEBILLENTRY"])[0]["PURPOSEID"] = ReceivePurposeObject;
((DynamicObjectCollection)DataEntity["RECEIVEBILLENTRY"])[0]["PURPOSEID_Id"] = XSXServiceHelper.XSXServiceHelper.GetSFKYT(this.Context, Convert.ToString(AccountUsage["Number"]));
}
if (XSXServiceHelper.XSXServiceHelper.GetYWTYPE(this.Context, Convert.ToString(AccountUsage["Number"]), Convert.ToInt64(DataEntity["CONTACTUNIT_Id"])) != 0)
{
DynamicObject YwTypeObject = XSXServiceHelper.XSXServiceHelper.GetBasicObject(this.Context, "PAEZ_SALSERVICE", XSXServiceHelper.XSXServiceHelper.GetYWTYPE(this.Context, Convert.ToString(AccountUsage["Number"]), Convert.ToInt64(DataEntity["CONTACTUNIT_Id"])));
DataEntity["FYWTYPE"] = YwTypeObject;
DataEntity["FYWTYPE_Id"] = XSXServiceHelper.XSXServiceHelper.GetYWTYPE(this.Context, Convert.ToString(AccountUsage["Number"]), Convert.ToInt64(DataEntity["CONTACTUNIT_Id"]));
}
}
//组织类型是品牌,******根据实际编码进行修改******
//if (Convert.ToString(OrgType["Number"]).EqualsIgnoreCase(ConstantBaseData.BrandOrgNo))
// {
/*
* 客户类别是有区域或者无区域门店
* ConstantBaseDate增加账号用途,业务类型，收付款用途ID
* 银行账号维护账户用途
* 收款单增加业务类型、账号用途两个字段，账号用途根据我方银行账号进行属性获取携带，当业务类型为门店加盟、保证金时为空，订货货款，区域订货保证金、营建费用时为对应业务类型
* 账号用途是门店加盟费则收付款用途为门店加盟费，账号用途为门店加盟保证金则收付款用途为门店加盟保证金
* 同理使用于区域加盟
*/
//客户类型是门店，门店加盟费******根据实际编码进行修改******
//if (Convert.ToString(CustType["Number"]).EqualsIgnoreCase(ConstantBaseData.YQYMDNO) || Convert.ToString(CustType["Number"]).EqualsIgnoreCase(ConstantBaseData.WQYMDNO))
//{
// //门店加盟费 ID:113486 No:005,******根据实际编码进行修改******
// DynamicObject ReceivePurposeObject = XSXServiceHelper.XSXServiceHelper.GetBasicObject(this.Context, "CN_RECPAYPURPOSE", 113486);//服务端获取收付款用途对象
// ((DynamicObjectCollection)DataEntity["RECEIVEBILLENTRY"])[0]["PURPOSEID"] = ReceivePurposeObject;
// ((DynamicObjectCollection)DataEntity["RECEIVEBILLENTRY"])[0]["PURPOSEID_Id"] = 113486;
//}
////客户类型是区域，区域加盟费******根据实际编码进行修改******
//if (Convert.ToString(CustType["Number"]).EqualsIgnoreCase("QY"))
//{
// //区域加盟费ID:107586 No:100 ,******根据实际编码进行修改******
// DynamicObject ReceivePurposeObject = XSXServiceHelper.XSXServiceHelper.GetBasicObject(this.Context, "CN_RECPAYPURPOSE", 107586);//服务端获取收付款用途对象
// ((DynamicObjectCollection)DataEntity["RECEIVEBILLENTRY"])[0]["PURPOSEID"] = ReceivePurposeObject;
// ((DynamicObjectCollection)DataEntity["RECEIVEBILLENTRY"])[0]["PURPOSEID_Id"] = 107586;
//}
////}
////组织类型是生产公司******根据实际编码进行修改******
//// if (Convert.ToString(OrgType["Number"]).EqualsIgnoreCase("SC"))
////{
////客户类型是门店，订货货款******根据实际编码进行修改******
//if (Convert.ToString(CustType["Number"]).EqualsIgnoreCase("MD01"))
//{
// //订货货款ID:107610 No:400 ,******根据实际编码进行修改******
// DynamicObject ReceivePurposeObject = XSXServiceHelper.XSXServiceHelper.GetBasicObject(this.Context, "CN_RECPAYPURPOSE", 107610);//服务端获取收付款用途对象
// ((DynamicObjectCollection)DataEntity["RECEIVEBILLENTRY"])[0]["PURPOSEID"] = ReceivePurposeObject;
// ((DynamicObjectCollection)DataEntity["RECEIVEBILLENTRY"])[0]["PURPOSEID_Id"] = 107610;
//}
////客户类型是区域，订货保证金******根据实际编码进行修改******
//if (Convert.ToString(CustType["Number"]).EqualsIgnoreCase("QY"))
//{
// //订货保证金ID:107608 No:300 ,******根据实际编码进行修改******
// DynamicObject ReceivePurposeObject = XSXServiceHelper.XSXServiceHelper.GetBasicObject(this.Context, "CN_RECPAYPURPOSE", 107608);//服务端获取收付款用途对象
// ((DynamicObjectCollection)DataEntity["RECEIVEBILLENTRY"])[0]["PURPOSEID"] = ReceivePurposeObject;
// ((DynamicObjectCollection)DataEntity["RECEIVEBILLENTRY"])[0]["PURPOSEID_Id"] = 107608;
//}
//}
}
}
}
}
}
}
public override void BeginOperationTransaction(BeginOperationTransactionArgs e)
{
base.BeginOperationTransaction(e);
this.UpdatebudgetValue(e);
}
public override void BeginOperationTransaction(BeginOperationTransactionArgs e)
{
base.BeginOperationTransaction(e);
}
public override void BeginOperationTransaction(BeginOperationTransactionArgs e)
{
base.BeginOperationTransaction(e);
var dataEntities = e.DataEntitys.Where(data => data.FieldProperty <string>(this.BusinessInfo.GetField("FGenTargetStatus")).EqualsIgnoreCase(LogicStatus.Instance.Yes())).ToArray();
if (!dataEntities.Any())
{
return;
}
var connectorService = PHMSWMSServiceFactory.Instance.GetLocalService <IConnectorService>();
var args = new List <GenTargetArgs>();
//整理发货明细数据。
foreach (var data in dataEntities)
{
var entries = data.EntryProperty(this.BusinessInfo.GetEntity("FEntity"));
entries.Where(entry => entry.FieldProperty <string>(this.BusinessInfo.GetField("FSourceObjectTypeId")).EqualsIgnoreCase(PIWMSFormPrimaryKey.Instance.Outbound()))
.Select(entry => entry.FieldProperty <string>(this.BusinessInfo.GetField("FSourceBillId")).ToChangeType <long>())
.Cast <object>()
.ToArray()
.Adaptive(billIds =>
{
var sources = connectorService.GetGenTargetSource(this.Context, GenTargetSourceSqlFromOutboundGroupByOutNotice.Instance, this.BusinessInfo.GetForm().Id, billIds);
sources.ForEach(item =>
{
item.BillId = data.PkId <long>();
item.BillNo = data.BillNo();
});
args.AddRange(sources);
});
}//end foreach
//整理收货明细数据。
foreach (var data in dataEntities)
{
var entries = data.EntryProperty(this.BusinessInfo.GetEntity("FEntity"));
entries.Where(entry => entry.FieldProperty <string>(this.BusinessInfo.GetField("FSourceObjectTypeId")).EqualsIgnoreCase(PIWMSFormPrimaryKey.Instance.Inbound()))
.Select(entry => entry.FieldProperty <string>(this.BusinessInfo.GetField("FSourceBillId")).ToChangeType <long>())
.Cast <object>()
.ToArray()
.Adaptive(billIds =>
{
var sources = connectorService.GetGenTargetSource(this.Context, GenTargetSourceSqlFromInBoundGroupByInNotice.Instance, this.BusinessInfo.GetForm().Id, billIds);
sources.ForEach(item =>
{
item.BillId = data.PkId <long>();
item.BillNo = data.BillNo();
});
args.AddRange(sources);
});
}//end foreach
if (!args.Any())
{
throw new KDBusinessException(string.Empty, "未获取到回撤目标单据的数据源！");
}
var op = connectorService.Pull(this.Context, args.ToArray());
this.OperationResult.MergeResult(op);
if (!this.OperationResult.IsSuccess)
{
this.OperationResult.RemoveSuccessResult();
this.OperationResult.ThrowWhenUnSuccess(false);
} //end if
}
public override void BeginOperationTransaction(BeginOperationTransactionArgs e)
{
base.BeginOperationTransaction(e);
if (e.DataEntitys == null)
{
return;
}
List <long> lstPkIds = new List <long>();
foreach (DynamicObject billDataEntity in e.DataEntitys)
{
lstPkIds.Add(Convert.ToInt64(billDataEntity["Id"]));
}
if (lstPkIds == null || lstPkIds.Count == 0)
{
return;
}
//处理上游配方当的锁库逻辑
//当前操作执行时，1.解锁上游配方单与本单关联的数量2.重算上游配方单的锁库数量字段
string sql = string.Format(@"select TKE.FENTRYID as Id,TKE.FSUPPLYINTERID as FInvDetailID,TKH.FDEMANDENTRYID as BillDetailID,t4.FBASEACTUALQTY as FBASEQTY,0 as FSECQTY
from T_PLN_RESERVELINKENTRY TKE
inner join T_PLN_RESERVELINK TKH on TKE.FID = TKH.FID
inner join T_STK_INVENTORY TV on TKE.FSUPPLYINTERID = TV.FID and TKE.FSUPPLYFORMID = 'STK_Inventory'
inner join T_PRD_PPBOMENTRY BP on TKH.FDEMANDENTRYID = BP.FEntryID
inner join T_PRD_PPBOM TB on BP.FID = TB.FID and TKH.FDEMANDBILLNO = TB.FBILLNO
inner join (select t2.FSID, sum(t2.FBASEACTUALQTY) as FBASEACTUALQTY
FROM T_PRD_PickMtrl t INNER JOIN T_PRD_PickMtrlDATA t1 ON t.FID=t1.FID
INNER JOIN T_PRD_PickMtrlDATA_LK t2 ON t1.FENTRYID=t2.FENTRYID
where t2.FSTABLENAME='T_PRD_PPBOMENTRY' and t.FID in ({0})
group by t2.FSID) t4 on BP.FENTRYID=t4.FSID
where TKH.FSRCFORMID='PRD_PPBOM' ", string.Join(",", lstPkIds));
DynamicObjectCollection dyUnLockInfo = DBUtils.ExecuteDynamicObject(this.Context, sql);
//调用解锁接口
Common.LockCommon.UnLockInventory(this.Context, dyUnLockInfo, "PRD_PPBOM");
//重算单据上的锁库数量字段
sql = string.Format(@"/*dialect*/update t set t.F_JN_BaseLockQty=isnull(TE.FQTY,0)
from T_PRD_PPBOMENTRY_Q T left join
(select FDEMANDENTRYID,SUM(TKE.FBASEQTY) as FQTY from T_PLN_RESERVELINK TKH
inner join T_PLN_RESERVELINKENTRY TKE on TKE.FID = TKH.FID
where FDEMANDFORMID='PRD_PPBOM'
group by FDEMANDENTRYID) TE on T.FEntryID=TE.FDEMANDENTRYID
inner join (select t2.FSID
FROM T_PRD_PickMtrl t INNER JOIN T_PRD_PickMtrlDATA t1 ON t.FID=t1.FID
INNER JOIN T_PRD_PickMtrlDATA_LK t2 ON t1.FENTRYID=t2.FENTRYID
where t2.FSTABLENAME='T_PRD_PPBOMENTRY' and t.FID in ({0})
) t4 on T.FENTRYID=t4.FSID " , string.Join(",", lstPkIds));
DBUtils.Execute(this.Context, sql);
//处理本单的锁库逻辑
sql = string.Format(@" SELECT t.FBILLNO, t.FID,t1.FENTRYID,t1.FSEQ, FStockOrgId AS FSTOCKORGID, FKeeperTypeId AS FKEEPERTYPEID, FKEEPERID AS FKEEPERID,
t2.FOwnerTypeId AS FOWNERTYPEID, t2.FOWNERID AS FOWNERID, FStockId AS FSTOCKID,
FStockLocId AS FSTOCKPLACEID, TM.FMASTERID AS FMATERIALID, FAUXPROPID AS FAUXPROPERTYID,
FSTOCKSTATUSID AS FSTOCKSTATUSID, FLOT AS FLOT, FPRODUCEDATE AS FPRODUCTDATE,
FEXPIRYDATE AS FVALIDATETO, FBOMID AS FBOMID, FMTONO AS FMTONO,FPROJECTNO AS FPROJECTNO,
FBaseActualQty AS FBASEQTY, FBASEUNITID AS FBASEUNITID, FSecActualQty AS FSECQTY, FSECUNITID AS FSECUNITID,FUNITID AS FUNITID,t1.FACTUALQTY AS FQTY
FROM T_PRD_PickMtrl t INNER JOIN T_PRD_PickMtrlDATA t1 ON t.FID=t1.FID
INNER JOIN T_PRD_PickMtrlDATA_A t2 ON t1.FENTRYID=t2.FENTRYID
inner join T_BD_MATERIAL TM on t1.FMATERIALID=TM.FMATERIALID
WHERE t.FID in ({0}) ", string.Join(",", lstPkIds));
Common.LockCommon.LockInventory(this.Context, this.OperationResult, sql, "PRD_PickMtrl");
this.OperationResult.IsShowMessage = true;
}
private void InsertFlow(BeginOperationTransactionArgs e)
{
string FBraOffice = "0";
string FDSrcType = "";
string FDSrcAction = "";
string FDSrcBillID = CZ_GetFormType();
string FDSrcFID = "";
string FDSrcBNo = "";
string FDSrcEntryID = "0";
string FDSrcSEQ = "0";
string FDCostPrj = "";
string FPreCost = "0";
string FReCost = "0";
string FNote = "";
string opKey = this.FormOperation.Operation.ToUpperInvariant();
string sql = "";
string backSql = "";
Dictionary <string, string> Trans;
if (opKey == "SUBMIT" || opKey == "CANCELASSIGN" || opKey == "AUDIT" || opKey == "UNAUDIT")
{
var map = new Dictionary <string, string>()
{
{ "SUBMIT", "提交" },
{ "CANCELASSIGN", "撤销" },
{ "AUDIT", "审核" },
{ "UNAUDIT", "反审核" },
};
FDSrcAction = map[opKey];
foreach (var d in e.DataEntitys)
{
FDSrcFID = d["Id"].ToString();
FDSrcBNo = d["BillNo"].ToString();
string DocumentStatus = d["DocumentStatus"].ToString();
if (opKey == "AUDIT" && DocumentStatus == "D")
{
throw new KDBusinessException("001", $"单据编号为：{FDSrcBNo}的单据为重新审核状态，请先提交后再进行操作！");
}
var objs = DB_GetFormData(FDSrcFID);
foreach (var obj in objs)
{
Trans = Transform(FDSrcBillID, obj);
FDSrcType = Trans["FDSrcType"];
FBraOffice = Trans["FBraOffice"];
FDSrcEntryID = Trans["FDSrcEntryID"];
FDSrcSEQ = Trans["FDSrcSEQ"];
FDCostPrj = Trans["FDCostPrj"];
FPreCost = Trans["FPreCost"];
FReCost = Trans["FReCost"];
FNote = Trans["FNote"];
decimal amt = Convert.ToDecimal(FReCost) - Convert.ToDecimal(FPreCost);
if (FDSrcType == "资金") // 资金要确认仅注册审核、反审核操作
{
string srcBillNo = obj["FSourceBillNo"].ToString();
switch (FDSrcAction)
{
case "提交":
case "撤销":
// 判断源单单号是否存在，若存在，则跳过，不需要占用、撤回预算占用流水
if (!srcBillNo.IsNullOrEmptyOrWhiteSpace())
{
continue;
}
FDSrcType = "立项";
break;
case "审核":
if (amt != 0)
{
if (srcBillNo.IsNullOrEmptyOrWhiteSpace())
{
string srcType = "立项";
// 源单不存在时，增加一条立项审核的预算占用调整记录
sql += String.Format(@"exec proc_czly_InsertBudgetFlowS
@FBraOffice='{0}',@FDSrcType='{1}',@FDSrcAction='{2}',@FDSrcBillID='{3}',
@FDSrcFID='{4}',@FDSrcBNo='{5}',@FDSrcEntryID='{6}',@FDSrcSEQ='{7}',
@FDCostPrj='{8}',@FPreCost='{9}',@FReCost='{10}',@FNote='{11}';
", FBraOffice, srcType, FDSrcAction, FDSrcBillID,
FDSrcFID, FDSrcBNo, FDSrcEntryID, FDSrcSEQ,
FDCostPrj, FPreCost, amt, FNote);
}
else
{
// 源单存在时，反写源单
backSql += GeneBackWriteSQL(FDSrcBillID, FDSrcEntryID, amt);
}
}
break;
case "反审核":
// 若源单不存在
if (srcBillNo.IsNullOrEmptyOrWhiteSpace())
{
// 增加一条立项审核的预算占用撤回记录
string realCost = FReCost;
if (DocumentStatus == "B")
{
realCost = FPreCost;
}
string srcType = "立项";
sql += String.Format(@"exec proc_czly_InsertBudgetFlowS
@FBraOffice='{0}',@FDSrcType='{1}',@FDSrcAction='{2}',@FDSrcBillID='{3}',
@FDSrcFID='{4}',@FDSrcBNo='{5}',@FDSrcEntryID='{6}',@FDSrcSEQ='{7}',
@FDCostPrj='{8}',@FPreCost='{9}',@FReCost='{10}',@FNote='{11}';
", FBraOffice, srcType, FDSrcAction, FDSrcBillID,
FDSrcFID, FDSrcBNo, FDSrcEntryID, FDSrcSEQ,
FDCostPrj, FPreCost, realCost, FNote);
}
// 若源单存在
else
{
// 资金在审核中反审核时，则跳过处理
if (DocumentStatus == "B")
{
continue;
}
// 撤回审核时对源单的反写
if (amt != 0)
{
backSql += GeneBackWriteSQL(FDSrcBillID, FDSrcEntryID, amt);
}
}
break;
}
}
//审核中进行反审核
else if (FDSrcAction == "反审核" && DocumentStatus == "B")
{
FReCost = Trans["FPreCost"];
}
// 立项审核时如果金额没有变动，则不再进行预算占用调整
if (FDSrcType == "立项" && FDSrcAction == "审核")
{
if (amt == 0)
{
continue;
}
FReCost = amt.ToString();
}
sql += String.Format(@"exec proc_czly_InsertBudgetFlowS
@FBraOffice='{0}',@FDSrcType='{1}',@FDSrcAction='{2}',@FDSrcBillID='{3}',
@FDSrcFID='{4}',@FDSrcBNo='{5}',@FDSrcEntryID='{6}',@FDSrcSEQ='{7}',
@FDCostPrj='{8}',@FPreCost='{9}',@FReCost='{10}',@FNote='{11}';
", FBraOffice, FDSrcType, FDSrcAction, FDSrcBillID,
FDSrcFID, FDSrcBNo, FDSrcEntryID, FDSrcSEQ,
FDCostPrj, FPreCost, FReCost, FNote);
}
}
}
if (!sql.Equals(""))
{
DBUtils.Execute(this.Context, sql);
}
if (!backSql.Equals(""))
{
backSql = "/*dialect*/" + backSql;
DBUtils.Execute(this.Context, backSql);
}
}
public override void BeginOperationTransaction(BeginOperationTransactionArgs e)
{
try
{
string sql = string.Empty;
if (e.DataEntitys != null && e.DataEntitys.Count <DynamicObject>() > 0)
{
foreach (DynamicObject item in e.DataEntitys)
{
//财务应收fid
string Fid = item["Id"].ToString();
//单据类型
string FBILLTYPEID = item["BillTypeID_Id"].ToString();
//只有财务应收的采用反写
#region
if (FBILLTYPEID == "5d18aa0e58407c")
{
string upsql = "";
string UpdatesqlH = "";
sql = string.Format(@"select are.FORDERENTRYID as FORDERENTRYID,ar.FMODIFYDATE as 修改时间,ar.F_YBG_CheckBox,arE.FTAXPRICE as 含税单价,arE.FPRICE as 不含税单价,
are.FENTRYID as AreFENTRYID,arel.FBASICUNITQTY, arf.FALLAMOUNT as 表头价税合计,
arf.FNOTAXAMOUNT as 表头不含税金额 , are.FALLAMOUNTFOR as 表体价税合计,are.FIsModifyPrice,
arE.FNOTAXAMOUNTFOR as 表体不含税金额 ,arE.FPRICEQTY as 计价数量 ,arel.FSTABLENAME,arel.FSID
from t_AR_receivable ar inner join t_AR_receivableEntry arE on ar.FID=arE.FID
inner join T_AR_RECEIVABLEENTRY_LK arel on arel.FENTRYID=are.FENTRYID
left join t_AR_receivableFIN arf on arf.FID=ar.FID where ar.FID='{0}'", Fid);
DataSet ds = DBServiceHelper.ExecuteDataSet(this.Context, sql);
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string FORDERENTRYID = dt.Rows[i]["FORDERENTRYID"].ToString();
string FSID = dt.Rows[i]["FSID"].ToString();
//是否修改了单价
string FIsModifyPrice = dt.Rows[i]["FIsModifyPrice"].ToString();
//decimal FALLAMOUNT = Convert.ToDecimal(dt.Rows[i]["表头价税合计"].ToString());
// decimal FNOTAXAMOUNT = Convert.ToDecimal(dt.Rows[i]["表头不含税金额"].ToString());
decimal FALLAMOUNTFOR = Math.Abs(Convert.ToDecimal(dt.Rows[i]["表体价税合计"].ToString()));
decimal FNOTAXAMOUNTFOR = Math.Abs(Convert.ToDecimal(dt.Rows[i]["表体不含税金额"].ToString()));
decimal FPRICEQTY = Math.Abs(Convert.ToDecimal(dt.Rows[i]["计价数量"].ToString()));
decimal FBASICUNITQTY = Math.Abs(Convert.ToDecimal(dt.Rows[i]["FBASICUNITQTY"].ToString())); //暂估基本数量、
decimal FTAXPRICE = Math.Abs(Convert.ToDecimal(dt.Rows[i]["含税单价"].ToString())); //含税单价
decimal FPRICE = Math.Abs(Convert.ToDecimal(dt.Rows[i]["不含税单价"].ToString())); //不含税单价
string FMODIFYDATE = dt.Rows[i]["修改时间"].ToString();
//string F_YBG_CheckBox= dt.Rows[i]["F_YBG_CheckBox"].ToString();
if (FPRICEQTY != FBASICUNITQTY)
{
FALLAMOUNTFOR = FALLAMOUNTFOR * (FBASICUNITQTY / FPRICEQTY);
FNOTAXAMOUNTFOR = FNOTAXAMOUNTFOR * (FBASICUNITQTY / FPRICEQTY);
FPRICEQTY = FBASICUNITQTY;
}
//更新暂估应收
upsql += string.Format(@"/*dialect*/ update t_AR_receivableEntry set FIsLockPrice=1 where FENTRYID ='{0}'", FSID);
string FSTABLENAME = "";
sql = string.Format(@"select FSID as 销售出库单FENTRYID ,FSBILLID as 销售出库单id,FSTABLENAME
from T_AR_RECEIVABLEENTRY_LK where FENTRYID={0}", FSID);
DataSet ds2 = DBServiceHelper.ExecuteDataSet(this.Context, sql);
DataTable dt2 = ds2.Tables[0];
if (dt2.Rows.Count > 0)
{
for (int j = 0; j < dt2.Rows.Count; j++)
{
FSTABLENAME = dt2.Rows[j]["FSTABLENAME"].ToString();
if (FSTABLENAME == "T_SAL_OUTSTOCKENTRY")
{
//销售出库单表头
UpdatesqlH += string.Format(@"/*dialect*/ update T_SAL_OUTSTOCK set FARFNOTAXAMOUNTFOR_H=FARFNOTAXAMOUNTFOR_H+{1},FARFALLAMOUNTFOR_H=FARFALLAMOUNTFOR_H+{2},FARFMODIFYDATE='{3}'
from T_SAL_OUTSTOCK a inner join T_SAL_OUTSTOCKENTRY_R b on a.FID=b.FID where a.FID ='{0}' and FSOENTRYID='{4}'", dt2.Rows[j]["销售出库单id"].ToString(), FNOTAXAMOUNTFOR, FALLAMOUNTFOR, FMODIFYDATE, FORDERENTRYID);
//销售出库单表体
upsql += string.Format(@"/*dialect*/ update T_SAL_OUTSTOCKENTRY set FARFNOTAXAMOUNTFOR=FARFNOTAXAMOUNTFOR+{1},FARFALLAMOUNTFOR=FARFALLAMOUNTFOR+{2} ,FARFQty=FARFQty+{3},FARFTAXPRICE={4},FIsModifyPrice={5},FARFPRICE={6}
from T_SAL_OUTSTOCKENTRY a inner join T_SAL_OUTSTOCKENTRY_R b on a.FID=b.FID where a.FENTRYID ='{0}'and FSOENTRYID='{7}'", dt2.Rows[j]["销售出库单FENTRYID"].ToString(), FNOTAXAMOUNTFOR, FALLAMOUNTFOR, FPRICEQTY, FTAXPRICE, FIsModifyPrice, FPRICE, FORDERENTRYID);
}
else
{
//销售退货单表头
UpdatesqlH += string.Format(@"/*dialect*/ update T_SAL_RETURNSTOCK set FARFNOTAXAMOUNTFOR_H=FARFNOTAXAMOUNTFOR_H+{1},FARFALLAMOUNTFOR_H=FARFALLAMOUNTFOR_H+{2},FARFMODIFYDATE='{3}'
from T_SAL_RETURNSTOCK a inner join T_SAL_RETURNSTOCKENTRY b on a.FID=b.FID
where a.FID ='{0}'and FSOENTRYID='{4}'", dt2.Rows[j]["销售出库单id"].ToString(), FNOTAXAMOUNTFOR, FALLAMOUNTFOR, FMODIFYDATE, FORDERENTRYID);
//销售退货表体
upsql += string.Format(@"/*dialect*/ update T_SAL_RETURNSTOCKENTRY set FARFNOTAXAMOUNTFOR=FARFNOTAXAMOUNTFOR+{1},FARFALLAMOUNTFOR=FARFALLAMOUNTFOR+{2} ,FARFQty=FARFQty+{3},FARFTAXPRICE={5},FIsModifyPrice={6},FARFPRICE={7}
where FENTRYID ='{0}'and FSOENTRYID='{4}'", dt2.Rows[j]["销售出库单FENTRYID"].ToString(), FNOTAXAMOUNTFOR, FALLAMOUNTFOR, FPRICEQTY, FORDERENTRYID, FTAXPRICE, FIsModifyPrice, FPRICE);
}
}
}
}
//更新销售出库单表头
DBServiceHelper.Execute(Context, UpdatesqlH);
//更新销售出库单表体
DBServiceHelper.Execute(Context, upsql);
}
}
#endregion
}
}
}
catch (Exception ex)
{
throw new KDException("", "审核失败：" + ex.ToString());
}
}
/// <summary>
/// 操作开始前功能处理
/// </summary>
/// <param name="e"></param>
public override void BeginOperationTransaction(BeginOperationTransactionArgs e)
{
foreach (DynamicObject o in e.DataEntitys)
{
}
}
public override void BeginOperationTransaction(BeginOperationTransactionArgs e)
{
try
{
string sql = string.Empty;
if (e.DataEntitys != null && e.DataEntitys.Count <DynamicObject>() > 0)
{
foreach (DynamicObject item in e.DataEntitys)
{
string upsql = "";
string FID = item["Id"].ToString();
//供应商
string F_YBG_Supplier = item["SupplierId_Id"].ToString();
//仓库
string F_YBG_Warehouse = item["F_YBG_Warehouse_Id"].ToString();
//业务模式
string CRBusinessModel = item["F_YBG_BusinessModel"].ToString().Trim();
string F_YBG_BUSINESSMODEL = ""; //其他仓库默认01
if (string.IsNullOrEmpty(CRBusinessModel))
{
if (F_YBG_Supplier == "0" || F_YBG_Warehouse == "0")
{
throw new Exception("提交失败：未填写仓库和供应商！");
}
else
{
//仓库编码
sql = string.Format(@"select FNumber from t_BD_Stock where FSTOCKID='{0}'", F_YBG_Warehouse);
string CKFNumber = DBServiceHelper.ExecuteScalar <string>(this.Context, sql, null, null);
//供应商编码 ---自营VEN00057 VEN00099 VEN00256
sql = string.Format(@"select FNumber from t_BD_Supplier where FSUPPLIERID='{0}'", F_YBG_Supplier);
string SPFNUMBER = DBServiceHelper.ExecuteScalar <string>(this.Context, sql, null, null);
//珠海仓
if (CKFNumber.StartsWith("YBG001") || CKFNumber.StartsWith("YBG015") || CKFNumber.StartsWith("YBG017"))
{
F_YBG_BUSINESSMODEL = "07"; //珠海自营 07
upsql = string.Format(@"/*dialect*/ update t_PUR_POOrder set F_YBG_BUSINESSMODEL='{0}' where FID ={1}", F_YBG_BUSINESSMODEL, FID);
}
//自营
else
{
F_YBG_BUSINESSMODEL = "05"; //自营 05
upsql = string.Format(@"/*dialect*/ update t_PUR_POOrder set F_YBG_BUSINESSMODEL='{0}' where FID ={1}", F_YBG_BUSINESSMODEL, FID);
}
}
//更新业务模式
DBServiceHelper.Execute(this.Context, upsql);
}
else
{
#region 注释
//if (F_YBG_Supplier == "0" || F_YBG_Warehouse == "0")
//{
// throw new Exception("提交失败：未填写仓库和供应商！");
//}
////仓库编码
//sql = string.Format(@"select FNumber from t_BD_Stock where FSTOCKID='{0}'", F_YBG_Warehouse);
//string CKFNumber = DBServiceHelper.ExecuteScalar<string>(this.Context, sql, null, null);
////供应商编码 ---自营VEN00057 VEN00099 VEN00256
//sql = string.Format(@"select FNumber from t_BD_Supplier where FSUPPLIERID='{0}'", F_YBG_Supplier);
//string SPFNUMBER = DBServiceHelper.ExecuteScalar<string>(this.Context, sql, null, null);
////非嘉里开头的
//if (CKFNumber.StartsWith("ZF")) //挂靠01
//{
// F_YBG_BUSINESSMODEL = "01";
//}
////嘉里开头
//else if (CKFNumber.StartsWith("JLZF")) //04 挂靠自发
//{
// F_YBG_BUSINESSMODEL = "04";
//}
////嘉里物流主仓 嘉里苏宁移动仓
//else if (CKFNumber.StartsWith("JL002") || CKFNumber.StartsWith("JLSN001"))
//{
// // 是壹办公供应商或者自营供应商
// if (SPFNUMBER.Contains("VEN00057") || SPFNUMBER.Contains("VEN00099")) //自营 05
// {
// F_YBG_BUSINESSMODEL = "05";
// }
// else //代采 06
// {
// F_YBG_BUSINESSMODEL = "06";
// }
//}
////珠海仓
//else if (CKFNumber.StartsWith("YBG001") || CKFNumber.StartsWith("YBG015") || CKFNumber.StartsWith("YBG017"))
//{
// F_YBG_BUSINESSMODEL = "07"; //珠海自营 07
//}
//// 观澜仓 车公庙仓
//else if (CKFNumber.StartsWith("YBG002") || CKFNumber.StartsWith("YBG003"))
//{
// //壹办公供应商或者自营供应商
// if (SPFNUMBER.Contains("VEN00057") || SPFNUMBER.Contains("VEN00099")) //自营直发02
// {
// F_YBG_BUSINESSMODEL = "02";
// }
// else //代采直发 03
// {
// F_YBG_BUSINESSMODEL = "03";
// }
//}
//else //其他仓库默认01
//{
// //壹办公供应商或者自营供应商
// if (SPFNUMBER.Contains("VEN00057") || SPFNUMBER.Contains("VEN00099")) //自营 05
// {
// F_YBG_BUSINESSMODEL = "05"; //自营
// }
// else
// {
// F_YBG_BUSINESSMODEL = "01";
// }
//}
//if (F_YBG_BUSINESSMODEL != CRBusinessModel)
//{
// throw new Exception("采购订单业务模式改变了，不能提交！");
//}
#endregion
}
}
}
}
catch (Exception ex)
{
throw new Exception("提交失败：" + ex.ToString());
}
}
