//数据行转化为seat实例 public Seats DataRowToSeat(DataRow dr) { Seats se = new Seats(); se.restaurant_ID = (int)dr["restaurant_ID"]; se.seat_style = (int)dr["seat_style"]; se.seat_use = (int)dr["seat_use"]; se.seat_left = (int)dr["seat_left"]; se.seat_all = (int)dr["seat_all"]; return se; }
//根据餐厅ID查询座位 public Seats select_seat(int restaurant_ID) { String sql = "select * from seat_information where restaurant_ID=@restaurant_ID"; SqlParameter[] param = { new SqlParameter("@restaurant_ID",SqlDbType.Int) }; param[0].Value = restaurant_ID; Seats se = new Seats(); DataTable dt = SqlHelper.ExecuteSelect(sql, param); foreach (DataRow dr in dt.Rows) { se = DataRowToSeat(dr); } return se; }
//根据餐厅ID修改座位 public int update_seat(int restaurant_ID, Seats se) { String sql = "update seat_information set seat_style=@seat_style,seat_use=@seat_use,seat_left=@seat_left where restaurant_ID=@restaurant_ID"; SqlParameter[] param = { new SqlParameter("@restaurant_ID",SqlDbType.Int), new SqlParameter("@seat_style",SqlDbType.Int), new SqlParameter("@seat_use",SqlDbType.Int), new SqlParameter("@seat_left",SqlDbType.Int), new SqlParameter("@seat_all",SqlDbType.Int) }; param[0].Value = restaurant_ID; param[1].Value = se.seat_style; param[2].Value = se.seat_use; param[3].Value = se.seat_all - se.seat_use; param[4].Value = se.seat_all; return SqlHelper.ExecuteQuery(sql, param); }
//加入座位函数 public int Add_seat(Seats se) { String sql = "insert into seat_information values(@restaurant_ID,@seat_style,@seat_use,@seat_left,@seat_all)"; SqlParameter[] param = { new SqlParameter("@restaurant_ID",SqlDbType.Int), new SqlParameter("@seat_style",SqlDbType.Int), new SqlParameter("@seat_use",SqlDbType.Int), new SqlParameter("@seat_left",SqlDbType.Int), new SqlParameter("@seat_all",SqlDbType.Int), }; param[0].Value = se.restaurant_ID; param[1].Value = se.seat_style; param[2].Value = se.seat_use; param[3].Value = se.seat_all - se.seat_use; param[4].Value = se.seat_all; return SqlHelper.ExecuteQuery(sql, param); }
private void button2_Click_1(object sender, RoutedEventArgs e) { if (textBox1.Text == "") { MessageBox.Show("请输入小店名称。"); } else if (textBox2.Text == "") { MessageBox.Show("请输入密码。"); } else if (textBox3.Text == "") { MessageBox.Show("请确认密码。"); } else if (textBox4.Text == "") { MessageBox.Show("请输入验证问题。"); } else if (textBox5.Text == "") { MessageBox.Show("请输入答案。"); } else if (textBox6.Text == "") { MessageBox.Show("请输入小店描述。"); } else if (textBox8.Text == "") { MessageBox.Show("请输入2人桌总数。"); } else if (textBox9.Text == "") { MessageBox.Show("请输入4人桌总数。"); } else if (textBox10.Text == "") { MessageBox.Show("请输入8人桌总数。"); } else if (textBox11.Text == "") { MessageBox.Show("请输入12人桌总数。"); } else if (textBox12.Text == "") { MessageBox.Show("请输入手机号。"); } else if (textBox13.Text == "") { MessageBox.Show("请输入对外联系方式。"); } else if (textBox14.Text == "") { MessageBox.Show("请输入详细地址。"); } else if (serve == 1000) { MessageBox.Show("请选择是否配送外卖。"); } else if (textBox2.Text != textBox3.Text) { MessageBox.Show("密码输入错误,请重新输入密码"); } else if (textBox7.Text == "") { MessageBox.Show("请输入图片"); } else if (textBox12.Text.Length != 11) { MessageBox.Show("手机号码位数不正确,轻松重新输入"); textBox12.Clear(); } else { rests = r_dal.GetAllRestaurant(); int amount = rests.Count; int j = 0; while (j < amount) { if (textBox12.Text == rests[j].rest_telephone) { MessageBox.Show("该手机号已被注册,请重新输入"); break; } j++; } if (j == amount) { rest.rest_name = textBox1.Text; rest.rest_password = textBox2.Text; rest.rest_question = textBox4.Text; rest.rest_answer = textBox5.Text; rest.rest_description = textBox6.Text; rest.rest_telephone = textBox12.Text; rest.rest_homephone = textBox13.Text; rest.rest_location = textBox14.Text; rest.rest_service = serve; rest.rest_privilege = WuYouHui; rest.begin_date = DateTime.Now; rest.end_date = DateTime.Now; rest.rest_state = WeiShenHe; rest.rest_district = comboBox2.Text; if (bll.Add_restaurant(rest)) { int count = bll.GetAllRestaurant().Count; List<Restaurant> restaurants = new List<Restaurant>(); restaurants = bll.GetAllRestaurant(); int i = 0; while (i < count) { if (textBox12.Text == restaurants[i].rest_telephone) { if (textBox2.Text == restaurants[i].rest_password) { common.rest = restaurants[i]; break; } } i++; } pic.pic_style = 2; //2 pic.pic_owner = common.rest.ID; dal.Add_picture(pic); //加入pic数据库 MessageBox.Show("添加成功"); restaurants = bll.GetAllRestaurant(); count = bll.GetAllRestaurant().Count; for (i = 1; i < count; i++) { if (common.rest.rest_telephone == restaurants[i].rest_telephone) { common.rest = restaurants[i]; break; } } Seats se = new Seats(); if (textBox8.Text != "") { se.restaurant_ID = common.rest.ID; se.seat_style = seat2; se.seat_all = Convert.ToInt16(textBox8.Text); se.seat_use = 0; s_bll.Add_Seat(se); } if (textBox9.Text != "") { se.restaurant_ID = common.rest.ID; se.seat_style = seat4; se.seat_all = Convert.ToInt32(textBox9.Text); se.seat_use = 0; s_bll.Add_Seat(se); } if (textBox10.Text != "") { se.restaurant_ID = common.rest.ID; se.seat_style = seat8; se.seat_all = Convert.ToInt16(textBox10.Text); se.seat_use = 0; s_bll.Add_Seat(se); } if (textBox11.Text != "") { se.restaurant_ID = common.rest.ID; se.seat_style = seat12; se.seat_all = Convert.ToInt16(textBox11.Text); se.seat_use = 0; s_bll.Add_Seat(se); } Win_Owner1 win_owner = new Win_Owner1(); win_owner.Show(); this.Close(); } else { MessageBox.Show("添加失败"); } } } }
public bool Add_Seat(Seats dat) { return dal.Add_seat(dat) > 0; }