1.工单派发校验工价，工价未提前设置或设置部分，如果开关关闭时,不校验是否未设置 或者未设置全，工价复制表中都会写入，没有设置的工价就默认0 如果开关...

yl

2023-10-10 32c0daf9a78039004bb6c39d578f7734f13d54b1

 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";