SR十年树木 百年树人 长春树人科技
0431-85959679 注册后的软件必须使用新版本，版本可以向下兼容但绝对
不能使用老版本，否则接单会速度非常慢。 软件注册后一定要进入前台和后台检查相关的配置是否
正确。
3.注册修改数据库的步骤
所有数据库注册必须先将SMSCom.dll复制到软件所在目录下。 然后按照下面的步骤更改数据库
在InformationSQL数据库中更改以下表：
点表Item->右键->设计表，然后增加Item_Price5字段，内容如下
点表 MemberCardType->右键->设计表，然后增加
SR十年树木 百年树人
SR十年树木 百年树人 长春树人科技
0431-85959679 MemberCardType_UsePrice字段，内容如下
点视图 ItemEdit->右键->设计视图，然后增加Sql语句dbo.Item..Item_Price5，内容如下
SR十年树木 百年树人
SR十年树木 百年树人 长春树人科技
0431-85959679 然后看看品项表会多个会员价格的选项，如果不填，默认与品项价格一样，要是不一样则改之。
在会员卡类型设置里也有个会员价的字段，为真则表示这种类型的卡结算是按着会员价格执行的，会员价格要是0，则用品项价格，不为0就自动取会员价格。测试一下吧。（注意若是老客户需要把所有菜品中的会员价那里填上数值，默认是空的，如果不填会报错，客户若是没有会员价也要填个0上去）
最后将下面的内容替换BusinessBillDetailView视图中的内容（找到视图右键—设计视图）
SELECT DISTINCT
TOP 100 PERCENT dbo.Item.Item_Number, dbo.Item.Item_ID, dbo.Item.Item_Name, dbo.Item.Item_Abbreviation, dbo.BusinessDetail.BusinessDetail_OldPrice, dbo.BusinessDetail.BusinessDetail_ItemPrice, dbo.Item.Item_Unit, dbo.BusinessDetail.BusinessDetail_ItemDiscount,
SUM(dbo.BusinessDetail.BusinessDetail_ItemCount) AS ItemCount,
SUM(dbo.BusinessDetail.BusinessDetail_ItemZhiCount) AS ItemZhiCount,
dbo.Business.Business_ID, dbo.Notes.Notes_Name, dbo.BusinessDetail.Notes_ID, dbo.SmallItem.SmallItem_Number, dbo.SmallItem.SmallItem_Printer1, dbo.SmallItem.SmallItem_Printer2, dbo.SmallItem.SmallItem_Printer3, dbo.SmallItem.SmallItem_Printer4, dbo.SmallItem.SmallItem_Printer5, dbo.SmallItem.SmallItem_Printer6, dbo.SmallItem.SmallItem_WithPass, dbo.LargeItem.LargeItem_Number FROM dbo.LargeItem INNER JOIN dbo.Business INNER JOIN dbo.BusinessSub ON
dbo.Business.Business_ID = dbo.BusinessSub.Business_ID INNER JOIN dbo.BusinessDetail INNER JOIN dbo.Item INNER JOIN
dbo.SmallItem ON dbo.Item.SmallItem_ID = dbo.SmallItem.SmallItem_ID ON dbo.BusinessDetail.Item_ID = dbo.Item.Item_ID ON
dbo.BusinessSub.BusinessSub_ID = dbo.BusinessDetail.BusinessSub_ID ON dbo.LargeItem.LargeItem_ID = dbo.SmallItem.LargeItem_ID LEFT OUTER JOIN dbo.Notes ON dbo.BusinessDetail.Notes_ID = dbo.Notes.Notes_ID
SR十年树木 百年树人
SR十年树木 百年树人 长春树人科技
0431-85959679 GROUP BY dbo.Item.Item_ID, dbo.Item.Item_Number, dbo.Item.Item_Name, dbo.Item.Item_Abbreviation, dbo.BusinessDetail.BusinessDetail_OldPrice, dbo.BusinessDetail.BusinessDetail_ItemPrice, dbo.Item.Item_Unit,
dbo.BusinessDetail.BusinessDetail_ItemDiscount, dbo.Business.Business_ID, dbo.Notes.Notes_Name, dbo.BusinessDetail.Notes_ID,
dbo.SmallItem.SmallItem_Number, dbo.SmallItem.SmallItem_Printer1, dbo.SmallItem.SmallItem_Printer2, dbo.SmallItem.SmallItem_Printer3, dbo.SmallItem.SmallItem_Printer4, dbo.SmallItem.SmallItem_Printer5, dbo.SmallItem.SmallItem_Printer6, dbo.SmallItem.SmallItem_WithPass, dbo.LargeItem.LargeItem_Number ORDER BY dbo.Item.Item_Number
如图（替换变蓝色的部分）
将下面的内容替换BusinessDetailEdit视图中的内容（找到视图右键—设计视图）
SELECT dbo.BusinessDetail.BusinessDetail_ID, dbo.BusinessDetail.BusinessDetail_OldPrice, dbo.BusinessDetail.BusinessDetail_ItemPrice, dbo.BusinessDetail.BusinessDetail_ItemCount, dbo.BusinessDetail.BusinessDetail_ItemZhiCount, dbo.BusinessDetail.BusinessDetail_ItemDiscount, dbo.BusinessDetail.BusinessDetail_ItemState,
dbo.BusinessDetail.BusinessDetail_Recno, dbo.BusinessDetail.Item_ID, dbo.BusinessDetail.Notes_ID, dbo.BusinessDetail.BusinessSub_ID,
dbo.BusinessDetail.Withdrawal_ID, dbo.Item.Item_Number, dbo.Item.Item_Name,
SR十年树木 百年树人
SR十年树木 百年树人 长春树人科技
0431-85959679 dbo.Item.Item_Unit, dbo.Notes.Notes_Name, dbo.SmallItem.SmallItem_Number, dbo.SmallItem.SmallItem_Discount, dbo.SmallItem.SmallItem_Tip, dbo.Item.Item_LowCost, dbo.BusinessSub.BusinessSub_Time, dbo.Business.Business_ID, dbo.Employee.Employee_Number, dbo.LargeItem.LargeItem_Number FROM dbo.Notes RIGHT OUTER JOIN dbo.LargeItem INNER JOIN dbo.SmallItem INNER JOIN dbo.Item INNER JOIN
dbo.BusinessDetail ON dbo.Item.Item_ID = dbo.BusinessDetail.Item_ID ON dbo.SmallItem.SmallItem_ID = dbo.Item.SmallItem_ID INNER JOIN dbo.BusinessSub ON
dbo.BusinessDetail.BusinessSub_ID = dbo.BusinessSub.BusinessSub_ID INNER JOIN dbo.Business ON dbo.BusinessSub.Business_ID = dbo.Business.Business_ID ON dbo.LargeItem.LargeItem_ID = dbo.SmallItem.LargeItem_ID ON
dbo.Notes.Notes_ID = dbo.BusinessDetail.Notes_ID LEFT OUTER JOIN
dbo.Employee ON dbo.BusinessSub.Employee_ID = dbo.Employee.Employee_ID
如图（替换变蓝色的部分）
SR十年树木 百年树人