MES-WEB-API.git

			@@ -38,6 +38,7 @@
			oCn.BeginTran();
			//鏇存柊涓昏〃
			oCn.RunProc("UpDate Gy_RoutingBillMain set " +
			",HPRDORGID=" + omodel.HPRDORGID.ToString() +
			" HName='" + omodel.HName + "'" +
			",HBillNo='" + omodel.HBillNo + "'" +
			",HMaterTypeID=" + omodel.HMaterTypeID.ToString() +
			@@ -184,14 +185,14 @@
			",HRoutingGroupID,HUnitID,HMaterNumber,HUnitNumber,HStandard" +
			",HMainGroupID,HMainProcID,HMainCenterID,HMainTimeUnit,HMainUnitTime,HMainWorkQty" +
			",HMainPrice,HStdSourceQty,HAddSourceRate,HDelSourceRate" +
			",HPicNumVer,HPicNumAssemble,HMaterTexture,HProductNum,HVerNum" +
			",HPicNumVer,HPicNumAssemble,HMaterTexture,HProductNum,HPRDORGID,HVerNum" +
			") " +
			" values('" + this.BillType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" +
			"," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + DBUtility.ClsPub.CurUserName + "',getdate()," + omodel.HMaterID.ToString() + ",'" + omodel.HName + "'," + omodel.HMaterTypeID.ToString() +
			",'" + omodel.HRoutingGroupID.ToString() + "'," + omodel.HUnitID.ToString() + ",'" + omodel.HMaterNumber + "','" + omodel.HUnitNumber + "'," + DBUtility.ClsPub.BoolToString(omodel.HStandard) +
			"," + omodel.HMainGroupID.ToString() + "," + omodel.HMainProcID.ToString() + "," + omodel.HMainCenterID.ToString() + ",'" + omodel.HMainTimeUnit + "'," + omodel.HMainUnitTime.ToString() + "," + omodel.HMainWorkQty.ToString() +
			"," + omodel.HMainPrice.ToString() + "," + omodel.HStdSourceQty.ToString() + "," + omodel.HAddSourceRate + "," + omodel.HDelSourceRate.ToString() +
			",'" + omodel.HPicNumVer.ToString() + "','" + omodel.HPicNumAssemble.ToString() + "','" + omodel.HMaterTexture.ToString() + "','" + omodel.HProductNum.ToString() + "','" + omodel.HVerNum.ToString() + "'"+
			",'" + omodel.HPicNumVer.ToString() + "','" + omodel.HPicNumAssemble.ToString() + "','" + omodel.HMaterTexture.ToString() + "','" + omodel.HProductNum.ToString() + "','"+omodel.HPRDORGID.ToString()+"','" + omodel.HVerNum.ToString() + "'"+
			") ");
			//鎻掑叆瀛愯〃
			foreach (Model.ClsGy_RoutingBillSub oSub in DetailColl)
			@@ -261,7 +262,7 @@
			{
			//鏌ヨ涓昏〃
			DataSet Ds ;
			Ds = oCn.RunProcReturn("Select * from Gy_RoutingBillMain Where HInterID=" + lngBillKey.ToString(), "Gy_RoutingBillMain");
			Ds = oCn.RunProcReturn("Select * from Gy_RoutingBillMain Where HInterID=" + lngBillKey.ToString()+" and HPRDORGID='"+DBUtility.ClsPub.HOrgID.ToString()+"'", "Gy_RoutingBillMain");
			if(Ds.Tables[0].Rows.Count==0)
			{
			sReturn = "鍗曟嵁鏈壘鍒帮紒";