private void 删除ToolStripMenuItem_Click(object sender, EventArgs e) { string sql = "DELETE FROM [Message] WHERE [Message].[ID]=" + dgvMsgList.SelectedRows[0].Cells["ID"].Value.ToString(); BaseOperate operate = new BaseOperate(); operate.getcom(sql); btnSearchMsg_Click(null, null); }
private void btnSaveMsg_Click(object sender, EventArgs e) { string stationID = GetRowByValue(stations,"Name",cbRevStation.SelectedItem)["StationID"].ToString(); int lv = 0; if (rbLv0c.Checked) lv = 1; if (rbLv1c.Checked) lv = 2; string sql = "UPDATE [Message] SET SendTime='"+DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")+"',MsgContent='"+ txtMsgContent1.Text+"',MsgLevel="+ lv+",SendPeople='"+ UNtextBox .Text+ "',RevStation="+ stationID+",MsgState=0 WHERE ID="+txtMsgContent1.Tag.ToString(); BaseOperate operate = new BaseOperate(); operate.getcom(sql); btnSearchMsg_Click(null,null); }