protected void btnImport_Click(object sender, System.Web.UI.ImageClickEventArgs e) { //获取数据 SalaryStandardModel searchModel = new SalaryStandardModel(); //设置查询条件 //岗位 searchModel.QuarterID = Request.Form["ddlSearchQuarter"].ToString(); //岗位职等 //string I= Request.Form.AllKeys.ToString(); searchModel.AdminLevel = Request.Form["ctSearchQuaterAdmin$ddlCodeType"].ToString(); //启用状态 searchModel.UsedStatus = Request.Form["ddlSearchUsedStatus"].ToString(); //查询数据 DataTable dtNotify = SalaryStandardBus.SearchSalaryStandardInfo(searchModel); //导出标题 string headerTitle = "岗位|岗位职等|工资项名称|金额|启用状态"; string[] header = headerTitle.Split('|'); //导出标题所对应的列字段名称 string columnFiled = "QuarterName|AdminLevelName|ItemName|UnitPrice|UsedStatusName"; string[] field = columnFiled.Split('|'); XBase.Common.OutputToExecl.ExportToTable(this.Page, dtNotify, header, field, "岗位工资设置"); }
private void Search() { SalaryStandardModel searchModel = new SalaryStandardModel(); //设置查询条件 //岗位 if (ddlDeptName.SelectedValue != "0")//部门 { searchModel.QuarterID = ddlDeptName.SelectedValue; } if (this.ddlStartMonth.SelectedValue != "0") //起始月份 { searchModel.AdminLevel = ddlStartMonth.SelectedValue; } if (this.ddlEndMonth.SelectedValue != "0") //结束月份 { searchModel.AdminLevelName = ddlEndMonth.SelectedValue; } if (this.ddlYear.SelectedValue != "0") //结束月份 { searchModel.UnitPrice = ddlYear.SelectedValue; } UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //查询数据 DataTable dtNewTable = SalaryStandardBus.SearchSalarySummaryReport(searchModel); DataTable dtData = new DataTable(); dtData.Columns.Add("Remark"); dtData.Columns.Add("itemNo"); dtData.Columns.Add("CompanyCD"); dtData.Columns.Add("UnitPrice"); for (int i = 0; i < dtNewTable.Rows.Count; i++) { DataRow newRow = dtData.NewRow(); newRow["Remark"] = getDeptName(dtNewTable.Rows[i]["Remark"] == null ? "" : dtNewTable.Rows[i]["Remark"].ToString()); newRow["itemNo"] = dtNewTable.Rows[i]["itemNo"] == null ? "" : dtNewTable.Rows[i]["itemNo"].ToString(); newRow["CompanyCD"] = dtNewTable.Rows[i]["CompanyCD"] == null ? "" : dtNewTable.Rows[i]["CompanyCD"].ToString(); newRow["UnitPrice"] = dtNewTable.Rows[i]["UnitPrice"] == null ? "" : dtNewTable.Rows[i]["UnitPrice"].ToString(); dtData.Rows.Add(newRow); } ReportDocument oRpt = new ReportDocument(); CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/OperatingModel/CrystalReport/HumanManager/SalarySummeryReport.rpt")); // SetDatabaseLogon 拉模式中必须用这个方法来设置登录信息,参数一:用户名;参数二:密码;参数三:服务器;参数四:数据库名 CrystalReportViewer1.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.SalaryReportSummary")); //查询数据 CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["Creator"].Text = "\"" + "制表人:" + userInfo.EmployeeName + "\""; CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["DeptName"].Text = "\"" + "起始年月:" + ddlYear.SelectedValue + "." + ddlStartMonth.SelectedValue + "\""; CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["PerformanceType"].Text = "\"" + "结束年月:" + ddlYear.SelectedValue + "." + ddlEndMonth.SelectedValue + "\""; CrystalReportSource1.ReportDocument.SetDataSource(dtData); CrystalReportSource1.DataBind(); // CrystalReportViewer1是水晶报表浏览器,下面是给该浏览器赋上对像 CrystalReportViewer1.ReportSource = CrystalReportSource1; //CrystalReportViewer1.DataBind(); }
private void Search() { SalaryStandardModel searchModel = new SalaryStandardModel(); //设置查询条件 //岗位 if (ddlSearchQuarter.SelectedValue != "0") { searchModel.QuarterID = ddlSearchQuarter.SelectedValue; } //岗位职等 if (ddlSearchQuaterAdmin.SelectedValue != "0") { searchModel.AdminLevel = ddlSearchQuaterAdmin.SelectedValue; } //启用状态· searchModel.UsedStatus = "1"; UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //查询数据 DataTable dtData = SalaryStandardBus.SearchSalaryStandardReport(searchModel); ReportDocument oRpt = new ReportDocument(); CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/OperatingModel/CrystalReport/HumanManager/SalaryStandardReport.rpt")); // SetDatabaseLogon 拉模式中必须用这个方法来设置登录信息,参数一:用户名;参数二:密码;参数三:服务器;参数四:数据库名 CrystalReportViewer1.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.SalaryStandard")); //查询数据 CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["DeptName"].Text = "\"" + "" + "\""; CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["PerformanceType"].Text = "\"" + "" + "\""; CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["Creator"].Text = "\"" + "制表人:" + userInfo.EmployeeName + "\""; if (ddlSearchQuarter.SelectedValue != "0" && ddlSearchQuarter.SelectedIndex != -1) { CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["DeptName"].Text = "\"" + "岗位:" + ddlSearchQuarter.Items[ddlSearchQuarter.SelectedIndex].Text + "\""; } else { CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["DeptName"].Text = "\"" + "岗位:" + "全部" + "\""; } if (this.ddlSearchQuaterAdmin.SelectedValue != "0" && ddlSearchQuaterAdmin.SelectedIndex != -1) { CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["PerformanceType"].Text = "\"" + "职等:" + ddlSearchQuaterAdmin.Items[ddlSearchQuaterAdmin.SelectedIndex].Text + "\""; } else { CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["PerformanceType"].Text = "\"" + "职等:" + "全部" + "\""; } CrystalReportSource1.ReportDocument.SetDataSource(dtData); CrystalReportSource1.DataBind(); // CrystalReportViewer1是水晶报表浏览器,下面是给该浏览器赋上对像 CrystalReportViewer1.ReportSource = CrystalReportSource1; // CrystalReportViewer1.DataBind(); }
private void Search() { SalaryStandardModel searchModel = new SalaryStandardModel(); //设置查询条件 //岗位 if (ddlDeptName.SelectedValue != "0") { searchModel.QuarterID = ddlDeptName.SelectedValue; } if (this.ddlStartMonth.SelectedValue != "0")//起始月份 { searchModel.AdminLevel = ddlStartMonth.SelectedValue; } if (this.ddlEndMonth.SelectedValue != "0")//结束月份 { searchModel.AdminLevelName = ddlEndMonth.SelectedValue; } if (this.ddlYear.SelectedValue != "0")//结束月份 { searchModel.UnitPrice = ddlYear.SelectedValue; } searchModel.UsedStatus = txtSearchEmployee.Value; UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //查询数据 DataTable dtNewTable = SalaryStandardBus.SearchSalaryDetailsReport(searchModel); DataTable dtData = new DataTable(); dtData.Columns.Add("WorkMoney"); //部门 dtData.Columns.Add("CompanyCD"); //月份 dtData.Columns.Add("EmployeeID"); //人员编号 dtData.Columns.Add("ReprotNo"); //人员姓名 dtData.Columns.Add("FixedMoney"); //岗位 dtData.Columns.Add("TimeMoney"); //职等 dtData.Columns.Add("AllGetMoney"); //应发工资 dtData.Columns.Add("AllKillMoney"); //应扣工资 dtData.Columns.Add("SalaryMoney"); //实发工资 for (int i = 0; i < dtNewTable.Rows.Count; i++) { DataTable dt = SalaryStandardBus.GetEmployeeDetailsOutTime(dtNewTable.Rows[i]["EmployeeID"] == null ? "" : dtNewTable.Rows[i]["EmployeeID"].ToString(), dtNewTable.Rows[i]["DeptID"] == null ? "" : dtNewTable.Rows[i]["DeptID"].ToString(), dtNewTable.Rows[i]["ReprotNo"] == null ? "" : dtNewTable.Rows[i]["ReprotNo"].ToString()); DataRow newRow = dtData.NewRow(); newRow["WorkMoney"] = dt.Rows[0]["DeptName"] == null ? "" : dt.Rows[0]["DeptName"].ToString(); newRow["CompanyCD"] = dtNewTable.Rows[i]["ReportMonth"] == null ? "" : dtNewTable.Rows[i]["ReportMonth"].ToString(); newRow["EmployeeID"] = dt.Rows[0]["EmployeeName"] == null ? "" : dt.Rows[0]["EmployeeName"].ToString(); newRow["FixedMoney"] = dt.Rows[0]["TimeMoney"] == null ? "" : dt.Rows[0]["TimeMoney"].ToString(); dtData.Rows.Add(newRow); } ReportDocument oRpt = new ReportDocument(); CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/OperatingModel/CrystalReport/HumanManager/SalaryWorkByTime.rpt")); // SetDatabaseLogon 拉模式中必须用这个方法来设置登录信息,参数一:用户名;参数二:密码;参数三:服务器;参数四:数据库名 CrystalReportViewer1.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.SalaryReportSummary")); //查询数据 CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["Creator"].Text = "\"" + "制表人:" + userInfo.EmployeeName + "\""; CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["DeptName"].Text = "\"" + "起始年月:" + ddlYear.SelectedValue + "." + ddlStartMonth.SelectedValue + "\""; CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["PerformanceType"].Text = "\"" + "结束年月:" + ddlYear.SelectedValue + "." + ddlEndMonth.SelectedValue + "\""; CrystalReportSource1.ReportDocument.SetDataSource(dtData); CrystalReportSource1.DataBind(); // CrystalReportViewer1是水晶报表浏览器,下面是给该浏览器赋上对像 CrystalReportViewer1.ReportSource = CrystalReportSource1; // CrystalReportViewer1.DataBind(); }
protected void btnOutWord_Click(object sender, System.Web.UI.ImageClickEventArgs e) { string deptIDGet = Request.QueryString["DeptID"] == null ? "" : Request.QueryString["DeptID"].ToString(); string year = Request.QueryString["year"] == null ? "" : Request.QueryString["year"].ToString(); string titleNamee = year + "年度工资统计表"; HttpResponse resp; resp = Page.Response; resp.ContentEncoding = System.Text.Encoding.Default; UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; DataTable dtData = new DataTable(); dtData.Columns.Add("deptName"); //部门 dtData.Columns.Add("MonthCount1"); //人数 dtData.Columns.Add("MonthMoney1"); //金额 dtData.Columns.Add("MonthCount2"); //人数 dtData.Columns.Add("MonthMoney2"); //金额 dtData.Columns.Add("MonthCount3"); //人数 dtData.Columns.Add("MonthMoney3"); //金额 dtData.Columns.Add("MonthCount4"); //人数 dtData.Columns.Add("MonthMoney4"); //金额 dtData.Columns.Add("MonthCount5"); //人数 dtData.Columns.Add("MonthMoney5"); //金额 dtData.Columns.Add("MonthCount6"); //人数 dtData.Columns.Add("MonthMoney6"); //金额 dtData.Columns.Add("MonthCount7"); //人数 dtData.Columns.Add("MonthMoney7"); //金额 dtData.Columns.Add("MonthCount8"); //人数 dtData.Columns.Add("MonthMoney8"); //金额 dtData.Columns.Add("MonthCount9"); //人数 dtData.Columns.Add("MonthMoney9"); //金额 dtData.Columns.Add("MonthCount10"); //人数 dtData.Columns.Add("MonthMoney10"); //金额 dtData.Columns.Add("MonthCount11"); //人数 dtData.Columns.Add("MonthMoney11"); //金额 dtData.Columns.Add("MonthCount12"); //人数 dtData.Columns.Add("MonthMoney12"); //金额 dtData.Columns.Add("summary"); //月平均金额 if (!string.IsNullOrEmpty(deptIDGet)) { decimal sum = 0; DataRow newRow = dtData.NewRow(); string DeptName = SalaryStandardBus.GetNameByDeptID(deptIDGet); if (string.IsNullOrEmpty(DeptName)) { DeptName = " "; } newRow["deptName"] = DeptName; for (int month = 1; month < 13; month++) { string monthTemp; if (month < 10) { monthTemp = "0" + month.ToString(); } else { monthTemp = month.ToString(); } DataTable dtNew = SalaryStandardBus.GetMonthlyInfo(year, deptIDGet, monthTemp); if (dtNew.Rows.Count > 0) { newRow["MonthCount" + month.ToString()] = dtNew.Rows[0]["CompanyCD"] == null ? "" : dtNew.Rows[0]["CompanyCD"].ToString(); string UnitPrice = dtNew.Rows[0]["UnitPrice"] == null ? "" : dtNew.Rows[0]["UnitPrice"].ToString(); newRow["MonthMoney" + month.ToString()] = UnitPrice; sum = sum + Convert.ToDecimal(UnitPrice); } else { newRow["MonthCount" + month.ToString()] = " "; newRow["MonthMoney" + month.ToString()] = " "; sum = sum + 0; } } decimal dd = Math.Round(sum / 12, 4); newRow["summary"] = Convert.ToString(dd); dtData.Rows.Add(newRow); } else { DataTable dt = SalaryStandardBus.GetDeptInfo(); for (int a = 0; a < dt.Rows.Count; a++) { decimal sum = 0; DataRow newRow = dtData.NewRow(); string deptID = dt.Rows[a]["DeptID"] == null ? "" : dt.Rows[a]["DeptID"].ToString(); string DeptName = SalaryStandardBus.GetNameByDeptID(deptID); if (string.IsNullOrEmpty(DeptName)) { DeptName = " "; } newRow["deptName"] = DeptName; for (int month = 1; month < 13; month++) { string monthTemp; if (month < 10) { monthTemp = "0" + month.ToString(); } else { monthTemp = month.ToString(); } DataTable dtNew = SalaryStandardBus.GetMonthlyInfo(year, deptID, monthTemp); if (dtNew.Rows.Count > 0) { newRow["MonthCount" + month.ToString()] = dtNew.Rows[0]["CompanyCD"] == null ? "" : dtNew.Rows[0]["CompanyCD"].ToString(); string UnitPrice = dtNew.Rows[0]["UnitPrice"] == null ? "" : dtNew.Rows[0]["UnitPrice"].ToString(); newRow["MonthMoney" + month.ToString()] = UnitPrice; sum = sum + Convert.ToDecimal(UnitPrice); } else { newRow["MonthCount" + month.ToString()] = " "; newRow["MonthMoney" + month.ToString()] = " "; sum = sum + 0; } } decimal dd = Math.Round(sum / 12, 4); newRow["summary"] = Convert.ToString(dd); dtData.Rows.Add(newRow); } } string OutFile = titleNamee + ".xls"; resp.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(System.Text.Encoding.UTF8.GetBytes(OutFile))); string ls_item = ""; ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += titleNamee + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(13); resp.Write(ls_item); ls_item = ""; ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(13); resp.Write(ls_item); ls_item = ""; ls_item += " " + Convert.ToChar(9); ls_item += "一" + Convert.ToChar(9); ls_item += "月" + Convert.ToChar(9); ls_item += "二" + Convert.ToChar(9); ls_item += "月" + Convert.ToChar(9); ls_item += "三" + Convert.ToChar(9); ls_item += "月" + Convert.ToChar(9); ls_item += "四" + Convert.ToChar(9); ls_item += "月" + Convert.ToChar(9); ls_item += "五" + Convert.ToChar(9); ls_item += "月" + Convert.ToChar(9); ls_item += "六" + Convert.ToChar(9); ls_item += "月" + Convert.ToChar(9); ls_item += "七" + Convert.ToChar(9); ls_item += "月" + Convert.ToChar(9); ls_item += "八" + Convert.ToChar(9); ls_item += "月" + Convert.ToChar(9); ls_item += "九" + Convert.ToChar(9); ls_item += "月" + Convert.ToChar(9); ls_item += "十" + Convert.ToChar(9); ls_item += "月" + Convert.ToChar(9); ls_item += "十一" + Convert.ToChar(9); ls_item += "月" + Convert.ToChar(9); ls_item += "十二" + Convert.ToChar(9); ls_item += "月" + Convert.ToChar(9); ls_item += " " + Convert.ToChar(13); resp.Write(ls_item); ls_item = ""; int i = 0; ls_item += "部门 " + Convert.ToChar(9); ls_item += "人数" + Convert.ToChar(9); ls_item += "金额" + Convert.ToChar(9); ls_item += "人数" + Convert.ToChar(9); ls_item += "金额" + Convert.ToChar(9); ls_item += "人数" + Convert.ToChar(9); ls_item += "金额" + Convert.ToChar(9); ls_item += "人数" + Convert.ToChar(9); ls_item += "金额" + Convert.ToChar(9); ls_item += "人数" + Convert.ToChar(9); ls_item += "金额" + Convert.ToChar(9); ls_item += "人数" + Convert.ToChar(9); ls_item += "金额" + Convert.ToChar(9); ls_item += "人数" + Convert.ToChar(9); ls_item += "金额" + Convert.ToChar(9); ls_item += "人数" + Convert.ToChar(9); ls_item += "金额" + Convert.ToChar(9); ls_item += "人数" + Convert.ToChar(9); ls_item += "金额" + Convert.ToChar(9); ls_item += "人数" + Convert.ToChar(9); ls_item += "金额" + Convert.ToChar(9); ls_item += "人数" + Convert.ToChar(9); ls_item += "金额" + Convert.ToChar(9); ls_item += "人数" + Convert.ToChar(9); ls_item += "金额" + Convert.ToChar(9); ls_item += "月平均金额" + Convert.ToChar(9); ls_item += " " + Convert.ToChar(13); resp.Write(ls_item); ls_item = ""; for (i = 0; i < dtData.Rows.Count; i++) { ls_item += dtData.Rows[i]["deptName"].ToString() + Convert.ToChar(9); ls_item += dtData.Rows[i]["MonthCount1"].ToString() + Convert.ToChar(9); ls_item += dtData.Rows[i]["MonthMoney1"].ToString() + Convert.ToChar(9); ls_item += dtData.Rows[i]["MonthCount2"].ToString() + Convert.ToChar(9); ls_item += dtData.Rows[i]["MonthMoney2"].ToString() + Convert.ToChar(9); ls_item += dtData.Rows[i]["MonthCount3"].ToString() + Convert.ToChar(9); ls_item += dtData.Rows[i]["MonthMoney3"].ToString() + Convert.ToChar(9); ls_item += dtData.Rows[i]["MonthCount4"].ToString() + Convert.ToChar(9); ls_item += dtData.Rows[i]["MonthMoney4"].ToString() + Convert.ToChar(9); ls_item += dtData.Rows[i]["MonthCount5"].ToString() + Convert.ToChar(9); ls_item += dtData.Rows[i]["MonthMoney5"].ToString() + Convert.ToChar(9); ls_item += dtData.Rows[i]["MonthCount6"].ToString() + Convert.ToChar(9); ls_item += dtData.Rows[i]["MonthMoney6"].ToString() + Convert.ToChar(9); ls_item += dtData.Rows[i]["MonthCount7"].ToString() + Convert.ToChar(9); ls_item += dtData.Rows[i]["MonthMoney7"].ToString() + Convert.ToChar(9); ls_item += dtData.Rows[i]["MonthCount8"].ToString() + Convert.ToChar(9); ls_item += dtData.Rows[i]["MonthMoney8"].ToString() + Convert.ToChar(9); ls_item += dtData.Rows[i]["MonthCount9"].ToString() + Convert.ToChar(9); ls_item += dtData.Rows[i]["MonthMoney9"].ToString() + Convert.ToChar(9); ls_item += dtData.Rows[i]["MonthCount10"].ToString() + Convert.ToChar(9); ls_item += dtData.Rows[i]["MonthMoney10"].ToString() + Convert.ToChar(9); ls_item += dtData.Rows[i]["MonthCount11"].ToString() + Convert.ToChar(9); ls_item += dtData.Rows[i]["MonthMoney11"].ToString() + Convert.ToChar(9); ls_item += dtData.Rows[i]["MonthCount12"].ToString() + Convert.ToChar(9); ls_item += dtData.Rows[i]["MonthMoney12"].ToString() + Convert.ToChar(9); ls_item += dtData.Rows[i]["summary"].ToString() + Convert.ToChar(13); resp.Write(ls_item); ls_item = ""; } ls_item = ""; ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(13); resp.Write(ls_item); ls_item = ""; ls_item += "制表:" + Convert.ToChar(9); ls_item += ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeName + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "打印日期:" + Convert.ToChar(9); ls_item += DateTime.Now.ToString("yyyy-MM-dd") + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(9); ls_item += "" + Convert.ToChar(13); resp.Write(ls_item); resp.End(); }
public string getSalaryInfoByDept(string deptIDGet, string yearID) { string year = yearID; DataTable dt = SalaryStandardBus.GetDeptInfo(); StringBuilder sb = new StringBuilder(); sb.Append("\r\t <table width=\"95%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" valign=\"top\" align=\"center\"><tr align=\"center\"><td width=\"95%\" align=\"center\" valign=\"top\">"); sb.Append("\r\t <table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">"); sb.Append("\r\t <thead style=\"display:table-header-group;font-weight:bold\">"); sb.Append("\r\t <tr><td colspan=\"26\"> <table width=\"98%\" height=\"40\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" align=\"center\"> <tr><td align=\"center\" class=\"pS\" valign=\"middle\"><strong> " + year + "年度工资分析表 </strong></td></tr></table></td></tr>"); sb.Append(" \r\t <tr ><td align=\"center\" class=\"td1\" style=\"height: 25px\">部门</td><td colspan='2' align=\"center\" class=\"td1\" style=\"height: 25px\">1月</td><td colspan='2' align=\"center\" class=\"td1\" style=\"height: 25px\">2月</td><td colspan='2' align=\"center\" class=\"td1\" style=\"height: 25px\">3月</td><td colspan='2' align=\"center\" class=\"td1\" style=\"height: 25px\">4月</td><td colspan='2' align=\"center\" class=\"td1\" style=\"height: 25px\">5月</td><td colspan='2' align=\"center\" class=\"td1\" style=\"height: 25px\">6月</td><td colspan='2' align=\"center\" class=\"td1\" style=\"height: 25px\">7月</td><td colspan='2' align=\"center\" class=\"td1\" style=\"height: 25px\">8月</td><td colspan='2' align=\"center\" class=\"td1\" style=\"height: 25px\">9月</td><td colspan='2' align=\"center\" class=\"td1\" style=\"height: 25px\">10月</td><td colspan='2' align=\"center\" class=\"td1\" style=\"height: 25px\">11月</td><td colspan='2' align=\"center\" class=\"td1\" style=\"height: 25px\">12月</td><td align=\"center\" class=\"td4\" style=\"height: 25px\">" + " " + "</td></tr>"); sb.Append("\r\t <tr><td align=\"center\" class=\"td1\" style=\"height: 25px\">" + " " + "</td><td align=\"center\" class=\"td1\" style=\"height: 25px\">人数</td><td align=\"center\" class=\"td1\" style=\"height: 25px\">金额</td><td align=\"center\" class=\"td1\" style=\"height: 25px\">人数</td><td align=\"center\" class=\"td1\" style=\"height: 25px\">金额</td><td align=\"center\" class=\"td1\" style=\"height: 25px\">人数</td><td align=\"center\" class=\"td1\" style=\"height: 25px\">金额</td><td align=\"center\" class=\"td1\" style=\"height: 25px\">人数</td><td align=\"center\" class=\"td1\" style=\"height: 25px\">金额</td><td align=\"center\" class=\"td1\" style=\"height: 25px\">人数</td><td align=\"center\" class=\"td1\" style=\"height: 25px\">金额</td><td align=\"center\" class=\"td1\" style=\"height: 25px\">人数</td><td align=\"center\" class=\"td1\" style=\"height: 25px\">金额</td><td align=\"center\" class=\"td1\" style=\"height: 25px\">人数</td><td align=\"center\" class=\"td1\" style=\"height: 25px\">金额</td><td align=\"center\" class=\"td1\" style=\"height: 25px\">人数</td><td align=\"center\" class=\"td1\" style=\"height: 25px\">金额</td><td align=\"center\" class=\"td1\" style=\"height: 25px\">人数</td><td align=\"center\" class=\"td1\" style=\"height: 25px\">金额</td><td align=\"center\" class=\"td1\" style=\"height: 25px\">人数</td><td align=\"center\" class=\"td1\" style=\"height: 25px\">金额</td><td align=\"center\" class=\"td1\" style=\"height: 25px\">人数</td><td align=\"center\" class=\"td1\" style=\"height: 25px\">金额</td><td align=\"center\" class=\"td1\" style=\"height: 25px\">人数</td><td align=\"center\" class=\"td1\" style=\"height: 25px\">金额</td><td align=\"center\" class=\"td4\" style=\"height: 25px\">月平均金额</td></tr>"); sb.Append("\r\t </thead>"); sb.Append(" <tbody bgcolor=\"white\" id=\"show\""); if (!string.IsNullOrEmpty(deptIDGet)) { decimal sum = 0; string DeptName = SalaryStandardBus.GetNameByDeptID(deptIDGet); if (string.IsNullOrEmpty(DeptName)) { DeptName = " "; } sb.Append("\r\t <tr><td align=\"center\" class=td1 style=\"height: 25px\">" + DeptName + "</td>"); for (int month = 1; month < 13; month++) { string monthTemp; if (month < 10) { monthTemp = "0" + month.ToString(); } else { monthTemp = month.ToString(); } DataTable dtNew = SalaryStandardBus.GetMonthlyInfo(year, deptIDGet, monthTemp); if (dtNew.Rows.Count > 0) { string count = dtNew.Rows[0]["CompanyCD"] == null ? "" : dtNew.Rows[0]["CompanyCD"].ToString(); string UnitPrice = dtNew.Rows[0]["UnitPrice"] == null ? "" : dtNew.Rows[0]["UnitPrice"].ToString(); sb.Append("\r\t <td align=\"center\" class=td1 style=\"height: 25px\">" + count + "</td>" + "<td align=\"center\" class=td1 style=\"height: 25px\">" + UnitPrice + "</td>"); sum = sum + Convert.ToDecimal(UnitPrice); } else { sb.Append("\r\t <td align=\"center\" class=td1 style=\"height: 25px\">" + " " + "</td>" + "<td align=\"center\" class=td1 style=\"height: 25px\">" + " " + "</td>"); } } decimal dd = Math.Round(sum / 12, 4); sb.Append("\r\t <td align=\"center\" class=td4 style=\"height: 25px\">" + Convert.ToString(dd) + "</td>"); sb.Append("\r\t </tr>"); } else { for (int a = 0; a < dt.Rows.Count; a++) { decimal sum = 0; string deptID = dt.Rows[a]["DeptID"] == null ? "" : dt.Rows[a]["DeptID"].ToString(); string DeptName = SalaryStandardBus.GetNameByDeptID(deptID); if (string.IsNullOrEmpty(DeptName)) { DeptName = " "; } sb.Append("\r\t <tr><td align=\"center\" class=td1 style=\"height: 25px\">" + DeptName + "</td>"); for (int month = 1; month < 13; month++) { string monthTemp; if (month < 10) { monthTemp = "0" + month.ToString(); } else { monthTemp = month.ToString(); } DataTable dtNew = SalaryStandardBus.GetMonthlyInfo(year, deptID, monthTemp); if (dtNew.Rows.Count > 0) { string count = dtNew.Rows[0]["CompanyCD"] == null ? "" : dtNew.Rows[0]["CompanyCD"].ToString(); string UnitPrice = dtNew.Rows[0]["UnitPrice"] == null ? "" : dtNew.Rows[0]["UnitPrice"].ToString(); sb.Append("\r\t <td align=\"center\" class=td1 style=\"height: 25px\">" + count + "</td>" + "<td align=\"center\" class=td1 style=\"height: 25px\">" + UnitPrice + "</td>"); sum = sum + Convert.ToDecimal(UnitPrice); } else { sb.Append("\r\t <td align=\"center\" class=td1 style=\"height: 25px\">" + " " + "</td>" + "<td align=\"center\" class=td1 style=\"height: 25px\">" + " " + "</td>"); } } decimal dd = Math.Round(sum / 12, 4); sb.Append("\r\t <td align=\"center\" class=td4 style=\"height: 25px\">" + Convert.ToString(dd) + "</td>"); sb.Append("\r\t </tr>"); } } sb.Append("\r\t <tr><td align=\"center\" class=\"td3\" style=\"height: 25px\">" + " " + "</td><td align=\"center\" class=\"td3\" style=\"height: 25px\">" + " " + "</td><td align=\"center\" class=\"td3\" style=\"height: 25px\">" + " " + "</td><td align=\"center\" class=\"td3\" style=\"height: 25px\">" + " " + "</td><td align=\"center\" class=\"td3\" style=\"height: 25px\">" + " " + "</td><td align=\"center\" class=\"td3\" style=\"height: 25px\">" + " " + "</td><td align=\"center\" class=\"td3\" style=\"height: 25px\">" + " " + "</td><td align=\"center\" class=\"td3\" style=\"height: 25px\">" + " " + "</td><td align=\"center\" class=\"td3\" style=\"height: 25px\">" + " " + "</td><td align=\"center\" class=\"td3\" style=\"height: 25px\">" + " " + "</td><td align=\"center\" class=\"td3\" style=\"height: 25px\">" + " " + "</td><td align=\"center\" class=\"td3\" style=\"height: 25px\">" + " " + "</td><td align=\"center\" class=\"td3\" style=\"height: 25px\">" + " " + "</td><td align=\"center\" class=\"td3\" style=\"height: 25px\">" + " " + "</td><td align=\"center\" class=\"td3\" style=\"height: 25px\">" + " " + "</td><td align=\"center\" class=\"td3\" style=\"height: 25px\">" + " " + "</td><td align=\"center\" class=\"td3\" style=\"height: 25px\">" + " " + "</td><td align=\"center\" class=\"td3\" style=\"height: 25px\">" + " " + "</td><td align=\"center\" class=\"td3\" style=\"height: 25px\">" + " " + "</td><td align=\"center\" class=\"td3\" style=\"height: 25px\">" + " " + "</td><td align=\"center\" class=\"td3\" style=\"height: 25px\">" + " " + "</td><td align=\"center\" class=\"td3\" style=\"height: 25px\">" + " " + "</td><td align=\"center\" class=\"td3\" style=\"height: 25px\">" + " " + "</td><td align=\"center\" class=\"td3\" style=\"height: 25px\">" + " " + "</td><td align=\"center\" class=\"td3\" style=\"height: 25px\">" + " " + "</td><td align=\"center\" class=\"td5\" style=\"height: 25px\">" + " " + "</td></tr>"); sb.Append("\r\t </tbody>"); sb.Append("\r\t <tfoot class='noprint2' style=\"display:table-footer-group;font-weight:bold\"> <tr><td align=\"left\" class=\"noprint2\" colspan=\"8\" > 制表人: " + ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeName + "</td> <td align=\"right\" style=\"height: 23px\" class=\"noprint2\" colspan=\"22\" >打印日期:" + DateTime.Now.ToString("yyyy-MM-dd") + " </td> </tr></tfoot>"); sb.Append("\r\t </table>"); sb.Append("\r\t </td> </tr> </table>"); return(sb.ToString()); }
protected string getDeptName(string DeptId) { return(SalaryStandardBus.GetNameByDeptID(DeptId)); }