public DataTable QueryDiscountSource(ArrayList ParameterList)
{
try
{
DBO.VAM17_DBO dbo = new VAM17_DBO(ref USEDB);
return dbo.doQueryDiscountSource(ParameterList);
}
catch (Exception ex)
{
throw ex;
}
}
public void CreateDiscountInvoice(ArrayList ParameterList, DataTable dtA, DataTable dtB, out string V_DISC_NO)
{
try
{
DBO.VAM17_DBO dbo = new VAM17_DBO(ref USEDB);
//獨立呼叫啟動Transcation
Conn = USEDB.CreateConnection();
Conn.Open();
DBT = Conn.BeginTransaction();
int N_ID = 0;
int N_ID1 = 0;
//做折讓主檔新增
dbo.doInsertDiscountMain(ParameterList, out N_ID, out V_DISC_NO, DBT);
//做折讓明細檔新增
ArrayList Parameter_Det = new ArrayList();
if (dtA != null)
{
for (int i = 0; i < dtA.Rows.Count; i++)
{
Parameter_Det.Clear();
Parameter_Det.Add(N_ID); //N_PID
Parameter_Det.Add(V_DISC_NO); //V_DISC_NO
Parameter_Det.Add(ParameterList[1]); //V_TAX_TYPE
Parameter_Det.Add(GetValueSetParameter(dtA.Rows[i]["PROMOTE_ID"].ToString(), "string", false)); //V_SOURCE_NO
Parameter_Det.Add(GetValueSetParameter(dtA.Rows[i]["AMT"].ToString(), "float", false)); //N_AMT
Parameter_Det.Add(ParameterList[6]); //D_UPDATEDATE
Parameter_Det.Add(ParameterList[7]); //V_UPDATEUID
Parameter_Det.Add(ParameterList[8]); //D_CREATEDATE
Parameter_Det.Add(ParameterList[9]); //V_CREATEUID
Parameter_Det.Add(ParameterList[2]); //V_VENDOR
dbo.doInsertDiscountDetl(Parameter_Det, DBT);
}
}
//做發票折讓明細檔新增
if (dtB != null)
{
for (int i = 0; i < dtB.Rows.Count; i++)
{
Parameter_Det.Clear();
Parameter_Det.Add(V_DISC_NO); //V_DISC_NO
Parameter_Det.Add(GetValueSetParameter(dtB.Rows[i]["INV_NO"].ToString(), "string", false)); //V_INV_NO
Parameter_Det.Add(GetValueSetParameter(dtB.Rows[i]["DISC_AMT"].ToString(), "float", false)); //N_DISC_AMT
Parameter_Det.Add(ParameterList[7]); //V_UPDATEUID
Parameter_Det.Add(ParameterList[6]); //D_UPDATEDATE
Parameter_Det.Add(ParameterList[9]); //V_CREATEUID
Parameter_Det.Add(ParameterList[8]); //D_CREATEDATE
dbo.doInsertDiscountInvoice(Parameter_Det, DBT);
}
}
//獨立呼叫Transcation成立
DBT.Commit();
}
catch (Exception ex)
{
if (DBT != null)
DBT.Rollback();
throw ex;
}
finally
{
//獨立呼叫Transcation,關閉連線
if (Conn.State == ConnectionState.Connecting)
{
Conn.Close();
}
}
}
//查詢發票明細檔資料
public DataTable QueryInvoiceDetl(string V_VANDOR, string V_INV_NO)
{
try
{
DBO.VAM17_DBO dbo = new VAM17_DBO(ref USEDB);
return dbo.doQueryPurchaseInvoiceInfo(V_VANDOR, V_INV_NO);
}
catch (Exception ex)
{
throw ex;
}
}
//查詢進退貨折讓明細檔
public DataTable ViewDiscountDetl(string V_DISC_NO)
{
try
{
DBO.VAM17_DBO dbo = new VAM17_DBO(ref USEDB);
return dbo.doViewDiscountDetl(V_DISC_NO);
}
catch (Exception ex)
{
throw ex;
}
}
public void DeleteDiscountInvoice(ArrayList ParameterList1, DbTransaction RootDBT)
{
try
{
DBO.VAM17_DBO dbo = new VAM17_DBO(ref USEDB);
Conn = USEDB.CreateConnection();
Conn.Open();
DBT = Conn.BeginTransaction();
//先刪除原發票資料
dbo.doDeleteDiscountInvoice(ParameterList1, DBT);
DBT.Commit();
}
catch (Exception ex)
{
if (DBT != null)
DBT.Rollback();
throw ex;
}
finally
{
//獨立呼叫Transcation,關閉連線
if (Conn.State == ConnectionState.Connecting)
{
Conn.Close();
}
}
}
//查詢稅率
public void QueryTaxRate(out decimal N_TAX_RATE)
{
try
{
DBO.VAM17_DBO dbo = new VAM17_DBO(ref USEDB);
dbo.doGetTaxRate(out N_TAX_RATE);
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable QueryDiscountInv(string V_DISC_NO)
{
try
{
DBO.VAM17_DBO dbo = new VAM17_DBO(ref USEDB);
return dbo.doQueryDiscountInv(V_DISC_NO);
}
catch (Exception ex)
{
throw ex;
}
}