110,536
社区成员
发帖
与我相关
我的任务
分享
private void FillCommodityInfo()
{
ds = new DataSet();
DBHelper dB = new DBHelper();
try
{
string sql = string.Format("select a.CommodityID 商品编号,a.CommodityName 商品名称,b.SortName 类别名称,a.CommodityPrice 商品价格," +
"IF(a.IsDiscount = 1,'是','否') 是否打折,a.ReducePrice 打折价格 from commodity as A inner join commoditysort as B on a.SortID = b.SortID");
MySqlDataAdapter msda = new MySqlDataAdapter(sql, dB.Connection);//适配器,自动打开和关闭数据库,后面无需关闭操作
msda.Fill(ds, "commodity");
this.dgvCommodity.DataSource = this.ds.Tables["commodity"];
}
catch (Exception e)
{
MessageBox.Show("数据库操作错误!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
#region 添加事件
private void tsbtnAdd_Click(object sender, EventArgs e)
{
AddOrEdit aoe = new AddOrEdit();
aoe.Text = "添加商品信息";
aoe.commodityID = 0;//新增id传0
aoe.ShowDialog();//窗口不关闭会一直在这,关闭之后重新刷新dgv
this.FillCommodityInfo();//重新绑定dgv
}
#endregion
#region 编辑事件
private void tsbtnEdit_Click(object sender, EventArgs e)
{
AddOrEdit aoe = new AddOrEdit();
if (this.dgvCommodity.CurrentRow != null)
{
aoe.commodityID = Convert.ToInt32(dgvCommodity.CurrentRow.Cells[0].Value);//获取当前选中行的第一列中的值(使用这一句会产生乱码)
aoe.ShowDialog();
this.FillCommodityInfo();
}
}
#endregion
this.ds.Tables["commodity"].Columns[0].ColumnName = "商品编号";
this.dgvCommodity.Columns[0].HeaderText = "商品编号";
this.dgvCommodity.AutoGenerateColumns = false;
this.dgvCommodity.VirtualMode = true;
this.dgvCommodity.Columns.Add("CommodityID", "商品编号");