private List <SYS_INFO> MapSYS_INFO(DataTable dt) { List <SYS_INFO> rs = new List <SYS_INFO>(); for (int i = 0; i < dt.Rows.Count; i++) { SYS_INFO obj = new SYS_INFO(); if (dt.Columns.Contains("SysInfo_ID")) { obj.SysInfo_ID = dt.Rows[i]["SysInfo_ID"].ToString(); } if (dt.Columns.Contains("Application")) { obj.Application = dt.Rows[i]["Application"].ToString(); } if (dt.Columns.Contains("Version")) { obj.Version = dt.Rows[i]["Version"].ToString(); } if (dt.Columns.Contains("Type")) { obj.Type = int.Parse(dt.Rows[i]["Type"].ToString()); } if (dt.Columns.Contains("Created")) { obj.Created = DateTime.Parse(dt.Rows[i]["Created"].ToString()); } if (dt.Columns.Contains("Description")) { obj.Description = dt.Rows[i]["Description"].ToString(); } if (dt.Columns.Contains("Interface")) { obj.Interface = int.Parse(dt.Rows[i]["Interface"].ToString()); } if (dt.Columns.Contains("Guid_ID")) { obj.Guid_ID = dt.Rows[i]["Guid_ID"].ToString(); } rs.Add(obj); } return(rs); }
public int SYS_INFO_Insert(SYS_INFO obj) { try { return(DataProvider.ExecuteNonquery(DataProvider.ConnectionString, "SYS_INFO_Insert", obj.SysInfo_ID, obj.Application, obj.Version, obj.Type, obj.Created, obj.Description, obj.Guid_ID )); } catch { //throw ex; return(-1); } }