public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { Q_skyd_djb rpt = new Q_skyd_djb(); rpt.Site = this.Site; return(rpt); }
private void inital() { if (lsbh.Trim() != "" && sk_tt.Trim() != "") { ysk_tj = GetYsk(lsbh); if (sk_tt == "sk") { ds = B_common.GetList(" SELECT * from View_skyd_djb ", " lsbh='" + lsbh + "' and yydh='" + common_file.common_app.yydh + "'"); if (ds != null && ds.Tables[0].Rows.Count > 0) { try { Q_skyd_djb myreport = new Q_skyd_djb(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (ds.Tables[0].Rows[i]["zjhm"].ToString().Trim() != "") { ds.Tables[0].Rows[i]["yxzj"] = (ds.Tables[0].Rows[i]["yxzj"].ToString() + ": ") as object; } else { ds.Tables[0].Rows[i]["yxzj"] = ("") as object; } } myreport.SetDataSource(ds.Tables[0]); crystalReportViewer1.ReportSource = myreport; myreport.SetParameterValue("czy", czy); myreport.SetParameterValue("ysk_tj", ysk_tj); myreport.PrintToPrinter(1, true, 0, 0); } catch { common_file.common_app.Message_box_show(common_file.common_app.message_title, "打印出错,请正确设置打印机"); } } else { common_file.common_app.Message_box_show(common_file.common_app.message_title, "当前订单没有任何在住客人信息,打印终止!"); } } if (sk_tt == "tt") { ds = B_common.GetList(" SELECT * from VIEW_Qttyd_djb ", " ddbh='" + ddbh + "' and yydh='" + common_file.common_app.yydh + "'"); if (ds != null && ds.Tables[0].Rows.Count > 0) { try { Q_skyd_djb myreport = new Q_skyd_djb(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (ds.Tables[0].Rows[i]["zjhm"].ToString().Trim() != "") { ds.Tables[0].Rows[i]["yxzj"] = (ds.Tables[0].Rows[i]["yxzj"].ToString() + ": ") as object; } else { ds.Tables[0].Rows[i]["yxzj"] = ("") as object; } if (DateTime.Parse(ds.Tables[0].Rows[i]["krsr"].ToString().Trim()).Date.CompareTo(DateTime.Parse(common_file.common_app.cssj)) == 0) { ds.Tables[0].Rows[i]["krsr"] = ""; } } myreport.SetDataSource(ds.Tables[0]); crystalReportViewer1.ReportSource = myreport; myreport.SetParameterValue("czy", czy); myreport.SetParameterValue("ysk_tj", ysk_tj); myreport.PrintToPrinter(1, true, 0, 0); } catch { common_file.common_app.Message_box_show(common_file.common_app.message_title, "打印出错,请正确设置打印机"); } } else { common_file.common_app.Message_box_show(common_file.common_app.message_title, "当前订单没有任何在住客人信息,打印终止!"); } } } }