MES-WEB-API.git

			@@ -10,6 +10,7 @@
			public Models.ClsOA_ErrMsgBackBillMain omodel = new Models.ClsOA_ErrMsgBackBillMain();
			public List<Models.ClsOA_ErrMsgBackBillSub> DetailColl = new List<Models.ClsOA_ErrMsgBackBillSub>();
			public List<Models.ClsOA_ErrMsgBackBillSub2> DetailColl2 = new List<Models.ClsOA_ErrMsgBackBillSub2>();
			public Models.ClsOA_ErrMsgBackBillSub DetailReply = new Models.ClsOA_ErrMsgBackBillSub();

			public ClsOA_ErrMsgBackBill()
			{
			@@ -64,7 +65,19 @@
			",HDescription='" + omodel.HDescription + "'" +
			",HHasten=" + omodel.HHasten.ToString() +
			",HQty=" + omodel.HQty.ToString() +

			",HRecDeptID=" + omodel.HRecDeptID.ToString() +
			",HMaterNumber='" + omodel.HMaterNumber + "'" +
			",HForm='" + omodel.HForm + "'" +
			",HChangeNote='" + omodel.HChangeNote + "'" +
			",HNote='" + omodel.HNote + "'" +
			",HCenterID='" + omodel.HCenterID + "'" +
			",HBadProcMan='" + omodel.HBadProcMan.ToString() + "'" +
			",HQEMan='" + omodel.HQEMan.ToString() + "'" +
			",HSourceID='" + omodel.HSourceID.ToString() + "'" +
			",HShiftsID='" + omodel.HShiftsID.ToString()+ "'" +
			",HErrLev ='" + omodel.HErrLev.ToString() + "'" +
			",HHandleEmpID=" + omodel.HHandleEmpID.ToString() +

			" where HInterID=" + lngBillKey.ToString());
			//删除关联
			DeleteRelation(ref sReturn, lngBillKey);
			@@ -124,7 +137,7 @@
			try
			{
			//得到mainid
			omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo);
			//omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo);
			//若MAINDI重复则重新获取
			oCn.BeginTran();
			//主表
			@@ -134,7 +147,8 @@
			",HContext,HDeptID,HDescription,HSendMan,HReceiveMan" +
			",HCopyMan,HHasten,HLevel,HReTransmitMan,HBillTypeName"+
			",HPlanBillNo,HMaterName,HMaterModel,HQty,HSendType"+
			",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRecDeptID,HMaterNumber" +
			",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRecDeptID,HMaterNumber,HErrMsgBackTypeID,HHandleEmpID,HCloseFlag" +
			",HForm,HChangeNote,HNote,HBadProcMan,HQEMan,HSourceID,HShiftsID,HErrLev,HCenterID" +
			") " +
			" values('" + this.BillType + "','" + this.HBillSubType + "'," +omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" +
			"," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + DBUtility.ClsPub.CurUserName + "',getdate()" +
			@@ -142,8 +156,8 @@
			",'" + omodel.HCopyMan + "'," + omodel.HHasten.ToString() + ",'" + omodel.HLevel + "','" + omodel.HReTransmitMan + "','" + omodel.HBillTypeName + "'" +
			",'" + omodel.HPlanBillNo + "','" + omodel.HMaterName + "','" + omodel.HMaterModel + "'," + omodel.HQty.ToString() + ",'" + omodel.HSendType + "'" +
			",'" + omodel.HMainSourceInterID + "','" + omodel.HMainSourceEntryID + "','" + omodel.HMainSourceBillNo + "','" + omodel.HMainSourceBillType + "'" +
			"," + omodel.HRecDeptID + ",'" + omodel.HMaterNumber + "'" +
			") ");
			"," + omodel.HRecDeptID + ",'" + omodel.HMaterNumber + "'," + omodel.HErrMsgBackTypeID +", " + omodel.HHandleEmpID + ", '"+ "0"+
			"','" + omodel.HForm + "','" + omodel.HChangeNote + "','" + omodel.HNote + "','" + omodel.HBadProcMan + "','" + omodel.HQEMan + "','" + omodel.HSourceID + "','" + omodel.HShiftsID + "','" + omodel.HErrLev+ "','" + omodel.HCenterID + "') ");
			//插入子表
			//foreach (Models.ClsOA_ErrMsgBackBillSub oSub in DetailColl)
			//{
			@@ -193,6 +207,52 @@
			}
			}

			public bool ReplyBill(ref string sReturn)
			{
			try
			{

			//若MAINDI重复则重新获取
			oCn.BeginTran();


			DataSet Ds = oCn.RunProcReturn("select count(HInterID) as num from OA_ErrMsgBackBillSub where HInterID = " + DetailReply.HInterID + " group by HInterID ", "OA_ErrMsgBackBillSub");

			Int64 num = 0;

			if (Ds.Tables[0].Rows.Count == 0)
			{
			num = 1;
			}
			else
			{
			num = Convert.ToInt64(Ds.Tables[0].Rows[0]["num"]) + 1;
			}

			//主表
			oCn.RunProc("Insert Into OA_ErrMsgBackBillSub " +
			"(HInterID,HEntryID,HRemark,HSendStatus,HSendMan" +
			",HDescriptionSub,HDate" +
			",HCloseMan,HEntryCloseDate,HCloseType,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
			") " +
			" values(" + DetailReply.HInterID + "," + num + ",'" + DetailReply.HRemark + "'," + 1 + ",'" + DetailReply.HSendMan + "'" +
			",'" + DetailReply.HDescriptionSub + "','" + DetailReply.HDate + "','" + DetailReply.HCloseMan + "','" + "" + "'" +
			"," + 0 + "," + DetailReply.HSourceInterID + "," + DetailReply.HSourceEntryID + ",'" + DetailReply.HSourceBillNo + "'" +
			",'" + DetailReply.HSourceBillType + "'," + DetailReply.HRelationQty + "," + DetailReply.HRelationMoney +
			") ");

			sReturn = omodel.HInterID.ToString();
			oCn.Commit();
			return true;
			}
			catch (Exception e)
			{
			sReturn = e.Message;
			oCn.RollBack();
			throw (e);
			}
			}

			//删除单据
			public virtual bool DeleteBill(Int64 lngBillKey,string HEntryID, ref string sReturn)
			{