MES-WEB-API.git

New file
			@@ -0,0 +1,64 @@
			using System;
			using System.Collections.Generic;
			using System.Data;
			using System.Linq;
			using System.Web;
			using System.Web.Http;
			using WebAPI.Models;

			namespace WebAPI.Controllers.SBGL
			{
			public class Sb_EquipRepairSendWorkBillController : ApiController
			{
			public DBUtility.ClsPub.Enum_BillStatus BillStatus;

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

			#region 设备维修派工单查询列表
			[Route("Sb_EquipRepairSendWorkBill/GetEquipRepairSendWorkBillList")]
			[HttpGet]
			public object GetEquipRepairSendWorkBillList(string sWhere)
			{
			try
			{
			string sql = "select * from h_v_Sb_EquipRepairSendWorkBillList ";
			if (sWhere == "" \|\| sWhere == null)
			{
			ds = oCN.RunProcReturn(sql, "h_v_Sb_EquipRepairSendWorkBillList");
			}
			else
			{
			ds = oCN.RunProcReturn(sql + sWhere, "h_v_Sb_EquipRepairSendWorkBillList");
			}

			if (ds.Tables[0].Rows.Count == 0\|\|ds==null)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message ="无记录";
			objJsonResult.data = null;
			return objJsonResult;
			}
			objJsonResult.code = "1";
			objJsonResult.count = ds.Tables[0].Rows.Count;
			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;
			}
			}
			#endregion

			#region 设备维修派工单添加/修改
			#endregion
			}
			}

			@@ -14,6 +14,7 @@
			public class Sc_MouldRepairSendWorkBillController : ApiController
			{
			public DBUtility.ClsPub.Enum_BillStatus BillStatus;

			ClsSb_MouldRepairWorkBillMain omodel = new ClsSb_MouldRepairWorkBillMain();
			List<ClsSb_MouldRepairWorkBillSub> DetailColl = new List<ClsSb_MouldRepairWorkBillSub>();
			private json objJsonResult = new json();
			@@ -135,7 +136,7 @@
			",HYear='" + omodel.HYear.ToString() + "'" +
			",HPeriod='" + omodel.HPeriod.ToString() + "'" +
			",HRemark='" + omodel.HRemark + "'" +
			",HUpDater='" + DBUtility.ClsPub.CurUserName + "'" +
			",HUpDater='" + omodel.HUpDater + "'" +
			",HUpDateDate=getdate()" +
			//========================================
			",HMouldID=" + omodel.HMouldID.ToString() +

			@@ -367,6 +367,7 @@
			<Compile Include="Controllers\MoveStockBillController.cs" />
			<Compile Include="Controllers\Open_PrintTemController.cs" />
			<Compile Include="Controllers\ReportStepPlatFormController.cs" />
			<Compile Include="Controllers\SBGL\Sb_EquipRepairSendWorkBillController.cs" />
			<Compile Include="Controllers\SCGL\Sc_ProductionReturnBillController.cs" />
			<Compile Include="Controllers\SCGL\Sc_PackUnionBillController.cs" />
			<Compile Include="Controllers\Sc_MouldRepairSendWorkBillController.cs" />
			@@ -759,6 +760,7 @@
			<Folder Include="Views\MoveStockBill\" />
			<Folder Include="Views\ProductionReturnBill\" />
			<Folder Include="Views\QC_Management\" />
			<Folder Include="Views\Sb_EquipRepairSendWorkBill\" />
			<Folder Include="Views\Sc_MouldRepairOutBill\" />
			<Folder Include="Views\Sc_MouldRepairSendWorkBill\" />
			</ItemGroup>

	WebAPI/Controllers/SBGL/Sb_EquipRepairSendWorkBillController.cs	64 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	WebAPI/Controllers/Sc_MouldRepairSendWorkBillController.cs	3 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	WebAPI/WebAPI.csproj	2 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史