public DataTable QueryError(ArrayList ParameterList) { #region DataTable dt_Return = new DataTable(); try { VAM23_DBO DBO = new VAM23_DBO(ref USEDB); return DBO.QueryError(ParameterList); } catch (System.Exception ex) { throw ex; } #endregion }
public string[] Query_SALES_ITEM_7NET(ArrayList ParameterList, DbTransaction RootDBT) { bool IsRootTranscation = false; string[] strReturn = new string[2]; strReturn[0] = ""; strReturn[1] = ""; try { VAM23_DBO DBO = new VAM23_DBO(ref USEDB); //判斷是否有傳入Root Transcation IsRootTranscation = (RootDBT == null) ? true : false; #region 啟動交易或指定RootTranscation if (IsRootTranscation) { //獨立呼叫啟動Transcation Conn = USEDB.CreateConnection(); Conn.Open(); DBT = Conn.BeginTransaction(); } else { DBT = RootDBT; } #endregion strReturn = DBO.Query_SALES_ITEM_7NET(ParameterList, DBT); if (IsRootTranscation) { DBT.Commit(); } return strReturn; } catch (Exception ex) { #region 交易失敗 DBT.Rollback(); #endregion throw ex; } finally { #region 判斷是否關閉交易連線 if (IsRootTranscation) { //獨立呼叫Transcation,關閉連線 if (Conn.State == ConnectionState.Connecting) { Conn.Close(); } } #endregion } }
public string[] Insert7net(DataTable dt, DbTransaction RootDBT) { bool IsRootTranscation = false; string[] strReturn = new string[2]; strReturn[0] = ""; strReturn[1] = ""; try { VAM23_DBO DBO = new VAM23_DBO(ref USEDB); //判斷是否有傳入Root Transcation IsRootTranscation = (RootDBT == null) ? true : false; #region 啟動交易或指定RootTranscation if (IsRootTranscation) { //獨立呼叫啟動Transcation Conn = USEDB.CreateConnection(); Conn.Open(); DBT = Conn.BeginTransaction(); } else { DBT = RootDBT; } #endregion ArrayList ParameterList = new ArrayList(); string strSALES_MONTH = ""; string strUSERID = ""; int iRowNumber = 0; foreach (DataRow dr in dt.Rows) { iRowNumber += 1; strSALES_MONTH = dr["SALES_MONTH"].ToString(); strUSERID = dr["USERID"].ToString(); ParameterList.Clear(); if (iRowNumber == 1) { ParameterList.Add("Y"); } else { ParameterList.Add("N"); } ParameterList.Add(int.Parse(dr["ROW_ID"].ToString())); ParameterList.Add(dr["BATCH_NO"].ToString()); ParameterList.Add(dr["SALES_MONTH"].ToString()); ParameterList.Add(dr["VENDOR"].ToString()); if (dr["DELIV_DATE"].ToString() != "") { ParameterList.Add(DateTime.ParseExact(DateTime.Parse(dr["DELIV_DATE"].ToString()).ToString("yyyy/MM/dd"), "yyyy/MM/dd", null)); } else { ParameterList.Add(System.DBNull.Value); } ParameterList.Add(DateTime.ParseExact(DateTime.Parse(dr["SALES_DATE"].ToString()).ToString("yyyy/MM/dd"), "yyyy/MM/dd", null)); ParameterList.Add(dr["STAKIND"].ToString()); ParameterList.Add(dr["CHAN_SOURCE_NO"].ToString()); ParameterList.Add(dr["ITEM_NO"].ToString()); ParameterList.Add(dr["ITEM_MAP"].ToString()); ParameterList.Add(dr["BARCODE"].ToString()); ParameterList.Add(int.Parse(dr["SALES_QTY"].ToString())); if (dr["TAX_TYPE"].ToString() != "") { ParameterList.Add(int.Parse(dr["TAX_TYPE"].ToString())); } else { ParameterList.Add(System.DBNull.Value); } ParameterList.Add(dr["USERID"].ToString()); strReturn = DBO.InsertVdsVamSalesItem7net(ParameterList, DBT); } if (strReturn[0] == "1") { ParameterList.Clear(); ParameterList.Add("N"); ParameterList.Add("VAM23"); ParameterList.Add(strSALES_MONTH); ParameterList.Add(strUSERID); strReturn = CreateVdsVamSalesItemFor7net(ParameterList, DBT); } else { strReturn[0] = "2"; strReturn[1] = "匯入資料到暫存檔錯誤,請洽系統管理人員"; } if (IsRootTranscation) { DBT.Commit(); } return strReturn; } catch (Exception ex) { #region 交易失敗 DBT.Rollback(); #endregion throw ex; } finally { #region 判斷是否關閉交易連線 if (IsRootTranscation) { //獨立呼叫Transcation,關閉連線 if (Conn.State == ConnectionState.Connecting) { Conn.Close(); } } #endregion } }