金蝶云 自定义WebAPI接口

最新推荐文章于 2024-07-11 16:05:16 发布
最新推荐文章于 2024-07-11 16:05:16 发布
阅读量3.4k 收藏 10
点赞数 1
分类专栏： 金蝶云
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_39023606/article/details/108933880
版权

金蝶云 WebAPI 自定义接口 数据库查询 库存管理
关键词由CSDN通过智能技术生成

金蝶云 自定义WebAPI接口

using Kingdee.BOS.JSON;
using Kingdee.BOS.ServiceFacade.KDServiceFx;
using Kingdee.BOS.ServiceHelper;
using Kingdee.BOS.WebApi.ServicesStub;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;

namespace KingDee.api.ServicesStub
{
    public class CustomBusinessService : AbstractWebApiBusinessService
    {
        public CustomBusinessService(KDServiceContext context)
            : base(context)
        {
        }
        public RETURNROOT ExecuteService(ROOT parameter)
        {
            RETURNROOT _RETURNROOT = new RETURNROOT();
            List<string> _Exceptionlist = new List<string>();
            if (parameter.FormId == "Intervalinventory")
            {
                try
                {
                    string sql = GETsqlstr();
                    sql += (string.Format("\r\n exec('select {4} {0} from #LS {1} {2} {3}')",
                        (parameter.FieldKeys == null || parameter.FieldKeys.Trim() == "" ? " * " : parameter.FieldKeys).Replace("'", "''"),
                        (parameter.FilterString == null || parameter.FilterString.Trim() == "" ? " " : " where " + parameter.FilterString).Replace("'", "''"),
                        (parameter.GroupString == null || parameter.GroupString.Trim() == "" ? " " : " group by " + parameter.GroupString).Replace("'", "''"),
                        (parameter.OrderString == null || parameter.OrderString.Trim() == "" ? " " : " order by " + parameter.OrderString).Replace("'", "''"),
                        (parameter.TopRowCount == 0 ? "" : "top " + parameter.TopRowCount.ToString()).Replace("'", "''")));
                    sql += "\r\n DROP TABLE #LS";
                    DataSet ds = DBServiceHelper.ExecuteDataSet(this.KDContext.Session.AppContext, sql);
                    if (ds.Tables.Count > 0)
                    {
                        _RETURNROOT.DataTable = ds.Tables[0];
                        _RETURNROOT.Success = true;
                    }
                }
                catch (Exception e)
                {
                    _RETURNROOT.Success = false;
                    _Exceptionlist.Add(e.ToString());
                }
            }
            else
            {
                _RETURNROOT.Success = false;
                _Exceptionlist.Add("FormId有误！");
            }
            _RETURNROOT.Exception=_Exceptionlist;
            return _RETURNROOT;
        }

        public string GETsqlstr()
        {
            string sql = "/*dialect*/ ";
            sql += "\r\n select FAPPROVEDATE,FORG.FNUMBER FStockOrgID,FORG.FNAME FStockOrgNAME,";
            sql += "\r\n FMAT.FNUMBER FMATERIALID,FMAT.FNAME FMATERIALNAME,";
            sql += "\r\n FMAT.FNUMBER FSTOCKID,FMAT.FNAME FSTOCKNAME,";
            sql += "\r\n FSTOCKLOCID,FLOT,";
            sql += "\r\n FBASEUNI.FNUMBER FBASEUNITID,FBASEUNI.FNAME FBASEUNITNAME,FBASEQTY,";
            sql += "\r\n FUNI.FNUMBER FSTOCKUNITID,FUNI.FNAME FSTOCKUNITNAME,FQTY";
            sql += "\r\n into #LS";
            sql += "\r\n from";
            sql += "\r\n (";
            sql += "\r\n 	--入库";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FStockOrgID,j.FMATERIALID,j.FSTOCKID,j.FSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,isnull(j.FBASEQTY,0) FBASEQTY,j.FUNITID,isnull(j.FQTY,0) FQTY";
            sql += "\r\n 	from T_STK_INVINIT i with(nolock) --初始库存";
            sql += "\r\n 	inner join T_STK_INVINITDETAIL j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C'";

            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKORGID,j.FMATERIALID,j.FSTOCKID,j.FSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,isnull(j.FBASEUNITQTY,0),j.FUNITID,isnull(j.FREALQTY,0) ";
            sql += "\r\n 	from t_STK_InStock i with(nolock) --采购入库单";
            sql += "\r\n 	inner join T_STK_INSTOCKENTRY j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C'";

            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKORGID,j.FMATERIALID,j.FSTOCKID,j.FSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,isnull(j.FBASEREALQTY,0),j.FUNITID,isnull(j.FREALQTY,0)";
            sql += "\r\n 	from T_PRD_INSTOCK i with(nolock) --生产入库单";
            sql += "\r\n 	inner join T_PRD_INSTOCKENTRY j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C'";

            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKORGID,j.FMATERIALID,j.FSTOCKID,j.FSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,isnull(j.FBASEREALQTY,0),j.FUNITID,isnull(j.FREALQTY,0)";
            sql += "\r\n 	from T_SP_INSTOCK i with(nolock) --简单生产入库单";
            sql += "\r\n 	inner join T_SP_INSTOCKENTRY j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C'";

            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKORGID,j.FMATERIALID,j.FSTOCKID,j.FSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,isnull(j.FBASEQTY,0),j.FUNITID,isnull(j.FQTY,0)";
            sql += "\r\n 	from T_PRD_RETURNMTRL i with(nolock) --生产退料单";
            sql += "\r\n 	inner join T_PRD_RETURNMTRLENTRY j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C'";

            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKORGID,j.FMATERIALID,j.FSTOCKID,j.FSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,isnull(j.FBASEQTY,0),j.FUNITID,isnull(j.FQTY,0)";
            sql += "\r\n 	from T_SP_RETURNMTRL i with(nolock) --简单生产退料单";
            sql += "\r\n 	inner join T_SP_RETURNMTRLENTRY j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C'";

            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKORGID,j.FMATERIALID,j.FSTOCKID,j.FSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,isnull(j.FBASEQTY,0),j.FUNITID,isnull(j.FQTY,0)";
            sql += "\r\n 	from T_SUB_RETURNMTRL i with(nolock) --委外退料单";
            sql += "\r\n 	inner join T_SUB_RETURNMTRLENTRY j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C'";

            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKORGID,j.FMATERIALID,j.FSTOCKID,j.FSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,isnull(j.FBASEUNITQTY,0),j.FUNITID,isnull(j.FREALQTY,0)";
            sql += "\r\n 	from T_SAL_RETURNSTOCK i with(nolock) --销售退货单";
            sql += "\r\n 	inner join T_SAL_RETURNSTOCKENTRY j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C' and i.FBILLNO not in ('SR-2003000289')";
            //
            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKORGID,j.FMATERIALID,j.FSTOCKID,j.FSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,isnull(j.FBASEQTY,0),j.FUNITID,isnull(j.FQTY,0)";
            sql += "\r\n 	from T_STK_OEMINSTOCK i with(nolock) --受托加工材料入库单";
            sql += "\r\n 	inner join T_STK_OEMINSTOCKENTRY j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C'";

            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKORGID,j.FMATERIALID,j.FSTOCKID,j.FSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,isnull(j.FBASEGAINQTY,0),j.FUNITID,isnull(j.FGAINQTY,0)";
            sql += "\r\n 	from T_STK_STKCOUNTGAIN i with(nolock) --盘盈单";
            sql += "\r\n 	inner join T_STK_STKCOUNTGAINENTRY j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C'";

            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKORGID,j.FMATERIALID,j.FSTOCKID,j.FSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,isnull(j.FBASEQTY,0),j.FUNITID,isnull(j.FQTY,0)";
            sql += "\r\n 	from T_STK_MISCELLANEOUS i with(nolock) --其他入库单";
            sql += "\r\n 	inner join T_STK_MISCELLANEOUSENTRY j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C'";

            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKORGID,j.FMATERIALID,j.FSTOCKID,j.FSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,isnull(j.FBASEREALQTY,0),j.FUNITID,isnull(j.FREALQTY,0)";
            sql += "\r\n 	from T_REM_INSTOCK i with(nolock) --生产线产品入库单";
            sql += "\r\n 	inner join T_REM_INSTOCKENTRY j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C'";

            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKORGID,j.FMATERIALID,j.FSTOCKID,j.FSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,isnull(j.FBASEQTY,0),j.FUNITID,isnull(j.FQTY,0)";
            sql += "\r\n 	from T_REM_RETURNMTRL i with(nolock) --生产线退料单";
            sql += "\r\n 	inner join T_REM_RETURNMTRLENTRY j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C'";

            sql += "\r\n 	------出库";
            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKORGID,j.FMATERIALID,j.FSTOCKID,j.FSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,-1*isnull(j.FBASEUNITQTY,0),j.FUNITID,-1*isnull(j.FREALQTY,0)";
            sql += "\r\n 	from T_SAL_OUTSTOCK i with(nolock) --销售出库单";
            sql += "\r\n 	inner join T_SAL_OUTSTOCKENTRY j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C' ";

            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKORGID,j.FMATERIALID,j.FSTOCKID,j.FSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,-1*isnull(j.FBASEACTUALQTY,0),j.FUNITID,-1*isnull(j.FACTUALQTY,0)";
            sql += "\r\n 	from T_PRD_PICKMTRL i with(nolock) --生产领料单";
            sql += "\r\n 	inner join T_PRD_PICKMTRLDATA j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C'";

            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKORGID,j.FMATERIALID,j.FSTOCKID,j.FSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,-1*isnull(j.FBASEACTUALQTY,0),j.FUNITID,-1*isnull(j.FACTUALQTY,0)";
            sql += "\r\n 	from T_SP_PICKMTRL i with(nolock) --简单生产领料单";
            sql += "\r\n 	inner join T_SP_PICKMTRLDATA j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C'";

            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKORGID,j.FMATERIALID,j.FSTOCKID,j.FSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,-1*isnull(j.FBASEREALQTY,0),j.FUNITID,-1*isnull(j.FREALQTY,0)";
            sql += "\r\n 	from T_PRD_RESTOCK i with(nolock) --生产退库单";
            sql += "\r\n 	inner join T_PRD_RESTOCKENTRY j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C'";

            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKORGID,j.FMATERIALID,j.FSTOCKID,j.FSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,-1*isnull(j.FBASEOUTQTY,0),j.FUNITID,-1*isnull(j.FOUTQTY,0)";
            sql += "\r\n 	from T_SP_OUTSTOCK i with(nolock) --简单生产退库单";
            sql += "\r\n 	inner join T_SP_OUTSTOCKENTRY j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C'";

            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKORGID,j.FMATERIALID,j.FSTOCKID,j.FSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j2.FBASEUNITID,-1*isnull(j2.FBASEACTUALQTY,0),j2.FUNITID,-1*isnull(j2.FACTUALQTY,0)";
            sql += "\r\n 	from T_PRD_FEEDMTRL i with(nolock) --生产补料单";
            sql += "\r\n 	inner join T_PRD_FEEDMTRLDATA j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	inner join T_PRD_FEEDMTRLDATA_Q j2 with(nolock) on j.FID=j2.FID and j.FENTRYID=j2.FENTRYID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C'";

            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKORGID,j.FMATERIALID,j.FSTOCKID,j.FSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,-1*isnull(j.FBASEACTUALQTY,0),j.FUNITID,-1*isnull(j.FACTUALQTY,0)";
            sql += "\r\n 	from T_SUB_PICKMTRL i with(nolock) --委外领料单";
            sql += "\r\n 	inner join T_SUB_PICKMTRLDATA j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C'";

            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKORGID,j.FMATERIALID,j.FSTOCKID,j.FSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j2.FBASEUNITID,-1*isnull(j2.FBASEACTUALQTY,0),j2.FUNITID,-1*isnull(j2.FACTUALQTY,0)";
            sql += "\r\n 	from T_SUB_FEEDMTRL i with(nolock) --委外补料单";
            sql += "\r\n 	inner join T_SUB_FEEDMTRLENTRY j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	inner join T_SUB_FEEDMTRLENTRY_Q j2 with(nolock) on j.FID=j2.FID and j.FENTRYID=j2.FENTRYID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C'";

            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKORGID,j.FMATERIALID,j.FSTOCKID,j.FSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,-1*isnull(j.FBASEUNITQTY,0),j.FUNITID,-1*isnull(j.FCONSUMEQTY,0)";
            sql += "\r\n 	from T_SUB_EXCONSUME i with(nolock) --委外超耗单";
            sql += "\r\n 	inner join T_SUB_EXCONSUMEENTRY j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C'";

            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKORGID,j.FMATERIALID,j.FSTOCKID,j.FSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,-1*isnull(j.FBASEUNITQTY,0),j.FUNITID,-1*isnull(j.FRMREALQTY,0)";
            sql += "\r\n 	from T_PUR_MRB i with(nolock) --采购退料单";
            sql += "\r\n 	inner join T_PUR_MRBENTRY j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C'";

            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKORGID,j.FMATERIALID,j.FSTOCKID,j.FSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,-1*isnull(j.FBASELOSSQTY,0),j.FUNITID,-1*isnull(j.FLOSSQTY,0)";
            sql += "\r\n 	from T_STK_STKCOUNTLOSS i with(nolock) --盘亏单";
            sql += "\r\n 	inner join T_STK_STKCOUNTLOSSENTRY j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C'";

            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKORGID,j.FMATERIALID,j.FSTOCKID,j.FSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,-1*isnull(j.FBASEQTY,0),j.FUNITID,-1*isnull(j.FQTY,0)";
            sql += "\r\n 	from T_STK_MISDELIVERY i with(nolock) --其他出库单";
            sql += "\r\n 	inner join T_STK_MISDELIVERYENTRY j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C'";

            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKORGID,j.FMATERIALID,j.FSTOCKID,j.FSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,-1*isnull(j.FBASEREALQTY,0),j.FUNITID,-1*isnull(j.FREALQTY,0)";
            sql += "\r\n 	from T_REM_OUTSTOCK i with(nolock) --生产线产品退库单";
            sql += "\r\n 	inner join T_REM_OUTSTOCKENTRY j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C'";

            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKORGID,j.FMATERIALID,j.FSTOCKID,j.FSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,-1*isnull(j.FBASEQTY,0),j.FUNITID,-1*isnull(j.FQTY,0)";
            sql += "\r\n 	from T_STK_OEMINSTOCKRTN i with(nolock) --受托加工材料退料单";
            sql += "\r\n 	inner join T_STK_OEMINSTOCKRTNENTRY j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C'";

            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKORGID,j.FMATERIALID,j.FSTOCKID,j.FSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,-1*isnull(j.FBASEACTUALQTY,0),j.FUNITID,-1*isnull(j.FACTUALQTY,0)";
            sql += "\r\n 	from T_REM_PICKMTRL i with(nolock) --生产线领料单";
            sql += "\r\n 	inner join T_REM_PICKMTRLDATA j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C'";

            sql += "\r\n 	----调拨";
            sql += "\r\n 	--union all";
            sql += "\r\n 	--select i.FAPPROVEDATE,i.FSTOCKORGID,j.FMATERIALID,j.FDESTSTOCKID,j.FDESTSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	--j.FBASEUNITID,isnull(j.FBASEQTY,0),j.FUNITID,isnull(j.FQTY,0)";
            sql += "\r\n 	--from T_STK_STKTRANSFERIN i with(nolock) --直接调拨单-调入";
            sql += "\r\n 	--inner join T_STK_STKTRANSFERINENTRY j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	--WHERE FDOCUMENTSTATUS='C' and FOBJECTTYPEID='STK_TransferDirect'";




            sql += "\r\n 	--union all";
            sql += "\r\n 	--select i.FAPPROVEDATE,i.FSTOCKOUTORGID,j.FMATERIALID,j.FSRCSTOCKID,j.FSRCSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	--j.FBASEUNITID,-1*isnull(j.FBASEQTY,0),j.FUNITID,-1*isnull(j.FQTY,0)";
            sql += "\r\n 	--from T_STK_STKTRANSFERIN i with(nolock) --直接调拨单-调出";
            sql += "\r\n 	--inner join T_STK_STKTRANSFERINENTRY j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	--WHERE FDOCUMENTSTATUS='C' and FOBJECTTYPEID='STK_TransferDirect'";

            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKORGID,j.FMATERIALID,j.FDESTSTOCKID,j.FDESTSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,isnull(j.FBASEQTY,0),j.FUNITID,isnull(j.FQTY,0)";
            sql += "\r\n 	from T_STK_STKTRANSFERIN i with(nolock) --分步式调入单-调入";
            sql += "\r\n 	inner join T_STK_STKTRANSFERINENTRY j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C' and FOBJECTTYPEID='STK_TRANSFERIN' ";

            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKOUTORGID,j.FMATERIALID,j.FSRCSTOCKID,j.FSRCSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,-1*isnull(j.FBASEQTY,0),j.FUNITID,-1*isnull(j.FQTY,0)";
            sql += "\r\n 	from T_STK_STKTRANSFERIN i with(nolock) --分步式调入单-调出";
            sql += "\r\n 	inner join T_STK_STKTRANSFERINENTRY j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C' and FOBJECTTYPEID='STK_TRANSFERIN' ";

            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKINORGID,j.FMATERIALID,j.FDESTSTOCKID,j.FDESTSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,isnull(j.FBASEQTY,0),j.FUNITID,isnull(j.FQTY,0)";
            sql += "\r\n 	from T_STK_STKTRANSFEROUT i with(nolock) --分步式调出单-调入";
            sql += "\r\n 	inner join T_STK_STKTRANSFEROUTENTRY j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C'  and FOBJECTTYPEID='STK_TRANSFERIN' ";

            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKORGID,j.FMATERIALID,j.FSRCSTOCKID,j.FSRCSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,-1*isnull(j.FBASEQTY,0),j.FUNITID,-1*isnull(j.FQTY,0)";
            sql += "\r\n 	from T_STK_STKTRANSFEROUT i with(nolock) --分步式调出单-调出";
            sql += "\r\n 	inner join T_STK_STKTRANSFEROUTENTRY j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C' and FOBJECTTYPEID='STK_TRANSFERIN' ";

            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKORGID,j.FMATERIALID,j.FDESTSTOCKID,j.FDESTSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,isnull(j.FBASEQTY,0),j.FUNITID,isnull(j.FQTY,0)";
            sql += "\r\n 	from T_REM_STKTRANSFERIN i with(nolock) --生产线仓库调拨单-调入";
            sql += "\r\n 	inner join T_REM_STKTRANSFERINENTRY j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C'";

            sql += "\r\n 	union all";
            sql += "\r\n 	select i.FAPPROVEDATE,i.FSTOCKOUTORGID,j.FMATERIALID,j.FSRCSTOCKID,j.FSRCSTOCKLOCID,j.FLOT,";
            sql += "\r\n 	j.FBASEUNITID,-1*isnull(j.FBASEQTY,0),j.FUNITID,-1*isnull(j.FQTY,0)";
            sql += "\r\n 	from T_REM_STKTRANSFERIN i with(nolock) --生产线仓库调拨单-调出";
            sql += "\r\n 	inner join T_REM_STKTRANSFERINENTRY j with(nolock) on i.FID=j.FID";
            sql += "\r\n 	WHERE FDOCUMENTSTATUS='C'";
            sql += "\r\n ) i";
            sql += "\r\n inner join ";
            sql += "\r\n 		(";
            sql += "\r\n 			select i.FMATERIALID,i.FNUMBER,j.FNAME from T_BD_MATERIAL i with(nolock)--物料";
            sql += "\r\n 			inner join T_BD_MATERIAL_L j with(nolock) on i.FMATERIALID=j.FMATERIALID";
            sql += "\r\n 			where j.FLOCALEID=2052 ";
            sql += "\r\n 			and i.FMATERIALID in (select FMATERIALID from t_BD_MaterialBase where FISINVENTORY=1)";
            sql += "\r\n 		) FMAT on i.FMATERIALID=FMAT.FMATERIALID";


            sql += "\r\n left join ";
            sql += "\r\n 		(";
            sql += "\r\n 			select i.FSTOCKID,i.FNUMBER,j.FNAME from T_BD_STOCK i with(nolock)--仓库";
            sql += "\r\n 			inner join T_BD_STOCK_L j with(nolock) on i.FSTOCKID=j.FSTOCKID";
            sql += "\r\n 			where j.FLOCALEID=2052 ";
            sql += "\r\n 		) FSTO on i.FSTOCKID=FSTO.FSTOCKID";
            sql += "\r\n left join ";
            sql += "\r\n 		(";
            sql += "\r\n 			select i.FORGID,i.FNUMBER,j.FNAME from T_ORG_ORGANIZATIONS i with(nolock)--组织";
            sql += "\r\n 			inner join T_ORG_ORGANIZATIONS_L j with(nolock) on i.FORGID=j.FORGID";
            sql += "\r\n 			where j.FLOCALEID=2052 ";
            sql += "\r\n 		) FORG on i.FSTOCKORGID=FORG.FORGID";
            sql += "\r\n left join ";
            sql += "\r\n 		(";
            sql += "\r\n 			select i.FUNITID,i.FNUMBER,j.FNAME from T_BD_UNIT i with(nolock)--基本单位";
            sql += "\r\n 			inner join T_BD_UNIT_L j with(nolock) on i.FUNITID=j.FUNITID";
            sql += "\r\n 			where j.FLOCALEID=2052 ";
            sql += "\r\n 		) FBASEUNI on i.FBASEUNITID=FBASEUNI.FUNITID";

            sql += "\r\n left join ";
            sql += "\r\n 		(";
            sql += "\r\n 			select i.FUNITID,i.FNUMBER,j.FNAME from T_BD_UNIT i with(nolock)--单位";
            sql += "\r\n 			inner join T_BD_UNIT_L j with(nolock) on i.FUNITID=j.FUNITID";
            sql += "\r\n 			where j.FLOCALEID=2052 ";
            sql += "\r\n 		) FUNI on i.FUNITID=FUNI.FUNITID";
            return sql;
        }
    }
    public class ROOT
    {
        public string FormId {get;set;}
        public string FieldKeys {get;set;}
        public string FilterString {get;set;}
        public string GroupString { get; set; }
        public string OrderString {get;set;}
        public int TopRowCount {get;set;}
        
    }
    public class RETURNROOT
    {
        public bool Success { get; set; }
        public DataTable DataTable { get; set; }
        public List<string> Exception { get; set; }
    }
}

服务地址：
http://ServerIp/K3Cloud/接口命名空间.接口实现类名.方法,组件名.common.kdsvc
例如：
“http://192.168.66.60/k3cloud/ApiServiceTest.AAA.CustomBusinessService.ExecuteService,ApiServiceTest.AAA.common.kdsvc”
需要注意的是，自定义webapi接口服务地址中比其他标准接口地址多了一个组件名，如果需要和其他其他标准接口保持一致，则二开自定义的webapi接口命名空间必须以.ServicesStub结尾，例如以下示例自定义接口则其服务地址可以参考如下格式：
“http://192.168.66.60/k3cloud/Kingdee.K3Erp.WebAPI.ServiceExtend.ServicesStub.CustomBusinessService ExecuteService.common.kdsvc”

C#程序示例
我的资源中下载
KingDee.api.ServicesStub.rar

凌晨四点♛
关注
专栏目录
金蝶云 WebAPI接口说明书_V4.0.docx
10-12
金蝶云星空WebAPI接口文档4.0版本 用于金蝶Cloud产品的接口开发调用 cloud和k3 wise还是有很大区别的，希望能帮到大家
金蝶云 自定义WebAPI接口 c#程序示例
10-05
金蝶云 自定义WebAPI接口 c#程序示例 接口的封装及调用（无引用组件示例（不引用金蝶的组件））
如何与金蝶系统进行接口对接
最新发布
qq_46132384的博客
07-11 1425
在进行接口对接时候需要根据金蝶那边传来的json字段进行分析，金蝶的新增和保存接口巨繁琐，需要特别注意，解析字段，我们需要传给金蝶什么字段数据，然后根据自己的实际情况，进行传输。通过创建请求对象并设置查询参数，然后使用 Retrofit 和 RxJava 发起网络请求并处理响应，将返回的响应赋值给。综上所述大致步骤分为创建 Retrofitv，创建 API 接口实例，发起请求，处理响应，监听状态等。
金蝶云 WebAPI接口说明书_V4.0.docx,金蝶webapi万能接口,PHP源码.zip
10-15
金蝶云 WebAPI接口说明书_V4.0.docx,金蝶webapi万能接口,PHP源码
C# 金蝶WEB API
GuestingNew的博客
05-18 2343
PS. 金蝶的DLL大家只能自己找资源了~博客不能发发这些； 至于代码上我写了很多注释，主要是方便接手的人看，闲注释累赘的自行删减吧，或者cs编辑区右键→【大纲显示】→【折叠到定义】即可~ 引用参考 工具类 /// <summary> /// 金蝶接口 /// 数据字典（详见辅助资料列表） /// </summary> public class JinDieAPIHelper { /// <summary>
金蝶 webservice接口 文档
12-21
金蝶 boswebservice接口的相关文档，包括 BOS V6.2 WebService.pdf和WebService总账（凭证引入）接口说明.pdf，我的第二个金蝶项目就全靠它俩了
Python跟金蝶WebAPI进行做对接
热门推荐
Ghjkku的博客
05-19 13万+
Python做WebAPI对接—登陆接口：https://club.kingdee.com/forum.php?mod=viewthread&tid=1484661 Python做WebAPI对接—基础资料保存接口：https://club.kingdee.com/forum.php?mod=viewthread&tid=1485021 Python做Web API对接—单据保存接口(无源单)：https://club.kingdee.com/forum.php?mod=viewthr.
金蝶云 自定义WebAPI接口 c#程序示例.rar
01-17
本示例主要围绕“金蝶云 自定义WebAPI接口 c#程序”进行，旨在帮助开发者理解如何在C#环境中与金蝶云的API进行交互。 在C#中开发对接金蝶云的WebAPI接口，你需要了解以下关键知识点： 1. **金蝶云API文档**：首先...
金蝶云（K3/cloud）webapi 开发实例
02-08
金蝶云（K3/cloud）WebAPI开发实例是针对企业级财务管理软件金蝶云的API接口进行编程实践的示例项目。金蝶云，原名K3，是金蝶国际软件集团推出的一款云端ERP解决方案，它为企业提供了全面的财务、供应链、生产制造等...
金蝶云星空WEBAPI接口说明文档
11-15
金蝶云星空WEBAPI接口说明文档是一份详细的开发者指南，旨在帮助具备开发能力的用户利用金蝶云的API接口，实现与其他业务系统的集成。金蝶云作为一款先进的企业管理软件，提供了丰富的API功能，使得企业可以自定义...
金蝶接口API说明书，金蝶云星空平台API调用接口说明
04-11
##### 自定义WebAPI接口 除了上述标准接口外，金蝶云星空还支持开发人员根据自身需求定制API接口。 #### 结论 金蝶接口API说明书是金蝶云星空平台进行系统集成的重要参考文档。通过对这份文档的学习和理解，开发...
金蝶调用Webservice接口-SOAP
03-01
金蝶调用第三方webservice接口以soap方式实现，包括创建服务service、DIspatch、SOAPMessage、QName、封装数据、Dispatch传递消息、消息转换为doc对象、调用结果判断等
金蝶webapi，网页调用实例，查询单据及其对数据进行转换.doc
04-20
金蝶webapi实例，新手看了也懂的，超实用，脱离sdk，非常详细，后期需要其他方法的调用可以私聊我。
对接金蝶的demo，帮助快速对接金蝶webapi
06-23
对接金蝶的demo，帮助快速对接金蝶webapi，金蝶，java，webapi帮助工具
C# WebAPI示例
05-16
C# WebAPI示例 C# WebAPI示例 C# WebAPI示例C# WebAPI示例
金蝶k3cloudWebAP接口实例
05-03
金蝶k3cloudAPI接口,.net C# 编写，很多代码，有插件和很多复杂的API项目实例，这里不上传，需要具体可以联系我；
金蝶K3 webservice接口
weixin_52395937的博客
11-19 1386
一． “凭证引入”技术方案 其他业务系统数据，传输到EAS系统服务器，通过凭证引入“webservice接口”，转化为EAS数据。 其他业务系统内的资金流动信息，实时地、非人工干预的传递到EAS系统，以财务凭证的形式，转化为EAS系统内的财务信息。 二． “凭证引入”技术规范 EAS系统提供WebService 服务，以及产生EAS财务凭证的接口，供其他业务系统调用。 WebService 服务：金蝶在EAS系统上发布WebService服务，提供wsdl文件供客户端下载，其他业务系统根据下载的wsdl文件
调用金蝶保存接口。
weixin_42601547的博客
01-03 750
金蝶保存接口可以用来保存数据到金蝶软件中。要使用这个接口，你需要先获取金蝶软件的API文档，然后根据文档中的说明调用相应的API即可。 你需要注意，调用金蝶保存接口前，你需要先进行相应的身份认证，才能获得调用接口的权限。 例如，你可以使用以下的代码来调用金蝶保存接口： import requests # 设置身份认证信息 auth = ('username', 'password') # 设置...
java对接金蝶webapi
Strive_789的博客
07-10 844
然后又出现新的问题，提交可以提交了，发现，哎，怎么数据不一样啊，有一些数据金蝶会自己补充的数据怎么没有了，我后面也加上了这个字段还是不行，行吧，用金蝶自己端里面的测试工具提交数据，是没问题的，自己用java对接提交的数据是有问题的。对了十几遍，想办法把自己api提交的json和金蝶端里面的测试工具填数据生成的json做成一样的，一个不漏，还是不行，我怀疑人生了。好吧我写了一个json对比代码，进行了对比，简直就是一模一样，提交还是不行。好吧，我发现了一个可以对比json的网站，都丢上去，发现还是一样，这。
评论 3
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值