public Choice_of_podrazd(SlugebZapiskaViewModal pflvm) { InitializeComponent(); flvm = pflvm; Rows = new List <ChoiceViewModal>(); List <object> tmp = Server.GetServer.DataBase("uit").ExecuteCommand("select naim from rz_for_print order by id"); foreach (string podr in tmp) { Rows.Add(new ChoiceViewModal(podr)); } main_list_box.ItemsSource = Rows; }
public void PrintSlZap(SlugebZapiskaViewModal flvm, List <ChoiceViewModal> Rows) { application = new Word.Application(); fileName = Path.GetTempFileName(); File.WriteAllBytes(fileName, Properties.Resources.sl_zap); document = application.Documents.Open(fileName); range = SearchRange("@@nom_sz"); if (range != null) { range.Text = flvm.Nom_sz; } range = SearchRange("@@poluch"); if (range != null) { range.Text = ""; } foreach (ChoiceViewModal cvm in Rows) { if (cvm.IsChecked) { range.Text += cvm.Podrazd + "\n"; } } range = SearchRange("@@date"); if (range != null) { range.Text = DateTime.Now.ToShortDateString(); } range = SearchRange("@@kontract"); if (range != null) { range.Text = flvm.SelectedKontract; } range = SearchRange("@@izdelie"); if (range != null) { range.Text = flvm.Izdelie; } range = SearchRange("@@nom_stanc"); if (range != null) { range.Text = flvm.SelectedSer_nom; } range = SearchRange("@@voin_chast"); if (range != null) { range.Text = flvm.Voin_chast; } range = SearchRange("@@nom_zak"); if (range != null) { range.Text = flvm.Nom_zak.ToString(); } range = SearchRange("@@srok_otprav"); if (range != null) { range.Text = flvm.Srok_otprav; } range = SearchRange("@@prim"); if (range != null) { range.Text = flvm.Proizv_chast; } table = document.Tables[2]; for (int i = 0; i < flvm.Izgot.Count; i++) { if (flvm.Izgot[i].Save != null) { table.Cell(table.Rows.Count, 1).Range.Text = (i + 1).ToString(); table.Cell(table.Rows.Count, 2).Range.Text = flvm.Izgot[i].SelectedCherch; table.Cell(table.Rows.Count, 3).Range.Text = flvm.Izgot[i].SelectedNaim; table.Cell(table.Rows.Count, 4).Range.Text = flvm.Izgot[i].Kolvo.ToString(); table.Cell(table.Rows.Count, 5).Range.Text = flvm.Izgot[i].Prim; if (i < flvm.Izgot.Count - 1) { table.Rows.Add(missingObj); } } } table = document.Tables[3]; for (int i = 0; i < flvm.Remont.Count; i++) { if (flvm.Remont[i].Save != null) { table.Cell(table.Rows.Count, 1).Range.Text = (i + 1).ToString(); table.Cell(table.Rows.Count, 2).Range.Text = flvm.Remont[i].SelectedCherch; table.Cell(table.Rows.Count, 3).Range.Text = flvm.Remont[i].SelectedNaim; table.Cell(table.Rows.Count, 4).Range.Text = flvm.Remont[i].Kolvo.ToString(); table.Cell(table.Rows.Count, 5).Range.Text = flvm.Remont[i].Prim; if (i < flvm.Remont.Count - 1) { table.Rows.Add(missingObj); } } } table = document.Tables[4]; for (int i = 0; i < flvm.Priobr.Count; i++) { if (flvm.Priobr[i].Save != null) { table.Cell(table.Rows.Count, 1).Range.Text = (i + 1).ToString(); table.Cell(table.Rows.Count, 2).Range.Text = flvm.Priobr[i].SelectedN_nomer; table.Cell(table.Rows.Count, 3).Range.Text = flvm.Priobr[i].SelectedCherch; table.Cell(table.Rows.Count, 4).Range.Text = flvm.Priobr[i].SelectedNaim; table.Cell(table.Rows.Count, 5).Range.Text = flvm.Priobr[i].Kolvo.ToString() + EdIzm(flvm.Priobr[i].SelectedN_nomer); table.Cell(table.Rows.Count, 6).Range.Text = flvm.Priobr[i].Prim; if (i < flvm.Priobr.Count - 1) { table.Rows.Add(missingObj); } } } table = document.Tables[5]; for (int i = 0; i < flvm.Stor_rem.Count; i++) { if (flvm.Stor_rem[i].Save != null) { table.Cell(table.Rows.Count, 1).Range.Text = (i + 1).ToString(); table.Cell(table.Rows.Count, 2).Range.Text = flvm.Stor_rem[i].SelectedCherch; table.Cell(table.Rows.Count, 3).Range.Text = flvm.Stor_rem[i].SelectedNaim; table.Cell(table.Rows.Count, 4).Range.Text = flvm.Stor_rem[i].Kolvo.ToString(); table.Cell(table.Rows.Count, 5).Range.Text = flvm.Stor_rem[i].SelectedIzgotov; table.Cell(table.Rows.Count, 6).Range.Text = flvm.Stor_rem[i].Prim; if (i < flvm.Stor_rem.Count - 1) { table.Rows.Add(missingObj); } } } foreach (Word.Paragraph paragraph in document.Paragraphs) { if (paragraph.Range.Text.Trim() == string.Empty) { paragraph.Range.Select(); application.Selection.Delete(); } } application.Visible = true; }
public SlugebZapiska(string pNom_sz, string ser_nom) { InitializeComponent(); SZVM = new SlugebZapiskaViewModal(pNom_sz, ser_nom); main_grid.DataContext = SZVM; }