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