/// <summary> /// 返回list对象 /// </summary> /// <param name="dt"></param> /// <returns></returns> public static List <BearingAnalysis> ListValue(DataTable dt) { List <BearingAnalysis> bearingList = new List <BearingAnalysis>(); BearingAnalysis bearing; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { bearing = new BearingAnalysis(); bearing.strID = dt.Rows[i]["strID"].ToString(); bearing.JiCheID = PageBase.static_ext_int(dt.Rows[i]["JiCheID"]); bearing.traintype = dt.Rows[i]["strValue"].ToString(); bearing.traincode = dt.Rows[i]["traincode"].ToString(); bearing.begindt = PageBase.static_ext_date(dt.Rows[i]["begindt"]); bearing.enddt = PageBase.static_ext_date(dt.Rows[i]["enddt"]); bearing.maxtemper = PageBase.static_ext_double(dt.Rows[i]["maxtemper"]); bearing.maxteemper = PageBase.static_ext_double(dt.Rows[i]["maxteemper"]); bearing.maxtemperdate = PageBase.static_ext_date(dt.Rows[i]["maxtemperdate"]); bearing.maxtemperpos = dt.Rows[i]["maxtemperpos"].ToString(); bearing.maxtemperrasie = PageBase.static_ext_double(dt.Rows[i]["maxtemperrasie"]); bearing.maxteemperrasie = PageBase.static_ext_double(dt.Rows[i]["maxteemperrasie"]); bearing.maxtemperrasiedate = PageBase.static_ext_date(dt.Rows[i]["maxtemperrasiedate"]); bearing.maxtemperrasiepos = dt.Rows[i]["maxtemperrasiepos"].ToString(); bearingList.Add(bearing); } } return(bearingList); }
/// <summary> /// 根据传入where条件获取轴报记录 /// </summary> /// <param name="where"></param> /// <returns></returns> public static BearingAnalysis BearingAnalysisRecords(string where) { string strSql = "select * from TAB_BearingAnalysis where 1=1 " + where; DataTable dt = SqlHelper.ExecuteDataset(searchmaster.GetSqlConnConfig("57"), CommandType.Text, strSql).Tables[0]; BearingAnalysis bearing = new BearingAnalysis(); if (dt.Rows.Count > 0) { return(SetValue(bearing, dt.Rows[0])); } return(bearing); }
public static BearingAnalysis SetValue(BearingAnalysis bearing, DataRow dr) { if (dr != null) { bearing.strID = dr["strID"].ToString(); bearing.JiCheID = PageBase.static_ext_int(dr["JiCheID"]); bearing.traintype = dr["traintype"].ToString(); bearing.traincode = dr["traincode"].ToString(); bearing.begindt = PageBase.static_ext_date(dr["begindt"]); bearing.enddt = PageBase.static_ext_date(dr["enddt"]); bearing.maxtemper = PageBase.static_ext_double(dr["maxtemper"]); bearing.maxteemper = PageBase.static_ext_double(dr["maxteemper"]); bearing.maxtemperdate = PageBase.static_ext_date(dr["maxtemperdate"]); bearing.maxtemperpos = dr["maxtemperpos"].ToString(); bearing.maxtemperrasie = PageBase.static_ext_double(dr["maxtemperrasie"]); bearing.maxteemperrasie = PageBase.static_ext_double(dr["maxteemperrasie"]); bearing.maxtemperrasiedate = PageBase.static_ext_date(dr["maxtemperrasiedate"]); bearing.maxtemperrasiepos = dr["maxtemperrasiepos"].ToString(); } return(bearing); }