private void BindGrid() { string strSql; strSql = "select a.*,b.Short_Name from Book a inner join Org b on a.Publish_Org=b.Org_ID where Publish_org=" + SessionSet.OrganizationID + ViewState["QuerySql"].ToString() + " order by Book_Name"; DataSet ds = RunSqlDataSet(strSql); IList <RailExam.Model.Book> bookList = new List <RailExam.Model.Book>(); ArrayList bookIDList = GetBookIDList(); foreach (DataRow dr in ds.Tables[0].Rows) { if (bookIDList.IndexOf(Convert.ToInt32(dr["Book_ID"].ToString())) == -1) { RailExam.Model.Book book = new RailExam.Model.Book(); book.bookId = Convert.ToInt32(dr["Book_ID"].ToString()); book.bookName = dr["Book_Name"].ToString(); book.bookNo = dr["Book_No"].ToString(); book.authors = dr["Authors"].ToString(); book.bookmaker = dr["BookMaker"].ToString(); book.publishOrg = Convert.ToInt32(dr["Publish_Org"].ToString()); book.publishOrgName = dr["Short_Name"].ToString(); book.revisers = dr["Revisers"].ToString(); book.coverDesigner = dr["Cover_Designer"].ToString(); book.keyWords = dr["Keywords"].ToString(); book.pageCount = Convert.ToInt32(dr["Page_Count"].ToString()); book.wordCount = Convert.ToInt32(dr["Word_Count"].ToString()); book.Description = dr["Description"].ToString(); book.url = "../Book/" + dr["Book_ID"].ToString() + "/index.html"; book.Memo = dr["Remark"].ToString(); book.knowledgeId = 0; book.knowledgeName = ""; bookList.Add(book); } } gvBook.DataSource = bookList; gvBook.DataBind(); }
protected void btnOK_Click(object sender, EventArgs e) { if (Request.QueryString.Get("TrainTypeID") != null) { int bookID = Convert.ToInt32(Request.QueryString.Get("BookID")); int trainTypeID = Convert.ToInt32(Request.QueryString.Get("TrainTypeID")); BookTrainTypeBLL objBll = new BookTrainTypeBLL(); BookTrainType obj = objBll.GetBookTrainType(bookID, trainTypeID); int order = Convert.ToInt32(txtOrderIndex.Text); int max = Convert.ToInt32(Request.QueryString.Get("MaxOrder")); if (order > max) { obj.OrderIndex = max; } else { obj.OrderIndex = order; } objBll.UpdateBookTrainType(obj); } else { BookBLL objBll = new BookBLL(); RailExam.Model.Book obj = objBll.GetBook(Convert.ToInt32(Request.QueryString.Get("BookID"))); int order = Convert.ToInt32(txtOrderIndex.Text); int max = Convert.ToInt32(Request.QueryString.Get("MaxOrder")); if (order > max) { obj.OrderIndex = max; } else { obj.OrderIndex = order; } objBll.UpdateBook(obj); } Response.Write("<script>top.returnValue='true';window.close();</script>"); }
protected void btnOk_Click(object sender, EventArgs e) { int selectOrgID = Convert.ToInt32(hfOrg.Value); int bookID = Convert.ToInt32(Request.QueryString.Get("BookID")); ArrayList objOrgList = new ArrayList(); OrganizationBLL orgBll = new OrganizationBLL(); IList <Organization> objOrg = orgBll.GetOrganizationsByWhereClause("id_path || '/' like '/1/" + selectOrgID + "/%'"); foreach (Organization organization in objOrg) { objOrgList.Add(organization.OrganizationId); } BookBLL objBookBll = new BookBLL(); RailExam.Model.Book objBook = objBookBll.GetBook(bookID); objBook.publishOrg = selectOrgID; objBook.orgidAL = objOrgList; objBookBll.UpdateBook(objBook); Response.Write("<script>top.returnValue='true';window.close();</script>"); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack && !Grid1.IsCallback) { if (PrjPub.CurrentLoginUser == null) { Response.Redirect("/RailExamBao/Common/Error.aspx?error=Session过期请重新登录本系统!"); return; } //if(HfChapterId.Value != "") //{ // BookChapterBLL objBll = new BookChapterBLL(); // BookChapter obj = objBll.GetBookChapter(Convert.ToInt32(HfChapterId.Value)); // txtChapterName.Text = obj.NamePath; //} HfChapterId.Value = Request.QueryString.Get("cid"); HfBookId.Value = Request.QueryString.Get("bid"); if (!string.IsNullOrEmpty(HfBookId.Value) && HfBookId.Value != "-1") { BookBLL objbookbill = new BookBLL(); RailExam.Model.Book objBook = objbookbill.GetBook(Convert.ToInt32(HfBookId.Value)); if (PrjPub.CurrentLoginUser.SuitRange == 0 && PrjPub.IsServerCenter) { if (PrjPub.CurrentLoginUser.StationOrgID != objBook.publishOrg) { Response.Write("<script>alert('您没有导入当前教材章节试题的权限!');window.close();</script>"); return; } } if (HfChapterId.Value != "-1") { BookChapterBLL objBll = new BookChapterBLL(); BookChapter obj = objBll.GetBookChapter(Convert.ToInt32(HfChapterId.Value)); txtChapterName.Text = objBook.bookName + ">>" + obj.NamePath; if (obj.IsCannotSeeAnswer) { ddlMode.Visible = true; } else { ddlMode.Visible = false; ddlMode.SelectedValue = "0"; } } else { txtChapterName.Text = objBook.bookName; ddlMode.Visible = false; ddlMode.SelectedValue = "0"; } lblTitle.Visible = true; btnDelAll.Visible = true; } else { lblTitle.Visible = false; btnDelAll.Visible = false; } if (!PrjPub.IsWuhanOnly()) { ddlMode.Visible = false; ddlMode.SelectedValue = "0"; } ddlMode.Visible = false; ddlMode.SelectedValue = "0"; if (Session["table"] != null) { Session.Remove("table"); } } string str = Request.Form.Get("Refresh"); if (str != null && str == "refresh") { if (Session["table"] != null) { Grid1.DataSource = (DataTable)Session["table"]; Grid1.DataBind(); } } }
private int SaveNewBook() { if (this.txtPageCount.Text == "") { this.txtPageCount.Text = "0"; } if (this.txtWordCount.Text == "") { this.txtWordCount.Text = "0"; } BookBLL kBLL = new BookBLL(); string strId = Request.QueryString.Get("knowledgeId"); RailExam.Model.Book book = new RailExam.Model.Book(); book.Memo = txtMemo.Text; if (PrjPub.CurrentLoginUser.SuitRange == 1) { book.bookName = txtBookName.Text; } else { OrganizationBLL orgBll = new OrganizationBLL(); string orgName = orgBll.GetOrganization(PrjPub.CurrentLoginUser.StationOrgID).ShortName; book.bookName = orgName + txtBookName.Text; } book.Description = txtDescription.Text; book.pageCount = int.Parse(txtPageCount.Text); book.wordCount = int.Parse(txtWordCount.Text); book.revisers = txtRevisers.Text; book.authors = hfEmployeeID.Value; book.bookmaker = txtBookMaker.Text; book.bookNo = txtBookNo.Text; book.coverDesigner = txtCoverDesigner.Text; book.keyWords = txtKeyWords.Text; book.knowledgeName = txtKnowledgeName.Text; book.knowledgeId = int.Parse(hfKnowledgeID.Value); book.publishOrg = int.Parse(hfPublishOrgID.Value); book.publishDate = DateTime.Parse(datePublishDate.DateValue.ToString()); book.TechnicianTypeID = Convert.ToInt32(ddlTech.SelectedValue); book.IsGroupLearder = Convert.ToInt32(ddlIsGroup.SelectedValue); ArrayList alTrainTypeID = new ArrayList(); string strTrainTypeID = hfTrainTypeID.Value; string[] str1 = strTrainTypeID.Split(new char[] { ',' }); for (int i = 0; i < str1.Length; i++) { if (!string.IsNullOrEmpty(str1[i])) { alTrainTypeID.Add(str1[i]); } } book.trainTypeidAL = alTrainTypeID; ArrayList al = new ArrayList(); book.orgidAL = GetOrg(tvOrg.Nodes, al); ArrayList al1 = new ArrayList(); foreach (TreeViewNode tn in tvPost.Nodes) { if (tn.Checked) { al1.Add(tn.ID); } if (tn.Nodes.Count > 0) { foreach (TreeViewNode tns in tn.Nodes) { if (tns.Checked) { al1.Add(tns.ID); } if (tns.Nodes.Count > 0) { foreach (TreeViewNode tnss in tns.Nodes) { if (tnss.Checked) { al1.Add(tnss.ID); } } } } } } book.postidAL = al1; string strNewID = kBLL.AddBook(book).ToString(); string strPath = Server.MapPath("../Online/Book/" + strNewID); Directory.CreateDirectory(strPath); Directory.CreateDirectory(strPath + "/Upload"); CopyTemplate(Server.MapPath("../Online/Book/template/"), Server.MapPath("../Online/Book/" + strNewID + "/")); SaveBookCover(strNewID); return(Convert.ToInt32(strNewID)); }
protected void SaveButton_Click(object sender, EventArgs e) { if (this.txtPageCount.Text == "") { this.txtPageCount.Text = "0"; } if (this.txtWordCount.Text == "") { this.txtWordCount.Text = "0"; } BookBLL kBLL = new BookBLL(); BookBLL objBookBll = new BookBLL(); if (txtBookName.Text.Trim() != ViewState["BookName"].ToString()) { if (objBookBll.GetBookByName(txtBookName.Text.Trim()).Count > 0) { SessionSet.PageMessage = "该教材名称已经存在"; return; } } //修改 string strId = Request.QueryString.Get("id"); RailExam.Model.Book book = new RailExam.Model.Book(); book.bookId = Convert.ToInt32(strId); book.Memo = txtMemo.Text; book.bookName = txtBookName.Text; book.Description = txtDescription.Text; book.pageCount = int.Parse(this.txtPageCount.Text); book.wordCount = int.Parse(this.txtWordCount.Text); book.revisers = txtRevisers.Text; book.authors = hfEmployeeID.Value; book.bookmaker = txtBookMaker.Text; book.bookNo = txtBookNo.Text; book.coverDesigner = txtCoverDesigner.Text; book.keyWords = txtKeyWords.Text; book.knowledgeName = txtKnowledgeName.Text; book.knowledgeId = int.Parse(hfKnowledgeID.Value); book.publishOrg = int.Parse(hfPublishOrgID.Value); book.publishDate = DateTime.Parse(datePublishDate.DateValue.ToString()); book.TechnicianTypeID = Convert.ToInt32(ddlTech.SelectedValue); book.IsGroupLearder = Convert.ToInt32(ddlIsGroup.SelectedValue); book.OrderIndex = Convert.ToInt32(hfOrderIndex.Value); if (hlUrl.Text != "") { book.url = "../Book/" + strId + "/cover.htm"; } ArrayList alTrainTypeID = new ArrayList(); string strTrainTypeID = hfTrainTypeID.Value; string[] str1 = strTrainTypeID.Split(new char[] { ',' }); for (int i = 0; i < str1.Length; i++) { if (!string.IsNullOrEmpty(str1[i])) { alTrainTypeID.Add(str1[i]); } } book.trainTypeidAL = alTrainTypeID; ArrayList al = new ArrayList(); book.orgidAL = GetOrg(tvOrg.Nodes, al); ArrayList al1 = new ArrayList(); foreach (TreeViewNode tn in tvPost.Nodes) { if (tn.Checked) { al1.Add(tn.ID); } if (tn.Nodes.Count > 0) { foreach (TreeViewNode tns in tn.Nodes) { if (tns.Checked) { al1.Add(tns.ID); } if (tns.Nodes.Count > 0) { foreach (TreeViewNode tnss in tns.Nodes) { if (tnss.Checked) { al1.Add(tnss.ID); } } } } } } book.postidAL = al1; kBLL.UpdateBook(book); kBLL.UpdateBookVersion(Convert.ToInt32(strId)); SaveBookCover(strId); if (PrjPub.IsWuhan()) { Response.Write("<script>window.opener.form1.Refresh.value='true';window.opener.form1.submit();window.close();</script>"); } else { Response.Write("<script>top.returnValue='true';top.close();</script>"); } }
private void FillPage(int nBookID) { ArrayList orgidAL = new ArrayList(); ArrayList postidAL = new ArrayList(); ArrayList trainTypeidAL = new ArrayList(); BookBLL bookBLL = new BookBLL(); RailExam.Model.Book book = bookBLL.GetBook(nBookID); if (book != null) { txtBookName.Text = book.bookName; ViewState["BookName"] = book.bookName; txtKnowledgeName.Text = book.KnowledgeNames; hfKnowledgeID.Value = book.knowledgeId.ToString(); txtTrainTypeName.Text = book.trainTypeNames; trainTypeidAL = book.trainTypeidAL; string strTrainTypeID = ""; for (int i = 0; i < trainTypeidAL.Count; i++) { strTrainTypeID += trainTypeidAL[i].ToString() + ","; } if (strTrainTypeID.Length > 0) { strTrainTypeID = strTrainTypeID.Substring(0, strTrainTypeID.Length - 1); } hfTrainTypeID.Value = strTrainTypeID; txtBookNo.Text = book.bookNo; txtPublishOrgName.Text = book.publishOrgName; hfPublishOrgID.Value = book.publishOrg.ToString(); datePublishDate.DateValue = book.publishDate.ToString("yyyy-MM-dd"); hfEmployeeID.Value = book.authors; if (!string.IsNullOrEmpty(hfEmployeeID.Value)) { OracleAccess db = new OracleAccess(); DataTable dt = db.RunSqlDataSet("Select Employee_Name from Employee where Employee_ID=" + hfEmployeeID.Value).Tables[0]; if (dt != null && dt.Rows.Count > 0) { txtAuthors.Text = dt.Rows[0]["Employee_Name"].ToString(); } if (PrjPub.CurrentLoginUser.EmployeeID.ToString() != book.authors && PrjPub.CurrentLoginUser.RoleID != 1) { btnChapter.Visible = false; SaveButton.Visible = false; SaveExitButton.Visible = false; SaveNextButton.Visible = false; } } txtRevisers.Text = book.revisers; txtBookMaker.Text = book.bookmaker; txtCoverDesigner.Text = book.coverDesigner; txtKeyWords.Text = book.keyWords; txtPageCount.Text = book.pageCount.ToString(); txtWordCount.Text = book.wordCount.ToString(); txtDescription.Text = book.Description; hfOrderIndex.Value = book.OrderIndex.ToString(); string strUrl = string.Empty; if (!string.IsNullOrEmpty(book.url)) { strUrl = "../Online/Book" + book.url.Substring(7, book.url.Length - 7); } hlUrl.Text = strUrl; hlUrl.NavigateUrl = strUrl; txtMemo.Text = book.Memo; ddlIsGroup.SelectedValue = book.IsGroupLearder.ToString(); ddlTech.SelectedValue = book.TechnicianTypeID.ToString(); orgidAL = book.orgidAL; postidAL = book.postidAL; } BindOrganizationTree(orgidAL); BindPostTree(postidAL); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (PrjPub.CurrentLoginUser == null) { Response.Redirect("/RailExamBao/Common/Error.aspx?error=Session过期请重新登录本系统!"); return; } //ViewState["NowID"] = "false"; if (PrjPub.HasEditRight("教材管理") && PrjPub.IsServerCenter)//&& PrjPub.CurrentLoginUser.SuitRange == 1 { HfUpdateRight.Value = "True"; } else { HfUpdateRight.Value = "False"; } if (PrjPub.HasDeleteRight("教材管理") && PrjPub.IsServerCenter)//&& PrjPub.CurrentLoginUser.SuitRange == 1 { HfDeleteRight.Value = "True"; } else { HfDeleteRight.Value = "False"; } OrganizationBLL orgBll = new OrganizationBLL(); int orgID = orgBll.GetStationOrgID(PrjPub.CurrentLoginUser.OrgID); HfOrgId.Value = orgID.ToString(); hfEmployeeID.Value = PrjPub.CurrentLoginUser.EmployeeID.ToString(); if (!string.IsNullOrEmpty(Request.QueryString.Get("postID"))) { hfPostID.Value = Request.QueryString.Get("postID"); } BindGrid(); } else { if (Request.Form.Get("Refresh") == "true") { //ViewState["NowID"] = "false"; BindGrid(); } } #region //string strGet = Request.Form.Get("Index"); //if (strGet != null && strGet != "") //{ // GetIndex(strGet); // BindGrid(); //} //string strCover = Request.Form.Get("RefreshCover"); //if(strCover!= null && strCover !="") //{ // string strBookUrl = "../Book/" + strCover + "/cover.htm"; // BookBLL objBill = new BookBLL(); // objBill.UpdateBookUrl(Convert.ToInt32(strCover), strBookUrl); // string strBookName = objBill.GetBook(Convert.ToInt32(strCover)).bookName; // string strPath = "../Online/Book/" + strCover + "/Cover.htm"; // string str = File.ReadAllText(Server.MapPath(strPath), System.Text.Encoding.UTF8); // if (str.IndexOf("booktitle") < 0) // { // str = "<link href='book.css' type='text/css' rel='stylesheet' />" // + "<div id='booktitle'>" + strBookName + "</div>" + "<br>" // + str; // File.WriteAllText(Server.MapPath(strPath), str, System.Text.Encoding.UTF8); // } // BookChapterBLL objChapterBll = new BookChapterBLL(); // objChapterBll.GetIndex(strCover); // SystemLogBLL objLogBll = new SystemLogBLL(); // objLogBll.WriteLog("编辑教材《" + strBookName + "》前言"); // BindGrid(); //} #endregion string strDeleteID = Request.Form.Get("DeleteID"); if (strDeleteID != null && strDeleteID != "") { DelBook(strDeleteID); BindGrid(); } string strUpID = Request.Form.Get("UpID"); if (strUpID != null && strUpID != "") { if (Request.QueryString.Get("id") != null) { BookBLL objBll = new BookBLL(); RailExam.Model.Book obj = objBll.GetBook(Convert.ToInt32(strUpID)); obj.OrderIndex = obj.OrderIndex - 1; objBll.UpdateBook(obj); } if (Request.QueryString.Get("id1") != null) { int trainTypeID = Convert.ToInt32(Request.QueryString.Get("id1")); BookTrainTypeBLL objTrainTypeBll = new BookTrainTypeBLL(); BookTrainType objTrainType = objTrainTypeBll.GetBookTrainType(Convert.ToInt32(strUpID), trainTypeID); objTrainType.OrderIndex = objTrainType.OrderIndex - 1; objTrainTypeBll.UpdateBookTrainType(objTrainType); } BindGrid(); } string strDownID = Request.Form.Get("DownID"); if (strDownID != null && strDownID != "") { if (Request.QueryString.Get("id") != null) { BookBLL objBll = new BookBLL(); RailExam.Model.Book obj = objBll.GetBook(Convert.ToInt32(strDownID)); obj.OrderIndex = obj.OrderIndex + 1; objBll.UpdateBook(obj); } if (Request.QueryString.Get("id1") != null) { int trainTypeID = Convert.ToInt32(Request.QueryString.Get("id1")); BookTrainTypeBLL objTrainTypeBll = new BookTrainTypeBLL(); BookTrainType objTrainType = objTrainTypeBll.GetBookTrainType(Convert.ToInt32(strDownID), trainTypeID); objTrainType.OrderIndex = objTrainType.OrderIndex + 1; objTrainTypeBll.UpdateBookTrainType(objTrainType); } BindGrid(); } string strRefreshDown = Request.Form.Get("RefreshDown"); if (strRefreshDown != null && strRefreshDown != "") { if (!DownloadBook(strRefreshDown)) { SessionSet.PageMessage = "当前教材不存在电子版教材!"; BindGrid(); return; } BindGrid(); } if (!string.IsNullOrEmpty(hfPostID.Value)) { PostBLL post = new PostBLL(); txtPost.Text = post.GetPost(Convert.ToInt32(hfPostID.Value)).PostName; } }
private void BindTree() { string strBookID = Request.QueryString.Get("BookID"); string strSelectedID = Request.QueryString.Get("StrategyID"); string strItemTypeID = Request.QueryString.Get("itemTypeID"); BookBLL objBll = new BookBLL(); RailExam.Model.Book obj = objBll.GetBook(Convert.ToInt32(strBookID)); ItemBLL objItemBll = new ItemBLL(); TreeViewNode node = new TreeViewNode(); int m = objItemBll.GetItemsByBookID(obj.bookId, Convert.ToInt32(strItemTypeID)); if (m > 0) { node.Text = obj.bookName + "£¨" + m + "Ì⣩"; } else { node.Text = obj.bookName; } node.ID = obj.bookId.ToString(); tvBook.Nodes.Add(node); BookChapterBLL objChapterBll = new BookChapterBLL(); IList <RailExam.Model.BookChapter> objChapterList = objChapterBll.GetBookChapterByBookID(Convert.ToInt32(strBookID)); TreeViewNode tvn = null; foreach (BookChapter bookChapter in objChapterList) { if (bookChapter.IsMotherItem) { continue; } tvn = new TreeViewNode(); tvn.ID = bookChapter.ChapterId.ToString(); tvn.Value = bookChapter.ChapterId.ToString(); int n = objItemBll.GetItemsByBookChapterIdPath(bookChapter.IdPath, Convert.ToInt32(strItemTypeID)); if (n > 0) { tvn.Text = bookChapter.ChapterName + "£¨" + n + "Ì⣩"; } else { tvn.Text = bookChapter.ChapterName; } tvn.ToolTip = bookChapter.ChapterName; tvn.ShowCheckBox = true; if (Request.QueryString.Get("StrategyID") != null) { string str = "," + strSelectedID + ","; if (str.IndexOf("," + tvn.ID + ",") != -1) { tvn.Checked = true; } } tvn.Attributes.Add("isChapter", "true"); tvn.ImageUrl = "~/App_Themes/" + StyleSheetTheme + "/Images/TreeView/Chapter.gif"; if (bookChapter.ParentId == 0) { tvBook.FindNodeById(bookChapter.BookId.ToString()).Nodes.Add(tvn); } else { tvBook.FindNodeById(bookChapter.ParentId.ToString()).Nodes.Add(tvn); } } if (tvBook.Nodes.Count > 0) { tvBook.Nodes[0].Expanded = true; } }
protected void btnInput_Click(object sender, EventArgs e) { string strSql; for (int i = 0; i < gvBook.Rows.Count; i++) { CheckBox chk = (CheckBox)gvBook.Rows[i].FindControl("chSelect"); string strKnowledgeId = ((HiddenField)gvBook.Rows[i].FindControl("hfKownledgeId")).Value; if (chk.Checked) { strSql = "select a.*,b.Short_Name from Book a inner join Org b on a.Publish_Org=b.Org_ID where a.Book_ID=" + gvBook.DataKeys[i].Value.ToString(); DataSet ds = RunSqlDataSet(strSql); DataRow dr = ds.Tables[0].Rows[0]; BookBLL objBookbll = new BookBLL(); RailExam.Model.Book objBookNew = new RailExam.Model.Book(); objBookNew.bookId = Convert.ToInt32(dr["Book_ID"].ToString()); string strPath = Server.MapPath(ConfigurationManager.AppSettings["BookDesigner"].ToString() + objBookNew.bookId + "/"); string strAimPath = Server.MapPath("../Online/Book/" + objBookNew.bookId + "/"); if (!Directory.Exists(strPath)) { SessionSet.PageMessage = "有教材还未创建内容,暂不能导入!"; return; } objBookNew.bookName = dr["Book_Name"].ToString(); objBookNew.bookNo = dr["Book_No"].ToString(); objBookNew.authors = dr["Authors"].ToString(); objBookNew.bookmaker = dr["BookMaker"].ToString(); objBookNew.publishOrg = Convert.ToInt32(dr["Publish_Org"].ToString()); objBookNew.publishOrgName = dr["Short_Name"].ToString(); objBookNew.revisers = dr["Revisers"].ToString(); objBookNew.coverDesigner = dr["Cover_Designer"].ToString(); objBookNew.keyWords = dr["Keywords"].ToString(); objBookNew.pageCount = Convert.ToInt32(dr["Page_Count"].ToString()); objBookNew.wordCount = Convert.ToInt32(dr["Word_Count"].ToString()); objBookNew.Description = dr["Description"].ToString(); objBookNew.url = "../Book/" + dr["Book_ID"].ToString() + "/index.html"; objBookNew.Memo = dr["Remark"].ToString(); objBookNew.knowledgeId = Convert.ToInt32(strKnowledgeId); //objBookbll.UpdateBook(objBookNew, ref errorCode); strSql = "select * from Book_Chapter where Book_ID=" + gvBook.DataKeys[i].Value.ToString(); ds = RunSqlDataSet(strSql); BookChapterBLL objBookChapterBll = new BookChapterBLL(); //取得Access数据库中当前教材的所有的章节ID ArrayList objAccessChapterList = new ArrayList(); //取得当前教材在oracle数据中所有章节ID ArrayList objList = GetBookChapterList(Convert.ToInt32(gvBook.DataKeys[i].Value.ToString())); foreach (DataRow dr1 in ds.Tables[0].Rows) { RailExam.Model.BookChapter objBookChapter = new RailExam.Model.BookChapter(); objBookChapter.ChapterId = Convert.ToInt32(dr1["Chapter_ID"].ToString()); objBookChapter.BookId = Convert.ToInt32(dr1["Book_ID"].ToString()); objBookChapter.ChapterName = dr1["Chapter_Name"].ToString(); objBookChapter.ParentId = Convert.ToInt32(dr1["Parent_ID"].ToString()); objBookChapter.LevelNum = Convert.ToInt32(dr1["Level_Num"].ToString()); objBookChapter.OrderIndex = Convert.ToInt32(dr1["Order_Index"].ToString()); objBookChapter.ReferenceRegulation = dr1["REFERENCE_REGULATION"].ToString(); objBookChapter.Description = dr1["Description"].ToString(); objBookChapter.Memo = dr1["Remark"].ToString(); objBookChapter.Url = "../Book/" + dr1["Book_ID"].ToString() + "/" + dr1["Chapter_ID"].ToString() + ".htm"; //如果该章节的ID已存在当前oracle数据库中则只需修改章节信息,否则添加信息 if (objList.IndexOf(objBookChapter.ChapterId) != -1) { objBookChapterBll.UpdateBookChapter(objBookChapter); } else { objBookChapterBll.AddBookChapter(objBookChapter); } objAccessChapterList.Add(objBookChapter.ChapterId); } //取得当前教材在oracle中的所有教材信息 IList <RailExam.Model.BookChapter> objOracleBookChapterList = objBookChapterBll.GetBookChapterByBookID(objBookNew.bookId); foreach (RailExam.Model.BookChapter chapter in objOracleBookChapterList) { //如果oracle数据库中某章节ID不在Access数据库中 if (objAccessChapterList.IndexOf(chapter.ChapterId) == -1) { ItemBLL objItemBll = new ItemBLL(); IList <RailExam.Model.Item> objItemList = objItemBll.GetItemsByBookBookId(objBookNew.bookId); foreach (RailExam.Model.Item item in objItemList) { item.StatusId = 2; objItemBll.UpdateItem(item); } objBookChapterBll.DeleteBookChapter(chapter.ChapterId); } } if (Directory.Exists(Server.MapPath("../Online/Book/" + objBookNew.bookId + "/"))) { //Directory.Delete(Server.MapPath("../Online/Book/" + objBookNew.bookId + "/"), true); DeleteFile(Server.MapPath("../Online/Book/" + objBookNew.bookId + "/")); } CopyTemplate(strPath, strAimPath); } } BindGrid(); }
private void BindGrid() { string strSql; strSql = "select a.*,b.Short_Name from Book a inner join Org b on a.Publish_Org=b.Org_ID where Publish_org=" + SessionSet.OrganizationID + ViewState["QuerySql"].ToString() + " order by Book_Name"; DataSet ds = RunSqlDataSet(strSql); IList <RailExam.Model.Book> objList = new List <RailExam.Model.Book>(); ArrayList objBookList = GetBookList(); BookBLL objBookbll = new BookBLL(); IList <RailExam.Model.Book> objAllBookList = objBookbll.GetAllBookInfo(SessionSet.OrganizationID); foreach (DataRow dr in ds.Tables[0].Rows) { int n = objBookList.IndexOf(Convert.ToInt32(dr["Book_ID"].ToString())); if (n != -1) { RailExam.Model.Book objBookNew = new RailExam.Model.Book(); objBookNew.bookId = Convert.ToInt32(dr["Book_ID"].ToString()); objBookNew.bookName = dr["Book_Name"].ToString(); objBookNew.bookNo = dr["Book_No"].ToString(); objBookNew.authors = dr["Authors"].ToString(); objBookNew.bookmaker = dr["BookMaker"].ToString(); objBookNew.publishOrg = Convert.ToInt32(dr["Publish_Org"].ToString()); objBookNew.publishOrgName = dr["Short_Name"].ToString(); objBookNew.revisers = dr["Revisers"].ToString(); objBookNew.coverDesigner = dr["Cover_Designer"].ToString(); objBookNew.keyWords = dr["Keywords"].ToString(); objBookNew.pageCount = Convert.ToInt32(dr["Page_Count"].ToString()); objBookNew.wordCount = Convert.ToInt32(dr["Word_Count"].ToString()); objBookNew.Description = dr["Description"].ToString(); objBookNew.url = "../Book/" + dr["Book_ID"].ToString() + "/index.html"; objBookNew.Memo = dr["Remark"].ToString(); foreach (RailExam.Model.Book obj in objAllBookList) { if (obj.bookId == Convert.ToInt32(dr["Book_ID"].ToString())) { TrainTypeBLL objTrainTypeBll = new TrainTypeBLL(); objBookNew.knowledgeId = obj.knowledgeId; objBookNew.knowledgeName = obj.knowledgeName; BookTrainTypeBLL objBookTrainTypeBll = new BookTrainTypeBLL(); IList <BookTrainType> objBookTrainTypeList = objBookTrainTypeBll.GetBookTrainTypeByBookID(Convert.ToInt32(dr["Book_ID"].ToString())); string strTypeName = ""; foreach (BookTrainType obj1 in objBookTrainTypeList) { if (strTypeName == "") { strTypeName = strTypeName + GetType("/" + obj1.TrainTypeName, objTrainTypeBll.GetTrainTypeInfo(obj1.TrainTypeID).ParentID); } else { strTypeName = strTypeName + "," + GetType("/" + obj1.TrainTypeName, objTrainTypeBll.GetTrainTypeInfo(obj1.TrainTypeID).ParentID); } } objBookNew.trainTypeNames = strTypeName; } } objList.Add(objBookNew); } } gvBook.DataSource = objList; gvBook.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string strID = Request.QueryString.Get("id"); ViewState["mode"] = Request.QueryString.Get("mode"); hfItemType.Value = Request.QueryString.Get("itemTypeID"); ddlType.SelectedValue = hfItemType.Value; if (ViewState["mode"].ToString() == "Insert") { string subjectId = Request.QueryString.Get("subjectid"); hfSubjectId.Value = subjectId; if (!string.IsNullOrEmpty(subjectId)) { RandomExamSubjectBLL paperStrategySubjectBLL = new RandomExamSubjectBLL(); RandomExamSubject paperStrategySubject = paperStrategySubjectBLL.GetRandomExamSubject(int.Parse(subjectId)); if (paperStrategySubject != null) { hfExamID.Value = paperStrategySubject.RandomExamId.ToString(); txtSubjectName.Text = paperStrategySubject.SubjectName; ddlType.SelectedValue = paperStrategySubject.ItemTypeId.ToString(); labelTotalCount.Text = paperStrategySubject.ItemCount.ToString(); RandomExamStrategyBLL randomExamStrategyBLL = new RandomExamStrategyBLL(); IList <RailExam.Model.RandomExamStrategy> RandomExamStrategys = randomExamStrategyBLL.GetRandomExamStrategys(paperStrategySubject.RandomExamSubjectId); int hasCount = 0; foreach (RailExam.Model.RandomExamStrategy randomExamStrategy in RandomExamStrategys) { hasCount += randomExamStrategy.ItemCount; } labelLeaveCount.Text = (paperStrategySubject.ItemCount - hasCount).ToString(); txtNDR.Text = labelLeaveCount.Text; RandomExamResultBLL reBll = new RandomExamResultBLL(); IList <RailExam.Model.RandomExamResult> examResults = reBll.GetRandomExamResultByExamID(paperStrategySubject.RandomExamId); if (examResults.Count > 0) { SaveButton.Visible = false; } } hfSubjectId.Value = subjectId; mother1.Visible = false; mother2.Visible = false; } OracleAccess db = new OracleAccess(); string strSql = "select RANDOM_EXAM_STRATEGY_SEQ.nextval from dual"; DataRow dr = db.RunSqlDataSet(strSql).Tables[0].Rows[0]; hfKeyID.Value = dr[0].ToString(); } else { hfKeyID.Value = strID; FillPage(int.Parse(strID)); } } if (!string.IsNullOrEmpty(HfChapterId.Value)) { if (HfRangeType.Value == "4") { BookChapterBLL chapterBll = new BookChapterBLL(); BookChapter chapter = chapterBll.GetBookChapter(Convert.ToInt32(HfChapterId.Value)); txtChapterName.Text = chapter.ChapterName; } else { BookBLL bookBll = new BookBLL(); RailExam.Model.Book book = bookBll.GetBook(Convert.ToInt32(HfChapterId.Value)); txtChapterName.Text = book.bookName; } } if (!string.IsNullOrEmpty(HfExCludeChaptersId.Value)) { string strSql = "select * from Book_Chapter where Chapter_ID in (" + HfExCludeChaptersId.Value + ")"; OracleAccess db = new OracleAccess(); DataSet ds = db.RunSqlDataSet(strSql); string strName = string.Empty; foreach (DataRow dr in ds.Tables[0].Rows) { if (strName == string.Empty) { strName += dr["Chapter_Name"].ToString(); } else { strName += "," + dr["Chapter_Name"].ToString(); } } txtExCludeChapters.Text = strName; } }
private int SaveNewBook() { BookBLL kBLL = new BookBLL(); RailExam.Model.Book book = new RailExam.Model.Book(); book.bookName = txtBookName.Text; book.knowledgeName = txtKnowledgeName.Text; book.knowledgeId = int.Parse(hfKnowledgeID.Value); book.publishOrg = int.Parse(hfPublishOrgID.Value); book.publishDate = DateTime.Today; book.TechnicianTypeID = Convert.ToInt32(ddlTech.SelectedValue); book.IsGroupLearder = Convert.ToInt32(ddlIsGroup.SelectedValue); ArrayList alTrainTypeID = new ArrayList(); string strTrainTypeID = hfTrainTypeID.Value; string[] str1 = strTrainTypeID.Split(new char[] { ',' }); for (int i = 0; i < str1.Length; i++) { alTrainTypeID.Add(str1[i]); } book.trainTypeidAL = alTrainTypeID; ArrayList al = new ArrayList(); book.orgidAL = GetOrg(tvOrg.Nodes, al); ArrayList al1 = new ArrayList(); foreach (TreeViewNode tn in tvPost.Nodes) { if (tn.Checked) { al1.Add(tn.ID); } if (tn.Nodes.Count > 0) { foreach (TreeViewNode tns in tn.Nodes) { if (tns.Checked) { al1.Add(tns.ID); } if (tns.Nodes.Count > 0) { foreach (TreeViewNode tnss in tns.Nodes) { if (tnss.Checked) { al1.Add(tnss.ID); } } } } } } book.postidAL = al1; string strNewID = kBLL.AddBook(book).ToString(); string strPath = Server.MapPath("../Online/Book/" + strNewID); Directory.CreateDirectory(strPath); Directory.CreateDirectory(strPath + "/Upload"); CopyTemplate(Server.MapPath("../Online/Book/template/"), Server.MapPath("../Online/Book/" + strNewID + "/")); SaveBookCover(strNewID); return(Convert.ToInt32(strNewID)); }
/// <summary> /// 发布教材 /// </summary> /// <param name="strID"></param> public void GetIndex(string strID) { string strItem, strChapter; BookBLL objBll = new BookBLL(); RailExam.Model.Book objBook = objBll.GetBook(Convert.ToInt32(strID)); string strBookName = objBook.bookName; string strBookUrl = objBook.url; string strVersion = objBook.Version.ToString(); WriteXml(strID, strVersion); strItem = "var TREE_ITEMS = [ ['" + strBookName + "', 'common.htm?url=cover.htm&chapterid=0&bookid=" + strID + "',"; strChapter = "var Tree_Chapter=['0','cover.htm','" + strBookName + "'"; IList <RailExam.Model.BookChapter> objBookChapter = GetBookChapterByBookID(Convert.ToInt32(strID)); foreach (RailExam.Model.BookChapter chapter in objBookChapter) { if (chapter.ParentId == 0) { if (chapter.Url == "" || chapter.Url == null) { strItem += "['" + chapter.ChapterName + "', 'common.htm?url=empty.htm&chapterid=" + chapter.ChapterId + "&bookid=" + strID + "'"; strChapter += ",'" + chapter.ChapterId + "','empty.htm','" + chapter.NamePath + "'"; } else { strItem += "['" + chapter.ChapterName + "', 'common.htm?url=" + chapter.ChapterId + ".htm&chapterid=" + chapter.ChapterId + "&bookid=" + strID + "'"; strChapter += ",'" + chapter.ChapterId + "','" + chapter.ChapterId + ".htm','" + chapter.NamePath + "'"; } if (GetBookChapterByParentID(chapter.ChapterId).Count > 0) { strItem += ","; } strItem = Get(chapter.ChapterId, strItem); strChapter = GetChapter(chapter.ChapterId, strChapter); } } strItem += "]];"; string strPath = "../Online/Book/" + strID + "/tree_items.js"; File.Delete(HttpContext.Current.Server.MapPath(strPath)); File.AppendAllText(HttpContext.Current.Server.MapPath(strPath), strItem, System.Text.Encoding.UTF8); strChapter += "];"; strPath = "../Online/Book/" + strID + "/tree_chapter.js"; if (File.Exists(HttpContext.Current.Server.MapPath(strPath))) { File.Delete(HttpContext.Current.Server.MapPath(strPath)); } File.AppendAllText(HttpContext.Current.Server.MapPath(strPath), strChapter, System.Text.Encoding.UTF8); string[] strIndex = File.ReadAllLines(HttpContext.Current.Server.MapPath("../Online/Book/" + strID + "/index.html"), System.Text.Encoding.Default); for (int i = 0; i < strIndex.Length; i++) { if (strIndex[i].IndexOf("<title>") != -1) { strIndex[i] = "\t<title> " + strBookName + " </title>"; } if (strIndex[i].IndexOf("common.htm?url=cover.htm&chapterid=0") != -1) { strIndex[i] = strIndex[i].Replace("common.htm?url=cover.htm&chapterid=0", "common.htm?url=cover.htm&chapterid=0&bookid=" + strID); } } File.WriteAllLines(HttpContext.Current.Server.MapPath("../Online/Book/" + strID + "/index.html"), strIndex, System.Text.Encoding.UTF8); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (PrjPub.CurrentLoginUser == null) { Response.Redirect("/RailExamBao/Common/Error.aspx?error=Session过期请重新登录本系统!"); return; } //ViewState["NowID"] = "false"; if (PrjPub.HasEditRight("教材管理") && PrjPub.IsServerCenter) //&& PrjPub.CurrentLoginUser.SuitRange == 1 { HfUpdateRight.Value = "True"; } else { HfUpdateRight.Value = "False"; } if (PrjPub.HasDeleteRight("教材管理") && PrjPub.IsServerCenter) //&& PrjPub.CurrentLoginUser.SuitRange == 1 { HfDeleteRight.Value = "True"; } else { HfDeleteRight.Value = "False"; } OrganizationBLL orgBll = new OrganizationBLL(); int orgID = orgBll.GetStationOrgID(PrjPub.CurrentLoginUser.OrgID); HfOrgId.Value = orgID.ToString(); BindGrid(); } else { if (Request.Form.Get("Refresh") == "true") { //ViewState["NowID"] = "false"; BindGrid(); } } string strDeleteID = Request.Form.Get("DeleteID"); if (strDeleteID != null && strDeleteID != "") { DelBook(strDeleteID); BindGrid(); } string strUpID = Request.Form.Get("UpID"); if (strUpID != null && strUpID != "") { if (Request.QueryString.Get("id") != null) { BookBLL objBll = new BookBLL(); RailExam.Model.Book obj = objBll.GetBook(Convert.ToInt32(strUpID)); obj.OrderIndex = obj.OrderIndex - 1; objBll.UpdateBook(obj); } if (Request.QueryString.Get("id1") != null) { int trainTypeID = Convert.ToInt32(Request.QueryString.Get("id1")); BookTrainTypeBLL objTrainTypeBll = new BookTrainTypeBLL(); BookTrainType objTrainType = objTrainTypeBll.GetBookTrainType(Convert.ToInt32(strUpID), trainTypeID); objTrainType.OrderIndex = objTrainType.OrderIndex - 1; objTrainTypeBll.UpdateBookTrainType(objTrainType); } BindGrid(); } string strDownID = Request.Form.Get("DownID"); if (strDownID != null && strDownID != "") { if (Request.QueryString.Get("id") != null) { BookBLL objBll = new BookBLL(); RailExam.Model.Book obj = objBll.GetBook(Convert.ToInt32(strDownID)); obj.OrderIndex = obj.OrderIndex + 1; objBll.UpdateBook(obj); } if (Request.QueryString.Get("id1") != null) { int trainTypeID = Convert.ToInt32(Request.QueryString.Get("id1")); BookTrainTypeBLL objTrainTypeBll = new BookTrainTypeBLL(); BookTrainType objTrainType = objTrainTypeBll.GetBookTrainType(Convert.ToInt32(strDownID), trainTypeID); objTrainType.OrderIndex = objTrainType.OrderIndex + 1; objTrainTypeBll.UpdateBookTrainType(objTrainType); } BindGrid(); } }
protected void btnInput_Click(object sender, EventArgs e) { string strSql; for (int i = 0; i < gvBook.Rows.Count; i++) { CheckBox chk = (CheckBox)gvBook.Rows[i].FindControl("chSelect"); HiddenField hfKownledgeName = (HiddenField)gvBook.Rows[i].FindControl("hfKownledgeName"); HiddenField hfKownledgeId = (HiddenField)gvBook.Rows[i].FindControl("hfKownledgeId"); HiddenField hfTrainTypeName = (HiddenField)gvBook.Rows[i].FindControl("hfTrainTypeName"); HiddenField hfTrainTypeID = (HiddenField)gvBook.Rows[i].FindControl("hfTrainTypeID"); if (chk.Checked && hfKownledgeName.Value.Trim() == "") { SessionSet.PageMessage = "请选择教材体系!"; return; } if (chk.Checked && hfTrainTypeName.Value.Trim() == "") { SessionSet.PageMessage = "请选择培训类别!"; return; } if (chk.Checked) { strSql = "select a.*,b.Short_Name from Book a inner join Org b on a.Publish_Org=b.Org_ID where a.Book_ID=" + gvBook.DataKeys[i].Value.ToString(); DataSet ds = RunSqlDataSet(strSql); DataRow dr = ds.Tables[0].Rows[0]; BookBLL bookBLL = new BookBLL(); RailExam.Model.Book book = new RailExam.Model.Book(); book.bookId = Convert.ToInt32(dr["Book_ID"].ToString()); string strPath = Server.MapPath(ConfigurationManager.AppSettings["BookDesigner"].ToString() + book.bookId + "/"); string strAimPath = Server.MapPath("../Online/Book/" + book.bookId + "/"); if (!Directory.Exists(strPath)) { SessionSet.PageMessage = "有教材还未创建内容,暂不能导入!"; return; } book.bookName = dr["Book_Name"].ToString(); book.bookNo = dr["Book_No"].ToString(); book.authors = dr["Authors"].ToString(); book.bookmaker = dr["BookMaker"].ToString(); book.publishOrg = Convert.ToInt32(dr["Publish_Org"].ToString()); book.publishOrgName = dr["Short_Name"].ToString(); book.revisers = dr["Revisers"].ToString(); book.coverDesigner = dr["Cover_Designer"].ToString(); book.keyWords = dr["Keywords"].ToString(); book.pageCount = Convert.ToInt32(dr["Page_Count"].ToString()); book.wordCount = Convert.ToInt32(dr["Word_Count"].ToString()); book.Description = dr["Description"].ToString(); book.url = "../Book/" + dr["Book_ID"].ToString() + "/index.html"; book.Memo = dr["Remark"].ToString(); book.knowledgeId = Convert.ToInt32(hfKownledgeId.Value); book.knowledgeName = hfKownledgeName.Value; ArrayList typeIDAL = new ArrayList(); string[] strTypeID = hfTrainTypeID.Value.Split(','); for (int j = 0; j < strTypeID.Length; j++) { typeIDAL.Add(strTypeID[j]); } book.trainTypeidAL = typeIDAL; bookBLL.AddBook(book); strSql = "select * from Book_Chapter where Book_ID=" + gvBook.DataKeys[i].Value.ToString() + " order by Level_Num,Order_Index"; ds = RunSqlDataSet(strSql); BookChapterBLL bookChapterBll = new BookChapterBLL(); foreach (DataRow dr1 in ds.Tables[0].Rows) { RailExam.Model.BookChapter bookChapter = new RailExam.Model.BookChapter(); bookChapter.ChapterId = Convert.ToInt32(dr1["Chapter_ID"].ToString()); bookChapter.BookId = Convert.ToInt32(dr1["Book_ID"].ToString()); bookChapter.ChapterName = dr1["Chapter_Name"].ToString(); bookChapter.ParentId = Convert.ToInt32(dr1["Parent_ID"].ToString()); bookChapter.LevelNum = Convert.ToInt32(dr1["Level_Num"].ToString()); bookChapter.OrderIndex = Convert.ToInt32(dr1["Order_Index"].ToString()); bookChapter.ReferenceRegulation = dr1["REFERENCE_REGULATION"].ToString(); bookChapter.Description = dr1["Description"].ToString(); bookChapter.Memo = dr1["Remark"].ToString(); bookChapter.Url = "../Book/" + dr1["Book_ID"].ToString() + "/" + dr1["Chapter_ID"].ToString() + ".htm"; bookChapterBll.AddBookChapter(bookChapter); } CopyTemplate(strPath, strAimPath); } } BindGrid(); }