MES-WEB-API.git

			@@ -1,10 +1,10 @@
			using Newtonsoft.Json.Linq;
			using Pub_Class;
			using System;
			using System.Collections.Generic;
			using System.Data;
			using System.Web.Http;
			using WebAPI.Models;
			using Pub_Class;
			namespace WebAPI.Controllers
			{
			/**
			@@ -12,27 +12,93 @@
			*/
			public class Sc_MouldOtherInBillController : ApiController
			{
			public DBUtility.ClsPub.Enum_BillStatus BillStatus;//单据状态（新增，修改，浏览，更新单价，变更）

			private json objJsonResult = new json();
			DataSet ds;
			public DataSet ds = new DataSet();
			public WebServer webserver = new WebServer();
			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
			public SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
			public DAL.ClsSc_MouldScrapInBill BillNew0 = new DAL.ClsSc_MouldScrapInBill(); //模具报废入库对应单据类
			public DAL.ClsSc_MouldScrapInBill BillOld0 = new DAL.ClsSc_MouldScrapInBill(); //模具报废入库对应单据类


			/// <summary>
			/// 根据包装单返回此包装单内的相关信息
			/// </summary>
			/// <returns></returns>
			///

			#region 模具其他入库单列表

			[Route("Sc_MouldOtherInBill/GetMouldOtherInBillList")]
			/// <summary>
			/// 检具维修工单列表
			/// </summary>
			/// <returns></returns>
			[Route("Sc_CheckToolsRepair/GetCheckToolsRepairWorkBillList")]
			[HttpGet]
			public object GetMouldProdOutBill(string sWhere)
			public object GetCheckToolsRepairWorkBillList(string sWhere)
			{
			try
			{

			ds = Sc_MouldOtherInBillList_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_MouldOtherInBill/GetMouldOtherInBill")]
			[HttpGet]
			public object GetMouldOtherInBill(string sWhere,string user, string Organization)
			{
			try
			{
			//编辑权限
			if (!DBUtility.ClsPub.Security_Log("Sc_MouldOtherInBillList", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "无查看权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			ds = Sc_MouldOtherInBill(sWhere, Organization);

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "返回记录成功！";
			@@ -49,209 +115,274 @@
			}
			}

			public static DataSet Sc_GetMouldProdOutBill(string sWhere)
			public static DataSet Sc_MouldOtherInBill(string sWhere, string Organization)
			{
			string sql1 = string.Format(@"select * from h_v_Sc_MouldOtherInBillList where 库存组织='" + Organization + "'");
			if (sWhere == null \|\| sWhere.Equals(""))
			{
			return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldOtherInBillList ", "h_v_Sc_MouldOtherInBillList");
			return new SQLHelper.ClsCN().RunProcReturn(sql1 + "order by hmainid desc", "h_v_Sc_MouldOtherInBillList");
			}
			else
			{
			string sql1 = "select * from h_v_Sc_MouldOtherInBillList where 1 = 1 ";
			string sql = sql1 + sWhere;
			string sql = sql1 + sWhere+ "order by hmainid desc";
			return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldOtherInBillList");
			}

			}

			#endregion
			///// <summary>
			///// 返回模具其他入库单列表
			/////参数：string sql。
			/////返回值：object。
			///// </summary>
			//[Route("Sc_MouldOtherInBill/GetMouldOtherInBillList")]
			//[HttpGet]
			//public object list(string sWhere)
			//{
			// try
			// {
			// if (sWhere == null \|\| sWhere.Equals(""))
			// {
			// ds = oCN.RunProcReturn("select * from Sc_MouldStockBillMain " + sWhere, "Sc_MouldStockBillMain");
			// }
			// else
			// {
			// string sql1 = "select * from Sc_MouldStockBillMain where 1 = 1 ";
			// string sql = sql1 + sWhere;
			// ds = oCN.RunProcReturn(sql, "Sc_MouldStockBillMain");
			// }
			// 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;
			// }
			//}
			///// <summary>
			///// 模具其他入库单列表
			///// </summary>
			///// <returns></returns>
			//[Route("Sc_MouldOtherInBill/GetMouldOtherInBillList")]
			//[HttpGet]
			//public object GetMouldOtherInBillList(string sWhere)
			//{
			// try
			// {

			// ds = Sc_MouldOtherInBillList_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_MouldOtherInBillList_s(string sWhere)
			#region[器具其他入库单编辑时获取表头数据]
			[Route("Sc_MouldOtherInBill/Sc_MouldOtherInBillListCheckDetai")]
			[HttpGet]
			public ApiResult<DataSet> Sc_MouldOtherInBillListCheckDetai(string HID)
			{
			return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldOtherInBillList ", "h_v_Sc_MouldOtherInBillList");
			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_MouldOtherInBillList where hmainid= " + HID + " ", "h_v_Sc_MouldOtherInBillList");
			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

			/// <summary>
			/// 修改单据-保存按钮
			///参数：string sql。
			///返回值：object。
			/// </summary>
			[Route("Sc_MouldOtherInBill/AddBill1")]
			[HttpPost]
			public object AddBill1([FromBody] JObject oMain)
			#region[器具其他入库单编辑时获取表体数据]
			[Route("Sc_MouldOtherInBill/Sc_MouldOtherInBillListProjectDetai")]
			[HttpGet]
			public object Sc_MouldOtherInBillListProjectDetai(string sqlWhere)
			{

			DataSet ds;
			DataSet ds1;
			List<object> list = new List<object>();
			try
			{
			DAL.ClsSc_MouldOtherInBill oMould = new DAL.ClsSc_MouldOtherInBill();
			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,收料仓库ID HWHID, 收料仓库代码 HWHCode, 收料仓库 HWHName,HSPID,
			仓位代码 HSPCode, 仓位 HSPName,表体备注 HRemark,HStockOrgID FROM h_v_Sc_MouldOtherInBillList"), "h_v_Sc_MouldOtherInBillList");

			var _value = oMain["oMain"].ToString();
			string msg1 = _value.ToString();
			string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
			string msg2 = sArray[0].ToString();
			string msg3 = sArray[1].ToString();
			string msg4 = sArray[2].ToString();
			string msg5 = sArray[3].ToString();
			//反序列化
			msg2 = "[" + msg2.ToString() + "]";
			List<Sc_MouldStockBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Sc_MouldStockBillMain>>(msg2);
			}
			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,收料仓库ID HWHID, 收料仓库代码 HWHCode, 收料仓库 HWHName,HSPID,
			仓位代码 HSPCode, 仓位 HSPName,表体备注 HRemark,HStockOrgID FROM h_v_Sc_MouldOtherInBillList where 1 = 1 ");
			string sql = sql1 + sqlWhere;
			ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldOtherInBillList");

			long HItemID = list[0].HInterID;
			string HBillNo = list[0].HBillNo;
			DateTime HDate = list[0].HDate;
			long HSCWHID = list[0].HSCWHID;
			long HWHID = list[0].HWHID;
			long HSupID = list[0].HSupID;
			long HSecManagerID = list[0].HSecManagerID;
			long HRepairID = list[0].HRepairID;
			long HManagerID = list[0].HManagerID;
			string HUpDater = list[0].HUpDater;
			long HDeptID = list[0].HDeptID;
			}
			//查汇总
			ds1 = oCN.RunProcReturn(string.Format(@"select 物料代码,max(物料名称)物料名称,规格型号,max(单据号)单据号,批次,sum(实发数量)实发数量,
			收料仓库ID,max(收料仓库代码)收料仓库代码,max(收料仓库)收料仓库,表体备注 from h_v_Sc_MouldOtherInBillList
			where 1=1 " + sqlWhere + " group by 物料代码,规格型号,收料仓库ID,批次,表体备注"), "h_v_Sc_MouldOtherInBillList");






			//若MAINDI重复则重新获取
			oCN.BeginTran();
			//主表
			oCN.RunProc("Update Sc_MouldStockBillMain set " +
			" HSCWHID=" + HSCWHID +
			",HWHID=" + HWHID +
			",HSupID=" + HSupID +
			",HSecManagerID=" + HSecManagerID +
			",HManagerID= " + HManagerID + " Where HInterID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);
			//修改子项目代码
			//oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_EquipMent,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo);
			//将上级为非末级
			//oCN.RunProc("Update Gy_EquipMent set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
			//
			oCN.Commit();
			objJsonResult.code = "1";
			list.Add(ds.Tables[0]);
			list.Add(ds1.Tables[0]);
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "修改单据成功！";
			//objJsonResult.data = null;
			return objJsonResult;
			objJsonResult.Message = "获取信息成功！";
			objJsonResult.list = list;
			}
			catch (Exception e)
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.Message;
			objJsonResult.Message = "没有返回任何记录！" + e.ToString();
			objJsonResult.data = null;
			}
			return objJsonResult;
			}
			#endregion

			#region 器具其他入库单保存/编辑
			/// <summary>
			/// 保存模具领用单
			/// </summary>
			/// <param name="msg"></param>
			/// <returns></returns>
			[Route("Sc_MouldOtherInBill/SaveGetMouldOtherInBillList")]
			[HttpPost]
			public object SaveGetMouldOtherInBillList([FromBody] JObject msg)
			{
			var _value = msg["msg"].ToString();
			string msg1 = _value.ToString();
			string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
			string msg2 = sArray[0].ToString();
			string msg3 = sArray[1].ToString();
			string msg4 = sArray[2].ToString();

			string UserName = "";
			ListModels oListModels = new ListModels();
			try
			{
			//编辑权限
			if (!DBUtility.ClsPub.Security_Log("Sc_MouldOtherInBill_Edit", 1, false, msg4))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "无保存权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			DLL.ClsSc_MouldOtherInBill oBill = new DLL.ClsSc_MouldOtherInBill();
			List<Model.ClsSc_MouldOtherInBillMain> lsmain = new List<Model.ClsSc_MouldOtherInBillMain>();
			msg2 = msg2.Replace("\\", "");
			msg2 = msg2.Replace("\n", ""); //\n
			lsmain = oListModels.getObjectByJson_Sc_MouldOtherInBillMain(msg2);
			foreach (Model.ClsSc_MouldOtherInBillMain oItem in lsmain)
			{
			//oItem.HMaker = "";
			UserName = oItem.HMaker; //制单人
			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 = 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) == "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存失败！没有单据日期，无法保存！";
			objJsonResult.data = 1;
			return objJsonResult;
			}
			oBill.omodel = oItem;
			}
			//表体数据
			//按 },{来拆分数组 //去掉【和】
			msg3 = msg3.Substring(1, msg3.Length - 2);
			msg3 = msg3.Replace("\\", "");
			msg3 = msg3.Replace("\n", ""); //\n
			//msg2 = msg2.Replace("'", "’");
			List<Model.ClsSc_MouldStockBillSub> ls = new List<Model.ClsSc_MouldStockBillSub>();
			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; //关闭类型
			//oItemSub.HRemark = ""; //备注
			oItemSub.HSourceInterID = 0; // 源单主内码
			oItemSub.HSourceEntryID = 0; //源单子内码
			//oItemSub.HSourceBillNo = ""; //源单单号
			//oItemSub.HSourceBillType = ""; //源单类型
			//oItemSub.HRelationQty = 0; //关联数量
			//oItemSub.HRelationMoney = 0; //关联金额
			//oItemSub.HRepairID = 0; //维修项目
			//oItemSub.HRepairExplanation =""; //维修要求
			//oItemSub.HMoney = 0; //维修费用
			oBill.DetailColl.Add(oItemSub);

			}
			//保存
			//保存完毕后处理
			bool bResult;
			if (oBill.omodel.HInterID == 0)
			{
			// bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
			bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
			}
			else
			{
			bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
			}
			if (bResult)
			{
			string sql = $"exec h_p_Sc_MouldChangeFileStatus 'in','{oBill.omodel.HInterID.ToString()}' ";
			oCn.RunProc(sql);
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "保存成功！";
			//WebAPIController.Add_Log("送货单下推", UserName, "生成送货单");
			objJsonResult.data = 1;
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.data = 1;
			return objJsonResult;
			}
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存失败！" + e.ToString();
			objJsonResult.data = 1;
			return objJsonResult;
			}
			}
			#endregion



			#region [器具其他入库单删除功能]
			/// <summary>
			/// 模具入库单列表删除按钮
			///参数：string sql。
			///返回值：object。
			/// 模具处理领用单删除功能
			/// </summary>
			[Route("Sc_MouldOtherInBill/Delete_Json")]
			/// <returns></returns>
			[Route("Sc_MouldOtherInBill/DeltetMouldOtherInBill")]
			[HttpGet]
			public object Delete_Json(long HItemID)
			public object DeltetMouldOtherInBill(string HInterID,string user)
			{
			DAL.ClsSc_MouldOtherInBill oMould = new DAL.ClsSc_MouldOtherInBill();
			try
			//编辑权限
			if (!DBUtility.ClsPub.Security_Log("Sc_MouldOtherOutBill_Delete", 1, false, user))
			{
			if (oMould.omodel.HBillStatus > 1)
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "无删除权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}


			Int64 lngBillKey = 0;
			lngBillKey = DBUtility.ClsPub.isLong(HInterID);
			if (lngBillKey == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据ID为空！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			DLL.ClsSc_MouldOtherInBill oBill = new DLL.ClsSc_MouldOtherInBill();
			if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
			{
			if (oBill.omodel.HBillStatus > 1)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			@@ -259,7 +390,7 @@
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (oMould.omodel.HChecker != "")
			if (oBill.omodel.HChecker != "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			@@ -267,195 +398,40 @@
			objJsonResult.data = null;
			return objJsonResult;
			}
			//
			if (oMould.DeleteBill(HItemID, ref DBUtility.ClsPub.sExeReturnInfo))
			{
			////写入日志
			//ClsPub.Add_Log("", "删除项目，代码：" + oMould.omodel.hn + ",名称：" + oMould.omodel.HName, ClsPub.CurUserName);
			//更新上级为末级
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "删除成功";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "删除失败";
			objJsonResult.data = null;
			return objJsonResult;
			}
			//ds = oCN.RunProcReturn("delete from Gy_Department where HItemID = " + HItemID, "Gy_Department");

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "删除成功";
			objJsonResult.data = null;
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}




			/// <summary>
			/// 新增单据-保存按钮
			///参数：string sql。
			///返回值：object。
			/// </summary>
			[Route("Sc_MouldOtherInBill/AddBill")]
			[HttpPost]
			public object AddBill([FromBody] JObject sMainSub)
			{
			var _value = sMainSub["sMainSub"].ToString();
			string msg1 = _value.ToString();
			oCN.BeginTran();
			//保存主表
			objJsonResult = AddBillMain(msg1);
			if (objJsonResult.code == "0")
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = objJsonResult.Message;
			objJsonResult.data = null;
			return objJsonResult;
			}
			oCN.Commit();
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "新增单据成功！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			public json AddBillMain(string msg1)
			{
			string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
			string msg2 = sArray[0].ToString();
			string msg3 = sArray[1].ToString();
			try
			{
			msg2 = "[" + msg2.ToString() + "]";
			List<Sc_MouldStockBillMain> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Sc_MouldStockBillMain>>(msg2);
			string BillType = "3795";
			long HInterID = mainList[0].HInterID;//递入type得到的单据ID
			string HBillNo = mainList[0].HBillNo;//递入type得到的单据号
			DateTime HDate = mainList[0].HDate;//日期
			int HYear = 2021;
			double HPeriod = 1;
			string HRemark = mainList[0].HRemark;//备注
			string HMaker = mainList[0].HMaker;//制单人
			long HSCWHID = mainList[0].HSCWHID;//
			long HSupID = mainList[0].HSupID;//
			long HEmpID = mainList[0].HEmpID;
			long HManagerID = mainList[0].HManagerID;//
			long HWHID = mainList[0].HWHID;//
			long HProcID = mainList[0].HProcID;//
			long HSecManagerID = mainList[0].HSecManagerID;//
			long HKeeperID = mainList[0].HKeeperID;//
			long HDeptID = mainList[0].HDeptID;
			string HExplanation = mainList[0].HExplanation;//
			string HInnerBillNo = mainList[0].HInnerBillNo;//
			string HRedBlueFlag = mainList[0].HRedBlueFlag;//
			string HRepairType = mainList[0].HRepairType;//
			long HRepairID = mainList[0].HRepairID;//

			//主表
			oCN.RunProc("Insert Into Sc_MouldStockBillMain " +
			"(HBillType,HBillSubType,HInterID,HBillNo,HDate" +
			",HYear,HPeriod,HRemark,HMaker,HMakeDate" +
			",HSupID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" +
			",HKeeperID,HDeptID,HExplanation,HInnerBillNo,HRedBlueFlag" +
			") " +
			" values('" + BillType + "','" + BillType + "'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" +
			"," + HYear + "," + HPeriod + ",'" + HRemark + "','" + HMaker + "',getdate()" +
			"," + HSupID + "," + HWHID + "," + HSCWHID + "," + HEmpID + "," + HManagerID + "," + HSecManagerID +
			"," + HKeeperID + "," + HDeptID + ",'" + HExplanation + "','" + HInnerBillNo + "','" + HRedBlueFlag + "'" +
			") ");

			//保存子表
			objJsonResult = AddBillSub(msg3, HInterID);
			if (objJsonResult.code == "0")
			bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
			if (IsDete)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = objJsonResult.Message;
			objJsonResult.count = 1;
			objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = null;
			objJsonResult.data = null;
			return objJsonResult;
			else
			{

			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			catch (Exception e)
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.Message = "单据未找到";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			public json AddBillSub(string msg3, long HInterID)
			{
			List<Sc_MouldStockBillSub> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Sc_MouldStockBillSub>>(msg3);
			for (int i = 0; i < subList.ToArray().Length; i++)
			{
			long HMaterID = 0;//物料ID
			long HPropertyID = 0;//
			long HSecUnitID = 0;//
			long HUnitID = 0;//
			long HWHID = 0;//
			long HSCWHID = 0;//
			long HSPID = 0;//
			long HSCSPID = 0;//
			long HSPGroupID = 0;//
			long HLifeUnitID = 0;//

			oCN.RunProc("Insert into Sc_MouldStockBillSub " +
			" (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" +
			",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
			",HMaterID,HPropertyID,HSecUnitID,HSecUnitRate,HUnitID,HQtyMust" +
			",HQty,HPrice,HMoney,HWHID,HSCWHID,HSPID" +
			",HDesignLife,HLeaveLife,HUseLife,HUseLifeQty" +
			",HSCSPID,HSPGroupID,HBatchNo" +
			",HNewModel,HWallThickness,HHardness,HLastProdModel,HDiameter,HBackFlag" +
			",HQtyRel,HNewLifeQty,HNowModel,HNowLife" +
			",HMouldType,HInitModel,HInitDesignLife,HLifeUnitID" +
			") values("
			+ HInterID + "," + i + ",'','','','" + subList[i].HRemark + "'" +
			"," + subList[i].HSourceInterID + "," + subList[i].HSourceEntryID + ",'" + subList[i].HSourceBillNo + "','" + subList[i].HSourceBillType + "','" + subList[i].HrelationQty + "','" + subList[i].HrelationQty + "'" +
			"," + HMaterID + "," + HPropertyID + "," + HSecUnitID + ",'" + subList[i].HSecUnitRate + "','" + HUnitID + "','" + subList[i].HQtyMust + "'" +
			",'" + subList[i].HQty + "','" + subList[i].HPrice + "','" + subList[i].HMoney + "'," + HWHID + "," + HSCWHID + "," + HSPID +
			",'" + subList[i].HDesignLife + "','" + subList[i].HLeaveLife + "','" + subList[i].HUseLife + "','" + subList[i].HUseLifeQty + "'" +
			"," + HSCSPID + "," + HSPGroupID + ",'" + subList[i].HBatchNo + "'" +
			",'" + subList[i].HNewModel + "','" + subList[i].HWallThickness + "','" + subList[i].HHardness + "','" + subList[i].HLastProdModel + "','" + subList[i].HDiameter + "','" + subList[i].HBackFlag + "'" +
			",'" + subList[i].HQtyRel + "','" + subList[i].HNewLifeQty + "','" + subList[i].HNowModel + "','" + subList[i].HNowLife + "'" +
			",'" + subList[i].HMouldType + "','" + subList[i].HInitModel + "','" + subList[i].HInitDesignLife + "'," + HLifeUnitID +
			") ");
			}

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = null;
			objJsonResult.data = null;
			return objJsonResult;
			}


			}
			}
			}
			#endregion
			#endregion