private void SearchData() { SearchFlow flow = new SearchFlow(); PopupProductPRSearchData data = new PopupProductPRSearchData(); data.PRCODEFROM = this.txtFromPRCode.Text.Trim(); data.PRCODETO = this.txtToPRCode.Text.Trim(); data.DUEDATEFROM = this.ctlFromDueDate.DateValue; data.DUEDATETO = this.ctlToDueDate.DateValue; if (Convert.ToDouble(this.cmbPurchaseType.SelectedValue) != 0) { data.PURCHASETYPE = this.cmbPurchaseType.SelectedItem.Text; } if (Convert.ToDouble(this.cmbProduct.SelectedValue) != 0) { data.PRODUCT = this.cmbProduct.SelectedItem.Text; } if (Convert.ToDouble(this.cmbDivision.SelectedValue) != 0) { data.DIVISION = this.cmbDivision.SelectedItem.Text; } this.grvReserve.DataSource = flow.GetProductPRList(data); this.grvReserve.DataBind(); }
public static DataTable GetProductPRList(PopupProductPRSearchData data) { string where = "QTY > 0 "; if (data.PRCODEFROM.Trim() != "") where += (where == "" ? "" : "AND ") + "UPPER(PRCODE) >= '" + OracleDB.QRText(data.PRCODEFROM.Trim()).ToUpper() + "' "; if (data.PRCODETO.Trim() != "") where += (where == "" ? "" : "AND ") + "UPPER(PRCODE) <= '" + OracleDB.QRText(data.PRCODETO.Trim()).ToUpper() + "' "; if (data.DUEDATEFROM.Year != 1) where += (where == "" ? "" : "AND ") + "TO_DATE(DUEDATE, 'DDMMYYYY') >= " + OracleDB.QRDate(data.DUEDATEFROM) + " "; if (data.DUEDATETO.Year != 1) where += (where == "" ? "" : "AND ") + "TO_DATE(DUEDATE, 'DDMMYYYY') <= " + OracleDB.QRDate(data.DUEDATETO) + " "; if (data.PURCHASETYPE.Trim() != "") where += (where == "" ? "" : "AND ") + "UPPER(PURCHASETYPE) = '" + OracleDB.QRText(data.PURCHASETYPE.Trim()).ToUpper() + "' "; if (data.PRODUCT.Trim() != "") where += (where == "" ? "" : "AND ") + "UPPER(PDNAME) = '" + OracleDB.QRText(data.PRODUCT.Trim()).ToUpper() + "' "; if (data.DIVISION.Trim() != "") where += (where == "" ? "" : "AND ") + "UPPER(DVNAME) = '" + OracleDB.QRText(data.DIVISION.Trim()).ToUpper() + "' "; string sql = "SELECT * FROM v_product_po_popup_list "; sql += (where == "" ? "" : "WHERE " + where); sql += "ORDER BY PRCODE "; return OracleDB.ExecListCmd(sql); }
public DataTable GetProductPRList (PopupProductPRSearchData data) { return SearchDAL.GetProductPRList(data); }