/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button_save_Click(object sender, EventArgs e)
{
if (this.grid_weights.SelectedCells.Count != 0)
{
int r = this.grid_weights.SelectedCells[0].RowIndex;
string id = (string)this.grid_weights.Rows[r].Cells["id"].Value;
string level = this.combobox_labels.Text;
string remarks = this.input_remarks.Text;
string sql = "update t_weights set level='" + level + "', remarks='" + remarks + "' where id='" + id + "'";
if (DbUtil.edit(sql))
{
this.dataSource_weights();
MessageBox.Show("操作成功");
}
else
{
MessageBox.Show("操作失败");
}
}
else
{
MessageBox.Show("请选择一条数据");
}
}
/// <summary>
/// 更新级别
/// </summary>
private void update_weight_level(string levelStr)
{
string id = (string)this.grid_weights.Rows[this.grid_weights.RowCount - 1].Cells["id"].Value;
string sql = "update t_weights set level='" + levelStr + "' where id = '" + id + "'";
if (DbUtil.edit(sql))
{
this.grid_weights.Rows[this.grid_weights.RowCount - 1].Cells["level"].Value = levelStr;
//MessageBox.Show("操作成功");
}
else
{
//MessageBox.Show("操作失败");
}
}
private void input_remarks_KeyUp(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
TextBox test = (TextBox)sender;
string id = (string)this.grid_weights.Rows[this.grid_weights.RowCount - 1].Cells["id"].Value;
string sql = "update t_weights set remarks='" + test.Text + "' where id = '" + id + "'";
if (DbUtil.edit(sql))
{
this.grid_weights.Rows[this.grid_weights.RowCount - 1].Cells["remarks"].Value = test.Text;
//MessageBox.Show("操作成功");
}
else
{
//MessageBox.Show("操作失败");
}
}
}
private void button_del_Click(object sender, EventArgs e)
{
if (this.grid_weights.SelectedCells.Count != 0)
{
int r = this.grid_weights.SelectedCells[0].RowIndex;
string id = (string)this.grid_weights.Rows[r].Cells["id"].Value;
string sql = "update t_weights set life_cycle=-1 where id='" + id + "'";
if (DbUtil.edit(sql))
{
this.dataSource_weights();
MessageBox.Show("操作成功");
}
else
{
MessageBox.Show("操作失败");
}
}
else
{
MessageBox.Show("请选择一条数据");
}
}
