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);
});
}
