ch
2021-03-29 6c6386f7dbbf7cccf55a62fe727ba56502535b59
新增一个模治具控制器  控制器里列表调用API方法
3个文件已删除
9个文件已修改
1个文件已添加
1690 ■■■■■ 已修改文件
WebAPI/Controllers/BaseSet/Gy_GroupController.cs 1 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/BaseSet/Gy_SourceController.cs 1 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/CJGL/Cj_NoPassProcController.cs 75 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/LMESController.cs 136 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/LookingForBillController.cs 1 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/Sc_CheckToolsRepairWorkBillController.cs 494 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Properties/PublishProfiles/JFAPI.pubxml 17 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Properties/PublishProfiles/JFAPI.pubxml.user 332 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Properties/PublishProfiles/WEBAPI.pubxml 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Properties/PublishProfiles/WEBAPI.pubxml.user 170 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Service/BaseSetService.cs 391 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Web.config 4 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/WebAPI.csproj 66 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/BaseSet/Gy_GroupController.cs
@@ -9,6 +9,7 @@
using WebAPI.Models;
namespace WebAPI.Controllers
{
    //班组Controller
    public class Gy_GroupController : ApiController
    {
        public DBUtility.ClsPub.Enum_BillStatus BillStatus;
WebAPI/Controllers/BaseSet/Gy_SourceController.cs
@@ -9,6 +9,7 @@
using WebAPI.Models;
namespace WebAPI.Controllers
{
    //生产资源Controller
    public class Gy_SourceController : ApiController
    {
        public DBUtility.ClsPub.Enum_BillStatus BillStatus;
WebAPI/Controllers/CJGL/Cj_NoPassProcController.cs
New file
@@ -0,0 +1,75 @@
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 Cj_NoPassProcController : 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("Cj_NoPassProc/list")]
        [HttpGet]
        public object list(string sWhere)
        {
            try
            {
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_QC_NoPassProdCheckBillList " + sWhere, "h_v_QC_NoPassProdCheckBillList");
                }
                else
                {
                    string sql1 = "select * from h_v_QC_NoPassProdCheckBillList where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    ds = oCN.RunProcReturn(sql, "h_v_QC_NoPassProdCheckBillList");
                }
                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;
            }
        }
        //
    }
}
WebAPI/Controllers/LMESController.cs
@@ -245,111 +245,6 @@
        }
        /// <summary>
        /// 返回生产汇报单列表
        ///参数:string sql。
        ///返回值:object。
        /// </summary>
        [Route("LEMS/MES_Sc_ProcessReportList_Json")]
        [HttpGet]
        public object MES_Sc_ProcessReportList_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_ProcessReportMain ", "Sc_ProcessReportMain");
                }
                else
                {
                    string sql1 = "select * from Sc_ProcessReportMain where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    ds = oCN.RunProcReturn(sql, "Sc_ProcessReportMain");
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录!" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
            return GetObjectJson(ds);
        }
        /// <summary>
        /// 返回生产工序计划单列表
        ///参数:string sql。
        ///返回值:object。
        /// </summary>
        [Route("LEMS/MES_Sc_ProcessPlanMain_Json")]
        [HttpGet]
        public object MES_Sc_ProcessPlanMain_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_ProcessPlanMain ", "Sc_ProcessPlanMain");
                }
                else
                {
                    string sql1 = "select * from Sc_ProcessPlanMain where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    ds = oCN.RunProcReturn(sql, "Sc_ProcessPlanMain");
                }
            }
            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="sWhere"></param>
       /// <returns></returns>
        [Route("LEMS/MES_Sc_ProcessSendWorkMain_Json")]
        [HttpGet]
        public object MES_Sc_ProcessSendWorkMain_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_ProcessSendWorkMain ", "Sc_ProcessSendWorkMain");
                }
                else
                {
                    string sql1 = "select * from Sc_ProcessSendWorkMain where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    ds = oCN.RunProcReturn(sql, "Sc_ProcessSendWorkMain");
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录!" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
            return GetObjectJson(ds);
        }
        /// <summary>
        /// 返回工序委外接收单列表
        ///参数:string sql。
        ///返回值:object。
@@ -1206,38 +1101,7 @@
                objJsonResult.data = e.ToString();
                return objJsonResult;
            }
        }
        /// <summary>
        /// 返回工序列表
        ///参数:string sql。
        ///返回值:object。
        /// </summary>
        [Route("LEMS/getProcessList")]
        [HttpGet]
        public object getProcessList(string sWhere)
        {
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_Gy_ProcessList "+ sWhere, "h_v_Gy_ProcessList");
                }
                else
                {
                    string sql1 = "select * from h_v_Gy_ProcessList where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    ds = oCN.RunProcReturn(sql, "h_v_Gy_ProcessList");
                }
            }
            catch (Exception e)
            {
                ds = null;
            }
            return GetObjectJson(ds);
        }
        //
WebAPI/Controllers/LookingForBillController.cs
@@ -15,6 +15,7 @@
        public DataSet ds = new DataSet();
        public WebServer webserver = new WebServer();
        /// <summary>
        /// 根据包装单 返回此包装单内的相关信息
        /// </summary>
WebAPI/Controllers/Sc_CheckToolsRepairWorkBillController.cs
@@ -21,7 +21,7 @@
        /// <returns></returns>
        /// <summary>
        /// 上下架单列表
        /// 检具维修工单列表
        /// </summary>
        /// <returns></returns>
        [Route("Sc_CheckToolsRepair/GetCheckToolsRepairWorkBillList")]
@@ -62,16 +62,504 @@
        #region sql语句
      
        //上架归还单列表
        public static DataSet Sc_CheckToolsRepairWorkBillList_s(string sWhere)
        {
            return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_CheckToolsRepairWorkBillList ", "h_v_Sc_CheckToolsRepairWorkBillList");
        }
        /// <summary>
        /// 检具点检计划表列表
        /// </summary>
        /// <returns></returns>
        [Route("Sc_CheckToolsDotCheckPlan/GetCheckToolsDotCheckPlanBillList")]
        [HttpGet]
        public object GetCheckToolsDotCheckPlanBillList(string sWhere)
        {
            try
            {
                ds = Sc_CheckToolsDotCheckPlanBillList_s(sWhere);
                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 = "返回记录成功!";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
            }
            catch (Exception ex)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录!" + ex.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #region sql语句
        public static DataSet Sc_CheckToolsDotCheckPlanBillList_s(string sWhere)
        {
            return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_CheckToolsDotCheckPlanBillList ", "h_v_Sc_CheckToolsDotCheckPlanBillList");
        }
        #endregion
        /// <summary>
        /// 检具保养记录表列表
        /// </summary>
        /// <returns></returns>
        [Route("Sc_CheckToolsMaintainBill/GetCheckToolsMaintainBillList")]
        [HttpGet]
        public object GetCheckToolsMaintainBillList(string sWhere)
        {
            try
            {
                ds = Sc_CheckToolsMaintainBillList_s(sWhere);
                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 = "返回记录成功!";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
            }
            catch (Exception ex)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录!" + ex.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #region sql语句
        public static DataSet Sc_CheckToolsMaintainBillList_s(string sWhere)
        {
            return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_CheckToolsMaintainBillList ", "h_v_Sc_CheckToolsMaintainBillList");
        }
        #endregion
        /// <summary>
        /// 模具保养记录表列表
        /// </summary>
        /// <returns></returns>
        [Route("Sc_MouldMaintainBill/GetMouldMaintainBillList")]
        [HttpGet]
        public object GetMouldMaintainBillList(string sWhere)
        {
            try
            {
                ds = Sc_MouldMaintainBillList_s(sWhere);
                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 = "返回记录成功!";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
            }
            catch (Exception ex)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录!" + ex.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #region sql语句
        public static DataSet Sc_MouldMaintainBillList_s(string sWhere)
        {
            return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldMaintainBillList ", "h_v_Sc_MouldMaintainBillList");
        }
        #endregion
        /// <summary>
        /// 模具点检计划表列表
        /// </summary>
        /// <returns></returns>
        [Route("Sc_MouldDotCheckPlanBill/GetMouldDotCheckPlanBillList")]
        [HttpGet]
        public object GetMouldDotCheckPlanBillList(string sWhere)
        {
            try
            {
                ds = Sc_MouldDotCheckPlanBillList_s(sWhere);
                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 = "返回记录成功!";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
            }
            catch (Exception ex)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录!" + ex.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #region sql语句
        public static DataSet Sc_MouldDotCheckPlanBillList_s(string sWhere)
        {
            return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldDotCheckPlanBillList ", "h_v_Sc_MouldDotCheckPlanBillList");
        }
        #endregion
        /// <summary>
        /// 模具点检记录表列表
        /// </summary>
        /// <returns></returns>
        [Route("Sc_MouldDotCheckBill/GetMouldDotCheckBillList")]
        [HttpGet]
        public object GetMouldDotCheckBillList(string sWhere)
        {
            try
            {
                ds = Sc_MouldDotCheckBillList_s(sWhere);
                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 = "返回记录成功!";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
            }
            catch (Exception ex)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录!" + ex.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #region sql语句
        public static DataSet Sc_MouldDotCheckBillList_s(string sWhere)
        {
            return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldDotCheckBillList ", "h_v_Sc_MouldDotCheckBillList");
        }
        #endregion
        /// <summary>
        /// 检具保养计划表列表
        /// </summary>
        /// <returns></returns>
        [Route("Sc_CheckToolsMaintainPlanBill/GetCheckToolsMaintainPlanBillList")]
        [HttpGet]
        public object GetCheckToolsMaintainPlanBillList(string sWhere)
        {
            try
            {
                ds = Sc_CheckToolsMaintainPlanBillList_s(sWhere);
                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 = "返回记录成功!";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
            }
            catch (Exception ex)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录!" + ex.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #region sql语句
        public static DataSet Sc_CheckToolsMaintainPlanBillList_s(string sWhere)
        {
            return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_CheckToolsMaintainPlanBillList ", "h_v_Sc_CheckToolsMaintainPlanBillList");
        }
        #endregion
        /// <summary>
        /// 模具保养计划表列表
        /// </summary>
        /// <returns></returns>
        [Route("Sc_MouldMaintainPlanBill/GetMouldMaintainPlanBillList")]
        [HttpGet]
        public object GetMouldMaintainPlanBillList(string sWhere)
        {
            try
            {
                ds = Sc_MouldMaintainPlanBillList_s(sWhere);
                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 = "返回记录成功!";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
            }
            catch (Exception ex)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录!" + ex.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #region sql语句
        public static DataSet Sc_MouldMaintainPlanBillList_s(string sWhere)
        {
            return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldMaintainPlanBillList ", "h_v_Sc_MouldMaintainPlanBillList");
        }
        #endregion
        /// <summary>
        /// 模具故障登记表列表
        /// </summary>
        /// <returns></returns>
        [Route("Sc_MouldConkBookBill/GetMouldConkBookBillList")]
        [HttpGet]
        public object GetMouldConkBookBillList(string sWhere)
        {
            try
            {
                ds = Sc_MouldConkBookBillList_s(sWhere);
                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 = "返回记录成功!";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
            }
            catch (Exception ex)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录!" + ex.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #region sql语句
        public static DataSet Sc_MouldConkBookBillList_s(string sWhere)
        {
            return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldConkBookBillList ", "h_v_Sc_MouldConkBookBillList");
        }
        #endregion
        /// <summary>
        /// 模具故障登记表列表
        /// </summary>
        /// <returns></returns>
        [Route("Sc_MouldRepairCheckBill/GetMouldRepairCheckBillList")]
        [HttpGet]
        public object GetMouldRepairCheckBillList(string sWhere)
        {
            try
            {
                ds = Sc_MouldRepairCheckBillList_s(sWhere);
                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 = "返回记录成功!";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
            }
            catch (Exception ex)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录!" + ex.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #region sql语句
        public static DataSet Sc_MouldRepairCheckBillList_s(string sWhere)
        {
            return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldRepairCheckBillList ", "h_v_Sc_MouldRepairCheckBillList");
        }
        #endregion
        /// <summary>
        /// 检具维修验收单列表
        /// </summary>
        /// <returns></returns>
        [Route("Sc_CheckToolsRepairCheckBill/GetCheckToolsRepairCheckBillList")]
        [HttpGet]
        public object GetCheckToolsRepairCheckBillList(string sWhere)
        {
            try
            {
                ds = Sc_CheckToolsRepairCheckBillList_s(sWhere);
                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 = "返回记录成功!";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
            }
            catch (Exception ex)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录!" + ex.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #region sql语句
        public static DataSet Sc_CheckToolsRepairCheckBillList_s(string sWhere)
        {
            return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_CheckToolsRepairCheckBillList ", "h_v_Sc_CheckToolsRepairCheckBillList");
        }
        #endregion
        //测试专用接口
        [Route("LookingFor/Test")]
        [HttpGet]
        public object Test(string HbillNo)//h_p_Xs_SellOutFindSP
        public object Test(string HbillNo)//Sc_CheckToolsRepair/GetCheckToolsRepairWorkBillList
        {
            DataSet ds;
            ds = new SQLHelper.ClsCN().RunProcReturn("EXEC h_p_Xs_SellOutFindSP '" + HbillNo + "'", "h_p_Xs_SellOutFindSP");
WebAPI/Properties/PublishProfiles/JFAPI.pubxml
File was deleted
WebAPI/Properties/PublishProfiles/JFAPI.pubxml.user
File was deleted
WebAPI/Properties/PublishProfiles/WEBAPI.pubxml
@@ -11,7 +11,7 @@
    <SiteUrlToLaunchAfterPublish />
    <LaunchSiteAfterPublish>True</LaunchSiteAfterPublish>
    <ExcludeApp_Data>False</ExcludeApp_Data>
    <publishUrl>D:\网站发布\WebAPI_SWE</publishUrl>
    <publishUrl>D:\网站发布\智云MESWMS\API</publishUrl>
    <DeleteExistingFiles>True</DeleteExistingFiles>
  </PropertyGroup>
</Project>
WebAPI/Properties/PublishProfiles/WEBAPI.pubxml.user
@@ -6,32 +6,32 @@
<Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
  <PropertyGroup>
    <TimeStampOfAssociatedLegacyPublishXmlFile />
    <_PublishTargetUrl>D:\网站发布\WebAPI_SWE</_PublishTargetUrl>
    <_PublishTargetUrl>D:\网站发布\智云MESWMS\API</_PublishTargetUrl>
  </PropertyGroup>
  <ItemGroup>
    <File Include="apiapp.json">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="bin/Antlr3.Runtime.dll">
      <publishTime>03/24/2021 13:17:32</publishTime>
      <publishTime>02/22/2013 08:43:40</publishTime>
    </File>
    <File Include="bin/Antlr3.Runtime.pdb">
      <publishTime>02/22/2013 08:43:40</publishTime>
    </File>
    <File Include="bin/BLL.dll">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="bin/DAL.dll">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="bin/Dapper.dll">
      <publishTime>03/24/2021 13:18:36</publishTime>
      <publishTime>07/22/2016 14:52:40</publishTime>
    </File>
    <File Include="bin/DBUtility.dll">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="bin/Kingdee.BOS.WebApi.Client.dll">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="bin/Kingdee.BOS.WebApi.FormService.dll">
      <publishTime>09/20/2018 19:23:20</publishTime>
@@ -40,34 +40,34 @@
      <publishTime>09/20/2018 19:28:34</publishTime>
    </File>
    <File Include="bin/Microsoft.Azure.AppService.ApiApps.Service.dll">
      <publishTime>03/24/2021 13:15:21</publishTime>
      <publishTime>03/18/2015 17:02:50</publishTime>
    </File>
    <File Include="bin/Microsoft.CSharp.dll">
      <publishTime>09/26/2012 03:16:08</publishTime>
    </File>
    <File Include="bin/Microsoft.Web.Infrastructure.dll">
      <publishTime>07/08/2013 15:15:08</publishTime>
      <publishTime>07/25/2012 11:48:56</publishTime>
    </File>
    <File Include="bin/Model.dll">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="bin/Newtonsoft.Json.dll">
      <publishTime>01/28/2016 14:22:24</publishTime>
      <publishTime>08/03/2014 20:33:56</publishTime>
    </File>
    <File Include="bin/Newtonsoft.Json.Net35.dll">
      <publishTime>01/04/2011 13:48:18</publishTime>
    </File>
    <File Include="bin/Pub_Class.dll">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="bin/Pub_Control.dll">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="bin/SQLHelper.dll">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="bin/Swashbuckle.Core.dll">
      <publishTime>03/24/2021 13:19:15</publishTime>
      <publishTime>02/15/2015 17:57:08</publishTime>
    </File>
    <File Include="bin/System.ComponentModel.DataAnnotations.dll">
      <publishTime>09/26/2012 03:16:08</publishTime>
@@ -91,13 +91,13 @@
      <publishTime>09/26/2012 03:16:08</publishTime>
    </File>
    <File Include="bin/System.IdentityModel.Tokens.Jwt.dll">
      <publishTime>03/24/2021 13:19:56</publishTime>
      <publishTime>08/19/2014 10:03:34</publishTime>
    </File>
    <File Include="bin/System.Net.Http.dll">
      <publishTime>09/26/2012 03:16:08</publishTime>
    </File>
    <File Include="bin/System.Net.Http.Formatting.dll">
      <publishTime>03/24/2021 13:20:42</publishTime>
      <publishTime>11/28/2018 13:00:36</publishTime>
    </File>
    <File Include="bin/System.Runtime.Serialization.dll">
      <publishTime>09/26/2012 03:16:08</publishTime>
@@ -106,7 +106,7 @@
      <publishTime>09/26/2012 03:16:08</publishTime>
    </File>
    <File Include="bin/System.Web.Cors.dll">
      <publishTime>03/24/2021 13:21:12</publishTime>
      <publishTime>11/28/2018 12:58:44</publishTime>
    </File>
    <File Include="bin/System.Web.dll">
      <publishTime>09/26/2012 03:16:08</publishTime>
@@ -121,37 +121,37 @@
      <publishTime>09/26/2012 03:16:08</publishTime>
    </File>
    <File Include="bin/System.Web.Helpers.dll">
      <publishTime>03/24/2021 13:21:44</publishTime>
      <publishTime>01/28/2015 04:04:30</publishTime>
    </File>
    <File Include="bin/System.Web.Http.Cors.dll">
      <publishTime>03/24/2021 13:22:27</publishTime>
      <publishTime>11/28/2018 13:01:26</publishTime>
    </File>
    <File Include="bin/System.Web.Http.dll">
      <publishTime>03/24/2021 13:22:27</publishTime>
      <publishTime>11/28/2018 13:01:00</publishTime>
    </File>
    <File Include="bin/System.Web.Http.WebHost.dll">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="bin/System.Web.Mvc.dll">
      <publishTime>01/28/2015 04:02:18</publishTime>
    </File>
    <File Include="bin/System.Web.Optimization.dll">
      <publishTime>03/24/2021 13:24:37</publishTime>
      <publishTime>02/11/2014 15:26:04</publishTime>
    </File>
    <File Include="bin/System.Web.Razor.dll">
      <publishTime>03/24/2021 13:25:05</publishTime>
      <publishTime>01/28/2015 04:02:32</publishTime>
    </File>
    <File Include="bin/System.Web.Services.dll">
      <publishTime>09/26/2012 03:16:08</publishTime>
    </File>
    <File Include="bin/System.Web.WebPages.Deployment.dll">
      <publishTime>03/24/2021 13:25:41</publishTime>
      <publishTime>01/28/2015 04:04:30</publishTime>
    </File>
    <File Include="bin/System.Web.WebPages.dll">
      <publishTime>03/24/2021 13:25:41</publishTime>
      <publishTime>01/28/2015 04:04:30</publishTime>
    </File>
    <File Include="bin/System.Web.WebPages.Razor.dll">
      <publishTime>03/24/2021 13:25:41</publishTime>
      <publishTime>01/28/2015 04:04:30</publishTime>
    </File>
    <File Include="bin/System.Xml.dll">
      <publishTime>09/26/2012 03:16:08</publishTime>
@@ -160,19 +160,19 @@
      <publishTime>09/26/2012 03:16:08</publishTime>
    </File>
    <File Include="bin/WebActivatorEx.dll">
      <publishTime>03/24/2021 13:26:42</publishTime>
      <publishTime>11/24/2014 11:18:48</publishTime>
    </File>
    <File Include="bin/WebAPI.dll">
      <publishTime>06/12/2020 17:45:15</publishTime>
      <publishTime>03/29/2021 14:17:50</publishTime>
    </File>
    <File Include="bin/WebAPI.pdb">
      <publishTime>03/24/2021 15:45:15</publishTime>
      <publishTime>03/29/2021 14:17:50</publishTime>
    </File>
    <File Include="bin/WebAPI.XmlSerializers.dll">
      <publishTime>02/04/2021 21:35:21</publishTime>
    </File>
    <File Include="bin/WebGrease.dll">
      <publishTime>03/24/2021 13:26:58</publishTime>
      <publishTime>07/17/2013 17:03:52</publishTime>
    </File>
    <File Include="bin/zh-Hans/System.Net.Http.Formatting.resources.dll">
      <publishTime>11/29/2018 13:26:02</publishTime>
@@ -184,163 +184,163 @@
      <publishTime>03/26/2019 14:23:20</publishTime>
    </File>
    <File Include="Content/bootstrap.css">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Content/bootstrap.min.css">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Content/Site.css">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="DLL/BLL.dll">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="DLL/DAL.dll">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="DLL/DBUtility.dll">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="DLL/Kingdee.BOS.WebApi.Client.dll">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="DLL/Model.dll">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="DLL/Newtonsoft.Json.Net35.dll">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="DLL/Pub_Class.dll">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="DLL/Pub_Control.dll">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="DLL/SQLHelper.dll">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="fonts/glyphicons-halflings-regular.eot">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="fonts/glyphicons-halflings-regular.svg">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="fonts/glyphicons-halflings-regular.ttf">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="fonts/glyphicons-halflings-regular.woff">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Global.asax">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Index.html">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Metadata/deploymentTemplates/apiappconfig.azureresource.json">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="packages.config">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Views/Scripts/bootstrap.js">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Views/Scripts/bootstrap.min.js">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Views/Scripts/jquery-1.10.2.js">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Views/Scripts/jquery-1.10.2.min.js">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Views/Scripts/jquery-1.10.2.min.map">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Views/Scripts/jquery.validate.js">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Views/Scripts/jquery.validate.min.js">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Views/Scripts/jquery.validate.unobtrusive.js">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Views/Scripts/jquery.validate.unobtrusive.min.js">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Views/Scripts/modernizr-2.6.2.js">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Views/Shared/Error.cshtml">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Views/Shared/_Layout.cshtml">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Views/web.config">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Views/_ViewStart.cshtml">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Web References/WebS/ClsCLD_Customer_Model.datasource">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Web References/WebS/ClsCLD_Department_Model.datasource">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Web References/WebS/ClsCLD_Employee_Model.datasource">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Web References/WebS/ClsCLD_StockPlace_Model.datasource">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Web References/WebS/ClsCLD_Supplier_Model.datasource">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Web References/WebS/ClsCLD_Warehouse_Model.datasource">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_BadReason_Model.datasource">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_BarCodeBill_WMS_Model_View.datasource">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Customer_Model.datasource">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Department_Model.datasource">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Employee_Model.datasource">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Group_Model.datasource">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Item30JiTai_Model.datasource">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Source_Model.datasource">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_StockPlace_Model.datasource">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Supplier_Model.datasource">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Warehouse_Model.datasource">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Web References/WebS/ClsKf_ICStockBill_WMS.datasource">
      <publishTime>03/24/2021 16:19:16</publishTime>
      <publishTime>03/26/2021 14:46:18</publishTime>
    </File>
    <File Include="Web.config">
      <publishTime>03/24/2021 16:33:09</publishTime>
      <publishTime>03/29/2021 14:24:45</publishTime>
    </File>
  </ItemGroup>
</Project>
WebAPI/Service/BaseSetService.cs
File was deleted
WebAPI/Web.config
@@ -11,8 +11,8 @@
      
  </configSections>
    <connectionStrings>
        <!--<add name="YqnConn" connectionString="Data Source=.;Initial Catalog=HX_LimsSys_Simoer;User Id=HX_USER,Password=lc@841022;Integrated Security=True" />-->
        <add name="YqnConn" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=HX_LMESsys;User Id=HX_USER,Password=lc@841022;Integrated Security=True" />
        <!--<add name="YqnConn" connectionString="Data Source=192.168.0.175;Initial Catalog=HX_LimsSys;User Id=HX_USER,Password=lc@841022;Integrated Security=True" />-->
    <add name="YqnConn" connectionString="Data Source=.;Initial Catalog=HX_LimsSys;Integrated Security=True" />
    </connectionStrings>
    
  <appSettings>
WebAPI/WebAPI.csproj
@@ -44,8 +44,8 @@
  </PropertyGroup>
  <ItemGroup>
    <Reference Include="Antlr3.Runtime, Version=3.4.1.9004, Culture=neutral, PublicKeyToken=eb42632606e9261f, processorArchitecture=MSIL">
      <SpecificVersion>False</SpecificVersion>
      <HintPath>bin\Antlr3.Runtime.dll</HintPath>
      <HintPath>..\packages\Antlr.3.4.1.9004\lib\Antlr3.Runtime.dll</HintPath>
      <Private>True</Private>
    </Reference>
    <Reference Include="BLL, Version=1.0.0.0, Culture=neutral, processorArchitecture=x86">
      <SpecificVersion>False</SpecificVersion>
@@ -56,8 +56,7 @@
      <HintPath>DLL\DAL.dll</HintPath>
    </Reference>
    <Reference Include="Dapper, Version=1.50.2.0, Culture=neutral, processorArchitecture=MSIL">
      <SpecificVersion>False</SpecificVersion>
      <HintPath>bin\Dapper.dll</HintPath>
      <HintPath>..\packages\Dapper.1.50.2\lib\net45\Dapper.dll</HintPath>
    </Reference>
    <Reference Include="DBUtility, Version=1.0.0.0, Culture=neutral, processorArchitecture=x86">
      <SpecificVersion>False</SpecificVersion>
@@ -73,8 +72,8 @@
      <HintPath>..\..\..\..\LMES\LMES\LMES\OCX\Kingdee.BOS.WebApi.ServicesStub.dll</HintPath>
    </Reference>
    <Reference Include="Microsoft.Azure.AppService.ApiApps.Service, Version=0.9.16.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL">
      <SpecificVersion>False</SpecificVersion>
      <HintPath>bin\Microsoft.Azure.AppService.ApiApps.Service.dll</HintPath>
      <HintPath>..\packages\Microsoft.Azure.AppService.ApiApps.Service.0.9.16\lib\net45\Microsoft.Azure.AppService.ApiApps.Service.dll</HintPath>
      <Private>True</Private>
    </Reference>
    <Reference Include="Microsoft.CSharp">
      <Private>True</Private>
@@ -103,30 +102,28 @@
      <HintPath>DLL\SQLHelper.dll</HintPath>
    </Reference>
    <Reference Include="Swashbuckle.Core, Version=1.0.0.0, Culture=neutral, PublicKeyToken=cd1bb07a5ac7c7bc, processorArchitecture=MSIL">
      <SpecificVersion>False</SpecificVersion>
      <HintPath>bin\Swashbuckle.Core.dll</HintPath>
      <HintPath>..\packages\Swashbuckle.Core.5.0.0\lib\net40\Swashbuckle.Core.dll</HintPath>
      <Private>True</Private>
    </Reference>
    <Reference Include="System.Data.DataSetExtensions">
      <Private>True</Private>
    </Reference>
    <Reference Include="System.IdentityModel.Tokens.Jwt, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL">
      <SpecificVersion>False</SpecificVersion>
      <HintPath>bin\System.IdentityModel.Tokens.Jwt.dll</HintPath>
      <HintPath>..\packages\System.IdentityModel.Tokens.Jwt.4.0.0\lib\net45\System.IdentityModel.Tokens.Jwt.dll</HintPath>
      <Private>True</Private>
    </Reference>
    <Reference Include="System.Net.Http">
      <Private>True</Private>
    </Reference>
    <Reference Include="System.Net.Http.Formatting, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL">
      <SpecificVersion>False</SpecificVersion>
      <HintPath>bin\System.Net.Http.Formatting.dll</HintPath>
    <Reference Include="System.Net.Http.Formatting, Version=5.2.7.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL">
      <HintPath>..\packages\Microsoft.AspNet.WebApi.Client.5.2.7\lib\net45\System.Net.Http.Formatting.dll</HintPath>
    </Reference>
    <Reference Include="System.Runtime.Serialization">
      <Private>True</Private>
    </Reference>
    <Reference Include="System.ServiceModel" />
    <Reference Include="System.Web.Cors, Version=5.2.7.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL">
      <SpecificVersion>False</SpecificVersion>
      <HintPath>bin\System.Web.Cors.dll</HintPath>
      <HintPath>..\packages\Microsoft.AspNet.Cors.5.2.7\lib\net45\System.Web.Cors.dll</HintPath>
    </Reference>
    <Reference Include="System.Web.DynamicData">
      <Private>True</Private>
@@ -155,25 +152,27 @@
    <Reference Include="System.Web.Extensions">
      <Private>True</Private>
    </Reference>
    <Reference Include="System.Web.Helpers, Version=2.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL">
      <SpecificVersion>False</SpecificVersion>
      <HintPath>bin\System.Web.Helpers.dll</HintPath>
    <Reference Include="System.Web.Helpers, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL">
      <HintPath>..\packages\Microsoft.AspNet.WebPages.3.2.3\lib\net45\System.Web.Helpers.dll</HintPath>
      <Private>True</Private>
    </Reference>
    <Reference Include="System.Web.Http, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL">
      <SpecificVersion>False</SpecificVersion>
      <HintPath>bin\System.Web.Http.dll</HintPath>
    <Reference Include="System.Web.Http, Version=5.2.7.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL">
      <HintPath>..\packages\Microsoft.AspNet.WebApi.Core.5.2.7\lib\net45\System.Web.Http.dll</HintPath>
    </Reference>
    <Reference Include="System.Web.Http.Cors, Version=5.2.7.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL">
      <SpecificVersion>False</SpecificVersion>
      <HintPath>bin\System.Web.Http.Cors.dll</HintPath>
      <HintPath>..\packages\Microsoft.AspNet.WebApi.Cors.5.2.7\lib\net45\System.Web.Http.Cors.dll</HintPath>
    </Reference>
    <Reference Include="System.Web.Http.WebHost, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL">
      <SpecificVersion>False</SpecificVersion>
      <HintPath>DLL\System.Web.Http.WebHost.dll</HintPath>
    </Reference>
    <Reference Include="System.Web.Mvc, Version=5.2.3.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL">
      <HintPath>..\packages\Microsoft.AspNet.Mvc.5.2.3\lib\net45\System.Web.Mvc.dll</HintPath>
      <Private>True</Private>
    </Reference>
    <Reference Include="System.Web.Optimization, Version=1.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL">
      <SpecificVersion>False</SpecificVersion>
      <HintPath>bin\System.Web.Optimization.dll</HintPath>
      <HintPath>..\packages\Microsoft.AspNet.Web.Optimization.1.1.3\lib\net40\System.Web.Optimization.dll</HintPath>
      <Private>True</Private>
    </Reference>
    <Reference Include="System.Web.Razor, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL">
      <HintPath>..\packages\Microsoft.AspNet.Razor.3.2.3\lib\net45\System.Web.Razor.dll</HintPath>
@@ -233,7 +232,6 @@
    <Content Include="Index.html" />
    <Content Include="Views\Scripts\bootstrap.js" />
    <Content Include="Views\Scripts\bootstrap.min.js" />
    <None Include="Properties\PublishProfiles\JFAPI.pubxml" />
    <None Include="Properties\Settings.settings">
      <Generator>SettingsSingleFileGenerator</Generator>
      <LastGenOutput>Settings.Designer.cs</LastGenOutput>
@@ -316,16 +314,17 @@
    <Compile Include="App_Start\RouteConfig.cs" />
    <Compile Include="App_Start\SwaggerConfig.cs" />
    <Compile Include="App_Start\WebApiConfig.cs" />
    <Compile Include="Controllers\BaseSet\Gy_SourceController.cs" />
    <Compile Include="Controllers\BaseSet\Gy_CustomerController.cs" />
    <Compile Include="Controllers\BaseSet\Gy_BadReasonController.cs" />
    <Compile Include="Controllers\BaseSet\Gy_GroupController.cs" />
    <Compile Include="Controllers\BaseSet\Gy_SupplierController.cs" />
    <Compile Include="Controllers\BaseSet\Gy_MaterialController.cs" />
    <Compile Include="Controllers\BaseSet\Gy_WarehouseController.cs" />
    <Compile Include="Controllers\BaseSet\Gy_EmployeeController.cs" />
    <Compile Include="Controllers\BaseSet\Gy_CustomerController.cs" />
    <Compile Include="Controllers\BaseSet\Gy_DepartmentController.cs" />
    <Compile Include="Controllers\BaseSet\Gy_EmployeeController.cs" />
    <Compile Include="Controllers\BaseSet\Gy_GroupController.cs" />
    <Compile Include="Controllers\BaseSet\Gy_MaterialController.cs" />
    <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_WarehouseController.cs" />
    <Compile Include="Controllers\CJGL\Cj_NoPassProcController.cs" />
    <Compile Include="Controllers\LMESController.cs" />
    <Compile Include="Controllers\LookingForBillController.cs" />
    <Compile Include="Controllers\NewApiController.cs" />
@@ -354,7 +353,6 @@
    </Compile>
    <Compile Include="Service\ProcessDal.cs" />
    <Compile Include="Service\YqnDal.cs" />
    <Compile Include="Service\BaseSetService.cs" />
    <Compile Include="Service\YqnQbService.cs" />
    <Compile Include="Web References\WebS\Reference.cs">
      <AutoGen>True</AutoGen>