private static void FillData(SupplierManager SupplierData, DataRow dr) { Type tp = typeof(SupplierManager); for (int i = 0; i < dr.Table.Columns.Count; i++) { string propertyName = dr.Table.Columns[i].ColumnName; PropertyInfo propertyinfo = tp.GetProperty(propertyName); if (propertyinfo != null && dr[i] != DBNull.Value) { propertyinfo.SetValue(SupplierData, dr[i], null); } } }
public static List<SupplierManager> GetDetail(string ID) { string strSql = "SELECT * FROM V_Supplier WHERE ID = @ID"; DataTable dt = DbHelperSQL.Query(strSql, new SqlParameter("@ID", ID)).Tables[0]; List<SupplierManager> SupplierData = new List<SupplierManager>(); foreach (DataRow dr in dt.Rows) { SupplierManager Detail = new SupplierManager(); //for (int i = 0; i < dr.Table.Columns.Count; i++) // { FillData(Detail, dr); //} SupplierData.Add(Detail); } return SupplierData; }