智云MESWMS-WEBAPI-弃用
parent: 2594df09 | 补丁 | 提交 | ignore whitespace
WYB
2021-03-24 ef460ff1ab295153c05a53ad0512cc982ed2c114 
Merge branch 'master' of http://101.37.171.70:10101/r/MESWMS-WEBAPI
2个文件已修改
6个文件已添加
450 ■■■■■ 已修改文件
WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs 73 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/BaseSet/Gy_CustomerController.cs 73 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs 73 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/BaseSet/Gy_MaterialController.cs 73 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/BaseSet/Gy_SupplierController.cs 73 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/BaseSet/Gy_WarehouseController.cs 73 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Properties/PublishProfiles/JFAPI.pubxml.user 6 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/WebAPI.csproj 6 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 
 WebAPI/Controllers/BaseSet/Gy_BadReasonController.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_BadReasonController : 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_BadReason/list")]


        [HttpGet]


        public object list(string sWhere)


        {


            try


            {


                if (sWhere == null || sWhere.Equals(""))


                {


                    ds = oCN.RunProcReturn("select * from h_v_IF_BadReasonList " + sWhere, "h_v_IF_BadReasonList");


                }


                else


                {


                    string sql1 = "select * from h_v_IF_BadReasonList where 1 = 1 ";


                    string sql = sql1 + sWhere;


                    ds = oCN.RunProcReturn(sql, "h_v_IF_BadReasonList");


                }


                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/BaseSet/Gy_CustomerController.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_CustomerController : 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_Customer/list")]


        [HttpGet]


        public object list(string sWhere)


        {


            try


            {


                if (sWhere == null || sWhere.Equals(""))


                {


                    ds = oCN.RunProcReturn("select * from h_v_Gy_CustomerList " + sWhere, "h_v_Gy_CustomerList");


                }


                else


                {


                    string sql1 = "select * from h_v_Gy_CustomerList where 1 = 1 ";


                    string sql = sql1 + sWhere;


                    ds = oCN.RunProcReturn(sql, "h_v_Gy_CustomerList");


                }


                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/BaseSet/Gy_EmployeeController.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_EmployeeController : 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_Employee/list")]


        [HttpGet]


        public object list(string sWhere)


        {


            try


            {


                if (sWhere == null || sWhere.Equals(""))


                {


                    ds = oCN.RunProcReturn("select * from h_v_IF_EmployeeList " + sWhere, "h_v_IF_EmployeeList");


                }


                else


                {


                    string sql1 = "select * from h_v_IF_EmployeeList where 1 = 1 ";


                    string sql = sql1 + sWhere;


                    ds = oCN.RunProcReturn(sql, "h_v_IF_EmployeeList");


                }


                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/BaseSet/Gy_MaterialController.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_MaterialController : 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_Material/list")]


        [HttpGet]


        public object list(string sWhere)


        {


            try


            {


                if (sWhere == null || sWhere.Equals(""))


                {


                    ds = oCN.RunProcReturn("select * from h_v_Gy_MaterialList " + sWhere, "h_v_Gy_MaterialList");


                }


                else


                {


                    string sql1 = "select * from h_v_Gy_MaterialList where 1 = 1 ";


                    string sql = sql1 + sWhere;


                    ds = oCN.RunProcReturn(sql, "h_v_Gy_MaterialList");


                }


                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/BaseSet/Gy_SupplierController.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_SupplierController : 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_Supplier/list")]


        [HttpGet]


        public object list(string sWhere)


        {


            try


            {


                if (sWhere == null || sWhere.Equals(""))


                {


                    ds = oCN.RunProcReturn("select * from h_v_Gy_SupplierList " + sWhere, "h_v_Gy_SupplierList");


                }


                else


                {


                    string sql1 = "select * from h_v_Gy_SupplierList where 1 = 1 ";


                    string sql = sql1 + sWhere;


                    ds = oCN.RunProcReturn(sql, "h_v_Gy_SupplierList");


                }


                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/BaseSet/Gy_WarehouseController.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_WarehouseController : 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_Warehouse/list")]


        [HttpGet]


        public object list(string sWhere)


        {


            try


            {


                if (sWhere == null || sWhere.Equals(""))


                {


                    ds = oCN.RunProcReturn("select * from h_v_IF_WareHouseList " + sWhere, "h_v_IF_WareHouseList");


                }


                else


                {


                    string sql1 = "select * from h_v_IF_WareHouseList where 1 = 1 ";


                    string sql = sql1 + sWhere;


                    ds = oCN.RunProcReturn(sql, "h_v_IF_WareHouseList");


                }


                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/Properties/PublishProfiles/JFAPI.pubxml.user


@@ -152,10 +152,10 @@


      <publishTime>11/24/2014 11:18:48</publishTime>


    </File>


    <File Include="bin/WebAPI.dll">


      <publishTime>03/23/2021 16:26:42</publishTime>


      <publishTime>03/24/2021 10:44:06</publishTime>


    </File>


    <File Include="bin/WebAPI.pdb">


      <publishTime>03/23/2021 16:26:42</publishTime>


      <publishTime>03/24/2021 10:44:06</publishTime>


    </File>


    <File Include="bin/WebAPI.XmlSerializers.dll">


      <publishTime>03/23/2021 14:35:51</publishTime>


@@ -326,7 +326,7 @@


      <publishTime>03/23/2021 14:16:31</publishTime>


    </File>


    <File Include="Web.config">


      <publishTime>03/23/2021 16:26:47</publishTime>


      <publishTime>03/24/2021 10:46:23</publishTime>


    </File>


  </ItemGroup>


</Project>




 WebAPI/WebAPI.csproj


@@ -315,6 +315,12 @@


    <Compile Include="App_Start\RouteConfig.cs" />


    <Compile Include="App_Start\SwaggerConfig.cs" />


    <Compile Include="App_Start\WebApiConfig.cs" />


    <Compile Include="Controllers\BaseSet\Gy_CustomerController.cs" />


    <Compile Include="Controllers\BaseSet\Gy_BadReasonController.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_DepartmentController.cs" />


    <Compile Include="Controllers\BaseSet\Gy_ProcessController.cs" />


    <Compile Include="Controllers\LMESController.cs" />