/// <summary> /// 获取结果 /// </summary> /// <param name="strsql"></param> /// <param name="param"></param> /// <returns></returns> public static string getResult(string strsql, SqlParameter param) { string result = ""; SqlConnection con = DataBaseOperate.getSqlCon(); SqlCommand cmd = DataBaseOperate.getSqlCmd(strsql, con); cmd.Parameters.Add(param); SqlDataReader read = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (read.Read()) { result = read[0].ToString(); } con.Close(); return(result); }
/// <summary> /// 获取处在某一时间段内的具体时间,用于汇总传参 /// </summary> /// <param name="strsql"></param> /// <param name="param"></param> /// <returns></returns> public static List <string> getIncludeTime(string strsql, SqlParameter[] param) { List <string> list = new List <string>(); //string strsql = "select MONITORTIME from MONITORTIME between @time1 and @time2"; SqlConnection con = DataBaseOperate.getSqlCon(); SqlCommand cmd = DataBaseOperate.getSqlCmd(strsql, con); cmd.Parameters.AddRange(param); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { list.Add(reader[0].ToString()); } con.Close(); cmd.Parameters.Clear(); return(list); }