public DataTable QueryTransDetl(ArrayList ParameterList) { VDS_IVM14_DBO dbo = new VDS_IVM14_DBO(ref USEDB); DataTable dtResult; try { dtResult = dbo.QueryTransDetl(ParameterList); return dtResult; } catch (Exception ex) { throw ex; } }
public void GetExceptionData(out string strChanNo, out string strStore, out string strSupplier) { strChanNo = string.Empty; strStore = string.Empty; strSupplier = string.Empty; try { VDS_IVM14_DBO dbo = new VDS_IVM14_DBO(ref USEDB); dbo.GetExceptionData(out strChanNo, out strStore, out strSupplier); } catch (Exception ex) { throw ex; } }
public void CheckTransOutItem(ArrayList ParameterList, out string strErr_No, out string strType, out string strItem_Map, out double List_Price, out string strMsg) { strErr_No = string.Empty; strType = string.Empty; strItem_Map = string.Empty; strMsg = string.Empty; List_Price = 0; try { VDS_IVM14_DBO dbo = new VDS_IVM14_DBO(ref USEDB); dbo.CheckTransOutItem(ParameterList, out strErr_No, out strType, out strItem_Map, out List_Price, out strMsg); } catch (Exception ex) { throw ex; } }
public void DeleteTransData(ArrayList ParameterList, DbTransaction RootDBT, out string strResult) { bool IsRootTranscation = false; VDS_IVM14_DBO dbo = new VDS_IVM14_DBO(ref USEDB); try { //判斷是否有傳入Root Transcation IsRootTranscation = (RootDBT == null) ? true : false; #region 啟動交易或指定RootTranscation if (IsRootTranscation) { //獨立呼叫啟動Transcation Conn = USEDB.CreateConnection(); Conn.Open(); DBT = Conn.BeginTransaction(); } else { DBT = RootDBT; } #endregion dbo.DeleteTransData(ParameterList, DBT, out strResult); #region 交易成功 if (IsRootTranscation) { //獨立呼叫Transcation成立 DBT.Commit(); } #endregion } catch (Exception ex) { #region 交易失敗 if (IsRootTranscation) { //獨立呼叫Transcation失敗 DBT.Rollback(); } #endregion throw ex; } finally { #region 判斷是否關閉交易連線 if (IsRootTranscation) { //獨立呼叫Transcation,關閉連線 if (Conn.State == ConnectionState.Connecting) { Conn.Close(); } } #endregion } }
public void CreateTransIn(ArrayList parameterList, DbTransaction RootDBT,out int intID,out string strTransNo,out string strMsg,out string strResult) { bool IsRootTranscation = false; DBO.VDS_IVM14_DBO IVMM = new VDS_IVM14_DBO(ref USEDB); try { //判斷是否有傳入Root Transcation IsRootTranscation = (RootDBT == null) ? true : false; #region 啟動交易或指定RootTranscation if (IsRootTranscation) { //獨立呼叫啟動Transcation Conn = USEDB.CreateConnection(); Conn.Open(); DBT = Conn.BeginTransaction(); } else { DBT = RootDBT; } #endregion IVMM.CreateTransIn(parameterList, DBT, out intID, out strTransNo, out strMsg, out strResult); if (strResult == "0") { throw new Exception(strMsg); } #region 交易成功 if (IsRootTranscation) { //獨立呼叫Transcation成立 DBT.Commit(); } #endregion } catch (Exception ex) { #region 交易失敗 if (IsRootTranscation) { //獨立呼叫Transcation失敗 DBT.Rollback(); } #endregion throw ex; } finally { #region 判斷是否關閉交易連線 if (IsRootTranscation) { //獨立呼叫Transcation,關閉連線 if (Conn.State == ConnectionState.Connecting) { Conn.Close(); } } #endregion } }
public void CreateTransferOut(ArrayList parameterList, DataTable Dt_Detail, DbTransaction RootDBT,out string strTrans_No) { bool IsRootTranscation = false; DBO.VDS_IVM14_DBO IVMM = new VDS_IVM14_DBO(ref USEDB); try { //判斷是否有傳入Root Transcation IsRootTranscation = (RootDBT == null) ? true : false; #region 啟動交易或指定RootTranscation if (IsRootTranscation) { //獨立呼叫啟動Transcation Conn = USEDB.CreateConnection(); Conn.Open(); DBT = Conn.BeginTransaction(); } else { DBT = RootDBT; } #endregion int intID = 0; string strMsg = string.Empty; string strResult = string.Empty; ArrayList alDetail = new ArrayList(); strTrans_No = string.Empty; //新增主檔 IVMM.CreateTransOutMain(parameterList, DBT, out intID, out strTrans_No); for (int i = 0; i < Dt_Detail.Rows.Count; i++) { alDetail.Clear(); alDetail.Add(intID); //0 N_PID alDetail.Add(parameterList[0]); //1 V_SUPPLIER alDetail.Add(parameterList[1]); //2 V_CHAN_NO alDetail.Add(parameterList[2]); //3 V_STORE alDetail.Add(Dt_Detail.Rows[i]["ITEM"].ToString()); //4 V_ITEM alDetail.Add(Dt_Detail.Rows[i]["PERIOD"].ToString()); //5 V_PERIOD alDetail.Add(Dt_Detail.Rows[i]["TRANS_QTY"].ToString()); //6 N_TRANS_QTY alDetail.Add(parameterList[5]); //7 V_CREATEUID alDetail.Add(parameterList[6]); //8 D_CREATEDATE alDetail.Add(parameterList[7]); //9 V_UPDATEUID alDetail.Add(parameterList[8]); //10 D_UPDATEDATE //新增明細檔 IVMM.CreateTransOutDetl(alDetail, DBT, out strMsg, out strResult); if (strResult == "0") { throw new Exception(strMsg); } } alDetail.Clear(); alDetail.Add(parameterList[0]);//SUPPLIER alDetail.Add(strTrans_No); alDetail.Add(parameterList[4]);//LOCATE_SECTION alDetail.Add(parameterList[5]);//CREATEUID IVMM.GenDocByTransOutNO(alDetail, DBT, out strMsg, out strResult); if (strResult == "0") { throw new Exception(strMsg); } #region 交易成功 if (IsRootTranscation) { //獨立呼叫Transcation成立 DBT.Commit(); } #endregion } catch (Exception ex) { #region 交易失敗 if (IsRootTranscation) { //獨立呼叫Transcation失敗 DBT.Rollback(); } #endregion throw ex; } finally { #region 判斷是否關閉交易連線 if (IsRootTranscation) { //獨立呼叫Transcation,關閉連線 if (Conn.State == ConnectionState.Connecting) { Conn.Close(); } } #endregion } }
public DataTable GetItemByBarCode(ArrayList ParameterList) { VDS_IVM14_DBO dbo = new VDS_IVM14_DBO(ref USEDB); DataTable dtResult; try { dtResult = dbo.GetItemByBarCode(ParameterList); return dtResult; } catch (Exception ex) { throw ex; } }
public DataTable GetSourceData(ArrayList ParameterList, out int intTotal_Cnt, out int intNomal_Cnt, out int intErr_Cnt, out int intTotal_Trans_Qty) { VDS_IVM14_DBO dbo = new VDS_IVM14_DBO(ref USEDB); DataTable dtResult; try { dtResult = dbo.GetSourceData(ParameterList,out intTotal_Cnt,out intNomal_Cnt,out intErr_Cnt,out intTotal_Trans_Qty); return dtResult; } catch (Exception ex) { throw ex; } }