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();
}
