GetInt64() public method

public GetInt64 ( int i ) : System.Int64
i int
return System.Int64
コード例 #1
0
ファイル: DBUtils.cs プロジェクト: Reve/EVESharp
        public static PyObject DBColumnToPyObject(int index, ref MySqlDataReader reader)
        {
            Type type = reader.GetFieldType(index);

            switch (type.Name)
            {
                case "String":
                    return new PyString(reader.GetString(index));
                case "UInt32":
                case "Int32":
                case "UInt16":
                case "Int16":
                case "SByte":
                case "Byte":
                    return new PyInt(reader.GetInt32(index));
                case "UInt64":
                case "Int64":
                    return new PyLongLong(reader.GetInt64(index));
                case "Byte[]":
                    return new PyBuffer((byte[])reader.GetValue(index));
                case "Double":
                    return new PyFloat(reader.GetDouble(index));
                case "Decimal":
                    return new PyFloat((double)reader.GetDecimal(index));
                case "Boolean":
                    return new PyBool(reader.GetBoolean(index));
                default:
                    Log.Error("Database", "Unhandled MySQL type " + type.Name);
                    break;
            }

            return null;
        }
コード例 #2
0
ファイル: Guild.cs プロジェクト: Dextan/Estrella
        public Guild(MySqlDataReader reader, MySqlConnection con)
        {
            ID = reader.GetInt32("ID");
            Name = reader.GetString("GuildName");
               // _Password = (byte[])reader.GetValue("Password");
            _Password = new byte[12];
            AllowGuildWar = reader.GetBoolean("AllowGuildWar");
            Message = reader.GetString("GuildMessage");
            MessageCreateTime = reader.GetDateTime(8);
            MessageCreaterID = reader.GetInt32("CreaterID");
            CreateTime = DateTime.Now;//read later
            GuildMoney = reader.GetInt64("GuildMoney");

            Members = new List<GuildMember>();
            ThreadLocker = new object();
            GuildStore = new GuildStorage(this);
            Load();
        }
コード例 #3
0
ファイル: seo_metadata.cs プロジェクト: seavan/bewell-travel
 public void LoadFromReader(MySqlDataReader _reader)
 {
     m_id = _reader["id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("id") : 0;
     mc_id = false;
     m_entity_id = _reader["entity_id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("entity_id") : 0;
     mc_entity_id = false;
     m_proto_name = _reader["proto_name"].GetType() != typeof(System.DBNull) ? _reader.GetString("proto_name") : "";
     mc_proto_name = false;
     m_url = _reader["url"].GetType() != typeof(System.DBNull) ? _reader.GetString("url") : "";
     mc_url = false;
     m_title = _reader["title"].GetType() != typeof(System.DBNull) ? _reader.GetString("title") : "";
     mc_title = false;
     m_keywords = _reader["keywords"].GetType() != typeof(System.DBNull) ? _reader.GetString("keywords") : "";
     mc_keywords = false;
     m_description = _reader["description"].GetType() != typeof(System.DBNull) ? _reader.GetString("description") : "";
     mc_description = false;
 }
コード例 #4
0
ファイル: field_values.cs プロジェクト: seavan/bewell-travel
 public void LoadFromReader(MySqlDataReader _reader)
 {
     m_id = _reader["id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("id") : 0;
     mc_id = false;
     m_entity_id = _reader["entity_id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("entity_id") : 0;
     mc_entity_id = false;
     m_proto_name = _reader["proto_name"].GetType() != typeof(System.DBNull) ? _reader.GetString("proto_name") : "";
     mc_proto_name = false;
     m_field_id = _reader["field_id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("field_id") : 0;
     mc_field_id = false;
     m_field_value = _reader["field_value"].GetType() != typeof(System.DBNull) ? _reader.GetString("field_value") : "";
     mc_field_value = false;
 }
コード例 #5
0
        private static UserRecord MapUserRecord(MySqlDataReader dr)
        {
            var record = new UserRecord();

            record.Id = dr.GetInt64("id");
            record.LastUpdated = dr.GetDateTime("lastUpdated");
            record.Losses = dr.GetInt32("losses");
            record.RecordType = (RecordType)dr.GetInt32("type");
            record.Ties = dr.GetInt32("ties");
            record.UserId = dr.GetInt64("userId");
            record.UserName = dr.GetString("userName");
            record.Wins = dr.GetInt32("wins");

            if (!dr.IsDBNull(dr.GetOrdinal("season")))
            {
                record.Season = dr.GetInt32("season");
            }

            if (!dr.IsDBNull(dr.GetOrdinal("seasonType")))
            {
                record.SeasonType = (SeasonType) dr.GetInt32("seasonType");
            }

            if (!dr.IsDBNull(dr.GetOrdinal("week")))
            {
                record.Week = dr.GetInt32("week");
            }

            return record;
        }
コード例 #6
0
        public void setProperty(MySqlDataReader reader)
        {
            this._Name = reader.GetString(reader.GetOrdinal("Name"));
            this._Engine = reader.GetString(reader.GetOrdinal("Engine"));
            this._Version = reader.GetInt64(reader.GetOrdinal("Version"));
            this._Row_format = reader.GetString(reader.GetOrdinal("Row_format"));
            if (!reader.IsDBNull(reader.GetOrdinal("Rows")))
            {
                this._Rows = reader.GetInt64(reader.GetOrdinal("Rows"));
            }
            this._Avg_row_length = reader.GetInt64(reader.GetOrdinal("Avg_row_length"));
            this._Data_length = reader.GetInt64(reader.GetOrdinal("Data_length"));
            this._Max_data_length = reader.GetInt64(reader.GetOrdinal("Max_data_length"));
            this._Index_length = reader.GetInt64(reader.GetOrdinal("Index_length"));
            this._Data_free = reader.GetInt64(reader.GetOrdinal("Data_free"));
            if (!reader.IsDBNull(reader.GetOrdinal("Auto_increment")))
            {
                this._Auto_increment = reader.GetInt64(reader.GetOrdinal("Auto_increment"));
            }

            if (!reader.IsDBNull(reader.GetOrdinal("Create_time")))
            {
                this._Create_time = reader.GetDateTime(reader.GetOrdinal("Create_time"));
            }
            if (!reader.IsDBNull(reader.GetOrdinal("Update_time")))
            {
                this._Update_time = reader.GetDateTime(reader.GetOrdinal("Update_time"));
            }

            if (!reader.IsDBNull(reader.GetOrdinal("Check_time")))
            {
                this._Check_time = reader.GetDateTime(reader.GetOrdinal("Check_time"));
            }
            this._Collation = reader.GetString(reader.GetOrdinal("Collation"));
            if (!reader.IsDBNull(reader.GetOrdinal("Checksum")))
            {
                this._Checksum = reader.GetInt64(reader.GetOrdinal("Checksum"));
            }
            this._Create_options = reader.GetString(reader.GetOrdinal("Create_options"));
            this._Comment = reader.GetString(reader.GetOrdinal("Comment"));
        }
コード例 #7
0
ファイル: cure_profiles.cs プロジェクト: seavan/bewell-travel
 public void LoadFromReader(MySqlDataReader _reader)
 {
     m_id = _reader["id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("id") : 0;
     mc_id = false;
     m_title = _reader["title"].GetType() != typeof(System.DBNull) ? _reader.GetString("title") : "";
     mc_title = false;
     m_gender_id = _reader["gender_id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("gender_id") : 0;
     mc_gender_id = false;
     m_css_class = _reader["css_class"].GetType() != typeof(System.DBNull) ? _reader.GetString("css_class") : "";
     mc_css_class = false;
     m_item_order = _reader["item_order"].GetType() != typeof(System.DBNull) ? _reader.GetInt32("item_order") : 0;
     mc_item_order = false;
 }
コード例 #8
0
ファイル: entity_fields.cs プロジェクト: seavan/bewell-travel
 public void LoadFromReader(MySqlDataReader _reader)
 {
     m_id = _reader["id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("id") : 0;
     mc_id = false;
     m_title = _reader["title"].GetType() != typeof(System.DBNull) ? _reader.GetString("title") : "";
     mc_title = false;
     m_fieldsets = _reader["fieldsets"].GetType() != typeof(System.DBNull) ? _reader.GetString("fieldsets") : "";
     mc_fieldsets = false;
     m_announce_order = _reader["announce_order"].GetType() != typeof(System.DBNull) ? _reader.GetInt32("announce_order") : 0;
     mc_announce_order = false;
     m_show_in_announce = _reader["show_in_announce"].GetType() != typeof(System.DBNull) ? _reader.GetBoolean("show_in_announce") : false;
     mc_show_in_announce = false;
     m_controller = _reader["controller"].GetType() != typeof(System.DBNull) ? _reader.GetString("controller") : "";
     mc_controller = false;
     m_action = _reader["action"].GetType() != typeof(System.DBNull) ? _reader.GetString("action") : "";
     mc_action = false;
 }
コード例 #9
0
ファイル: deseases.cs プロジェクト: seavan/bewell-travel
 public void LoadFromReader(MySqlDataReader _reader)
 {
     m_id = _reader["id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("id") : 0;
     mc_id = false;
     m_icd_code = _reader["icd_code"].GetType() != typeof(System.DBNull) ? _reader.GetString("icd_code") : "";
     mc_icd_code = false;
     m_title = _reader["title"].GetType() != typeof(System.DBNull) ? _reader.GetString("title") : "";
     mc_title = false;
     m_international_title = _reader["international_title"].GetType() != typeof(System.DBNull) ? _reader.GetString("international_title") : "";
     mc_international_title = false;
     m_profile_id = _reader["profile_id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("profile_id") : 0;
     mc_profile_id = false;
 }
コード例 #10
0
ファイル: territories.cs プロジェクト: seavan/bewell-travel
 public void LoadFromReader(MySqlDataReader _reader)
 {
     m_id = _reader["id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("id") : 0;
     mc_id = false;
     m_title = _reader["title"].GetType() != typeof(System.DBNull) ? _reader.GetString("title") : "";
     mc_title = false;
     m_parent_id = _reader["parent_id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("parent_id") : 0;
     mc_parent_id = false;
     m_category_id = _reader["category_id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("category_id") : 0;
     mc_category_id = false;
     m_nested_category_id = _reader["nested_category_id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("nested_category_id") : 0;
     mc_nested_category_id = false;
     m_item_order = _reader["item_order"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("item_order") : 0;
     mc_item_order = false;
     m_in_search = _reader["in_search"].GetType() != typeof(System.DBNull) ? _reader.GetBoolean("in_search") : false;
     mc_in_search = false;
     m_map_key = _reader["map_key"].GetType() != typeof(System.DBNull) ? _reader.GetString("map_key") : "";
     mc_map_key = false;
 }
コード例 #11
0
ファイル: fieldsets.cs プロジェクト: seavan/bewell-travel
 public void LoadFromReader(MySqlDataReader _reader)
 {
     m_id = _reader["id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("id") : 0;
     mc_id = false;
     m_title = _reader["title"].GetType() != typeof(System.DBNull) ? _reader.GetString("title") : "";
     mc_title = false;
     m_url = _reader["url"].GetType() != typeof(System.DBNull) ? _reader.GetString("url") : "";
     mc_url = false;
     m_proto_name = _reader["proto_name"].GetType() != typeof(System.DBNull) ? _reader.GetString("proto_name") : "";
     mc_proto_name = false;
     m_order_number = _reader["order_number"].GetType() != typeof(System.DBNull) ? _reader.GetInt32("order_number") : 0;
     mc_order_number = false;
     m_show_gallery = _reader["show_gallery"].GetType() != typeof(System.DBNull) ? _reader.GetBoolean("show_gallery") : false;
     mc_show_gallery = false;
     m_show_map = _reader["show_map"].GetType() != typeof(System.DBNull) ? _reader.GetBoolean("show_map") : false;
     mc_show_map = false;
     m_show_in_anounce = _reader["show_in_anounce"].GetType() != typeof(System.DBNull) ? _reader.GetBoolean("show_in_anounce") : false;
     mc_show_in_anounce = false;
 }
コード例 #12
0
 public void LoadFromReader(MySqlDataReader _reader)
 {
     m_id = _reader["id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("id") : 0;
     mc_id = false;
     m_fieldset_id = _reader["fieldset_id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("fieldset_id") : 0;
     mc_fieldset_id = false;
     m_field_id = _reader["field_id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("field_id") : 0;
     mc_field_id = false;
     m_order_number = _reader["order_number"].GetType() != typeof(System.DBNull) ? _reader.GetInt32("order_number") : 0;
     mc_order_number = false;
 }
コード例 #13
0
ファイル: pages.cs プロジェクト: seavan/bewell-travel
 public void LoadFromReader(MySqlDataReader _reader)
 {
     m_id = _reader["id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("id") : 0;
     mc_id = false;
     m_parent_id = _reader["parent_id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("parent_id") : 0;
     mc_parent_id = false;
     m_title = _reader["title"].GetType() != typeof(System.DBNull) ? _reader.GetString("title") : "";
     mc_title = false;
     m_publish_date = _reader["publish_date"].GetType() != typeof(System.DBNull) ? _reader.GetDateTime("publish_date") : DateTime.MinValue;
     mc_publish_date = false;
     m_html = _reader["html"].GetType() != typeof(System.DBNull) ? _reader.GetString("html") : "";
     mc_html = false;
     m_alias = _reader["alias"].GetType() != typeof(System.DBNull) ? _reader.GetString("alias") : "";
     mc_alias = false;
 }
コード例 #14
0
 private static LeagueMember MapLeagueMember(MySqlDataReader dr)
 {
     return new LeagueMember
         {
             Id = dr.GetInt64("id"),
             IsActive = dr.GetBoolean("active"),
             Joined = dr.GetDateTime("joined"),
             LeagueId = dr.GetInt64("leagueId"),
             UserId = dr.GetInt64("userId"),
             UserName = dr.GetString("userName")
         };
 }
コード例 #15
0
 private static League MapLeague(MySqlDataReader dr)
 {
     return new League
         {
             Created = dr.GetDateTime("created"),
             CreatorUserId = dr.GetInt64("creatorUserId"),
             CreatorUserName = dr.GetString("creatorUserName"),
             Id = dr.GetInt64("id"),
             IsActive = dr.GetBoolean("active"),
             Name = dr.GetString("name"),
             OwnerUserId = dr.GetInt64("ownerUserId"),
             OwnerUserName = dr.GetString("ownerUserName"),
             Sport = (SportType) dr.GetInt32("sportId")
         };
 }
コード例 #16
0
        private static LeagueInvitation MapInvitation(MySqlDataReader dr)
        {
            var invite = new LeagueInvitation
                {
                    Created = dr.GetDateTime("created"),
                    Email = dr.GetString("email"),
                    Id = dr.GetInt64("id"),
                    InvitationToken = dr.GetString("inviteToken"),
                    LeagueId = dr.GetInt64("leagueId"),
                    SentByUserId = dr.GetInt64("sentByUserId"),
                    Status = (InviteStatus) dr.GetInt32("status")
                };

            var userIdOrdinal = dr.GetOrdinal("userId");
            var inviteSentOnOrdinal = dr.GetOrdinal("inviteSentOn");
            var acceptedOnOrdinal = dr.GetOrdinal("acceptedOn");

            if (!dr.IsDBNull(userIdOrdinal))
            {
                invite.UserId = dr.GetInt64("userId");
            }

            if (!dr.IsDBNull(inviteSentOnOrdinal))
            {
                invite.InviteSentOn = dr.GetDateTime("inviteSentOn");
            }

            if (!dr.IsDBNull(acceptedOnOrdinal))
            {
                invite.AcceptedOn = dr.GetDateTime("acceptedOn");
            }

            return invite;
        }
コード例 #17
0
        private static UserPick MapUserPick(MySqlDataReader dr)
        {
            var pick = new UserPick
                {
                    GameId = dr.GetInt64("gameId"),
                    Id = dr.GetInt64("id"),
                    OptionId = dr.GetInt64("gameOptionId"),
                    OptionGroupId = dr.GetInt64("groupId"),
                    OptionType = (GameOptionType) dr.GetInt32("type"),
                    UserId = dr.GetInt64("userId")
                };

            var outcomeOrdinal = dr.GetOrdinal("outcome");

            if (!dr.IsDBNull(outcomeOrdinal))
            {
                pick.Outcome = (OptionOutcome) dr.GetInt32(outcomeOrdinal);
            }

            return pick;
        }
コード例 #18
0
        private ShoppingCart BuildObject(MySqlDataReader reader)
        {
            if (!reader.Read()) return null;
            var cart = new ShoppingCart();
            do {
                cart.Items.Add(new ShoppingCart.ShoppingCartItem {
                    Product = new Product {
                        Id = reader.GetInt64("ProductId"),
                        Name = reader.GetString("Name"),
                        Price = reader.GetDecimal("Price"),
                        Description = reader.GetString("Description"),
                    },
                    Quantity = reader.GetInt32("Quantity"),
                });
            } while (reader.Read());

            return cart;
        }
コード例 #19
0
        private void RecordUserData()
        {
            try
            {
                String userData = this.username.Text;
                String pass = this.password.Password;
                String role = "";
                if (this.user.IsChecked == true)
                {
                    role = "user";
                }
                else
                {
                    role = "admin";
                }
                String sqlInsert = "INSERT user (username, password, role) VALUES(@username, @password, @role)";
                String sqlCheck = "SELECT COUNT(*) FROM user WHERE username=@username";
                CheckStateDB();
                System.Security.Cryptography.MD5 md5 = System.Security.Cryptography.MD5.Create();
                byte[] inputBytes = System.Text.Encoding.ASCII.GetBytes(pass);
                byte[] hash = md5.ComputeHash(inputBytes);

                StringBuilder sb = new StringBuilder();
                for (int i = 0; i < hash.Length; i++)
                {
                    sb.Append(hash[i].ToString("X2"));
                }
                pass = sb.ToString().ToLower();
                cmd = new MySqlCommand(sqlCheck, conn);
                cmd.Parameters.AddWithValue("@username", EncoderUTF(userData));
                reader = cmd.ExecuteReader();
                reader.Read();
                if (reader.GetInt64(0) > 0)
                {
                    reader.Close();
                    throw new Exception("exists");
                }
                else
                {
                    reader.Close();
                    cmd = new MySqlCommand(sqlInsert, conn);
                    cmd.Parameters.AddWithValue("@username", EncoderUTF(userData));
                    cmd.Parameters.AddWithValue("@password", pass);
                    cmd.Parameters.AddWithValue("@role", role);
                    cmd.ExecuteNonQuery();
                    MessageBox.Show("บันทึกข้อมูลสมาชิกแล้ว", "สถานะการบันทึก");
                    ClearScreen();
                }
                
            }
            catch (Exception er)
            {
                ErrorLogCreate(er);
                MessageBox.Show("มี username นี้แล้วหรือลืมใส่รหัสผ่าน", "สถานะการบันทึก");
            }



        }
コード例 #20
0
ファイル: Db.cs プロジェクト: rodzflores/nationalElectin2014
 //getLast inserted id method
 public double getLastId()
 {
     double id = 0d;
     string sql;
     MySqlCommand comm = new MySqlCommand();
     sql = "SELECT last_insert_id()";
     comm.CommandText = sql;
     comm.Connection = this.conn;
     //this.reader = comm.ExecuteReader();
     this.reader = this.execute(comm.CommandText);
     while (reader.Read())
     {
         id = reader.GetInt64(0);
     }
     this.reader.Close();
     return id;
 }
コード例 #21
0
        private static Option<Team> MapOption(MySqlDataReader dr)
        {
            var option = new Option<Team>
                {
                    CutOff = dr.GetDateTime("cutOffTime"),
                    GameId = dr.GetInt64("gameId"),
                    GroupId = dr.GetInt64("groupId"),
                    Id = dr.GetInt64("id"),
                    Team = new Team
                        {
                            Id = dr.GetInt32("teamId")
                        },
                    Type = (GameOptionType) dr.GetInt32("type")
                };

            if (dr["value"] != DBNull.Value)
            {
                option.Value = dr.GetDecimal("value");
            }

            if (dr["outcome"] != DBNull.Value)
            {
                option.Outcome = (OptionOutcome) dr.GetInt32("outcome");
                option.IsWinner = option.Outcome.Value == OptionOutcome.Won;
            }

            option.CutOff = option.CutOff.AddDays(ConfigSettings.GameTimeOffSetInDays);
            option.IsPastCutOff = DateTime.UtcNow >= option.CutOff;

            return option;
        }
コード例 #22
0
ファイル: UserRepository.cs プロジェクト: hecubu5/sportpicks
 private static User MapUser(MySqlDataReader dr)
 {
     return new User
         {
             AuthToken = new AuthToken
                 {
                     Expiration = dr.GetDateTime("authTokenExpiration"),
                     Token = dr.GetString("authToken"),
                     UserId = dr.GetInt64("id"),
                     UserName = dr.GetString("userName")
                 },
             Email = dr.GetString("email"),
             JoinedOn = dr.GetDateTime("joinedOn"),
             Id = dr.GetInt64("id"),
             PasswordHash = dr.GetString("password"),
             Salt = dr.GetString("salt"),
             Status = (UserStatus) dr.GetInt32("statusID"),
             UserName = dr.GetString("userName")
         };
 }
コード例 #23
0
ファイル: accounts.cs プロジェクト: seavan/bewell-travel
 public void LoadFromReader(MySqlDataReader _reader)
 {
     m_id = _reader["id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("id") : 0;
     mc_id = false;
     m_email = _reader["email"].GetType() != typeof(System.DBNull) ? _reader.GetString("email") : "";
     mc_email = false;
     m_firstname = _reader["firstname"].GetType() != typeof(System.DBNull) ? _reader.GetString("firstname") : "";
     mc_firstname = false;
     m_lastname = _reader["lastname"].GetType() != typeof(System.DBNull) ? _reader.GetString("lastname") : "";
     mc_lastname = false;
     m_secondname = _reader["secondname"].GetType() != typeof(System.DBNull) ? _reader.GetString("secondname") : "";
     mc_secondname = false;
     m_role_id = _reader["role_id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("role_id") : 0;
     mc_role_id = false;
     m_post = _reader["post"].GetType() != typeof(System.DBNull) ? _reader.GetString("post") : "";
     mc_post = false;
     m_created = _reader["created"].GetType() != typeof(System.DBNull) ? _reader.GetDateTime("created") : DateTime.MinValue;
     mc_created = false;
     m_password = _reader["password"].GetType() != typeof(System.DBNull) ? _reader.GetString("password") : "";
     mc_password = false;
     m_salt = _reader["salt"].GetType() != typeof(System.DBNull) ? !String.IsNullOrEmpty(_reader["salt"].ToString()) ? _reader.GetGuid("salt") : new System.Guid() : new System.Guid();
     mc_salt = false;
     m_activation_guid = _reader["activation_guid"].GetType() != typeof(System.DBNull) ? !String.IsNullOrEmpty(_reader["activation_guid"].ToString()) ? _reader.GetGuid("activation_guid") : new System.Guid() : new System.Guid();
     mc_activation_guid = false;
     m_lastlogin = _reader["lastlogin"].GetType() != typeof(System.DBNull) ? _reader.GetDateTime("lastlogin") : DateTime.MinValue;
     mc_lastlogin = false;
     m_rememberpass_guid = _reader["rememberpass_guid"].GetType() != typeof(System.DBNull) ? !String.IsNullOrEmpty(_reader["rememberpass_guid"].ToString()) ? _reader.GetGuid("rememberpass_guid") : new System.Guid() : new System.Guid();
     mc_rememberpass_guid = false;
 }
コード例 #24
0
ファイル: ReviewPanel.cs プロジェクト: ocy1011/Capstone
    public void ReadReviews()
    {
        int   productID = product.id;
        int   count     = DbConnecter.instance.Count("productID", "review", "productID = " + productID + ";");
        float anchorGap = 0.3f;
        float firstYMax = 0.75f;
        float lastYMax  = 0;
        int   maxRange  = Mathf.Clamp(count - reviewUnits.Count, 0, count);
        int   minRange  = Mathf.Clamp(maxRange - oneLoadAmount, 0, maxRange);

        if (maxRange > 0)
        {
            string sql = "SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY(dateTime) DESC) AS id, email, productID, score, first, second, third, fourth, fifth FROM review WHERE productID = " + productID + ") newtable WHERE id <=" + maxRange + " AND id >" + minRange + "; ";

            /*
             * string sql = @"SELECT *
             *         FROM (
             *                  SELECT ROW_NUMBER() OVER(ORDER BY(dateTime) DESC) AS id, *
             *                  FROM review
             *                  WHERE productID = " + productID +
             *            @") newtable
             *          WHERE id <=" + maxRange + " AND id >" + minRange + "; ";
             */
            MySql.Data.MySqlClient.MySqlDataReader reader = DbConnecter.instance.Reader(sql);
            while (reader.Read())
            {
                Transform newReviewUnit = Instantiate(reviewUnit);
                newReviewUnit.SetParent(content.transform);
                RectTransform rectTransform = newReviewUnit.GetComponent <RectTransform>();
                int           reviewCount   = reviewUnits.Count;
                float         yMax          = firstYMax - anchorGap * reviewCount;
                float         yMin          = yMax - anchorGap;
                lastYMax = yMin;
                rectTransform.anchorMax = new Vector2(1, yMax);
                rectTransform.anchorMin = new Vector2(0, yMin);
                rectTransform.offsetMin = Vector2.zero;
                rectTransform.offsetMax = Vector2.zero;


                Review review = new Review();
                review.id        = (int)reader.GetInt64(0);
                review.email     = reader.GetString(1);
                review.productID = reader.GetInt32(2);
                review.score     = reader.GetInt32(3);
                review.first     = reader.GetInt32(4);
                review.second    = reader.GetInt32(5);
                review.third     = reader.GetInt32(6);
                review.fourth    = reader.GetInt32(7);
                review.fifth     = reader.GetInt32(8);


                ReviewUnit reviewUnitInfo = newReviewUnit.GetComponent <ReviewUnit>();
                reviewUnitInfo.Change(review, gameObject);
                reviewUnits.Add(reviewUnitInfo);
            }
            reader.Close();
            DbConnecter.instance.CloseConnection();
        }
        else
        {
            Debug.Log("불러올 리뷰가 없습니다");
        }
        if (lastYMax < 0)
        {
            float contentSize = content.getInitialContentYSize() * (1 - (lastYMax));
            content.ChangeSize(contentSize);
        }
        else
        {
            float contentSize = content.getInitialContentYSize();
            content.ChangeSize(contentSize);
        }
    }
コード例 #25
0
ファイル: prices.cs プロジェクト: seavan/bewell-travel
 public void LoadFromReader(MySqlDataReader _reader)
 {
     m_id = _reader["id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("id") : 0;
     mc_id = false;
     m_entity_id = _reader["entity_id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("entity_id") : 0;
     mc_entity_id = false;
     m_proto_name = _reader["proto_name"].GetType() != typeof(System.DBNull) ? _reader.GetString("proto_name") : "";
     mc_proto_name = false;
     m_month = _reader["month"].GetType() != typeof(System.DBNull) ? _reader.GetByte("month") : (byte)0;
     mc_month = false;
     m_price = _reader["price"].GetType() != typeof(System.DBNull) ? _reader.GetFloat("price") : (double)0;
     mc_price = false;
     m_comment = _reader["comment"].GetType() != typeof(System.DBNull) ? _reader.GetString("comment") : "";
     mc_comment = false;
 }
コード例 #26
0
ファイル: resorts.cs プロジェクト: seavan/bewell-travel
 public void LoadFromReader(MySqlDataReader _reader)
 {
     m_id = _reader["id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("id") : 0;
     mc_id = false;
     m_title = _reader["title"].GetType() != typeof(System.DBNull) ? _reader.GetString("title") : "";
     mc_title = false;
     m_territory_id = _reader["territory_id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("territory_id") : 0;
     mc_territory_id = false;
     m_cure_profiles = _reader["cure_profiles"].GetType() != typeof(System.DBNull) ? _reader.GetString("cure_profiles") : "";
     mc_cure_profiles = false;
     m_ad_cure_profiles = _reader["ad_cure_profiles"].GetType() != typeof(System.DBNull) ? _reader.GetString("ad_cure_profiles") : "";
     mc_ad_cure_profiles = false;
     m_health_factors = _reader["health_factors"].GetType() != typeof(System.DBNull) ? _reader.GetString("health_factors") : "";
     mc_health_factors = false;
     m_is_recomended = _reader["is_recomended"].GetType() != typeof(System.DBNull) ? _reader.GetBoolean("is_recomended") : false;
     mc_is_recomended = false;
     m_coordinates = _reader["coordinates"].GetType() != typeof(System.DBNull) ? _reader.GetString("coordinates") : "";
     mc_coordinates = false;
     m_noyayesgo = _reader["noyayesgo"].GetType() != typeof(System.DBNull) ? _reader.GetBoolean("noyayesgo") : false;
     mc_noyayesgo = false;
     m_is_published = _reader["is_published"].GetType() != typeof(System.DBNull) ? _reader.GetBoolean("is_published") : false;
     mc_is_published = false;
 }
コード例 #27
0
ファイル: dictionary.cs プロジェクト: seavan/bewell-travel
 public void LoadFromReader(MySqlDataReader _reader)
 {
     m_id = _reader["id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("id") : 0;
     mc_id = false;
     m_word = _reader["word"].GetType() != typeof(System.DBNull) ? _reader.GetString("word") : "";
     mc_word = false;
     m_translate = _reader["translate"].GetType() != typeof(System.DBNull) ? _reader.GetString("translate") : "";
     mc_translate = false;
     m_explanation = _reader["explanation"].GetType() != typeof(System.DBNull) ? _reader.GetString("explanation") : "";
     mc_explanation = false;
 }
コード例 #28
0
ファイル: MsgrDb.cs プロジェクト: ClutchMAV/aura-2
		/// <summary>
		/// Reads note from reader, returns null on error.
		/// </summary>
		/// <param name="reader"></param>
		/// <returns></returns>
		private Note ReadNote(MySqlDataReader reader)
		{
			var note = new Note();

			note.Id = reader.GetInt64("noteId");
			note.Sender = reader.GetStringSafe("sender");
			note.Receiver = reader.GetStringSafe("receiver");
			note.Message = reader.GetStringSafe("message");
			note.Time = reader.GetDateTimeSafe("time");
			note.Read = reader.GetBoolean("read");

			var split = note.Sender.Split('@');
			if (split.Length != 2)
				return null;

			note.FromCharacterName = split[0];
			note.FromServer = split[1];

			return note;
		}
コード例 #29
0
 public void LoadFromReader(MySqlDataReader _reader)
 {
     m_id = _reader["id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("id") : 0;
     mc_id = false;
     m_title = _reader["title"].GetType() != typeof(System.DBNull) ? _reader.GetString("title") : "";
     mc_title = false;
 }
コード例 #30
0
 public void LoadFromReader(MySqlDataReader _reader)
 {
     m_id = _reader["id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("id") : 0;
     mc_id = false;
     m_title = _reader["title"].GetType() != typeof(System.DBNull) ? _reader.GetString("title") : "";
     mc_title = false;
     m_parent_id = _reader["parent_id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("parent_id") : 0;
     mc_parent_id = false;
     m_show_on_sitemap = _reader["show_on_sitemap"].GetType() != typeof(System.DBNull) ? _reader.GetBoolean("show_on_sitemap") : false;
     mc_show_on_sitemap = false;
 }
コード例 #31
0
ファイル: resort_zones.cs プロジェクト: seavan/bewell-travel
 public void LoadFromReader(MySqlDataReader _reader)
 {
     m_id = _reader["id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("id") : 0;
     mc_id = false;
     m_title = _reader["title"].GetType() != typeof(System.DBNull) ? _reader.GetString("title") : "";
     mc_title = false;
     m_territory_id = _reader["territory_id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("territory_id") : 0;
     mc_territory_id = false;
     m_health_factors = _reader["health_factors"].GetType() != typeof(System.DBNull) ? _reader.GetString("health_factors") : "";
     mc_health_factors = false;
     m_treatment_options = _reader["treatment_options"].GetType() != typeof(System.DBNull) ? _reader.GetString("treatment_options") : "";
     mc_treatment_options = false;
 }