searchfrm.cs

本代码设计了一个销售管理系统

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
using System.Xml;
using System.IO;
using UserData;

namespace LtsClient
{
	/// <summary>
	/// searchFrm 的摘要说明。
	/// </summary>
	public class searchFrm : System.Windows.Forms.Form
	{
		private System.Windows.Forms.Button cancelbtn;
		private System.Windows.Forms.Button inputbtn;
		private System.Windows.Forms.TextBox info;
		private System.Windows.Forms.Label label15;
		private System.Windows.Forms.TextBox publish;
		private System.Windows.Forms.Label label13;
		private System.Windows.Forms.TextBox author;
		private System.Windows.Forms.Label label14;
		private System.Windows.Forms.TextBox hire_price;
		private System.Windows.Forms.Label label12;
		private System.Windows.Forms.TextBox member_price;
		private System.Windows.Forms.Label label11;
		private System.Windows.Forms.TextBox goods_price;
		private System.Windows.Forms.Label label10;
		private System.Windows.Forms.TextBox order_time;
		private System.Windows.Forms.Label label9;
		private System.Windows.Forms.TextBox order_price;
		private System.Windows.Forms.Label label7;
		private System.Windows.Forms.TextBox order_num;
		private System.Windows.Forms.Label label6;
		private System.Windows.Forms.TextBox bar_code;
		private System.Windows.Forms.Label label5;
		private System.Windows.Forms.TextBox g_code;
		private System.Windows.Forms.Label label4;
		private System.Windows.Forms.TextBox g_name;
		private System.Windows.Forms.Label label3;
		private System.Windows.Forms.Label label2;
		private System.Windows.Forms.TextBox department;
		private System.Windows.Forms.ComboBox g_type;
		private System.Windows.Forms.Label label1;
		private System.Windows.Forms.TextBox order_from;
		private System.Windows.Forms.Label label8;
		private System.Windows.Forms.Button searchbtn;
		private System.Windows.Forms.DataGrid dataGrid1;
		private System.Windows.Forms.Button button1;
		private System.Windows.Forms.Label label16;
		private System.Windows.Forms.ComboBox goods_type;
		private System.Windows.Forms.Label label17;
		private System.Windows.Forms.Button addbtn;
		private System.Windows.Forms.Button turnback;
		private System.Windows.Forms.Button turnin;
		private System.Windows.Forms.TextBox addnumstr;
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;

		public searchFrm()
		{
			//
			// Windows 窗体设计器支持所必需的
			//
			InitializeComponent();
			FPara.CheckLogin();
			//
			// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
			//
		}

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

		#region Windows Form Designer generated code
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			this.cancelbtn = new System.Windows.Forms.Button();
			this.inputbtn = new System.Windows.Forms.Button();
			this.info = new System.Windows.Forms.TextBox();
			this.label15 = new System.Windows.Forms.Label();
			this.publish = new System.Windows.Forms.TextBox();
			this.label13 = new System.Windows.Forms.Label();
			this.author = new System.Windows.Forms.TextBox();
			this.label14 = new System.Windows.Forms.Label();
			this.hire_price = new System.Windows.Forms.TextBox();
			this.label12 = new System.Windows.Forms.Label();
			this.member_price = new System.Windows.Forms.TextBox();
			this.label11 = new System.Windows.Forms.Label();
			this.goods_price = new System.Windows.Forms.TextBox();
			this.label10 = new System.Windows.Forms.Label();
			this.order_time = new System.Windows.Forms.TextBox();
			this.label9 = new System.Windows.Forms.Label();
			this.order_price = new System.Windows.Forms.TextBox();
			this.label7 = new System.Windows.Forms.Label();
			this.order_num = new System.Windows.Forms.TextBox();
			this.label6 = new System.Windows.Forms.Label();
			this.bar_code = new System.Windows.Forms.TextBox();
			this.label5 = new System.Windows.Forms.Label();
			this.g_code = new System.Windows.Forms.TextBox();
			this.label4 = new System.Windows.Forms.Label();
			this.g_name = new System.Windows.Forms.TextBox();
			this.label3 = new System.Windows.Forms.Label();
			this.label2 = new System.Windows.Forms.Label();
			this.department = new System.Windows.Forms.TextBox();
			this.g_type = new System.Windows.Forms.ComboBox();
			this.label1 = new System.Windows.Forms.Label();
			this.order_from = new System.Windows.Forms.TextBox();
			this.label8 = new System.Windows.Forms.Label();
			this.searchbtn = new System.Windows.Forms.Button();
			this.dataGrid1 = new System.Windows.Forms.DataGrid();
			this.button1 = new System.Windows.Forms.Button();
			this.goods_type = new System.Windows.Forms.ComboBox();
			this.label16 = new System.Windows.Forms.Label();
			this.addnumstr = new System.Windows.Forms.TextBox();
			this.label17 = new System.Windows.Forms.Label();
			this.addbtn = new System.Windows.Forms.Button();
			this.turnback = new System.Windows.Forms.Button();
			this.turnin = new System.Windows.Forms.Button();
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
			this.SuspendLayout();
			// 
			// cancelbtn
			// 
			this.cancelbtn.Location = new System.Drawing.Point(456, 353);
			this.cancelbtn.Name = "cancelbtn";
			this.cancelbtn.Size = new System.Drawing.Size(122, 25);
			this.cancelbtn.TabIndex = 62;
			this.cancelbtn.Text = "关闭";
			this.cancelbtn.Click += new System.EventHandler(this.cancelbtn_Click);
			// 
			// inputbtn
			// 
			this.inputbtn.Location = new System.Drawing.Point(88, 353);
			this.inputbtn.Name = "inputbtn";
			this.inputbtn.Size = new System.Drawing.Size(82, 25);
			this.inputbtn.TabIndex = 61;
			this.inputbtn.Text = "修改";
			this.inputbtn.Click += new System.EventHandler(this.inputbtn_Click);
			// 
			// info
			// 
			this.info.Location = new System.Drawing.Point(88, 302);
			this.info.Multiline = true;
			this.info.Name = "info";
			this.info.Size = new System.Drawing.Size(357, 51);
			this.info.TabIndex = 60;
			this.info.Text = "";
			// 
			// label15
			// 
			this.label15.Location = new System.Drawing.Point(19, 310);
			this.label15.Name = "label15";
			this.label15.Size = new System.Drawing.Size(79, 17);
			this.label15.TabIndex = 59;
			this.label15.Text = "其它信息";
			// 
			// publish
			// 
			this.publish.Location = new System.Drawing.Point(88, 276);
			this.publish.Name = "publish";
			this.publish.Size = new System.Drawing.Size(376, 21);
			this.publish.TabIndex = 58;
			this.publish.Text = "";
			// 
			// label13
			// 
			this.label13.Location = new System.Drawing.Point(19, 284);
			this.label13.Name = "label13";
			this.label13.Size = new System.Drawing.Size(79, 18);
			this.label13.TabIndex = 57;
			this.label13.Text = "出版/发行";
			// 
			// author
			// 
			this.author.Location = new System.Drawing.Point(88, 250);
			this.author.Name = "author";
			this.author.Size = new System.Drawing.Size(374, 21);
			this.author.TabIndex = 56;
			this.author.Text = "";
			// 
			// label14
			// 
			this.label14.Location = new System.Drawing.Point(19, 258);
			this.label14.Name = "label14";
			this.label14.Size = new System.Drawing.Size(71, 18);
			this.label14.TabIndex = 55;
			this.label14.Text = "歌手/演员";
			// 
			// hire_price
			// 
			this.hire_price.Location = new System.Drawing.Point(535, 224);
			this.hire_price.Name = "hire_price";
			this.hire_price.Size = new System.Drawing.Size(43, 21);
			this.hire_price.TabIndex = 54;
			this.hire_price.Text = "";
			// 
			// label12
			// 
			this.label12.Location = new System.Drawing.Point(499, 233);
			this.label12.Name = "label12";
			this.label12.Size = new System.Drawing.Size(36, 17);
			this.label12.TabIndex = 53;
			this.label12.Text = "押金";
			// 
			// member_price
			// 
			this.member_price.Location = new System.Drawing.Point(421, 224);
			this.member_price.Name = "member_price";
			this.member_price.Size = new System.Drawing.Size(78, 21);
			this.member_price.TabIndex = 52;
			this.member_price.Text = "";
			// 
			// label11
			// 
			this.label11.Location = new System.Drawing.Point(342, 233);
			this.label11.Name = "label11";
			this.label11.Size = new System.Drawing.Size(79, 17);
			this.label11.TabIndex = 51;
			this.label11.Text = "会员租/售价";
			// 
			// goods_price
			// 
			this.goods_price.Location = new System.Drawing.Point(281, 224);
			this.goods_price.Name = "goods_price";
			this.goods_price.Size = new System.Drawing.Size(61, 21);
			this.goods_price.TabIndex = 50;
			this.goods_price.Text = "";
			// 
			// label10
			// 
			this.label10.Location = new System.Drawing.Point(228, 233);
			this.label10.Name = "label10";
			this.label10.Size = new System.Drawing.Size(53, 17);
			this.label10.TabIndex = 49;
			this.label10.Text = "租/售价";
			// 
			// order_time
			// 
			this.order_time.Location = new System.Drawing.Point(395, 34);
			this.order_time.Name = "order_time";
			this.order_time.Size = new System.Drawing.Size(96, 21);
			this.order_time.TabIndex = 48;
			this.order_time.Text = "";
			// 
			// label9
			// 
			this.label9.Location = new System.Drawing.Point(334, 43);
			this.label9.Name = "label9";
			this.label9.Size = new System.Drawing.Size(69, 17);
			this.label9.TabIndex = 47;
			this.label9.Text = "进货时间";
			// 
			// order_price
			// 
			this.order_price.Location = new System.Drawing.Point(167, 224);
			this.order_price.Name = "order_price";
			this.order_price.Size = new System.Drawing.Size(53, 21);
			this.order_price.TabIndex = 45;
			this.order_price.Text = "";
			// 
			// label7
			// 
			this.label7.Location = new System.Drawing.Point(132, 233);
			this.label7.Name = "label7";
			this.label7.Size = new System.Drawing.Size(35, 17);
			this.label7.TabIndex = 43;
			this.label7.Text = "进价";
			// 
			// order_num
			// 
			this.order_num.Location = new System.Drawing.Point(61, 224);
			this.order_num.Name = "order_num";
			this.order_num.ReadOnly = true;
			this.order_num.Size = new System.Drawing.Size(71, 21);
			this.order_num.TabIndex = 42;
			this.order_num.Text = "";
			// 
			// label6
			// 
			this.label6.Location = new System.Drawing.Point(18, 233);
			this.label6.Name = "label6";
			this.label6.Size = new System.Drawing.Size(52, 17);
			this.label6.TabIndex = 41;
			this.label6.Text = "总数量";
			// 
			// bar_code
			// 
			this.bar_code.Location = new System.Drawing.Point(281, 9);
			this.bar_code.Name = "bar_code";
			this.bar_code.Size = new System.Drawing.Size(131, 21);
			this.bar_code.TabIndex = 40;
			this.bar_code.Text = "";
			// 
			// label5
			// 
			this.label5.Location = new System.Drawing.Point(246, 17);
			this.label5.Name = "label5";
			this.label5.Size = new System.Drawing.Size(35, 17);
			this.label5.TabIndex = 39;
			this.label5.Text = "条码";
			// 
			// g_code
			// 
			this.g_code.Location = new System.Drawing.Point(210, 34);
			this.g_code.Name = "g_code";
			this.g_code.Size = new System.Drawing.Size(114, 21);
			this.g_code.TabIndex = 38;
			this.g_code.Text = "";
			// 
			// label4
			// 
			this.label4.Location = new System.Drawing.Point(175, 43);
			this.label4.Name = "label4";
			this.label4.Size = new System.Drawing.Size(35, 17);
			this.label4.TabIndex = 37;
			this.label4.Text = "代号";
			// 
			// g_name
			// 
			this.g_name.Location = new System.Drawing.Point(53, 34);
			this.g_name.Name = "g_name";
			this.g_name.Size = new System.Drawing.Size(114, 21);
			this.g_name.TabIndex = 36;
			this.g_name.Text = "";
			// 
			// label3
			// 
			this.label3.Location = new System.Drawing.Point(18, 43);
			this.label3.Name = "label3";
			this.label3.Size = new System.Drawing.Size(35, 17);
			this.label3.TabIndex = 35;
			this.label3.Text = "名称";
			// 
			// label2
			// 
			this.label2.Location = new System.Drawing.Point(132, 17);
			this.label2.Name = "label2";
			this.label2.Size = new System.Drawing.Size(35, 17);
			this.label2.TabIndex = 34;
			this.label2.Text = "店号";
			// 
			// department
			// 
			this.department.Location = new System.Drawing.Point(167, 9);
			this.department.Name = "department";
			this.department.Size = new System.Drawing.Size(69, 21);
			this.department.TabIndex = 33;
			this.department.Text = "";
			// 
			// g_type
			// 
			this.g_type.Items.AddRange(new object[] {