private JRRTable RowToDDInforMationID(DataRow dr)
{
JRRTable dD_Infor = new JRRTable()
{
AutoID = Convert.ToInt32(dr["AutoID"]),
JRName = dr["JRName"].ToString(),
JJRName = dr["JJRName"].ToString(),
EndJDTime = (DateTime?)SqlHelper.GetDBnullValue(dr["EndJDTime"]),
SatJQTime = (DateTime?)SqlHelper.GetDBnullValue(dr["SatJQTime"]),
SatJHTime = (DateTime?)SqlHelper.GetDBnullValue(dr["SatJHTime"])
};
return(dD_Infor);
}
public List <JRRTable> GetAlldD_JRRTable()
{
string sql = "select * from JRRTable ";
DataTable dt = SqlHelper.ExecuteTable(sql);
List <JRRTable> list = new List <JRRTable>();
if (dt.Rows.Count > 0)
{
foreach (DataRow item in dt.Rows)
{
JRRTable inforMation = RowToDDInforMationID(item);
list.Add(inforMation);
}
}
return(list);
}
