示例#1
0
        public void updateStatus(RemoteUser rUser)
        {//Set status
            this.connect();
            SqlCeCommand cmd = this.conn.CreateCommand();

            cmd.CommandText = "update " + TABLE_NAME + " set status='" + rUser.getStatus() + "'  where username='******' and system='" + rUser.getSystemName() + "'";
            cmd.ExecuteNonQuery();
            this.disconnect();
        }
 public void addUser(RemoteUser rUser)
 {
     //add new user
     this.connect();
     SqlCeCommand cmd = this.conn.CreateCommand();
     DateTime currentTime = DateTime.Now;
     cmd.CommandText = "insert into " + TABLE_NAME + "(system,username,password,modified_date,status) values('" + rUser.getSystemName() + "','" + rUser.getUsername() + "','" + rUser.getPassword() + "','" + currentTime.ToString() + "','" + rUser.getStatus() + "')";
     cmd.ExecuteNonQuery();
     this.disconnect();
 }
示例#3
0
        public void addUser(RemoteUser rUser)
        {//add new user
            this.connect();
            SqlCeCommand cmd         = this.conn.CreateCommand();
            DateTime     currentTime = DateTime.Now;

            cmd.CommandText = "insert into " + TABLE_NAME + "(system,username,password,modified_date,status) values('" + rUser.getSystemName() + "','" + rUser.getUsername() + "','" + rUser.getPassword() + "','" + currentTime.ToString() + "','" + rUser.getStatus() + "')";
            cmd.ExecuteNonQuery();
            this.disconnect();
        }
 public void updateStatus(RemoteUser rUser)
 {
     //Set status
     this.connect();
     SqlCeCommand cmd = this.conn.CreateCommand();
     cmd.CommandText = "update " + TABLE_NAME + " set status='" + rUser.getStatus() + "'  where username='******' and system='" + rUser.getSystemName() + "'";
     cmd.ExecuteNonQuery();
     this.disconnect();
 }