河南紫薇销售统计系统

1、河南紫薇销售统计系统c#windowsform前台设计 设计背景：为方便鄢陵百泉花木公司销售管理方便，按需设计河南紫薇销售统计司统。所用软件：visual studio2010，sqlserver2008.司统应用平台：windowsxp、windows7、windows8司统。数据库信息由河南鄢陵百泉花木公司河南紫薇销售中心提供。本系统的后台由中原公司进行分析设计，具体功能模块二由网络信息开发部们研究开发.cs文件代码：using system;using system.collections.generic;using system.componentmodel;using system.

2、data;using system.drawing;using system.linq;using system.text;using system.windows.forms;using system.data.sqlclient;namespace six public partial class ziweis : form public ziweis() initializecomponent(); this.txtxh.focus(); /打洙?开a窗洹?体?显?示?紫§薇?信?息 private void ziweis_load_1(object sender, event

3、args e) sixdb cdb = new sixdb(); this.getinfo(cdb.ziwei(); /查é询显?示? private void getinfo(sqldatareader _reader) try sqldatareader reader = _reader; this.listview1.items.clear(); while (reader.read() string subitems = new string reader.getstring(0),reader.getstring(1).trim(),reader.getstring(2),

4、reader.getstring(3), reader.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 (except

5、ion ex) messagebox.show(ex.tostring(), "一?般?性?错洙?误ó", 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

6、.text, this.txtbj.text); this.txtxh .text = "" this.txtbj.text = "" this.txtxm .text = "" this.txtxh.focus(); /取?消?查é询 private void quxiao_click(object sender, eventargs e) sixdb cdb = new sixdb(); this.getinfo(cdb.ziwei(); /查é询所ù要癮删?除y的?紫薇?信?息 private vo

7、id chaxun(sqldatareader _reader) try sqldatareader reader = _reader; this.listview2.items.clear(); while (reader.read() string subitems = new string reader.getstring(0),reader.getstring(1).trim(),reader.getstring(2),reader.getstring(3), reader.getstring(4), reader.getstring(5), reader.getstring(6) ;

8、 this.listview2.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(), "一?般?性?错洙?误ó", messageboxbutto

9、ns.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.shanxh.text = "" this.shanxm.text = "" this.shanbj.text = "" /删除河南紫薇信息 pr

10、ivate 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.shanbj.text); this.getinfo(del.ziwei();

11、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 se

12、nder, eventargs e) tongji tttt = new tongji(); tttt.show(); this.visible = false; private void button1_click(object sender, eventargs e) this.close(); 鄢陵百泉花木公司紫薇销售统计软件前台设计由新乡画室艺林画室设计。designer.cs文件代码：namespace six partial class ziweis / <summary> / required designer variable. / </summary>

13、 private system.componentmodel.icontainer components = null; / <summary> / clean up any resources being used. / </summary> / <param name="disposing">true if managed resources should be disposed; otherwise, false.</param> protected override void dispose(bool disposin

14、g) if (disposing && (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 in

15、itializecomponent() ponents = new system.componentmodel.container(); system.componentmodel.componentresourcemanager resources = new system.componentmodel.componentresourcemanager(typeof(ziweis); this.ziwei = new system.windows.forms.tabcontrol(); this.ckxsxx = new system.windows.forms.tabpage(); thi

16、s.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.forms.columnheader)(new system.windows.forms.columnheader(); this.

17、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.columnheader)(new system.windows.forms.columnheader(); this.col

18、umnheader13 = (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(); this.quxiao = new system.windows.forms.button(); this.tx

19、tbj = 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.chaxuehao = new system.windows.forms.label(); this.chaxin

20、gming = 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 system.windows.forms.button(); this.listview2

21、= 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 = (system.windows.forms.columnheader)(new syst

22、em.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.windows.forms.columnheader)(new system.win

23、dows.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.textbox(); this.label4 = new system.

24、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(); this.riqi = new system

25、.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.suspendlayout(); this.st

26、atusstrip1.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(

27、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); th

28、is.ckxsxx.controls.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(

29、this.chaxuehao); this.ckxsxx.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

30、 system.drawing.point(4, 22); this.ckxsxx.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;

31、 this.label6.font = new system.drawing.font("宋?体?", 38.25f, system.drawing.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); th

32、is.label6.tabindex = 13; this.label6.text = "查é看紫§薇?信?息" / / listview1 / this.listview1.columns.addrange(new system.windows.forms.columnheader this.columnheader8, this.columnheader9, this.columnheader10, this.columnheader11, this.columnheader12, this.columnheader13, this.columnhe

33、ader14); this.listview1.font = new system.drawing.font("宋?体?", 10.5f, system.drawing.fontstyle.regular, system.drawing.graphicsunit.point, (byte)(134); this.listview1.gridlines = true; this.listview1.location = new system.drawing.point(31, 112); this.listview1.name = "listview1"

34、this.listview1.size = new system.drawing.size(558, 207); this.listview1.tabindex = 12; this.listview1.usecompatiblestateimagebehavior = false; this.listview1.view = system.windows.forms.view.details; / / columnheader8 / this.columnheader8.text = "紫§号?" this.columnheader8.width = 93; /

35、 / columnheader9 / this.columnheader9.text = "姓?名?" this.columnheader9.width = 73; / / columnheader10 / this.columnheader10.text = "性?别纄" this.columnheader10.width = 48; / / columnheader11 / this.columnheader11.text = "联司电?话°" this.columnheader11.width = 74; / / co

36、lumnheader12 / this.columnheader12.text = "客悒?户?" this.columnheader12.width = 94; / / columnheader13 / this.columnheader13.text = "公o司" this.columnheader13.width = 93; / / columnheader14 / this.columnheader14.text = "所ù选?种?程ì" this.columnheader14.width = 106;

37、/ / 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" this.chaxunxinx

38、i.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.fon

39、t("宋?体?", 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.tex

40、t = "取? 消?" this.quxiao.usevisualstylebackcolor = 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.fontsty

41、le.regular, system.drawing.graphicsunit.point, (byte)(134); 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; / / l

42、abel1 / this.label1.autosize = true; this.label1.backcolor = system.drawing.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.controlt

43、ext; this.label1.location = new system.drawing.point(31, 349); this.label1.name = "label1" this.label1.size = new system.drawing.size(229, 16); this.label1.tabindex = 0; this.label1.text = "请?在ú下?面?输?入?您ú要癮查é询的?信?息" / / chabanji / this.chabanji.autosize = true; thi

44、s.chabanji.backcolor = system.drawing.color.transparent; this.chabanji.font = new system.drawing.font("宋?体?", 10.5f, system.drawing.fontstyle.bold, system.drawing.graphicsunit.point, (byte)(134); this.chabanji.forecolor = system.drawing.systemcolors.controltext; this.chabanji.location = ne

45、w system.drawing.point(97, 483); this.chabanji.name = "chabanji" this.chabanji.size = new system.drawing.size(52, 14); this.chabanji.tabindex = 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.foreco