using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using CrystalDecisions.CrystalReports.Engine;

namespace 進銷存管理系統
{
	/// <summary>
	/// CrystalReport 的摘要說明。
	/// </summary>
	public class CrystalReport : System.Windows.Forms.Form
	{
		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 進銷存管理系統.DataSet2 dataSet21;
		/// <summary>
		/// 必需的設計器變量。
		/// </summary>
		private System.ComponentModel.Container components = null;

		public CrystalReport()
		{
			//
			// Windows 窗體設計器支持所必需的
			//
			InitializeComponent();

			//
			// TODO: 在 InitializeComponent 調用后添加任何構造函數代碼
			//
		}

		/// <summary>
		/// 清理所有正在使用的資源。
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if( disposing )
			{
				if(components != null)
				{
					components.Dispose();
				}
			}
			base.Dispose( disposing );
		}

		#region Windows 窗體設計器生成的代碼
		/// <summary>
		/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
		/// 此方法的內容。
		/// </summary>
		private void InitializeComponent()
		{
			System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(CrystalReport));
			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.dataSet21 = new 進銷存管理系統.DataSet2();
			((System.ComponentModel.ISupportInitialize)(this.dataSet21)).BeginInit();
			this.SuspendLayout();
			// 
			// crystalReportViewer1
			// 
			this.crystalReportViewer1.ActiveViewIndex = -1;
			this.crystalReportViewer1.DisplayGroupTree = false;
			this.crystalReportViewer1.Dock = System.Windows.Forms.DockStyle.Fill;
			this.crystalReportViewer1.Location = new System.Drawing.Point(0, 0);
			this.crystalReportViewer1.Name = "crystalReportViewer1";
			this.crystalReportViewer1.ReportSource = null;
			this.crystalReportViewer1.Size = new System.Drawing.Size(736, 397);
			this.crystalReportViewer1.TabIndex = 0;
			// 
			// sqlDataAdapter1
			// 
			this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
			this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																									  new System.Data.Common.DataTableMapping("Table", "進貨單", new System.Data.Common.DataColumnMapping[] {
																																																			 new System.Data.Common.DataColumnMapping("供貨商號", "供貨商號"),
																																																			 new System.Data.Common.DataColumnMapping("貨號", "貨號"),
																																																			 new System.Data.Common.DataColumnMapping("進貨日期", "進貨日期"),
																																																			 new System.Data.Common.DataColumnMapping("業務員", "業務員"),
																																																			 new System.Data.Common.DataColumnMapping("制單人", "制單人"),
																																																			 new System.Data.Common.DataColumnMapping("進貨數量", "進貨數量"),
																																																			 new System.Data.Common.DataColumnMapping("進價", "進價"),
																																																			 new System.Data.Common.DataColumnMapping("稅價合計", "稅價合計"),
																																																			 new System.Data.Common.DataColumnMapping("稅率", "稅率"),
																																																			 new System.Data.Common.DataColumnMapping("不含稅價", "不含稅價"),
																																																			 new System.Data.Common.DataColumnMapping("稅額", "稅額"),
																																																			 new System.Data.Common.DataColumnMapping("名稱", "名稱"),
																																																			 new System.Data.Common.DataColumnMapping("品名", "品名"),
																																																			 new System.Data.Common.DataColumnMapping("倉庫", "倉庫"),
																																																			 new System.Data.Common.DataColumnMapping("單位", "單位")})});
			// 
			// sqlSelectCommand1
			// 
			this.sqlSelectCommand1.CommandText = "SELECT a.供貨商號, b.貨號, a.進貨日期, a.業務員, a.制單人, b.進貨數量, b.進價, b.稅價合計, b.稅率, b.不含稅價, b." +
				"稅額, c.名稱, d.品名, b.倉庫, d.單位 FROM 進貨單 a INNER JOIN 進貨單明細 b ON a.編號 = b.進貨單號 INNER " +
				"JOIN 供貨商清單 c ON a.供貨商號 = c.供貨商號 INNER JOIN 商品清單 d ON b.貨號 = d.貨號";
			this.sqlSelectCommand1.Connection = this.sqlConnection1;
			// 
			// sqlConnection1
			// 
			this.sqlConnection1.ConnectionString = "workstation id=localhost;Integrated Security=SSPI;Database=jxcbook;";
			// 
			// dataSet21
			// 
			this.dataSet21.DataSetName = "DataSet2";
			this.dataSet21.Locale = new System.Globalization.CultureInfo("zh-CN");
			// 
			// CrystalReport
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(736, 397);
			this.Controls.Add(this.crystalReportViewer1);
			this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
			this.Name = "CrystalReport";
			this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
			this.Text = "進貨單報表";
			this.Load += new System.EventHandler(this.CrystalReport_Load);
			((System.ComponentModel.ISupportInitialize)(this.dataSet21)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

		private void CrystalReport_Load(object sender, System.EventArgs e)
		{
			sqlDataAdapter1.Fill(this.dataSet21);
			CrystalReport1 rpt=new CrystalReport1();
			rpt.SetDataSource(this.dataSet21.Tables[0]);
			crystalReportViewer1.ReportSource=rpt;			
		}
		
		    
	}
}