protected void toExcel(object sender, EventArgs e)
{
//List<yh_jinxiaocun_mingxi> list = ri_qi_select(string.Empty, string.Empty, user.gongsi);
HrMingXiModel hm = new HrMingXiModel();
List <gongzi_gongzimingxi> list = hm.gongzitiao_list(Session["gongsi"].ToString());
if (list != null)
{
StringWriter sw = new StringWriter();
sw.WriteLine("姓名\t部门\t岗位\t身份证号\t入职时间\t基本工资\t绩效工资\t岗位工资\t当月合计工资\t跨度工资\t职称津贴\t月出勤天数\t加班时间\t加班费\t全勤应发\t缺勤天数\t缺勤扣款\t迟到天数\t迟到扣款\t应发工资\t社保基数\t医疗基数\t公积金基数\t年金基数\t企业养老\t企业失业\t企业医疗\t企业工伤\t企业生育\t企业公积金\t企业年金\t滞纳金\t利息\t企业小计\t个人养老\t个人失业\t个人医疗\t个人生育\t个人公积金\t个人年金4%\t滞纳金\t利息\t个人小计\t税前工资\t应税工资\t税率\t扣除数\t代扣个人所得税\t年金1%\t实发工资\t验算公式");
foreach (gongzi_gongzimingxi gongzitiao in list)
{
sw.WriteLine(gongzitiao.B + "\t" + gongzitiao.C + "\t" + gongzitiao.D + "\t" + gongzitiao.E + "\t" + gongzitiao.F + "\t" + gongzitiao.G + "\t" + gongzitiao.H + "\t" + gongzitiao.I + "\t" + gongzitiao.J + "\t" + gongzitiao.K + "\t" + gongzitiao.L + "\t" + gongzitiao.M + "\t" + gongzitiao.N + "\t" + gongzitiao.O + "\t" + gongzitiao.P + "\t" + gongzitiao.Q + "\t" + gongzitiao.R + "\t" + gongzitiao.S + "\t" + gongzitiao.T + "\t" + gongzitiao.U + "\t" + gongzitiao.V + "\t" + gongzitiao.W + "\t" + gongzitiao.X + "\t" + gongzitiao.Y + "\t" + gongzitiao.Z + "\t" + gongzitiao.AA + "\t" + gongzitiao.AB + "\t" + gongzitiao.AC + "\t" + gongzitiao.AD + "\t" + gongzitiao.AE + "\t" + gongzitiao.AF + "\t" + gongzitiao.AG + "\t" + gongzitiao.AH + "\t" + gongzitiao.AI + "\t" + gongzitiao.AJ + "\t" + gongzitiao.AK + "\t" + gongzitiao.AL + "\t" + gongzitiao.AM + "\t" + gongzitiao.AN + "\t" + gongzitiao.AO + "\t" + gongzitiao.AP + "\t" + gongzitiao.AQ + "\t" + gongzitiao.AR + "\t" + gongzitiao.ASA + "\t" + gongzitiao.ATA + "\t" + gongzitiao.AU + "\t" + gongzitiao.AV + "\t" + gongzitiao.AW + "\t" + gongzitiao.AX + "\t" + gongzitiao.AY + "\t" + gongzitiao.AZ);
}
sw.Close();
Response.AddHeader("Content-Disposition", "attachment; filename=工资条.xls");
Response.ContentType = "application/ms-excel";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.Write(sw);
Response.End();
}
else
{
Response.Write(" <script>alert('保存失败'); location='ming_xi.aspx';</script>");
}
}
protected void toExcel(object sender, EventArgs e)
{
HrMingXiModel hm = new HrMingXiModel();
List <gongzi_kaoqinmingxi> list = hm.kaoqin_mingxi_list(Session["gongsi"].ToString());
if (list != null)
{
StringWriter sw = new StringWriter();
sw.WriteLine("姓名\t年\t月\t应到\t实到\t请假\t加班\t迟到\t部门");
foreach (gongzi_kaoqinmingxi kaoqin in list)
{
sw.WriteLine(kaoqin.name + "\t" + kaoqin.C + "\t" + kaoqin.D + "\t" + kaoqin.E + "\t" + kaoqin.F + "\t" + kaoqin.G + "\t" + kaoqin.H + "\t" + kaoqin.I + "\t" + kaoqin.J);
}
sw.Close();
Response.AddHeader("Content-Disposition", "attachment; filename=考勤记录.xls");
Response.ContentType = "application/ms-excel";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.Write(sw);
Response.End();
}
else
{
Response.Write(" <script>alert('保存失败'); location='ming_xi.aspx';</script>");
}
}
protected void toExcel(object sender, EventArgs e)
{
HrMingXiModel hm = new HrMingXiModel();
List <gongzi_gongzimingxi> list = hm.gongzi_list(Session["gongsi"].ToString());
if (list != null)
{
StringWriter sw = new StringWriter();
sw.WriteLine("员工姓名\t支付金额\t员工银行账号\t币种");
foreach (gongzi_gongzimingxi bp in list)
{
sw.WriteLine(bp.B + "\t" + bp.AY + "\t" + bp.BA + "\t" + "人民币");
}
sw.Close();
Response.AddHeader("Content-Disposition", "attachment; filename=报盘.xls");
Response.ContentType = "application/ms-excel";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.Write(sw);
Response.End();
}
else
{
Response.Write(" <script>alert('保存失败'); location='ming_xi.aspx';</script>");
}
}
protected void toExcel(object sender, EventArgs e)
{
HrMingXiModel hm = new HrMingXiModel();
List<gongzi_kaoqinjilu> list = hm.kaoqin_list(Session["gongsi"].ToString());
if (list != null)
{
StringWriter sw = new StringWriter();
sw.WriteLine("年\t月\t姓名\t1\t2\t3\t4\t5\t6\t7\t8\t9\t10\t11\t12\t13\t14\t15\t16\t17\t18\t19\t20\t21\t22\t23\t24\t25\t26\t27\t28\t29\t30\t31\t全勤天数\t实际天数\t请假/小时\t加班/小时\t迟到天数");
foreach (gongzi_kaoqinjilu kaoqin in list)
{
sw.WriteLine(kaoqin.year + "\t" + kaoqin.moth + "\t" + kaoqin.name + "\t" + kaoqin.E + "\t" + kaoqin.F + "\t" + kaoqin.G + "\t" + kaoqin.H + "\t" + kaoqin.I + "\t" + kaoqin.J + "\t" + kaoqin.K + "\t" + kaoqin.L + "\t" + kaoqin.M + "\t" + kaoqin.N + "\t" + kaoqin.O + "\t" + kaoqin.P + "\t" + kaoqin.Q + "\t" + kaoqin.R + "\t" + kaoqin.S + "\t" + kaoqin.T + "\t" + kaoqin.U + "\t" + kaoqin.V + "\t" + kaoqin.W + "\t" + kaoqin.X + "\t" + kaoqin.Y + "\t" + kaoqin.Z + "\t" + kaoqin.AA + "\t" + kaoqin.AB + "\t" + kaoqin.AC + "\t" + kaoqin.AD + "\t" + kaoqin.AE + "\t" + kaoqin.AF + "\t" + kaoqin.AG + "\t" + kaoqin.AH + "\t" + kaoqin.AI + "\t" + kaoqin.AJ + "\t" + kaoqin.AK + "\t" + kaoqin.AL + "\t" + kaoqin.AM + "\t" + kaoqin.AN);
}
sw.Close();
Response.AddHeader("Content-Disposition", "attachment; filename=考勤.xls");
Response.ContentType = "application/ms-excel";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.Write(sw);
Response.End();
}
else
{
Response.Write(" <script>alert('保存失败'); location='ming_xi.aspx';</script>");
}
}
protected void toExcel(object sender, EventArgs e)
{
HrMingXiModel hm = new HrMingXiModel();
List <gongzi_gongzimingxi> list = hm.gongzi_list(Session["gongsi"].ToString());
if (list != null)
{
StringWriter sw = new StringWriter();
sw.WriteLine("姓名\t证件类型\t证件号码\t收入金额\t基本养老保险金\t失业保险金\t住房公积金\t年金（个人部分）");
foreach (gongzi_gongzimingxi baoshui in list)
{
sw.WriteLine(baoshui.B + "\t" + "身份证" + "\t" + baoshui.E + "\t" + baoshui.U + "\t" + baoshui.AI + "\t" + baoshui.AK + "\t" + baoshui.AN + "\t" + baoshui.AO);
}
sw.Close();
Response.AddHeader("Content-Disposition", "attachment; filename=报税.xls");
Response.ContentType = "application/ms-excel";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.Write(sw);
Response.End();
}
else
{
Response.Write(" <script>alert('保存失败'); location='ming_xi.aspx';</script>");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
//Session["sss"] = "SELECT * FROM [gongzi_gongzimingxi] WHERE (([BD] = '" + Session["gongsi"].ToString() + "')";
//Session["bm1"] = Request.Form["DropDownList1"].ToString();
//string dd1;
//string dd2;
//string dd3;
//string dd4;
//if (Request.Form["DropDownList1"].ToString() == "")
//{
// dd1 = "";
//}else{
// dd1 = Request.Form["DropDownList1"].ToString();
//}
//if (Request.Form["DropDownList2"].ToString() == "")
//{
// dd2 = "";
//}
//else{
// dd2 = Request.Form["DropDownList2"].ToString();
//}
//if (Request.Form["DropDownList3"].ToString() == "")
//{
// dd3 = "";
//}
//else{
// dd3 = Request.Form["DropDownList3"].ToString();
//}
//if (Request.Form["DropDownList4"].ToString() == "")
//{
// dd4 = "";
//}
//else{
// dd4 = Request.Form["DropDownList4"].ToString();
//}
//Session["sss"] = Session["sss"].ToString() + ")";
//string aa = Session["sss"].ToString();
//Session["bm1"] = Request.Form["DropDownList1"].ToString();
//Session["zw1"] = Request.Form["DropDownList2"].ToString();
//Session["Nian"] = Request.Form["DropDownList3"].ToString();
//Session["Yue"] = Request.Form["DropDownList4"].ToString();
HrMingXiModel hm = new HrMingXiModel();//
List <gongzi_gongzimingxi> list = hm.getTiao(Session["gongsi"].ToString(), Request.Form["DropDownList1"].ToString(), Request.Form["DropDownList2"].ToString(), Request.Form["DropDownList3"].ToString(), Request.Form["DropDownList4"].ToString());
//if (Request.Form["DropDownList4"].ToString()==""){
// GridView1.DataSourceID = "SqlDataSource2";
GridView1.DataSourceID = null;
GridView1.DataSource = list;
//}else{
// GridView1.DataSourceID = "SqlDataSource3";
//}
GridView1.DataBind();
//if (Request.Form["DropDownList1"].ToString() != "" && Request.Form["DropDownList2"].ToString() != "" ) {
// Session["bm1"] = Request.Form["DropDownList1"].ToString();
// Session["zw1"] = Request.Form["DropDownList2"].ToString();
// GridView1.DataSourceID = "SqlDataSource4";
// GridView1.DataBind();
//}
//else if (Request.Form["DropDownList1"].ToString() != "" && Request.Form["DropDownList2"].ToString() == "")
//{
// Session["bm1"] = Request.Form["DropDownList1"].ToString();
// GridView1.DataSourceID = "SqlDataSource2";
// GridView1.DataBind();
//}else if(Request.Form["DropDownList2"].ToString() != "" ){
// Session["zw1"] = Request.Form["DropDownList2"].ToString();
// GridView1.DataSourceID = "SqlDataSource3";
// GridView1.DataBind();
//}
}
