private List <SYS_OPTION> MapSYS_OPTION(DataTable dt) { List <SYS_OPTION> rs = new List <SYS_OPTION>(); for (int i = 0; i < dt.Rows.Count; i++) { SYS_OPTION obj = new SYS_OPTION(); if (dt.Columns.Contains("Option_ID")) { obj.Option_ID = (dt.Rows[i]["Option_ID"].ToString()); } if (dt.Columns.Contains("OptionValue")) { obj.OptionValue = (dt.Rows[i]["OptionValue"].ToString()); } if (dt.Columns.Contains("ValueType")) { obj.ValueType = int.Parse(dt.Rows[i]["ValueType"].ToString()); } if (dt.Columns.Contains("System")) { obj.System = bool.Parse(dt.Rows[i]["System"].ToString()); } if (dt.Columns.Contains("Description")) { obj.Description = (dt.Rows[i]["Description"].ToString()); } rs.Add(obj); } return(rs); }
public int SYS_OPTION_Insert(SYS_OPTION obj) { try { return(DataProvider.ExecuteNonquery(DataProvider.ConnectionString, "SYS_OPTION_Insert", obj.Option_ID, obj.OptionValue, obj.ValueType, obj.Description )); } catch { //throw ex; return(-1); } }
public int SYS_OPTION_Update(SYS_OPTION obj, string Option_ID) { try { return(DataProvider.ExecuteNonquery(DataProvider.ConnectionString, "SYS_LOG_Update", Option_ID, obj.OptionValue, obj.ValueType, obj.Description )); } catch { //throw ex; return(-1); } }