Пример #1
0
        public static LoginMessage queryLogin(LoginModel loginModel)
        {
            LoginMessage        loginMessage        = new LoginMessage();
            zAccountDetailModel zAccountDetailModel = new zAccountDetailModel();
            ReturnStatusModel   returnStatusModel   = new ReturnStatusModel();

            string CommandText = "SELECT * " +
                                 "FROM zAccount_Detail " +
                                 "WHERE " +
                                 "account_username = '******' " +
                                 "AND account_password ='******'";

            sqlConnection.Open();
            sqlCommand = sqlConnection.CreateCommand();

            using (SQLiteCommand cmd = new SQLiteCommand(CommandText, DatabaseConnection.sqlConnection))
            {
                using (SQLiteDataReader rdr = cmd.ExecuteReader())
                {
                    if (rdr.HasRows != false)
                    {
                        while (rdr.Read())
                        {
                            zAccountDetailModel.account_id               = (rdr["account_id"].ToString());
                            zAccountDetailModel.account_username         = (rdr["account_username"].ToString());
                            zAccountDetailModel.account_password         = (rdr["account_password"].ToString());
                            zAccountDetailModel.account_created_date     = (rdr["account_created_date"].ToString());
                            zAccountDetailModel.account_created_by       = (rdr["account_created_by"].ToString());
                            zAccountDetailModel.account_firstname        = (rdr["account_firstname"].ToString());
                            zAccountDetailModel.account_lastname         = (rdr["account_lastname"].ToString());
                            zAccountDetailModel.account_lastlogin_time   = (rdr["account_lastlogin_time"].ToString());
                            zAccountDetailModel.account_lastlogin_date   = (rdr["account_lastlogin_date"].ToString());
                            zAccountDetailModel.account_language_default = (rdr["account_language_default"].ToString());
                            zAccountDetailModel.account_role_id          = (rdr["account_role_id"].ToString());
                            zAccountDetailModel.account_expire_date      = (rdr["account_expire_date"].ToString());
                            zAccountDetailModel.account_status           = (rdr["account_status"].ToString());
                        }

                        returnStatusModel.status        = true;
                        returnStatusModel.error_message = Messages.m_login_success;
                    }
                    else
                    {
                        returnStatusModel.status        = false;
                        returnStatusModel.error_message = Messages.m_user_or_pass_inc;
                    }
                }
            }

            loginMessage.zAccountDetailModel = zAccountDetailModel;
            loginMessage.returnStatusModel   = returnStatusModel;

            sqlConnection.Close();

            return(loginMessage);
        }
Пример #2
0
        public static LoginMessage queryLoginUsername(LoginModel loginModel)
        {
            LoginMessage        loginMessage        = new LoginMessage();
            zAccountDetailModel zAccountDetailModel = new zAccountDetailModel();
            ReturnStatusModel   returnStatusModel   = new ReturnStatusModel();

            string CommandText = "SELECT account_username " +
                                 "FROM zAccount_Detail " +
                                 "WHERE " +
                                 "account_username = '******'";

            sqlConnection.Open();
            sqlCommand = sqlConnection.CreateCommand();

            using (SQLiteCommand cmd = new SQLiteCommand(CommandText, DatabaseConnection.sqlConnection))
            {
                using (SQLiteDataReader rdr = cmd.ExecuteReader())
                {
                    if (rdr.HasRows != false && rdr.Read())
                    {
                        zAccountDetailModel.account_username = (rdr["account_username"].ToString());
                        returnStatusModel.status             = false;
                        returnStatusModel.error_message      = Messages.m_pass_inc;
                    }
                    else
                    {
                        returnStatusModel.status        = false;
                        returnStatusModel.error_message = Messages.m_user_not_exist;
                    }
                }
            }

            loginMessage.zAccountDetailModel = zAccountDetailModel;
            loginMessage.returnStatusModel   = returnStatusModel;

            sqlConnection.Close();

            return(loginMessage);
        }