private StockCheckSearchData GetData()
{
StockCheckSearchData data = new StockCheckSearchData();
data.BATCHNO = this.cmbBatchNo.Items.Count == 0 ? "xxx" : this.cmbBatchNo.SelectedItem.Text;
data.WAREHOUSE = Convert.ToDouble(this.cmbWarehouse.SelectedItem.Value);
data.LOCATION = Convert.ToDouble(this.cmbLocation.SelectedItem.Value);
data.DATEFROM = this.ctlDateFrom.DateValue;
data.DATETO = this.ctlDateTo.DateValue;
data.BARCODE = this.txtBarcode.Text.Trim();
data.PRODUCTNAME = this.txtProductName.Text.Trim();
data.LOTNO = this.cmbLotNo.SelectedItem.Text;
data.DIFFCHECK = this.chkDiff.Checked;
return data;
}
//public PDOrderDAL DALObj
//{
// get { if (_dal == null) { _dal = new PDOrderDAL(); } return _dal; }
//}
public DataTable GetStockCheckItemList(StockCheckSearchData data)
{
string whereString = "";
if (data.BATCHNO.Trim() != "")
whereString += (whereString == "" ? "" : "AND ") + "UPPER(BATCHNO) = '" + OracleDB.QRText(data.BATCHNO.Trim()).ToUpper() + "' ";
if (data.WAREHOUSE != 0)
whereString += (whereString == "" ? "" : "AND ") + "WAREHOUSE = " + data.WAREHOUSE.ToString() + " ";
if (data.LOCATION != 0)
whereString += (whereString == "" ? "" : "AND ") + "L_LOID = " + data.LOCATION.ToString() + " ";
if (data.DATEFROM.Year != 1)
whereString += (whereString == "" ? "" : "AND ") + "CHECKDATE >= " + OracleDB.QRDate(data.DATEFROM) + " ";
if (data.DATETO.Year != 1)
whereString += (whereString == "" ? "" : "AND ") + "CHECKDATE <= " + OracleDB.QRDate(data.DATETO) + " ";
if (data.BARCODE.Trim() != "")
whereString += (whereString == "" ? "" : "AND ") + "UPPER(BARCODE) LIKE '%" + data.BARCODE.Trim().ToUpper() + "%' ";
if (data.PRODUCTNAME.Trim() != "")
whereString += (whereString == "" ? "" : "AND ") + "UPPER(PD_NAME) LIKE '%" + data.PRODUCTNAME.Trim().ToUpper() + "%' ";
if (data.LOTNO.Trim() != "·Ñé§ËÁ´")
whereString += (whereString == "" ? "" : "AND ") + "UPPER(LOTNO) = '" + OracleDB.QRText(data.LOTNO.Trim()).ToUpper() + "' ";
if (data.DIFFCHECK)
whereString += (whereString == "" ? "" : "AND ") + "DIFFQTY <> 0 ";
string sql = "SELECT ROWNUM NO, BATCHNO, BARCODE, PD_NAME, LOTNO, L_NAME, SYSQTY, COUNTQTY, DIFFQTY, SH_LOID, PD_LOID , PS_LOID ";
sql += "FROM v_stockcheck_list ";
sql += (whereString == "" ? "" : "WHERE " + whereString);
DataTable dt = OracleDB.ExecListCmd(sql);
return dt;
}
