protected int QueryPurchaseMain() { MaintainPurchaseOrder BCO = new MaintainPurchaseOrder(ConntionDB); ParameterList.Clear(); ParameterList.Add(txtPURCHASE_NO.Text.Trim()); DataTable dt = BCO.QuerySwitch(PURCommon.QueryType.PK, ParameterList); //iResult 0:查無資料 1:有資料但全部結案 2:有資料(可能包含部分結案) SLP_VendorBase1.Text = ""; txtStatus.Text = ""; //此欄位是在途單的狀態 非採購單的狀態 int iResult = 2; if (dt.Rows.Count == 0) { iResult = 0; } else { SLP_VendorBase1.Text = dt.Rows[0]["VENDOR"].ToString().Trim(); if (dt.Rows[0]["STATUS"].ToString().Trim() == "75") { iResult = 1; } } return iResult; }
private DataTable Get_MainData(string strPURCHASE_NO) { MaintainPurchaseOrder bco = new MaintainPurchaseOrder(ConntionDB); ParameterList.Clear(); ParameterList.Add("AND M.PURCHASE_NO='" + strPURCHASE_NO + "'"); DataTable dt = bco.QuerySwitch(PURModel.PURCommon.QueryType.Where1, ParameterList); return dt; }
// 繫結資料 Master private bool databind_Master() { bool bResult = false; ErrorMsgLabel.Text = ""; MaintainPurchaseOrder bco = new MaintainPurchaseOrder(ConntionDB); ParameterList.Clear(); ParameterList.Add(this.hiddenPurchaseNo.Value); DataTable Dt = bco.QuerySwitch(PURModel.PURCommon.QueryType.PK, ParameterList); if (Dt.Rows.Count > 0) { ViewState["MasterOLDData"] = Dt; this.hiddenIsClose.Value = Dt.Rows[0]["IS_CLOSE"].ToString(); this.hiddenPurchase_ID.Value = Dt.Rows[0]["ID"].ToString(); bResult = true; } else { ErrorMsgLabel.Text = "查無此筆資料或已被其他使用者刪除,請點選上一筆/下一筆鈕或回查詢頁重新查詢!"; } return bResult; }
protected void BtnQuery_Click(object sender, EventArgs e) { try { ErrorMsgLabel.Text = ""; ResultMsgLabel.Text = ""; IsCheckOK = true; DataTable Dt = new DataTable(); // 清空靜態變數 與 檢查各查詢參數是否正確 string strWhere = ""; strWhere = this.getQuerySqlStatement(); if (IsCheckOK) { MaintainPurchaseOrder bco = new MaintainPurchaseOrder(ConntionDB); ParameterList.Clear(); ParameterList.Add(strWhere); ParameterList.Add(TextBoxRowCountLimit.Text.Trim()); Dt = bco.QuerySwitch(PURModel.PURCommon.QueryType.Where1, ParameterList); if (Dt == null || (Dt != null && Dt.Rows.Count <= 0)) { ResultMsgLabel.Text = "查無資料"; } else { dt_Detail = Dt; } // 設定頁面狀態 this.hid_PageStatus.Value = "QUERY"; this.txt_PageStatus.Text = "QUERY"; // 設定查詢結果 this.gv_Detail.DataSource = Dt; this.gv_Detail.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text); this.gv_Detail.PageIndex = 0; if (Dt.Rows.Count > 0) Set_SessionNo(dt_Detail.DefaultView); else Session["PUR02_SortKey" + PageTimeStamp.Value] = null; } else { this.gv_Detail.DataSource = null; } this.gv_Detail.DataBind(); } catch (Exception ex) { this.ErrorMsgLabel.Text = ex.ToString(); } finally { } }