protected void Page_Load(object sender, EventArgs e) { //得到是否是武汉铁路局 if (PrjPub.IsWuhan()) { hfIswuhan.Value = "1"; } else { hfIswuhan.Value = "0"; } if (!IsPostBack) { BindTree(); BindTrainTypeTree(); } string str1 = Request.Form.Get("Test1"); if (str1 != null & str1 != "") { BindTree(); BindTrainTypeTree(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (PrjPub.IsWuhan()) { gradesGrid.Levels[0].Columns[2].HeadingText = "员工编码"; lblWorkNo.Text = "上岗证号"; } else { gradesGrid.Levels[0].Columns[2].HeadingText = "工资编号"; lblWorkNo.Text = "工资编号"; } DataSet ds = GetDataSet(); if (ds != null && ds.Tables[0].Rows.Count > 0) { gradesGrid.DataSource = ds; gradesGrid.DataBind(); } //else //{ // SessionSet.PageMessage = "数据错误!"; // return; //} } else { if (Request.Form.Get("OutPut") != null && Request.Form.Get("OutPut") != "") { OutputData(Request.Form.Get("OutPut"), Request.Form.Get("OutPutOrgID")); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (PrjPub.IsWuhan()) { Grid1.Columns[3].HeaderText = "Ô±¹¤±àÂë"; } else { Grid1.Columns[3].HeaderText = "¹¤×ʱàºÅ"; } string strId = Request.QueryString.Get("employeeID"); if (strId != null && strId != "") { ViewState["ChooseId"] = strId; ViewState["UpdateMode"] = 1; } else { ViewState["ChooseId"] = ""; ViewState["UpdateMode"] = 0; } BindStationStart(); BindOrgStart(); BindWorkShopStart(); BindSystemStart(); BindTypeStart(); BindPostStart(); EmployeeBLL bll = new EmployeeBLL(); RailExam.Model.Employee employee = bll.GetEmployee(Convert.ToInt32(Request.QueryString.Get("nowEmployeeID"))); OrganizationBLL orgbll = new OrganizationBLL(); int stationOrgID = orgbll.GetStationOrgID(employee.OrgID); if (stationOrgID != 200) { ddlStation.SelectedValue = stationOrgID.ToString(); OrganizationBLL objBll = new OrganizationBLL(); IList <RailExam.Model.Organization> objList = objBll.GetOrganizationsByParentID(Convert.ToInt32(ddlStation.SelectedValue)); foreach (RailExam.Model.Organization organization in objList) { ListItem item = new ListItem(); item.Value = organization.OrganizationId.ToString(); item.Text = organization.ShortName; ddlWorkShop.Items.Add(item); } ddlStation.Enabled = false; } ViewState["StartRow"] = 0; ViewState["EndRow"] = Grid1.PageSize; ViewState["EmploySortField"] = "nlssort(a.employee_name,'NLS_SORT=SCHINESE_PINYIN_M')"; BindGrid(ViewState["EmploySortField"].ToString()); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack && !CallBack.IsCallback) { NavBarItem parentItem = null; if (PrjPub.CurrentLoginUser == null) { CallBack.RefreshInterval = 0; return; } hfEmployeeID.Value = PrjPub.CurrentLoginUser.EmployeeID.ToString(); foreach (FunctionRight functionRight in PrjPub.CurrentLoginUser.FunctionRights) { if (PrjPub.IsWuhan()) { if (functionRight.Function.FunctionID == "0406") { continue; } } if (functionRight.Right == 0) { continue; } NavBarItem item = new NavBarItem(); item.Text = functionRight.Function.MenuName; item.Expanded = functionRight.Function.IsDefault; if (functionRight.Function.FunctionID.Length == 2) { item.SelectedLookId = "TopItemLook"; item.SubGroupCssClass = "Level2Group"; item.DefaultSubItemLookId = "Level2ItemLook"; SystemMenu.Items.Add(item); parentItem = item; } else { if (parentItem != null) { item.ClientSideCommand = "goToUrl('" + functionRight.Function.PageUrl + "');"; //item.NavigateUrl = functionRight.Function.PageUrl; //item.Target = "ContentFrame"; parentItem.Items.Add(item); } } } } }
/// <summary> /// 记时 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Callback1_Callback(object sender, CallBackEventArgs e) { if (PrjPub.IsWuhan()) { return; } if (string.IsNullOrEmpty(e.Parameters[0].ToString()) || string.IsNullOrEmpty(e.Parameters[1].ToString())) { return; } DateTime starttime; DateTime endtime; try { starttime = Convert.ToDateTime(e.Parameters[0]); endtime = Convert.ToDateTime(e.Parameters[1]); } catch { return; } TimeSpan ts = endtime.Subtract(starttime); int spanLoginTime = ts.Hours * 3600 + ts.Minutes * 60 + ts.Seconds; EmployeeBLL employeeBLL = new EmployeeBLL(); Employee employyee = employeeBLL.GetEmployee(Convert.ToInt32(e.Parameters[2])); int oldLogintime = employyee.LoginTime; employyee.LoginTime = oldLogintime + spanLoginTime; SystemUserBLL systemUserBLL = new SystemUserBLL(); SystemUser loginUser = systemUserBLL.GetUserByEmployeeID(Convert.ToInt32(e.Parameters[2])); SessionSet.UserID = loginUser.UserID; SessionSet.EmployeeID = loginUser.EmployeeID; SessionSet.EmployeeName = employyee.EmployeeName; SessionSet.OrganizationID = employyee.OrgID; SessionSet.OrganizationName = employyee.OrgName; if (PrjPub.IsServerCenter) { employeeBLL.UpdateEmployee(employyee); } else { employeeBLL.UpdateEmployeeInStation(employyee); } }
protected void btnLast_Click(object sender, ImageClickEventArgs e) { string strId = Request.QueryString.Get("id"); string strStartMode = ViewState["startmode"].ToString(); string strFlag = ""; if (ViewState["mode"].ToString() == "Insert") { strFlag = "Edit"; } else if (ViewState["mode"].ToString() == "Edit") { RandomExamResultBLL reBll = new RandomExamResultBLL(); IList <RailExam.Model.RandomExamResult> examResults = reBll.GetRandomExamResultByExamID(Convert.ToInt32(strId)); if (examResults.Count > 0) { strFlag = "ReadOnly"; } else { strFlag = ViewState["mode"].ToString(); } } else { strFlag = ViewState["mode"].ToString(); } if (PrjPub.IsWuhan()) { Response.Redirect("RandomExamManageThird.aspx?startmode=" + strStartMode + "&mode=" + strFlag + "&id=" + strId); } else { string strItemType = ""; RandomExamSubjectBLL objSubjectBll = new RandomExamSubjectBLL(); IList <RandomExamSubject> objSubjectList = objSubjectBll.GetRandomExamSubjectByRandomExamId(Convert.ToInt32(strId)); foreach (RandomExamSubject subject in objSubjectList) { if (strItemType == "") { strItemType = subject.ItemTypeId.ToString(); } else { strItemType = strItemType + "|" + subject.ItemTypeId; } } Response.Redirect("/RailExamBao/RandomExamOther/RandomExamStrategyInfo.aspx?startmode=" + strStartMode + "&mode=" + strFlag + "&itemType=" + strItemType + "&id=" + strId); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { hfIsWuhan.Value = PrjPub.IsWuhan().ToString(); if (PrjPub.HasEditRight("教材管理") && PrjPub.IsServerCenter) //&& PrjPub.CurrentLoginUser.SuitRange == 1 { HfUpdateRight.Value = "True"; } else { HfUpdateRight.Value = "False"; } if (PrjPub.HasDeleteRight("教材管理") && PrjPub.IsServerCenter) { HasDeleteRight.Value = "True"; } else { HasDeleteRight.Value = "False"; } BindDdl(); DateTime start = new DateTime(2000, 1, 1); DateTime end = new DateTime(2100, 12, 31); BookUpdateBLL objBll = new BookUpdateBLL(); IList <BookUpdate> objList = objBll.GetBookUpdateBySelect(0, "", "", start, end, ""); dgUpdate.DataSource = objList; dgUpdate.DataBind(); } string strRefreshGrid = Request.Form.Get("RefreshGrid"); if (strRefreshGrid != null & strRefreshGrid != "") { BindGrid(); } string strID = Request.Form.Get("DeleteID"); if (strID != null & strID != "") { BookUpdateBLL objBll = new BookUpdateBLL(); objBll.DeleteBookUpdate(Convert.ToInt32(strID)); BindGrid(); } }
protected void Page_Load(object sender, EventArgs e) { //if (PrjPub.IsEvaluation) //{ // DateTime strEnd = Convert.ToDateTime(PrjPub.EvaluationDate); // if (DateTime.Today > strEnd) // { // Response.Write(ViewState["OverTime"].ToString()); // } //} if (!IsPostBack) { //hf.Value = "0"; hfIsWuhan.Value = PrjPub.IsWuhan().ToString(); hfIsShowResult.Value = ConfigurationManager.AppSettings["IsShowResult"]; } }
protected void Page_Load(object sender, EventArgs e) { //if (PrjPub.IsEvaluation) //{ // DateTime strEnd = Convert.ToDateTime(PrjPub.EvaluationDate); // if (DateTime.Today > strEnd) // { // Response.Write(ViewState["OverTime"].ToString()); // } //} if (PrjPub.IsWuhan()) { hfIswuhan.Value = "1"; } else { hfIswuhan.Value = "0"; } }
private void DeleteData(int nEmployeID) { EmployeeBLL employeeBLL = new EmployeeBLL(); if (employeeBLL.CanDeleteEmployee(nEmployeID)) { if (!PrjPub.IsWuhan()) { EmployeeDetailBLL objBll = new EmployeeDetailBLL(); objBll.DeleteEmployeeDetail(nEmployeID); } else { employeeBLL.DeleteEmployee(nEmployeID); } } else { SessionSet.PageMessage = "该员工已参加考试,不能删除!"; return; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (PrjPub.CurrentLoginUser == null && PrjPub.CurrentStudent == null) { Response.Redirect("/RailExamBao/Common/Error.aspx?error=Session过期请重新登录本系统!"); return; } string sbInnerHtml = "<ul id='navigation'>"; if (!string.IsNullOrEmpty(Request.QueryString.Get("type")) && Request.QueryString.Get("type") == "employee") { OracleAccess oa = new OracleAccess(); string sql = "select * from SYSTEM_FUNCTION t where function_type = 4 order by function_id"; DataSet ds = oa.RunSqlDataSet(sql); if (ds != null && ds.Tables.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { if (row["function_id"].ToString().Length == 2) { sbInnerHtml += "<li><a class='head'>" + row["menu_name"] + "</a>"; sbInnerHtml += "<ul>"; //添加二级功能菜单 foreach (DataRow row1 in ds.Tables[0].Rows) { if (row1["function_id"].ToString().Length == 4 && row1["function_id"].ToString().IndexOf(row["function_id"].ToString()) == 0) { sbInnerHtml += @"<li><a href='" + row1["page_url"].ToString() + "' target='I2'>" + row1["menu_name"].ToString() + "</a></li>"; } } sbInnerHtml += "</ul>"; } sbInnerHtml += "</li>"; } sbInnerHtml += "</ul>"; this.menu.InnerHtml = sbInnerHtml; } } else { foreach (FunctionRight functionRight in PrjPub.CurrentLoginUser.FunctionRights) { if (PrjPub.IsWuhan()) { if (functionRight.Function.FunctionID == "0406") { continue; } } if (functionRight.Right == 0) { continue; } if (functionRight.Function.FunctionID.Length == 2) { sbInnerHtml += "<li><a class='head'>" + functionRight.Function.MenuName + "</a>"; sbInnerHtml += "<ul>"; //添加二级功能菜单 foreach (FunctionRight functionRight1 in PrjPub.CurrentLoginUser.FunctionRights) { if (functionRight1.Right == 0) { continue; } if (functionRight1.Function.FunctionID.Length == 4 && functionRight1.Function.FunctionID.IndexOf(functionRight.Function.FunctionID) == 0) { sbInnerHtml += @"<li><a href='" + functionRight1.Function.PageUrl + "' target='I2'>" + functionRight1.Function.MenuName + "</a></li>"; } } sbInnerHtml += "</ul>"; } sbInnerHtml += "</li>"; } sbInnerHtml += "</ul>"; this.menu.InnerHtml = sbInnerHtml; } } }
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>"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (PrjPub.CurrentLoginUser == null) { Response.Redirect("/RailExamBao/Common/Error.aspx?error=Session过期请重新登录本系统!"); return; } hfIsWuhan.Value = PrjPub.IsWuhan().ToString(); string strBookID = Request.QueryString.Get("id"); ViewState["BookID"] = strBookID; hfMode.Value = Request.QueryString.Get("mode"); if (strBookID != null && strBookID != "") { if (PrjPub.CurrentLoginUser.RoleID == 1) { ImgSelectEmployee.Visible = true; } else { ImgSelectEmployee.Visible = false; } if (hfMode.Value == "ReadOnly") { SaveButton.Visible = false; CancelButton.Visible = true; SaveNextButton.Visible = false; SaveExitButton.Visible = false; //ClientScript.RegisterStartupScript(GetType(), "jsHide", "<script>document.all.ImgSelectKnowledge.style.display='none';</script>"); //Response.Write("<script>document.all.ImgSelectKnowledge.style.display='none';</script>"); } else if (hfMode.Value == "Edit") { btnCover.Visible = false; btnChapter.Visible = true; SaveButton.Visible = true; CancelButton.Visible = false; SaveExitButton.Visible = false; SaveNextButton.Visible = false; } FillPage(int.Parse(strBookID)); } else { if (PrjPub.CurrentLoginUser.RoleID != 1) { ImgSelectEmployee.Visible = false; } SaveButton.Visible = false; SaveNextButton.Visible = true; SaveExitButton.Visible = true; CancelButton.Visible = false; datePublishDate.DateValue = DateTime.Today.ToString("yyyy-MM-dd"); string strKnowledgeID = Request.QueryString.Get("knowledgeId"); if (strKnowledgeID != null && strKnowledgeID != string.Empty) { hfKnowledgeID.Value = strKnowledgeID; KnowledgeBLL objBll = new KnowledgeBLL(); RailExam.Model.Knowledge obj = objBll.GetKnowledge(Convert.ToInt32(strKnowledgeID)); txtKnowledgeName.Text = txtKnowledgeName.Text + GetKnowledgeName("/" + obj.KnowledgeName, obj.ParentId); ImgSelectKnowledge.Visible = false; } ArrayList objOrgList = new ArrayList(); if (PrjPub.CurrentLoginUser.SuitRange == 0) { OrganizationBLL orgBll = new OrganizationBLL(); txtPublishOrgName.Text = orgBll.GetOrganization(PrjPub.CurrentLoginUser.StationOrgID).ShortName; hfPublishOrgID.Value = PrjPub.CurrentLoginUser.StationOrgID.ToString(); IList <Organization> objOrganizationList = orgBll.GetOrganizationsByWhereClause("ID_Path || '/' like '/1/" + PrjPub.CurrentLoginUser.StationOrgID + "/%' "); foreach (Organization organization in objOrganizationList) { objOrgList.Add(organization.OrganizationId); } } txtAuthors.Text = PrjPub.CurrentLoginUser.EmployeeName; hfEmployeeID.Value = PrjPub.CurrentLoginUser.EmployeeID.ToString(); //txtPublishOrgName.Text = PrjPub.CurrentLoginUser.OrgName; //hfPublishOrgID.Value = PrjPub.CurrentLoginUser.OrgID.ToString(); BindOrganizationTree(objOrgList); ArrayList objList = new ArrayList(); if (!string.IsNullOrEmpty(Request.QueryString.Get("PostId"))) { objList.Add(Convert.ToInt32(Request.QueryString.Get("PostId"))); } BindPostTree(objList); ddlTech.SelectedValue = "1"; } } if (!string.IsNullOrEmpty(hfTrainTypeID.Value)) { TrainTypeBLL objBll = new TrainTypeBLL(); string[] str = hfTrainTypeID.Value.Split(','); string strTypeName = ""; for (int i = 0; i < str.Length; i++) { TrainType obj = objBll.GetTrainTypeInfo(Convert.ToInt32(str[i])); if (i == 0) { strTypeName = GetTrainTypeName("/" + obj.TypeName, obj.ParentID); } else { strTypeName = strTypeName + "," + GetTrainTypeName("/" + obj.TypeName, obj.ParentID); } } txtTrainTypeName.Text = strTypeName; } if (!string.IsNullOrEmpty(hfPublishOrgID.Value)) { OrganizationBLL orgbll = new OrganizationBLL(); txtPublishOrgName.Text = orgbll.GetOrganization(Convert.ToInt32(hfPublishOrgID.Value)).ShortName; } string strRefresh = Request.Form.Get("RefreshCover"); if (strRefresh != null && strRefresh != "") { //string strPath = "../Book/" + ViewState["BookID"].ToString() + "/cover.htm"; //BookBLL objBill = new BookBLL(); //objBill.UpdateBookUrl(Convert.ToInt32(ViewState["BookID"].ToString()), strPath); //string strBookName = objBill.GetBook(Convert.ToInt32(ViewState["BookID"].ToString())).bookName; //string srcPath = "../Online/Book/" + ViewState["BookID"].ToString() + "/Cover.htm"; //string str = File.ReadAllText(Server.MapPath(srcPath), 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(srcPath), str, System.Text.Encoding.UTF8); //BookChapterBLL objChapterBll = new BookChapterBLL(); //objChapterBll.GetIndex(ViewState["BookID"].ToString()); //SystemLogBLL objLogBll = new SystemLogBLL(); //objLogBll.WriteLog("编辑教材《" + strBookName + "》前言"); //FillPage(Convert.ToInt32(ViewState["BookID"].ToString())); } }
protected void btnExcel_Click(object sender, EventArgs e) { RandomExamBLL objBll = new RandomExamBLL(); RailExam.Model.RandomExam objRandomExam = objBll.GetExam(Convert.ToInt32(Request.QueryString.Get("id"))); SpreadsheetClass xlsheet = new SpreadsheetClass(); Worksheet ws = (Worksheet)xlsheet.Worksheets[1]; ws.Cells.Font.set_Size(10); ws.Cells.Font.set_Name("宋体"); ws.Cells[1, 1] = objRandomExam.ExamName + " 参加考试学员名单"; Range rang1 = ws.get_Range(ws.Cells[1, 1], ws.Cells[1, 7]); rang1.set_MergeCells(true); rang1.set_HorizontalAlignment(XlHAlign.xlHAlignCenter); rang1.Font.set_Name("宋体"); //write headertext ws.Cells[2, 1] = "序号"; ((Range)ws.Cells[2, 1]).set_HorizontalAlignment(XlHAlign.xlHAlignCenter); ws.Cells[2, 2] = "姓名"; ws.get_Range(ws.Cells[2, 2], ws.Cells[2, 2]).set_MergeCells(true); ws.get_Range(ws.Cells[2, 2], ws.Cells[2, 2]).set_HorizontalAlignment(XlHAlign.xlHAlignCenter); if (PrjPub.IsWuhan()) { ws.Cells[2, 3] = "员工编码"; } else { ws.Cells[2, 3] = "工资编号"; } ws.get_Range(ws.Cells[2, 3], ws.Cells[2, 3]).set_MergeCells(true); ws.get_Range(ws.Cells[2, 3], ws.Cells[2, 3]).set_HorizontalAlignment(XlHAlign.xlHAlignCenter); ws.Cells[2, 4] = "职名"; ws.get_Range(ws.Cells[2, 4], ws.Cells[2, 4]).set_MergeCells(true); ws.get_Range(ws.Cells[2, 4], ws.Cells[2, 4]).set_HorizontalAlignment(XlHAlign.xlHAlignCenter); ws.Cells[2, 5] = "组织机构"; ws.get_Range(ws.Cells[2, 5], ws.Cells[2, 7]).set_MergeCells(true); ws.get_Range(ws.Cells[2, 5], ws.Cells[2, 7]).set_HorizontalAlignment(XlHAlign.xlHAlignCenter); ws.Cells[2, 8] = "考试地点"; ws.get_Range(ws.Cells[2, 8], ws.Cells[2, 10]).set_MergeCells(true); ws.get_Range(ws.Cells[2, 8], ws.Cells[2, 10]).set_HorizontalAlignment(XlHAlign.xlHAlignCenter); for (int j = 0; j < gvChoose.Rows.Count; j++) { ws.Cells[3 + j, 1] = ((Label)gvChoose.Rows[j].FindControl("lblNo")).Text; ws.Cells[3 + j, 2] = ((Label)gvChoose.Rows[j].FindControl("LabelName")).Text; ws.get_Range(ws.Cells[3 + j, 2], ws.Cells[3 + j, 2]).set_MergeCells(true); ws.get_Range(ws.Cells[3 + j, 2], ws.Cells[3 + j, 2]).set_HorizontalAlignment(XlHAlign.xlHAlignLeft); ws.Cells[3 + j, 3] = "'" + ((Label)gvChoose.Rows[j].FindControl("LabelWorkNo")).Text; ws.get_Range(ws.Cells[3 + j, 3], ws.Cells[3 + j, 3]).set_MergeCells(true); ws.get_Range(ws.Cells[3 + j, 3], ws.Cells[3 + j, 3]).set_HorizontalAlignment(XlHAlign.xlHAlignLeft); ws.Cells[3 + j, 4] = ((Label)gvChoose.Rows[j].FindControl("LabelPostName")).Text; ws.get_Range(ws.Cells[3 + j, 4], ws.Cells[3 + j, 4]).set_MergeCells(true); ws.get_Range(ws.Cells[3 + j, 4], ws.Cells[3 + j, 4]).set_HorizontalAlignment(XlHAlign.xlHAlignLeft); ws.Cells[3 + j, 5] = ((Label)gvChoose.Rows[j].FindControl("Labelorgid")).Text; ws.get_Range(ws.Cells[3 + j, 5], ws.Cells[3 + j, 7]).set_MergeCells(true); ws.get_Range(ws.Cells[3 + j, 5], ws.Cells[3 + j, 7]).set_HorizontalAlignment(XlHAlign.xlHAlignCenter); ws.Cells[3 + j, 8] = ((Label)gvChoose.Rows[j].FindControl("lblComputeRoom")).Text; ws.get_Range(ws.Cells[3 + j, 8], ws.Cells[3 + j, 10]).set_MergeCells(true); ws.get_Range(ws.Cells[3 + j, 8], ws.Cells[3 + j, 10]).set_HorizontalAlignment(XlHAlign.xlHAlignCenter); } ws.Name = "1-1"; ws.Cells.Columns.AutoFit(); try { ((Worksheet)xlsheet.Worksheets[1]).Activate(); string path = Server.MapPath("../Excel/Excel.xls"); if (File.Exists(path)) { File.Delete(path); } xlsheet.Export(path, SheetExportActionEnum.ssExportActionNone, SheetExportFormat.ssExportAsAppropriate); FileInfo file = new FileInfo(path); this.Response.Clear(); this.Response.Buffer = true; this.Response.Charset = "utf-7"; this.Response.ContentEncoding = Encoding.UTF7; // 添加头信息,为"文件下载/另存为"对话框指定默认文件名 this.Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode(objRandomExam.ExamName + "参加考试学员名单") + ".xls"); // 添加头信息,指定文件大小,让浏览器能够显示下载进度 this.Response.AddHeader("Content-Length", file.Length.ToString()); // 指定返回的是一个不能被客户端读取的流,必须被下载 this.Response.ContentType = "application/ms-excel"; // 把文件流发送到客户端 this.Response.WriteFile(file.FullName); } catch { SessionSet.PageMessage = "系统错误,导出Excel文件失败!"; } }
protected void SaveButton_Click(object sender, EventArgs e) { BookUpdateBLL BookUpdateBLL = new BookUpdateBLL(); BookUpdate BookUpdate = new BookUpdate(); string strUpdateObject = Request.QueryString.Get("Object"); if (txtCause.Text == string.Empty) { SessionSet.PageMessage = "更改原因不能为空!"; return; } if (txtContent.Text == string.Empty) { SessionSet.PageMessage = "更改内容不能为空!"; return; } if (ViewState["AddFlag"].ToString() == "1") //新增 { BookBLL objBookBll = new BookBLL(); BookUpdate.BookId = int.Parse(ViewState["BookID"].ToString()); BookUpdate.ChapterId = int.Parse(ViewState["ChapterID"].ToString()); BookUpdate.updatePerson = lblPerson.Text; BookUpdate.updateDate = DateTime.Parse(lblDate.Text); BookUpdate.updateCause = txtCause.Text; BookUpdate.updateContent = txtContent.Text; BookUpdate.Memo = txtMemo.Text; BookUpdate.BookNameBak = objBookBll.GetBook(Convert.ToInt32(ViewState["BookID"].ToString())).bookName; if (ViewState["ChapterID"].ToString() != "0") { BookChapterBLL objChapterBll = new BookChapterBLL(); BookUpdate.ChapterNameBak = objChapterBll.GetBookChapter(Convert.ToInt32(ViewState["ChapterID"].ToString())).ChapterName; } if (strUpdateObject == "insertchapterinfo") { BookUpdate.ChapterNameBak = Server.UrlDecode(Request.QueryString.Get("newchaptername")); BookUpdate.UpdateObject = PrjPub.BOOKUPDATEOBJECT_INSERTCHAPTERINFO; } else if (strUpdateObject == "updatechapterinfo") { BookUpdate.UpdateObject = PrjPub.BOOKUPDATEOBJECT_UPDATECHAPTERINFO; } else if (strUpdateObject == "chaptercontent") { BookUpdate.UpdateObject = PrjPub.BOOKUPDATEOBJECT_CHAPTERCONTENT; } else if (strUpdateObject == "delbook") { BookUpdate.UpdateObject = PrjPub.BOOKUPDATEOBJECT_DELBOOK; } else if (strUpdateObject == "delchapter") { BookUpdate.UpdateObject = PrjPub.BOOKUPDATEOBJECT_DELCHAPTER; } else { BookUpdate.UpdateObject = lblChapterName.Text; } BookUpdateBLL.AddBookUpdate(BookUpdate); Response.Write("<script>top.returnValue='true';window.close();</script>"); } else //修改 { BookUpdate.BookId = int.Parse(ViewState["BookID"].ToString()); BookUpdate.ChapterId = int.Parse(ViewState["ChapterID"].ToString()); BookUpdate.updatePerson = lblPerson.Text; BookUpdate.updateDate = DateTime.Parse(lblDate.Text); BookUpdate.updateCause = txtCause.Text; BookUpdate.updateContent = txtContent.Text; BookUpdate.Memo = txtMemo.Text; BookUpdate.bookUpdateId = int.Parse(Request.QueryString.Get("id")); BookUpdateBLL.UpdateBookUpdate(BookUpdate); if (PrjPub.IsWuhan()) { Response.Write("<script>window.opener.form1.RefreshGrid.value='true';window.opener.form1.submit();window.close();</script>"); } else { Response.Write("<script>top.returnValue='true';window.close();</script>"); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { hfOrgID.Value = PrjPub.CurrentLoginUser.StationOrgID.ToString(); ViewState["mode"] = Request.QueryString.Get("mode"); ViewState["startmode"] = Request.QueryString.Get("startmode"); hfMode.Value = ViewState["mode"].ToString(); _isWuhan = PrjPub.IsWuhan(); _isWuhanOnly = PrjPub.IsWuhanOnly(); dateBeginTime.DateValue = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); dateEndTime.DateValue = DateTime.Now.AddDays(7).ToString("yyyy-MM-dd HH:mm:ss"); string ExamCategoryID = Request.QueryString.Get("ExamCategoryIDPath"); if (ExamCategoryID == "0") { ExamCategoryID = ""; } if (!string.IsNullOrEmpty(ExamCategoryID)) { string[] str1 = ExamCategoryID.Split(new char[] { '/' }); int nID = int.Parse(str1[str1.LongLength - 1].ToString()); hfCategoryId.Value = nID.ToString(); ExamCategoryBLL pcl = new ExamCategoryBLL(); RailExam.Model.ExamCategory pc = pcl.GetExamCategory(nID); txtCategoryName.Text = pc.CategoryName; } OracleAccess db = new OracleAccess(); string strSql = "select * from Random_Exam_Modular_Type order by Level_Num"; DataSet ds = db.RunSqlDataSet(strSql); ListItem item = new ListItem(); item.Text = "--请选择--"; item.Value = "0"; ddlModularType.Items.Add(item); foreach (DataRow dr in ds.Tables[0].Rows) { item = new ListItem(); item.Text = dr["Random_Exam_Modular_Type_Name"].ToString(); item.Value = dr["Random_Exam_Modular_Type_ID"].ToString(); ddlModularType.Items.Add(item); } string strExamID = Request.QueryString.Get("id"); if (!string.IsNullOrEmpty(strExamID)) { FillPage(int.Parse(strExamID)); } else { rbnStyle2.Checked = true; saveTd.Visible = true; ddlDate.SelectedValue = "1"; dateSaveDate.Visible = false; SetTrainClassVisible(false); } } if (hfPostID.Value != "") { txtPost.Text = hfPostName.Value; } if (hfCategoryId.Value != "") { ExamCategoryBLL pcl = new ExamCategoryBLL(); RailExam.Model.ExamCategory pc = pcl.GetExamCategory(Convert.ToInt32(hfCategoryId.Value)); txtCategoryName.Text = pc.CategoryName; } chkHasTrainClass.Attributes.Add("onclick", "chkHasTrainClassOnchange();"); }
protected void Page_Load(object sender, EventArgs e) { hfChapterID.Value = Request.QueryString["id"]; hfIsWuhan.Value = PrjPub.IsWuhan().ToString(); if (fvBookChapter.CurrentMode == FormViewMode.Insert) { if (hfInsert.Value == "-1") { ((HiddenField)fvBookChapter.FindControl("hfParentID")).Value = Request.QueryString["ParentID"]; ((HiddenField)fvBookChapter.FindControl("hfBookID")).Value = Request.QueryString["BookID"]; } else { ((HiddenField)fvBookChapter.FindControl("hfParentId")).Value = hfInsert.Value; ((HiddenField)fvBookChapter.FindControl("hfBookID")).Value = Request.QueryString["BookID"]; } if (Request.QueryString["Mode"] == "Edit") { ((HiddenField)fvBookChapter.FindControl("hfIsEdit")).Value = "true"; } else { ((HiddenField)fvBookChapter.FindControl("hfIsEdit")).Value = "false"; } } else if (fvBookChapter.CurrentMode == FormViewMode.Edit) { if (Request.QueryString["Mode"] == "Edit") { ((HiddenField)fvBookChapter.FindControl("hfIsEdit")).Value = "true"; } else { ((HiddenField)fvBookChapter.FindControl("hfIsEdit")).Value = "false"; } } string strRefresh = Request.Form.Get("Refresh"); if (strRefresh != null & strRefresh != "") { string strPath = "../Online/Book/" + Request.QueryString["BookID"].ToString() + "/" + Request.QueryString["id"].ToString() + ".htm"; BookChapterBLL objBill = new BookChapterBLL(); objBill.UpdateBookChapterUrl(Convert.ToInt32(Request.QueryString["id"].ToString()), strPath); RailExam.Model.BookChapter objBookChapter = objBill.GetBookChapter(Convert.ToInt32(Request.QueryString["id"].ToString())); string strChapterName = objBookChapter.ChapterName; string str = File.ReadAllText(Server.MapPath(strPath), Encoding.UTF8); if (str.IndexOf("chaptertitle") < 0) { if (objBookChapter.LevelNum < 3) { str = "<link href='book.css' type='text/css' rel='stylesheet' />" + "<body oncontextmenu='return false' ondragstart='return false' onselectstart ='return false' oncopy='document.selection.empty()' onbeforecopy='return false'>" + "<div id='chaptertitle" + objBookChapter.LevelNum + "'>" + strChapterName + "</div>" + "<br>" + str + "</body>"; } else { str = "<link href='book.css' type='text/css' rel='stylesheet' />" + "<body oncontextmenu='return false' ondragstart='return false' onselectstart ='return false' oncopy='document.selection.empty()' onbeforecopy='return false'>" + "<div id='chaptertitle3'>" + strChapterName + "</div>" + "<br>" + str + "</body>"; } File.WriteAllText(Server.MapPath(strPath), str, Encoding.UTF8); } BookBLL objBookBill = new BookBLL(); if (Request.QueryString.Get("Mode") == "Edit") { objBookBill.UpdateBookVersion(Convert.ToInt32(Request.QueryString["BookID"].ToString())); } string strBookName = objBookBill.GetBook(Convert.ToInt32(Request.QueryString["BookID"].ToString())).bookName; SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("编辑教材《" + strBookName + "》中“" + strChapterName + "”的章节内容"); fvBookChapter.DataBind(); Grid1.DataBind(); objBill.GetIndex(Request.QueryString["BookID"].ToString()); ItemBLL objBll = new ItemBLL(); IList <RailExam.Model.Item> objList = objBll.GetItemsByBookChapterId(Convert.ToInt32(Request.QueryString["BookID"]), Convert.ToInt32(Request.QueryString["id"]), 0, 0); if (objList.Count > 0) { ClientScript.RegisterStartupScript(GetType(), "jsSelectFirstNode", @"var ret = window.showModalDialog('/RailExamBao/Book/ItemEnabled.aspx?BookID=" + Request.QueryString["BookID"] + @"&ChapterID=" + Request.QueryString["id"] + @"','','help:no; status:no;dialogWidth:300px;dialogHeight:120px;');", true); } } string strRefreshGrid = Request.Form.Get("RefreshGrid"); if (strRefreshGrid != null & strRefreshGrid != "") { fvBookChapter.DataBind(); Grid1.DataBind(); } string strDeleteBookChapterUpdateID = Request.Form.Get("DeleteBookChapterUpdateID"); if (!string.IsNullOrEmpty(strDeleteBookChapterUpdateID)) { DeleteData(int.Parse(strDeleteBookChapterUpdateID)); Grid1.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (PrjPub.CurrentLoginUser == null) { Response.Redirect("/RailExamBao/Common/Error.aspx?error=Session过期请重新登录本系统!"); return; } 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"; } HfOrgId.Value = PrjPub.CurrentLoginUser.StationOrgID.ToString(); if (PrjPub.IsWuhanOnly() && PrjPub.IsServerCenter) { btnAddBookItem.Visible = true; } else { btnAddBookItem.Visible = false; } hfRailSystemId.Value = PrjPub.GetRailSystemId().ToString(); } if (!IsPostBack && !ddlViewChangeCallBack.IsCallback && !treeNodeSelectedCallBack.IsCallback && !itemsGrid.IsCallback) { BindKnowledgeTree(""); } if (hfIsSearchCommand.Value == "true") { itemsGrid.CurrentPageIndex = 0; itemsGrid.DataBind(); hfIsSearchCommand.Value = "false"; } if (hfRefresh.Value != "") { if (PrjPub.IsWuhan()) { DownloadWord(hfRefresh.Value); } else { DownloadExcel(hfRefresh.Value); } } string strRefresh = Request.Form.Get("refresh"); if (!string.IsNullOrEmpty(strRefresh)) { itemsGrid.DataBind(); } if (!string.IsNullOrEmpty(hfPostID.Value)) { PostBLL post = new PostBLL(); txtPost.Text = post.GetPost(Convert.ToInt32(hfPostID.Value)).PostName; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (PrjPub.CurrentLoginUser == null) { Response.Redirect("/RailExamBao/Common/Error.aspx?error=Session过期请重新登录本系统!"); return; } if (PrjPub.HasEditRight("角色权限") && PrjPub.IsServerCenter) { HfUpdateRight.Value = "True"; } else { HfUpdateRight.Value = "False"; } if (PrjPub.HasDeleteRight("角色权限") && PrjPub.IsServerCenter) { HfDeleteRight.Value = "True"; } else { HfDeleteRight.Value = "False"; } if (PrjPub.HasEditRight("职员管理") && PrjPub.IsServerCenter) { HfUpdateRight.Value = "True"; } else { HfUpdateRight.Value = "False"; } if (PrjPub.HasDeleteRight("职员管理") && PrjPub.IsServerCenter) { HfDeleteRight.Value = "True"; } else { HfDeleteRight.Value = "False"; } if (PrjPub.IsWuhan()) { Grid1.Levels[0].Columns[1].HeadingText = "员工编码"; lblTitle.Text = "员工编码"; } else { Grid1.Levels[0].Columns[1].HeadingText = "工资编号"; lblTitle.Text = "工资编号"; } BindGrid(); IsWuhan.Value = PrjPub.IsWuhan().ToString(); IsWuhanOnly.Value = PrjPub.IsWuhanOnly().ToString(); hfAdmin.Value = PrjPub.CurrentLoginUser.IsAdmin.ToString(); NowEmployeeID.Value = PrjPub.CurrentLoginUser.EmployeeID.ToString(); } else { string strDeleteID = Request.Form.Get("DeleteID"); if (!string.IsNullOrEmpty(strDeleteID)) { if (strDeleteID == "1" || strDeleteID == "2") { SessionSet.PageMessage = "该员工为最高权限用户,不能被删除!"; BindGrid(); return; } DeleteData(int.Parse(strDeleteID)); BindGrid(); } string strRefresh = Request.Form.Get("Refresh"); if (strRefresh == "true") { BindGrid(); } string strUpdate = Request.Form.Get("UpdatePsw"); if (!string.IsNullOrEmpty(strUpdate)) { SystemUserBLL objBll = new SystemUserBLL(); SystemUser obj = objBll.GetUserByEmployeeID(Convert.ToInt32(strUpdate)); if (obj != null) { obj.Password = "******"; if (PrjPub.IsServerCenter) { objBll.UpdateUser(obj); } else { objBll.UpdateUserPsw(obj.UserID, "111111"); } SessionSet.PageMessage = "初始化密码成功!"; } else { SessionSet.PageMessage = "该员工登录帐户不存在,初始化密码失败!"; } BindGrid(); } } }