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