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;
}
