/// <summary> /// /// </summary> /// <returns></returns> internal List<Business.ParameterItem> GetAllIGroupSecurityConfig() { List<Business.ParameterItem> Result = new List<Business.ParameterItem>(); System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection); DSTableAdapters.IGroupSecurityConfigTableAdapter adap = new DSTableAdapters.IGroupSecurityConfigTableAdapter(); DS.IGroupSecurityConfigDataTable tbIGroupSecurityConfig = new DS.IGroupSecurityConfigDataTable(); try { conn.Open(); adap.Connection = conn; tbIGroupSecurityConfig = adap.GetData(); if (tbIGroupSecurityConfig != null) { int count = tbIGroupSecurityConfig.Count; for (int i = 0; i < count; i++) { Business.ParameterItem newParameter = new Business.ParameterItem(); newParameter.ParameterItemID = tbIGroupSecurityConfig[i].IGroupSecurityConfigID; newParameter.SecondParameterID = tbIGroupSecurityConfig[i].IGroupSecurityID; newParameter.Name = tbIGroupSecurityConfig[i].Name; newParameter.Code = tbIGroupSecurityConfig[i].Code; newParameter.BoolValue = tbIGroupSecurityConfig[i].BoolValue; newParameter.StringValue = tbIGroupSecurityConfig[i].StringValue; newParameter.NumValue = tbIGroupSecurityConfig[i].NumValue; newParameter.DateValue = tbIGroupSecurityConfig[i].DateValue; Result.Add(newParameter); } } } catch (Exception ex) { return null; } finally { adap.Connection.Close(); conn.Close(); } return Result; }