1、河南紫薇销售统计系统C#WindowsForm 前台设计设计背景：为方便鄢陵百泉花木公司销售管理方便，按需设计河南紫薇销售统计司统。所用软件：Visual studio2010，sqlserver2008.司统应用平台：windowsXp、windows7 、windows8 司统。数据库信息由河南鄢陵百泉花木公司河南紫薇销售中心提供。本系统的后台由中原公司进行分析设计，具体功能模块二由网络信息开发部们研究开发.cs 文件代码：using System;using System.Collections.Generic;using System.ComponentModel;using Syst
2、em.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace sixpublic partial class ziweis : Formpublic ziweis()InitializeComponent();this.txtxh.Focus();/打洙?开a窗洹?体?显?示?紫薇?信?息private void ziweis_Load_1(object sender, EventArgs e)si
3、xDB cdb = new sixDB();this.getInfo(cdb.ziwei();/查询显?示?private void getInfo(SqlDataReader _reader)trySqlDataReader reader = _reader;this.listView1.Items.Clear();while (reader.Read()string subItems = new stringreader.GetString(0),reader.GetString(1).Trim(),reader.GetString(2),reader.GetString(3),reade
4、r.GetString(4),reader.GetString(5),reader.GetString(6);this.listView1.Items.Add(new ListViewItem(subItems);reader.Close();catch (SqlException ex)MessageBox.Show(ex.ToString(), “SQL错洙?误“, MessageBoxButtons.OK, MessageBoxIcon.Information);catch (Exception ex)MessageBox.Show(ex.ToString(), “一?般?性?错洙?误“
5、, MessageBoxButtons.OK, MessageBoxIcon.Information);/按恪?紫号?、姓?名?、客悒?户?查询紫薇?信?息private void chaxunxinxi_Click(object sender, EventArgs e)sixDB ser = new sixDB();this.getInfo(ser.chaxun(this.txtxh.Text, this.txtxm.Text, this.txtbj.Text);this.txtxh .Text = “;this.txtbj.Text = “;this.txtxm .Text = “;thi
6、s.txtxh.Focus();/取?消?查询private void quxiao_Click(object sender, EventArgs e)sixDB cdb = new sixDB();this.getInfo(cdb.ziwei();/查询所要癮删?除y的?紫薇?信?息private void chaxun(SqlDataReader _reader)trySqlDataReader reader = _reader;this.listView2.Items.Clear();while (reader.Read()string subItems = new stringread
7、er.GetString(0),reader.GetString(1).Trim(),reader.GetString(2),reader.GetString(3),reader.GetString(4),reader.GetString(5),reader.GetString(6);this.listView2.Items.Add(new ListViewItem(subItems);reader.Close();catch (SqlException ex)MessageBox.Show(ex.ToString(), “SQL错洙?误“, MessageBoxButtons.OK, Mes
8、sageBoxIcon.Information);catch (Exception ex)MessageBox.Show(ex.ToString(), “一?般?性?错洙?误“, MessageBoxButtons.OK, MessageBoxIcon.Information);private void xinxi_Click(object sender, EventArgs e)sixDB ser = new sixDB();this.chaxun(ser.chaxun(this.shanxh.Text, this.shanxm.Text, this.shanbj.Text);this.sh
9、anxh.Text = “;this.shanxm.Text = “;this.shanbj.Text = “;/删除河南紫薇信息private void shanchu_Click(object sender, EventArgs e)if (MessageBox.Show(“您是?否?要癮删?除y选?中D的?信?息！?“, “提? 示?“, MessageBoxButtons.OKCancel) = DialogResult.OK)sixDB del = new sixDB();del.deletestu(this.shanxh.Text, this.shanxm.Text, this.s
10、hanbj.Text);this.getInfo(del.ziwei();this.getInfo(del.ziwei();this.listView2.Items.Clear();private void timer1_Tick(object sender, EventArgs e)riqi.Text = “当獭?前日?期:“ + DateTime.Now.ToShortDateString();shijian.Text = “当獭?前时骸?间?:“ + DateTime.Now.ToLongTimeString();private void st_Click(object sender,
11、EventArgs e)tongji tttt = new tongji();tttt.Show();this.Visible = false;private void button1_Click(object sender, EventArgs e)this.Close();鄢陵百泉花木公司紫薇销售统计软件前台设计由新乡画室艺林画室设计。Designer.cs文件代码：namespace sixpartial class ziweis/ / Required designer variable./ private System.ComponentModel.IContainer compon
12、ents = null;/ / Clean up any resources being used./ / true if managed resources should be disposed; otherwise, false.protected override void Dispose(bool disposing)if (disposing base.Dispose(disposing);#region Windows Form Designer generated code/ / Required method for Designer support - do not modi
13、fy/ the contents of this method with the code editor./ private void InitializeComponent()ponents = new System.ComponentModel.Container();System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ziweis);this.ziwei = new System.Windows.Forms.
14、TabControl();this.ckxsxx = new System.Windows.Forms.TabPage();this.label6 = new System.Windows.Forms.Label();this.listView1 = new System.Windows.Forms.ListView();this.columnHeader8 = (System.Windows.Forms.ColumnHeader)(new System.Windows.Forms.ColumnHeader();this.columnHeader9 = (System.Windows.Form
15、s.ColumnHeader)(new System.Windows.Forms.ColumnHeader();this.columnHeader10 = (System.Windows.Forms.ColumnHeader)(new System.Windows.Forms.ColumnHeader();this.columnHeader11 = (System.Windows.Forms.ColumnHeader)(new System.Windows.Forms.ColumnHeader();this.columnHeader12 = (System.Windows.Forms.Colu
16、mnHeader)(new System.Windows.Forms.ColumnHeader();this.columnHeader13 = (System.Windows.Forms.ColumnHeader)(new System.Windows.Forms.ColumnHeader();this.columnHeader14 = (System.Windows.Forms.ColumnHeader)(new System.Windows.Forms.ColumnHeader();this.chaxunxinxi = new System.Windows.Forms.Button();t
17、his.quxiao = new System.Windows.Forms.Button();this.txtbj = new System.Windows.Forms.TextBox();this.label1 = new System.Windows.Forms.Label();this.chabanji = new System.Windows.Forms.Label();this.txtxh = new System.Windows.Forms.TextBox();this.txtxm = new System.Windows.Forms.TextBox();this.chaxueha
18、o = new System.Windows.Forms.Label();this.chaxingming = new System.Windows.Forms.Label();this.sxsxx = new System.Windows.Forms.TabPage();this.label7 = new System.Windows.Forms.Label();this.label5 = new System.Windows.Forms.Label();this.xinxi = new System.Windows.Forms.Button();this.shanchu = new Sys
19、tem.Windows.Forms.Button();this.listView2 = new System.Windows.Forms.ListView();this.columnHeader1 = (System.Windows.Forms.ColumnHeader)(new System.Windows.Forms.ColumnHeader();this.columnHeader2 = (System.Windows.Forms.ColumnHeader)(new System.Windows.Forms.ColumnHeader();this.columnHeader3 = (Syst
20、em.Windows.Forms.ColumnHeader)(new System.Windows.Forms.ColumnHeader();this.columnHeader4 = (System.Windows.Forms.ColumnHeader)(new System.Windows.Forms.ColumnHeader();this.columnHeader5 = (System.Windows.Forms.ColumnHeader)(new System.Windows.Forms.ColumnHeader();this.columnHeader6 = (System.Window
21、s.Forms.ColumnHeader)(new System.Windows.Forms.ColumnHeader();this.columnHeader7 = (System.Windows.Forms.ColumnHeader)(new System.Windows.Forms.ColumnHeader();this.shanbj = new System.Windows.Forms.TextBox();this.shanxm = new System.Windows.Forms.TextBox();this.shanxh = new System.Windows.Forms.Text
22、Box();this.label4 = new System.Windows.Forms.Label();this.label2 = new System.Windows.Forms.Label();this.label3 = new System.Windows.Forms.Label();this.groupBox1 = new System.Windows.Forms.GroupBox();this.st = new System.Windows.Forms.Button();this.statusStrip1 = new System.Windows.Forms.StatusStrip
23、();this.riqi = new System.Windows.Forms.ToolStripStatusLabel();this.shijian = new System.Windows.Forms.ToolStripStatusLabel();this.button1 = new System.Windows.Forms.Button();this.timer1 = new System.Windows.Forms.Timer(ponents);this.ziwei.SuspendLayout();this.ckxsxx.SuspendLayout();this.sxsxx.Suspe
24、ndLayout();this.statusStrip1.SuspendLayout();this.SuspendLayout();/ / ziwei/ this.ziwei.Controls.Add(this.ckxsxx);this.ziwei.Controls.Add(this.sxsxx);this.ziwei.Location = new System.Drawing.Point(0, -4);this.ziwei.Name = “ziwei“;this.ziwei.SelectedIndex = 0;this.ziwei.Size = new System.Drawing.Size
25、(706, 576);this.ziwei.TabIndex = 0;/ / ckxsxx/ this.ckxsxx.BackColor = System.Drawing.Color.Transparent;this.ckxsxx.BackgroundImage = (System.Drawing.Image)(resources.GetObject(“ckxsxx.BackgroundImage“);this.ckxsxx.Controls.Add(this.label6);this.ckxsxx.Controls.Add(this.listView1);this.ckxsxx.Contro
26、ls.Add(this.chaxunxinxi);this.ckxsxx.Controls.Add(this.quxiao);this.ckxsxx.Controls.Add(this.txtbj);this.ckxsxx.Controls.Add(this.label1);this.ckxsxx.Controls.Add(this.chabanji);this.ckxsxx.Controls.Add(this.txtxh);this.ckxsxx.Controls.Add(this.txtxm);this.ckxsxx.Controls.Add(this.chaxuehao);this.ck
27、xsxx.Controls.Add(this.chaxingming);this.ckxsxx.Font = new System.Drawing.Font(“宋?体?“, 36F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, (byte)(134);this.ckxsxx.ForeColor = System.Drawing.SystemColors.ControlText;this.ckxsxx.Location = new System.Drawing.Point(4, 22);this.ckx
28、sxx.Name = “ckxsxx“;this.ckxsxx.Padding = new System.Windows.Forms.Padding(3);this.ckxsxx.Size = new System.Drawing.Size(698, 553);this.ckxsxx.TabIndex = 1;this.ckxsxx.Text = “查看紫薇?信?息“;/ / label6/ this.label6.AutoSize = true;this.label6.Font = new System.Drawing.Font(“宋?体?“, 38.25F, System.Drawing.
29、FontStyle.Bold, System.Drawing.GraphicsUnit.Point, (byte)(134);this.label6.Location = new System.Drawing.Point(146, 36);this.label6.Name = “label6“;this.label6.Size = new System.Drawing.Size(334, 51);this.label6.TabIndex = 13;this.label6.Text = “查看紫薇?信?息“;/ / listView1/ this.listView1.Columns.AddRan
30、ge(new System.Windows.Forms.ColumnHeader this.columnHeader8,this.columnHeader9,this.columnHeader10,this.columnHeader11,this.columnHeader12,this.columnHeader13,this.columnHeader14);this.listView1.Font = new System.Drawing.Font(“宋?体?“, 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUn
31、it.Point, (byte)(134);this.listView1.GridLines = true;this.listView1.Location = new System.Drawing.Point(31, 112);this.listView1.Name = “listView1“;this.listView1.Size = new System.Drawing.Size(558, 207);this.listView1.TabIndex = 12;this.listView1.UseCompatibleStateImageBehavior = false;this.listVie
32、w1.View = System.Windows.Forms.View.Details;/ / columnHeader8/ this.columnHeader8.Text = “紫号?“;this.columnHeader8.Width = 93;/ / columnHeader9/ this.columnHeader9.Text = “姓?名?“;this.columnHeader9.Width = 73;/ / columnHeader10/ this.columnHeader10.Text = “性?别纄“;this.columnHeader10.Width = 48;/ / colu
33、mnHeader11/ this.columnHeader11.Text = “联 司电?话“;this.columnHeader11.Width = 74;/ / columnHeader12/ this.columnHeader12.Text = “客悒?户?“;this.columnHeader12.Width = 94;/ / columnHeader13/ this.columnHeader13.Text = “公o司“;this.columnHeader13.Width = 93;/ / columnHeader14/ this.columnHeader14.Text = “所选?
34、种?程“;this.columnHeader14.Width = 106;/ / chaxunxinxi/ this.chaxunxinxi.Font = new System.Drawing.Font(“宋?体?“, 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, (byte)(134);this.chaxunxinxi.Location = new System.Drawing.Point(344, 411);this.chaxunxinxi.Name = “chaxunxinxi“;t
35、his.chaxunxinxi.Size = new System.Drawing.Size(75, 23);this.chaxunxinxi.TabIndex = 11;this.chaxunxinxi.Text = “查询信?息“;this.chaxunxinxi.UseVisualStyleBackColor = true;this.chaxunxinxi.Click += new System.EventHandler(this.chaxunxinxi_Click);/ / quxiao/ this.quxiao.Font = new System.Drawing.Font(“宋?体?
36、“, 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, (byte)(134);this.quxiao.Location = new System.Drawing.Point(344, 473);this.quxiao.Name = “quxiao“;this.quxiao.Size = new System.Drawing.Size(75, 23);this.quxiao.TabIndex = 10;this.quxiao.Text = “取? 消?“;this.quxiao.UseVisu
37、alStyleBackColor = true;this.quxiao.Click += new System.EventHandler(this.quxiao_Click);/ / txtbj/ this.txtbj.BackColor = System.Drawing.SystemColors.ActiveCaptionText;this.txtbj.Font = new System.Drawing.Font(“宋?体?“, 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, (byte)(1
38、34);this.txtbj.ForeColor = System.Drawing.SystemColors.ControlText;this.txtbj.Location = new System.Drawing.Point(155, 477);this.txtbj.Name = “txtbj“;this.txtbj.Size = new System.Drawing.Size(160, 26);this.txtbj.TabIndex = 7;/ / label1/ this.label1.AutoSize = true;this.label1.BackColor = System.Draw
39、ing.Color.Transparent;this.label1.Font = new System.Drawing.Font(“宋?体?“, 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, (byte)(134);this.label1.ForeColor = System.Drawing.SystemColors.ControlText;this.label1.Location = new System.Drawing.Point(31, 349);this.label1.Name = “lab
40、el1“;this.label1.Size = new System.Drawing.Size(229, 16);this.label1.TabIndex = 0;this.label1.Text = “请?在下?面?输?入?您要癮查询的?信?息“;/ / chabanji/ this.chabanji.AutoSize = true;this.chabanji.BackColor = System.Drawing.Color.Transparent;this.chabanji.Font = new System.Drawing.Font(“宋?体?“, 10.5F, System.Drawi
41、ng.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, (byte)(134);this.chabanji.ForeColor = System.Drawing.SystemColors.ControlText;this.chabanji.Location = new System.Drawing.Point(97, 483);this.chabanji.Name = “chabanji“;this.chabanji.Size = new System.Drawing.Size(52, 14);this.chabanji.TabIndex =
42、 6;this.chabanji.Text = “客悒?户?：阰“;/ / txtxh/ this.txtxh.BackColor = System.Drawing.SystemColors.ActiveCaptionText;this.txtxh.Font = new System.Drawing.Font(“宋?体?“, 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, (byte)(134);this.txtxh.ForeColor = System.Drawing.SystemColors
43、.ControlText;this.txtxh.Location = new System.Drawing.Point(157, 384);this.txtxh.Name = “txtxh“;this.txtxh.Size = new System.Drawing.Size(158, 26);this.txtxh.TabIndex = 1;/ / txtxm/ this.txtxm.BackColor = System.Drawing.SystemColors.ActiveCaptionText;this.txtxm.Font = new System.Drawing.Font(“宋?体?“,
44、 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, (byte)(134);this.txtxm.ForeColor = System.Drawing.SystemColors.ControlText;this.txtxm.Location = new System.Drawing.Point(155, 428);this.txtxm.Name = “txtxm“;this.txtxm.Size = new System.Drawing.Size(160, 26);this.txtxm.TabIn
45、dex = 4;/ / chaxuehao/ this.chaxuehao.AutoSize = true;this.chaxuehao.BackColor = System.Drawing.Color.Transparent;this.chaxuehao.Font = new System.Drawing.Font(“宋?体?“, 10.5F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, (byte)(134);this.chaxuehao.ForeColor = System.Drawing.Syste
46、mColors.ControlText;this.chaxuehao.Location = new System.Drawing.Point(99, 396);this.chaxuehao.Name = “chaxuehao“;this.chaxuehao.Size = new System.Drawing.Size(52, 14);this.chaxuehao.TabIndex = 0;this.chaxuehao.Text = “紫号?：阰“;/ / chaxingming/ this.chaxingming.AutoSize = true;this.chaxingming.BackCol
47、or = System.Drawing.Color.Transparent;this.chaxingming.Font = new System.Drawing.Font(“宋?体?“, 10.5F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, (byte)(134);this.chaxingming.ForeColor = System.Drawing.SystemColors.ControlText;this.chaxingming.Location = new System.Drawing.Point
48、(93, 440);this.chaxingming.Name = “chaxingming“;this.chaxingming.Size = new System.Drawing.Size(52, 14);this.chaxingming.TabIndex = 3;this.chaxingming.Text = “姓?名?：阰“;/ / sxsxx/ this.sxsxx.BackgroundImage = (System.Drawing.Image)(resources.GetObject(“sxsxx.BackgroundImage“);this.sxsxx.Controls.Add(this.label7);this.sxsxx.Controls.Add(this.label5);this.sxsxx.Controls.Add(this.xinxi);this.sxsxx.Controls.Add(this.shanchu);this.sxsxx.Controls.Add(this.listView2);this.sxsxx.Controls.Add(this.shanbj);this.sxsxx.Controls.Add(this.shanxm);this.sxsxx.Controls.Add(this.shan
