~yxj/MES-WEB-API.git

			@@ -119,9 +119,9 @@
			string msg2 = sArray[0].ToString();
			string msg3 = sArray[1].ToString();

			int hentryid = int.Parse(sArray[2].ToString());//子表的顺序id
			int OperationType = int.Parse(sArray[3].ToString());//数据类型 1添加 3修改
			string user = sArray[4].ToString();//用户名
			//int hentryid = int.Parse(sArray[2].ToString());//子表的顺序id
			int OperationType = int.Parse(sArray[2].ToString());//数据类型 1添加 3修改
			string user = sArray[3].ToString();//用户名
			try
			{
			//判断是否有编辑权限
			@@ -162,7 +162,7 @@
			double HStdSourceQty = mainList[0].HStdSourceQty;//标准资源数
			double HAddSourceRate = mainList[0].HAddSourceRate;//加资源增量
			double HDelSourceRate = mainList[0].HDelSourceRate;//减资源减量
			int HPRDORGID = mainList[0].HPRDORGID; //生产组织
			int HPRDORGID = mainList[0].HOrgID; //生产组织
			int HOrgID = mainList[0].HOrgID; //组织
			string HPicNumVer = mainList[0].HPicNumVer;//图号版本
			string HPicNumAssemble = mainList[0].HPicNumAssemble;//总装图号
			@@ -170,7 +170,9 @@
			string HProductNum = mainList[0].HProductNum;//成品编号
			string HVerNum = mainList[0].HVerNum;//版本

			if (OperationType == 1)//新增
			ds = oCN.RunProcReturn("select * from h_v_Gy_RoutingBillList where hmainid=" + HInterID + " and 单据号='" + HBillNo + "'", "h_v_Gy_RoutingBillList");

			if (OperationType == 1 && ds.Tables[0].Rows.Count == 0)//新增
			{
			//主表
			oCN.RunProc("Insert Into Gy_RoutingBillMain " +
			@@ -186,7 +188,7 @@
			"," + HMainPrice + "," + HStdSourceQty + "," + HAddSourceRate + "," + HPRDORGID + "," + HDelSourceRate +
			",'"+ HPicNumVer + "','" + HPicNumAssemble + "','" + HMaterTexture + "','" + HProductNum + "','" + HVerNum + "',"+ HOrgID + ") ");
			}
			else if (OperationType == 3)
			else if (OperationType == 3 \|\| ds.Tables[0].Rows.Count != 0)
			{ //修改
			oCN.RunProc("update Gy_RoutingBillMain set " +
			"HDate='" + HDate +
			@@ -200,10 +202,10 @@
			",HProductNum='" + HProductNum + "',HVerNum='" + HVerNum + "' where HInterID='" + HInterID + "'");

			//删除子表
			oCN.RunProc("delete from Gy_RoutingBillSub where HInterID='" + HInterID + "' and HEntryID='" + hentryid + "'");
			oCN.RunProc("delete from Gy_RoutingBillSub where HInterID='" + HInterID+ "' and HProcNo!='9999'");
			}
			//保存子表
			objJsonResult = AddBillSub(msg3, HInterID, hentryid);
			objJsonResult = AddBillSub(msg3, HInterID);
			if (objJsonResult.code == "0")
			{
			objJsonResult.code = "0";
			@@ -255,7 +257,7 @@
			}
			}

			public json AddBillSub(string msg3, long HInterID, int hentryid)
			public json AddBillSub(string msg3, long HInterID)
			{
			List<Gy_RoutingBillSub> DetailColl = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_RoutingBillSub>>(msg3);
			int i = 0;
			@@ -271,6 +273,8 @@
			return objJsonResult;
			}

			if (oSub.HProcNo!="9999")
			{
			oCN.RunProc("Insert into Gy_RoutingBillSub " +
			"(HInterID,HEntryID,HProcID,HProcNO,HSupID,HSupFlag" +
			",HWorkQty,HCenterID,HTimeUnit,HUnitTime" +
			@@ -284,7 +288,7 @@
			",HTechnologyParameter,HPicNum,HProcCheckNote" +
			",HOverRate,HProcWorkNum" +
			") values("
			+ HInterID + "," + (hentryid==-1?i: hentryid) + "," + oSub.HProcID.ToString() + ",'" + (hentryid == -1 ? i : hentryid) + "'," + oSub.HSupID.ToString() + "," + Convert.ToString(oSub.HSupFlag ? 1 : 0) + "" +
			+ HInterID + "," + i + "," + oSub.HProcID.ToString() + ",'" + oSub.HProcNo + "'," + oSub.HSupID.ToString() + "," + Convert.ToString(oSub.HSupFlag ? 1 : 0) + "" +
			"," + oSub.HWorkQty.ToString() + "," + oSub.HCenterID.ToString() + ",'" + oSub.HTimeUnit.ToString() + "'," + oSub.HUnitTime.ToString() +
			"," + oSub.HReadyTime.ToString() + "," + oSub.HQueueTime.ToString() + "," + oSub.HMoveTime.ToString() +
			",'" + oSub.HCloseMan + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "','" + oSub.HProcType + "'," + Convert.ToString(oSub.HNextProcFlag ? 1 : 0) + "," + Convert.ToString(oSub.HFlowProc ? 1 : 0) +
			@@ -297,6 +301,7 @@
			"', " + oSub.HOverRate.ToString() + ",'" + oSub.HProcWorkNum.ToString() + "'" +
			") ");
			}
			}

			objJsonResult.code = "1";
			objJsonResult.count = 1;