public DataTable QuerySwitch(QueryType QT, ArrayList ParameterList ) { DBO.OUT03_SKUDBO dbo = new OUT03_SKUDBO(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.doQueryByID(ParameterList); break; case QueryType.Custom: Dt = dbo.doQueryByFind(ParameterList); break; default: Dt = new DataTable(); break; } return Dt; } catch (Exception ex) { throw ex; } }
public DataTable QuerySKUByALL() { try { DBO.OUT03_SKUDBO dbo = new OUT03_SKUDBO(ref USEDB); return dbo.doQueryAll(); } catch (Exception ex) { throw ex; } }
public string StoreName(string Code ) { string Name = ""; string ConnectionDBStr = ((DatabaseSettings)ConfigurationManager.GetSection("dataConfiguration")).DefaultDatabase; OUT03_SKUDBO BCO = new OUT03_SKUDBO(ConnectionDBStr); if (Code != "") { ArrayList ParameterList = new ArrayList(); ParameterList.Clear(); ParameterList.Add(Code); // STORE ParameterList.Add(Code); // STORE ParameterList.Add(""); // STORE_NAME ParameterList.Add(""); // MDC_START_DATE ParameterList.Add(""); // MDC_START_DATE ParameterList.Add(""); // MDC_END_DATE ParameterList.Add(""); // MDC_END_DATE ParameterList.Add("1"); // ROW NUmber DataTable Dt = BCO.QueryByLikeForSLP(ParameterList); if (Dt.Rows.Count > 0) { Name = Dt.Rows[0]["STORE_NAME"].ToString().Trim(); } else { Name = "查無資料"; } } return Name; }
/// <summary> /// 查詢資料庫取得資料 /// </summary> private void databind() { //抓取本頁初次登記的時間 string SessionIDName = "STM_STORE_" + PageTimeStamp.Value; OUT03_SKUDBO BCO = new OUT03_SKUDBO(ConntionDB); ParameterList.Clear(); ParameterList.Add(SLP_STORE_ST.Text.Trim()); ParameterList.Add(SLP_STORE_ED.Text.Trim()); ParameterList.Add(txtStore.Text.Trim() + "%"); ParameterList.Add(SLP_MDC_START_DATE.StartDate.Trim()); ParameterList.Add(SLP_MDC_START_DATE.EndDate.Trim()); ParameterList.Add(SLP_MDC_END_DATE.StartDate.Trim()); ParameterList.Add(SLP_MDC_END_DATE.EndDate.Trim()); ParameterList.Add(TextBoxRowCountLimit.Text.Trim()); DataTable Dt = BCO.QueryByLikeForSLP(ParameterList); Session[SessionIDName] = Dt; GridView1.DataSource = Dt; //設定分頁大小 if (TextBoxPagesize.Text == "0") { GridView1.PageSize = 1; } else { GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text); } GridView1.PageIndex = 0; GridView1.DataBind(); GridView1.SelectedIndex = -1; }
}//Initiziatoin_Component private void dataget() { if (_Code != "") { OUT03_SKUDBO BCO = new OUT03_SKUDBO(ConntionDB); DataTable Dt = BCO.QueryByLikeForSLP(ParameterList); if (Dt.Rows.Count > 0) { _Name = Dt.Rows[0]["STORE_NAME"].ToString().Trim(); } else { _Name = "查無資料"; } } HiddenField1.Value = _Name; TextBoxName.Text = _Name; }//dataget
public DataTable QuerySKUByID(ArrayList ParameterList) { try { DBO.OUT03_SKUDBO dbo = new OUT03_SKUDBO(ref USEDB); return dbo.doQueryByID(ParameterList); } catch (Exception ex) { throw ex; } }
/// <summary> /// 測試SP交易失敗 /// </summary> /// <param name="ParameterList">變數</param> /// <param name="RootDBT">是否有主交易,無主交易輸入null</param> public void TestTranscation(ArrayList ParameterList1, ArrayList ParameterList2, ArrayList ParameterList3, DbTransaction RootDBT ) { bool IsRootTranscation = false; try { DBO.OUT03_SKUDBO dbo = new OUT03_SKUDBO(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 dbo.doCreate(ParameterList1, DBT); dbo.doUpdate(ParameterList2, DBT); dbo.doDelete(ParameterList3, DBT); throw new Exception("交易失敗"); #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 } }