예제 #1
0
        public static DataTable GetforLookup(SQLITE_DAL SQLITE_DAL)
        {
            string q = " SELECT " + MASTERPATH.MASTERPATH_TBL + ".* \r\n";

            q += ", " + MASTERTABLES.MASTERTABLES_TBL + "." + MASTERTABLES.MASTERTABLES_NAME + " \r\n";
            q += " FROM  " + MASTERPATH.MASTERPATH_TBL + " \r\n";
            q += " INNER JOIN  " + MASTERTABLES.MASTERTABLES_TBL + " \r\n";
            q += " ON( " + MASTERPATH.MASTERPATH_TBL + "." + MASTERTABLES.MASTERTABLES_ID + " = " + MASTERTABLES.MASTERTABLES_TBL + "." + MASTERTABLES.MASTERTABLES_ID + ")\r\n";
            q += " WHERE " + MASTERPATH.MASTERPATH_TBL + "." + MASTERPATH.ACTIVE_ID + "  = '" + Core.Active + "' \r\n";
            q += " ORDER BY  " + MASTERPATH.MASTERPATH_TBL + "." + MASTERPATH.MASTERPATH_ID + ";\r\n";

            return(SQLITE_DAL.Listdata(q));
        }