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); }