MES-WEB-API.git

			@@ -8,12 +8,12 @@
			public class ClsCg_PayableBill : DBUtility.ClsXt_BaseBill
			{
			public Model.ClsCg_PayableBillMain omodel = new Model.ClsCg_PayableBillMain();
			public List<Model.ClsCg_PayableBillSub> DetailColl = new List<Model.ClsCg_PayableBillSub>();

			public List<Model.ClsCg_PayableSub> DetailColl = new List<Model.ClsCg_PayableSub>();
			public List<Model.ClsCg_PayableSub> DetailCol2 = new List<Model.ClsCg_PayableSub>();
			public ClsCg_PayableBill()
			{
			base.MvarItemKeySub = "Cg_PayableBillSub";
			base.MvarItemKeySub2 = "";
			base.MvarItemKeySub = "Cg_PayableSub";
			base.MvarItemKeySub2 = "Cg_PayableSub_Entry";
			base.MvarItemKeySub3 = "";
			base.MvarItemKeySub4 = "";
			base.MvarItemKey= "Cg_PayableBillMain";
			@@ -32,11 +32,75 @@
			#endregion
			#endregion

			//å é¤å³è
			public override void DeleteRelation(ref string sReturn, Int64 lngBillKey)
			{
			//éè´å¥åºå éè´è®¢å å³èæ°é
			try
			{
			if (DetailColl[0].HSourceBillType == "1201") //éè´å¥åºå
			{
			oCn.RunProc("exec h_p_Cg_UpDateRelation_POStockInToPayable_Del " + lngBillKey.ToString());
			}
			else if (DetailColl[0].HSourceBillType == "1102") //éè´è®¢å
			{
			oCn.RunProc("exec h_p_Cg_UpDateRelation_POOrderToPayable_Del " + lngBillKey.ToString());
			}
			else
			{

			}
			}
			catch (Exception e)
			{
			throw (e);
			}
			}

			//æ°å¢å³è
			public override void AddNewRelation(ref string sReturn, Int64 lngBillKey)
			{
			//éè´å¥åºå éè´è®¢å å³èæ°é
			try
			{
			if (DetailColl[0].HSourceBillType == "1201") //éè´å¥åºå
			{
			oCn.RunProc("exec h_p_Cg_UpDateRelation_POStockInToPayable_Add " + lngBillKey.ToString());
			}
			else if (DetailColl[0].HSourceBillType == "1102") //éè´è®¢å
			{
			oCn.RunProc("exec h_p_Cg_UpDateRelation_POOrderToPayable_Add " + lngBillKey.ToString());
			}
			else
			{

			}
			}
			catch (Exception e)
			{
			throw (e);
			}
			}

			#region ä¿®æ¹åæ®
			public override bool ModifyBill(Int64 lngBillKey, ref string sReturn)
			{
			try
			{
			//ä¿ååæ§å¶=========================================
			string HBillNote = "";
			DataSet ds = oCn.RunProcReturn("Exec h_p_Cg_PayableBill_BeforeSaveCtrl " + omodel.HInterID, "h_p_Cg_PayableBill_BeforeSaveCtrl");
			if (ds == null)
			{
			sReturn = "ä¿ååå¤æå¤±è´¥ï¼";
			return false;
			}
			if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
			{
			sReturn = "ä¿åå¤±è´¥ï¼" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
			return false;
			}
			//=========================================================
			oCn.BeginTran();
			//æ´æ°ä¸»è¡¨
			string mainSql = "update Cg_PayableBillMain set " +
			@@ -67,11 +131,12 @@
			DeleteRelation(ref sReturn, lngBillKey);
			//å é¤åè¡¨
			DeleteBillSub(lngBillKey);

			//å é¤åè¡¨2
			DeleteBillSub2(lngBillKey);
			//æå¥åè¡¨
			omodel.HInterID = lngBillKey;
			//æå¥åè¡¨
			foreach (Model.ClsCg_PayableBillSub oSub in DetailColl)
			foreach (Model.ClsCg_PayableSub oSub in DetailColl)
			{
			string subSql = "insert into Cg_PayableSub" +
			"(HInterID,HEntryID,HBillNo_bak,HMaterID,HUnitID,HQty,HPrice,HTaxPrice,HDiscountRate,HRelTaxPrice,HTaxRate,HTaxMoney" +
			@@ -113,6 +178,66 @@
			")";
			oCn.RunProc(subSql);
			}
			//æ´æ°è®¢åå³èæ°é
			AddNewRelation(ref sReturn, omodel.HInterID);
			//æå¥åè¡¨2
			foreach (Model.ClsCg_PayableSub oSub in DetailCol2)
			{
			string subSql = "insert into Cg_PayableSub_Entry" +
			"(HInterID,HEntryID,HBillNo_bak,HMaterID,HUnitID,HQty,HPrice,HTaxPrice,HDiscountRate,HRelTaxPrice,HTaxRate,HTaxMoney" +
			",HlineTotal,HlineTotalBB,HMoney,HMoneyBB,HRemark" +
			",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
			",HPOOrderInterID,HPOOrderEntryID,HPOOrderBillNo" +
			",HSeOrderTaxPrice,HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo) " +
			" values(" +
			"" + omodel.HInterID + "" +
			"," + oSub.HEntryID + "" +
			",'" + omodel.HBillNo + "'" +
			"," + oSub.HMaterID + "" +
			"," + oSub.HUnitID + "" +
			"," + oSub.HQty + "" +
			"," + oSub.HPrice + "" +
			"," + oSub.HTaxPrice + "" +
			"," + oSub.HDiscountRate + "" +
			"," + oSub.HRelTaxPrice + "" +
			"," + oSub.HTaxRate + "" +
			"," + oSub.HTaxMoney + "" +
			"," + oSub.HlineTotal + "" +
			"," + oSub.HlineTotalBB + "" +
			"," + oSub.HMoney + "" +
			"," + oSub.HMoneyBB + "" +
			",'" + oSub.HRemark + "'" +
			"," + oSub.HSourceInterID + "" +
			"," + oSub.HSourceEntryID + "" +
			",'" + oSub.HSourceBillNo + "'" +
			",'" + oSub.HSourceBillType + "'" +
			"," + oSub.HRelationQty + "" +
			"," + oSub.HRelationMoney + "" +
			"," + oSub.HPOOrderInterID + "" +
			"," + oSub.HPOOrderEntryID + "" +
			",'" + oSub.HPOOrderBillNo + "'" +
			"," + oSub.HSeOrderTaxPrice + "" +
			"," + oSub.HSeOrderInterID + "" +
			"," + oSub.HSeOrderEntryID + "" +
			",'" + oSub.HSeOrderBillNo + "'" +
			")";
			oCn.RunProc(subSql);
			}
			//=========================ä¿ååæ§å¶
			DataSet ds2 = oCn.RunProcReturn("h_p_Cg_PayableBill_AfterSaveCtrl " + omodel.HInterID ,"h_p_Cg_PayableBill_AfterSaveCtrl");
			if (ds2 == null)
			{
			sReturn = "ä¿ååæ§å¶å¤æå¤±è´¥ï¼";
			oCn.RollBack();
			return false;
			}
			if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
			{
			sReturn = "ä¿åå¤±è´¥2ï¼" + DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBackRemark"]);
			oCn.RollBack();
			return false;
			}
			//============================

			sReturn = "ä¿®æ¹åæ®æåï¼";
			oCn.Commit();
			@@ -132,9 +257,22 @@
			{
			try
			{
			DataSet ds;
			//DataSet ds;


			//ä¿ååæ§å¶=========================================
			string HBillNote = "";
			DataSet ds = oCn.RunProcReturn("Exec h_p_Cg_PayableBill_BeforeSaveCtrl " + omodel.HInterID, "h_p_Cg_PayableBill_BeforeSaveCtrl");
			if (ds == null)
			{
			sReturn = "ä¿ååå¤æå¤±è´¥ï¼";
			return false;
			}
			if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
			{
			sReturn = "ä¿åå¤±è´¥ï¼" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
			return false;
			}
			//=========================================================
			oCn.BeginTran();

			//æ£æ¥ä¸»è¡¨åç æ¯å¦éå¤ï¼è¥éå¤åéæ°çæå¹¶ç»§ç»æ£æ¥ï¼ç´å°ä¸åéå¤
			@@ -150,6 +288,7 @@
			break;
			}
			}


			//æå¥ä¸»è¡¨
			string mainSql = "insert into Cg_PayableBillMain" +
			@@ -187,7 +326,7 @@
			oCn.RunProc(mainSql);

			//æå¥åè¡¨
			foreach (Model.ClsCg_PayableBillSub oSub in DetailColl)
			foreach (Model.ClsCg_PayableSub oSub in DetailColl)
			{
			string subSql = "insert into Cg_PayableSub" +
			"(HInterID,HEntryID,HBillNo_bak,HMaterID,HUnitID,HQty,HPrice,HTaxPrice,HDiscountRate,HRelTaxPrice,HTaxRate,HTaxMoney" +
			@@ -229,6 +368,66 @@
			")";
			oCn.RunProc(subSql);
			}
			//æå¥åè¡¨Entry
			foreach (Model.ClsCg_PayableSub oSub in DetailCol2)
			{
			string subSql = "insert into Cg_PayableSub_Entry" +
			"(HInterID,HEntryID,HBillNo_bak,HMaterID,HUnitID,HQty,HPrice,HTaxPrice,HDiscountRate,HRelTaxPrice,HTaxRate,HTaxMoney" +
			",HlineTotal,HlineTotalBB,HMoney,HMoneyBB,HRemark" +
			",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
			",HPOOrderInterID,HPOOrderEntryID,HPOOrderBillNo" +
			",HSeOrderTaxPrice,HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo) " +
			" values(" +
			"" + omodel.HInterID + "" +
			"," + oSub.HEntryID + "" +
			",'" + omodel.HBillNo + "'" +
			"," + oSub.HMaterID + "" +
			"," + oSub.HUnitID + "" +
			"," + oSub.HQty + "" +
			"," + oSub.HPrice + "" +
			"," + oSub.HTaxPrice + "" +
			"," + oSub.HDiscountRate + "" +
			"," + oSub.HRelTaxPrice + "" +
			"," + oSub.HTaxRate + "" +
			"," + oSub.HTaxMoney + "" +
			"," + oSub.HlineTotal + "" +
			"," + oSub.HlineTotalBB + "" +
			"," + oSub.HMoney + "" +
			"," + oSub.HMoneyBB + "" +
			",'" + oSub.HRemark + "'" +
			"," + oSub.HSourceInterID + "" +
			"," + oSub.HSourceEntryID + "" +
			",'" + oSub.HSourceBillNo + "'" +
			",'" + oSub.HSourceBillType + "'" +
			"," + oSub.HRelationQty + "" +
			"," + oSub.HRelationMoney + "" +
			"," + oSub.HPOOrderInterID + "" +
			"," + oSub.HPOOrderEntryID + "" +
			",'" + oSub.HPOOrderBillNo + "'" +
			"," + oSub.HSeOrderTaxPrice + "" +
			"," + oSub.HSeOrderInterID + "" +
			"," + oSub.HSeOrderEntryID + "" +
			",'" + oSub.HSeOrderBillNo + "'" +
			")";
			oCn.RunProc(subSql);
			}
			//æ´æ°è®¢åå³èæ°é
			AddNewRelation(ref sReturn, omodel.HInterID);
			//=========================ä¿ååæ§å¶
			DataSet ds2 = oCn.RunProcReturn("h_p_Cg_PayableBill_AfterSaveCtrl " + omodel.HInterID, "h_p_Cg_PayableBill_AfterSaveCtrl");
			if (ds2 == null)
			{
			sReturn = "ä¿ååæ§å¶å¤æå¤±è´¥ï¼";
			oCn.RollBack();
			return false;
			}
			if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
			{
			sReturn = "ä¿åå¤±è´¥2ï¼" + DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBackRemark"]);
			oCn.RollBack();
			return false;
			}
			//============================
			sReturn = "æ°å¢åæ®æåï¼";
			oCn.Commit();
			return true;
			@@ -318,7 +517,7 @@
			DetailColl.Clear();//æ¸ç©º
			for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++)
			{
			Model.ClsCg_PayableBillSub oSub = new Model.ClsCg_PayableBillSub();
			Model.ClsCg_PayableSub oSub = new Model.ClsCg_PayableSub();
			// åºå®èµå¼===============================================
			oSub.HInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HInterID"]);
			oSub.HEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HEntryID"]);
			@@ -361,6 +560,56 @@

			DetailColl.Add(oSub);
			}
			//åè¡¨Entry
			DataSet DsSub2;
			DsSub2 = oCn.RunProcReturn("select * from Cg_PayableSub_Entry where HInterID = " + lngBillKey.ToString() + "order by HEntryID", "Cg_PayableSub_Entry ");
			DetailCol2.Clear();//æ¸ç©º
			for (int i = 0; i < DsSub2.Tables[0].Rows.Count; i++)
			{
			Model.ClsCg_PayableSub oSub = new Model.ClsCg_PayableSub();
			// åºå®èµå¼===============================================
			oSub.HInterID = DBUtility.ClsPub.isLong(DsSub2.Tables[0].Rows[i]["HInterID"]);
			oSub.HEntryID = DBUtility.ClsPub.isLong(DsSub2.Tables[0].Rows[i]["HEntryID"]);
			oSub.HBillNo_bak = DBUtility.ClsPub.isStrNull(DsSub2.Tables[0].Rows[i]["HBillNo_bak"]);
			oSub.HCloseMan = DBUtility.ClsPub.isStrNull(DsSub2.Tables[0].Rows[i]["HCloseMan"]);
			oSub.HCloseType = DBUtility.ClsPub.isBool(DsSub2.Tables[0].Rows[i]["HCloseType"]);
			oSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DsSub2.Tables[0].Rows[i]["HEntryCloseDate"]);

			oSub.HSourceInterID = DBUtility.ClsPub.isLong(DsSub2.Tables[0].Rows[i]["HSourceInterID"]);
			oSub.HSourceEntryID = DBUtility.ClsPub.isLong(DsSub2.Tables[0].Rows[i]["HSourceEntryID"]);
			oSub.HSourceBillType = DsSub2.Tables[0].Rows[i]["HSourceBillType"].ToString().Trim();
			oSub.HSourceBillNo = DsSub2.Tables[0].Rows[i]["HSourceBillNo"].ToString().Trim();
			oSub.HRelationQty = DBUtility.ClsPub.isDoule(DsSub2.Tables[0].Rows[i]["HRelationQty"]);
			oSub.HRelationMoney = DBUtility.ClsPub.isDoule(DsSub2.Tables[0].Rows[i]["HRelationMoney"]);

			oSub.HRemark = DsSub2.Tables[0].Rows[i]["HRemark"].ToString().Trim();
			//===================================================
			oSub.HMaterID = DBUtility.ClsPub.isLong(DsSub2.Tables[0].Rows[i]["HMaterID"]);
			oSub.HUnitID = DBUtility.ClsPub.isLong(DsSub2.Tables[0].Rows[i]["HUnitID"]);
			oSub.HQty = DBUtility.ClsPub.isDoule(DsSub2.Tables[0].Rows[0]["HQty"]);
			oSub.HPrice = DBUtility.ClsPub.isDoule(DsSub2.Tables[0].Rows[0]["HPrice"]);
			oSub.HTaxPrice = DBUtility.ClsPub.isDoule(DsSub2.Tables[0].Rows[0]["HTaxPrice"]);
			oSub.HDiscountRate = DBUtility.ClsPub.isDoule(DsSub2.Tables[0].Rows[0]["HDiscountRate"]);
			oSub.HRelTaxPrice = DBUtility.ClsPub.isDoule(DsSub2.Tables[0].Rows[0]["HRelTaxPrice"]);
			oSub.HTaxRate = DBUtility.ClsPub.isDoule(DsSub2.Tables[0].Rows[0]["HTaxRate"]);
			oSub.HTaxMoney = DBUtility.ClsPub.isDoule(DsSub2.Tables[0].Rows[0]["HTaxMoney"]);
			oSub.HMoney = DBUtility.ClsPub.isDoule(DsSub2.Tables[0].Rows[0]["HMoney"]);
			oSub.HMoneyBB = DBUtility.ClsPub.isDoule(DsSub2.Tables[0].Rows[0]["HMoneyBB"]);
			oSub.HlineTotal = DBUtility.ClsPub.isDoule(DsSub2.Tables[0].Rows[0]["HlineTotal"]);
			oSub.HlineTotalBB = DBUtility.ClsPub.isDoule(DsSub2.Tables[0].Rows[0]["HlineTotalBB"]);

			oSub.HPOOrderInterID = DBUtility.ClsPub.isLong(DsSub2.Tables[0].Rows[0]["HPOOrderInterID"]);
			oSub.HPOOrderEntryID = DBUtility.ClsPub.isLong(DsSub2.Tables[0].Rows[0]["HPOOrderEntryID"]);
			oSub.HPOOrderBillNo = DBUtility.ClsPub.isStrNull(DsSub2.Tables[0].Rows[0]["HPOOrderBillNo"]);

			oSub.HSeOrderTaxPrice = DBUtility.ClsPub.isDoule(DsSub2.Tables[0].Rows[0]["HSeOrderTaxPrice"]);
			oSub.HSeOrderInterID = DBUtility.ClsPub.isLong(DsSub2.Tables[0].Rows[0]["HSeOrderInterID"]);
			oSub.HSeOrderEntryID = DBUtility.ClsPub.isLong(DsSub2.Tables[0].Rows[0]["HSeOrderEntryID"]);
			oSub.HSeOrderBillNo = DBUtility.ClsPub.isStrNull(DsSub2.Tables[0].Rows[0]["HSeOrderBillNo"]);

			DetailCol2.Add(oSub);
			}

			sReturn = "æ¾ç¤ºåæ®æåï¼";
			return true;
			}