private ProductStockinQuarantineSearchData GetData()
{
ProductStockinQuarantineSearchData data = new ProductStockinQuarantineSearchData();
data.MFGDATE= this.ctlMFGDate.DateValue;
data.PRODUCT = Convert.ToDouble(this.cmbProduct.SelectedItem.Value);
data.LOTNO = this.txtLotNo.Text.Trim();
return data;
}
public DataTable GetProductionStockinQuarantineList(ProductStockinQuarantineSearchData whereData)
{
string whereString = "";
if (whereData.MFGDATE.Year != 1)
whereString += (whereString == "" ? "" : "AND ") + "MFGDATE = " + OracleDB.QRDate(whereData.MFGDATE) + " ";
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.PRODUCT,PD.NAME PRODUCTNAME,PDP.LOTNO,PDP.QUARANTINEQTY,U.NAME UNITNAME,PDP.QUARANTINEREMARK ";
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);
}
public DataTable GetProductionStockinQuarantineList(ProductStockinQuarantineSearchData data)
{
return SearchDAL.GetProductionStockinQuarantineList(data);
}