《基于CS结构的开发技术》课程设计报告书V1.0

东莞理工学院城市学院《方向课课程设计1》——基于C/S结构的开发技术课程设计题目：小型超市管理系统专业：软件工程年级：2009级 1 班小组成员：蔡泽辉（组长）、缪志发、蓝柳明指导教师：张永财老师时间：2012.6.11 —2012 .6.15地点：实验楼616东莞理工学院城市学院计算机与信息科学系制2012年6 月目录1．开发环境与开发工具 (3)2．系统需求分析 (3)2.1实体信息 (3)2.2实体联系信息 (5)3．功能要求分析 (6)4．系统设计 (6)4.1系统功能模块设计，如有类图等UML分析则更好 (6)4.2数据库概念结构设计（如有数据库则需增加以下部分） (7)4.3 数据库逻辑结构设计 (9)5．数据库初始数据的加载（如有数据库则填写以下内容） (20)5.1供应商表记录插入 (21)5.2客户表记录插入 (21)5.3部门表记录插入 (22)5.4仓库表记录插入 (22)5.5商品计量单位表记录插入 (23)5.6权限表记录插入 (24)5.7用户表记录插入 (24)5.8商品进货表记录插入 (25)5.9库存表记录插入 (25)5.10销售表记录插入 (25)5.11临时库存表记录插入 (26)5.12退货表记录插入 (26)5.13职位表记录插入 (27)6．系统实现 (27)6.1商品进货 (27)6.2商品销售 (32)6.3销售查询 (37)6.4库存调拨 (39)6.5基本信息查询 (43)7．设计心得 (46)8．参考文献 (47)1．开发环境与开发工具系统开发平台：Microsoft Visual Studio 2008系统开发语言：C#数据库管理系统软件：SQL Server2005运行平台:Windows XP（SP2）/Windows 2000（SP4）/Windows Server 2003(SP1) 运行环境: Framework SDK v2.02．系统需求分析小型超市系统管理是企业日常经营管理中十分重要的一个组成部分，传统的手工管理方式呈现出越来越多的弊端。

在手工管理模式下，统计、汇总处理时的工作量极其繁重，处理效率非常低。

通过小型超市管理系统，企业可以减少人工干预，提高企业竞争能力。

2.1实体信息User用户实体Goods商品实体Depot仓库实体Goods进货记录实体Sell销售记录实体Customer客户实体Company供应商实体2.2实体联系信息1：n之间的联系3．功能要求分析1，收银（售货）管理。

根据输入的商品编号和数量计算并显示顾客的应付金额，记录每一次售货信息，并动态更新库存信息。

2，进货管理。

记录每一次进货的信息，能按月、年统计某种商品的进货量，进货信息包括：商品名称、进价、数量、来源、进货人等。

3，库存商品管理。

能按照商品编号或者商品名称查询商品价格、生产厂商等商品信息；可以把各种商品进行分类，例如电器类、食品类等；可以对要上架的商品进行标价。

4，销售情况统计。

能按天、月、年统计各种（精确到每一种）商品的销售情况，包括商品名称、数量、总金额等。

5，厂商信息查询。

能按商品的记录查询有关厂商的各信息，包括厂商名、联系人、电话等。

6，人员权限管理实现用户管理和不同用户、角色的登录功能。

4．系统设计4.1系统功能模块设计，如有类图等UML分析则更好小型超市管理系统功能结构如图4-1所示。

4.2数据库概念结构设计（如有数据库则需增加以下部分）(主要包括整体E-R图)4.3 数据库逻辑结构设计4.3.1 数据库关系模式供应商（公司ID，公司名称，公司主管，电话，传真，公司地址，备注）客户（客户ID，客户姓名，性别，生日，移动电话，家庭电话，住址，备注）部门（部门ID，部门名称，部门描述，部门职责）仓库（仓库ID，仓库分类）进货（商品ID，操作员ID，公司名称，仓库名称，商品名称，商品数量，商品计量单位，进货时间，商品规格，进货价格，销售价格，应付金额，实付金额，备注）权限分配（权限ID，系统用户分类，系统用户姓名，员工信息，供应商信息，客户信息，采购进货信息，采购退货信息，商品销售信息，客户退货信息，库存调拨信息，库存警报信息，权限设置信息，修改密码信息）职位（职位ID，职位名称，职位描述）退货（退货商品ID，库存ID，商品ID，操作员ID，客户ID，公司ID，仓库名称，商品名称，商品规格，退货时间，退货数量，商品计量单位，退货价格，应付金额，已退款金额，退货原因，退货类型）销售（销售ID，库存ID，商品ID，操作员ID，商品名称，销售数量，商品规格，销售时间，商品计量单位，进货单价，销售单价，应收金额，实收金额，备注）库存（库存ID，商品ID，公司名称，仓库名称，商品名称，库存数量，报警数量，商品计量单位，进货时间，商品规格，进货单价，销售单价，应付金额，实付金额，备注）临时库存（临时库存ID，库存ID，操作员ID，商品ID，商品名称，调出仓库名称，调入仓库名称，商品调动时间，库存数量，调动数量）计量单位（单位ID，单位名称）用户（操作员ID，姓名，系统登录名称，密码，性别，生日，部门，职位，移动电话，家庭电话，住址，权限ID）4.3.2 数据库及表结构的创建SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id =OBJECT_ID(N'[dbo].[tb_Company]') AND type in (N'U'))BEGIN创建公司表tb_CompanyCREATE TABLE [dbo].[tb_Company]([CompanyID] [int] IDENTITY(1,1) NOT NULL,[CompanyName] [nvarchar](100) NULL,[CompanyDirector] [nvarchar](20) NULL,[CompanyPhone] [nvarchar](20) NULL,[CompanyFax] [nvarchar](20) NULL,[CompanyAddress] [nvarchar](200) NULL,[CompanyRemark] [nvarchar](400) NULL,CONSTRAINT [PK_tb_Company] PRIMARY KEY CLUSTERED([CompanyID] ASC)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]ENDGOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_Post]') AND type in (N'U'))BEGIN创建职位表tb_PostCREATE TABLE [dbo].[tb_Post]([PostID] [int] IDENTITY(1,1) NOT NULL,[PostName] [nvarchar](20) NULL,[PostDescription] [nvarchar](200) NULL,CONSTRAINT [PK_tb_Post] PRIMARY KEY CLUSTERED([PostID] ASC)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]ENDGOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_Popedom]') AND type in (N'U'))BEGIN创建权限表tb_PopedomCREATE TABLE [dbo].[tb_Popedom]([PopedomID] [int] IDENTITY(1,1) NOT NULL,[SysUserSort] [nvarchar](20) NULL,[SysUserName] [nvarchar](20) NULL,[EmployeeInfo] [bit] NULL,[CompanyInfo] [bit] NULL,[CustomerInfo] [bit] NULL,[GoodsInInfo] [bit] NULL,[GoodsOutInfo] [bit] NULL,[SellGoodsInfo] [bit] NULL,[ReGoodsInfo] [bit] NULL,[StockChangeInfo] [bit] NULL,[StockAlarmInfo] [bit] NULL,[SysUser] [bit] NULL,[PopedomInfo] [bit] NULL,[BakDataInfo] [bit] NULL,[ReBakDataInfo] [bit] NULL,CONSTRAINT [PK_tb_Popedom] PRIMARY KEY CLUSTERED([PopedomID] ASC)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]ENDGOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_User]') AND type in (N'U'))BEGIN创建用户表tb_UserCREATE TABLE [dbo].[tb_User]([UserID] [int] IDENTITY(1,1) NOT NULL,[Name] [nvarchar](20) NULL,[SysLoginName] [nvarchar](20) NULL,[Pwd] [nvarchar](100) NULL,[Sex] [nvarchar](20) NULL,[Birthday] [datetime] NULL,[Department] [nvarchar](20) NULL,[Post] [nvarchar](20) NULL,[PhoneH] [nvarchar](20) NULL,[PhoneM] [nvarchar](20) NULL,[Address] [nvarchar](200) NULL,[PopedomID] [int] NULL,CONSTRAINT [PK_tb_User] PRIMARY KEY CLUSTERED([UserID] ASC)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]ENDGOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_Unit]') AND type in (N'U'))BEGIN创建单位表tb_UnitCREATE TABLE [dbo].[tb_Unit]([UnitID] [int] IDENTITY(1,1) NOT NULL,[UnitName] [nvarchar](10) NULL,CONSTRAINT [PK_tb_Unit] PRIMARY KEY CLUSTERED([UnitID] ASC)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]ENDGOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_StockTemp]') AND type in (N'U'))BEGIN创建仓库调拨表tb_StockTempCREATE TABLE [dbo].[tb_StockTemp]([StockTempID] [nvarchar](20) NOT NULL,[StockID] [int] NULL,[UserID] [int] NULL,[GoodsID] [nvarchar](20) NULL,[GoodsName] [nvarchar](50) NULL,[FDepotName] [nvarchar](20) NULL,[LDepotName] [nvarchar](20) NULL,[CGoodsTime] [datetime] NULL,[StockNum] [int] NULL,[CGoodsNum] [int] NULL,CONSTRAINT [PK_tb_Stock] PRIMARY KEY CLUSTERED([StockTempID] ASC)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]ENDGOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_Stock]') AND type in (N'U'))BEGIN创建库存表tb_StockCREATE TABLE [dbo].[tb_Stock]([StockID] [int] IDENTITY(1,1) NOT NULL,[GoodsID] [nvarchar](20) NULL,[CompanyName] [nvarchar](100) NULL,[DepotName] [nvarchar](20) NULL,[GoodsName] [nvarchar](20) NULL,[StockNum] [int] NULL,[AlarmNum] [int] NULL CONSTRAINT [DF_tb_Stock_AlarmNum] DEFAULT ((10)), [GoodsUnit] [nvarchar](20) NULL,[GoodsTime] [datetime] NULL,[GoodsSpec] [nvarchar](20) NULL,[GoodsPrice] [money] NULL,[SellPrice] [money] NULL,[NeedPay] [money] NULL,[HasPay] [money] NULL,[Remark] [nvarchar](200) NULL,CONSTRAINT [PK_tb_Stock_1] PRIMARY KEY CLUSTERED([StockID] ASC)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]ENDGOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_Sell]') AND type in (N'U'))BEGIN创建销售表tb_SellCREATE TABLE [dbo].[tb_Sell]([SellID] [nvarchar](20) NOT NULL,[StockID] [int] NULL,[GoodsID] [nvarchar](20) NULL,[UserID] [int] NULL,[GoodsName] [nvarchar](50) NULL,[GoodsNum] [int] NULL,[GoodsSpec] [nvarchar](20) NULL,[GoodsTime] [datetime] NULL,[GoodsUnit] [nvarchar](20) NULL,[GoodsPrice] [money] NULL,[SellPrice] [money] NULL,[NeedPay] [money] NULL,[HasPay] [money] NULL,[Remark] [nvarchar](200) NULL,CONSTRAINT [PK_tb_Sell] PRIMARY KEY CLUSTERED([SellID] ASC)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]ENDGOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_ReGoods]') AND type in (N'U'))BEGIN创建退货表tb_ReGoodsCREATE TABLE [dbo].[tb_ReGoods]([ReGoodsID] [nvarchar](20) NOT NULL,[StockID] [int] NULL,[GoodsID] [nvarchar](20) NULL,[UserID] [int] NULL,[CustomerID] [int] NULL,[CompanyName] [nvarchar](100) NULL,[DepotName] [nvarchar](20) NULL,[ReGoodsName] [nvarchar](20) NULL,[ReGoodsSpec] [nvarchar](20) NULL,[ReGoodsTime] [datetime] NULL,[ReGoodsNum] [int] NULL,[ReGoodsUnit] [nvarchar](20) NULL,[ReGoodsPrice] [money] NULL,[NeedPay] [money] NULL,[HasPay] [money] NULL,[ReGoodsResult] [nvarchar](400) NULL,[ReGoodsSort] [int] NULL,CONSTRAINT [PK_tb_ReGoods] PRIMARY KEY CLUSTERED([ReGoodsID] ASC)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]ENDGOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_Goods]') AND type in (N'U'))BEGIN创建商品表tb_GoodsCREATE TABLE [dbo].[tb_Goods]([GoodsID] [nvarchar](20) NOT NULL,[UserID] [int] NULL,[CompanyName] [nvarchar](100) NULL,[DepotName] [nvarchar](20) NULL,[GoodsName] [nvarchar](50) NULL,[GoodsNum] [int] NULL,[GoodsUnit] [nvarchar](20) NULL,[GoodsTime] [datetime] NULL,[GoodsSpec] [nvarchar](20) NULL,[GoodsPrice] [money] NULL,[SellPrice] [money] NULL,[NeedPay] [money] NULL,[HasPay] [money] NULL,[Remark] [nvarchar](200) NULL,CONSTRAINT [PK_tb_Goods] PRIMARY KEY CLUSTERED([GoodsID] ASC)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]ENDGOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_Depot]') AND type in (N'U'))BEGIN创建仓库分类表tb_DepotCREATE TABLE [dbo].[tb_Depot]([DepotID] [int] IDENTITY(1,1) NOT NULL,[DepotSort] [nvarchar](20) NULL,CONSTRAINT [PK_tb_Depot] PRIMARY KEY CLUSTERED([DepotID] ASC)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]ENDGOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_Department]') AND type in (N'U'))BEGIN创建部门表tb_DepartmentCREATE TABLE [dbo].[tb_Department]([DepartmentID] [int] IDENTITY(1,1) NOT NULL,[DepName] [nvarchar](20) NULL,[DepDescription] [nvarchar](200) NULL,[DepPrincipal] [nvarchar](20) NULL,CONSTRAINT [PK_tb_Department] PRIMARY KEY CLUSTERED([DepartmentID] ASC)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]ENDGOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_Customer]') AND type in (N'U'))BEGIN创建顾客信息表tb_CustomerCREATE TABLE [dbo].[tb_Customer]([CustomerID] [int] IDENTITY(1,1) NOT NULL,[Name] [nvarchar](20) NULL,[Sex] [nvarchar](4) NULL,[Birthday] [datetime] NULL,[PhoneH] [nvarchar](20) NULL,[PhoneM] [nvarchar](20) NULL,[Address] [nvarchar](200) NULL,[Remark] [nvarchar](200) NULL,CONSTRAINT [PK_tb_Customer] PRIMARY KEY CLUSTERED([CustomerID] ASC)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]ENDGOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_UserView]'))创建v_UserView视图EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[v_UserView]ASSELECT dbo.tb_User.*, dbo.tb_Popedom.SysUserSort, dbo.tb_Popedom.SysUserName,dbo.tb_Popedom.EmployeeInfo, dbo.tb_Popedom.CustomerInfo,dbo.tb_panyInfo, dbo.tb_Popedom.GoodsInInfo,dbo.tb_Popedom.GoodsOutInfo, dbo.tb_Popedom.SellGoodsInfo,dbo.tb_Popedom.ReGoodsInfo, dbo.tb_Popedom.StockChangeInfo,dbo.tb_Popedom.StockAlarmInfo, dbo.tb_Popedom.SysUser,dbo.tb_Popedom.PopedomInfo, dbo.tb_Popedom.BakDataInfo,dbo.tb_Popedom.ReBakDataInfoFROM dbo.tb_User INNER JOINdbo.tb_Popedom ON dbo.tb_User.PopedomID = dbo.tb_Popedom.PopedomID 'GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_UserSell]'))创建v_UserSell视图EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[v_UserSell]ASSELECT dbo.tb_, dbo.tb_User.Sex, dbo.tb_User.Department,dbo.tb_User.Birthday, dbo.tb_User.Post, dbo.tb_User.PhoneH, dbo.tb_User.PhoneM,dbo.tb_User.Address, dbo.tb_Sell.*FROM dbo.tb_Sell INNER JOINdbo.tb_User ON dbo.tb_erID = dbo.tb_erID'GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_GoodsIn]'))创建v_GoodsIn视图EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[v_GoodsIn]ASSELECT dbo.tb_Goods.*, dbo.tb_, dbo.tb_User.Sex, dbo.tb_User.Department,dbo.tb_User.PostFROM dbo.tb_User INNER JOINdbo.tb_Goods ON dbo.tb_erID = dbo.tb_erID'GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_ReGoods]'))创建v_ReGoods视图EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[v_ReGoods]ASSELECT dbo.tb_, dbo.tb_Customer.Sex, dbo.tb_Customer.Birthday, dbo.tb_Customer.PhoneH, dbo.tb_Customer.Address, dbo.tb_Customer.Remark,dbo.tb_ReGoods.ReGoodsID, dbo.tb_ReGoods.GoodsID, dbo.tb_erID,dbo.tb_ReGoods.CustomerID, dbo.tb_panyName,dbo.tb_ReGoods.DepotName, dbo.tb_ReGoods.ReGoodsName,dbo.tb_ReGoods.ReGoodsSpec, dbo.tb_ReGoods.ReGoodsTime,dbo.tb_ReGoods.ReGoodsNum, dbo.tb_ReGoods.ReGoodsUnit,dbo.tb_ReGoods.ReGoodsPrice, dbo.tb_ReGoods.NeedPay,dbo.tb_ReGoods.HasPay, dbo.tb_ReGoods.ReGoodsResult,dbo.tb_ReGoods.ReGoodsSortFROM dbo.tb_ReGoods INNER JOINdbo.tb_Customer ON dbo.tb_ReGoods.CustomerID = dbo.tb_Customer.CustomerID'4.3.3 数据库表关系图5．数据库初始数据的加载（如有数据库则填写以下内容）5.1供应商表记录插入5.2客户表记录插入5.3部门表记录插入5.4仓库表记录插入5.5商品计量单位表记录插入5.6权限表记录插入5.7用户表记录插入5.8商品进货表记录插入5.9库存表记录插入5.10销售表记录插入5.11临时库存表记录插入5.12退货表记录插入5.13职位表记录插入6．系统实现6.1商品进货关键代码：private void GoodsIn_Load(object sender, EventArgs e){string cmdtxt = "SELECT GoodsID as 商品ID,GoodsName as 商品名称,GoodsTime as 进货日期,CompanyName as 供应商名称";cmdtxt += ",GoodsNum as 进货数量,GoodsUnit as 商品单位,GoodsPrice as 商品进价,DepotName as 所属仓库,GoodsSpec as 商品规格";cmdtxt += ",SellPrice as 销售价格,NeedPay as 应付金额,HasPay as 实付金额,Remark as 备注FROM tb_Goods";this.dgvGoodsInfo.DataSource = G_SqlClass.GetDs(cmdtxt).Tables[0];G_OperationForm.BindComboBox("SELECT * FROM tb_Company", cbxCompanyName, "CompanyName"); //绑定ComboBox控件G_OperationForm.BindComboBox("SELECT * FROM tb_Unit", cbxUnit, "UnitName");G_OperationForm.BindComboBox("SELECT * FROM tb_Depot", cbxDepot, "DepotSort"); G_OperationForm.BindComboBox("SELECT * FROM tb_User",cbxEmployeeName, "Name"); }private void toolSave_Click(object sender, EventArgs e){string P_Str_condition, P_Str_cmdtxt;switch (G_Int_status){case 1:if (this.cbxEmployeeName.SelectedValue.ToString() != ""){string P_Str_Id = String.Empty;//检索数据库中对应客户的IDstring P_Str_cmdtxt2 = "SELECT UserID,Name FROM tb_User WHERE Name='" + this.cbxEmployeeName.SelectedValue.ToString() + "'";SqlDataReader P_dr = G_SqlClass.GetReader(P_Str_cmdtxt2);P_dr.Read();if (P_dr.HasRows){P_Str_Id = P_dr["UserID"].ToString();}P_dr.Close();//下面是要执行的SQL语句P_Str_cmdtxt = "INSERT INTOtb_Goods(GoodsID,UserID,CompanyName,DepotName,GoodsName,GoodsNum,GoodsUnit,GoodsTime,GoodsSp ec,GoodsPrice,SellPrice";P_Str_cmdtxt += ",Remark,NeedPay,HasPay) VALUES('" +bGoodsID.Text + "','" + P_Str_Id + "'";P_Str_cmdtxt += ",'" + this.cbxCompanyName.SelectedValue.ToString() + "','" + this.cbxDepot.SelectedValue.ToString() + "'";P_Str_cmdtxt += ",'"+ this.txtGoodsName.Text + "','"+ this.txtNum.Text + "','" + this.cbxUnit.SelectedValue.ToString() + "'";P_Str_cmdtxt += ",'" + this.dtBirthday.Value.ToString("yyyy-MM-dd") + "','" + this.txtSpec.Text + "'," + this.txtGoodsInPrice.Text + "";P_Str_cmdtxt += "," + this.txtSellPrice.Text + ",'" +this.txtRemark.Text + "'";P_Str_cmdtxt += "," + this.txtNeedPay.Text + "," + this.txtHasPay.Text + ")";if (this.txtGoodsName.Text == ""){MessageBox.Show("商品名称不能为空！", "提示对话框", MessageBoxButtons.OK, rmation);return;}if (this.txtNum.Text == ""){MessageBox.Show("商品数量不能为空！", "提示对话框", MessageBoxButtons.OK, rmation);return;}if (this.txtGoodsInPrice.Text == ""){MessageBox.Show("商品进价不能为空！", "提示对话框", MessageBoxButtons.OK, rmation);return;}if (this.txtSellPrice.Text == ""){MessageBox.Show("销售价格不能为空！", "提示对话框", MessageBoxButtons.OK, rmation);return;}if (!G_OperationForm.IsNumeric(this.txtNum.Text)&& !G_OperationForm.IsNumeric(this.txtGoodsInPrice.Text)&& !G_OperationForm.IsNumeric(this.txtHasPay.Text)&& !G_OperationForm.IsNumeric(this.txtSellPrice.Text)){MessageBox.Show("您输入的数据格式有误！", "提示对话框", MessageBoxButtons.OK, rmation);}else{//执行SQL语句并返回执行结果if (G_SqlClass.GetExecute(P_Str_cmdtxt)){MessageBox.Show("数据添加成功！");ControlStatus();}else{MessageBox.Show("数据添加失败！");}}}else{MessageBox.Show("请选择销售员姓名！", "提示对话框", MessageBoxButtons.OK, rmation);}break;case 2:if (this.cbxEmployeeName.SelectedValue.ToString() != ""){string P_Str_Id = String.Empty;//检索数据库中对应客户的IDstring P_Str_cmdtxt2 = "SELECT UserID,Name FROM tb_User WHERE Name='" + this.cbxEmployeeName.SelectedValue.ToString() + "'";SqlDataReader P_dr = G_SqlClass.GetReader(P_Str_cmdtxt2);P_dr.Read();if (P_dr.HasRows){P_Str_Id = P_dr["UserID"].ToString();}P_dr.Close();P_Str_condition = this.dgvGoodsInfo[0,this.dgvGoodsInfo.CurrentCell.RowIndex].Value.ToString();P_Str_cmdtxt = "UPDATE tb_Goods SET GoodsName='" +this.txtGoodsName.Text + "',CompanyName='" + this.cbxCompanyName.SelectedValue.ToString() + "'";P_Str_cmdtxt += ",DepotName='"+ this.cbxDepot.SelectedValue.ToString() + "',GoodsNum='" + this.txtNum.Text + "'";P_Str_cmdtxt += ",GoodsUnit='"+ this.cbxUnit.SelectedValue.ToString() + "',GoodsTime='" + this.dtBirthday.Value + "'";P_Str_cmdtxt += ",GoodsSpec='" + this.txtSpec.Text +"',UserID='"+P_Str_Id+"',GoodsPrice=" + this.txtGoodsInPrice.Text + "";P_Str_cmdtxt += ",SellPrice=" + this.txtSellPrice.Text + ",Remark='"+ this.txtRemark.Text + "'";P_Str_cmdtxt += ",NeedPay=" + this.txtNeedPay.Text + ",HasPay=" + this.txtHasPay.Text + " WHERE GoodsID='" + P_Str_condition + "'";if (G_SqlClass.GetExecute(P_Str_cmdtxt)){MessageBox.Show("数据修改成功！");ControlStatus();}else{MessageBox.Show("数据修改失败！");}}else{MessageBox.Show("请选择销售员姓名！", "提示对话框", MessageBoxButtons.OK, rmation);}break;default:break;}//绑定数据显示控件string cmdtxt = "SELECT GoodsID as 商品ID,GoodsName as 商品名称,GoodsTime as 进货日期,CompanyName as 供应商名称";cmdtxt += ",GoodsNum as 进货数量,GoodsUnit as 商品单位,GoodsPrice as 商品进价,DepotName as 所属仓库,GoodsSpec as 商品规格";cmdtxt += ",SellPrice as 销售价格,NeedPay as 应付金额,HasPay as 实付金额,Remark as 备注FROM tb_Goods";this.dgvGoodsInfo.DataSource = G_SqlClass.GetDs(cmdtxt).Tables[0];}结果截图：进货之前进货之后6.2商品销售关键代码：private void SellGoods_Load(object sender, EventArgs e){this.timer1.Start();string P_Str_cmdtxt = "SELECT SellID as 销售ID,GoodsID as 商品ID,[Name] as 销售员姓名,GoodsName as 商品名称";P_Str_cmdtxt +=",GoodsNum as 销售数量,GoodsUnit as 商品单位,GoodsSpec as 商品规格,GoodsTime as 销售时间";P_Str_cmdtxt += ",GoodsPrice 进货价格,SellPrice as 销售价格,NeedPay as 应收金额,HasPay as 实收金额,Remark as 备注";P_Str_cmdtxt += " FROM v_UserSell";this.dgvSellInfo.DataSource = G_SqlClass.GetDs(P_Str_cmdtxt).Tables[0];G_OperationClass.BindComboBox("SELECT * FROM tb_Customer", cbxCustomerName, "Name");G_OperationClass.BindComboBox("SELECT * FROM tb_Unit", cbxUnit, "UnitName");G_OperationClass.BindComboBox("SELECT * FROM tb_User",cbxSellName,"Name");}private void btnFindGoods_Click(object sender, EventArgs e){StockFind stockfind = new StockFind();stockfind.StartPosition = FormStartPosition.CenterScreen;stockfind.ShowDialog();}private void toolSave_Click(object sender, EventArgs e){string P_Str_condition, P_Str_cmdtxt;switch (G_Int_status){case 1:if (this.cbxSellName.SelectedValue.ToString() != ""){if (this.txtGoodsName.Text == ""){MessageBox.Show("商品名称不能为空！", "提示对话框", MessageBoxButtons.OK, rmation);return;}if (this.txtNum.Text == ""){MessageBox.Show("商品数量不能为空！", "提示对话框", MessageBoxButtons.OK, rmation);return;}if (this.txtGoodsInPrice.Text == ""){MessageBox.Show("商品进价不能为空！", "提示对话框", MessageBoxButtons.OK, rmation);return;}if (this.txtSellPrice.Text == ""){MessageBox.Show("销售价格不能为空！", "提示对话框", MessageBoxButtons.OK, rmation);return;}if (this.txtNeedPay.Text == ""){MessageBox.Show("应付金额不能为空！", "提示对话框", MessageBoxButtons.OK, rmation);return;}if (!G_OperationClass.IsNumeric(this.txtNum.Text)&& !G_OperationClass.IsNumeric(this.txtGoodsInPrice.Text)&& !G_OperationClass.IsNumeric(this.txtHasPay.Text)&& !G_OperationClass.IsNumeric(this.txtSellPrice.Text)){MessageBox.Show("您输入的数据格式有误！", "提示对话框", MessageBoxButtons.OK, rmation);}string P_Str_Id = String.Empty;//检索数据库中对应客户的IDstring P_Str_cmdtxt2 = "SELECT UserID,Name FROM tb_User WHERE Name='" + this.cbxSellName.SelectedValue.ToString() + "'";SqlDataReader P_dr = G_SqlClass.GetReader(P_Str_cmdtxt2);P_dr.Read();if (P_dr.HasRows){P_Str_Id = P_dr["UserID"].ToString();}P_dr.Close();//下面是要执行的SQL语句P_Str_cmdtxt = "INSERT INTOtb_Sell(SellID,GoodsID,UserID,GoodsName,GoodsNum,GoodsUnit,GoodsTime,GoodsSpec,GoodsPrice,Se llPrice";P_Str_cmdtxt += ",Remark,NeedPay,HasPay,StockID) VALUES('" +bGoodsID.Text + "','" + PropertyClass.GetGoodsID + "','" + P_Str_Id + "'";P_Str_cmdtxt += ",'"+ this.txtGoodsName.Text + "','"+ this.txtNum.Text + "','" + this.cbxUnit.SelectedValue.ToString() + "'";P_Str_cmdtxt += ",'" + this.dtBirthday.Value.ToString("yyyy-MM-dd") + "','" + this.txtSpec.Text + "','" + this.txtGoodsInPrice.Text + "'";P_Str_cmdtxt += ",'" + this.txtSellPrice.Text + "','" +this.txtRemark.Text + "'";P_Str_cmdtxt += ",'" + this.txtNeedPay.Text + "','" +this.txtHasPay.Text + "','" + PropertyClass.GetStockID + "')";string update = "update tb_Stock set StockNum =StockNum-'" +this.txtNum.Text + "' where GoodsID='" + PropertyClass.GetGoodsID + "'and DepotName='" + PropertyClass.StockName + "'";G_SqlClass.GetExecute(update);SqlDataReader P_dr2 = G_SqlClass.GetReader("select GoodsID,StockNum from tb_Stock where GoodsID='"+ PropertyClass.GetGoodsID + "' and StockNum<'" +Convert.ToInt32(txtNum.Text.Trim()) + "'");P_dr2.Read();if (P_dr2.HasRows){MessageBox.Show("库存中没有足够数量的商品，请重新填写销售数量！"); txtNum.Text = "";txtNum.Focus();}else{//执行SQL语句并返回执行结果if (G_SqlClass.GetExecute(P_Str_cmdtxt)){MessageBox.Show("数据添加成功！");ControlStatus();PropertyClass.GetGoodsID = null;}else{MessageBox.Show("数据添加失败！");}}P_dr2.Close();}else{MessageBox.Show("请选择销售员姓名！", "提示对话框", MessageBoxButtons.OK, rmation);}break;case 2:if (this.cbxSellName.SelectedValue.ToString() != ""){string P_Str_Id = String.Empty;//检索数据库中对应客户的IDstring P_Str_cmdtxt2 = "SELECT UserID,Name FROM tb_User WHERE Name='" + this.cbxSellName.SelectedValue.ToString() + "'";SqlDataReader P_dr = G_SqlClass.GetReader(P_Str_cmdtxt2);P_dr.Read();if (P_dr.HasRows){P_Str_Id = P_dr["UserID"].ToString();}P_dr.Close();P_Str_condition = this.dgvSellInfo[0,this.dgvSellInfo.CurrentCell.RowIndex].Value.ToString();P_Str_cmdtxt = "UPDATE tb_Sell SET GoodsName='" +this.txtGoodsName.Text + "',GoodsNum='" + this.txtNum.Text + "'";P_Str_cmdtxt += ",GoodsUnit='"+ this.cbxUnit.SelectedValue.ToString() + "',GoodsTime='" + this.dtBirthday.Value + "'";P_Str_cmdtxt += ",GoodsSpec='" + this.txtSpec.Text +"',UserID='"+P_Str_Id+"',GoodsPrice=" + this.txtGoodsInPrice.Text + "";P_Str_cmdtxt += ",SellPrice=" + this.txtSellPrice.Text + ",Remark='"+ this.txtRemark.Text + "'";P_Str_cmdtxt += ",NeedPay=" + this.txtNeedPay.Text + ",HasPay=" + this.txtHasPay.Text + " WHERE SellID='" + P_Str_condition + "'";if (G_SqlClass.GetExecute(P_Str_cmdtxt)){MessageBox.Show("数据修改成功！");ControlStatus();}else{MessageBox.Show("数据修改失败！");}}else{MessageBox.Show("请选择销售员姓名！", "提示对话框", MessageBoxButtons.OK, rmation);}break;default:break;}//绑定数据显示控件string P_Str_cmdtxt1 = "SELECT SellID,GoodsID as 商品ID,[Name] as 销售员姓名,GoodsName as 商品名称";P_Str_cmdtxt1 += ",GoodsNum as 销售数量,GoodsUnit as 商品单位,GoodsSpec as 商品规格,GoodsTime as 销售时间";P_Str_cmdtxt1 += ",GoodsPrice 进货价格,SellPrice as 销售价格,NeedPay as 应收金额,HasPay as 实收金额,Remark as 备注";P_Str_cmdtxt1 += " FROM v_UserSell";this.dgvSellInfo.DataSource = G_SqlClass.GetDs(P_Str_cmdtxt1).Tables[0];}结果截图：销售之前。