private ListViewItem rest_lvi(int id, Goods_Data dat) { ListViewItem lvi = new ListViewItem(); lvi.Text = id.ToString(); lvi.Tag = dat.GoodsId; lvi.SubItems.Add(dat.GoodsDisplayName); lvi.SubItems.Add(dat.ItemQuantity.ToString()); lvi.SubItems.Add(dat.BasicSalePrice.ToString()); lvi.SubItems.Add(dat.ItemId.ToString()); return(lvi); }
private void button4_Click(object sender, EventArgs e) { if (textBox4.Text.Trim().Equals("") || textBox5.Text.Trim().Equals("") || textBox6.Text.Trim().Equals("") || textBox7.Text.Trim().Equals("")) { MessageBox.Show("兄Dei,信息填完整啊!", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } int itemID = Convert.ToInt32(textBox4.Text.Trim());//道具ID string GoodsDisplayName = textBox5.Text.Trim(); int ItemQuantity = Convert.ToInt32(textBox6.Text.Trim()); double BasicSalePrice = Convert.ToDouble(textBox7.Text.Trim()); string gameItemKey = GetKey(itemID.ToString());//Key Task.Run(() => { string sql = $@"select max([GoodsId]) from {_db}.[dbo].[Goods] "; int GoodsId = Convert.ToInt32(db._SQLScalar(sql)) + 1;//自增1 bool status = InsertStore(GoodsId, itemID, GoodsDisplayName, ItemQuantity, BasicSalePrice, gameItemKey); if (status) { Goods_Data sp = new Goods_Data() { BasicSalePrice = BasicSalePrice, CategoryId = "未上架", GoodsDisplayName = GoodsDisplayName, GoodsId = GoodsId, ItemId = itemID.ToString(), ItemQuantity = ItemQuantity }; Goods_Data_is_null.Add(sp); this.Invoke(new Action(delegate { listView2.Items.Add(rest_lvi(Convert.ToInt32(listView2.Items[listView2.Items.Count - 1].SubItems[0].Text) + 1, sp)); })); } xs(status); }); }