用于在用户单击按钮时在文本框中添加自动生成Clear_data ID 的代码
本文关键字:Clear 自动生成 data ID 代码 添加 单击 用户 按钮 文本 用于 | 更新日期: 2023-09-27 18:30:31
我在 c# 中创建了一个表单,我需要自动生成的 ID,当用户单击清除数据按钮时会自动显示该 ID。ID 的格式应为 LEL5 序列号。(序列号总是在增加的情况下,如 1,2,3,..)
例如:我的第一张唱片 iD 是 LEL5-1,
我的第二个记录ID是LEL5-2
请帮忙。谢谢。
static int EJDS_id = 1;
string code;
private void button1_Click_1(object sender, EventArgs e)
{
EJDS_id = EJDS_id + 1;
txtjobno.Text = "LEL5-" + EJDS_id.ToString();
}
创建一个名为 SERIAL_NUMBERS 的表:
create table SERIAL_NUMBERS(
ID INT NOT NULL PRIMARY KEY,
LASTNUMBER INT NOT NULL);
然后插入一个字符串来存储最后一个值:
insert into SERIAL_NUMBERS(ID, LASTNUMBER) values (1, 0);
然后在代码隐藏中添加以下命名空间:
using System.Data;
using System.Data.OleDb;
using System.Web.Configuration;
然后在您的代码隐藏中:
protected void button1_Click_1(object sender, EventArgs e) {
UpdateLastNumber();
txtjobno.Text = "LEL5-" + GetLastNumber().ToString();
}
protected int GetLastNumber(){
int last = 0;
OleDbConnection con = new OleDbConnection(WebConfigurationManager.ConnectionStrings["YourConnectionStringnameFromWebConfigFile"].ConnectionString);
OleDbCommand cmd = new OleDbCommand("select lastnumber from serial_numbers where id = 1", con); // I added the condition just to be sure that only one value will be queried
con.Open();
last = Convert.ToInt32(cmd.ExecuteScalar().ToString());
con.Close();
return last;
}
protected void UpdateLastNumber(){
OleDbConnection con = new OleDbConnection(WebConfigurationManager.ConnectionStrings["YourConnectionStringnameFromWebConfigFile"].ConnectionString);
OleDbCommand cmd = new OleDbCommand("update serial_numbers set lastnumber = lastnumber + 1 where id = 1", con); // I added the condition just to be sure that only one value will be queried
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
string test = "LEL5-1";
int xxxx = Convert.ToInt32(test.Substring(5));
xxxx++;
string result = string.Format("LEL5-{0}", xxxx);