private void SearchData() { ProductionToDoListFlow flow = new ProductionToDoListFlow(); ProductionDuringListSearchData data = new ProductionDuringListSearchData(); data.LOTNO = this.txtLotNo.Text.Trim(); data.DATEFROM = this.dtpDateFrom.DateValue; data.DATETO = this.dtpDateTo.DateValue; data.PDNAME = this.txtPDName.Text.Trim(); this.grvProductionDuring.DataSource = flow.GetProductionDuringList(data); this.grvProductionDuring.DataBind(); }
public DataTable GetProductionDuringList(ProductionDuringListSearchData data) { string where = ""; if (data.LOTNO.Trim() != "") where += (where == "" ? "" : "AND ") + "UPPER(LOTNO) LIKE '%" + data.LOTNO.Trim().ToUpper() + "%' "; if (data.DATEFROM.Year != 1) where += (where == "" ? "" : "AND ") + "TO_DATE(MFGDATE, 'DDMMYYYY') >= " + OracleDB.QRDate(data.DATEFROM) + " "; if (data.DATETO.Year != 1) where += (where == "" ? "" : "AND ") + "TO_DATE(MFGDATE, 'DDMMYYYY') <= " + OracleDB.QRDate(data.DATETO) + " "; if (data.PDNAME.Trim() != "") where += (where == "" ? "" : "AND ") + "UPPER(PDNAME) LIKE '%" + data.PDNAME.Trim().ToUpper() + "%' "; string sql = "SELECT PDPLOID, POLOID, LOTNO, PDNAME, MFGDATE, STDQTY, PDQTY, UNAME, DUEDATE, SUPPLIERNAME, QUARANTINEDATE, SENDQCDATE, QCDUEDATE, QCRESULT, SENDFGDATE "; sql += "FROM V_TODOLIST_PD_DURING "; sql += (where == "" ? "" : "WHERE " + where); return OracleDB.ExecListCmd(sql); }