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));
}
