frmorderdetailsdata.cs

Winform_OnlineTraning 我们培训机构的在线培训部分

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
using System.Drawing.Printing;

namespace Example_1
{
	/// <summary>
	/// Summary description for Form1.
	/// </summary>
	public class frmOrderDetails : System.Windows.Forms.Form
	{
		private System.Windows.Forms.DataGrid dbgOrderDetailsData;
		/// <summary>
		/// Required designer variable.
		/// </summary>
		private System.ComponentModel.Container components = null;

		//User Defined variables

		private SqlConnection objSqlConnection;
		private SqlCommand objSqlCommand;
		private SqlDataAdapter objSqlDataAdapter;
		private System.Windows.Forms.Button btnPrint;
		private System.Windows.Forms.Button btnPrintPreview;
		private System.Windows.Forms.Button btnExit;
		private System.Windows.Forms.PrintPreviewDialog ppdlgPrintPreviewDialog;
		private System.Drawing.Printing.PrintDocument pdocPrintDocument;
		private System.Windows.Forms.PrintDialog pdlgPrintDialog;
		private DataSet objDataSet;

		public frmOrderDetails()
		{
			//
			// Required for Windows Form Designer support
			//
			InitializeComponent();

			//
			// TODO: Add any constructor code after InitializeComponent call
			//
		}

		/// <summary>
		/// Clean up any resources being used.
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if( disposing )
			{
				if (components != null) 
				{
					components.Dispose();
				}
			}
			base.Dispose( disposing );
		}

		#region Windows Form Designer generated code
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{
			System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(frmOrderDetails));
			this.dbgOrderDetailsData = new System.Windows.Forms.DataGrid();
			this.btnPrint = new System.Windows.Forms.Button();
			this.btnPrintPreview = new System.Windows.Forms.Button();
			this.btnExit = new System.Windows.Forms.Button();
			this.ppdlgPrintPreviewDialog = new System.Windows.Forms.PrintPreviewDialog();
			this.pdocPrintDocument = new System.Drawing.Printing.PrintDocument();
			this.pdlgPrintDialog = new System.Windows.Forms.PrintDialog();
			((System.ComponentModel.ISupportInitialize)(this.dbgOrderDetailsData)).BeginInit();
			this.SuspendLayout();
			// 
			// dbgOrderDetailsData
			// 
			this.dbgOrderDetailsData.DataMember = "";
			this.dbgOrderDetailsData.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dbgOrderDetailsData.Location = new System.Drawing.Point(16, 8);
			this.dbgOrderDetailsData.Name = "dbgOrderDetailsData";
			this.dbgOrderDetailsData.Size = new System.Drawing.Size(408, 240);
			this.dbgOrderDetailsData.TabIndex = 0;
			// 
			// btnPrint
			// 
			this.btnPrint.Location = new System.Drawing.Point(176, 256);
			this.btnPrint.Name = "btnPrint";
			this.btnPrint.TabIndex = 1;
			this.btnPrint.Text = "打印(&P)";
			this.btnPrint.Click += new System.EventHandler(this.btnPrint_Click);
			// 
			// btnPrintPreview
			// 
			this.btnPrintPreview.Location = new System.Drawing.Point(264, 256);
			this.btnPrintPreview.Name = "btnPrintPreview";
			this.btnPrintPreview.Size = new System.Drawing.Size(80, 23);
			this.btnPrintPreview.TabIndex = 2;
			this.btnPrintPreview.Text = "打印预览(&R)";
			this.btnPrintPreview.Click += new System.EventHandler(this.btnPrintPreview_Click);
			// 
			// btnExit
			// 
			this.btnExit.Location = new System.Drawing.Point(352, 256);
			this.btnExit.Name = "btnExit";
			this.btnExit.Size = new System.Drawing.Size(72, 23);
			this.btnExit.TabIndex = 2;
			this.btnExit.Text = "退出(&X)";
			this.btnExit.Click += new System.EventHandler(this.btnExit_Click);
			// 
			// ppdlgPrintPreviewDialog
			// 
			this.ppdlgPrintPreviewDialog.AutoScrollMargin = new System.Drawing.Size(0, 0);
			this.ppdlgPrintPreviewDialog.AutoScrollMinSize = new System.Drawing.Size(0, 0);
			this.ppdlgPrintPreviewDialog.ClientSize = new System.Drawing.Size(400, 300);
			this.ppdlgPrintPreviewDialog.Document = this.pdocPrintDocument;
			this.ppdlgPrintPreviewDialog.Enabled = true;
			this.ppdlgPrintPreviewDialog.Icon = ((System.Drawing.Icon)(resources.GetObject("ppdlgPrintPreviewDialog.Icon")));
			this.ppdlgPrintPreviewDialog.Location = new System.Drawing.Point(17, 17);
			this.ppdlgPrintPreviewDialog.MinimumSize = new System.Drawing.Size(375, 250);
			this.ppdlgPrintPreviewDialog.Name = "ppdlgPrintPreviewDialog";
			this.ppdlgPrintPreviewDialog.TransparencyKey = System.Drawing.Color.Empty;
			this.ppdlgPrintPreviewDialog.Visible = false;
			// 
			// pdocPrintDocument
			// 
			this.pdocPrintDocument.PrintPage += new System.Drawing.Printing.PrintPageEventHandler(this.pdocPrintDocument_PrintPage);
			// 
			// pdlgPrintDialog
			// 
			this.pdlgPrintDialog.Document = this.pdocPrintDocument;
			// 
			// frmOrderDetails
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(5, 14);
			this.ClientSize = new System.Drawing.Size(440, 301);
			this.Controls.Add(this.btnPrintPreview);
			this.Controls.Add(this.btnPrint);
			this.Controls.Add(this.dbgOrderDetailsData);
			this.Controls.Add(this.btnExit);
			this.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
			this.Name = "frmOrderDetails";
			this.Text = "订单细目数据";
			this.Load += new System.EventHandler(this.frmOrderDetails_Load);
			((System.ComponentModel.ISupportInitialize)(this.dbgOrderDetailsData)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

		/// <summary>
		/// The main entry point for the application.
		/// </summary>
		[STAThread]
		static void Main() 
		{
			Application.Run(new frmOrderDetails());
		}

		private void frmOrderDetails_Load(object sender, System.EventArgs e)
		{
			try
			{
				objSqlConnection = new SqlConnection("Server = (local); database = Inventory; uid = sa; password=;");
				objSqlConnection.Open();
				objSqlCommand = new SqlCommand("Select * from OrderDetails",objSqlConnection);
				objSqlDataAdapter = new SqlDataAdapter(objSqlCommand);
				
				objDataSet = new DataSet();

				objSqlDataAdapter.Fill(objDataSet,"OrderDetails");
				this.dbgOrderDetailsData.DataSource = objDataSet.Tables[0];
			}
			catch(SqlException ex)
			{
				MessageBox.Show(ex.Message);
			}
		}
		private void btnExit_Click(object sender, System.EventArgs e)
		{
			this.Close();
		}

		private void btnPrint_Click(object sender, System.EventArgs e)
		{
			try
			{
				if (pdlgPrintDialog.ShowDialog() == DialogResult.OK)
				{
					pdocPrintDocument.Print();
				}
			}
			catch(Exception ex)
			{
				MessageBox.Show("打印时出错" +ex.Message.ToString());
			}
		}

		private void pdocPrintDocument_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
		{
			try
			{
				//Create a DataTable and Store the Data grid values in it
				DataTable objDataTable = (DataTable)this.dbgOrderDetailsData.DataSource; 

				//Setting the X and Y locations
				int startX = 100;
				int startY = 100;
				
				//Displaying the Headings
				e.Graphics.DrawString("订单细目编号",new Font("Arial",9),Brushes.Black,100,80);
				e.Graphics.DrawString("订单编号",new Font("Arial",9),Brushes.Black,200,80);
				e.Graphics.DrawString("产品编号",new Font("Arial",9),Brushes.Black,300,80);
				e.Graphics.DrawString("数量",new Font("Arial",9),Brushes.Black,400,80);
				e.Graphics.DrawString("单价",new Font("Arial",9),Brushes.Black,500,80);
				e.Graphics.DrawString("总计",new Font("Arial",9),Brushes.Black,600,80);


				//Iterating through the rows
				for(int row = 0 ; row < objDataTable.Rows.Count; row++)
				{
					//Storing the rows to objDataRow object
					DataRow objDataRow = objDataTable.Rows[row];
					
					//Iterating through the Columns
					for(int i = 0; i < objDataTable.Columns.Count;i++)
					{
						//Displaying the Values
						e.Graphics.DrawString(objDataRow[i].ToString(),new Font("Arial",11),Brushes.Black,startX,startY);
						startX += 100;
					}
					startX = 100;
					startY += 20;
					
				}
				
			}
		
			catch(Exception excep)
			{
				MessageBox.Show("打印时出错。" +excep.Message.ToString());
			}
		}

		private void btnPrintPreview_Click(object sender, System.EventArgs e)
		{
			try
			{
				if (ppdlgPrintPreviewDialog.ShowDialog() == DialogResult.OK)
				{
					pdocPrintDocument.Print();
				}
			}
			catch(Exception ex)
			{
				MessageBox.Show("打印时出错" +ex.Message.ToString());
			}
		}
	}
}