WebAPI/Controllers/BaseSet/Gy_GroupController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Controllers/BaseSet/Gy_SourceController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Properties/PublishProfiles/JFAPI.pubxml.user | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/WebAPI.csproj | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
WebAPI/Controllers/BaseSet/Gy_GroupController.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_GroupController : 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_Group/list")] [HttpGet] public object list(string sWhere) { try { if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_IF_GroupList " + sWhere, "h_v_IF_GroupList"); } else { string sql1 = "select * from h_v_IF_GroupList where 1 = 1 "; string sql = sql1 + sWhere; ds = oCN.RunProcReturn(sql, "h_v_IF_GroupList"); } 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_SourceController.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_SourceController : 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_Source/list")] [HttpGet] public object list(string sWhere) { try { if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_IF_SourceList " + sWhere, "h_v_IF_SourceList"); } else { string sql1 = "select * from h_v_IF_SourceList where 1 = 1 "; string sql = sql1 + sWhere; ds = oCN.RunProcReturn(sql, "h_v_IF_SourceList"); } 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/24/2021 10:44:06</publishTime> <publishTime>03/24/2021 16:31:44</publishTime> </File> <File Include="bin/WebAPI.pdb"> <publishTime>03/24/2021 10:44:06</publishTime> <publishTime>03/24/2021 16:31:44</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/24/2021 10:46:23</publishTime> <publishTime>03/24/2021 16:31:55</publishTime> </File> </ItemGroup> </Project> WebAPI/WebAPI.csproj
@@ -316,8 +316,10 @@ <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" />