예제 #1
0
        private bool user_checkOut(string loginID, string password)
        {
            bool          login         = false;
            SqlConnection sqlconnection = new SqlConnection(conStr);

            string comStr = string.Format("select Student_REGISTRED,Student_PASSWORD, Student_NAME from dboStudent where Student_IID = \'{0}\'", loginID);

            dataSet = new DataSet();
            dataSet.Clear();
            dataSet = SqlCommondClass.GetDataSet(comStr, "dboStudent", sqlconnection);
            if (dataSet.Tables[0].Rows.Count == 0)
            {
                login = false;
                return(login);
            }

            if (dataSet.Tables[0].Rows[0][0].ToString().Trim().Equals("True"))
            {
                if (dataSet.Tables[0].Rows[0][1].ToString().Trim().Equals(password.Trim()))
                {
                    this.loginName = dataSet.Tables[0].Rows[0][2].ToString().Trim();
                    login          = true;
                    return(login);
                }
            }
            else
            {
                MessageBox.Show("您还没有注册登账户!");
            }

            return(login);
        }
예제 #2
0
        private void textBoxId_TextChanged(object sender, EventArgs e)
        {
            string        registerId    = this.textBoxId.Text.Trim();
            string        registerName  = this.textBoxName.Text.Trim();
            string        comStr        = string.Format("select Student_SEX, Student_BIRTHDAY, Student_DEPT, Student_MAJOR from dboStudent where Student_IID = \'{0}\' and Student_NAME = \'{1}\'", registerId, registerName);
            SqlConnection sqlconnection = new SqlConnection(conStr);

            try
            {
                sqlconnection.Open();
                DataSet dataSet = SqlCommondClass.GetDataSet(comStr, "dboStudent", sqlconnection);
                if (dataSet.Tables[0].Rows.Count >= 1)
                {
                    this.textBoxSex.Text    = dataSet.Tables[0].Rows[0]["Student_SEX"].ToString().Trim();
                    this.textBoxBirth.Text  = dataSet.Tables[0].Rows[0]["Student_BIRTHDAY"].ToString().Substring(0, dataSet.Tables[0].Rows[0]["Student_BIRTHDAY"].ToString().IndexOf(" "));
                    this.textBoxDepart.Text = dataSet.Tables[0].Rows[0]["Student_DEPT"].ToString().Trim();
                    this.textBoxMajor.Text  = dataSet.Tables[0].Rows[0]["Student_MAJOR"].ToString().Trim();
                }
            }
            catch (Exception) { }
            finally
            {
                sqlconnection.Close();
            }
        }
예제 #3
0
        private bool admin_checkOut(string loginID, string password)
        {
            bool          login         = false;
            SqlConnection sqlconnection = new SqlConnection(conStr);

            string comStr = string.Format("select Sys_NAME, Sys_PASSWORD from dboSys where Sys_IID = \'{0}\'", loginID);

            dataSet = new DataSet();
            dataSet.Clear();
            dataSet = SqlCommondClass.GetDataSet(comStr, "dboSys", sqlconnection);

            if (dataSet.Tables[0].Rows.Count == 0)
            {
                login = false;
                return(login);
            }
            if (dataSet.Tables[0].Rows[0][1].ToString().Trim().Equals(password.Trim()))
            {
                this.sysLogin  = true;
                this.loginName = dataSet.Tables[0].Rows[0][0].ToString().Trim();
                login          = true;
                return(login);
            }

            return(login);
        }
예제 #4
0
        private void btnSearch_Click(object sender, EventArgs e)
        {
            string textStr   = this.textBox1.Text.Trim();
            string searchStr = "'";

            if (textStr.Equals(""))
            {
                return;
            }

            for (int Strlen = 0; Strlen < textStr.Length; Strlen++)
            {
                searchStr += "%" + textStr.ElementAt(Strlen);
            }
            searchStr += "%'";

            SqlConnection sqlconnection = new SqlConnection(conStr);
            string        comStr;

            comStr = "select Book_NAME 图书名,Book_MAINAUTHOR 主编,Book_SEARCHID 检索号,Book_CLASS 图书类别,Book_PUBLISHER 出版社,Book_INTRODUCTION 图书简介,Book_REMAIN 剩余量"
                     + " from dboBook where Book_MAINAUTHOR Like " + searchStr
                     + " OR Book_AUTHOR1 Like " + searchStr
                     + " OR Book_AUTHOR2 Like " + searchStr
                     + " OR Book_AUTHOR3 Like " + searchStr
                     + " OR Book_SEARCHID Like " + searchStr
                     + " OR Book_CLASS Like " + searchStr
                     + " OR Book_PUBLISHER Like " + searchStr
                     + " OR Book_INTRODUCTION Like " + searchStr;


            DataSet dataSet = SqlCommondClass.GetDataSet(comStr, "dboBook", sqlconnection);

            this.dataGridView1.DataSource = dataSet.Tables[0];
        }
예제 #5
0
        private void textBoxISBN_TextChanged(object sender, EventArgs e)
        {
            string ISBN = this.textBoxISBN.Text.Trim();

            string comStr = string.Format("select Book_NAME, Book_MAINAUTHOR, Book_AUTHOR1,Book_AUTHOR2,Book_AUTHOR2,Book_SEARCHID, Book_CLASS,"
                                          + "Book_PRICE,Book_PUBLISHER,Book_TOTAL,Book_REMAIN,Book_INTRODUCTION from dboBook "
                                          + "where Book_ISBN = \'{0}\'", ISBN);
            SqlConnection sqlconnection = new SqlConnection(conStr);

            try
            {
                sqlconnection.Open();
                DataSet dataSet = SqlCommondClass.GetDataSet(comStr, "result", sqlconnection);
                if (dataSet.Tables[0].Rows.Count >= 1)
                {
                    existBook = true;
                    this.textBoxBookName.Text    = dataSet.Tables[0].Rows[0]["Book_NAME"].ToString();
                    this.textBoxMainAuthor.Text  = dataSet.Tables[0].Rows[0]["Book_MAINAUTHOR"].ToString();
                    this.textBoxOtherAuthor.Text = dataSet.Tables[0].Rows[0]["Book_AUTHOR1"].ToString() + " "
                                                   + dataSet.Tables[0].Rows[0]["Book_AUTHOR2"].ToString() + " "
                                                   + dataSet.Tables[0].Rows[0]["Book_AUTHOR2"].ToString();
                    this.textBoxSearchId.Text  = dataSet.Tables[0].Rows[0]["Book_SEARCHID"].ToString();
                    this.textBoxBookClass.Text = dataSet.Tables[0].Rows[0]["Book_CLASS"].ToString();
                    this.textBoxPrice.Text     = dataSet.Tables[0].Rows[0]["Book_PRICE"].ToString();
                    this.textBoxPublisher.Text = dataSet.Tables[0].Rows[0]["Book_PUBLISHER"].ToString();
                    this.textBoxTotal.Text     = dataSet.Tables[0].Rows[0]["Book_TOTAL"].ToString();
                    this.textBoxRemain.Text    = dataSet.Tables[0].Rows[0]["Book_REMAIN"].ToString();
                    this.textBoxBriefInfo.Text = dataSet.Tables[0].Rows[0]["Book_INTRODUCTION"].ToString();
                }
                else
                {
                    existBook = false;
                    this.textBoxBookName.Text    = "";
                    this.textBoxMainAuthor.Text  = "";
                    this.textBoxOtherAuthor.Text = "";
                    this.textBoxSearchId.Text    = "";
                    this.textBoxBookClass.Text   = "";
                    this.textBoxPrice.Text       = "";
                    this.textBoxPublisher.Text   = "";
                    this.textBoxTotal.Text       = "";
                    this.textBoxRemain.Text      = "";
                    this.textBoxBriefInfo.Text   = "";
                }
            }
            catch (Exception)
            {
                MessageBox.Show("数据库操作失败!", "错误信息", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            finally
            {
                sqlconnection.Close();
            }
        }
예제 #6
0
        private void SuperbtnSearch_Click(object sender, EventArgs e)
        {
            string comStr = "select Book_NAME 图书名,Book_MAINAUTHOR 主编,Book_SEARCHID 检索号,Book_CLASS 图书类别,Book_PUBLISHER 出版社,Book_INTRODUCTION 图书简介,Book_REMAIN 剩余量"
                            + " from dboBook where ";

            string bookName    = this.textBookName.Text.Trim();
            string authorName  = this.textAuthorName.Text.Trim();
            string subjectName = this.textSubjectName.Text.Trim();
            string publishName = this.textPublishName.Text.Trim();
            string isbnName    = this.textISBNName.Text.Trim();

            if (bookName.Length > 1)
            {
                comStr += " Book_NAME = '" + bookName + "'";
            }

            if (authorName.Length > 1)
            {
                comStr += "and Book_MAINAUTHOR = '" + authorName + "'";
            }

            if (subjectName.Length > 1)
            {
                comStr += "and Book_CLASS = '" + subjectName + "'";
            }

            if (publishName.Length > 1)
            {
                comStr += "and Book_PUBLISHER = '" + publishName + "'";
            }

            if (isbnName.Length > 1)
            {
                comStr += "and Book_ISBN = '" + isbnName + "'";
            }

            SqlConnection sqlconnection = new SqlConnection(conStr);

            dataSet.Clear();
            dataSet = SqlCommondClass.GetDataSet(comStr, "dboBook", sqlconnection);

            if (dataSet.Tables[0].Rows.Count < 20)
            {
                for (int i = dataSet.Tables[0].Rows.Count; i < 20; i++)
                {
                    dataSet.Tables[0].Rows.Add();
                }
            }
            this.dataGridView1.DataSource = dataSet.Tables[0];
        }
예제 #7
0
        public void getSystemInfo(string loginID)
        {
            if (loginID.Equals(""))
            {
                return;
            }

            SqlConnection sqlconnection = new SqlConnection(conStr);
            string        comStr;

            comStr = "select Sys_NAME, Sys_SEX, Sys_BIRTHDAY from dboSys where Sys_IID = " + loginID;

            DataSet dataSet = SqlCommondClass.GetDataSet(comStr, "dboStudent", sqlconnection);

            name               = dataSet.Tables[0].Rows[0]["Sys_NAME"].ToString().Trim();
            sex                = dataSet.Tables[0].Rows[0]["Sys_SEX"].ToString().Trim();
            ID                 = loginID;
            birthday           = dataSet.Tables[0].Rows[0]["Sys_BIRTHDAY"].ToString().Trim();
            birthday           = birthday.Substring(0, 8);
            userClassification = "管理员";
            depart             = "";
            major              = "";
        }
예제 #8
0
        public void getUserInfo(string loginID)
        {
            if (loginID.Equals(""))
            {
                return;
            }

            SqlConnection sqlconnection = new SqlConnection(conStr);
            string        comStr;

            comStr = "select Student_NAME, Student_SEX, Student_BIRTHDAY, Student_TYPE,Student_DEPT, Student_MAJOR from dboStudent where Student_IID = " + loginID;

            DataSet dataSet = SqlCommondClass.GetDataSet(comStr, "dboStudent", sqlconnection);

            name               = dataSet.Tables[0].Rows[0][0].ToString().Trim();
            sex                = dataSet.Tables[0].Rows[0][1].ToString().Trim();
            ID                 = loginID;
            birthday           = dataSet.Tables[0].Rows[0][2].ToString().Trim();
            birthday           = birthday.Substring(0, 10);
            userClassification = dataSet.Tables[0].Rows[0][3].ToString().Trim();
            depart             = dataSet.Tables[0].Rows[0][4].ToString().Trim();
            major              = dataSet.Tables[0].Rows[0][5].ToString().Trim();
        }
예제 #9
0
        private void search(searchType searchtype)
        {
            SqlConnection sqlconnection = new SqlConnection(conStr);

            switch (searchtype)
            {
            case searchType.searchHistory:
            {
                try
                {
                    sqlconnection.Open();
                    string comStr = string.Format("select Book_ISBN 图书ISBN,Book_NAME 图书名,Book_MAINAUTHOR 主编, Book_SEARCHID 检索号,Book_CLASS 图书类别,Book_PUBLISHER 出版社,Book_INTRODUCTION 图书简介,Book_REMAIN 剩余量"
                                                  + " from dboBook,dboSearchRecord"
                                                  + " where dboBook.Book_ISBN=dboSearchRecord.SearchRecord_Book_ISBN and dboSearchRecord.SearchRecord_user_IID = \'{0}\'"
                                                  + " order by (dboSearchRecord.SearchRecord_COUNT)", loginID);

                    DataSet dataSet = SqlCommondClass.GetDataSet(comStr, "result", sqlconnection);
                    MostSearchFm.dataGridView1.DataSource = dataSet.Tables[0];
                }
                catch (System.Exception)
                {
                }
                finally
                {
                    sqlconnection.Close();
                }
                break;
            }

            case searchType.borrowHistory:
            {
                try
                {
                    sqlconnection.Open();
                    string comStr = string.Format("select Book_NAME 图书名,Borrow_BORROW_TIME 借书日期,Borrow_RETURN_TIME 还书日期, Book_MAINAUTHOR 主编, Book_SEARCHID 检索号,Book_CLASS 图书类别,Book_PUBLISHER 出版社,Book_INTRODUCTION 图书简介,Book_REMAIN 剩余量"
                                                  + " from dboBook,dboBorrow"
                                                  + " where dboBook.Book_ISBN = dboBorrow.Borrow_Book_ISBN and dboBorrow.Borrow_user_IID = \'{0}\' and dboBorrow.Borrow_BORROW_STATE = 1"
                                                  + " order by (dboBorrow.Borrow_BORROW_TIME)", loginID);

                    DataSet dataSet = SqlCommondClass.GetDataSet(comStr, "result", sqlconnection);
                    HistotySearchFm.dataGridView1.DataSource = dataSet.Tables[0];
                }
                catch (System.Exception)
                {
                }
                finally
                {
                    sqlconnection.Close();
                }
                break;
            }

            case searchType.borrowNow:
            {
                try
                {
                    string nowTime = DateTime.Now.Date.ToString().Substring(0, 10);
                    sqlconnection.Open();
                    string comStr = string.Format("select Book_NAME 图书名, DateDiff(day, Borrow_BORROW_TIME, '" + nowTime + "') AS 距还书日期_天, Book_MAINAUTHOR 主编,Book_SEARCHID 检索号,Book_CLASS 图书类别,Book_PUBLISHER 出版社,Book_INTRODUCTION 图书简介"
                                                  + " from dboBook,dboBorrow"
                                                  + " where dboBook.Book_ISBN=dboBorrow.Borrow_Book_ISBN and dboBorrow.Borrow_user_IID = \'{0}\' and dboBorrow.Borrow_BORROW_STATE=0"
                                                  + " order by DateDiff(day, Borrow_BORROW_TIME, Borrow_RETURN_TIME) asc", loginID);

                    DataSet dataSet = SqlCommondClass.GetDataSet(comStr, "result", sqlconnection);
                    BorrowingSearchFm.dataGridView1.DataSource = dataSet.Tables[0];
                }
                catch (System.Exception)
                {
                    MessageBox.Show("error");
                }
                finally
                {
                    sqlconnection.Close();
                }
                break;
            }
            }
        }
예제 #10
0
        private void btnRegist_Click(object sender, EventArgs e)
        {
            bool finished = true;

            string adminID    = this.textBoxID.Text.Trim();
            string adminName  = this.textBoxName.Text.Trim();
            string adminSex   = this.textBoxSex.Text.Trim();
            string adminBirth = this.textBoxBirth.Text.Substring(0, 10).Trim();

            if (adminID == "" || adminName == "" || adminSex == "" || adminBirth == "")
            {
                MessageBox.Show("请输入完整信息", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }

            if (this.textBoxPassword1.Text.Trim() != this.textBoxPassword2.Text.Trim())
            {
                MessageBox.Show("两次输入密码不一致", "错误信息", MessageBoxButtons.OK, MessageBoxIcon.Error);
                this.textBoxPassword1.Text = "";
                this.textBoxPassword2.Text = "";
                return;
            }
            string        adminPassword = this.textBoxPassword1.Text.Trim();
            string        comStr        = string.Format("select * from dboSys where Sys_IID = \'{0}\'", adminID);
            SqlConnection sqlconnection = new SqlConnection(conStr);
            DataSet       dataSet       = new DataSet();

            try
            {
                dataSet = SqlCommondClass.GetDataSet(comStr, "result", sqlconnection);
            }
            catch (System.Exception)
            {
                finished = false;
                MessageBox.Show("打开数据库失败", "错误信息", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }
            finally
            {
                sqlconnection.Close();
            }

            if (dataSet.Tables[0].Rows.Count >= 1)
            {
                MessageBox.Show("该管理员编号已经存在,可以直接登录", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }
            else
            {
                comStr = string.Format("insert into dboSys(Sys_IID,Sys_NAME,Sys_SEX,Sys_BIRTHDAY,Sys_PASSWORD) values(\'{0}\',\'{1}\',\'{2}\',\'{3}\',\'{4}\')",
                                       adminID, adminName, adminSex, adminBirth, coding(adminPassword));
                MessageBox.Show(comStr);
                try
                {
                    sqlconnection.Open();
                    SqlCommand command = new SqlCommand(comStr, sqlconnection);
                    MessageBox.Show(command.ToString());
                    command.ExecuteNonQuery();
                }
                catch (System.Exception)
                {
                    finished = false;
                    MessageBox.Show("创建管理员失败", "错误信息", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }
                finally
                {
                    sqlconnection.Close();
                }
                if (finished)
                {
                    MessageBox.Show("创建管理员成功");
                }
            }
        }