TreeViewModal LoadTreeFromServer(int pid)
{
RowDefectViewModal tmp = Converter.ToViewModal(Server.GetServer.DataBase("uit")
.Table("select * from rz_kart_defect where id =" + pid).LoadFromServer() as List <Row_in_kart_defect>)[0];
TreeViewModal root = new TreeViewModal(tmp);
List <object> tmp_list = Server.GetServer.DataBase("uit")
.ExecuteCommand("select id from rz_kart_defect where par =" + pid);
foreach (int id in tmp_list)
{
TreeViewModal tmplist = root.Children.FirstOrDefault(x => x.Id == id);
if (tmplist == null)
{
root.Children.Add(LoadTreeFromServer(id));
}
else
{
tmplist = LoadTreeFromServer(id);
}
}
if (root.Children.Count != 0)
{
List <TreeViewModal> tmp1 = (from u in root.Children orderby u.Nom_ceh select u).ToList();
root.Children.Clear();
foreach (TreeViewModal list in tmp1)
{
root.Children.Add(list);
}
}
return(root);
}
string OboznOrNaim(RowDefectViewModal tmp)
{
if (tmp.Cherch == null)
{
return(tmp.Naim_det);
}
return(tmp.Cherch);
}
public ObservableCollection <RowDefectViewModal> InitComposition(RowDefectViewModal parent)
{
composition = new ObservableCollection <RowDefectViewModal>();
List <object> tmp = new List <object>();
tmp = Server.GetServer.DataBase("uit")
.ExecuteCommand("select ltrim(rtrim(nc)) from spkd1 where nk = '"
+ parent.Cherch_for_search + "' order by nc");
foreach (string obozn in tmp)
{
composition.Add(new RowDefectViewModal(obozn, parent));
}
return(composition);
}
private void listBox_PreviewMouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
if (e.ClickCount == 2)
{
RowDefectViewModal tmp = (sender as ListBox).SelectedItem as RowDefectViewModal;
if (Rows.FirstOrDefault(x => x.Cherch == tmp.Cherch) != null)
{
Rows.Add(new RowDefectViewModal(tmp));
}
else
{
Rows.Add(tmp);
}
IsSave = false;
}
}
public Defect_map(int pid)
{
InitializeComponent();
Id = pid;
Header = Converter.ToViewModal(Server.GetServer.DataBase("uit")
.Table("select * from rz_kart_defect where id = " + Id).LoadFromServer() as List <Row_in_kart_defect>)[0];
cap.DataContext = Header;
if (Header.Par == 0)
{
Rows = Converter.ToViewModal(Server.GetServer.DataBase("uit")
.Table("select * from rz_kart_defect where par = " + Id + " and spos_ustr = "
+ References.GetReferences.GetId("rz_spos_ustr", "Дефектация"))
.LoadFromServer() as List <Row_in_kart_defect>);
}
else
{
Rows = Converter.ToViewModal(Server.GetServer.DataBase("uit")
.Table("select * from rz_kart_defect where par = " + Id).LoadFromServer() as List <Row_in_kart_defect>);
}
main_table.ItemsSource = Rows;
listBox_sostav.ItemsSource = References.GetReferences.InitComposition(Header);
}
public ObservableCollection <RowDefectViewModal> SearchAndLoad(RowDefectViewModal parent, string order)
{
if (armsearch == null)
{
armsearch = new ObservableCollection <RowDefectViewModal>();
}
bool is_here = false;
foreach (RowDefectViewModal row in armsearch)
{
if (row.Cherch == order)
{
is_here = true;
MessageBox.Show("Чертёж уже добавлен в список");
break;
}
}
if (!is_here)
{
armsearch.Add(new RowDefectViewModal(order, parent));
}
return(armsearch);
}
public void PrintDocument(RowDefectViewModal header, ObservableCollection <RowDefectViewModal> Rows)
{
application = new Word.Application();
fileName = Path.GetTempFileName();
File.WriteAllBytes(fileName, Properties.Resources.бланк);
document = application.Documents.Open(fileName);
range = SearchRange("@@nom_zak");
if (range != null)
{
range.Text = "№ " + header.Nom_zak.ToString();
}
range = SearchRange("@@prior");
if (range != null)
{
if (header.Prior != null)
{
range.Text = header.Prior.ToString();
}
else
{
range.Text = "";
}
}
range = SearchRange("@@kolvo");
if (range != null)
{
range.Text = header.Kolvo.ToString();
}
range = SearchRange("@@ser_nom_izd");
if (range != null)
{
range.Text = "№ " + header.Ser_nom.ToString();
}
range = SearchRange("@@Cherch");
if (range != null)
{
range.Text = header.Cherch;
}
range = SearchRange("@@naim_det_1");
if (range != null)
{
range.Text = Server.GetServer.DataBase("uit")
.ExecuteCommand("select naim from rz_ser_nom_naim where ser_nom = '"
+ header.Ser_nom + "'")[0].ToString();
}
range = SearchRange("@@obozn_det");
if (range != null)
{
range.Text = header.Cherch;
}
range = SearchRange("@@naim_det_2");
if (range != null)
{
range.Text = header.Naim_det;
}
range = SearchRange("@@nom_kart");
if (range != null)
{
if (header.Par == 0)
{
range.Text = header.Nom_sz.ToString();
}
else
{
range.Text = header.Nom_kart;
}
}
table = document.Tables[1];
for (int i = 0; i < Rows.Count; i++)
{
table.Cell(table.Rows.Count, 1).Range.Text = (i + 1).ToString();
table.Cell(table.Rows.Count, 2).Range.Text = Rows[i].Cherch + " = " + Rows[i].Kolvo.ToString() + " шт" +
"\n" + Rows[i].Opis_def + "\n" + Rows[i].Opis_def_komment;
table.Cell(table.Rows.Count, 3).Range.Text = Rows[i].Prichina + "\n" + Rows[i].Prichina_komment;
table.Cell(table.Rows.Count, 4).Range.Text = Rows[i].Met_opr + "\n" + Rows[i].Met_opr_komment;
table.Cell(table.Rows.Count, 5).Range.Text = Rows[i].Teh_treb + "\n" + Rows[i].Teh_treb_komment;
table.Cell(table.Rows.Count, 6).Range.Text = Rows[i].Spos_ustr + "\n" + Rows[i].Spos_ustr_komment;
if (i < Rows.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;
}
