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<string> 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<long> entryIds = new List<long>();
|
// 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<decimal>();
|
// foreach (DataRow dr in dt1.Rows)
|
// {
|
// list.Add(ConvertHelper.ToDecimal(dr["FBehalfInvoiceRatio"]));
|
// }
|
|
// }
|
|
// }
|
}
|
}
|
