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