private void deleteToolStripMenuItem_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count == 0) { MessageBox.Show("请选择一列数据"); return; } int a = dataGridView1.SelectedRows[0].Index; int OrderId = (int)dataGridView1.Rows[a].Cells["OrderId"].Value; string state = dataGridView1.Rows[a].Cells["Column8"].Value.ToString().Trim(); if (state == "已退订") { string sql = string.Format(@"DELETE FROM OrderInfo where OrderId='{0}'", OrderId); DBTools bb = new DBTools(); string sql2 = string.Format(@"DELETE FROM client_order where OrderId='{0}'", OrderId); int i = bb.DonIntsdf(sql); if (i > 0) { MessageBox.Show("删除成功"); loadDate(); } else { MessageBox.Show("删除失败"); } } else { MessageBox.Show("只可删除已退订的订单"); } }
private void button2_Click(object sender, EventArgs e) { int sdf = 0; Random random = new Random(); int number = Convert.ToInt32(numericUpDown1.Value); //电影票的张数 string moiveid = dataGridView1.SelectedRows[0].Cells[0].Value.ToString(); //影院ID string dindanbianh = ""; if (number <= int.Parse(textBox7.Text.ToString())) { for (int i = 1; i <= number; i++) { int orderId = random.Next(100000, 999999);//生成一个六位随机数作为订单编号 string sql = string.Format(@"INSERT INTO [movieDB].[dbo].[OrderInfo] ([OrderId] ,[TicketId] ,[number] ,[State]) VALUES ({0},'{1}','{2}','{3}') ;UPDATE [movieDB].[dbo].[Movie] SET [number]=[number]-{4} WHERE TicketId='{5}'" , orderId, moiveid, number, "已预订", number, moiveid); Convert.ToInt32(cc.DonIntsdf(sql)); string sql2 = string.Format(@"INSERT INTO client_order([OrderId],[ClientId]) VALUES ('{0}','{1}')", orderId, Program.username); sdf = Convert.ToInt32(cc.DonIntsdf(sql2)); dindanbianh = dindanbianh + orderId; } if (sdf > 0) { MessageBox.Show("预订成功,订单编号为:" + dindanbianh, "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } else { MessageBox.Show("预订的票数不能超过剩余票数"); } }
private void button1_Click(object sender, EventArgs e) { string sql = string.Format(@"update Client set ClientPwd='{0}',name='{1}',age={2} where ClientId='{3}'", textBox3.Text, textBox1.Text, textBox2.Text, Program.username); DBTools bb = new DBTools(); int i = bb.DonIntsdf(sql); if (i > 0) { MessageBox.Show("保存成功"); } else { MessageBox.Show("保存失败"); } }
private void tuidinToolStripMenuItem_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count == 0) { MessageBox.Show("请选择一列数据"); return; } int a = dataGridView1.SelectedRows[0].Index; int OrderId = (int)dataGridView1.Rows[a].Cells["OrderId"].Value; string sql = string.Format(@"update OrderInfo set State='{0}' where OrderId='{1}'", "已退订", OrderId); DBTools bb = new DBTools(); int i = bb.DonIntsdf(sql); if (i > 0) { MessageBox.Show("退订成功"); loadDate(); } else { MessageBox.Show("退订失败"); } }
private void button1_Click(object sender, EventArgs e)//注册 { bool kdfg = ksdjhfg(); if (kdfg == false) { string ID = comboBox1.Text; string PWD = textBox1.Text; string quePWD = textBox2.Text; if (ID != "" && PWD != "" && quePWD != "" && textBox3.Text != "") { if (ID.Length == 11) { bool asd = IsHandset(ID); if (asd) { if (PWD.Length >= 6 && PWD.Length <= 12) { if (PWD == quePWD) { if (textBox3.Text == he.ToString()) { string asdd = @"INSERT INTO [movieDB].[dbo].[Client] ([ClientId] ,[ClientPwd]) VALUES ('" + ID + "','" + PWD + "')"; DBTools bb = new DBTools(); int clienID = bb.DonIntsdf(asdd); if (clienID == 1) { MessageBox.Show("注册成功,立即返回登录界面", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); this.Close(); } else { MessageBox.Show("注册失败"); } } else { MessageBox.Show("验证码不正确"); } } else { MessageBox.Show("密码不一致"); } } else { MessageBox.Show("密码长度限制在6-12位"); } } else { MessageBox.Show("手机号格式不正确"); } } else { MessageBox.Show("手机号长度不正确"); } } else { MessageBox.Show("请完善信息!"); } } else { MessageBox.Show("此用户已注册"); } }