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