private void ButtonAdd_Click(object sender, RoutedEventArgs e) { MsAccess acs = new MsAccess(); string result = "0"; string sql = $@" Select nrm.nrm_id From nrm Where nrm.nrm_dt = {DatePickerNorm.SelectedDate:#M-d-yyyy#} "; result = acs.GetValueSql(sql); if (result != "0") { MessageBox.Show($@"Данные на {DatePickerNorm.SelectedDate:#M-d-yyyy#} уже есть в системе"); return; } else { sql = $@"INSERT INTO nrm (nrm_dt, stf_tn, nrm_hr, nrm_scr) SELECT {DatePickerNorm.SelectedDate:#M-d-yyyy#}, stf_tn, nrm_hr, nrm_scr FROM nrm WHERE nrm_dt = (SELECT MAX(nrm_dt) FROM nrm WHERE nrm_dt <= { DatePickerNorm.SelectedDate :#M-d-yyyy#})"; acs.GetValueSql(sql); GenerateNormsDep(); //Запись лога acs.Log(DatePickerNorm.SelectedDate.Value.ToShortDateString(), "Создание"); } }
private void editButton_Click(object sender, RoutedEventArgs e) { string dep = ((TextBlock)((StackPanel)((Button)sender).Parent).Children[0]).Text; MsAccess acs = new MsAccess(); string normDbPath = Environment.CurrentDirectory + @"\Resources\Norm.accdb"; //Uri uri = new Uri(@"pack://*****:*****@"INSERT INTO nrm (nrm_dt, stf_tn, stf_fln, pos_nm, nrm_hr, nrm_scr) IN '{normDbPath}' SELECT nrm.nrm_dt, nrm.stf_tn, stf.stf_fln, pos.pos_nm, nrm.nrm_hr, nrm.nrm_scr FROM pos INNER JOIN ((dep INNER JOIN stf ON dep.dep_id = stf.dep_id) INNER JOIN nrm ON stf.stf_tn = nrm.stf_tn) ON pos.pos_id = stf.pos_id WHERE dep.dep_mn = ""{dep}"" AND nrm.nrm_dt = {DatePickerNorm.SelectedDate:#M-d-yyyy#} ; "; acs.GetValueSql(sql); acs.PathToBase = normDbPath; acs.AccessFormsOpen("nrm"); //Подсвечиваю отдел в котором были изменения ((TextBlock)((StackPanel)((Button)sender).Parent).Children[0]).Background = Brushes.OrangeRed; ButtonUpdate.Visibility = Visibility.Visible; ButtonReset.Visibility = Visibility.Visible; _dep = dep; }