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