using Kingdee.BOS.Core.DynamicForm.PlugIn; using Kingdee.BOS.Core.DynamicForm.PlugIn.Args; using Kingdee.BOS.Orm.DataEntity; using Kingdee.BOS.ServiceHelper; using Kingdee.BOS.WebApi.Client; using MDM_Model.Constants; using Newtonsoft.Json; using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Linq; using System.Text; using System.Threading.Tasks; using XH_Bussiness.DBService; using XH_Bussiness.Models; using XH_Bussiness.Untity; using ZD.Cloud.Logger; using ZD.Cloud.Share.Common; namespace XH_Bussiness.ServicePlugin { [Description("应收结算清单物料保存暂时不用")] public class PluginARSettlement : AbstractOperationServicePlugIn { // public override void OnPreparePropertys(PreparePropertysEventArgs e) // { // base.OnPreparePropertys(e); // IList Fields = e.FieldKeys; // Fields.Add("FBizBillNo"); // Fields.Add("FSeq"); // Fields.Add("FMaterialId"); // } // public override void AfterExecuteOperationTransaction(AfterExecuteOperationTransaction e) // { // if (this.Context.CurrentOrganizationInfo.ID != 1) // { // return; // } // //获取元数据集 // DynamicObject[] SrcDatas = e.DataEntitys; // LogHelper.LogInfo("PluginARSettlement:" + JsonConvert.SerializeObject(e.DataEntitys)); // foreach (DynamicObject SrcData in SrcDatas) // { // UpdatePrice(SrcData); // } // } // private void UpdatePrice(DynamicObject srcData) // { // var entity = srcData["FDetailEntity"] as DynamicObjectCollection; // foreach (DynamicObject item in entity) // { // string Seq = item["Seq"].ToString(); // var materialId = Convert.ToInt64(item["FMaterialId"]); // var bizBillNo = Convert.ToInt64(item["FBizBillNo"]); // string sql1 = $@"select F_ProjectNo,FPrice // from t_sal_orderentry // where fentryid in // (select fsid // from t_sal_outstockentry_lk // where fentryid in (select fentryid // from t_sal_outstock t1 // left join t_sal_outstockentry t2 // on t1.fid = t2.fid // where t1.fbillno = '{bizBillNo}')) //"; // var ds1 = DBServiceHelper.ExecuteDataSet(Context, sql1); // var dt1 = ds1.Tables[0]; // if (dt1.Rows.Count == 0) // { // continue; // } // List entryIds = new List(); // foreach (DataRow dr in dt1.Rows) // { // entryIds.Add(ConvertHelper.ToInt64(dr["F_ProjectNo"])); // } // string sql2 = $"select T1.FBehalfInvoiceRatio from PXDF_BigTicketProject t1 left join PXDF_BigTicketProjectEntry t2 on t1.fid=t2.fid where t2.fentryid in {entryIds.ToListParam()}"; // var ds2 = DBServiceHelper.ExecuteDataSet(Context, sql2); // var list = new List(); // foreach (DataRow dr in dt1.Rows) // { // list.Add(ConvertHelper.ToDecimal(dr["FBehalfInvoiceRatio"])); // } // } // } } }