Example #1
0
        public DataTable selectAll()
        {
            String    sql = "";
            DataTable dt  = new DataTable();

            sql = "Select * From " + lSale.table + " Where " + lSale.Active + "='1' Order By " + lSale.saleName;
            dt  = conn.selectData(sql);

            return(dt);
        }
Example #2
0
        public DataTable selectAll()
        {
            String    sql = "";
            DataTable dt  = new DataTable();

            sql = "Select * From " + rw.table + " Order By " + rw.yearId + "," + rw.monthId + "," + rw.periodId;
            dt  = conn.selectData(sql);

            return(dt);
        }
Example #3
0
        public DataTable selectAll()
        {
            String    sql = "";
            DataTable dt  = new DataTable();

            sql = "Select * From " + cust.table + " Where " + cust.Active + "='1'";
            dt  = conn.selectData(sql);

            return(dt);
        }
Example #4
0
        public DataTable selectAll()
        {
            String    sql = "";
            DataTable dt2 = new DataTable();

            try
            {
                sql = "Select * From " + sr.table + " Where " + sr.Active + "='1'";
                dt2 = conn.selectData(sql);
            }
            catch (Exception ex)
            {
            }

            return(dt2);
        }
Example #5
0
        private String selectLock()
        {
            DataTable dt  = new DataTable();
            String    sql = "";

            sql = "select " + fl.fLock + " From " + fl.table;
            dt  = conn.selectData(sql);
            if (dt.Rows.Count > 0)
            {
                return(dt.Rows[0][fl.fLock].ToString());
            }
            else
            {
                return("");
            }
        }
Example #6
0
        public DataTable selectAll()
        {
            String    sql = "";
            DataTable dt  = new DataTable();

            try
            {
                sql = "Select * From " + tho.table + " Where " + tho.Active + "='1' Order By " + tho.Color;
                dt  = conn.selectData(sql);
            }
            catch (Exception ex)
            {
            }


            return(dt);
        }