private ToDoListExpireData GetSearchData()
{
ToDoListExpireData data = new ToDoListExpireData();
data.PRODUCTNAME = this.txtProductName.Text.Trim();
data.TIME = Convert.ToDouble(txtTime.Text == "" ? "0" : txtTime.Text);
return data;
}
public DataTable GetExpireWHList(ToDoListExpireData data)
{
string where = "";
if (data.PRODUCTNAME.Trim() != "")
where += (where == "" ? "" : "AND ") + "UPPER(PRODUCTNAME) LIKE '%" + data.PRODUCTNAME.Trim().ToUpper() + "%' ";
if (data.TIME != 0)
where += (where == "" ? "" : "AND ") + "EXPDATE <= ADD_MONTHS(sysdate, '" + data.TIME + "') ";
string sql = "SELECT LOID, BARCODE, PRODUCTNAME, LOTNO, QTY, UNITNAME, EXPDATE ";
sql += "FROM V_TODOLIST_WH_EXPDATE ";
sql += (where == "" ? "" : " WHERE ") + where;
sql += "ORDER BY PRODUCTNAME ";
return OracleDB.ExecListCmd(sql);
}
public DataTable GetExpireWHList(ToDoListExpireData data)
{
return DALObj.GetExpireWHList(data);
}