如何在VB.NET中发票编号ganrate？ [英] How to invoice number ganrate in VB.NET ?

问题描述

你好



如何在vb.net中编制发票号但主要问题是我有3台电脑而且我想在3台电脑中安装相同的软件并且发送独特的发票数字，如果计算机1计费柜台gnarte发票1所以第二台电脑autometice ganrate发票没有2。'





喜欢市盈率会计系统（大商城）请帮帮我





[phone] [已删除]我的号码

[已删除] @gmail。 com

www。[已删除] .com



我尝试过：



i我尝试并且我成功但是只有1个电脑而不是3个电脑就像我在多个电脑中生成同一时间发票所以两个电脑生成相同的发票没有所以这是一个问题

解决方案

在许多系统之间生成唯一编号：



1）系统需要连接到网络。

2）数字生成应该集中完成o n外部系统，客户连接到它。



方式取决于你的能力是什么以及你在服务器计算机上运行的是什么，大多数通过表格上的唯一数字列在数据库层执行此操作。

首先，不要在任何论坛中发布您的电子邮件地址，除非您真的喜欢垃圾邮件！如果有人回复您，您将收到一封电子邮件通知您。这同样适用于您的电话号码 - 没有人需要。

您的网站地址很危险：如果您再次发布，很有可能您会被认为是垃圾邮件发送者而且您会被禁止进入网站。



关于发票编号...不要生成它。因为您正在为多个用户工作，所以您将使用多用户数据库来存储发票数据（也可能是客户） - Sql Server或MySql。将发票号作为数据库中的IDENTITY字段，并且当您插入行时SQL会为您生成它，并确保它对您来说是唯一的。

感谢您的回复但是先生，



我使用的是MSSQL DATABSE，我希望在多台计算机中发出惊人的发票，但是不像1,2,3,4 ......那样的独特的发票并且只有一个DATABSE文件，如STORE.MDF



注意： - 我使用SQL SERVER 2005服务器所以数据库访问所有计算机，但问题仅产生发票号码

hello

how to ganrate invoice number in vb.net but main problm is i have 3 computer and i want install same software in 3 computer and gnrate unique invoice number like if computer 1 billing counter gnarte invoice 1 so second computer autometice ganrate invoice no 2 .'


like mart accounting system( big mall) please help me


[phone][DELETED] my number
[DELETED]@gmail.com
www.[DELETED].com

What I have tried:

i am try and i am success but only for 1 pc not 3 pc like when im generate same time invoice in multiple pc so both computer generate same invoice no so this is a problem

解决方案

To generate a unique number between many systems:

1) The systems need to be connected to a network.
2) The number generation should be done centrally on an external system, which the "clients" connect to.

The "how" depends on what your abilities are and what you are running on your "server" computer, most do this at the database layer through unique number columns on a table.

First off, never post your email address in any forum, unless you really like spam! If anyone replies to you, you will receive an email to let you know. The same applies to your phone number - nobody needs that.
And your site address is dangerous: if you post it again, there is a very good chance you will be assumed to be a spammer and you will be banned from the site.

As to the invoice number ... don't generate it. Because you are working for multiple users you will be using a multiuser database to store the invoice data (and presumably the customers as well) - either Sql Server or MySql. Have the invoice number as an IDENTITY field within the database, and SQL will generate it for you when you INSERT the row, and will ensure that it is unique for you.

thanks for reply but sir,

I AM USING MSSQL DATABSE , AND I WANT GANRATE INVOICE IN MULTIPLE COMPUTER BUT UNIQUE INVOICE NO LIKE 1,2,3,4..... ETC AND ONLY IN ONE DATABSE FILE LIKE STORE.MDF

NOTE:- I AM USING SQL SERVER 2005 SERVER SO DATABASE ACCESS ALL COMPUTER BUT PROBLEM IS ONLY GENERATING INVOICE NUMBER

这篇关于如何在VB.NET中发票编号ganrate？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！