运行环境中：
运行之后：
求教，我想把“交接班”那个给删了，可是连代码一起删了之后，运行还会出现，求高手，或许没删全，等下把代码上了

private void frmMain_FormClosing(object sender, FormClosingEventArgs e) { Application.Exit(); }
private void 删除ToolStripMenuItem_Click(object sender, EventArgs e) { if (dataGridView2.SelectedRows.Count >= 1) { for (int i = 0; i < dataGridView2.SelectedRows.Count; i++) { string sqlcaozuo = string.Format("delete from Operation where Id='{0}'", (int)dataGridView2.SelectedRows[i].Cells[0].Value); SqlCommand cmd = new SqlCommand(sqlcaozuo,DBHelp.connection); DBHelp.connection.Open(); cmd.ExecuteNonQuery(); DBHelp.connection.Close(); } timer1_Tick(sender,e); } }
private void 刷新的ToolStripMenuItem_Click(object sender, EventArgs e) { timer1_Tick(sender,e); }
public void jifei() { set.Tables.Clear(); string sql = "select Id,ComputerId,CardId,StartMoney,BeginTime,UserTime,priceId,LastMoney from Record"; adapter = new SqlDataAdapter(sql, DBHelp.connection); adapter.Fill(set, "record"); foreach (DataRow row in set.Tables["record"].Rows) {
string time = Convert.ToString(DateTime.Now - Convert.ToDateTime(row["BeginTime"])); int a = time.IndexOf(':'); int price = Convert.ToInt32(time.Substring(a + 1, 2)); row["UserTime"] = time.Substring(a - 2, 2) + "时" + time.Substring(a + 1, 2) + "分"; double aa; if (UsersHelp.huiyuan(row["CardId"].ToString())) { string sql1 = string.Format("Select huiyuan from Price where Id='{0}'", row["priceId"]); SqlCommand cmd = new SqlCommand(sql1, DBHelp.connection); DBHelp.connection.Open(); aa = Convert.ToDouble(cmd.ExecuteScalar()); DBHelp.connection.Close(); } else { string sql1 = string.Format("Select feihuiyuan from Price where Id='{0}'", row["priceId"]); SqlCommand cmd = new SqlCommand(sql1, DBHelp.connection); DBHelp.connection.Open(); aa = Convert.ToDouble(cmd.ExecuteScalar()); DBHelp.connection.Close(); } if (price % 12 == 0) { if (Convert.ToDouble(row["LastMoney"]) > 0) { row["LastMoney"] = Convert.ToDouble(row["LastMoney"]) - aa / 5; } else { UsersHelp.jiezhang((string)row["CardId"]); //当费用小于零时自动结帐 } } } dataGridView3.DataSource = set.Tables["record"]; SqlCommandBuilder build = new SqlCommandBuilder(adapter); adapter.Update(set, "record"); }
private void 删除ToolStripMenuItem1_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count >= 1) { for (int i = 0; i < dataGridView1.SelectedRows.Count; i++) { string sqlcaozuo = string.Format("delete from Message where Id='{0}'", (int)dataGridView1.SelectedRows[i].Cells[0].Value); SqlCommand cmd = new SqlCommand(sqlcaozuo, DBHelp.connection); DBHelp.connection.Open(); cmd.ExecuteNonQuery(); DBHelp.connection.Close(); } timer1_Tick(sender, e); } }
private void contextMenuStrip3_Click(object sender, EventArgs e) { timer1_Tick(sender,e); } }}

菜鸟一个，看不太懂。