private void MakeReport(bool save = false)
{
string oonum = "-";
string oodate = "-";
string propno = this.propno.ToString();
if (save)
{
oonum = txtoonum.Text;
oodate = txtoodate.Text;
}
string sql = "select * from cadre.prop_redesig where propno = " + propno + " order by fdate,empid";
OraDBConnection oraCn = new OraDBConnection();
System.Data.DataSet ds = OraDBConnection.GetData(sql);
string pdfPath;
if (save)
{
pdfPath = Server.MapPath("office_orders\\" + oonum + "-BEG-I" + oodate + ".pdf");
}
else
{
pdfPath = Server.MapPath("office_orders\\preview_rdg-" + propno + "-" + DateTime.Now.ToString("yyyyMMdd-HHmmssfff") + ".pdf");
}
CrystalReportSource1.Report.FileName = Server.MapPath("Reports\\rptredesig.rpt");
CrystalReportSource1.ReportDocument.SetDataSource(ds.Tables[0]);
CrystalReportSource1.DataBind();
CrystalReportSource1.ReportDocument.ExportToDisk(ExportFormatType.PortableDocFormat, pdfPath);
Utils.DownloadFile(pdfPath);
}
protected void BindInfo()
{
CustAdviceModel model = new CustAdviceModel();
UserInfoUtil UserInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
/*接受参数*/
model.ID = Convert.ToInt32(Request.QueryString["ID"].ToString());
string CompanyCD = UserInfo.CompanyCD;
/*读取数据*/
DataTable dtDetail = new DataTable();
DataTable dt = XBase.Business.Office.CustManager.CustAdviceBus.GetOneCustAdviceInfo(model);
/*绑定RPT*/
if (dt != null)
{
/*加载主报表*/
this.CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/PrinttingModel/CustManager/CustAdvice.rpt"));
CrystalReportViewer1.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.CustAdvice"));
//绑定数据
CrystalReportSource1.ReportDocument.SetDataSource(dt);
CrystalReportSource1.DataBind();
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
CrystalReportSource1.ReportDocument.SetParameterValue("CreatorName", userInfo.UserName);
CrystalReportSource1.ReportDocument.SetParameterValue("CreatorName", userInfo.UserName);
CrystalReportSource1.ReportDocument.SetParameterValue("CreatorName", userInfo.UserName);
this.CrystalReportViewer1.ReportSource = CrystalReportSource1;
}
}
protected void Page_Load(object sender, EventArgs e)
{
SmoothEnterprise.Database.DataSet rs = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
rs.Open("SELECT no from [EIPB].[dbo].cxmt310_in_head where id='" + Request.QueryString["id"] + "' ");
if (!rs.EOF)
{
string sql;
sql = "EXEC CXMT310_Report1 '" + rs["no"].ToString() + "'";
string DBConfig_sql = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["EIPBConnectionString"].ConnectionString;
DataSet ds = new DataSet();
SqlConnection sqlCon = new SqlConnection(DBConfig_sql);
SqlDataAdapter sqlAd = new SqlDataAdapter();
SqlCommand sqlCmd = new SqlCommand(sql, sqlCon);
sqlAd.SelectCommand = sqlCmd;
sqlAd.Fill(ds, "sql");
CrystalReportSource1.ReportDocument.Load(Server.MapPath("CXMT310_Report1.rpt"));
CrystalReportSource1.ReportDocument.SetDataSource(ds.Tables["sql"]);
CrystalReportSource1.DataBind();
CrystalReportViewer1.ReportSource = CrystalReportSource1;
}
CrystalReportViewer1.DisplayGroupTree = false;
}
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();
}
//public void DataBindToDept()
//{
// DataTable dt = PerformanceQueryBus.SearchDeptInfo();
// ddlDeptName.DataSource = dt;
// ddlDeptName.DataTextField = "DeptName";
// ddlDeptName.DataValueField = "ID";
// ddlDeptName.DataBind();
// ddlDeptName.Items.Add(new System.Web.UI.WebControls.ListItem("--请选择--", "0"));
// ddlDeptName.SelectedValue = "0";
//}
public void Search()
{
ReportDocument oRpt = new ReportDocument();
CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/OperatingModel/CrystalReport/HumanManager/EmployeeExamination.rpt"));
// SetDatabaseLogon 拉模式中必须用这个方法来设置登录信息，参数一：用户名；参数二：密码；参数三：服务器；参数四：数据库名
CrystalReportViewer1.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.PerformanceSummary"));
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
EmployeeTestSearchModel searchModel = new EmployeeTestSearchModel();
searchModel.Addr = Request.Form["hidDeptID"] == null ? "" : Request.Form["hidDeptID"].ToString();
searchModel.StatusName = Request.Form["txtSearchEmployeeID"] == null ? "" : Request.Form["txtSearchEmployeeID"].ToString();
searchModel.StartDate = txtStartDate.Value;
searchModel.StartToDate = txtStartToDate.Value;
searchModel.EndDate = txtEndDate.Value;
searchModel.EndToDate = txtEndToDate.Value;
searchModel.CompanyCD = userInfo.CompanyCD;
//查询数据
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["Creator"].Text = "\"" + "制表人:" + userInfo.EmployeeName + "\"";
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["DeptName"].Text = "\"" + "开始日期:" + txtStartDate.Value + " 至 " + txtStartToDate.Value + "\"";
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["PerformanceType"].Text = "\"" + "结束日期:" + txtEndDate.Value + " 至 " + txtEndToDate.Value + "\"";
DataTable dtData = EmployeeTestBus.EmployeeExaminationReportInfo(searchModel);
DataTable dt = new DataTable();
DataColumn newCol = new DataColumn("LevelType");
DataColumn newCol2 = new DataColumn("ID");
dt.Columns.Add(newCol);
dt.Columns.Add(newCol2);
if (dtData.Rows.Count > 0)
{
for (int i = 0; i < dtData.Rows.Count; i++)
{
DataRow sk = dt.NewRow();
string deptName = EmployeeTestBus.getDept(dtData.Rows[i]["LevelType"] == null ? "" : dtData.Rows[i]["LevelType"].ToString());
sk["LevelType"] = deptName;
sk["ID"] = dtData.Rows[i]["ID"] == null ? "" : dtData.Rows[i]["ID"].ToString();
dt.Rows.Add(sk);
}
}
CrystalReportSource1.ReportDocument.SetDataSource(dt);
CrystalReportSource1.DataBind();
// CrystalReportViewer1是水晶报表浏览器，下面是给该浏览器赋上对像
CrystalReportViewer1.ReportSource = CrystalReportSource1;
// CrystalReportViewer1.DataBind();
}
protected void BindInfo()
{
UserInfoUtil UserInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
/*接受参数*/
int ID = Convert.ToInt32(Request.QueryString["ID"].ToString());
string ReprotNo = Request.QueryString["ReportNo"].ToString();
string CompanyCD = UserInfo.CompanyCD;
/*读取数据*/
DataTable dtDetail = new DataTable();
DataTable dt = XBase.Business.Office.StorageManager.CheckReportBus.GetReportInfo(ID);
dtDetail = XBase.Business.Office.StorageManager.CheckReportBus.GetDetailInfo(ID);
/*绑定RPT*/
if (dt != null)
{
/*加载主报表*/
this.CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/PrinttingModel/StorageManager/StorageCheckReport.rpt"));
CrystalReportViewer1.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.QualityCheckReport"));
/*加载子报表*/
ReportDocument rdDetail = new ReportDocument();
if (dtDetail.Rows.Count > 0)
{
rdDetail = CrystalReportSource1.ReportDocument.Subreports["StorageCheckReportDetail.rpt"];
rdDetail.SetDataSource(dtDetail);
}
//绑定数据
CrystalReportSource1.ReportDocument.SetDataSource(dt);
CrystalReportSource1.DataBind();
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
this.CrystalReportSource1.ReportDocument.SetParameterValue("Creator", userInfo.UserName);
this.CrystalReportViewer1.ReportSource = CrystalReportSource1;
}
}
//public void DataBindToYear()
//{
// string year = string.Empty;
// int yearTemp = DateTime.Now.Year - 10;
// for (int i = 0; i <= 30; i++)
// {
// ddlYear.Items.Add(new ListItem((yearTemp + i).ToString() + "年度", (yearTemp + i).ToString()));
// }
// ddlYear.SelectedValue = DateTime.Now.Year.ToString();
//}
//public void DataBindToMonth()
//{
// string month = string.Empty;
// int monthTemp = DateTime.Now.Month;
// if (monthTemp < 10)
// {
// month = "0" + monthTemp.ToString();
// }
// ddlEndMonth.SelectedValue = month;
// this.ddlStartMonth.SelectedValue = month;
//}
//public void DataBindToDept()
//{
// DataTable dt = PerformanceQueryBus.SearchDeptInfo();
// ddlDeptName.DataSource = dt;
// ddlDeptName.DataTextField = "DeptName";
// ddlDeptName.DataValueField = "ID";
// ddlDeptName.DataBind();
// ddlDeptName.Items.Add(new System.Web.UI.WebControls.ListItem("--请选择--", "0"));
// ddlDeptName.SelectedValue = "0";
//}
private void Search(string rectApplyID)
{
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//查询数据
DataTable dtData = RectApplyBus.GetRectApplyInfoWithIDByReport(rectApplyID);
DataTable dtSub = RectApplyBus.GetRectApplyDetailsInfoByReport(rectApplyID);
ReportDocument oRpt = new ReportDocument();
CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/OperatingModel/CrystalReport/HumanManager/RectApplyEdit.rpt"));
// SetDatabaseLogon 拉模式中必须用这个方法来设置登录信息，参数一：用户名；参数二：密码；参数三：服务器；参数四：数据库名
CrystalReportViewer1.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.SalaryReportSummary"));
ReportDocument rdDetail = CrystalReportSource1.ReportDocument.Subreports["RectApplyDetailReport.rpt"];
rdDetail.SetDataSource(dtSub);
//查询数据
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["Creator"].Text = "\"" + "制表人:" + userInfo.EmployeeName + "\"";
CrystalReportSource1.ReportDocument.SetDataSource(dtData);
CrystalReportSource1.DataBind();
// CrystalReportViewer1是水晶报表浏览器，下面是给该浏览器赋上对像
CrystalReportViewer1.ReportSource = CrystalReportSource1;
//CrystalReportViewer1.DataBind();
}
/*绑定信息*/
protected void BindInfo()
{
UserInfoUtil UserInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
/*接受参数*/
int ID = Convert.ToInt32(Request.QueryString["ID"].ToString());
string FromType = Request.QueryString["FromType"].ToString();
string ApplyNo = Request.QueryString["ApplyNo"].ToString();
string CompanyCD = UserInfo.CompanyCD;
/*读取数据*/
DataTable dtDetail = new DataTable();
DataTable dt = XBase.Business.Office.StorageManager.StorageQualityCheckPro.GetPrintQualityDB(ID);
if (FromType.Trim() == "0")
{
dtDetail = XBase.Business.Office.StorageManager.StorageQualityCheckPro.GetPrintQualityDetail(ApplyNo, CompanyCD, "0");
}
if (FromType == "1")
{
dtDetail = XBase.Business.Office.StorageManager.StorageQualityCheckPro.GetPrintQualityDetail(ApplyNo, CompanyCD, "1");
}
if (FromType == "2")
{
dtDetail = XBase.Business.Office.StorageManager.StorageQualityCheckPro.GetPrintQualityDetail(ApplyNo, CompanyCD, "2");
}
/*绑定RPT*/
if (dt != null)
{
/*加载主报表*/
if (FromType == "0")
{
CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/PrinttingModel/StorageManager/StorageQualityCheck.rpt"));
}
if (FromType == "1")
{
CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/PrinttingModel/StorageManager/StorageQualityCheckPur.rpt"));
}
if (FromType == "2")
{
CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/PrinttingModel/StorageManager/StorageQualityCheckMan.rpt"));
}
/*加载子报表*/
ReportDocument rdDetail = new ReportDocument();
if (dtDetail.Rows.Count > 0)
{
if (FromType == "0")
{
rdDetail = CrystalReportSource1.ReportDocument.Subreports["StorageQualityCheckDetail.rpt"];
rdDetail.SetDataSource(dtDetail);
}
if (FromType == "1")
{
rdDetail = CrystalReportSource1.ReportDocument.Subreports["StorageQualityCheckDetail3.rpt"];
rdDetail.SetDataSource(dtDetail);
}
if (FromType == "2")
{
rdDetail = CrystalReportSource1.ReportDocument.Subreports["StorageQualityCheckDetail2.rpt"];
rdDetail.SetDataSource(dtDetail);
}
}
CrystalReportViewer1.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.QualityCheckApplay"));
//绑定数据
CrystalReportSource1.ReportDocument.SetDataSource(dt);
CrystalReportSource1.DataBind();
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
CrystalReportSource1.ReportDocument.SetParameterValue("Creator", userInfo.UserName);
this.CrystalReportViewer1.ReportSource = CrystalReportSource1;
}
}
public void Search()
{
ReportDocument oRpt = new ReportDocument();
CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/OperatingModel/CrystalReport/HumanManager/EmployeeConditionMonthReport.rpt"));
// SetDatabaseLogon 拉模式中必须用这个方法来设置登录信息，参数一：用户名；参数二：密码；参数三：服务器；参数四：数据库名
CrystalReportViewer1.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.PerformanceSummary"));
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
EmployeeTestSearchModel searchModel = new EmployeeTestSearchModel();
string DeptID = ddlDeptName.SelectedValue;
string dds = Request.Form.ToString();
string year = Request.Form["ddlTaskYear"] == null ? "" : Request.Form["ddlTaskYear"].ToString();
string month = Request.Form["ddlTaskNum"] == null ? "" : Request.Form["ddlTaskNum"].ToString();
string day = "";
if (month == "01" || month == "03" || month == "05" || month == "07" || month == "08" || month == "10" || month == "12")
{
day = "31";
}
else if (month == "04" || month == "06" || month == "09" || month == "11")
{
day = "30";
}
else
{
if (IsLeapYear(Convert.ToInt32(year)))
{
day = "29";
}
else
{
day = "28";
}
}
string monthStartDate = year + "-" + month + "-" + "01";
string monthEndDate = year + "-" + month + "-" + day;
//查询数据
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["Creator"].Text = "\"" + "制表人:" + userInfo.EmployeeName + "\"";
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["Month"].Text = "\"" + "月份:" + year + "-" + month + "\"";
DataTable dt = new DataTable();
DataColumn newCol1 = new DataColumn("UsedName"); //部门
DataColumn newCol2 = new DataColumn("Attachmentname"); //招聘人数
DataColumn newCol3 = new DataColumn("EmployeeName"); //面试人数
DataColumn newCol4 = new DataColumn("NameEn"); //报道人数
DataColumn newCol5 = new DataColumn("AccountNature"); //迟到人数
DataColumn newCol6 = new DataColumn("Height"); //早退人数
DataColumn newCol7 = new DataColumn("Weight"); //旷工次数
DataColumn newCol8 = new DataColumn("Sight"); //请假次数
DataColumn newCol9 = new DataColumn("EmployeeNo"); //迁调人数
DataColumn newCol10 = new DataColumn("CompanyCD"); //迁调人数
dt.Columns.Add(newCol1);
dt.Columns.Add(newCol2);
dt.Columns.Add(newCol3);
dt.Columns.Add(newCol4);
dt.Columns.Add(newCol5);
dt.Columns.Add(newCol6);
dt.Columns.Add(newCol7);
dt.Columns.Add(newCol8);
dt.Columns.Add(newCol9);
dt.Columns.Add(newCol10);
// 部门招聘人数
DataTable GetRequireNum = EmployeeTestBus.GetRequireNum(DeptID, monthStartDate, monthEndDate);
// 部门面试人数
DataTable GetInterviewNum = EmployeeTestBus.GetInterviewNum(DeptID, monthStartDate, monthEndDate);
// 部门报道人数
DataTable GetReportedNum = EmployeeTestBus.GetReportedNum(DeptID, monthStartDate, monthEndDate);
// 部门迟到人数
DataTable GetLatedNum = EmployeeTestBus.GetLatedNum(DeptID, monthStartDate, monthEndDate);
// 部门早退人数
DataTable GetLeaveEarlyNum = EmployeeTestBus.GetLeaveEarlyNum(DeptID, monthStartDate, monthEndDate);
// 部门旷工人次
DataTable GetAbsenteeismNum = EmployeeTestBus.GetAbsenteeismNum(DeptID, monthStartDate, monthEndDate);
// 部门请假次数
DataTable GetLeaveNum = EmployeeTestBus.GetLeaveNum(DeptID, monthStartDate, monthEndDate);
// 部门调出人数
DataTable GetDeptOutNum = EmployeeTestBus.GetDeptOutNum(DeptID, monthStartDate, monthEndDate);
// 部门调入人数
DataTable GetDeptInNum = EmployeeTestBus.GetDeptInNum(DeptID, monthStartDate, monthEndDate);
// 部门离职人数
DataTable GetSeparationNum = EmployeeTestBus.GetSeparationNum(DeptID, monthStartDate, monthEndDate);
//获取某公司的所有部门
DataTable dtData = EmployeeTestBus.GetDeptInfo(DeptID);
if (dtData.Rows.Count > 0)
{
for (int i = 0; i < dtData.Rows.Count; i++)
{
DataRow sk = dt.NewRow();
string deptName = dtData.Rows[i]["DeptName"] == null ? "" : dtData.Rows[i]["DeptName"].ToString();
sk["UsedName"] = deptName;
string ID = dtData.Rows[i]["ID"] == null ? "" : dtData.Rows[i]["ID"].ToString();
// 部门招聘人数
DataTable GetRequireNum2 = GetNewDataTable(GetRequireNum, "applyDept='" + ID + "'");
if (GetRequireNum2.Rows.Count > 0)
{
sk["Attachmentname"] = GetRequireNum2.Rows[0]["PersonCount"] == null ? "" : GetRequireNum2.Rows[0]["PersonCount"].ToString();
}
// 部门面试人数
DataTable GetInterviewNum2 = GetNewDataTable(GetInterviewNum, "DeptID='" + ID + "'");
if (GetInterviewNum2.Rows.Count > 0)
{
sk["EmployeeName"] = GetInterviewNum2.Rows[0]["InterviewNum"] == null ? "" : GetInterviewNum2.Rows[0]["InterviewNum"].ToString();
}
// 部门报道人数
DataTable GetReportedNum2 = GetNewDataTable(GetReportedNum, "DeptID='" + ID + "'");
if (GetReportedNum2.Rows.Count > 0)
{
sk["NameEn"] = GetReportedNum2.Rows[0]["ReportedNum"] == null ? "" : GetReportedNum2.Rows[0]["ReportedNum"].ToString();
}
// 部门迟到人数
DataTable GetLatedNum2 = GetNewDataTable(GetLatedNum, "DeptID='" + ID + "'");
if (GetLatedNum2.Rows.Count > 0)
{
sk["AccountNature"] = GetLatedNum2.Rows[0]["DelayManCount"] == null ? "" : GetLatedNum2.Rows[0]["DelayManCount"].ToString();
}
// 部门早退人数
DataTable GetLeaveEarlyNum2 = GetNewDataTable(GetLeaveEarlyNum, "DeptID='" + ID + "'");
if (GetLeaveEarlyNum2.Rows.Count > 0)
{
sk["Height"] = GetLeaveEarlyNum2.Rows[0]["DelayManCount"] == null ? "" : GetLeaveEarlyNum2.Rows[0]["DelayManCount"].ToString();
}
// 部门旷工人次
DataTable GetAbsenteeismNum2 = GetNewDataTable(GetAbsenteeismNum, "DeptID='" + ID + "'");
if (GetAbsenteeismNum2.Rows.Count > 0)
{
sk["Weight"] = GetAbsenteeismNum2.Rows[0]["Absentee"] == null ? "" : GetAbsenteeismNum2.Rows[0]["Absentee"].ToString();
}
// 部门请假次数
DataTable GetLeaveNum2 = GetNewDataTable(GetLeaveNum, "DeptID='" + ID + "'");
if (GetLeaveNum2.Rows.Count > 0)
{
sk["Sight"] = GetLeaveNum2.Rows[0]["leaveCount"] == null ? "" : GetLeaveNum2.Rows[0]["leaveCount"].ToString();
}
//部门迁出人数
DataTable GetDeptOutNum2 = GetNewDataTable(GetDeptOutNum, "NowDeptID='" + ID + "'");
string outNum = "0";
if (GetDeptOutNum2.Rows.Count > 0)
{
outNum = GetDeptOutNum2.Rows[0]["countQian"] == null ? "0" : GetDeptOutNum2.Rows[0]["countQian"].ToString();
}
//部门迁入人数
DataTable GetDeptInNum2 = GetNewDataTable(GetDeptInNum, "NewDeptID='" + ID + "'");
string intNum = "0";
if (GetDeptInNum2.Rows.Count > 0)
{
intNum = GetDeptInNum2.Rows[0]["countQian"] == null ? "0" : GetDeptInNum2.Rows[0]["countQian"].ToString();
}
string qianNum = (Convert.ToInt32(outNum) + Convert.ToInt32(intNum)).ToString();
if (qianNum == "0")
{
qianNum = "";
}
sk["EmployeeNo"] = qianNum;
// 部门离职人次
DataTable GetSeparationNum2 = GetNewDataTable(GetSeparationNum, "DeptID='" + ID + "'");
if (GetSeparationNum2.Rows.Count > 0)
{
sk["CompanyCD"] = GetSeparationNum2.Rows[0]["separateNum"] == null ? "" : GetSeparationNum2.Rows[0]["separateNum"].ToString();
}
dt.Rows.Add(sk);
}
}
CrystalReportSource1.ReportDocument.SetDataSource(dt);
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();
}
public void Search()
{
ReportDocument oRpt = new ReportDocument();
if (chkType1.Checked)
{
CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/OperatingModel/CrystalReport/HumanManager/PerformanceStaticByLT.rpt"));
}
if (chkType2.Checked)
{
CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/OperatingModel/CrystalReport/HumanManager/PerformanceStaticByLTBing.rpt"));
}
if (chkType3.Checked)
{
CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/OperatingModel/CrystalReport/HumanManager/PerformanceStaticByLTZhe.rpt"));
}
// SetDatabaseLogon 拉模式中必须用这个方法来设置登录信息，参数一：用户名；参数二：密码；参数三：服务器；参数四：数据库名
CrystalReportViewer1.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.PerformanceSummary"));
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
PerformanceTaskModel searchModel = new PerformanceTaskModel();
if (ddlDeptName.SelectedValue != "0" && ddlDeptName.SelectedIndex != -1)//部门
{
searchModel.SummaryDate = ddlDeptName.SelectedValue;
}
if (ddlTaskFlag.SelectedIndex != 0)
{
searchModel.TaskFlag = ddlTaskFlag.SelectedValue; //考核期间类型
}
if (ddlTestNo.SelectedValue != "0" && ddlTestNo.SelectedIndex != -1)
{
searchModel.TaskNo = ddlTestNo.SelectedValue; //考核任务编号
}
if (this.ddlPerType.SelectedValue != "0" && ddlPerType.SelectedIndex != -1)
{
searchModel.CompleteDate = this.ddlPerType.SelectedValue; //考核类型
}
if (ddlTaskFlag.SelectedValue != "4" && ddlTaskFlag.SelectedValue != "5")
{
if (this.ddlTaskNum.SelectedValue != "0" && ddlTaskNum.SelectedIndex != -1)
{
searchModel.TaskNum = ddlTaskNum.SelectedValue; //考核期间
}
}
if (this.ddlLevelType.SelectedIndex != 0)
{
searchModel.Summaryer = ddlLevelType.SelectedValue; //考核等级
}
// if (Request.QueryString["AdviceType"] != "0")
// searchModel.Title = Request.QueryString["AdviceType"];//考核建议
if (this.ddlTaskYear.SelectedIndex != 0 && this.ddlTaskYear.SelectedIndex != -1)
{
searchModel.TaskDate = ddlTaskYear.SelectedValue; //考核建议
}
// if (!string.IsNullOrEmpty(Request.QueryString["EmployeeID"]))
// searchModel.EditFlag = Request.QueryString["EmployeeID"];//被考核人
searchModel.CompanyCD = userInfo.CompanyCD;
//查询数据
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["DeptName"].Text = "\"" + "" + "\"";
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["PerformanceType"].Text = "\"" + "" + "\"";
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["taskFlag"].Text = "\"" + "" + "\"";
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["taskNum"].Text = "\"" + "考核期间:" + "全部" + "\"";
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["Creator"].Text = "\"" + "制表人:" + userInfo.EmployeeName + "\"";
DataTable dtData = PerformanceQueryBus.SearchDetailsInfoByLT(searchModel);
if (ddlDeptName.SelectedValue != "0" && ddlDeptName.SelectedIndex != -1)
{
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["DeptName"].Text = "\"" + "部门:" + ddlDeptName.Items[ddlDeptName.SelectedIndex].Text + "\"";
}
else
{
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["DeptName"].Text = "\"" + "部门:" + "全部" + "\"";
}
if (this.ddlPerType.SelectedValue != "0" && ddlPerType.SelectedIndex != -1)
{
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["PerformanceType"].Text = "\"" + "考核类型:" + ddlPerType.Items[ddlPerType.SelectedIndex].Text + "\"";
}
else
{
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["PerformanceType"].Text = "\"" + "考核类型:" + "全部" + "\"";
}
if (ddlTaskFlag.SelectedIndex != 0)
{
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["taskFlag"].Text = "\"" + "考核期间类型:" + ddlTaskFlag.Items[ddlTaskFlag.SelectedIndex].Text + "\"";
}
else
{
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["taskFlag"].Text = "\"" + "考核期间类型:" + "全部" + "\"";
}
if (ddlTaskFlag.SelectedValue != "4" && ddlTaskFlag.SelectedValue != "5")
{
if (this.ddlTaskNum.SelectedValue != "0" && ddlTaskNum.SelectedIndex != -1)
{
if (this.ddlTaskYear.SelectedIndex != 0 && this.ddlTaskYear.SelectedIndex != -1)
{
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["taskNum"].Text = "\"" + "考核期间:" + ddlTaskYear.Items[ddlTaskYear.SelectedIndex].Text + ddlTaskNum.Items[ddlTaskNum.SelectedIndex].Text + "\"";
}
else
{
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["taskNum"].Text = "\"" + "考核期间:" + "所有年份" + ddlTaskNum.Items[ddlTaskNum.SelectedIndex].Text + "\"";
}
}
}
else
{
if (this.ddlTaskYear.SelectedIndex != 0 && this.ddlTaskYear.SelectedIndex != -1)
{
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["taskNum"].Text = "\"" + ddlTaskYear.Items[ddlTaskYear.SelectedIndex].Text + "\"";
}
}
CrystalReportSource1.ReportDocument.SetDataSource(dtData);
CrystalReportSource1.DataBind();
// CrystalReportViewer1是水晶报表浏览器，下面是给该浏览器赋上对像
CrystalReportViewer1.ReportSource = CrystalReportSource1;
// CrystalReportViewer1.DataBind();
}
protected void lnkDownloadPrv_Click(object sender, EventArgs e)
{
string oonum = ((System.Web.UI.WebControls.GridViewRow)((((System.Web.UI.Control)(sender)).Parent).Parent)).Cells[7].Text;
string propno = ((System.Web.UI.WebControls.GridViewRow)((((System.Web.UI.Control)(sender)).Parent).Parent)).Cells[3].Text;
string sql = "SELECT m.sno, p.OONUM AS oonum1, to_char(p.OODATE,'dd-MM-yyyy') AS oodate1, '1' AS notes, p.ENDONUM AS endono,10 AS fsize," +
"(SELECT COUNT(*) FROM cadre.propcadrmap WHERE propno = 163 ) AS TotCount," +
"(SELECT COUNT(*) FROM cadre.propcadrmap WHERE status = 'P' AND propno = 163 ) AS PCount," +
"pshr.get_fullname(e.empid) AS fullname," +
"TO_CHAR(e.empid) AS empid," +
"TO_CHAR(e.dob,'dd-mm-yyyy') AS dob," +
"pshr.get_post(e.cloccode) AS old_work_loc," +
"e.cloccode AS old_work_loccode," +
"pshr.get_desg(e.cdesgcode) AS old_work_desg," +
"e.cdesgcode AS old_work_desgcode," +
"DECODE(m.rowno,0,pshr.get_post(e.cloccode), pshr.get_post(cadre.get_lcode_rno(m.rowno))) AS old_pc_loc," +
"DECODE(m.rowno,0,e.cloccode, cadre.get_lcode_rno(m.rowno)) AS old_pc_loccode," +
"DECODE(m.rowno,0,pshr.get_desg(e.cdesgcode), pshr.get_desg(cadre.get_dcode_rno(m.rowno))) AS old_pc_desg," +
"DECODE(m.rowno,0,e.cdesgcode, cadre.get_dcode_rno(m.rowno)) AS old_pc_desgcode," +
"DECODE(m.rowno,0,'0', cadre.get_indx_rno(m.rowno)) AS old_pc_indx," +
"cadre.get_org_plants(m.cloccode) AS new_work_loc," +
"m.cloccode AS new_work_loccode," +
"pshr.get_desg(m.cdesgcode) AS new_work_desg," +
"m.cdesgcode AS new_work_desgcode," +
"DECODE(LENGTH(m.proposed_rowno),9,pshr.get_post(m.proposed_rowno), cadre.get_org_plants(cadre.get_lcode_rno(m.proposed_rowno))) AS new_pc_loc," +
"DECODE(LENGTH(m.proposed_rowno),9,m.proposed_rowno, cadre.get_lcode_rno(m.proposed_rowno)) AS new_pc_loccode," +
"DECODE(m.proposed_rowno,0,pshr.get_desg(m.cdesgcode), pshr.get_desg(cadre.get_dcode_rno(m.proposed_rowno))) AS new_pc_desg," +
"DECODE(m.proposed_rowno,0,m.cdesgcode, cadre.get_dcode_rno(m.proposed_rowno)) AS new_pc_desgcode," +
"cadre.get_indx_rno(m.proposed_rowno) AS new_pc_indx," +
"(select data from cadre.bignotes where name = p.bignote) AS BIGNOTE," +
"(select data from cadre.bigcc where name = p.bigcc) AS BIGCC," +
"m.sysremarks" +
"|| m.remarks AS remarks," +
"'G' AS grp," +
"m.propno," +
"m.prvcomment," +
"TO_CHAR(m.newempid) AS newempid," +
"m.status," +
"m.disp_left," +
"m.disp_right," +
"pshr.get_soccat(e.empid) AS categ " +
"FROM pshr.empperso e," +
"cadre.propcadrmap m," +
"cadre.tp_proposals p " +
"WHERE e.empid =m.empid " +
"AND m.propno = p.pno " +
"AND m.status IS NOT NULL " +
"AND M.STATUS NOT IN ('S','V') " +
"AND m.propno =" + propno + " " +
"AND m.cloccode IS NOT NULL " +
"ORDER BY sno";
System.Data.DataSet ds = OraDBConnection.GetData(sql);
string pdfPath;
pdfPath = Server.MapPath("office_orders\\" + oonum.Replace("\\", "").Replace("/", "") + "-BEG-I.pdf");
CrystalReportSource1.Report.FileName = Server.MapPath("Reports\\rptposttrans_pc.rpt");
CrystalReportSource1.ReportDocument.SetDataSource(ds.Tables[0]);
CrystalReportSource1.DataBind();
CrystalReportSource1.ReportDocument.ExportToDisk(ExportFormatType.PortableDocFormat, pdfPath);
Utils.DownloadFile(pdfPath);
}
private void MakeReport()
{
string oonum = "-";
string oodate = "-";
string notes = "";
if (Session.Contents["save"].ToString() == "YES")
{
oonum = Session.Contents["oonum"].ToString();
oodate = Session.Contents["oodate"].ToString();
}
//notes = Session.Contents["notes"].ToString();
notes = "1";
string sql = "select m.sno,'" + oonum + "' as oonum1, '" + oodate + "' as oodate1, '" + notes + "' as notes," +
" pshr.get_fullname(e.empid),e.empid,e.dob," +
"pshr.get_post(e.cloccode) as old_work_loc,e.cloccode as old_work_loccode,pshr.get_desg(e.cdesgcode) as old_work_desg," +
"e.cdesgcode as old_work_desgcode," +
"DECODE(m.rowno,0,pshr.get_post(e.cloccode), pshr.get_post(cadre.get_lcode_rno(m.rowno))) AS old_pc_loc," +
" DECODE(m.rowno,0,e.cloccode, cadre.get_lcode_rno(m.rowno)) AS old_pc_loccode," +
" DECODE(m.rowno,0,pshr.get_desg(e.cdesgcode), pshr.get_desg(cadre.get_dcode_rno(m.rowno))) AS old_pc_desg, " +
" DECODE(m.rowno,0,e.cdesgcode, cadre.get_dcode_rno(m.rowno)) AS old_pc_desgcode, " +
" DECODE(m.rowno,0,'0', cadre.get_indx_rno(m.rowno)) AS old_pc_indx, " +
//pshr.get_post(cadre.get_lcode_rno(m.rowno)) as old_pc_loc," +
//"cadre.get_lcode_rno(m.rowno) as old_pc_loccode,pshr.get_desg(cadre.get_dcode_rno(m.rowno)) as old_pc_desg," +
//"cadre.get_dcode_rno(m.rowno) as old_pc_desgcode,cadre.get_indx_rno(m.rowno) as old_pc_indx,
" pshr.get_post(m.cloccode) as new_work_loc," +
"m.cloccode as new_work_loccode,pshr.get_desg(m.cdesgcode) as new_work_desg,m.cdesgcode as new_work_desgcode," +
//"pshr.get_post(cadre.get_lcode_rno(m.proposed_rowno)) as new_pc_loc,cadre.get_lcode_rno(m.proposed_rowno) as new_pc_loccode," +
"decode(length(m.proposed_rowno),9,pshr.get_post(m.proposed_rowno), pshr.get_post(cadre.get_lcode_rno(m.proposed_rowno))) AS new_pc_loc," +
"decode(length(m.proposed_rowno),9,m.proposed_rowno, cadre.get_lcode_rno(m.proposed_rowno)) AS new_pc_loccode," +
" DECODE(m.rowno,0,pshr.get_desg(e.cdesgcode), pshr.get_desg(cadre.get_dcode_rno(m.proposed_rowno))) AS new_pc_desg, " +
" DECODE(m.rowno,0,e.cdesgcode, cadre.get_dcode_rno(m.proposed_rowno)) AS new_pc_desgcode, " +
//"decode(length(m.proposed_rowno),9,pshr.get_desg(cadre.get_dcode_rno(m.rowno)), pshr.get_desg(cadre.get_dcode_rno(m.proposed_rowno))) AS new_pc_desg,"+
//"decode(length(m.proposed_rowno),9,cadre.get_dcode_rno(m.rowno), cadre.get_dcode_rno(m.proposed_rowno)) AS new_pc_desgcode,"+
////"pshr.get_desg(cadre.get_dcode_rno(m.proposed_rowno)) as new_pc_desg,cadre.get_dcode_rno(m.proposed_rowno) as new_pc_desgcode," +
"cadre.get_indx_rno(m.proposed_rowno) as new_pc_indx, m.remarks,'G' as grp,m.proposalno from pshr.empperso e, cadre.cadrmap m where e.empid=m.empid and m.status is not null " +
"order by sno";
OraDBConnection oraCn = new OraDBConnection();
System.Data.DataSet ds = OraDBConnection.GetData(sql);
string pdfPath;
if (Session.Contents["save"].ToString() == "YES")
{
pdfPath = Server.MapPath("office_orders\\" + oonum + "\\BEG-I" + oodate + ".pdf");
}
else
{
//get sysdate
string sysdate = OraDBConnection.GetScalar("select to_char(sysdate,'dd-mm-yyyy') from dual");
string systime = OraDBConnection.GetScalar("select to_char(sysdate,'hh-mm') from dual");
pdfPath = Server.MapPath("office_orders\\" + sysdate + systime + ".pdf");
}
CrystalReportSource1.Report.FileName = Server.MapPath("Reports\\rptposttrans.rpt");
CrystalReportSource1.ReportDocument.SetDataSource(ds.Tables[0]);
CrystalReportSource1.DataBind();
CrystalReportViewer1.ReportSource = CrystalReportSource1;
CrystalReportViewer1.DataBind();
System.Data.DataSet ds6;
string sql3 = "select * from cadre.notes_proposal_person where ccnum > 0 order by sno";
ds6 = OraDBConnection.GetData(sql3);
CrystalReportSource1.ReportDocument.Subreports["notes"].SetDataSource(ds6.Tables[0]);
CrystalReportSource1.DataBind();
System.Data.DataSet ds5;
string sql2 = "select * from cadre.cclist_proposal_person where ccnum > 0 order by sno";
ds5 = OraDBConnection.GetData(sql2);
CrystalReportSource1.ReportDocument.Subreports["cclists"].SetDataSource(ds5.Tables[0]);
CrystalReportSource1.DataBind();
CrystalReportSource1.ReportDocument.ExportToDisk(ExportFormatType.PortableDocFormat, pdfPath);
DownloadFile(pdfPath);
}
