Exemplo n.º 1
0
        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);
        }
Exemplo n.º 2
0
        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);
        }