예제 #1
0
    // 권리사 로그인 정보 로딩
    public static bool GetAuthorityLoginList(SqlHelper dbHelper)
    {
        try
        {
            AuthorityLoginManager.Instance.InitList();
            MySqlDataReader datareader = dbHelper.call_proc("spNewSelectAuthorityLogin", null);

            Int32 ComboBoxIndex = 1;
            while (datareader.Read())
            {
                AuthorityLoginInfoData pAuthorityLoginInfoData = new AuthorityLoginInfoData();

                if (datareader["seq"] != DBNull.Value)
                {
                    pAuthorityLoginInfoData.seq_ = Convert.ToInt32(datareader["seq"]);
                }

                if (datareader["ChannelSeq"] != DBNull.Value)
                {
                    pAuthorityLoginInfoData.ChannelSeq_ = Convert.ToInt32(datareader["ChannelSeq"]);
                }

                if (datareader["ChannelName"] != DBNull.Value)
                {
                    pAuthorityLoginInfoData.ChannelName_ = Convert.ToString(datareader["ChannelName"]);
                }

                if (datareader["PartnerSeq"] != DBNull.Value)
                {
                    pAuthorityLoginInfoData.PartnerSeq_ = Convert.ToInt32(datareader["PartnerSeq"]);
                }

                if (datareader["AuthorityName"] != DBNull.Value)
                {
                    pAuthorityLoginInfoData.AuthorityName_ = Convert.ToString(datareader["AuthorityName"]);
                }

                if (datareader["Name"] != DBNull.Value)
                {
                    pAuthorityLoginInfoData.Name_ = Convert.ToString(datareader["Name"]);
                }

                pAuthorityLoginInfoData.ComboIndex_ = ComboBoxIndex++;

                AuthorityLoginManager.Instance.GetList().Add(pAuthorityLoginInfoData.seq_, pAuthorityLoginInfoData);
            }

            datareader.Close();
            datareader.Dispose();
            datareader = null;
        }
        catch (System.Exception ex)
        {
            return(false);
        }

        return(true);
    }
예제 #2
0
    // 권리사 로그인 정보 로딩
    public static bool GetAuthorityLoginList(SqlHelper dbHelper)
    {
        try
        {
            AuthorityLoginManager.Instance.InitList();
            MySqlDataReader datareader = dbHelper.call_proc("spNewSelectAuthorityLogin", null);

            Int32 ComboBoxIndex = 1;
            while (datareader.Read())
            {
                AuthorityLoginInfoData pAuthorityLoginInfoData = new AuthorityLoginInfoData();

                if (datareader["seq"] != DBNull.Value)
                    pAuthorityLoginInfoData.seq_ = Convert.ToInt32(datareader["seq"]);

                if (datareader["ChannelSeq"] != DBNull.Value)
                    pAuthorityLoginInfoData.ChannelSeq_ = Convert.ToInt32(datareader["ChannelSeq"]);

                if (datareader["ChannelName"] != DBNull.Value)
                    pAuthorityLoginInfoData.ChannelName_ = Convert.ToString(datareader["ChannelName"]);

                if (datareader["PartnerSeq"] != DBNull.Value)
                    pAuthorityLoginInfoData.PartnerSeq_ = Convert.ToInt32(datareader["PartnerSeq"]);

                if (datareader["AuthorityName"] != DBNull.Value)
                    pAuthorityLoginInfoData.AuthorityName_ = Convert.ToString(datareader["AuthorityName"]);

                if (datareader["Name"] != DBNull.Value)
                    pAuthorityLoginInfoData.Name_ = Convert.ToString(datareader["Name"]);

                pAuthorityLoginInfoData.ComboIndex_ = ComboBoxIndex++;

                AuthorityLoginManager.Instance.GetList().Add(pAuthorityLoginInfoData.seq_, pAuthorityLoginInfoData);
            }

            datareader.Close();
            datareader.Dispose();
            datareader = null;
        }
        catch (System.Exception ex)
        {
            return false;
        }

        return true;
    }