public static bool DeleteRecord(int id)
{
try
{
IDeleteDataSourceFace query = new DeleteSQL(TableName.Recomment);
query.DataBaseAlias = Const.LogConnection;
query.AddWhere("Id", id);
return(query.ExecuteNonQuery() > 0);
}
catch (Exception ex)
{
Logger.Error(ex);
return(false);
}
}
private void dgvProductInfo_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
//修改商品
if (e.ColumnIndex == dgvProductInfo.Columns[0].Index)
{
ProductInfo productInfo = new ProductInfo("修改", int.Parse(dgvProductInfo.Rows[e.RowIndex].Cells["ProductID"].Value.ToString()));
productInfo.ShowDialog();
}
//删除商品
if (e.ColumnIndex == dgvProductInfo.Columns[1].Index)
{
//弹出确认删除框，确认删除后，调用删除语句
if (MessageBox.Show("确认删除？", "此删除不可恢复", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
var sql = DeleteSQL.DeleteProductWithId(int.Parse(dgvProductInfo.Rows[e.RowIndex].Cells["ProductID"].Value.ToString()));
MessageBox.Show(DeleteData.DeleteInfo(sql) ? "删除商品成功" : "删除商品失败");
}
}
}
