frmorderdetails.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;

namespace Example_2
{
	/// <summary>
	/// Summary description for Form1.
	/// </summary>
	public class frmOrderDetails : System.Windows.Forms.Form
	{
		private System.Windows.Forms.TreeView tvwOrdersData;
		private System.Windows.Forms.Button btnExit;
		private System.Windows.Forms.ListView lvwOrdersData;
		private System.Windows.Forms.Label lblOrderID;
		private System.Windows.Forms.Label lblDetails;

		/// <summary>
		/// Required designer variable.
		/// </summary>
		private System.ComponentModel.Container components = null;

		//Variable Declaration
		private SqlConnection objSqlConnection;
		private SqlDataAdapter objSqlDataAdapter;
		private DataSet objDataSet;
		private DataSet objOrderIDDataSet;

		
			
		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()
		{
			this.tvwOrdersData = new System.Windows.Forms.TreeView();
			this.lvwOrdersData = new System.Windows.Forms.ListView();
			this.btnExit = new System.Windows.Forms.Button();
			this.lblOrderID = new System.Windows.Forms.Label();
			this.lblDetails = new System.Windows.Forms.Label();
			this.SuspendLayout();
			// 
			// tvwOrdersData
			// 
			this.tvwOrdersData.ImageIndex = -1;
			this.tvwOrdersData.Location = new System.Drawing.Point(8, 24);
			this.tvwOrdersData.Name = "tvwOrdersData";
			this.tvwOrdersData.SelectedImageIndex = -1;
			this.tvwOrdersData.Size = new System.Drawing.Size(120, 256);
			this.tvwOrdersData.TabIndex = 0;
			this.tvwOrdersData.AfterSelect += new System.Windows.Forms.TreeViewEventHandler(this.tvwOrdersData_AfterSelect);
			// 
			// lvwOrdersData
			// 
			this.lvwOrdersData.Location = new System.Drawing.Point(128, 24);
			this.lvwOrdersData.Name = "lvwOrdersData";
			this.lvwOrdersData.Size = new System.Drawing.Size(416, 256);
			this.lvwOrdersData.TabIndex = 1;
			// 
			// btnExit
			// 
			this.btnExit.Location = new System.Drawing.Point(472, 288);
			this.btnExit.Name = "btnExit";
			this.btnExit.TabIndex = 2;
			this.btnExit.Text = "退出(&X)";
			this.btnExit.Click += new System.EventHandler(this.btnExit_Click);
			// 
			// lblOrderID
			// 
			this.lblOrderID.Location = new System.Drawing.Point(8, 8);
			this.lblOrderID.Name = "lblOrderID";
			this.lblOrderID.Size = new System.Drawing.Size(100, 16);
			this.lblOrderID.TabIndex = 3;
			this.lblOrderID.Text = "订单编号：";
			// 
			// lblDetails
			// 
			this.lblDetails.Location = new System.Drawing.Point(128, 8);
			this.lblDetails.Name = "lblDetails";
			this.lblDetails.Size = new System.Drawing.Size(100, 16);
			this.lblDetails.TabIndex = 3;
			this.lblDetails.Text = "详细信息：";
			// 
			// frmOrderDetails
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(5, 14);
			this.ClientSize = new System.Drawing.Size(552, 317);
			this.Controls.Add(this.lblOrderID);
			this.Controls.Add(this.btnExit);
			this.Controls.Add(this.lvwOrdersData);
			this.Controls.Add(this.tvwOrdersData);
			this.Controls.Add(this.lblDetails);
			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.frmOrders_Load);
			this.ResumeLayout(false);

		}
		#endregion

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

		private void frmOrders_Load(object sender, System.EventArgs e)
		{
			
			this.lvwOrdersData.Columns.Add ( "订单明细编号" ,100, HorizontalAlignment.Right ) ;
			this.lvwOrdersData.Columns.Add ( "订单编号" , 80 , HorizontalAlignment.Right ) ;
			this.lvwOrdersData.Columns.Add ( "产品编号" , 80 , HorizontalAlignment.Right ) ;
			this.lvwOrdersData.Columns.Add ( "数量" , 40 , HorizontalAlignment.Right ) ;
			this.lvwOrdersData.Columns.Add ( "单价" , 40 , HorizontalAlignment.Right ) ;
			this.lvwOrdersData.Columns.Add ( "总价" , 40 , HorizontalAlignment.Right ) ;
			this.lvwOrdersData.View=View.Details;
			
	
			objSqlConnection = new SqlConnection("SERVER = (local); database = Inventory; uid = sa; password =");
			try
			{
				//实例化一个新的DataSet
				objDataSet = new DataSet();
				objOrderIDDataSet = new DataSet();
				//打开连接
				objSqlConnection.Open();
				 
				objSqlDataAdapter = new SqlDataAdapter("Select * from OrderDetails",objSqlConnection);
				
				objSqlDataAdapter.Fill(objDataSet,"OrderDetails");
				
				objSqlDataAdapter = new SqlDataAdapter("select distinct OrderID from OrderDetails",objSqlConnection);
				objSqlDataAdapter.Fill(objOrderIDDataSet,"OrderDetails");
			}
			catch(SqlException ex)
			{
				MessageBox.Show(ex.Message);
			}
			catch(Exception ex)
			{
				MessageBox.Show(ex.Message);
			}

			
			TreeNode objNodeParent;
			foreach (DataRow objDataRow in objOrderIDDataSet.Tables[0].Rows)
			{
				// Add the category node.
				objNodeParent = tvwOrdersData.Nodes.Add(objDataRow["OrderId"].ToString());
								
				// Store the disconnected category information.
				objNodeParent.Tag = objDataRow;
			}

		}
		private void btnExit_Click(object sender, System.EventArgs e)
		{
			this.Close();
		}

		private void tvwOrdersData_AfterSelect(object sender, System.Windows.Forms.TreeViewEventArgs e)
		{
			this.lvwOrdersData.Items.Clear();
		string varOrderID = e.Node.Text;
	
			foreach(DataRow objDataRow in objDataSet.Tables[0].Rows)
			{
				if(varOrderID == objDataRow["OrderID"].ToString())
				{
					ListViewItem lstItem = new ListViewItem ( ) ; 
					lstItem.SubItems.Clear ( ) ; 
					lstItem.SubItems[0].Text = objDataRow["OrderDetailsID"].ToString() ; //第0列
					lstItem.SubItems.Add(objDataRow["OrderID"].ToString());
					lstItem.SubItems.Add ( objDataRow["ProductID"].ToString() ) ; //第1列
					lstItem.SubItems.Add( objDataRow["Quantity"].ToString());
					lstItem.SubItems.Add(objDataRow["UnitPrice"].ToString());
					lstItem.SubItems.Add (  objDataRow["Total"].ToString()) ; //第n列
					lvwOrdersData.Items.Add(lstItem);				
					

					
				}
			}
		}
	}
}