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