nothing

ch

2021-04-29 686c4af65faac6302083a9a1d22b672ca031e26e

nothing

 WebAPI/Controllers/BLL/Xt_AccountPeriodController.cs

New file
@@ -0,0 +1,73 @@
using Newtonsoft.Json.Linq;
using Pub_Class;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Web.Http;
using WebAPI.Models;
namespace WebAPI.Controllers
{
    public class Xt_AccountPeriodController : ApiController
    {
        public DBUtility.ClsPub.Enum_BillStatus BillStatus;

        private json objJsonResult = new json();
        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
        DataSet ds;


        /// <summary>
        /// 返回会计期间列表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("Xt_AccountPeriod/list")]
        [HttpGet]
        public object list(string sWhere)
        {
            try
            {
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_Xt_AccountPeriodList " + sWhere, "h_v_Xt_AccountPeriodList");
                }
                else
                {
                    string sql1 = "select * from h_v_Xt_AccountPeriodList where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    ds = oCN.RunProcReturn(sql, "h_v_Xt_AccountPeriodList");
                }
                if (ds == null || ds.Tables[0].Rows.Count == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "没有返回任何记录！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                else
                {
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "Sucess！";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }



        //
    }
}

 WebAPI/Controllers/BLL/Xt_BillTypeController.cs

New file
@@ -0,0 +1,73 @@
using Newtonsoft.Json.Linq;
using Pub_Class;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Web.Http;
using WebAPI.Models;
namespace WebAPI.Controllers
{
    public class Xt_BillTypeController : ApiController
    {
        public DBUtility.ClsPub.Enum_BillStatus BillStatus;

        private json objJsonResult = new json();
        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
        DataSet ds;


        /// <summary>
        /// 返回单据类型列表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("Xt_BillType/list")]
        [HttpGet]
        public object list(string sWhere)
        {
            try
            {
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_Xt_BillTypeList " + sWhere, "h_v_Xt_BillTypeList");
                }
                else
                {
                    string sql1 = "select * from h_v_Xt_BillTypeList where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    ds = oCN.RunProcReturn(sql, "h_v_Xt_BillTypeList");
                }
                if (ds == null || ds.Tables[0].Rows.Count == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "没有返回任何记录！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                else
                {
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "Sucess！";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }



        //
    }
}

 WebAPI/Controllers/BLL/Xt_SystemLogController.cs

New file
@@ -0,0 +1,73 @@
using Newtonsoft.Json.Linq;
using Pub_Class;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Web.Http;
using WebAPI.Models;
namespace WebAPI.Controllers
{
    public class Xt_SystemLogController : ApiController
    {
        public DBUtility.ClsPub.Enum_BillStatus BillStatus;

        private json objJsonResult = new json();
        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
        DataSet ds;


        /// <summary>
        /// 返回系统日志信息列表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("Xt_SystemLog/list")]
        [HttpGet]
        public object list(string sWhere)
        {
            try
            {
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_Xt_SystemLogList " + sWhere + " order by 日期 desc", "h_v_Xt_SystemLogList");
                }
                else
                {
                    string sql1 = "select * from h_v_Xt_SystemLogList where 1 = 1 ";
                    string sql = sql1 + sWhere + " order by 日期 desc";
                    ds = oCN.RunProcReturn(sql, "h_v_Xt_SystemLogList");
                }
                if (ds == null || ds.Tables[0].Rows.Count == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "没有返回任何记录！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                else
                {
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "Sucess！";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }



        //
    }
}

 WebAPI/Controllers/BLL/Xt_SystemParameterController.cs

New file
@@ -0,0 +1,73 @@
using Newtonsoft.Json.Linq;
using Pub_Class;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Web.Http;
using WebAPI.Models;
namespace WebAPI.Controllers
{
    public class Xt_SystemParameterController : ApiController
    {
        public DBUtility.ClsPub.Enum_BillStatus BillStatus;

        private json objJsonResult = new json();
        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
        DataSet ds;


        /// <summary>
        /// 返回系统参数列表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("Xt_SystemParameter/list")]
        [HttpGet]
        public object list(string sWhere)
        {
            try
            {
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_Xt_SystemParameterList " + sWhere, "h_v_Xt_SystemParameterList");
                }
                else
                {
                    string sql1 = "select * from h_v_Xt_SystemParameterList where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    ds = oCN.RunProcReturn(sql, "h_v_IF_Proh_v_Xt_SystemParameterListpertyList");
                }
                if (ds == null || ds.Tables[0].Rows.Count == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "没有返回任何记录！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                else
                {
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "Sucess！";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }



        //
    }
}

 WebAPI/Controllers/BLL/Xt_UserController.cs

New file
@@ -0,0 +1,73 @@
using Newtonsoft.Json.Linq;
using Pub_Class;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Web.Http;
using WebAPI.Models;
namespace WebAPI.Controllers
{
    public class Xt_UserController : ApiController
    {
        public DBUtility.ClsPub.Enum_BillStatus BillStatus;

        private json objJsonResult = new json();
        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
        DataSet ds;


        /// <summary>
        /// 返回系统用户列表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("Xt_User/list")]
        [HttpGet]
        public object list(string sWhere)
        {
            try
            {
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_IF_UserList " + sWhere, "h_v_IF_UserList");
                }
                else
                {
                    string sql1 = "select * from h_v_IF_UserList where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    ds = oCN.RunProcReturn(sql, "h_v_IF_UserList");
                }
                if (ds == null || ds.Tables[0].Rows.Count == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "没有返回任何记录！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                else
                {
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "Sucess！";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }



        //
    }
}

 WebAPI/Controllers/BLL/Xt_UserGroupController.cs

New file
@@ -0,0 +1,73 @@
using Newtonsoft.Json.Linq;
using Pub_Class;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Web.Http;
using WebAPI.Models;
namespace WebAPI.Controllers
{
    public class Xt_UserGroupController : ApiController
    {
        public DBUtility.ClsPub.Enum_BillStatus BillStatus;

        private json objJsonResult = new json();
        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
        DataSet ds;


        /// <summary>
        /// 返回用户角色列表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("Xt_UserGroup/list")]
        [HttpGet]
        public object list(string sWhere)
        {
            try
            {
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_System_UserGroup " + sWhere, "h_v_System_UserGroup");
                }
                else
                {
                    string sql1 = "select * from h_v_System_UserGroup where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    ds = oCN.RunProcReturn(sql, "h_v_System_UserGroup");
                }
                if (ds == null || ds.Tables[0].Rows.Count == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "没有返回任何记录！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                else
                {
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "Sucess！";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }



        //
    }
}

 WebAPI/Controllers/BLL/Xt_XtgnbController.cs

New file
@@ -0,0 +1,73 @@
using Newtonsoft.Json.Linq;
using Pub_Class;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Web.Http;
using WebAPI.Models;
namespace WebAPI.Controllers
{
    public class Xt_XtgnbController : ApiController
    {
        public DBUtility.ClsPub.Enum_BillStatus BillStatus;

        private json objJsonResult = new json();
        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
        DataSet ds;


        /// <summary>
        /// 返回系统模块列表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("Xt_Xtgnb/list")]
        [HttpGet]
        public object list(string sWhere)
        {
            try
            {
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_Xt_XtgnbList " + sWhere, "h_v_Xt_XtgnbList");
                }
                else
                {
                    string sql1 = "select * from h_v_Xt_XtgnbList where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    ds = oCN.RunProcReturn(sql, "h_v_Xt_XtgnbList");
                }
                if (ds == null || ds.Tables[0].Rows.Count == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "没有返回任何记录！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                else
                {
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "Sucess！";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }



        //
    }
}

 WebAPI/Controllers/BaseSet/Gy_PropertyController.cs

New file
@@ -0,0 +1,73 @@
using Newtonsoft.Json.Linq;
using Pub_Class;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Web.Http;
using WebAPI.Models;
namespace WebAPI.Controllers
{
    public class Gy_PropertyController : ApiController
    {
        public DBUtility.ClsPub.Enum_BillStatus BillStatus;

        private json objJsonResult = new json();
        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
        DataSet ds;


        /// <summary>
        /// 返回辅助属性列表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("Gy_Property/list")]
        [HttpGet]
        public object list(string sWhere)
        {
            try
            {
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_IF_PropertyList " + sWhere, "h_v_IF_PropertyList");
                }
                else
                {
                    string sql1 = "select * from h_v_IF_PropertyList where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    ds = oCN.RunProcReturn(sql, "h_v_IF_PropertyList");
                }
                if (ds == null || ds.Tables[0].Rows.Count == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "没有返回任何记录！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                else
                {
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "Sucess！";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }



        //
    }
}

 WebAPI/Controllers/BaseSet/Xt_ORGANIZATIONSController.cs

New file
@@ -0,0 +1,73 @@
using Newtonsoft.Json.Linq;
using Pub_Class;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Web.Http;
using WebAPI.Models;
namespace WebAPI.Controllers
{
    public class Xt_ORGANIZATIONSController : ApiController
    {
        public DBUtility.ClsPub.Enum_BillStatus BillStatus;

        private json objJsonResult = new json();
        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
        DataSet ds;


        /// <summary>
        /// 返回组织列表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("Xt_ORGANIZATIONS/list")]
        [HttpGet]
        public object list(string sWhere)
        {
            try
            {
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_IF_ORGANIZATIONSList " + sWhere, "h_v_IF_ORGANIZATIONSList");
                }
                else
                {
                    string sql1 = "select * from h_v_IF_ORGANIZATIONSList where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    ds = oCN.RunProcReturn(sql, "h_v_IF_ORGANIZATIONSList");
                }
                if (ds == null || ds.Tables[0].Rows.Count == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "没有返回任何记录！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                else
                {
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "Sucess！";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }



        //
    }
}

 WebAPI/Controllers/JHGL/Gy_RoutingBillController.cs

New file
@@ -0,0 +1,288 @@
using Newtonsoft.Json.Linq;
using Pub_Class;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Web.Http;
using WebAPI.Models;

namespace WebAPI.Controllers
{
    //工艺路线Controller
    public class Gy_RoutingBillController : ApiController
    {
        public DBUtility.ClsPub.Enum_BillStatus BillStatus;

        private json objJsonResult = new json();
        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
        DataSet ds;


        /// <summary>
        /// 返回工艺路线列表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("Gy_RoutingBill/list")]
        [HttpGet]
        public object list(string sWhere)
        {
            try
            {
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_MES_StationEntrustOutBillList " + sWhere, "h_v_MES_StationEntrustOutBillList");
                }
                else
                {
                    string sql1 = "select * from h_v_MES_StationEntrustOutBillList where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    ds = oCN.RunProcReturn(sql, "h_v_MES_StationEntrustOutBillList");
                }
                if (ds == null || ds.Tables[0].Rows.Count == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "false！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                else
                {
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "Sucess！";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }

        /// <summary>
        /// 新增单据-保存按钮
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("Gy_RoutingBill/AddBill")]
        [HttpPost]
        public object AddBill([FromBody] JObject sMainSub)
        {
            var _value = sMainSub["sMainSub"].ToString();
            string msg1 = _value.ToString();
            oCN.BeginTran();
            //保存主表
            objJsonResult = AddBillMain(msg1);
            if (objJsonResult.code == "0")
            {
                oCN.RollBack();
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = objJsonResult.Message;
                objJsonResult.data = null;
                return objJsonResult;
            }
            oCN.Commit();
            objJsonResult.code = "1";
            objJsonResult.count = 1;
            objJsonResult.Message = "新增单据成功！";
            objJsonResult.data = ds.Tables[0];
            return objJsonResult;
        }

        public json AddBillMain(string msg1)
        {
            string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
            string msg2 = sArray[0].ToString();
            string msg3 = sArray[1].ToString();
            try
            {
                msg2 = "[" + msg2.ToString() + "]";
                List<Gy_RoutingBill> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_RoutingBill>>(msg2);
                string BillType = "3301";
                long HInterID = mainList[0].HInterID;//递入type得到的单据ID
                string HBillNo = mainList[0].HBillNo;//递入type得到的单据号
                DateTime HDate = mainList[0].HDate;//日期
                int HYear = 2021;
                double HPeriod = 1;
                string HRemark = mainList[0].HRemark;//备注
                string HMaker = mainList[0].HMaker;//制单人
                long HMaterID = mainList[0].HMaterID;//产品ID
                string HName = mainList[0].HName;//工艺路线名称
                long HMaterTypeID = 0;
                long HRoutingGroupID = mainList[0].HRoutingGroupID;//工艺路线大类ID
                long HUnitID = mainList[0].HUnitID;//计量单位
                string HMaterNumber = mainList[0].HMaterNumber;//产品代码
                long HUnitNumber = mainList[0].HUnitID;//计量单位ID
                bool HStandard = mainList[0].HStandard;//是否默认工艺
                long HMainGroupID = mainList[0].HGroupID;//生产班组ID
                long HMainProcID = mainList[0].HMainProcID;//工序ID
                long HMainCenterID = mainList[0].HMainCenterID;//工作中心ID
                string HMainTimeUnit = mainList[0].HMainTimeUnit;//运行时间单位
                double HMainUnitTime = mainList[0].HMainUnitTime;//运行时间
                double HMainWorkQty = mainList[0].HMainWorkQty;//加工数量
                double HMainPrice = mainList[0].HMainPrice;//工价
                double HStdSourceQty = mainList[0].HStdSourceQty;//标准资源数
                double HAddSourceRate = mainList[0].HAddSourceRate;//加资源增量
                double HDelSourceRate = mainList[0].HDelSourceRate;//减资源减量

                //主表
                oCN.RunProc("Insert Into Gy_RoutingBillMain   " +
                "(HBillType,HInterID,HBillNo,HDate" +
                ",HYear,HPeriod,HRemark,HMaker,Hmakedate,HMaterID,HName,HMaterTypeID" +
                ",HRoutingGroupID,HUnitID,HMaterNumber,HUnitNumber,HStandard" +
                ",HMainGroupID,HMainProcID,HMainCenterID,HMainTimeUnit,HMainUnitTime,HMainWorkQty" +
                ",HMainPrice,HStdSourceQty,HAddSourceRate,HDelSourceRate" +
                ") " +
                " values('" + BillType + "'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" +
                "," + HYear + "," + HPeriod + ",'" + HRemark + "','" + HMaker + "',getdate()," + HMaterID + ",'" + HName + "'," + HMaterTypeID +
                "," + HRoutingGroupID + "," + HUnitID + ",'" + HMaterNumber + "','" + HUnitNumber + "'," + Convert.ToString(HStandard ? 1 : 0) +
                "," + HMainGroupID + "," + HMainProcID + "," + HMainCenterID + ",'" + HMainTimeUnit + "'," + HMainUnitTime + "," + HMainWorkQty +
                "," + HMainPrice + "," + HStdSourceQty + "," + HAddSourceRate + "," + HDelSourceRate +
                ") ");

                //保存子表
                objJsonResult = AddBillSub(msg3, HInterID);
                if (objJsonResult.code == "0")
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = objJsonResult.Message;
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                oCN.RunProc("exec h_p_Gy_RoutingBillCheck " + HInterID);  //设置默认工艺路线
                //判断是否重复工序号
                ds = oCN.RunProcReturn("exec h_p_Gy_RoutingCtrl " + HInterID, "h_p_Gy_RoutingCtrl");
                if (ds == null || ds.Tables[0].Rows.Count == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "判断重复工序号失败！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                else
                {
                    if (ClsPub.isStrNull(ds.Tables[0].Rows[0][0]) == "2")
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = ClsPub.isStrNull(ds.Tables[0].Rows[0][1]);
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                }
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = null;
                objJsonResult.data = null;
                return objJsonResult;
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }

        public json AddBillSub(string msg3,long HInterID) {
            List<Gy_RoutingBillSub> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_RoutingBillSub>>(msg3);
            for (int i=0;i< subList.ToArray().Length;i++)
            {
                if (subList[i].HWorkQty <= 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "第" + i + "行，加工数量不能为0或者小于0";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                long HCenterID = 0;//工作中心ID
                string HTimeUnit = "";//时间单位
                double HUnitTime = 0;//运行时间
                double HReadyTime = 0;//准备时间
                double HQueueTime = 0;//排队时间
                double HMoveTime = 0;//转移时间
                string HCloseMan = "";//关闭人
                bool HCloseType = false;//
                string HProcType = "";//工序类型
                bool HNextProcFlag = false;//下道流转工序
                bool HFlowProc = false;//流转工序
                double HFixPrice = 0;//班产定额
                double HProcPrice = 0;//工序工价
                double HBadPrice = 0;//不合格单价
                double HWasterPrice = 0;//报废单价
                bool HStdFlag = false;//标准定额
                double HBeginDayQty = 0;//开工余量（天数）
                double HBeginFixQty = 0;//开工余量（固数）
                long HSourceInterID = 0;//源单主内码
                long HSourceEntryID = 0;//源单子内码
                string HSourceBillNo = "";//源单单号
                string HSourceBillType = "";//源单类型
                double HRelationQty = 0;//关联数量
                double HRelationMoney = 0;//关联金额
                bool HAutoTrunFlag = false;//自动移转
                double HFixWorkDays = 0;//上道固定天数
                double HTrunWorkDays = 0;//上道循环周期
                double HReadyTimes = 0;//本道准备时间
                double HICMOReadyTimes = 0;//换单准备时间
                double HSubStdEmpQty = 0;//标准人数
                double HSubCanUseSourceQty = 0;//可操作设备数
                long HProcID_S = 0;//工段ID
                long HCenterID_S = 0;//产线中心ID
                double HWorkQty_S = 0;//产线产能
                double HSubStdEmpQty_S = 0;//产线人数
                string HMouldNo = "";//模具编号
                double HChangeMould = 0;//换模时间/换刀时间
                string HPackStd = "";//周转箱标准
                string HPack = "";//周转箱
                string HPutArea = "";//暂放区
                double HMyWorkDays = 0;//生产周期
                double HMyFixWorkDays = 0;//固定生产天数

                oCN.RunProc("Insert into Gy_RoutingBillSub " +
                      "(HInterID,HEntryID,HProcID,HProcNO,HSupID,HSupFlag" +
                      ",HWorkQty,HCenterID,HTimeUnit,HUnitTime" +
                      ",HReadyTime,HQueueTime,HMoveTime" +
                      ",HCloseMan,HCloseType,HRemark,HProcType,HNextProcFlag,HFlowProc" +
                      ",HFixPrice,HProcPrice,HBadPrice,HWasterPrice,HStdFlag,HBeginDayQty,HBeginFixQty" +
                      ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney,HAutoTrunFlag" +
                      ",HFixWorkDays,HTrunWorkDays,HReadyTimes,HICMOReadyTimes,HSubStdEmpQty,HSubCanUseSourceQty" +
                      ",HProcID_S,HCenterID_S,HWorkQty_S,HSubStdEmpQty_S,HMouldNo,HChangeMould" +
                      ",HPackStd,HPack,HPutArea,HMyWorkDays,HMyFixWorkDays,HPassRate" +
                      ") values("
                      + HInterID + "," + i + "," + subList[i].HProcID + "," + subList[i].HProcNo + "," + subList[i].HSupID + "," + Convert.ToString(subList[i].HSupFlag ? 1 : 0) + "" +
                      "," + subList[i].HWorkQty + "," + HCenterID + ",'" + HTimeUnit + "'," + HUnitTime +
                      "," + HReadyTime + "," + HQueueTime + "," + HMoveTime +
                      ",'" + HCloseMan + "'," + Convert.ToString(HCloseType ? 1 : 0) + ",'" + subList[i].HRemark + "','" + HProcType + "'," + Convert.ToString(HNextProcFlag ? 1 : 0) + "," + Convert.ToString(HFlowProc ? 1 : 0) +
                      "," + HFixPrice + "," + HProcPrice + "," + HBadPrice + "," + HWasterPrice + "," + Convert.ToString(HStdFlag ? 1 : 0) + "," + HBeginDayQty + "," + HBeginFixQty +
                      "," + HSourceInterID + "," + HSourceEntryID + ",'" + HSourceBillNo + "','" + HSourceBillType + "'," + HRelationQty + "," + HRelationMoney + "," + Convert.ToString(HAutoTrunFlag ? 1 : 0) +
                     "," + HFixWorkDays + "," + HTrunWorkDays + "," + HReadyTimes + "," + HICMOReadyTimes + "," + HSubStdEmpQty + "," + HSubCanUseSourceQty +
                     "," + HProcID_S + "," + HCenterID_S + "," + HWorkQty_S + ", " + HSubStdEmpQty_S + ",'" + HMouldNo + "'," + HChangeMould +
                     ",'" + HPackStd + "','" + HPack + "','" + HPutArea + "'," + HMyWorkDays + "," + HMyFixWorkDays + "," + subList[i].HPassRate +
                      ") ");
            }
            
            objJsonResult.code = "1";
            objJsonResult.count = 1;
            objJsonResult.Message = null;
            objJsonResult.data = null;
            return objJsonResult;
        }

        //
    }
}

 WebAPI/Controllers/Sc_ProcessMangementController.cs

@@ -479,13 +479,13 @@
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select top 500 * from WW_EntrustWorkOrderBillMain ", "WW_EntrustWorkOrderBillMain");
                    ds = oCN.RunProcReturn("select top 500 * from h_v_WW_EntrustWorkOrderBillList ", "h_v_WW_EntrustWorkOrderBillList");
                }
                else
                {
                    string sql1 = "select * from WW_EntrustWorkOrderBillMain where 1 = 1 ";
                    string sql1 = "select * from h_v_WW_EntrustWorkOrderBillList where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    ds = oCN.RunProcReturn(sql, "WW_EntrustWorkOrderBillMain");
                    ds = oCN.RunProcReturn(sql, "h_v_WW_EntrustWorkOrderBillList");
                }
            }
            catch (Exception e)
@@ -498,43 +498,6 @@
            }
            return GetObjectJson(ds);
        }


        /// <summary>
        /// 返回委外工序汇报单列表
        /// </summary>
        /// <param name="sWhere"></param>
        /// <returns></returns>
        [Route("Sc_ProcessMangement/MES_Sc_StationOutBillMain_Json")]
        [HttpGet]
        public object MES_Sc_StationOutBillMain_Json(string sWhere)
        {
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select top 500 * from Sc_StationOutBillMain ", "Sc_StationOutBillMain");
                }
                else
                {
                    string sql1 = "select * from Sc_StationOutBillMain where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    ds = oCN.RunProcReturn(sql, "Sc_StationOutBillMain");
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
            return GetObjectJson(ds);
        }


        /// <summary>
        /// 返回不合格评审列表
@@ -1359,7 +1322,110 @@
            }
        }

        /// <summary>
        /// 返回委外工序派工单列表
        /// </summary>
        /// <param name="sqlWhere"></param>
        /// <returns></returns>
        [Route("Sc_ProcessMangement/MES_WW_EntrustProcSendWorkBill_Json")]
        [HttpGet]
        public object MES_WW_EntrustProcSendWorkBill_Json(string sqlWhere)
        {
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (sqlWhere == null || sqlWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select top 500 * from h_v_WW_EntrustProcSendWorkBillList ", "h_v_WW_EntrustProcSendWorkBillList");
                }
                else
                {
                    string sql1 = "select * from h_v_WW_EntrustProcSendWorkBillList where 1 = 1 ";
                    string sql = sql1 + sqlWhere;
                    ds = oCN.RunProcReturn(sql, "h_v_WW_EntrustProcSendWorkBillList");
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
            return GetObjectJson(ds);
        }

        /// <summary>
        /// 返回委外工序计划汇报单列表
        /// </summary>
        /// <param name="sqlWhere"></param>
        /// <returns></returns>
        [Route("Sc_ProcessMangement/MES_WW_EntrustProcessReportBill_Json")]
        [HttpGet]
        public object MES_WW_EntrustProcessReportBill_Json(string sqlWhere)
        {
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (sqlWhere == null || sqlWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select top 500 * from h_v_WW_EntrustProcessReportBillList ", "h_v_WW_EntrustProcessReportBillList");
                }
                else
                {
                    string sql1 = "select * from h_v_WW_EntrustProcessReportBillList where 1 = 1 ";
                    string sql = sql1 + sqlWhere;
                    ds = oCN.RunProcReturn(sql, "h_v_WW_EntrustProcessReportBillList");
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
            return GetObjectJson(ds);
        }

        /// <summary>
        /// 返回委外工序计划转出单列表
        /// </summary>
        /// <param name="sqlWhere"></param>
        /// <returns></returns>
        [Route("Sc_ProcessMangement/MES_WW_EntrustProcessSendOutBillList_Json")]
        [HttpGet]
        public object MES_WW_EntrustProcessSendOutBillList_Json(string sqlWhere)
        {
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (sqlWhere == null || sqlWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select top 500 * from h_v_WW_EntrustProcessSendOutBillList ", "h_v_WW_EntrustProcessSendOutBillList");
                }
                else
                {
                    string sql1 = "select * from h_v_WW_EntrustProcessSendOutBillList where 1 = 1 ";
                    string sql = sql1 + sqlWhere;
                    ds = oCN.RunProcReturn(sql, "h_v_WW_EntrustProcessSendOutBillList");
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
            return GetObjectJson(ds);
        }


    }

 WebAPI/Models/Gy_RoutingBill.cs

New file
@@ -0,0 +1,33 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace WebAPI.Models
{
    public class Gy_RoutingBill
    {
        public long HInterID { get; set; }
        public string HBillNo { get; set; }
        public DateTime HDate { get; set; }
        public string HRemark { get; set; }
        public string HMaker { get; set; }
        public long HMaterID { get; set; }
        public string HName { get; set; }
        public long HRoutingGroupID { get; set; }
        public long HUnitID { get; set; }
        public string HMaterNumber { get; set; }
        public bool HStandard { get; set; }
        public long HGroupID { get; set; }
        public long HMainProcID { get; set; }
        public long HMainCenterID { get; set; }
        public string HMainTimeUnit { get; set; }
        public double HMainUnitTime { get; set; }
        public double HMainWorkQty { get; set; }
        public double HMainPrice { get; set; }
        public double HStdSourceQty { get; set; }
        public double HAddSourceRate { get; set; }
        public double HDelSourceRate { get; set; }

    }
}

 WebAPI/Models/Gy_RoutingBillSub.cs

New file
@@ -0,0 +1,19 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace WebAPI.Models
{
    public class Gy_RoutingBillSub
    {
        public long HProcID { get; set; }//工序ID
        public string HProcNo { get; set; }//流水号
        public long HSupID { get; set; }//供应商ID
        public bool HSupFlag { get; set; }//外协标记
        public double HWorkQty { get; set; }//加工数量
        public double HPassRate { get; set; }//良率
        public string HRemark { get; set; }//备注

    }
}

 WebAPI/Properties/PublishProfiles/API.pubxml.user

@@ -7,38 +7,39 @@
  <PropertyGroup>
    <TimeStampOfAssociatedLegacyPublishXmlFile />
    <_PublishTargetUrl>D:\网站发布\智云MESWMS\API</_PublishTargetUrl>
    <History>True|2021-04-16T00:50:41.5499248Z;True|2021-04-16T08:32:59.1701708+08:00;True|2021-04-16T08:27:36.9176335+08:00;True|2021-04-15T15:56:26.8485667+08:00;True|2021-04-15T15:21:23.2875671+08:00;True|2021-04-15T14:41:16.9980034+08:00;True|2021-04-15T14:36:34.8570017+08:00;True|2021-04-13T16:15:00.7668503+08:00;</History>
    <History>True|2021-04-28T02:18:54.1336497Z;True|2021-04-27T16:34:19.0789205+08:00;True|2021-04-27T14:48:28.8138232+08:00;True|2021-04-27T10:34:03.6370089+08:00;True|2021-04-26T16:18:32.0260755+08:00;True|2021-04-26T15:00:58.6773071+08:00;True|2021-04-26T13:23:50.3968646+08:00;True|2021-04-16T08:50:41.5499248+08:00;True|2021-04-16T08:32:59.1701708+08:00;True|2021-04-16T08:27:36.9176335+08:00;True|2021-04-15T15:56:26.8485667+08:00;True|2021-04-15T15:21:23.2875671+08:00;True|2021-04-15T14:41:16.9980034+08:00;True|2021-04-15T14:36:34.8570017+08:00;True|2021-04-13T16:15:00.7668503+08:00;</History>
  </PropertyGroup>
  <ItemGroup>
    <File Include="apiapp.json">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:33</publishTime>
    </File>
    <File Include="bin/Antlr3.Runtime.dll">
      <publishTime>02/22/2013 08:43:40</publishTime>
      <publishTime>04/13/2021 13:28:28</publishTime>
    </File>
    <File Include="bin/Antlr3.Runtime.pdb">
      <publishTime>02/22/2013 08:43:40</publishTime>
      <publishTime>04/13/2021 13:28:28</publishTime>
    </File>
    <File Include="bin/BLL.dll">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:33</publishTime>
    </File>
    <File Include="bin/DAL.dll">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:33</publishTime>
    </File>
    <File Include="bin/Dapper.dll">
      <publishTime>07/22/2016 14:52:40</publishTime>
      <publishTime>04/13/2021 13:30:11</publishTime>
    </File>
    <File Include="bin/DBUtility.dll">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:33</publishTime>
    </File>
    <File Include="bin/Kingdee.BOS.WebApi.Client.dll">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:33</publishTime>
    </File>
    <File Include="bin/Kingdee.BOS.WebApi.FormService.dll">
      <publishTime>09/20/2018 19:23:20</publishTime>
      <publishTime>04/26/2020 09:57:16</publishTime>
    </File>
    <File Include="bin/Kingdee.BOS.WebApi.ServicesStub.dll">
      <publishTime>09/20/2018 19:28:34</publishTime>
      <publishTime>04/26/2020 09:57:16</publishTime>
    </File>
    <File Include="bin/Microsoft.Azure.AppService.ApiApps.Service.dll">
      <publishTime>03/18/2015 17:02:50</publishTime>
@@ -50,7 +51,7 @@
      <publishTime>07/25/2012 11:48:56</publishTime>
    </File>
    <File Include="bin/Model.dll">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:33</publishTime>
    </File>
    <File Include="bin/Newtonsoft.Json.dll">
      <publishTime>08/03/2014 20:33:56</publishTime>
@@ -59,13 +60,13 @@
      <publishTime>01/04/2011 13:48:18</publishTime>
    </File>
    <File Include="bin/Pub_Class.dll">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:33</publishTime>
    </File>
    <File Include="bin/Pub_Control.dll">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:33</publishTime>
    </File>
    <File Include="bin/SQLHelper.dll">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:33</publishTime>
    </File>
    <File Include="bin/Swashbuckle.Core.dll">
      <publishTime>02/15/2015 17:57:08</publishTime>
@@ -107,7 +108,7 @@
      <publishTime>09/26/2012 03:16:08</publishTime>
    </File>
    <File Include="bin/System.Web.Cors.dll">
      <publishTime>11/28/2018 12:58:44</publishTime>
      <publishTime>04/13/2021 13:30:39</publishTime>
    </File>
    <File Include="bin/System.Web.dll">
      <publishTime>09/26/2012 03:16:08</publishTime>
@@ -131,16 +132,16 @@
      <publishTime>11/28/2018 13:01:00</publishTime>
    </File>
    <File Include="bin/System.Web.Http.WebHost.dll">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:33</publishTime>
    </File>
    <File Include="bin/System.Web.Mvc.dll">
      <publishTime>01/28/2015 04:02:18</publishTime>
      <publishTime>04/13/2021 13:31:08</publishTime>
    </File>
    <File Include="bin/System.Web.Optimization.dll">
      <publishTime>02/11/2014 15:26:04</publishTime>
      <publishTime>04/13/2021 13:31:24</publishTime>
    </File>
    <File Include="bin/System.Web.Razor.dll">
      <publishTime>01/28/2015 04:02:32</publishTime>
      <publishTime>04/13/2021 13:31:12</publishTime>
    </File>
    <File Include="bin/System.Web.Services.dll">
      <publishTime>09/26/2012 03:16:08</publishTime>
@@ -164,10 +165,10 @@
      <publishTime>11/24/2014 11:18:48</publishTime>
    </File>
    <File Include="bin/WebAPI.dll">
      <publishTime>04/29/2021 15:06:44</publishTime>
      <publishTime>04/28/2021 10:18:38</publishTime>
    </File>
    <File Include="bin/WebAPI.pdb">
      <publishTime>04/29/2021 15:06:44</publishTime>
      <publishTime>04/28/2021 10:18:38</publishTime>
    </File>
    <File Include="bin/WebAPI.XmlSerializers.dll">
      <publishTime>02/04/2021 21:35:21</publishTime>
@@ -185,163 +186,163 @@
      <publishTime>03/26/2019 14:23:20</publishTime>
    </File>
    <File Include="Content/bootstrap.css">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:33</publishTime>
    </File>
    <File Include="Content/bootstrap.min.css">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:33</publishTime>
    </File>
    <File Include="Content/Site.css">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:33</publishTime>
    </File>
    <File Include="DLL/BLL.dll">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:33</publishTime>
    </File>
    <File Include="DLL/DAL.dll">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:33</publishTime>
    </File>
    <File Include="DLL/DBUtility.dll">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:33</publishTime>
    </File>
    <File Include="DLL/Kingdee.BOS.WebApi.Client.dll">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:33</publishTime>
    </File>
    <File Include="DLL/Model.dll">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:33</publishTime>
    </File>
    <File Include="DLL/Newtonsoft.Json.Net35.dll">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:33</publishTime>
    </File>
    <File Include="DLL/Pub_Class.dll">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:33</publishTime>
    </File>
    <File Include="DLL/Pub_Control.dll">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:33</publishTime>
    </File>
    <File Include="DLL/SQLHelper.dll">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:33</publishTime>
    </File>
    <File Include="fonts/glyphicons-halflings-regular.eot">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:33</publishTime>
    </File>
    <File Include="fonts/glyphicons-halflings-regular.svg">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:33</publishTime>
    </File>
    <File Include="fonts/glyphicons-halflings-regular.ttf">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:33</publishTime>
    </File>
    <File Include="fonts/glyphicons-halflings-regular.woff">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:33</publishTime>
    </File>
    <File Include="Global.asax">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:33</publishTime>
    </File>
    <File Include="Index.html">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:33</publishTime>
    </File>
    <File Include="Metadata/deploymentTemplates/apiappconfig.azureresource.json">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:33</publishTime>
    </File>
    <File Include="packages.config">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 13:27:57</publishTime>
    </File>
    <File Include="Views/Scripts/bootstrap.js">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Views/Scripts/bootstrap.min.js">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Views/Scripts/jquery-1.10.2.js">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Views/Scripts/jquery-1.10.2.min.js">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Views/Scripts/jquery-1.10.2.min.map">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Views/Scripts/jquery.validate.js">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Views/Scripts/jquery.validate.min.js">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Views/Scripts/jquery.validate.unobtrusive.js">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Views/Scripts/jquery.validate.unobtrusive.min.js">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Views/Scripts/modernizr-2.6.2.js">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Views/Shared/Error.cshtml">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Views/Shared/_Layout.cshtml">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Views/web.config">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Views/_ViewStart.cshtml">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Web References/WebS/ClsCLD_Customer_Model.datasource">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Web References/WebS/ClsCLD_Department_Model.datasource">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Web References/WebS/ClsCLD_Employee_Model.datasource">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Web References/WebS/ClsCLD_StockPlace_Model.datasource">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Web References/WebS/ClsCLD_Supplier_Model.datasource">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Web References/WebS/ClsCLD_Warehouse_Model.datasource">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_BadReason_Model.datasource">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_BarCodeBill_WMS_Model_View.datasource">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Customer_Model.datasource">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Department_Model.datasource">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Employee_Model.datasource">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Group_Model.datasource">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Item30JiTai_Model.datasource">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Source_Model.datasource">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_StockPlace_Model.datasource">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Supplier_Model.datasource">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Warehouse_Model.datasource">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Web References/WebS/ClsKf_ICStockBill_WMS.datasource">
      <publishTime>04/12/2021 11:33:15</publishTime>
      <publishTime>04/13/2021 10:11:34</publishTime>
    </File>
    <File Include="Web.config">
      <publishTime>04/29/2021 15:06:50</publishTime>
      <publishTime>04/28/2021 10:18:49</publishTime>
    </File>
  </ItemGroup>
</Project>

 WebAPI/WebAPI.csproj

@@ -324,7 +324,16 @@
    <Compile Include="Controllers\BaseSet\Gy_ProcessController.cs" />
    <Compile Include="Controllers\BaseSet\Gy_SourceController.cs" />
    <Compile Include="Controllers\BaseSet\Gy_SupplierController.cs" />
    <Compile Include="Controllers\BaseSet\Gy_PropertyController.cs" />
    <Compile Include="Controllers\BaseSet\Gy_WarehouseController.cs" />
    <Compile Include="Controllers\BaseSet\Xt_ORGANIZATIONSController.cs" />
    <Compile Include="Controllers\BLL\Xt_AccountPeriodController.cs" />
    <Compile Include="Controllers\BLL\Xt_BillTypeController.cs" />
    <Compile Include="Controllers\BLL\Xt_UserGroupController.cs" />
    <Compile Include="Controllers\BLL\Xt_XtgnbController.cs" />
    <Compile Include="Controllers\BLL\Xt_SystemParameterController.cs" />
    <Compile Include="Controllers\BLL\Xt_UserController.cs" />
    <Compile Include="Controllers\BLL\Xt_SystemLogController.cs" />
    <Compile Include="Controllers\CGGL\Cg_POOrderBillController.cs" />
    <Compile Include="Controllers\CGGL\WW_EntrustOrderBillController.cs" />
    <Compile Include="Controllers\CGGL\Cg_POInStockBillController.cs" />
@@ -333,6 +342,7 @@
    <Compile Include="Controllers\CJGL\Cj_StationOutBillController.cs" />
    <Compile Include="Controllers\CJGL\Cj_StationInBillController.cs" />
    <Compile Include="Controllers\CJGL\Cj_StationEntrustOutBillController.cs" />
    <Compile Include="Controllers\JHGL\Gy_RoutingBillController.cs" />
    <Compile Include="Controllers\Sc_ProcessMangementController.cs" />
    <Compile Include="Controllers\CJGL\Cj_StationEntrustInBillController.cs" />
    <Compile Include="Controllers\LMESController.cs" />
@@ -352,6 +362,7 @@
    <Compile Include="Models\ApiConfig.cs" />
    <Compile Include="Models\ApiResult.cs" />
    <Compile Include="Models\DocumentsView.cs" />
    <Compile Include="Models\Gy_RoutingBillSub.cs" />
    <Compile Include="Models\LookingForBill.cs" />
    <Compile Include="Models\M_Department.cs" />
    <Compile Include="Models\M_ProcMul.cs" />
@@ -361,6 +372,7 @@
    <Compile Include="Models\Sc_ProcessReportViewModel.cs" />
    <Compile Include="Models\Sc_ProcessSendWorkViewModel.cs" />
    <Compile Include="Models\Department.cs" />
    <Compile Include="Models\Gy_RoutingBill.cs" />
    <Compile Include="Models\StationBill.cs" />
    <Compile Include="Models\StationOutBillView.cs" />
    <Compile Include="Properties\Resources.Designer.cs">