public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { BB_zzkrdqtj rpt = new BB_zzkrdqtj(); rpt.Site = this.Site; return(rpt); }
private void displayBB(string sql_0, string sql_other) { string sel_str = ""; sel_str = " id>=0 and yydh='" + common_file.common_app.yydh + "' " + sql_0 + sql_other + " "; ds = B_common.GetList(" select krxm,krxb,yxzj,zjhm,krgj,ddsj,czsj as '离店时间' from Qskyd_mainrecord_lskr ", sel_str); if (ds != null && ds.Tables[0].Rows.Count > 0) { //这一部分计算人数 //境内的人数(国家为中国或者yxzj为身份证都为境内) for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (ds.Tables[0].Rows[i]["yxzj"].ToString().Equals(common_file.common_app.yxzj_sfz)) { ds.Tables[0].Rows[i]["krgj"] = common_file.common_app.krgj_zg; } } int kr_jn_tj = 0; int kr_jw_tj = 0; int kr_wz_tj = 0; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (ds.Tables[0].Rows[i]["krgj"].ToString().Equals(common_file.common_app.krgj_zg)) { kr_jn_tj++; } if (ds.Tables[0].Rows[i]["krgj"].ToString() != null && ds.Tables[0].Rows[i]["krgj"].ToString() != "" && ds.Tables[0].Rows[i]["krgj"].ToString() != common_file.common_app.krgj_zg) { kr_jw_tj++; } if (ds.Tables[0].Rows[i]["krgj"].ToString() != null && ds.Tables[0].Rows[i]["krgj"].ToString() == "" && ds.Tables[0].Rows[i]["yxzj"].ToString() != common_file.common_app.yxzj_sfz) { kr_wz_tj++; } } kr_jn = kr_jn_tj.ToString(); kr_jw = kr_jw_tj.ToString(); kr_wz = kr_wz_tj.ToString(); p_gl.Visible = false; common_bb.displayprogress(progressBar1); string _qymc = ""; string _qymc_english = ""; string _address_chinese = ""; string _address_english = ""; string _qydh = ""; string _qycz = ""; string _qyyb = ""; string _website = ""; common_file.common_app.GetPrintInfo(ref _qymc, ref _qymc_english, ref _address_chinese, ref _address_english, ref _qydh, ref _qycz, ref _qyyb, ref _website); BB_zzkrdqtj myreport = new BB_zzkrdqtj(); myreport.SetDataSource(ds.Tables[0]); myreport.SetParameterValue("qymc", common_file.common_app.qymc); //myreport.SetParameterValue("cssj", Time_begin.Trim().Replace('/', '-')); //myreport.SetParameterValue("jssj", Time_end.Trim().Replace('/', '-')); myreport.SetParameterValue("address", _address_chinese); myreport.SetParameterValue("Tel", _qydh); myreport.SetParameterValue("Fax", _qycz); myreport.SetParameterValue("kr_jn", kr_jn); myreport.SetParameterValue("kr_jw", kr_jw); myreport.SetParameterValue("kr_wz", kr_wz); myreport.SetParameterValue("TimeSpan", timeSpan); crystalReportViewer1.ReportSource = myreport; } else { crystalReportViewer1.ReportSource = null; common_file.common_app.Message_box_show(common_file.common_app.message_title, "当前时间段内没有分析数据,您可以更改查询条件来获取其它的分析数据!"); } }