private ProductionQCSearchData GetData() { ProductionQCSearchData data = new ProductionQCSearchData(); data.MFGDATEFROM = this.ctlMfgDateFrom.DateValue; data.MFGDATETO = this.ctlMfgDateTo.DateValue; data.SENDQCDATEFROM = this.ctlSendQCDateFrom.DateValue; data.SENDQCDATETO = this.ctlSendQCDateTo.DateValue; data.EXPDATEFROM = this.ctlEXPDateFrom.DateValue; data.EXPDATETO = this.ctlEXPDateTo.DateValue; data.PRODUCT = Convert.ToDouble(this.cmbProduct.SelectedItem.Value); data.LOTNO = this.txtLotNo.Text.Trim(); return data; }
public DataTable GetProductionQCList(ProductionQCSearchData data) { return SearchDAL.GetProductionQCList(data); }
public DataTable GetProductionQCList(ProductionQCSearchData whereData) { string whereString = ""; if (whereData.MFGDATEFROM.Year != 1) whereString += (whereString == "" ? "" : "AND ") + "MFGDATE >= " + OracleDB.QRDate(whereData.MFGDATEFROM) + " "; if (whereData.MFGDATETO.Year != 1) whereString += (whereString == "" ? "" : "AND ") + "MFGDATE <= " + OracleDB.QRDate(whereData.MFGDATETO) + " "; if (whereData.SENDQCDATEFROM.Year != 1) whereString += (whereString == "" ? "" : "AND ") + "SENDQCDATE >= " + OracleDB.QRDate(whereData.SENDQCDATEFROM) + " "; if (whereData.SENDQCDATETO.Year != 1) whereString += (whereString == "" ? "" : "AND ") + "SENDQCDATE <= " + OracleDB.QRDate(whereData.SENDQCDATETO) + " "; if (whereData.EXPDATEFROM.Year != 1) whereString += (whereString == "" ? "" : "AND ") + "EXPDATE >= " + OracleDB.QRDate(whereData.EXPDATEFROM) + " "; if (whereData.EXPDATETO.Year != 1) whereString += (whereString == "" ? "" : "AND ") + "EXPDATE <= " + OracleDB.QRDate(whereData.EXPDATETO) + " "; if (whereData.PRODUCT != 0) whereString += (whereString == "" ? "" : "AND ") + "PRODUCT = " + whereData.PRODUCT + " "; if (whereData.LOTNO.Trim() != "") whereString += (whereString == "" ? "" : "AND ") + "LOTNO = '" + OracleDB.QRText(whereData.LOTNO.Trim()) + "' "; string sql = "SELECT ROWNUM NO,A.* FROM (SELECT PDP.LOID,PDP.MFGDATE,PDP.QUARANTINEDATE,PDP.PRODUCT, "; sql += "PD.NAME PRODUCTNAME,PDP.LOTNO,PDP.QCQTY1,U.NAME UNITNAME,PDP.QUARANTINEREMARK, "; sql += "PDP.STDQTY,PDP.QCREMARK,PDP.SENDQCDATE,PO.ORDERDATE "; sql += "FROM PDPRODUCT PDP INNER JOIN PDORDER PO ON PDP.PDORDER = PO.LOID "; sql += "INNER JOIN PRODUCT PD ON PDP.PRODUCT = PD.LOID INNER JOIN UNIT U ON PD.UNIT = U.LOID)A "; sql += (whereString == "" ? "" : "WHERE " + whereString); sql += "ORDER BY NO "; return OracleDB.ExecListCmd(sql); }