1//文件名:QuerySalaryForm.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_QuerySalaryForm : System.Web.UI.Page
14...{
15    private static string MySQL="";
16    private static string MyTitle = "";
17    protected void Page_Load(object sender, EventArgs e)
18    ...{
19        string MyForbidString = Session["MyForbid"].ToString();
20        if (MyForbidString.IndexOf("D4") > 1)
21        ...{
22            Server.Transfer("~/SystemManage/AllErrorHelp.aspx");
23        }
24    }
25    protected void Button3_Click(object sender, EventArgs e)
26    ...{//打印银行入账单
27        MyTitle = Session["MyCompanyName"].ToString() + "月度工资银行入账单";
28        MySQL = "SELECT [员工姓名], [银行账号],[实发金额] FROM [工资发放表] WHERE (([发放年份] ='" + this.DropDownList1.SelectedValue.ToString() + "') AND ([发放月份] = '" + this.DropDownList2.SelectedValue.ToString() + "'))";
29        Server.Transfer("~/QueryManage/QuerySalaryPrint.aspx");
30    }
31    protected void Button4_Click(object sender, EventArgs e)
32    ...{//打印养老险入账单
33        MyTitle = Session["MyCompanyName"].ToString() + "月度养老保险入账单";
34        MySQL = "SELECT [员工姓名], [养老保险账号],[养老险] FROM [工资发放表] WHERE (([发放年份] ='" + this.DropDownList1.SelectedValue.ToString() + "') AND ([发放月份] = '" + this.DropDownList2.SelectedValue.ToString() + "'))";
35        Server.Transfer("~/QueryManage/QuerySalaryPrint.aspx");
36    }
37    protected void Button5_Click(object sender, EventArgs e)
38    ...{//打印医疗险入账单
39        MyTitle = Session["MyCompanyName"].ToString() + "月度医疗保险入账单";
40        MySQL = "SELECT [员工姓名], [医疗保险账号],[医疗险] FROM [工资发放表] WHERE (([发放年份] ='" + this.DropDownList1.SelectedValue.ToString() + "') AND ([发放月份] = '" + this.DropDownList2.SelectedValue.ToString() + "'))";
41        Server.Transfer("~/QueryManage/QuerySalaryPrint.aspx");
42    }
43    protected void Button6_Click(object sender, EventArgs e)
44    ...{//打印住房基金入账单
45        MyTitle = Session["MyCompanyName"].ToString() + "月度住房基金入账单";
46        MySQL = "SELECT [员工姓名], [住房基金账号],[住房基金] FROM [工资发放表] WHERE (([发放年份] ='" + this.DropDownList1.SelectedValue.ToString() + "') AND ([发放月份] = '" + this.DropDownList2.SelectedValue.ToString() + "'))";
47        Server.Transfer("~/QueryManage/QuerySalaryPrint.aspx");
48    }
49    protected void Button2_Click(object sender, EventArgs e)
50    ...{//打印公司月度工资信息
51        MyTitle=Session["MyCompanyName"].ToString() + "月度工资发放信息表";
52        MySQL = "SELECT [员工编号], [员工姓名], [基本工资], [津贴], [奖金], [工龄工资], [岗位工资], [其他应增项], [应发合计], [所得税], [养老险], [医疗险], [住房基金], [其他应减项], [应减合计], [实发金额], [银行账号], [养老保险账号], [医疗保险账号], [住房基金账号], [身份证号码], [发放年份], [发放月份] FROM [工资发放表] WHERE (([发放年份] ='" + this.DropDownList1.SelectedValue.ToString() + "') AND ([发放月份] = '" + this.DropDownList2.SelectedValue.ToString() + "'))";
53        Server.Transfer("~/QueryManage/QuerySalaryPrint.aspx");
54    }
55    public string MyPrintSQL
56    ...{//设置要传递到打印页的数据
57        get
58        ...{
59            return MySQL;
60        }
61    }
62    public String MyPrintDate
63    ...{//设置要传递到打印页的数据
64        get
65        ...{
66            return "发放日期：" + this.DropDownList1.SelectedValue.ToString() + "年" + this.DropDownList2.SelectedValue.ToString() + "月";
67        }
68    }
69    public String MyPrintTitle
70    ...{//设置要传递到打印页的数据
71        get
72        ...{
73            return MyTitle;
74        }
75    }
76
77  
78}
79