コード例 #1
0
        /// <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;
        }