protected void btnFilter_Click(object sender, EventArgs e) { DataClassesDataContext dc = new DataClassesDataContext(); switch (Session[SessionMgm.Role].ToString()) { case "申请人员": break; case "系统管理员": case "组织部部长": // 仅显示已超过截止申报时间的申请 condition = (short)ProjectStatus.EStatus.ApplicantComplete; break; } if (-1 != condition) { List <String> userIDs = Global.GetSuitUsers(Session); var datasource = from x in dc.ViewPosApl.AsEnumerable() where userIDs.Contains(x.F_UserID) && x.F_statusEnum.Equals(condition) orderby x.F_appliedDate descending select x; GridView1.DataSource = UtilHelper.ToDataTable(datasource); Session.Add(SessionMgm.DataSource, GridView1.DataSource); GridView1.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ddlType.DataSource = SearchType.Types; ddlType.DataBind(); GridView1.DataSourceID = null; var datasource = getDatasource(false); GridView1.DataSource = UtilHelper.ToDataTable(datasource); Session.Add(SessionMgm.DataSource, GridView1.DataSource); GridView1.DataBind(); if (Session[SessionMgm.Role].ToString().Equals(RoleType.Expert)) { btnFilter.Visible = false; btnAllRecord.Visible = false; } else { btnAdd.Visible = false; } if (Session[SessionMgm.Role].ToString().Equals(RoleType.EduAdmin)) { btnAllRecord.Text = "查看审核通过"; btnBatPass.Visible = true; btnBatDeny.Visible = true; btnComment.Visible = true; btnDel.Visible = false; } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ddlType.DataSource = SearchType.AllTypes; ddlType.DataBind(); GridView1.DataSourceID = null; IEnumerable <ViewPosApl> datasource = getDatasource(false); GridView1.DataSource = UtilHelper.ToDataTable(datasource); Session.Add(SessionMgm.DataSource, GridView1.DataSource); GridView1.DataBind(); if (Session[SessionMgm.Role].ToString().Equals(RoleType.Applicant) == false) { //btnAllRecord.Text = "查看审核通过"; // btnGenNotice.Visible = true; btnGenList.Visible = true; btnGenCmprList.Visible = true; } else { // btnFilter.Visible = false; // btnAllRecord.Visible = false; } } }
DataTable GetDepts() { HttpSessionState Session = HttpContext.Current.Session; DataClassesDataContext dc = new DataClassesDataContext(); var depts = dc.DeptMent.Where(dm => dm.F_unitID.Equals(Session[SessionMgm.UnitID].ToString())); return(UtilHelper.ToDataTable(depts)); }
public DataTable GetApprovalPros() { HttpSessionState Session = HttpContext.Current.Session; DataClassesDataContext dc = new DataClassesDataContext(); String role = Session[SessionMgm.Role].ToString(); List <String> userIDs = Global.GetSuitUsers(Session); IEnumerable <ViewAuditedBySchool> auditedBySchool = dc.ViewAuditedBySchool.AsEnumerable().Where(_vu => userIDs.Contains(_vu.F_leaderID) && _vu.F_status.Equals(ProjectStatus.Approval)); return(UtilHelper.ToDataTable(auditedBySchool)); }
protected void btnAllRecord_Click(object sender, EventArgs e) { DataClassesDataContext dc = new DataClassesDataContext(); List <String> userIDs = Global.GetSuitUsers(Session); IEnumerable <ViewPosApl> datasource = getDatasource(false); GridView1.DataSource = UtilHelper.ToDataTable(datasource); Session.Add(SessionMgm.DataSource, GridView1.DataSource); GridView1.DataBind(); }
public DataTable GetUsedSciProject(String guideID, String unitID) { DataClassesDataContext dc = new DataClassesDataContext(); IQueryable <ScienceProject> projects = null; projects = dc.ScienceProject.Where(_sp => _sp.F_unitID.Equals(unitID) && _sp.F_guideProjectID.Equals(guideID) && (ProjectStatus.UnderEducationAudit.Equals(_sp.F_status) || ProjectStatus.Approval.Equals(_sp.F_status))); DataTable dt = UtilHelper.ToDataTable(projects); return(dt); }
public DataTable GetUsersInDept() { HttpSessionState Session = HttpContext.Current.Session; DataClassesDataContext dc = new DataClassesDataContext(); String role = Session[SessionMgm.Role].ToString(); IQueryable <ViewUserInDept> userIndepts; List <String> userIDs = Global.GetSuitUsers(Session); userIndepts = dc.ViewUserInDept.Where(_vu => userIDs.Contains(_vu.F_ID)); return(UtilHelper.ToDataTable(userIndepts)); }
public DataTable GetUsedProjectAllocation(String projectID) { DataClassesDataContext dc = new DataClassesDataContext(); IQueryable <ViewAssignProject> projects = dc.ViewAssignProject.Where(_ap => _ap.F_projectID.Equals(projectID)).OrderBy(_ap => _ap.F_seq); DataTable dt = UtilHelper.ToDataTable(projects); foreach (DataRow dr in dt.Rows) { String unitID = dr["F_unitID"].ToString(); String _projectID = dr["F_projectID"].ToString(); dr["F_sciImp"] = dc.ViewAuditedBySchool.Count(_vad => _vad.F_guideProjectID.Equals(_projectID) && _vad.F_type.Equals("重点") && unitID.Equals(_vad.F_unitID)); dr["F_sciIndustry"] = dc.ViewAuditedBySchool.Count(_vad => _vad.F_guideProjectID.Equals(_projectID) && _vad.F_type.Equals("产学研") && unitID.Equals(_vad.F_unitID)); dr["F_sciNormal"] = dc.ViewAuditedBySchool.Count(_vad => _vad.F_guideProjectID.Equals(_projectID) && _vad.F_type.Equals("一般") && unitID.Equals(_vad.F_unitID)); dr["F_sciB"] = dc.ViewAuditedBySchool.Count(_vad => _vad.F_guideProjectID.Equals(_projectID) && _vad.F_type.Equals("B类") && unitID.Equals(_vad.F_unitID)); dr["F_socialImpA"] = dc.ViewAuditedBySchool.Count(_vad => _vad.F_guideProjectID.Equals(_projectID) && _vad.F_type.Equals("A类重点项目") && unitID.Equals(_vad.F_unitID)); dr["F_socialNorA"] = dc.ViewAuditedBySchool.Count(_vad => _vad.F_guideProjectID.Equals(_projectID) && _vad.F_type.Equals("一般项目") && unitID.Equals(_vad.F_unitID)); dr["F_socialB"] = dc.ViewAuditedBySchool.Count(_vad => _vad.F_guideProjectID.Equals(_projectID) && _vad.F_type.Equals("B类项目") && unitID.Equals(_vad.F_unitID)); dr["F_socialProxy"] = dc.ViewAuditedBySchool.Count(_vad => _vad.F_guideProjectID.Equals(_projectID) && _vad.F_type.Equals("委托项目") && unitID.Equals(_vad.F_unitID)); decimal?sumOfSci = (from m in dc.ViewAuditedBySchool where m.F_projectType.Equals("科技项目") && m.F_guideProjectID.Equals(_projectID) && unitID.Equals(m.F_unitID) select m.F_fund).Sum(); decimal value1 = 0; if (sumOfSci != null) { value1 = sumOfSci.Value; } decimal?sumOfSocial = (from m in dc.ViewAuditedBySchool where m.F_projectType.Equals("社科项目") && m.F_guideProjectID.Equals(_projectID) && unitID.Equals(m.F_unitID) select m.F_fund).Sum(); decimal value2 = 0; if (sumOfSocial != null) { value2 = sumOfSocial.Value; } dr["F_amount"] = value1 + value2; } return(dt); }
protected void btnAllRecord_Click(object sender, EventArgs e) { DataClassesDataContext dc = new DataClassesDataContext(); List <String> userIDs = Global.GetSuitUsers(Session); IEnumerable <SocialProject> datasource; if (Session[SessionMgm.Role].ToString().Equals(RoleType.EduAdmin)) { datasource = from x in dc.SocialProject.AsEnumerable() where x.F_status.Equals(ProjectStatus.Pass) select x; } else { datasource = from x in dc.SocialProject.AsEnumerable() where userIDs.Contains(x.F_leaderID) select x; } GridView1.DataSource = UtilHelper.ToDataTable(datasource); Session.Add(SessionMgm.DataSource, GridView1.DataSource); GridView1.DataBind(); }
protected void btnSearch_Click(object sender, EventArgs e) { DataClassesDataContext dc = new DataClassesDataContext(); List <String> userIDs = Global.GetSuitUsers(Session); IEnumerable <AcceptApplicant> datasource = dc.AcceptApplicant.AsEnumerable().Where(_sp => userIDs.Contains(_sp.F_leaderID)); if (txtKeyword.Text.Trim().Length > 0) { DataTable dt = UtilHelper.ToDataTable(datasource); for (int i = 0; i < dt.Rows.Count; i++) { if (ddlType.SelectedValue.Equals(SearchType.ExactMatch)) { if (dt.Rows[i][ddlField.SelectedValue].ToString().Equals(txtKeyword.Text) == false) { dt.Rows.RemoveAt(i); i--; } } else if (ddlType.SelectedValue.Equals(SearchType.FuzzMatch)) { if (dt.Rows[i][ddlField.SelectedValue].ToString().Contains(txtKeyword.Text) == false) { dt.Rows.RemoveAt(i); i--; } } } GridView1.DataSource = dt; } else { GridView1.DataSource = datasource; } Session.Add(SessionMgm.DataSource, GridView1.DataSource); GridView1.DataBind(); }
protected void btnFilter_Click(object sender, EventArgs e) { DataClassesDataContext dc = new DataClassesDataContext(); switch (Session[SessionMgm.Role].ToString()) { case "申报人员(专家)": break; case "部门主管": condition = ProjectStatus.UnderDeptAudit; break; case "单位主管": condition = ProjectStatus.UnderSchoolAudit; break; case "教育厅管理人员": condition = ProjectStatus.UnderEducationAudit; break; } if (!String.IsNullOrWhiteSpace(condition)) { List <String> userIDs = Global.GetSuitUsers(Session); var datasource = from x in dc.ScienceProject.AsEnumerable() where userIDs.Contains(x.F_leaderID) && x.F_status.Equals(condition) select x; GridView1.DataSource = UtilHelper.ToDataTable(datasource); Session.Add(SessionMgm.DataSource, GridView1.DataSource); GridView1.DataBind(); } }
protected void btnSearch_Click(object sender, EventArgs e) { DataClassesDataContext dc = new DataClassesDataContext(); List <String> userIDs = Global.GetSuitUsers(Session); IEnumerable <ViewPosApl> datasource = getDatasource(false); if (txtKeyword.Text.Trim().Length > 0) { DataTable dt = UtilHelper.ToDataTable(datasource); for (int i = 0; i < dt.Rows.Count; i++) { if (ddlType.SelectedValue.Equals(SearchType.ExactMatch)) { if (dt.Rows[i][ddlField.SelectedValue].ToString().Equals(txtKeyword.Text) == false) { dt.Rows.RemoveAt(i); i--; } } else if (ddlType.SelectedValue.Equals(SearchType.FuzzMatch)) { if (dt.Rows[i][ddlField.SelectedValue].ToString().Contains(txtKeyword.Text) == false) { dt.Rows.RemoveAt(i); i--; } } else { DateTime selectedDate, inputDate; if (DateTime.TryParse(dt.Rows[i][ddlField.SelectedValue].ToString(), out selectedDate)) { if (DateTime.TryParse(txtKeyword.Text, out inputDate) == false) { UtilHelper.AlertMsg("请输入合法的日期"); } else { if (ddlType.SelectedValue.Equals(SearchType.Bigger)) { if (DateTime.Compare(selectedDate, inputDate) < 0) { dt.Rows.RemoveAt(i--); } } else if (ddlType.SelectedValue.Equals(SearchType.Smaller)) { if (DateTime.Compare(selectedDate, inputDate) > 0) { dt.Rows.RemoveAt(i--); } } } } else { UtilHelper.AlertMsg("大小只能用于比较日期"); } } } GridView1.DataSource = dt; } else { GridView1.DataSource = UtilHelper.ToDataTable(datasource); } Session.Add(SessionMgm.DataSource, GridView1.DataSource); GridView1.PageIndex = 0; GridView1.DataBind(); }