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