/// <summary> /// ���s�WBCO /// </summary> /// <param name="ParameterList">��J�ܼ�</param> /// <param name="RootDBT">�O�_���D���,�L�D�����Jnull</param> /// <returns>�^�Ƿs�W��ID</returns> public string CreateMasterAndDetail_Gift(ArrayList ParameterList, DataTable DetailData, DataTable GiftData, DbTransaction RootDBT) { #region bool IsRootTranscation = false; Int32 PID = 0; string[] sID_NO; string sTemp = ""; string sPurchaseNo = ""; try { //�P�_�O�_���ǤJRoot Transcation IsRootTranscation = (RootDBT == null) ? true : false; #region �Ұʥ���Ϋ��wRootTranscation if (IsRootTranscation) { //�W�ߩI�s�Ұ�Transcation Conn = USEDB.CreateConnection(); Conn.Open(); DBT = Conn.BeginTransaction(); } else { DBT = RootDBT; } #endregion //�g�J Master Table sTemp = CreatePurchaseOrder(ParameterList, DBT); sID_NO = sTemp.Split(new Char[] { ';' }); PID = int.Parse(sID_NO[0].ToString()); sPurchaseNo = sID_NO[1].ToString(); //�NParameterList���s��D��ID�PPURCHASRE_NO���ȡA����PID�PsPurchaseNo ParameterList[5] = sPurchaseNo; ParameterList[6] = PID; if (PID != 0) { #region �s�W���Ӹ�ƻP��s VDS_MKT_PURCARD_MAIN.PUR_NO(���x���ʥd) �� VDS_MKT_BPURCARD_MAIN.PUR_NO(�Ϯѱ��ʥd) foreach (DataRow dRow in DetailData.Rows) { CreatePurchaseOrderDetail(PID, ParameterList, dRow, DBT); //��s���O�ݩ���(VDS_ITM_PERIOD_PROFILE)��,�ӫ~�����O����f����B���ʤ�B���ʶq�P���ʳ渹 UpdatePeriodProfile(dRow["ITEM"].ToString().Trim(), dRow["PERIOD"].ToString().Trim(), dRow["PLAN_ACCEPT_DATE"].ToString().Trim(), ParameterList[0].ToString().Trim(), dRow["PURCHASE_QTY"].ToString().Trim(), sPurchaseNo, ParameterList[4].ToString().Trim(), DBT); //��s�Ϯѱ��ʥd�����x���ʥd���ʳ渹 if (dRow["PERIOD"].ToString().Trim() == "000000") //�b�ϮѸ̨�period�ȵ���O000000 { Update_B_PURCARD(sPurchaseNo, dRow["ITEM"].ToString().Trim(), ParameterList[4].ToString().Trim(), DBT); } else { Update_PURCARD(sPurchaseNo, dRow["ITEM"].ToString().Trim(), dRow["PERIOD"].ToString().Trim(), ParameterList[4].ToString().Trim(), DBT); } } #endregion #region �s�W�����ث~��� if (GiftData != null) { foreach (DataRow gRow in GiftData.Rows) { CreatePurchaseOrderDetail(PID, ParameterList, gRow, DBT); //��s�ث~�ݩ���(VDS_MKT_GIFT_PROFILE)��Ƥ�,�ӫ~�����O����f����B���ʤ�B���ʶq�P���ʳ渹 UpdateGiftProfile(gRow["ITEM"].ToString().Trim(), gRow["PERIOD"].ToString().Trim(), gRow["VIRTUAL_CODE"].ToString().Trim(), gRow["PLAN_ACCEPT_DATE"].ToString().Trim(), ParameterList[0].ToString().Trim(), gRow["PURCHASE_QTY"].ToString().Trim(), sPurchaseNo, ParameterList[4].ToString().Trim(), DBT); } } #endregion #region ������\ if (IsRootTranscation) { //�W�ߩI�sTranscation���� DBT.Commit(); } #endregion DBO.OUT_PurchaseOrderDBO dbo = new OUT_PurchaseOrderDBO(ref USEDB); sPurchaseNo = dbo.doQueryPurchase_NotByID(PID.ToString()); } else { throw new Exception("�s�W0�����!"); } return sPurchaseNo; } catch (Exception ex) { #region ������� if (IsRootTranscation) { //�W�ߩI�sTranscation���� DBT.Rollback(); } #endregion throw ex; } finally { #region �P�_�O�_��������s�u if (IsRootTranscation) { //�W�ߩI�sTranscation,�����s�u if (Conn.State == ConnectionState.Connecting) { Conn.Close(); } } #endregion } #endregion }