public List <HVAC> GetHVACSByTime(DateTime time, string reportType) { string sql = "select HvacId,Type,IsPassed,DetectTime from HVACS "; if (reportType == "日报表") { sql += "where datediff(day,'" + time + "',DetectTime)=0"; } else if (reportType == "月度报表") { //where datepart(month,'2020-02-07')=DATEPART(month,'2008-02-07') sql += "where datepart(year,DetectTime)=DATEPART(year,'" + time + "') and datepart(month,DetectTime)=DATEPART(month,'" + time + "')"; } else if (reportType == "年度报表") { sql += "where datepart(year,DetectTime)=DATEPART(year,'" + time + "')"; } SqlDataReader reader = null; try { reader = SQLHelperCommon.GetReader(sql, null, false); List <HVAC> listHvac = new List <HVAC>(); while (reader.Read()) { listHvac.Add(new HVAC() { HvacId = Convert.ToInt32(reader["HvacId"]), Type = reader["Type"].ToString(), IsPassed = reader["IsPassed"].ToString(), DetectTime = Convert.ToDateTime(reader["DetectTime"]) }); } return(listHvac); } catch (Exception ex) { throw ex; } finally { if (reader != null) { reader.Close(); } } }
public List <Param> GetParamsByHvacId(int id) { string sql = "select ParamName,Value,ValueUpper,ValueLower,ModubsAddr,IsDetected,Note,IsPassed from Params where HvacId=" + id; SqlDataReader reader = null; try { reader = SQLHelperCommon.GetReader(sql, null, false); List <Param> listP = new List <Param>(); while (reader.Read()) { listP.Add(new Param() { ParamName = reader["ParamName"].ToString(), ModubsAddr = reader["ModubsAddr"].ToString(), IsDetected = reader["IsDetected"].ToString(), Note = reader["Note"].ToString(), IsPassed = reader["IsPassed"].ToString(), Value = Convert.ToSingle(reader["Value"]), ValueUpper = Convert.ToSingle(reader["ValueUpper"]), ValueLower = Convert.ToSingle(reader["ValueLower"]), }); } return(listP); } catch (Exception ex) { throw ex; } finally { if (reader != null) { reader.Close(); } } }
/// <summary> /// 用户登陆方法 /// </summary> /// <param name="objUser">封装了登陆id和pwd的管理员对象</param> /// <returns>查询到的管理员对象,如果为null,则未查询到</returns> public User AdminLogin(User objUser) { //1.编写sql语句 string sql = "select UserName from Users where UserId = {0} and UserPwd = '{1}'"; sql = string.Format(sql, objUser.UserId, objUser.UserPwd); try { //2.调用数据访问类,执行sql语句 SqlDataReader objReader = SQLHelperCommon.GetReader(sql, null, false); //3.封装对象,返回结果 if (objReader.Read()) { objUser.UserName = objReader["UserName"].ToString(); objReader.Close(); } else { objUser = null; } } catch (SqlException ex) { objUser = null; throw ex; } catch (Exception ex) { objUser = null; throw ex; } return(objUser); }