private void SearchData() { SearchFlow flow = new SearchFlow(); PopupStockoutBasketData data = new PopupStockoutBasketData(); data.BARCODE = this.txtBarCode.Text.Trim(); data.NAME = this.txtBasketName.Text.Trim(); this.grvReserve.DataSource = flow.GetBasketList(data); this.grvReserve.DataBind(); }
public static DataTable GetBasketList(PopupStockoutBasketData data) { string where = "ACTIVE = '1' "; if (data.BARCODE.Trim() != "") where += (where == "" ? "" : "AND ") + "UPPER(BARCODE) LIKE '%" + OracleDB.QRText(data.BARCODE.Trim()).ToUpper() + "%' "; if (data.NAME.Trim() != "") where += (where == "" ? "" : "AND ") + "UPPER(NAME) LIKE '%" + OracleDB.QRText(data.NAME.Trim()).ToUpper() + "%' "; string sql = "SELECT LOID, BARCODE, NAME "; sql += "FROM V_PRODUCT_PACKAGE "; sql += (where == "" ? "" : "WHERE " + where); sql += "ORDER BY BARCODE "; return OracleDB.ExecListCmd(sql); }
public DataTable GetBasketList(PopupStockoutBasketData data) { return SearchDAL.GetBasketList(data); }