importreport.h

Visual C++.net数据库开发经典案例

#pragma once
#include "ImportReport.rpt"

using namespace System;
using namespace System::ComponentModel;
using namespace System::Collections;
using namespace System::Windows::Forms;
using namespace System::Data;
using namespace System::Drawing;
using namespace CrystalDecisions::CrystalReports::Engine;

namespace My
{
	/// <summary> 
	/// ImportReport 摘要
	///
	/// 警告: 如果您更改该类的名称，则将需要更改 
	///          与该类所依赖的所有 .resx 文件关联的托管资源编译器工具的 
	///          “资源文件名”属性。  否则，
	///          设计器将不能与此窗体关联的
	///          本地化资源正确交互。
	/// </summary>
	public __gc class ImportReportForm : public System::Windows::Forms::Form
	{
	public: 
		ImportReportForm(void)
		{
			InitializeComponent();
		}
        
	protected: 
		void Dispose(Boolean disposing)
		{
			if (disposing && components)
			{
				components->Dispose();
			}
			__super::Dispose(disposing);
		}
	private: CrystalDecisions::Windows::Forms::CrystalReportViewer *  crystalReportViewer1;
	private: System::Data::SqlClient::SqlDataAdapter *  sqlDataAdapter1;
	private: System::Data::SqlClient::SqlCommand *  sqlSelectCommand1;
	private: System::Data::SqlClient::SqlConnection *  sqlConnection1;
	private: My::DataSet8 *  dataSet81;
	private: My::DataSet8 *  dataSet82;









	private:
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		System::ComponentModel::Container* components;

		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		void InitializeComponent(void)
		{
			this->crystalReportViewer1 = new CrystalDecisions::Windows::Forms::CrystalReportViewer();
			this->sqlDataAdapter1 = new System::Data::SqlClient::SqlDataAdapter();
			this->sqlSelectCommand1 = new System::Data::SqlClient::SqlCommand();
			this->sqlConnection1 = new System::Data::SqlClient::SqlConnection();
			this->dataSet82 = new My::DataSet8();
			(__try_cast<System::ComponentModel::ISupportInitialize *  >(this->dataSet82))->BeginInit();
			this->SuspendLayout();
			// 
			// crystalReportViewer1
			// 
			this->crystalReportViewer1->ActiveViewIndex = -1;
			this->crystalReportViewer1->DisplayGroupTree = false;
			this->crystalReportViewer1->Dock = System::Windows::Forms::DockStyle::Fill;
			this->crystalReportViewer1->Location = System::Drawing::Point(0, 0);
			this->crystalReportViewer1->Name = S"crystalReportViewer1";
			this->crystalReportViewer1->ReportSource = 0;
			this->crystalReportViewer1->Size = System::Drawing::Size(776, 357);
			this->crystalReportViewer1->TabIndex = 0;
			// 
			// sqlDataAdapter1
			// 
			this->sqlDataAdapter1->SelectCommand = this->sqlSelectCommand1;
			System::Data::Common::DataTableMapping* __mcTemp__1[] = new System::Data::Common::DataTableMapping*[1];
			System::Data::Common::DataColumnMapping* __mcTemp__2[] = new System::Data::Common::DataColumnMapping*[14];
			__mcTemp__2[0] = new System::Data::Common::DataColumnMapping(S"供货商号", S"StockerID");
			__mcTemp__2[1] = new System::Data::Common::DataColumnMapping(S"货号", S"WareID");
			__mcTemp__2[2] = new System::Data::Common::DataColumnMapping(S"进货日期", S"ImportDate");
			__mcTemp__2[3] = new System::Data::Common::DataColumnMapping(S"业务员", S"Operator");
			__mcTemp__2[4] = new System::Data::Common::DataColumnMapping(S"进货数量", S"ImportQuantity");
			__mcTemp__2[5] = new System::Data::Common::DataColumnMapping(S"进价", S"ImportPrice");
			__mcTemp__2[6] = new System::Data::Common::DataColumnMapping(S"税价合计", S"Total");
			__mcTemp__2[7] = new System::Data::Common::DataColumnMapping(S"税率", S"TaxRate");
			__mcTemp__2[8] = new System::Data::Common::DataColumnMapping(S"不含税价", S"TotalNoTax");
			__mcTemp__2[9] = new System::Data::Common::DataColumnMapping(S"税额", S"Tax");
			__mcTemp__2[10] = new System::Data::Common::DataColumnMapping(S"名称", S"Name");
			__mcTemp__2[11] = new System::Data::Common::DataColumnMapping(S"品名", S"WareName");
			__mcTemp__2[12] = new System::Data::Common::DataColumnMapping(S"仓库", S"Depot");
			__mcTemp__2[13] = new System::Data::Common::DataColumnMapping(S"单位", S"Unit");
			__mcTemp__1[0] = new System::Data::Common::DataTableMapping(S"Table", S"ImportTable", __mcTemp__2);
			this->sqlDataAdapter1->TableMappings->AddRange(__mcTemp__1);
			// 
			// sqlSelectCommand1
			// 
			this->sqlSelectCommand1->CommandText = S"SELECT 进货单.供货商号, 进货单明细.货号, 进货单.进货日期, 进货单.业务员, 进货单明细.进货数量, 进货单明细.进价, 进货单明细.税价合计, 进" 
				S"货单明细.税率, 进货单明细.不含税价, 进货单明细.税额, 供货商清单.名称, 商品清单.品名, 进货单明细.仓库, 商品清单.单位 FROM 进货单 INN" 
				S"ER JOIN 进货单明细 ON 进货单.编号 = 进货单明细.进货单号 INNER JOIN 供货商清单 ON 进货单.供货商号 = 供货商清单.供货商号 I" 
				S"NNER JOIN 商品清单 ON 进货单明细.货号 = 商品清单.货号";
			this->sqlSelectCommand1->Connection = this->sqlConnection1;
			// 
			// sqlConnection1
			// 
			this->sqlConnection1->ConnectionString = S"workstation id=\"NDT-DENGYUANHUI\";packet size=4096;integrated security=SSPI;initia" 
				S"l catalog=jxcbook;persist security info=False";
			// 
			// dataSet82
			// 
			this->dataSet82->DataSetName = S"DataSet8";
			this->dataSet82->Locale = new System::Globalization::CultureInfo(S"zh-CN");
			// 
			// ImportReportForm
			// 
			this->AutoScaleBaseSize = System::Drawing::Size(6, 14);
			this->ClientSize = System::Drawing::Size(776, 357);
			this->Controls->Add(this->crystalReportViewer1);
			this->Name = S"ImportReportForm";
			this->Text = S"ImportReport";
			this->Load += new System::EventHandler(this, ImportReportForm_Load);
			(__try_cast<System::ComponentModel::ISupportInitialize *  >(this->dataSet82))->EndInit();
			this->ResumeLayout(false);

		}		

private: System::Void ImportReportForm_Load(System::Object *  sender, System::EventArgs *  e)
		 {
			 ImportReport* rpt = new ImportReport();
		 }

};
}