// MODEL.base_cpbh_data_main mystyleno = new MODEL.base_cpbh_data_main(); #region 獲取工厂型体 -string GetAllCode(string yearmonth) /// <summary> /// /// </summary> /// <param name="yearmonth"></param> /// <returns></returns> public List <MODEL.base_cpbh_data_main> GetOldStyle(string yearmonth) { string[] olddays = yearmonth.Split('-'); string days = olddays[0].Substring(2, 2) + olddays[1]; // string days1 = "1201"; string sql = " select cpbh,days from base_cpbh_data_main where days >@days"; SqlParameter p = new SqlParameter("days", days); DataTable dt = SqlHelper.ExcuteTable(sql, p); List <MODEL.base_cpbh_data_main> lists = null; if (dt.Rows.Count > 0) { lists = new List <MODEL.base_cpbh_data_main>(); foreach (DataRow row in dt.Rows) { MODEL.base_cpbh_data_main c = new MODEL.base_cpbh_data_main(); LoadDataToList(row, c); lists.Add(c); } } return(lists); }
/// 加载行数据到对象--集合 /// </summary> /// <param name="dr"></param> /// <param name="classes"></param> public void LoadDataToList(DataRow dr, MODEL.base_cpbh_data_main mycode) { mycode.cpbh = dr["cpbh"].ToString(); mycode.days = dr["days"].ToString(); }