private InvoiceRequestSearchData GetSearchData()
{
InvoiceRequestSearchData data = new InvoiceRequestSearchData();
data.CUSTOMERCODE = this.txtMemberCode.Text.Trim();
data.CUSTOMERNAME = this.txtMemberName.Text.Trim();
data.INVCODE = this.txtInvcode.Text.Trim();
data.PRODUCTNAME = this.txtProduct.Text.Trim();
return data;
}
public static DataTable GetInvoiceRequest(InvoiceRequestSearchData data, double currentInvoice)
{
string where = "REQUISITION NOT IN (SELECT REFLOID FROM REQUISITION WHERE REQUISITIONTYPE = " + Constz.Requisition.RequisitionType.REQ05.ToString() + " ";
where += "AND REFTABLE = 'REQUISITION' AND STATUS <> '" + Constz.Requisition.Status.Void.Code + "' AND LOID<> " + currentInvoice.ToString() + ") ";
if (data.INVCODE.Trim() != "")
where += (where == "" ? "" : "AND ") + "UPPER(INVCODE) LIKE '%" + data.INVCODE.Trim().ToUpper() + "%' ";
if (data.CUSTOMERCODE.Trim() != "")
where += (where == "" ? "" : "AND ") + "UPPER(CUSTOMERCODE) LIKE '%" + data.CUSTOMERCODE.Trim().ToUpper() + "%' ";
if (data.CUSTOMERNAME.Trim() != "")
where += (where == "" ? "" : "AND ") + "UPPER(CUSTOMERNAME) LIKE '%" + data.CUSTOMERNAME.Trim().ToUpper() + "%' ";
if (data.PRODUCTNAME.Trim() != "")
where += (where == "" ? "" : "AND ") + "UPPER(PRODUCTNAME) LIKE '%" + data.PRODUCTNAME.Trim().ToUpper() + "%' ";
string sql = "SELECT DISTINCT REQUISITION LOID, INVCODE, REQDATE, CUSTOMERNAME FROM V_INVOICE_FOR_REQUEST ";
sql += (where == "" ? "" : "WHERE " + where);
sql += "ORDER BY INVCODE, REQDATE, CUSTOMERNAME ";
return OracleDB.ExecListCmd(sql);
}
public DataTable GetInvoiceRequestList(InvoiceRequestSearchData data, double currentInvoice)
{
return SearchDAL.GetInvoiceRequest(data, currentInvoice);
}