public bool CheckPurItemIsOnWay(string sPurNo, string sItemNo, string sPeriod)
{
try
{
DBO.OUT_PurchaseOrderDBO dbo = new OUT_PurchaseOrderDBO(ref USEDB);
int iCount = dbo.CheckPurItemIsOnWay(sPurNo, sItemNo, sPeriod);
if (iCount == 0)
{ return false; }
else
{ return true; }
}
catch (Exception ex)
{
throw ex;
}
}
public bool CheckPurchaseIsACCEPT(string sPurNo)
{
try
{
DBO.OUT_PurchaseOrderDBO dbo = new OUT_PurchaseOrderDBO(ref USEDB);
int iCount = dbo.CheckPurchaseIsACCEPT(sPurNo);
if (iCount == 0)
{ return false; }
else
{ return true; }
}
catch (Exception ex)
{
throw ex;
}
}
public int Check_DC_Date(ArrayList ParameterList)
{
try
{
DBO.OUT_PurchaseOrderDBO dbo = new OUT_PurchaseOrderDBO(ref USEDB);
return dbo.doCheck_DC_Date(ParameterList);
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable GetVendorDataByVendorNo(ArrayList ParameterList)
{
try
{
DBO.OUT_PurchaseOrderDBO dbo = new OUT_PurchaseOrderDBO(ref USEDB);
return dbo.GetVendorData(ParameterList);
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable GetTempErrorDataByfind(ArrayList ParameterList)
{
try
{
DBO.OUT_PurchaseOrderDBO dbo = new OUT_PurchaseOrderDBO(ref USEDB);
return dbo.GetTempErrorDataByFind1(ParameterList);
}
catch (Exception ex)
{
throw ex;
}
}
public string GetOrderDocumentIDAndCode()
{
try
{
DBO.OUT_PurchaseOrderDBO dbo = new OUT_PurchaseOrderDBO(ref USEDB);
return dbo.GetOrderDocumentIDAndCode();
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable GetItemsByPurchase_No(ArrayList ParameterList)
{
try
{
DBO.OUT_PurchaseOrderDBO dbo = new OUT_PurchaseOrderDBO(ref USEDB);
return dbo.GetItemsByPUR_No(ParameterList);
}
catch (Exception ex)
{
throw ex;
}
}
public string GetDetail_Data(ArrayList ParameterList)
{
try
{
DBO.OUT_PurchaseOrderDBO dbo = new OUT_PurchaseOrderDBO(ref USEDB);
return dbo.doGetDetailData(ParameterList);
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable QueryPrintPurchaseOrderDetail(ArrayList ParameterList)
{
try
{
DBO.OUT_PurchaseOrderDBO dbo = new OUT_PurchaseOrderDBO(ref USEDB);
return dbo.PrintPurchaseOrderDetail(ParameterList);
}
catch (Exception ex)
{
throw ex;
}
}
/// <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
}
/// <summary>
/// ��s VDS_MKT_PURCARD_MAIN.PUR_NO ����sBCO
/// </summary>
/// <param name="sPurchaseNo">���ʳ渹</param>
/// <param name="sItem">�~��</param>
/// <param name="sPeriod">���O</param>
/// <param name="RootDBT">�O�_���D���,�L�D�����Jnull</param>
/// <returns>�^�Ǧ��\�P�_</returns>
public bool Update_PURCARD(string sPurchaseNo, string sItem, string sPeriod, string UpdateID, DbTransaction RootDBT)
{
bool IsRootTranscation = false;
bool bResult = false;
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
DBO.OUT_PurchaseOrderDBO dbo = new OUT_PurchaseOrderDBO(ref USEDB);
dbo.doUpdatePurCard(sPurchaseNo, sItem, sPeriod, UpdateID, DBT);
#region ������\
if (IsRootTranscation)
{
//�W�ߩI�sTranscation����
DBT.Commit();
}
#endregion
bResult = true;
return bResult;
}
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
}
}
/// <summary>
/// Master ����sBCO
/// </summary>
/// <param name="ParameterList">��s�ܼ�</param>
/// <param name="RootDBT">�O�_���D���,�L�D�����Jnull</param>
/// <returns>�^�Ǧ��\�P�_</returns>
public bool UpdatePUR_Master(ArrayList ParameterList,
DbTransaction RootDBT,
DataTable oldMaster)
{
bool IsRootTranscation = false;
bool bResult = false;
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
DBO.OUT_PurchaseOrderDBO dbo = new OUT_PurchaseOrderDBO(ref USEDB);
dbo.doUpdateMaster(ParameterList, oldMaster.Rows[0], DBT);
#region ������\
if (IsRootTranscation)
{
//�W�ߩI�sTranscation����
DBT.Commit();
}
#endregion
bResult = true;
return bResult;
}
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
}
}
public DataTable QuerySwitch(QueryType QT,
ArrayList ParameterList
)
{
DBO.OUT_PurchaseOrderDBO dbo = new OUT_PurchaseOrderDBO(ref USEDB);
DataTable Dt;
try
{
switch (QT)
{
//case QueryType.ALL:
// Dt = dbo.doQueryAll();
// break;
//case QueryType.CODE:
// Dt = dbo.doQueryByCode(ParameterList);
// break;
case QueryType.ID:
Dt = dbo.GetMasterByPK(ParameterList);
break;
case QueryType.Custom:
Dt = dbo.GetMainByWhere1(ParameterList);
break;
default:
Dt = new DataTable();
break;
}
return Dt;
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// ��Master table �����װʧ@
/// </summary>
/// <param name="ParMasterList">��s�ܼ�</param>
/// <param name="RootDBT">�O�_���D���,�L�D�����Jnull</param>
/// <returns>�^�Ǽv�T����</returns>
public void ClosePurchaseOrder(ArrayList ParMasterList,
DataRow OldMasterRow,
DbTransaction RootDBT
)
{
bool IsRootTranscation = false;
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
DBO.OUT_PurchaseOrderDBO dbo = new OUT_PurchaseOrderDBO(ref USEDB);
dbo.doClosePurchaseOrder(ParMasterList, OldMasterRow, DBT);
ArrayList Para = new ArrayList();
Para.Clear();
Para.Add(OldMasterRow["PURCHASE_NO"].ToString().Trim());
Para.Add("M");
Para.Add(ParMasterList[0].ToString());
dbo.doCloseCaseDetailByPurNo(Para, DBT);
#region ������\
if (IsRootTranscation)
{
//�W�ߩI�sTranscation����
DBT.Commit();
}
#endregion
}
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
}
}
//public DataTable QueryPurchaseOrderByALL()
//{
// try
// {
// DBO.OUT_PurchaseOrderDBO dbo = new OUT_PurchaseOrderDBO(ref USEDB);
// return dbo.doQueryAll();
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
//public DataTable QueryPurchaseOrderByCode(ArrayList ParameterList)
//{
// try
// {
// DBO.OUT_PurchaseOrderDBO dbo = new OUT_PurchaseOrderDBO(ref USEDB);
// return dbo.doQueryByCode(ParameterList);
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
public DataTable QueryPurchaseOrderByLike(ArrayList ParameterList)
{
try
{
DBO.OUT_PurchaseOrderDBO dbo = new OUT_PurchaseOrderDBO(ref USEDB);
return dbo.doQueryByLIKE(ParameterList);
}
catch (Exception ex)
{
throw ex;
}
}
public int Get_AcceptQty(ArrayList ParameterList)
{
try
{
DBO.OUT_PurchaseOrderDBO dbo = new OUT_PurchaseOrderDBO(ref USEDB);
return dbo.doGet_AcceptQty(ParameterList);
}
catch (Exception ex)
{
throw ex;
}
}
public void OpenPurchaseOrderDetail(ArrayList ParameterList, DbTransaction RootDBT)
{
bool IsRootTranscation = false;
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
DBO.OUT_PurchaseOrderDBO dbo = new OUT_PurchaseOrderDBO(ref USEDB);
dbo.doOpenPurchaseOrderDetail(ParameterList, DBT);
#region ������\
if (IsRootTranscation)
{
//�W�ߩI�sTranscation����
DBT.Commit();
}
#endregion
}
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
}
}
public DataTable QueryItemSchema()
{
try
{
DBO.OUT_PurchaseOrderDBO dbo = new OUT_PurchaseOrderDBO(ref USEDB);
return dbo.doQueryItemSchema();
}
catch (Exception ex)
{
throw ex;
}
}