/// <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
}
