1//文件名:QueryDepartmentForm.aspx.cs
 2using System;
 3using System.Data;
 4using System.Configuration;
 5using System.Collections;
 6using System.Web;
 7using System.Web.Security;
 8using System.Web.UI;
 9using System.Web.UI.WebControls;
10using System.Web.UI.WebControls.WebParts;
11using System.Web.UI.HtmlControls;
12
13public partial class QueryManage_QueryDepartmentForm : System.Web.UI.Page
14...{
15    protected void Page_Load(object sender, EventArgs e)
16    ...{
17        string MyForbidString = Session["MyForbid"].ToString();
18        if (MyForbidString.IndexOf("D2") > 1)
19        ...{
20            Server.Transfer("~/SystemManage/AllErrorHelp.aspx");
21        }
22    }
23    protected void Button2_Click(object sender, EventArgs e)
24    ...{//打印部门员工基本人事档案信息
25        Server.Transfer("~/QueryManage/QueryDepartmentPrint.aspx");
26    }
27    public string MyPrintSQL
28    ...{//设置要传递到打印页的数据
29        get
30        ...{
31            return "SELECT [员工编号], [姓名], [性别], [出生日期], [身份证号码], [民族], [籍贯], [政治面貌], [婚姻状况], [文化程度], [职务], [毕业院校], [职称], [进入公司时间], [合同服务年限], [基本工资], [银行账号], [养老保险账号], [医疗保险账号], [住房基金账号], [联系电话], [手机号码], [电子信箱], [家庭住址], [邮政编码], [补充说明] FROM [在职员工视图] WHERE ([所属部门] ='"+this.DropDownList1.SelectedValue.ToString()+"')";
32        }
33    }
34    public String MyPrintDate
35    ...{//设置要传递到打印页的数据
36        get
37        ...{
38            return "打印日期：" + DateTime.Now.ToShortDateString();
39        }
40    }
41    public String MyPrintTitle
42    ...{//设置要传递到打印页的数据
43        get
44        ...{
45            return Session["MyCompanyName"].ToString() + this.DropDownList1.SelectedValue.ToString() + "员工基本人事档案表";
46        }
47    }
48}
49