生产开报工查询增加销售单号查询

yl

2023-11-22 bfa0a4079b2ac3f363826b7e329115f88b4bf0f5

 VueWebApi/DLL/DAL/ErpSyncMesDAL.cs

@@ -1,6 +1,7 @@
using Dapper;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using VueWebApi.Tools;
@@ -196,15 +197,39 @@
        #endregion

        #region[生产管理：生产订单同步]
        public static ToMessage SeaveSearchErpOrder()
        public static ToMessage SeaveSearchErpOrder(string stu_torgcode,string stu_torgtypecode)
        {
            var sql = "";
            var dynamicParams = new DynamicParameters();
            try
            {
                if (stu_torgcode == "" || stu_torgcode == null)
                {
                    stu_torgcode = "";
                }
                if (stu_torgtypecode == "D")
                {
                    sql = @" with CTE as (
                           select id, org_code,org_name, parent_id
                           from TOrganization A
                           where org_code =@stu_torgcode
                           union all
                           select A.id,A.org_code,A.org_name,A.parent_id
                           from TOrganization A
                           inner join CTE on A.parent_id = CTE.id
                           )
                           select org_code,org_name from CTE";
                    dynamicParams.Add("@stu_torgcode", stu_torgcode);
                    var data = DapperHelper.selectdata(sql, dynamicParams);
                    stu_torgcode=string.Join(",", data.AsEnumerable().Select(row => row.Field<string>("org_code")));
                    //stu_torgcode = string.Join(",", data.AsEnumerable().Select(row => $"'{row.Field<string>("org_code")}'"));
                    //LogHelper.WriteLogData("获取车间编码："+stu_torgcode);
                }
                //存储过程名
                sql = @"h_p_IFCLD_ERPMO";
                bool a = DapperHelper.IsProcedureNo(sql);
                dynamicParams.Add("@stu_torgcode", stu_torgcode);
                dynamicParams.Add("@stu_torgtypecode", stu_torgtypecode);
                bool a = DapperHelper.IsProcedure(sql, dynamicParams);
                if (a)
                {
                    mes.code = "200";
@@ -230,5 +255,41 @@
            return mes;
        }
        #endregion

        #region[采购管理：采购订单同步]
        public static ToMessage SeaveSearchErpPurchaseOrder()
        {
            var sql = "";
            var dynamicParams = new DynamicParameters();
            try
            {
                //存储过程名
                sql = @"h_p_IFCLD_ERPPurchaseOrder";
                bool a = DapperHelper.IsProcedureNo(sql);
                if (a)
                {
                    mes.code = "200";
                    mes.count = 0;
                    mes.Message = "同步采购订单成功!";
                    mes.data = null;
                }
                else
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "同步采购订单失败!";
                    mes.data = null;
                }
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion
    }
}