数据批量录入的问题(100分全给)急!
资产编号是自动生成的流水号
这个是窗体的加载信息//窗体加载
private void Y_ZCDJ_ZJ_Load(object sender, System.EventArgs e)
{
this.Z_Rework_SM();
this.Z_FD_MCC_ALL();
this.Clear_Control();
if(this._WorkBS == "修改")
{
this.FD_UPDATE_DATE();
}
if(this._WorkBS == "查看")
{
this.FD_UPDATE_DATE();
this.Enabled_Control();
this.btn_OK.Enabled = false;
}
if(this._WorkBS == "添加")
{
string str_year;
DateTime dt = System.DateTime.Now;
str_year = dt.Year.ToString().Remove(0,2);
this.txt_zcbh.Text = "YQ" + str_year + this.cls_other.Str_PX_YQ(this._WorkDS,"主机数据表","资产编号");
}
}
}
Str_PX_YQ是自动生成流水号的方法
这个是批量添加:但总提示主键重复,我跟踪看了一下,流水号居然没变,实在不知道问题在哪!,如果一个一个添加时 流水号也就是资产编号可自动生成
private void btn_OK_Click(object sender, System.EventArgs e)
{
if(this._WorkBS == "添加")
for(temp=1;temp<=System.Convert.ToInt32(this.txt_ts.Text.Trim());temp++)
{
{
string str_year;
DateTime dt = System.DateTime.Now;
str_year = dt.Year.ToString().Remove(0,2);
this.txt_zcbh.Text = "YQ" + str_year + this.cls_other.Str_PX_YQ(this._WorkDS,"主机数据表","资产编号");
DataRow dr = this._WorkDS.Tables["主机数据表"].NewRow();
dr["备注"] = this.txt_bz.Text;
dr["出厂号"] = this.txt_cch.Text;
dr["厂家"] = this.txt_cj.Text;
dr["单价"] = this.txt_dj.Text;
dr["登记单号"] = this.txt_djdh.Text;
dr["单位编号"] = this.txt_dwbh.Text;
dr["国别"] = this.txt_gb.Text;
dr["规格"] = this.txt_gg.Text;
dr["科研号"] = this.txt_kyh.Text;
dr["领用人工资号"] = this.txt_lyrgzh.Text;
dr["设备号"] = this.txt_sbh.Text;
dr["设备名称"] = this.txt_sbmc.Text;
dr["资产编号"] = this.txt_zcbh.Text;
if(this.cls_y_zcgl.ZCDJ_ZJ_Add(dr) == true)
{
this.cls_other.ShowMessageBox(KDMIS.Class.Cls_Other.ShowMessageBoxType.添加成功信息提示);
this.DialogResult = DialogResult.OK;
}
else
{
this.DialogResult = DialogResult.Cancel;
}
}
}