河南紫薇销售统计系统.docx
- 文档编号:29952602
- 上传时间:2023-08-03
- 格式:DOCX
- 页数:32
- 大小:21.60KB
河南紫薇销售统计系统.docx
《河南紫薇销售统计系统.docx》由会员分享,可在线阅读,更多相关《河南紫薇销售统计系统.docx(32页珍藏版)》请在冰豆网上搜索。
河南紫薇销售统计系统
河南紫薇销售统计司统
C#WindowsForm前台设计
设计背景:
为方便鄢陵百泉花木公司销售管理方便,按需设计河南紫薇销售统计司统。
所用软件:
Visualstudio2010,sqlserver2008.
司统应用平台:
windowsXp、windows7、windows8司统。
数据库信息由河南鄢陵百泉花木公司河南紫薇销售中心提供,具体详细信息参考自:
网站。
本系统的后台由中原公司进行分析设计,具体功能模块二由网络信息开发部们研究开发,具体实现由万次火柴网站负责技术人员负责设计实现。
.cs文件代码:
usingSystem;
usingSystem.Collections.Generic;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Linq;
usingSystem.Text;
usingSystem.Windows.Forms;
usingSystem.Data.SqlClient;
namespacesix
{
publicpartialclassziweis:
Form
{
publicziweis()
{
InitializeComponent();
this.txtxh.Focus();
}
//打洙?
开a窗洹?
体?
显?
示?
紫§薇Θ?
信?
息¢
privatevoidziweis_Load_1(objectsender,EventArgse)
{
sixDBcdb=newsixDB();
this.getInfo(cdb.ziwei());
}
//查é询ˉ显?
示?
privatevoidgetInfo(SqlDataReader_reader)
{
try
{
SqlDataReaderreader=_reader;
this.listView1.Items.Clear();
while(reader.Read())
{
string[]subItems=newstring[]
{
reader.GetString(0),
reader.GetString
(1).Trim(),
reader.GetString
(2),
reader.GetString(3),
reader.GetString(4),
reader.GetString(5),
reader.GetString(6)
};
this.listView1.Items.Add(newListViewItem(subItems));
}
reader.Close();
}
catch(SqlExceptionex)
{
MessageBox.Show(ex.ToString(),"SQL错洙?
误ó",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
catch(Exceptionex)
{
MessageBox.Show(ex.ToString(),"一?
般?
性?
错洙?
误ó",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
}
//按恪?
紫§号?
、¢姓?
名?
、¢客悒?
户?
查é询ˉ紫§薇Θ?
信?
息¢
privatevoidchaxunxinxi_Click(objectsender,EventArgse)
{
sixDBser=newsixDB();
this.getInfo(ser.chaxun(this.txtxh.Text,this.txtxm.Text,this.txtbj.Text));
this.txtxh.Text="";
this.txtbj.Text="";
this.txtxm.Text="";
this.txtxh.Focus();
}
//取?
消?
查é询ˉ
privatevoidquxiao_Click(objectsender,EventArgse)
{
sixDBcdb=newsixDB();
this.getInfo(cdb.ziwei());
}
//查é询ˉ所ù要癮删?
除y的?
紫薇?
信?
息¢
privatevoidchaxun(SqlDataReader_reader)
{
try
{
SqlDataReaderreader=_reader;
this.listView2.Items.Clear();
while(reader.Read())
{
string[]subItems=newstring[]
{
reader.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(newListViewItem(subItems));
}
reader.Close();
}
catch(SqlExceptionex)
{
MessageBox.Show(ex.ToString(),"SQL错洙?
误ó",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
catch(Exceptionex)
{
MessageBox.Show(ex.ToString(),"一?
般?
性?
错洙?
误ó",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
}
privatevoidxinxi_Click(objectsender,EventArgse)
{
sixDBser=newsixDB();
this.chaxun(ser.chaxun(this.shanxh.Text,this.shanxm.Text,this.shanbj.Text));
this.shanxh.Text="";
this.shanxm.Text="";
this.shanbj.Text="";
}
//删除河南紫薇信息
privatevoidshanchu_Click(objectsender,EventArgse)
{
if(MessageBox.Show("您ú是?
否?
要癮删?
除y选?
中D的?
信?
息¢!
?
","提?
示?
",MessageBoxButtons.OKCancel)==DialogResult.OK)
{
sixDBdel=newsixDB();
del.deletestu(this.shanxh.Text,this.shanxm.Text,this.shanbj.Text);
this.getInfo(del.ziwei());
this.getInfo(del.ziwei());
this.listView2.Items.Clear();
}
}
privatevoidtimer1_Tick(objectsender,EventArgse)
{
riqi.Text="当獭?
前°日?
期ú:
"+DateTime.Now.ToShortDateString();
shijian.Text="当獭?
前°时骸?
间?
:
"+DateTime.Now.ToLongTimeString();
}
privatevoidst_Click(objectsender,EventArgse)
{
tongjitttt=newtongji();
tttt.Show();
this.Visible=false;
}
privatevoidbutton1_Click(objectsender,EventArgse)
{
this.Close();
}
}
}
鄢陵百泉花木公司紫薇销售统计软件前台设计由新乡画室艺林画室设计。
Designer.cs文件代码:
namespacesix
{
partialclassziweis
{
///
///Requireddesignervariable.
///
privateSystem.ComponentModel.IContainercomponents=null;
///
///Cleanupanyresourcesbeingused.
///
///
protectedoverridevoidDispose(booldisposing)
{
if(disposing&&(components!
=null))
{
components.Dispose();
}
base.Dispose(disposing);
}
#regionWindowsFormDesignergeneratedcode
///
///RequiredmethodforDesignersupport-donotmodify
///thecontentsofthismethodwiththecodeeditor.
///
privatevoidInitializeComponent()
{
ponents=newSystem.ComponentModel.Container();
System.ComponentModel.ComponentResourceManagerresources=newSystem.ComponentModel.ComponentResourceManager(typeof(ziweis));
this.ziwei=newSystem.Windows.Forms.TabControl();
this.ckxsxx=newSystem.Windows.Forms.TabPage();
this.label6=newSystem.Windows.Forms.Label();
this.listView1=newSystem.Windows.Forms.ListView();
this.columnHeader8=((System.Windows.Forms.ColumnHeader)(newSystem.Windows.Forms.ColumnHeader()));
this.columnHeader9=((System.Windows.Forms.ColumnHeader)(newSystem.Windows.Forms.ColumnHeader()));
this.columnHeader10=((System.Windows.Forms.ColumnHeader)(newSystem.Windows.Forms.ColumnHeader()));
this.columnHeader11=((System.Windows.Forms.ColumnHeader)(newSystem.Windows.Forms.ColumnHeader()));
this.columnHeader12=((System.Windows.Forms.ColumnHeader)(newSystem.Windows.Forms.ColumnHeader()));
this.columnHeader13=((System.Windows.Forms.ColumnHeader)(newSystem.Windows.Forms.ColumnHeader()));
this.columnHeader14=((System.Windows.Forms.ColumnHeader)(newSystem.Windows.Forms.ColumnHeader()));
this.chaxunxinxi=newSystem.Windows.Forms.Button();
this.quxiao=newSystem.Windows.Forms.Button();
this.txtbj=newSystem.Windows.Forms.TextBox();
this.label1=newSystem.Windows.Forms.Label();
this.chabanji=newSystem.Windows.Forms.Label();
this.txtxh=newSystem.Windows.Forms.TextBox();
this.txtxm=newSystem.Windows.Forms.TextBox();
this.chaxuehao=newSystem.Windows.Forms.Label();
this.chaxingming=newSystem.Windows.Forms.Label();
this.sxsxx=newSystem.Windows.Forms.TabPage();
this.label7=newSystem.Windows.Forms.Label();
this.label5=newSystem.Windows.Forms.Label();
this.xinxi=newSystem.Windows.Forms.Button();
this.shanchu=newSystem.Windows.Forms.Button();
this.listView2=newSystem.Windows.Forms.ListView();
this.columnHeader1=((System.Windows.Forms.ColumnHeader)(newSystem.Windows.Forms.ColumnHeader()));
this.columnHeader2=((System.Windows.Forms.ColumnHeader)(newSystem.Windows.Forms.ColumnHeader()));
this.columnHeader3=((System.Windows.Forms.ColumnHeader)(newSystem.Windows.Forms.ColumnHeader()));
this.columnHeader4=((System.Windows.Forms.ColumnHeader)(newSystem.Windows.Forms.ColumnHeader()));
this.columnHeader5=((System.Windows.Forms.ColumnHeader)(newSystem.Windows.Forms.ColumnHeader()));
this.columnHeader6=((System.Windows.Forms.ColumnHeader)(newSystem.Windows.Forms.ColumnHeader()));
this.columnHeader7=((System.Windows.Forms.ColumnHeader)(newSystem.Windows.Forms.ColumnHeader()));
this.shanbj=newSystem.Windows.Forms.TextBox();
this.shanxm=newSystem.Windows.Forms.TextBox();
this.shanxh=newSystem.Windows.Forms.TextBox();
this.label4=newSystem.Windows.Forms.Label();
this.label2=newSystem.Windows.Forms.Label();
this.label3=newSystem.Windows.Forms.Label();
this.groupBox1=newSystem.Windows.Forms.GroupBox();
this.st=newSystem.Windows.Forms.Button();
this.statusStrip1=newSystem.Windows.Forms.StatusStrip();
this.riqi=newSystem.Windows.Forms.ToolStripStatusLabel();
this.shijian=newSystem.Windows.Forms.ToolStripStatusLabel();
this.button1=newSystem.Windows.Forms.Button();
this.timer1=newSystem.Windows.Forms.Timer(ponents);
this.ziwei.SuspendLayout();
this.ckxsxx.SuspendLayout();
this.sxsxx.SuspendLayout();
this.statusStrip1.SuspendLayout();
this.SuspendLayout();
//
//ziwei
//
this.ziwei.Controls.Add(this.ckxsxx);
this.ziwei.Controls.Add(this.sxsxx);
this.ziwei.Location=newSystem.Drawing.Point(0,-4);
this.ziwei.Name="ziwei";
this.ziwei.SelectedIndex=0;
this.ziwei.Size=newSystem.Drawing.Size(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.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(this.chaxuehao);
this.ckxsxx.Controls.Add(this.chaxingming);
this.ckxsxx.Font=newSystem.Drawing.Font("宋?
体?
",36F,System.Drawing.FontStyle.Regular,System.Drawing.GraphicsUnit.Point,((byte)(134)));
this.ckxsxx.ForeColor=System.Drawing.SystemColors.ControlText;
this.ckxsxx.Location=newSystem.Drawing.Point(4,22);
this.ckxsxx.Name="ckxsxx";
this.ckxsxx.Padding=newSystem.Windows.Forms.Padding(3);
this.ckxsxx.Size=newSystem.Drawing.Size(698,553);
this.ckxsxx.TabIndex=1;
this.ckxsxx.Text="查é看′紫§薇Θ?
信?
息¢";
//
//label6
//
this.label6.AutoSize=true;
this.label6.Font=newSystem.Drawing.Font("宋?
体?
",38.25F,System.Drawing.FontStyle.Bold,System.Drawing.GraphicsUnit.Point,((byte)(134)));
this.label6.Location=newSystem.Drawing.Point(146,36);
this.label6.Name="label6";
this.label6.Size=newSystem.Drawing.Size(334,51);
this.label6.TabIndex=13;
this.label6.Text="查é看′紫§薇Θ?
信?
息¢";
//
//listView1
//
this.list
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 河南 紫薇 销售 统计 系统