private void SearchData() { ProductionToDoListFlow flow = new ProductionToDoListFlow(); ProductionWaitListSearchData data = new ProductionWaitListSearchData(); data.CODEFROM = this.txtCodeFrom.Text.Trim(); data.CODETO = this.txtCodeTo.Text.Trim(); data.DATEFROM = this.dtpDateFrom.DateValue; data.DATETO = this.dtpDateTo.DateValue; data.PDNAME = this.txtPDName.Text.Trim(); this.grvProductionWait.DataSource = flow.GetProductionWaitList(data); this.grvProductionWait.DataBind(); }
public DataTable GetProductionWaitList(ProductionWaitListSearchData data) { string where = ""; 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(REQDATE, 'DDMMYYYY') >= " + OracleDB.QRDate(data.DATEFROM) + " "; if (data.DATETO.Year != 1) where += (where == "" ? "" : "AND ") + "TO_DATE(REQDATE, 'DDMMYYYY') <= " + OracleDB.QRDate(data.DATETO) + " "; if (data.PDNAME.Trim() != "") where += (where == "" ? "" : "AND ") + "UPPER(PDNAME) LIKE '%" + data.PDNAME.Trim().ToUpper() + "%' "; string sql = "SELECT RQILOID, RQLOID, PDLOID, CODE, PDNAME, REQDATE, QTY, UNAME, OFFICER "; sql += "FROM V_TODOLIST_PD_WAIT "; sql += (where == "" ? "" : "WHERE " + where); return OracleDB.ExecListCmd(sql); }