界面详细设计与后台代码
1.入口界面
进入系统首页，网站自动统计未完成项
后台总代码：
using System;
using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI;
using System.Web.UI.HtmlControls; using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; using DataAccess;
public partial class Portal : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) {
if (Session[\
Response.Redirect(\ /*string
strConn
=
ConfigurationManager.ConnectionStrings[\ SqlConnection Conn = new SqlConnection(strConn);
SqlCommand Comm1 = new SqlCommand(\COUNT(ISNULL(pj_cd,1)) FROM tb_emp WHERE pj_cd IS null\
SqlCommand Comm2 = new SqlCommand(\ COUNT(ds.emp_cd) FROM (SELECT emp_cd FROM t_contract_record WHERE flag='1'AND end_date-getdate()<60 AND end_date-getdate()>0) ds\
SqlCommand Comm3 = new SqlCommand(\CONVERT(varchar(16),ti.jk,120) FROM(SELECT MAX(record_time)AS jk FROM t_chk_record WHERE flag='0') ti\ Conn.Open();
int count1 = 0, count2 = 0; DateTime date = DateTime.Now;
Comm1.CommandType = CommandType.Text; Comm2.CommandType = CommandType.Text; Comm3.CommandType = CommandType.Text; count1 = (int)Comm1.ExecuteScalar(); count2 = (int)Comm2.ExecuteScalar(); //date = (DateTime)Comm3.ExecuteScalar();
lblNotEmp.Text = count1.ToString(); lblNotContract.Text = count2.ToString(); lblRecordTime.Text = date.ToString(); Page.DataBind();*/
DataSet dsNotEmp = DataBaseAccess.GetDataSet(\COUNT(ISNULL(pj_cd,1)) con1 FROM tb_emp WHERE pj_cd IS null or pj_cd=''\
DataSet dsNotContract = DataBaseAccess.GetDataSet(\ COUNT(ds.emp_cd) con2
FROM
(SELECT
emp_cd
FROM
t_contract_record =
FROM(SELECT
WHERE
flag='1'AND
end_date-getdate()<60 AND end_date-getdate()>0) ds\ DataSet
dsRecordTime
date
DataBaseAccess.GetDataSet(\MAX(record_time)AS
jk
FROM
CONVERT(varchar(16),ti.jk,120)
lblNotEmp.Text = dsNotEmp.Tables[\
lblNotContract.Text = dsNotContract.Tables[\ lblRecordTime.Text = dsRecordTime.Tables[\ } }
t_chk_record WHERE flag='成功') ti\
2.工程评价
2.1
（1）进入员工管理模块，打开工程评价界面
（2）工程界面-员工评价信息查询
后台总代码：
using System;
using System.Collections; using System.Configuration; using System.Data;
using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI;
using System.Web.UI.HtmlControls; using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using Entity; using Business;
public partial class Employees_engineerEvaluate : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) {
if (Session[\
Response.Redirect(\
if (!new UserPopedeom().GetPopedom(\ {
Response.Write(\language = 'javascript'>alert('抱歉！您没有访问该页的权限！');history.go(-1);\ Response.End(); } else {
UCPagerV2_1.Grd = GVEmps;
UCPagerV2_1.DataSetName = \ } }
protected void btnQuery_Click(object sender, EventArgs e) {
//根据查询条件查询员工信息。 Pjevaluation pje = new Pjevaluation(); pje.Emp_cd = txtEmpCd.Text;
pje.Evaluation_date = selTime.SelectedValue;
pje.Evaluation_class = selEvaluationClass.SelectedValue;
Emp emp = new Emp(); emp.Emp_cd = txtEmpCd.Text; emp.Emp_name = txtEmpName.Text; emp.Dept_cd = selDeptName.SelectedValue; emp.Pj_cd = selPjName.SelectedValue;
//为gridview控件重新绑定时用到Session对象。
Session[\ Session[\ GVEmps.Visible = true;
DataSet ds = new Pjevaluations().GetEvaluation(pje,emp); Session[\
GVEmps.DataSource = ds; GVEmps.DataBind();
//分页控件
UCPagerV2_1.TotalRecords = ds.Tables[0].Rows.Count; Session[\ UCPagerV2_1.UCdatabound(); }
protected void selDeptName_DataBound(object sender, EventArgs e) {
//为下拉框添加第一个没有任何数据的项。 selDeptName.Items.Insert(0, \ selDeptName.SelectedIndex = 0; }
protected void selPjName_DataBound(object sender, EventArgs e) {
//为下拉框添加第一个没有任何数据的项。 selPjName.Items.Insert(0, \ selPjName.SelectedIndex = 0; }
protected void selTime_DataBound(object sender, EventArgs e) {
//为下拉框添加第一个没有任何数据的项。 selTime.Items.Insert(0, \ selTime.SelectedIndex = 0; }
protected void selEvaluationClass_DataBound(object sender, EventArgs e) {
//为下拉框添加第一个没有任何数据的项。 selEvaluationClass.Items.Insert(0, \ selEvaluationClass.SelectedIndex = 0; }
protected void lnkAddNew_Click(object sender, EventArgs e) {
//int index = Convert.ToInt32(e.CommandArgument); //
Session[\
GVEmps.DataKeys[((GridViewRow)((LinkButton)sender).NamingContainer).RowIndex].Value; //OnClientClick=\
=