~yxj/MES-WEB-API.git

			@@ -1,4 +1,5 @@
			using Newtonsoft.Json.Linq;
			using Pub_Class;
			using System;
			using System.Collections.Generic;
			using System.Data;
			@@ -6,24 +7,88 @@
			using WebAPI.Models;
			namespace WebAPI.Controllers
			{
			/**
			* 找货单单
			*/
			public class Sc_MouldOtherOutBillController : ApiController
			{
			public DBUtility.ClsPub.Enum_BillStatus BillStatus;//单据状态（新增，修改，浏览，更新单价，变更）

			private json objJsonResult = new json();
			public DataSet ds = new DataSet();
			public WebServer webserver = new WebServer();

			#region 模治具其他出库单
			public DAL.ClsSc_MouldScrapInBill BillNew0 = new DAL.ClsSc_MouldScrapInBill(); //模具报废入库对应单据类
			public DAL.ClsSc_MouldScrapInBill BillOld0 = new DAL.ClsSc_MouldScrapInBill(); //模具报废入库对应单据类


			/// <summary>
			/// 模治具其他出库单列表 list列表数据加载
			/// 根据包装单返回此包装单内的相关信息
			/// </summary>
			/// <returns></returns>
			[Route("Sc_MouldOtherOutBill/GetMouldOtherOutBillList")]

			/// <summary>
			/// 检具维修工单列表
			/// </summary>
			/// <returns></returns>
			[Route("Sc_CheckToolsRepair/GetCheckToolsRepairWorkBillList")]
			[HttpGet]
			public object GetMouldOtherOutBillList(string sWhere)
			public object GetCheckToolsRepairWorkBillList(string sWhere)
			{
			try
			{
			ds = Sc_MouldOtherOutBillList_s(sWhere);

			ds = Sc_CheckToolsRepairWorkBillList_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_CheckToolsRepairWorkBillList_s(string sWhere)
			{
			return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_CheckToolsRepairWorkBillList ", "h_v_Sc_CheckToolsRepairWorkBillList");
			}




			#region 其他出库单

			#region 其他出库单列表

			[Route("Sc_MouldOtherOutBill/GetMouldOtherOutBill")]
			[HttpGet]
			public object GetMouldOtherOutBill(string sWhere)
			{
			try
			{

			ds = Sc_MouldOtherOutBill(sWhere);
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "返回记录成功！";
			@@ -40,24 +105,98 @@
			}
			}

			#region sql语句


			public static DataSet Sc_MouldOtherOutBillList_s(string sWhere)
			public static DataSet Sc_MouldOtherOutBill(string sWhere)
			{
			return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldOtherOutBillList ", "h_v_Sc_MouldOtherOutBillList");
			if (sWhere == null \|\| sWhere.Equals(""))
			{
			return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldOtherOutBillList ", "h_v_Sc_MouldOtherOutBillList");
			}
			else
			{
			string sql1 = "select * from h_v_Sc_MouldOtherOutBillList where 1 = 1 ";
			string sql = sql1 + sWhere;
			return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldOtherOutBillList");
			}

			}

			#endregion

			#region[其他出库单编辑时获取表头数据]
			[Route("Sc_MouldOtherOutBill/Sc_MouldOtherOutBillListCheckDetai")]
			[HttpGet]
			public ApiResult<DataSet> Sc_MouldOtherOutBillListCheckDetai(string HID)
			{
			if (string.IsNullOrEmpty(HID))
			return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();

			var dataSet = oCN.RunProcReturn("select top 1 * from where hmainid= " + HID + " ", "h_v_Sc_MouldOtherOutBillList");
			if (dataSet == null \|\| dataSet.Tables[0].Rows.Count == 0)
			return new ApiResult<DataSet> { code = -1, msg = "不存在退库单号" };

			return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
			}
			#endregion

			#region 模治具其他出库单保存/编辑
			#region[其他出库单编辑时获取表体数据]
			[Route("Sc_MouldOtherOutBill/Sc_MouldOtherOutBillListProjectDetai")]
			[HttpGet]
			public object Sc_MouldOtherOutBillListProjectDetai(string sqlWhere)
			{
			DataSet ds;
			try
			{
			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
			if (sqlWhere == null \|\| sqlWhere.Equals(""))
			{
			ds = oCN.RunProcReturn(string.Format(@"SELECT HMaterID,模具代码 HMaterCode,模具名称 HMaterName,规格型号 HMaterSpec,批次 HBatchNo,
			设计寿命 HDesignLife, 剩余寿命 HLeaveLife, 累积使用寿命 HUseLife, 应发数量 HQtyMust, 实发数量 HQty,
			单价 HPrice, 金额 HMoney,HWHSonID HWHID, 发料仓库代码 HWHCode, 发料仓库 HWHName,HSPID,
			仓位代码 HSPCode, 仓位 HSPName,表体备注 HRemark FROM h_v_Sc_MouldOtherOutBillList"), "h_v_Sc_MouldOtherOutBillList");

			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "获取信息成功！";
			objJsonResult.data = ds.Tables[0];
			}
			else
			{

			//string sql1 = "select HRepairCheckID,HRepairCheckContent,HManagerID,HRemark from Sc_MouldRepairCheckBillSub where 1 = 1 ";
			string sql1 = string.Format(@"SELECT HMaterID,模具代码 HMaterCode,模具名称 HMaterName,规格型号 HMaterSpec,批次 HBatchNo,
			设计寿命 HDesignLife, 剩余寿命 HLeaveLife, 累积使用寿命 HUseLife, 应发数量 HQtyMust, 实发数量 HQty,
			单价 HPrice, 金额 HMoney,HWHSonID HWHID, 发料仓库代码 HWHCode, 发料仓库 HWHName,HSPID,
			仓位代码 HSPCode, 仓位 HSPName,表体备注 HRemark FROM h_v_Sc_MouldOtherOutBillList where 1 = 1 ");
			string sql = sql1 + sqlWhere;
			ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldOtherOutBillList");

			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "获取信息成功！";
			objJsonResult.data = ds.Tables[0];
			}
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "没有返回任何记录！" + e.ToString();
			objJsonResult.data = null;
			}
			return objJsonResult;
			}
			#endregion

			#region 其他出库单保存/编辑
			/// <summary>
			/// 保存模具维修单
			/// 保存模具领用单
			/// </summary>
			/// <param name="msg"></param>
			/// <returns></returns>
			[Route("Sc_MouldOtherOutBill/SaveMouldOtherOutBillList")]
			[Route("Sc_MouldOtherOutBill/SaveGetMouldOtherOutBillList")]
			[HttpPost]
			public object SaveMouldOtherOutBillList([FromBody] JObject msg)
			public object SaveGetMouldOtherOutBillList([FromBody] JObject msg)
			{
			var _value = msg["msg"].ToString();
			string msg1 = _value.ToString();
			@@ -70,32 +209,33 @@
			ListModels oListModels = new ListModels();
			try
			{
			DAL.ClsSc_MouldOtherOutBill oBill = new DAL.ClsSc_MouldOtherOutBill();
			List<Model.ClsSc_MouldStockBillMain> lsmain = new List<Model.ClsSc_MouldStockBillMain>();
			DLL.ClsSc_MouldOtherOutBill oBill = new DLL.ClsSc_MouldOtherOutBill();
			List<Model.ClsSc_MouldOtherOutBillMain> lsmain = new List<Model.ClsSc_MouldOtherOutBillMain>();
			msg2 = msg2.Replace("\\", "");
			msg2 = msg2.Replace("\n", ""); //\n
			lsmain = oListModels.getObjectByJson_Sc_MouldStockBillMain(msg2);
			foreach (Model.ClsSc_MouldStockBillMain oItem in lsmain)
			lsmain = oListModels.getObjectByJson_Sc_MouldOtherOutBillMain(msg2);
			foreach (Model.ClsSc_MouldOtherOutBillMain oItem in lsmain)
			{
			//oItem.HMaker = "";
			UserName = oItem.HMaker; //制单人
			oItem.HBillType = "3828";
			oItem.HBillSubType = "3828";

			//oItem.HInterID =0;
			//oItem.HBillNo = "";
			oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));// --日期
			oItem.HBillType = "3841";
			oItem.HBillSubType = "3841";
			//oItem.HBillNo = ""; //单据号
			//oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));// --日期
			//oItem.HInnerBillNo = ""; // --内部单据号
			oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
			//oItem.HMakeDate = "";
			//oItem.HYear = "";
			//oItem.HPeriod = "";
			//oItem.HRemark = "";
			//oItem.HCycleUnit = "";
			//oItem.HCheckCycle = "";
			//oItem.HBeginDate = "";
			//oItem.HEndDate = "";
			//oItem.HInnerBillNo = "";
			//oItem.HExplanation = "";
			oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd"));
			//oItem.HEquipID = 0; //设备ID(Gy_EquipMent)
			//oItem.HPeriod = 0;
			//oItem.HCheckBeginDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd")); // --维修日期
			//oItem.HCheckResult = ""; //验收结论--(正常，异常)
			//oItem.HEmpID = 0; //验收人(Gy_Employee)
			//oItem.HManagerID = 0; //负责人(Gy_Employee)
			//oItem.HDeptID = 0; //验收部门(Gy_Department)
			//oItem.HExplanation = ""; //摘要(故障描述)
			//oItem.HRemark = ""; //备注

			//oItem.HMainSourceInterID = oItem.HInterID;

			//oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo);
			if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "")
			@@ -115,13 +255,17 @@
			msg3 = msg3.Replace("\n", ""); //\n
			//msg2 = msg2.Replace("'", "’");
			List<Model.ClsSc_MouldStockBillSub> ls = new List<Model.ClsSc_MouldStockBillSub>();
			ls = oListModels.getObjectByJson_Sc_MouldStockBillSub(msg3);
			ls = oListModels.getObjectByJson_Gy_MouldStockBillSub(msg3);
			int i = 0;
			foreach (Model.ClsSc_MouldStockBillSub oItemSub in ls)
			{

			i++;
			oItemSub.HEntryID = i;

			//oItemSub.HRepairCheckID = 0; //验收项目ID
			//oItemSub.HRepairCheckContent = ""; //验收内容
			//oItemSub.HManagerID = 0; //负责人ID
			//oItemSub.HCloseMan = ""; //行关闭
			oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);
			oItemSub.HCloseType = false; //关闭类型
			@@ -130,14 +274,11 @@
			oItemSub.HSourceEntryID = 0; //源单子内码
			//oItemSub.HSourceBillNo = ""; //源单单号
			//oItemSub.HSourceBillType = ""; //源单类型
			oItemSub.HRelationQty = 0; //关联数量
			//oItemSub.HRelationMoney = 0; //关联金额
			//HMaterID = "";//配件代码
			//HUnitID = "";//单位代码
			//HQty = "";//实际用量
			//HQtyMust = "";//单位用量
			//HRemark = "";//备注

			//oItemSub.HRelationQty = 0; //关联数量
			//oItemSub.HRelationMoney = 0; //关联金额
			//oItemSub.HRepairID = 0; //维修项目
			//oItemSub.HRepairExplanation =""; //维修要求
			//oItemSub.HMoney = 0; //维修费用
			oBill.DetailColl.Add(oItemSub);

			}
			@@ -181,17 +322,18 @@
			}
			}
			#endregion
			#region [模治具其他出库单删除功能]

			#region [器具分布式调入单删除功能]
			/// <summary>
			/// 模具维修单删除功能
			/// 模具处理领用单删除功能
			/// </summary>
			/// <returns></returns>
			[Route("Sc_MouldOtherOutBill/DeltetMouldOtherOutBillList")]
			[Route("Sc_MouldOtherOutBill/DeltetMouldOtherOutBill")]
			[HttpGet]
			public object DeltetMouldOtherOutBillList(string HInterID)
			public object DeltetMouldOtherOutBill(string HInterID)
			{
			//编辑权限
			//if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBill_Delete", 1, true, DBUtility.ClsPub.CurUserName))
			//if (!DBUtility.ClsPub.Security_Log("Sc_MouldProdBackBill_Delete", 1, true, DBUtility.ClsPub.CurUserName))
			//{
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			@@ -211,7 +353,7 @@
			objJsonResult.data = null;
			return objJsonResult;
			}
			DAL.ClsSc_MouldOtherOutBill oBill = new DAL.ClsSc_MouldOtherOutBill();
			DLL.ClsSc_MouldOtherOutBill oBill = new DLL.ClsSc_MouldOtherOutBill();
			if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
			{
			if (oBill.omodel.HBillStatus > 1)
			@@ -242,6 +384,7 @@
			}
			else
			{

			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;
			@@ -260,66 +403,9 @@
			}
			#endregion

			#region[模治具其他出库单编辑时获取表头数据]
			[Route("Sc_MouldOtherOutBill/Sc_MouldOtherOutBillListCheckDetai")]
			[HttpGet]
			public ApiResult<DataSet> Sc_MouldOtherOutBillListCheckDetai(string HID)
			{
			if (string.IsNullOrEmpty(HID))
			return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
			var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_MouldOtherOutBillList where hmainid= " + HID + " ", "h_v_Sc_MouldOtherOutBillList");
			if (dataSet == null \|\| dataSet.Tables[0].Rows.Count == 0)
			return new ApiResult<DataSet> { code = -1, msg = "不存在设备保养记录表" };
			return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
			}
			#endregion
			#region[模治具其他出库单编辑时获取表题数据]
			[Route("Sc_MouldOtherOutBill/Sc_MouldOtherOutBillListProjectDetai")]
			[HttpGet]
			public object Sc_MouldOtherOutBillListProjectDetai(string sqlWhere)
			{
			DataSet ds;
			try
			{
			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
			if (sqlWhere == null \|\| sqlWhere.Equals(""))
			{
			ds = oCN.RunProcReturn(@"select 模具代码 HMaterID,模具名称 HMaterName,规格型号 HMaterSpec ,批次 HBatchNo,设计寿命 HDesignLife,剩余寿命 HLeaveLife,累积使用寿命 HUseLife,实发数量 HQty,单价 HPrice,金额 HMoney,模具仓库代码 HWHID,发货仓库 HWHName,表体备注 HRemark
			from h_v_Sc_MouldOtherOutBillList", "h_v_Sc_MouldOtherOutBillList_Edit");
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "获取信息成功！";
			objJsonResult.data = ds.Tables[0];
			}
			else
			{
			string sql1 = @"select 模具代码 HMaterID,模具名称 HMaterName,规格型号 HMaterSpec ,批次 HBatchNo,设计寿命 HDesignLife,剩余寿命 HLeaveLife,累积使用寿命 HUseLife,实发数量 HQty,单价 HPrice,金额 HMoney,模具仓库代码 HWHID,发货仓库 HWHName,表体备注 HRemark
			from h_v_Sc_MouldOtherOutBillList where 1 = 1 ";
			string sql = sql1 + sqlWhere;
			ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldOtherOutBillList");
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "获取信息成功！";
			objJsonResult.data = ds.Tables[0];
			}
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "没有返回任何计划！" + e.ToString();
			objJsonResult.data = null;
			}
			return objJsonResult;
			}
			#endregion





			#endregion

			}
			}
			}
			#endregion
			#endregion