~yxj/MES-WEB-API.git

			@@ -8,9 +8,9 @@
			{
			public class ClsSc_ICMOReportBill:DBUtility.ClsXt_BaseBill
			{
			public Model.ClsSc_ICMOReportBillMain omodel = new Model.ClsSc_ICMOReportBillMain();
			public Model.ClsSc_ICMOReportBillSub oSub = new Model.ClsSc_ICMOReportBillSub();
			public List<Model.ClsSc_ICMOReportBillSub> DetailColl = new List<Model.ClsSc_ICMOReportBillSub>();
			public Models.ClsSc_ICMOReportBillMain omodel = new Models.ClsSc_ICMOReportBillMain();
			public Models.ClsSc_ICMOReportBillSub oSub = new Models.ClsSc_ICMOReportBillSub();
			public List<Models.ClsSc_ICMOReportBillSub> DetailColl = new List<Models.ClsSc_ICMOReportBillSub>();

			public ClsSc_ICMOReportBill()
			{
			@@ -51,6 +51,11 @@
			",HUpDater='" + omodel.HMaker + "'" +
			",HUpDateDate=getdate()" +
			//========================================
			",HMainSourceBillNo='" + omodel.HMainSourceBillNo + "'" +
			",HMainSourceInterID=" + omodel.HMainSourceInterID.ToString() +
			",HMainSourceEntryID=" + omodel.HMainSourceEntryID.ToString() +
			",HMainSourceBillType=" + omodel.HMainSourceBillType.ToString() +

			",HDeptID=" + omodel.HDeptID.ToString() +
			",HDeptNumber='" + omodel.HDeptNumber +"'"+
			",HEmpID=" + omodel.HEmpID.ToString() +
			@@ -64,7 +69,7 @@
			DeleteBillSub(lngBillKey);
			//插入子表
			omodel.HInterID = lngBillKey;
			foreach (Model.ClsSc_ICMOReportBillSub oSub in DetailColl)
			foreach (Models.ClsSc_ICMOReportBillSub oSub in DetailColl)
			{
			oCn.RunProc("Insert into Sc_ICMOReportBillSub " +
			" (HInterID,HEntryID,HMaterID,HMaterNumber" +
			@@ -150,13 +155,15 @@
			"(HBillType,HBillSubType,HInterID,HBillNo,HDate,HMaker,HMakeDate" +
			",HYear,HPeriod,HRemark,HEmpID,HEmpNumber" +
			",HGroupID,HDeptID,HDeptNumber" +
			",HMainSourceBillNo,HMainSourceInterID,HMainSourceEntryID,HMainSourceBillType" +
			") " +
			" values('" + this.BillType + "','" + this.HBillSubType + "'," +omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "','" + omodel.HMaker+ "',getdate()" +
			"," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + omodel.HEmpID.ToString() + "','" + omodel.HEmpNumber +
			"','" + omodel.HGroupID.ToString() + "'," + omodel.HDeptID.ToString() + ",'" + omodel.HDeptNumber + "'"+
			"','" + omodel.HGroupID.ToString() + "'," + omodel.HDeptID.ToString() + ",'" + omodel.HDeptNumber +
			"','" + omodel.HMainSourceBillNo.ToString() + "'," + omodel.HMainSourceInterID.ToString() + ",'" + omodel.HMainSourceEntryID + "','" + omodel.HMainSourceBillType + "'" +
			") ");
			//插入子表
			foreach (Model.ClsSc_ICMOReportBillSub oSub in DetailColl)
			foreach (Models.ClsSc_ICMOReportBillSub oSub in DetailColl)
			{
			oCn.RunProc("Insert into Sc_ICMOReportBillSub " +
			" (HInterID,HEntryID,HMaterID,HMaterNumber" +
			@@ -254,7 +261,7 @@
			DetailColl.Clear();//清空
			for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++)
			{
			Model.ClsSc_ICMOReportBillSub oSub = new Model.ClsSc_ICMOReportBillSub();
			Models.ClsSc_ICMOReportBillSub oSub = new Models.ClsSc_ICMOReportBillSub();
			// 固定赋值===============================================
			oSub.HInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HInterID"]);
			oSub.HEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HEntryID"]);
			@@ -329,7 +336,7 @@
			"," + omodel.HGroupID.ToString() + "," + omodel.HDeptID.ToString() +
			") ");
			//插入子表
			foreach (Model.ClsSc_ICMOReportBillSub oSub in DetailColl)
			foreach (Models.ClsSc_ICMOReportBillSub oSub in DetailColl)
			{
			oCn.RunProc("Insert into Sc_ICMOReportBillSub " +
			" (HInterID,HEntryID,HMaterID" +
			@@ -405,7 +412,7 @@
			"," + omodel.HGroupID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HCheckType + "'" +
			") ");
			//插入子表
			foreach (Model.ClsSc_ICMOReportBillSub oSub in DetailColl)
			foreach (Models.ClsSc_ICMOReportBillSub oSub in DetailColl)
			{
			oCn.RunProc("Insert into Sc_ICMOReportBillSub " +
			" (HInterID,HEntryID,HMaterID" +