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); }
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); }
public DataTable selectAll() { String sql = ""; DataTable dt = new DataTable(); sql = "Select * From " + cust.table + " Where " + cust.Active + "='1'"; dt = conn.selectData(sql); return(dt); }
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); }
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(""); } }
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); }