protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Model.BookInfo bi = new Model.BookInfo(); int id = int.Parse(Request["id"]); biModel = bll.GetBookInfoById(id); } else { Model.BookInfo bi = new Model.BookInfo(); bi.BookTitle = Request["title"]; bi.SubTitle = Request["subtitle"]; bi.PriceOld = Convert.ToDecimal(Request["price"]); bi.PriceNew = Convert.ToDecimal(Request["discountprice"]); bi.Author = Request["author"]; bi.Publisher = Request["publisher"]; bi.PublishDate = Convert.ToDateTime(Request["publishdate"]); bi.Isbn = Request["isbn"]; bi.TypeId = Request["type1"] + "," + Request["type2"] + "," + Request["type3"]; bi.Details = Request["editorValue"]; bi.Id = Convert.ToInt32(Request["bid"]); bi.ImgTitle = Request["imgTitle"]; if (bll.InsertBookInfo(bi)) { Response.Redirect("BookInfo.aspx"); } else { Response.Redirect("Error.html"); } } }
protected void Page_Load(object sender, EventArgs e) { Model.BookInfo bi = new Model.BookInfo(); if (IsPostBack) { bi.BookTitle = Request["title"]; bi.SubTitle = Request["subtitle"]; bi.PriceNew = Convert.ToInt32(Request["price"]); bi.PriceOld = Convert.ToInt32(Request["discountprice"]); bi.Author = Request["author"]; bi.Publisher = Request["publisher"]; bi.PublishDate = Convert.ToDateTime(Request["publishdate"]); bi.SaleDate = System.DateTime.Now; bi.Isbn = Request["isbn"]; bi.TypeId = Request["type1"] + "," + Request["type2"] + "," + Request["type3"]; bi.ImgTitle = Request["imgTitle"]; bi.Details = Request["editorValue"]; BookShopBLL.BookInfoBLL bll = new BookInfoBLL(); if (bll.InsertBookInfo(bi)) { Response.Redirect("BookInfo.aspx"); } else { Response.Redirect("Error.html"); } } }
/// <summary> /// 图书信息方法 /// </summary> /// <param name="i">1代表插入数据 2代表修改数据 3代表删除数据</param> /// <param name="a">实例化对象</param> /// <returns></returns> public static string sysBookInfo(int i, Model.BookInfo a) { string str = "proc_BookInfoSave"; SqlParameter[] Parameter = { new SqlParameter("@num", SqlDbType.Int), new SqlParameter("@类别编号", SqlDbType.NVarChar), new SqlParameter("@图书名称", SqlDbType.NVarChar), new SqlParameter("@ISBN", SqlDbType.NVarChar), new SqlParameter("@图书作者", SqlDbType.NVarChar), new SqlParameter("@出版社", SqlDbType.NVarChar), new SqlParameter("@价格", SqlDbType.Decimal), new SqlParameter("@页数", SqlDbType.Int), new SqlParameter("@出版日期", SqlDbType.DateTime), new SqlParameter("@图书等级编号", SqlDbType.TinyInt), new SqlParameter("@图书简介", SqlDbType.NVarChar), new SqlParameter("@入库日期", SqlDbType.DateTime), new SqlParameter("@入库数量", SqlDbType.Int), new SqlParameter("@在馆数量", SqlDbType.Int), new SqlParameter("@BackValue", SqlDbType.NVarChar, 50), }; Parameter[0].Value = i; Parameter[1].Value = a.CbSortId; Parameter[2].Value = a.TbBookName; Parameter[3].Value = a.TbBookISBN; Parameter[4].Value = a.TbBookAuthor; Parameter[5].Value = a.TbBookPress; Parameter[6].Value = a.TbBookPrice; Parameter[7].Value = a.TbBookPage; Parameter[8].Value = a.DtpPDate; Parameter[9].Value = a.CbBookGrade; Parameter[10].Value = a.TbBookMark; Parameter[11].Value = a.DtpPutDate; Parameter[12].Value = a.TbRQuantity; Parameter[13].Value = a.TbSQuantity; Parameter[14].Direction = ParameterDirection.Output; SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, str, Parameter); return(Convert.ToString(Parameter[14].Value.ToString())); }
/// <summary> /// update book info by id /// </summary> /// <param name="bi"></param> /// <returns></returns> public int UpdateBookInfo(Model.BookInfo bi) { string sql = "update BookInfo set Title=@Title,SubTitle=@SubTitle,PriceOld=@PriceOld,PriceNew=@PriceNew,Author=@Author,Publisher=@Publisher,@PublishDate=@PublishDate,SaleDate=@SaleDate,ISBN=@ISBN,TypeId=@TypeId,Details=@Details,ImgTitle=@ImgTitle where Id=@Id"; SqlParameter[] ps = { new SqlParameter("@Title", bi.BookTitle), new SqlParameter("@SubTitle", bi.SubTitle), new SqlParameter("@PriceOld", bi.PriceOld), new SqlParameter("@PriceNew", bi.PriceNew), new SqlParameter("@Author", bi.Author), new SqlParameter("@Publisher", bi.Publisher), new SqlParameter("@PublishDate", bi.PublishDate), new SqlParameter("@SaleDate", bi.SaleDate), new SqlParameter("@ISBN", bi.Isbn), new SqlParameter("@TypeId", bi.TypeId), new SqlParameter("@Details", bi.Details), new SqlParameter("@ImgTitle", bi.ImgTitle), new SqlParameter("@Id", bi.Id) }; return(SqlHelper.ExcuteNonQuery(sql, ps)); }
private Model.BookInfo RowToGetBookInfo(DataRow dr) { Model.BookInfo bi = new Model.BookInfo(); bi.Id = Convert.ToInt32(dr["Id"]); return(bi); }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { int start = Convert.ToInt32(Request["startId"]); int end = Convert.ToInt32(Request["endId"]); //absolute path string path = Request.MapPath("/"); string temp = File.ReadAllText(Request.MapPath("/BookDetail.html")); BookInfoBLL bll = new BookInfoBLL(); for (int i = start; i < end; i++) { Model.BookInfo bi = bll.GetBookInfoById(i); //if id is not exist. if (bi == null) { continue; } //each folder can contain 500 html page, file name is id string path2 = path + (i / 500); if (!Directory.Exists(path2)) { Directory.CreateDirectory(path2); } string path3 = Path.Combine(path2, bi.Id + ".html"); //replace all text string temp2 = temp.Replace("$imgTitle", bi.ImgTitle) .Replace("$Details", bi.Details) .Replace("$BookTitle", bi.BookTitle) .Replace("$SubTitle", bi.SubTitle) .Replace("$Author", bi.Author) .Replace("$price", bi.PriceOld.ToString()) .Replace("$old", bi.PriceNew.ToString()) .Replace("$Isbn", bi.Isbn) .Replace("$Publisher", bi.Publisher) .Replace("$PublishDate", bi.PublishDate.ToString("yyyy-MM-dd")) .Replace("$id", bi.Id.ToString()); File.WriteAllText(path3, temp2); } Response.Write("<b style='color:red;'>Success to Generate</b>"); } else { BookInfoBLL bll = new BookInfoBLL(); Model.BookInfo bi = new Model.BookInfo(); DataTable dt = bll.GetAllBookInfo(); int max = 1; int start = 2; if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { bi = RowToGetBookInfo(dr); if ((bi.Id + 1 - bi.Id) == 1) { max++; continue; } } } //Get Id domain Context.Response.Write("Id domain:" + start + "--" + max); } }
/// <summary> /// update book info by id /// </summary> /// <param name="bi"></param> /// <returns></returns> public bool UpdateBookInfo(Model.BookInfo bi) { return(dal.UpdateBookInfo(bi) > 0); }