Esempio n. 1
0
 private ToDoListExpireData GetSearchData()
 {
     ToDoListExpireData data = new ToDoListExpireData();
     data.PRODUCTNAME = this.txtProductName.Text.Trim();
     data.TIME = Convert.ToDouble(txtTime.Text == "" ? "0" : txtTime.Text);
     return data;
 }
Esempio n. 2
0
        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);
        }
Esempio n. 3
0
 public DataTable GetExpireWHList(ToDoListExpireData data)
 {
     return DALObj.GetExpireWHList(data);
 }