private void SearchData()
{
SearchFlow flow = new SearchFlow();
PopupPOSearchData data = new PopupPOSearchData();
data.CODEFROM = this.txtCodeFrom.Text.Trim();
data.CODETO = this.txtCodeTo.Text.Trim();
data.DATEFROM = this.ctlDateFrom.DateValue;
data.DATETO = this.ctlDateTo.DateValue;
if (Convert.ToDouble(this.cmbSupplier.SelectedValue) != 0)
{
data.SUPPLIER = this.cmbSupplier.SelectedValue;
}
this.grvReserve.DataSource = flow.GetPOList(data);
this.grvReserve.DataBind();
}
public static DataTable GetPOList(PopupPOSearchData data)
{
string where = "STATUS = 'AP' AND LOID NOT IN (SELECT POOLD FROM POEDIT)";
if (data.CODEFROM.Trim() != "")
where += (where == "" ? "" : "AND ") + "UPPER(CODE) >= '" + OracleDB.QRText(data.CODEFROM.Trim()).ToUpper() + "' ";
if (data.CODETO.Trim() != "")
where += (where == "" ? "" : "AND ") + "UPPER(CODE) <= '" + OracleDB.QRText(data.CODETO.Trim()).ToUpper() + "' ";
if (data.DATEFROM.Year != 1)
where += (where == "" ? "" : "AND ") + "TO_DATE(ORDERDATE, 'DDMMYYYY') >= " + OracleDB.QRDate(data.DATEFROM) + " ";
if (data.DATETO.Year != 1)
where += (where == "" ? "" : "AND ") + "TO_DATE(ORDERDATE, 'DDMMYYYY') <= " + OracleDB.QRDate(data.DATETO) + " ";
if (data.SUPPLIER.Trim() != "")
where += (where == "" ? "" : "AND ") + "UPPER(SUPPLIER) = '" + OracleDB.QRText(data.SUPPLIER.Trim()).ToUpper() + "' ";
string sql = "SELECT * FROM (SELECT PO.LOID,PO.CODE,PO.ORDERDATE,PO.SUPPLIER,S.SUPPLIERNAME,PO.STATUS FROM PDORDER PO INNER JOIN SUPPLIER S ON PO.SUPPLIER = S.LOID) A ";
sql += (where == "" ? "" : "WHERE " + where);
sql += "ORDER BY CODE ";
return OracleDB.ExecListCmd(sql);
}
public DataTable GetPOList(PopupPOSearchData data)
{
return SearchDAL.GetPOList(data);
}
