예제 #1
0
 public readerreserveModel(bookreserveModel model)
 {
     this.bookId = model.BookId;
     this.bookName = model.BookName;
     this.readerId = model.ReaderId;
     this.reserveDate = model.BorrowDate;
     this.returnDate = model.BorrowDate.AddDays(30);
 }
예제 #2
0
 public static List<bookreserveModel> GetModelList()
 {
     List<bookreserveModel> modellist = new List<bookreserveModel>();
     string sqlstring = "select * from bookInfo";
     SqlDataReader datareader = CommonDB.ExecuteReader(CommonDB.CONN_STRING, CommandType.Text, sqlstring, null);
     while (datareader.Read())
     {
         DateTime time;
         DateTime.TryParse(datareader["BookDate"].ToString(), out time);
         bookreserveModel model = new bookreserveModel(datareader["BookID"].ToString(), datareader["BookName"].ToString(), datareader["CardNum"].ToString(), time);
         modellist.Add(model);
     }
     return modellist;
 }
예제 #3
0
    public static void AddReverse(bookreserveModel model)
    {
        try
        {
            string sqlstring = "insert into bookreserve (BookID,BookName,ReaderID,ReserveDate) " +
                               "values (@bookid,@bookname,@readerid,@reservedate)";
            SqlParameter[] sqlpara = new SqlParameter[]{ new SqlParameter("@bookid", SqlDbType.VarChar), new SqlParameter("@bookname", SqlDbType.VarChar)
                , new SqlParameter("@readerid", SqlDbType.VarChar), new SqlParameter("@reservedate", SqlDbType.DateTime)};

            sqlpara[0].Value = model.BookId;
            sqlpara[1].Value = model.BookName;
            sqlpara[2].Value = model.ReaderId;
            sqlpara[3].Value = model.BorrowDate;

            CommonDB.ExecuteNonQuery(CommonDB.CONN_STRING, CommandType.Text, sqlstring, sqlpara);
        }
        catch (Exception ex)
        {

            Console.WriteLine("ReaderReverse Remove error!");
        }
    }
예제 #4
0
    protected void Button1_Click1(object sender, EventArgs e)
    {
        var bu = (((sender as Button).Parent.Parent) as GridViewRow).DataItemIndex;

        var bookpress = -1;
        int.TryParse(bookstocklist[bu].BookPress, out bookpress);
        if (bookpress > 0)
        {
            if (Session["UserType"].ToString() == "2")
            {
                var bookid = bookstocklist[bu].BookId;
                var bookname = bookstocklist[bu].BookName;
                string readerid = Session["UserName"].ToString();
               bookreserveModel _model = new bookreserveModel(bookid, bookname, readerid, System.DateTime.Now);
               ReaderReverse.AddReverse(_model);
               Response.Write("<script type='text/javascript'>alert('" + "预定成功!" + "');</script>");
            }
        }
        else
        {
            Response.Write("<script type='text/javascript'>alert('" + "存书不足!" + "');</script>");
        }
    }