MES-WEB-API.git

			@@ -29,15 +29,75 @@
			{
			DetailColl = null;
			}


			#endregion 自定义方法

			//保存前控制
			public bool BeforeSave(Int64 HInterID, Int64 HICMOInterID, Int64 HICMOEntryID, string HICMOBillNo, Int64 OperationType, ref string sReturn)
			{
			try
			{
			DataSet Ds = oCn.RunProcReturn("Exec h_p_Sc_MESStopWorkBill_BeforeSaveCtrl " + HInterID.ToString() + "," + HICMOInterID.ToString() + "," + HICMOEntryID.ToString() + ",'" + HICMOBillNo + "'," + OperationType.ToString(), "h_p_Sc_MESStopWorkBill_BeforeSaveCtrl");
			if (Ds == null \|\| Ds.Tables[0].Rows.Count == 0)
			{
			sReturn = "保存前判断失败！";
			return false;
			}
			else
			{
			if (DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HBack"]) == 1)
			{
			sReturn = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRemark"]);
			return false;
			}
			}
			return true;
			}
			catch (Exception e)
			{
			throw (e);
			}
			}

			//保存后控制
			public bool AfterSave(Int64 HInterID, Int64 HICMOInterID, Int64 HICMOEntryID, string HICMOBillNo, Int64 OperationType, ref string sReturn)
			{
			try
			{
			DataSet Ds = oCn.RunProcReturn("Exec h_p_Sc_MESStopWorkBill_AfterSaveCtrl " + HInterID.ToString() + "," + HICMOInterID.ToString() + "," + HICMOEntryID.ToString() + ",'" + HICMOBillNo + "'," + OperationType.ToString(), "h_p_Sc_MESStopWorkBill_AfterSaveCtrl");
			if (Ds == null \|\| Ds.Tables[0].Rows.Count == 0)
			{
			sReturn = "保存后判断失败！";
			return false;
			}
			else
			{
			if (DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HBack"]) == 1)
			{
			sReturn = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRemark"]);
			return false;
			}
			}
			return true;
			}
			catch (Exception e)
			{
			throw (e);
			}
			}

			//修改单据
			public override bool ModifyBill(Int64 lngBillKey, ref string sReturn)
			{
			try
			{
			//
			oCn.BeginTran();
			//保存前控制
			if (!BeforeSave(lngBillKey, omodel.HICMOInterID, omodel.HICMOEntryID, omodel.HICMOBillNo, 2, ref sReturn))
			{
			oCn.RollBack();
			return false;
			}
			//更新主表
			oCn.RunProc("UpDate Sc_MESStopWorkBillMain set " +
			" HBillNo='" + omodel.HBillNo + "'" + //固定赋值===============
			@@ -83,11 +143,13 @@
			",HDeptID=" + omodel.HDeptID.ToString() +
			",HEmpID=" + omodel.HEmpID.ToString() +
			",HStopReason='" + omodel.HStopReason + "'" +
			",HStopType='" + omodel.HStopType + "'" +
			",HReportType='" + omodel.HReportType + "'" +
			",HBarCode='" + omodel.HBarCode + "'" +
			",HAddr='" + omodel.HAddr + "'" +
			",HBarCodeMaker='" + omodel.HBarCodeMaker + "'" +
			",HBarCodeMakeDate='" + omodel.HBarCodeMakeDate + "'" +
			",HWorkShiftID='" + omodel.HWorkShiftID + "'" +
			" where HInterID=" + lngBillKey.ToString());
			//删除关联
			DeleteRelation(ref sReturn, lngBillKey);
			@@ -137,7 +199,14 @@
			// return false;
			// }
			//}
			sReturn = "修改单据成功！";

			//保存后控制
			if (!AfterSave(lngBillKey, omodel.HICMOInterID, omodel.HICMOEntryID, omodel.HICMOBillNo, 2, ref sReturn))
			{
			oCn.RollBack();
			return false;
			}
			sReturn = "单据号：" + omodel.HBillNo + " 修改成功！";
			oCn.Commit();
			return true;
			}
			@@ -158,16 +227,12 @@
			omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo);
			//若MAINDI重复则重新获取
			oCn.BeginTran();
			//保存前控制=========================================
			ds = oCn.RunProcReturn("exec h_p_Sc_MESStopWorkBill_BeforeSaveCtrl " + omodel.HInterID + "," + omodel.HICMOInterID + "," + omodel.HICMOEntryID + ",'" + omodel.HICMOBillNo + "'", "h_p_Sc_MESStopWorkBill_BeforeSaveCtrl");

			if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) == "1")
			//保存前控制
			if (!BeforeSave(omodel.HInterID, omodel.HICMOInterID, omodel.HICMOEntryID, omodel.HICMOBillNo, 1, ref sReturn))
			{
			sReturn = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
			oCn.RollBack();
			return false;
			}
			//=========================================================

			//主表
			oCn.RunProc("Insert Into Sc_MESStopWorkBillMain " +
			"(HBillType,HBillSubType,HInterID,HBillNo,HBillStatus,HDate,HMaker,HMakeDate" +
			@@ -176,7 +241,7 @@
			",HProcExchBillNo,HMaterID,HProcID,HICMOQty,HPlanQty,HStopBeginWorkTime,HStopEndWorkTime,HSourceID" +
			",HGroupID,HDeptID,HEmpID,HStopReason,HReportType,HBarCode,HAddr,HBarCodeMaker,HBarCodeMakeDate" +
			",HSourceInterID_Main,HSourceEntryID_Main,HSourceBillNo_Main,HSourceBillType_Main" +
			",HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType" +
			",HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType,HStopType,HWorkShiftID" +
			") " +
			" values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "'," + omodel.HBillStatus.ToString() + ",getdate(),'" + omodel.HMaker + "',getdate()" +
			"," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "'" +
			@@ -184,7 +249,7 @@
			",'" + omodel.HProcExchBillNo + "'," + omodel.HMaterID.ToString() + "," + omodel.HProcID.ToString() + "," + omodel.HICMOQty.ToString() + "," + omodel.HPlanQty.ToString() + ",getdate(),'" + omodel.HStopEndWorkTime.ToShortDateString() + "'," + omodel.HSourceID.ToString() +
			"," + omodel.HGroupID.ToString() + "," + omodel.HDeptID.ToString() + "," + omodel.HEmpID.ToString() + ",'" + omodel.HStopReason + "','" + omodel.HReportType + "','" + omodel.HBarCode + "','" + omodel.HAddr + "','" + omodel.HBarCodeMaker + "',getdate()" +
			"," + omodel.HMainSourceInterID.ToString() + "," + omodel.HMainSourceEntryID.ToString() + ",'" + omodel.HMainSourceBillNo.ToString() + "','" + omodel.HMainSourceBillType + "'" +
			"," + omodel.HMainSourceInterID.ToString() + "," + omodel.HMainSourceEntryID.ToString() + ",'" + omodel.HMainSourceBillNo.ToString() + "','" + omodel.HMainSourceBillType + "'" +
			"," + omodel.HMainSourceInterID.ToString() + "," + omodel.HMainSourceEntryID.ToString() + ",'" + omodel.HMainSourceBillNo.ToString() + "','" + omodel.HMainSourceBillType + "','"+ omodel.HStopType + "','" + omodel.HWorkShiftID + "'" +
			") ");

			//再次验证保存是否合理
			@@ -202,16 +267,12 @@
			return false;
			}

			//保存后控制=========================================
			ds = oCn.RunProcReturn("exec h_p_Sc_MESStopWorkBill_AfterSaveCtrl " + omodel.HInterID + "," + omodel.HICMOInterID + "," + omodel.HICMOEntryID + ",'" + omodel.HICMOBillNo + "'", "h_p_Sc_MESStopWorkBill_AfterSaveCtrl");

			if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) == "1")
			//保存后控制
			if (!AfterSave(omodel.HInterID, omodel.HICMOInterID, omodel.HICMOEntryID, omodel.HICMOBillNo, 1, ref sReturn))
			{
			sReturn = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
			oCn.RollBack();
			return false;
			}
			//=========================================================

			sReturn = omodel.HInterID.ToString();
			oCn.Commit();
			@@ -422,7 +483,7 @@
			}

			//删除单据
			public override bool DeleteBill(Int64 lngBillKey, ref string sReturn)
			public bool DeleteBill(Int64 lngBillKey, string HBillNo, string procName, string user, ref string sReturn)
			{
			try
			{
			@@ -448,6 +509,24 @@
			//删除主表
			oCn.RunProc("Delete From " + MvarItemKey + " where HInterID=" + lngBillKey.ToString());

			//删除后控制==================================================================================
			string sql2 = "exec " + procName + " " + lngBillKey + ",'" + HBillNo + "','" + user + "'";
			ds = oCn.RunProcReturn(sql2, procName);
			if (ds == null \|\| ds.Tables.Count == 0 \|\| ds.Tables[0].Rows.Count == 0)
			{

			sReturn = "删除失败!原因:删除后判断失败，请与网络管理人员联系";
			oCn.RollBack();
			return false;
			}
			if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")
			{
			sReturn = "删除失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString();
			oCn.RollBack();
			return false;
			}
			//==============================================================================================

			sReturn = "删除单据成功！";
			oCn.Commit();
			return true;