protected void btnImport_Click(object sender, System.Web.UI.ImageClickEventArgs e) { SalaryReportModel searchModel = new SalaryReportModel(); //设置查询条件 //报表编号 searchModel.ReprotNo = txtReportNo.Text.Trim(); //报表主题 searchModel.ReportName = txtReportName.Text.Trim(); //所属年月 searchModel.ReportMonth = Request.Form["ddlYear"].ToString() + Request.Form["ddlMonth"].ToString(); //编制状态 searchModel.Status = Request.Form["ddlStatus"].ToString(); //审批状态 searchModel.FlowStatus = Request.Form["ddlFlowStatus"].ToString(); //查询数据 DataTable dtReport = SalaryReportBus.SearchReportInfo(searchModel); //导出标题 string headerTitle = "工资报表编号|工资报表主题|所属月份|开始日期|结束日期|编制人|编制日期|报表状态|审批状态"; string[] header = headerTitle.Split('|'); //导出标题所对应的列字段名称 string columnFiled = "ReprotNo|ReportName|ReportMonth|StartDate|EndDate|Creator|CreateDate|StatusName|FlowStatus"; string[] field = columnFiled.Split('|'); XBase.Common.OutputToExecl.ExportToTable(this.Page, dtReport, header, field, "工资报表列表"); }
public DataSet getSalaryReport(SalaryReportModel objSalaryReportModel) { DataSet dsGetAttendanceReport = new DataSet(); SqlParameter[] sqlParams = new SqlParameter[2]; //sqlParams[0] = new SqlParameter("@month", SqlDbType.VarChar, 15); //sqlParams[0].Value = objSalaryReportModel.Month; //sqlParams[1] = new SqlParameter("@year", SqlDbType.VarChar, 10); //sqlParams[1].Value = objSalaryReportModel.Year; SqlConnection con = new SqlConnection(ConnectionString); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SalaryReport"; cmd.CommandTimeout = 6000; //cmd.Parameters.Add(sqlParams); cmd.Parameters.Add("@month", SqlDbType.VarChar); cmd.Parameters["@month"].Value = objSalaryReportModel.Month; cmd.Parameters.Add("@year", SqlDbType.VarChar); cmd.Parameters["@year"].Value = objSalaryReportModel.Year; cmd.Connection = con; SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dsGetAttendanceReport); //dsGetAttendanceReport = SqlHelper.ExecuteDataset(ConnectionString, CommandType.StoredProcedure, "SalaryReport", sqlParams); return(dsGetAttendanceReport); }
public DataSet getSalaryReport(SalaryReportModel objSalaryReportModel) { return(objSalaryReportDAL.getSalaryReport(objSalaryReportModel)); }