usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.ComponentModel.DataAnnotations;usingSystem.Data;usingSystem.Text;usingGeneral_Script_Parser;usingMicrosoft.SemanticKernel;usingUFSoft.UBF.AopFrame.Lock;usingUFSoft.UBF.Business;usingUFSoft.UBF.Util.Context;namespaceUFSoft.UBF.MVC.AI.plugin;//////销售订单插件///publicclassSOInformation{privatestaticstringFullName="UFIDA::U9::SM::SO::SO";[KernelFunction][Description("查询销售订单信息")]publicIEnumerableGetSODetailsBySO([Description("查询条件"),Required]SOQueryquery){varwhereSql=$"andconvert(date,so.BusinessDate)>='{query.StartTime.ToString("yyyy-MM-dd")}'";if(!string.IsNullOrWhiteSpace(query.SONo)){whereSql+=$"andso.DocNo='{query.SONo}'";}if(!string.IsNullOrWhiteSpace(query.CustomerCode)){whereSql+=$"andso.OrderBy.Code='{query.CustomerCode}'";}if(!string.IsNullOrWhiteSpace(query.ItemCode)){whereSql+=$"andso.SOLines.ItemInfo.ItemCode='{query.ItemCode}'";}if(!string.IsNullOrWhiteSpace(query.OrgCode)){whereSql+=$"andso.Org.Code='{query.OrgCode}'";}if(query.EndTime!=null&&query.EndTime!=DateTime.MinValue&&query.EndTime!=DateTime.MaxValue){whereSql+=$"andconvert(date,so.BusinessDate)<='{query.EndTime.ToString("yyyy-MM-dd")}'";}StringBuilderstringBuilder=newStringBuilder();stringBuilder.Append("selectso.DocNoasSONo,so.BusinessDate,so.OrderBy.CodeasCustomerCode,so.OrderBy.NameasCustomerName");stringBuilder.Append(",so.SOLines.SOShiplines.SupplyOrg.Location.Address1asSuppAddress");//发货位置：供应组织的办公地址stringBuilder.Append(",so.SOLines.SOShiplines.SOAddresses.Address.AddressAasRcvAddress");//②收货位置stringBuilder.Append(",convert(date,so.SOLines.SOShiplines.RequireDate)asRequireDate");stringBuilder.Append(",so.SOLines.ItemInfo.ItemCodeasItemCode,so.SOLines.ItemInfo.ItemNameasItemName");stringBuilder.Append(",so.SOLines.Weight,so.SOLines.Volume");stringBuilder.Append(",so.SOLines.DiscountRate,so.SOLines.FinallyPriceTC,so.SOLines.OrderPriceTC");stringBuilder.Append(",so.SOLines.TotalMoneyTC,so.SOLines.NetMoneyTC,so.SOLines.TaxMoneyTC");stringBuilder.Append(",so.SOLines.OrderByQtyTU,so.SOLines.OrderByQtyPU,so.SOLines.OrderByQtyIU");stringBuilder.Append(",so.SOLines.DocLineNo");stringBuilder.Append(",so.SOLines.SOShiplines.DocSubLineNo");stringBuilder.Append("from"+FullName+"sowhereso.Status>=3");stringBuilder.Append(whereSql);returnGet(stringBuilder.ToString());;}[KernelFunction][Description("查询客户信用额度")]publicGetCreditQuantityGetCreditLimitByCustomer([Description("查询条件"),Required]GetCreditQueryquery){if(query==null||String.IsNullOrEmpty(query.CustomerCode))returnnull;GetCreditQuantityCreditDTO=newGetCreditQuantity();using(newScopedContext()){using(BPForEnginebp=newBPForEngine()){//需要引入UFIDA.U9.CC.CreditSV相关的引用，UFIDA.U9.CC.CreditBP相关的引用UFIDA.U9.CC.CreditSV.Proxy.GetCreditBlanceByCustomerProxyproxy=newUFIDA.U9.CC.CreditSV.Proxy.GetCreditBlanceByCustomerProxy();proxy.CustomerCode=query.CustomerCode;if(!string.IsNullOrEmpty(query.CustomerSiteCode)){proxy.CustomerSiteCode=query.CustomerSiteCode;}else{proxy.CustomerSiteCode=query.CustomerCode;}UFIDA.U9.CC.CreditBP.CreditLimitRateStatDTODataresultDTO=proxy.Do();if(resultDTO!=null){CreditDTO.CreditLimit=resultDTO.CreditLimit;CreditDTO.TempCredit=resultDTO.TempCredit;CreditDTO.MaxOverDueDays=resultDTO.MaxOverDueDays;CreditDTO.RemainOverdueAR=resultDTO.RemainOverdueAR;CreditDTO.ARBalance=resultDTO.ARBalance;}}}returnCreditDTO;}privateIEnumerableGet(stringoql){using(newScopedContext()){using(BPForEnginebp=newBPForEngine()){EntityDataQueryentityDataQuery=newEntityDataQuery("UFIDA.U9.InvTrans.WhQoh.WhQoh");vardatareader=entityDataQuery.FindDataReader(oql);Listlist=newList();while(datareader.Read()){SOQuantitydto=newSOQuantity();dto.SONo=datareader["SONo"].ToString();dto.DocLineNo=int.Parse(datareader["DocLineNo"].ToString());dto.DocSubLineNo=int.Parse(datareader["DocSubLineNo"].ToString());dto.BusinessDate=datareader["BusinessDate"].ToString();dto.CustomerCode=datareader["CustomerCode"].ToString();dto.CustomerName=datareader["CustomerName"].ToString();dto.RequireDate=datareader["RequireDate"].ToString();dto.ItemCode=datareader["ItemCode"].ToString();dto.ItemName=datareader["ItemName"].ToString();dto.Weight=decimal.Parse(datareader["Weight"].ToString());dto.Volume=decimal.Parse(datareader["Volume"].ToString());dto.OrderPriceTC=decimal.Parse(datareader["OrderPriceTC"].ToString());dto.FinallyPriceTC=decimal.Parse(datareader["FinallyPriceTC"].ToString());dto.TotalMoneyTC=decimal.Parse(datareader["TotalMoneyTC"].ToString());dto.NetMoneyTC=decimal.Parse(datareader["NetMoneyTC"].ToString());dto.TaxMoneyTC=decimal.Parse(datareader["TaxMoneyTC"].ToString());dto.OrderByQtyTU=decimal.Parse(datareader["OrderByQtyTU"].ToString());dto.OrderByQtyPU=decimal.Parse(datareader["OrderByQtyPU"].ToString());dto.OrderByQtyIU=decimal.Parse(datareader["OrderByQtyIU"].ToString());dto.SuppAddress=datareader["SuppAddress"].ToString();dto.RcvAddress=datareader["RcvAddress"].ToString();list.Add(dto);}returnlist;}}}//////查询销售订单入参///publicclassSOQuery{[Description("销售订单号")]publicstringSONo{get;set;}[Description("组织编码(为空的话是取所有组织)")]publicstringOrgCode{get;set;}[Description("客户编码")]publicstringCustomerCode{get;set;}[Description("料号")]publicstringItemCode{get;set;}[Description("销售订单查询开始日期"),Required]publicDateTimeStartTime{get;set;}[Description("销售订单查询结束日期")]publicDateTimeEndTime{get;set;}}//////查询销售订单返回参数///publicclassSOQuantity{[Description("销售订单单号")]publicstringSONo{get;set;}[Description("销售订单行号")]publicintDocLineNo{get;set;}[Description("销售订单计划行号")]publicintDocSubLineNo{get;set;}[Description("业务日期")]publicstringBusinessDate{get;set;}[Description("客户编码")]publicstringCustomerCode{get;set;}[Description("客户名称")]publicstringCustomerName{get;set;}[Description("交货日期")]publicstringRequireDate{get;set;}[Description("料品编码")]publicstringItemCode{get;set;}[Description("料品名称")]publicstringItemName{get;set;}[Description("重量")]publicdecimalWeight{get;set;}[Description("体积")]publicdecimalVolume{get;set;}[Description("折扣率")]publicdecimalDiscountRate{get;set;}[Description("单价")]publicdecimalOrderPriceTC{get;set;}[Description("最终价")]publicdecimalFinallyPriceTC{get;set;}[Description("价税合计")]publicdecimalTotalMoneyTC{get;set;}[Description("未税金额")]publicdecimalNetMoneyTC{get;set;}[Description("税额")]publicdecimalTaxMoneyTC{get;set;}[Description("交易单位数量")]publicdecimalOrderByQtyTU{get;set;}[Description("计价单位数量")]publicdecimalOrderByQtyPU{get;set;}[Description("库存主单位数量")]publicdecimalOrderByQtyIU{get;set;}[Description("发货位置")]publicstringSuppAddress{get;set;}[Description("收货位置")]publicstringRcvAddress{get;set;}}//////查询客户信用额度入参///publicclassGetCreditQuery{[Description("客户编码"),Required]publicstringCustomerCode{get;set;}[Description("客户位置编码(为空等于客户编码)")]publicstringCustomerSiteCode{get;set;}//[Description("组织编码(为空的话是取所有组织)")]publicstringOrgCode{get;set;}}publicclassGetCreditQuantity{[Description("信用额度")]publicdecimalCreditLimit{get;set;}[Description("临时额度)")]publicdecimalTempCredit{get;set;}[Description("逾期天数")]publicintMaxOverDueDays{get;set;}[Description("逾期应收余额")]publicdecimalRemainOverdueAR{get;set;}[Description("应收账款")]publicdecimalARBalance{get;set;}}}
