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);
}
