public recordset GetHistoryByName(String name, String begin, String end)
{
recordset rd = new recordset();
rd.cols = new ArrayList();
rd.rows = new ArrayList();
try
{
SqlConnection sc = new SqlConnection(constr);
SqlCommand sm = new SqlCommand();
sm.CommandType = CommandType.StoredProcedure;
sm.CommandText = "[sp_gethistorybyname]";
sm.Connection = sc;
SqlParameter param0 = new SqlParameter("@stnm", name);
sm.Parameters.Add(param0);
SqlParameter param1 = new SqlParameter("@stm", begin);
sm.Parameters.Add(param1);
SqlParameter param2 = new SqlParameter("@etm", end);
sm.Parameters.Add(param2);
sc.Open();
SqlDataReader dr = sm.ExecuteReader();
if (dr.HasRows)
{
for (int i = 0; i < dr.FieldCount; i++)
{
rd.cols.Add(dr.GetName(i));
}
while (dr.Read())
{
object[] ob = new object[dr.FieldCount];
dr.GetValues(ob);
rd.rows.Add(ob);
}
}
dr.Close();
sc.Close();
}
catch (Exception e)
{
rd.name = e.ToString();
}
return(rd);
}
public recordset GetHistoryByName(String name, String begin,String end)
{
recordset rd = new recordset();
rd.cols = new ArrayList();
rd.rows = new ArrayList();
try
{
SqlConnection sc = new SqlConnection(constr);
SqlCommand sm = new SqlCommand();
sm.CommandType = CommandType.StoredProcedure;
sm.CommandText = "[sp_gethistorybyname]";
sm.Connection = sc;
SqlParameter param0 = new SqlParameter("@stnm", name);
sm.Parameters.Add(param0);
SqlParameter param1 = new SqlParameter("@stm", begin);
sm.Parameters.Add(param1);
SqlParameter param2 = new SqlParameter("@etm", end);
sm.Parameters.Add(param2);
sc.Open();
SqlDataReader dr = sm.ExecuteReader();
if (dr.HasRows)
{
for (int i = 0; i < dr.FieldCount; i++) rd.cols.Add(dr.GetName(i));
while (dr.Read())
{
object[] ob = new object[dr.FieldCount];
dr.GetValues(ob);
rd.rows.Add(ob);
}
}
dr.Close();
sc.Close();
}
catch (Exception e)
{
rd.name = e.ToString();
}
return rd;
}
public recordset GetRealTime()
{
recordset rd = new recordset();
rd.cols = new ArrayList();
rd.rows = new ArrayList();
try
{
SqlConnection sc = new SqlConnection(constr);
SqlCommand sm = new SqlCommand();
sm.CommandType = CommandType.StoredProcedure;
sm.CommandText = "[sp_getrealtime]";
sm.Connection = sc;
sc.Open();
SqlDataReader dr = sm.ExecuteReader();
if (dr.HasRows)
{
for (int i = 0; i < dr.FieldCount; i++)
{
rd.cols.Add(dr.GetName(i));
}
while (dr.Read())
{
object[] ob = new object[dr.FieldCount];
dr.GetValues(ob);
rd.rows.Add(ob);
}
}
dr.Close();
sc.Close();
}
catch (Exception e)
{
rd.name = e.ToString();
}
return(rd);
}
public recordset GetRealTime()
{
recordset rd = new recordset();
rd.cols = new ArrayList();
rd.rows = new ArrayList();
try
{
SqlConnection sc = new SqlConnection(constr);
SqlCommand sm = new SqlCommand();
sm.CommandType = CommandType.StoredProcedure;
sm.CommandText = "[sp_getrealtime]";
sm.Connection = sc;
sc.Open();
SqlDataReader dr = sm.ExecuteReader();
if (dr.HasRows)
{
for (int i = 0; i < dr.FieldCount; i++) rd.cols.Add(dr.GetName(i));
while (dr.Read())
{
object[] ob = new object[dr.FieldCount];
dr.GetValues(ob);
rd.rows.Add(ob);
}
}
dr.Close();
sc.Close();
}
catch (Exception e)
{
rd.name= e.ToString();
}
return rd;
}
