private void Confirm(object sender, RoutedEventArgs e) { if (type == 0) { int exitroom_type_text = 0; string exitroom_time_text = ""; bool IsSealText = false; if (radiobutton1.IsChecked == true) { exitroom_type_text = 1; exitroom_time_text = exitroom_time_hour.Text + ":" + exitroom_time_minute.Text; if (IsSeal_ckb.IsChecked == true) { IsSealText = true; } } if (radiobutton2.IsChecked == true) { exitroom_type_text = 2; exitroom_time_text = exitroom_time_hour.Text + ":" + exitroom_time_minute.Text; if (IsSeal_ckb.IsChecked == true) { IsSealText = true; } } if (radiobutton3.IsChecked == true) { exitroom_type_text = 3; if (IsSeal_ckb2.IsChecked == true) { IsSealText = true; } } string confirm_fulldayprice_time_text = ""; if (confirm_fulldayprice_time_type_cb.Text == "入住后") { confirm_fulldayprice_time_text = confirm_fulldayprice_time_tb.Text; } else { confirm_fulldayprice_time_text = confirm_fulldayprice_time_hour_cb.Text + ":" + confirm_fulldayprice_time_minute_cb.Text; } string add_fullday_time_text = ""; if (addprice_fullday_type_cb.Text == "超过退房时间") { add_fullday_time_text = add_fullday_time_tb.Text; } else { add_fullday_time_text = add_fullday_time_hour_cb.Text + ":" + add_fullday_time_minute_cb.Text; } string confirm_add_fullday_time_text = ""; if (confirm_addprice_fullday_type_cb.Text == "超过退房时间") { confirm_add_fullday_time_text = confirm_add_fullday_time_tb.Text; } else { confirm_add_fullday_time_text = confirm_add_fullday_time_hour_cb.Text + ":" + confirm_add_fullday_time_minute_cb.Text; } if (radiobutton3.IsChecked == true) { starthalfprice_time_tb.Text = _24rotate_startprice_validtime_tb.Text; startprice_time_tb.Text = _24rorate_fullprice_time_tb.Text; } ValueRule_fullday valueRule_Fullday = new ValueRule_fullday() { ID = Guid.NewGuid(), name = name.Text, describe = describe.Text, exitroom_type = exitroom_type_text, exitroom_time = exitroom_time_text, starthalfprice_time = starthalfprice_time_tb.Text, startprice_time = startprice_time_tb.Text, confirm_fulldayprice_time_type = confirm_fulldayprice_time_type_cb.Text, confirm_fulldayprice_time = confirm_fulldayprice_time_text, after_exitroom_charge_time = after_exitroom_charge_time_tb.Text, after_exitroom_charge_type = after_exitroom_charge_type_cb.Text, IsSeal = IsSealText, addprice_fullday_type = addprice_fullday_type_cb.Text, add_fullday_time = add_fullday_time_text, confirm_addprice_fullday_type = confirm_addprice_fullday_type_cb.Text, confirm_add_fullday_time = confirm_add_fullday_time_text, _24rotate_startprice_validtime = _24rotate_startprice_validtime_tb.Text, _24rorate_fullprice_time = _24rorate_fullprice_time_tb.Text, IsUse = true, }; using (RetailContext context = new RetailContext()) { context.ValueRule_fulldays.Add(valueRule_Fullday); context.SaveChanges(); } (thispage.DataContext as ValueRule_fullday_ViewModel).ReFlashTable(); new MessageWindow("添加成功", "添加成功", "确定", 200, 220, Cancel).ShowDialog(); } else if (type == 1) { int exitroom_type_text = 0; string exitroom_time_text = ""; bool IsSealText = false; if (radiobutton1.IsChecked == true) { exitroom_type_text = 1; exitroom_time_text = exitroom_time_hour.Text + ":" + exitroom_time_minute.Text; if (IsSeal_ckb.IsChecked == true) { IsSealText = true; } } if (radiobutton2.IsChecked == true) { exitroom_type_text = 2; exitroom_time_text = exitroom_time_hour.Text + ":" + exitroom_time_minute.Text; if (IsSeal_ckb.IsChecked == true) { IsSealText = true; } } if (radiobutton3.IsChecked == true) { exitroom_type_text = 3; if (IsSeal_ckb2.IsChecked == true) { IsSealText = true; } } string confirm_fulldayprice_time_text = ""; if (confirm_fulldayprice_time_type_cb.Text == "入住后") { confirm_fulldayprice_time_text = confirm_fulldayprice_time_tb.Text; } else { confirm_fulldayprice_time_text = confirm_fulldayprice_time_hour_cb.Text + ":" + confirm_fulldayprice_time_minute_cb.Text; } string add_fullday_time_text = ""; if (addprice_fullday_type_cb.Text == "超过退房时间") { add_fullday_time_text = add_fullday_time_tb.Text; } else { add_fullday_time_text = add_fullday_time_hour_cb.Text + ":" + add_fullday_time_minute_cb.Text; } string confirm_add_fullday_time_text = ""; if (confirm_addprice_fullday_type_cb.Text == "超过退房时间") { confirm_add_fullday_time_text = confirm_add_fullday_time_tb.Text; } else { confirm_add_fullday_time_text = confirm_add_fullday_time_hour_cb.Text + ":" + confirm_add_fullday_time_minute_cb.Text; } using (RetailContext context = new RetailContext()) { string sql = string.Format("update ValueRule_fulldays set " + "name = '{0}',describe = '{1}',exitroom_type = {2},exitroom_time = '{3}'," + "starthalfprice_time = '{4}',startprice_time = '{5}',confirm_fulldayprice_time_type = '{6}',confirm_fulldayprice_time = '{7}'," + "after_exitroom_charge_time = '{8}',after_exitroom_charge_type = '{9}',IsSeal = {10},addprice_fullday_type = '{11}'," + "add_fullday_time = '{12}',confirm_addprice_fullday_type = '{13}',confirm_add_fullday_time = '{14}',_24rotate_startprice_validtime = '{15}'," + "_24rorate_fullprice_time = '{16}',IsUse = {17} where UPPER(HEX([ID])) = '{18}'", name.Text, describe.Text, exitroom_type_text, exitroom_time_text, starthalfprice_time_tb.Text, startprice_time_tb.Text, confirm_fulldayprice_time_type_cb.Text, confirm_fulldayprice_time_text, after_exitroom_charge_time_tb.Text, after_exitroom_charge_type_cb.Text, IsSealText, addprice_fullday_type_cb.Text, add_fullday_time_text, confirm_addprice_fullday_type_cb.Text, confirm_add_fullday_time_text, _24rotate_startprice_validtime_tb.Text, _24rorate_fullprice_time_tb.Text, true, id.ConvertGuid()); context.Database.ExecuteSqlCommand(sql); context.SaveChanges(); } (thispage.DataContext as ValueRule_fullday_ViewModel).ReFlashTable(); new MessageWindow("修改成功", "修改成功", "确定", 200, 220, Cancel).ShowDialog(); } }
public void InitData() { if (type == 0) { radiobutton1.IsChecked = true; exitroom_time_hour.Text = "14"; add_fullday_time_hour_cb.Text = "00"; confirm_add_fullday_time_hour_cb.Text = "00"; confirm_fulldayprice_time_hour_cb.Text = "00"; exitroom_time_minute.Text = "00"; add_fullday_time_minute_cb.Text = "00"; confirm_add_fullday_time_minute_cb.Text = "00"; confirm_fulldayprice_time_minute_cb.Text = "00"; confirm_fulldayprice_time_type_cb.Text = "入住后"; after_exitroom_charge_type_cb.Text = "半日租"; addprice_fullday_type_cb.Text = "超过退房时间"; confirm_addprice_fullday_type_cb.Text = "超过退房时间"; } if (type == 1) { using (RetailContext context = new RetailContext()) { string sql = string.Format("select * from ValueRule_fulldays where UPPER(HEX([ID])) = '{0}'", id.ConvertGuid()); ValueRule_fullday valueRule_Fullday = context.Database.SqlQuery <ValueRule_fullday>(sql).ToList()[0]; if (valueRule_Fullday.exitroom_type == 1 || valueRule_Fullday.exitroom_type == 2) { if (valueRule_Fullday.exitroom_type == 1) { radiobutton1.IsChecked = true; } else { radiobutton2.IsChecked = true; } if (valueRule_Fullday.IsSeal == true) { IsSeal_ckb.IsChecked = true; } exitroom_time_hour.Text = valueRule_Fullday.exitroom_time.Split(':')[0]; exitroom_time_minute.Text = valueRule_Fullday.exitroom_time.Split(':')[1]; if (valueRule_Fullday.confirm_fulldayprice_time_type == "入住后") { add_fullday_time_tb.Text = valueRule_Fullday.add_fullday_time; } else if (valueRule_Fullday.confirm_fulldayprice_time_type == "固定时间") { confirm_fulldayprice_time_hour_cb.Text = valueRule_Fullday.confirm_fulldayprice_time.Split(':')[0]; confirm_fulldayprice_time_minute_cb.Text = valueRule_Fullday.confirm_fulldayprice_time.Split(':')[1]; } if (valueRule_Fullday.after_exitroom_charge_type == "半日租") { IsSeal_ckb.Visibility = Visibility.Visible; } else { IsSeal_ckb.Visibility = Visibility.Hidden; } if (valueRule_Fullday.addprice_fullday_type == "超过退房时间") { add_fullday_time_tb.Text = valueRule_Fullday.add_fullday_time; } else if (valueRule_Fullday.addprice_fullday_type == "固定时间") { add_fullday_time_hour_cb.Text = valueRule_Fullday.add_fullday_time.Split(':')[0]; add_fullday_time_minute_cb.Text = valueRule_Fullday.add_fullday_time.Split(':')[1]; } if (valueRule_Fullday.confirm_addprice_fullday_type == "超过退房时间") { confirm_add_fullday_time_tb.Text = valueRule_Fullday.confirm_add_fullday_time; } else if (valueRule_Fullday.confirm_addprice_fullday_type == "固定时间") { confirm_add_fullday_time_hour_cb.Text = valueRule_Fullday.confirm_add_fullday_time.Split(':')[0]; confirm_add_fullday_time_minute_cb.Text = valueRule_Fullday.confirm_add_fullday_time.Split(':')[1]; } } else { radiobutton3.IsChecked = true; if (valueRule_Fullday.IsSeal == true) { IsSeal_ckb2.IsChecked = true; } _24rotate_startprice_validtime_tb.Text = valueRule_Fullday._24rotate_startprice_validtime; _24rorate_fullprice_time_tb.Text = valueRule_Fullday._24rorate_fullprice_time; } confirm_fulldayprice_time_type_cb.Text = valueRule_Fullday.confirm_fulldayprice_time_type; after_exitroom_charge_type_cb.Text = valueRule_Fullday.after_exitroom_charge_type; addprice_fullday_type_cb.Text = valueRule_Fullday.addprice_fullday_type; confirm_addprice_fullday_type_cb.Text = valueRule_Fullday.confirm_addprice_fullday_type; starthalfprice_time_tb.Text = valueRule_Fullday.starthalfprice_time; startprice_time_tb.Text = valueRule_Fullday.startprice_time; confirm_fulldayprice_time_tb.Text = valueRule_Fullday.confirm_fulldayprice_time; after_exitroom_charge_time_tb.Text = valueRule_Fullday.after_exitroom_charge_time; name.Text = valueRule_Fullday.name; describe.Text = valueRule_Fullday.describe; } } }