Разработка подсистемы документооборота в системе управления проектами сервисной компании
Дипломная работа - Компьютеры, программирование
Другие дипломы по предмету Компьютеры, программирование
20ANDpos.pos_pos_idISNULLANDpos.pg_pg_id="+listPos_group[j].pg_id+"ANDpos.cs_cs_id="+((Contract_spec)mainDGV.Rows[RowForDetail].Tag).cs_id+"ORDERBYpos.order_numberasc").ConvertAll(newConverter(ConverterPositions));(int i = 0; i < listPositionsFact.Count; i++)
{nodeChild = node.Nodes.Add(listPositionsFact[i].article, listPositionsFact[i].name, listPositionsFact[i].um_um_id.short_name, listPositionsFact[i].count,[i].val_val_id.name, listPositionsFact[i].price, listPositionsFact[i].summa, listPositionsFact[i].stat_stat_id.name, listPositionsFact[i].delivery,[i].cancel, listPositionsFact[i].official);.Tag = listPositionsFact[i];(nodeChild, listPositionsFact[i].pos_id, listPositionsFact[i].post_post_id, listPositionsFact[i].pg_pg_id);
}
}
#endregion
listPos_group2=connector.getAllDataFromDB("Pos_groupASpgWHEREpg.pt_pt_id=2ANDpg.cs_cs_id="+(mainDGV.Rows[RowForDetail].TagasContract_spec).cs_id).ConvertAll(newConverter(ConverterPos_group));(int j = 0; j < listPos_group2.Count; j++)
listPositionsDocs=connector.getAllDataFromDB("PositionsASposWHEREpos.delISNULLANDpos.post_post_id=2ANDpos.pos_pos_idISNULLANDpos.pg_pg_id="+listPos_group2[j].pg_id+"ANDpos.cs_cs_id="+((Contract_spec)mainDGV.Rows[RowForDetail].Tag).cs_id+"ORDERBYpos.order_numberasc").ConvertAll(newConverter(ConverterPositions));(int i = 0; i < listPositionsDocs.Count; i++)
{nodeChild = node.Nodes.Add(listPositionsDocs[i].article, listPositionsDocs[i].name, listPositionsDocs[i].um_um_id.short_name, listPositionsDocs[i].count,[i].val_val_id.name, listPositionsDocs[i].price, listPositionsDocs[i].summa, listPositionsDocs[i].stat_stat_id.name, listPositionsDocs[i].delivery,[i].cancel, listPositionsDocs[i].official);.Tag = listPositionsDocs[i];(nodeChild, listPositionsDocs[i].pos_id, listPositionsDocs[i].post_post_id, listPositionsDocs[i].pg_pg_id);
}
}
#endregion
}= true;
}void NodeCellsToTextBoxCells(TreeGridNode treeGridNode)
{(int i = 1; i < treeGridNode.Cells.Count; i++)//Заполнение пустыми ячейками строки группы
{.Cells[i] = new DataGridViewTextBoxCell();.Cells[i].Value = "";.Cells[i].ReadOnly = true;
}
}
//Рекурсивно добавляем потомков в деревоvoid recursionAddingNodes(TreeGridNode node, int id, Pos_type pos_type, Pos_group pos_group)
listPositionsChildren=connector.getAllDataFromDB("PositionsASposWHEREpos.delISNULLANDpos.post_post_id="+pos_type.pos_type_id+"ANDpos.pg_pg_id="+pos_group.pg_id+"ANDpos.pos_pos_id="+id+"ORDERBYpos.order_numberasc").ConvertAll(newConverter(ConverterPositions));(int j = 0; j < listPositionsChildren.Count; j++)
{nodeChild = node.Nodes.Add(listPositionsChildren[j].article, listPositionsChildren[j].name, listPositionsChildren[j].um_um_id.short_name, listPositionsChildren[j].count,[j].val_val_id.name, listPositionsChildren[j].price, listPositionsChildren[j].summa, listPositionsChildren[j].stat_stat_id.name, listPositionsChildren[j].delivery,[j].cancel, listPositionsChildren[j].official);.Tag = listPositionsChildren[j];newPos = new Positions();.name = ((Positions)nodeChild.Tag).name;
newPos.article = ((Positions)nodeChild.Tag).article;
newPos.cancel = ((Positions)nodeChild.Tag).cancel;.count = ((Positions)nodeChild.Tag).count;.delivery = ((Positions)nodeChild.Tag).delivery;.official = ((Positions)nodeChild.Tag).official;.delivery = ((Positions)nodeChild.Tag).delivery;.price = ((Positions)nodeChild.Tag).price;.summa = ((Positions)nodeChild.Tag).summa;.stat_stat_id = ((Positions)nodeChild.Tag).stat_stat_id;.prop_prop_id = ((Positions)nodeChild.Tag).prop_prop_id;.um_um_id = ((Positions)nodeChild.Tag).um_um_id;.val_val_id = ((Positions)nodeChild.Tag).val_val_id;.pg_pg_id = ((Positions)nodeChild.Parent.Tag).pg_pg_id;.post_post_id = ((Positions)nodeChild.Parent.Tag).post_post_id;.pos_pos_id = ((Positions)nodeChild.Parent.Tag);.cs_cs_id = ((Positions)nodeChild.Parent.Tag).cs_cs_id;(nodeChild, listPositionsChildren[j].pos_id, listPositionsChildren[j].post_post_id, listPositionsChildren[j].pg_pg_id);
}
}
#endregionvoid mainDGV_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{newTab = new DogovornieSpecifikaciiForm(mainDGV.Rows[e.RowIndex].Tag as Contract_spec);
(Parent as ExtendedTabControl).TabPages.Add(newTab);
(Parent as ExtendedTabControl).SelectedTab = newTab;
}
}
}
DogovornieSpecifikaciiForm.cs
using System;System.Collections.Generic;System.ComponentModel;System.Data;System.Drawing;System.Linq;System.Text;System.Windows.Forms;ControlsLibrary.Others;ControlsLibrary.NHibernate.MappingClasses;ControlsLibrary.Controls.TreeGridView;ControlsLibrary.Interfaces;Forms.FormModels
{partial class DogovornieSpecifikaciiForm : TabPage, ISessionable
{Connector connector = new Connector();
public static string desc = "Форма Ведение договорных спецификаций представляет собой...";
private bool flagCellMouseUpped = false;_spec ParentContractSpec = null;Point start;Point DraggablePanelOldLocation;Size DraggablePanelOldSize;bool dragPanelClosed = false;
#region ConstructorDogovornieSpecifikaciiForm()
{();
//Прикрепление событий.CellMouseDown += new System.Windows.Forms.DataGridViewCellMouseEventHandler(docsTgv_CellMouseDown);.CellMouseUp += new System.Windows.Forms.DataGridViewCellMouseEventHandler(docsTgv_CellMouseUp);.AllowDrop = true;.DragEnter += factTgv_DragEnter;.DragDrop += factTgv_DragDrop;.Move += draggablePanel1_Move;.MouseUp += draggablePanel1_MouseUp;
docsTgv.DragEnter += docsTgv_DragEnter;.DragDrop += docsTgv_DragDrop;
updateView(false);
//ToolTipst = new ToolTip();.SetToolTip(excelImportButton, "Импортировать в Excel");.SetToolTip(excelExportButton, "Экспортировать в Excel");.SetToolTip(DelRecordButton, "Удалить ДС");.SetToolTip(addRecordButton, "Добавить ДС");.SetToolTip(closeDraggablePanelButton, "Свернуть");
}DogovornieSpecifikaciiForm(Contract_spec ParentContractSpec)
{.ParentContractSpec = ParentContractSpec;();
//Прикрепление событий.CellMouseDown += new System.Windows.Forms.DataGridViewCellMouseEventHandler(docsTgv_CellMouseDown);.CellMouseUp += new System.Windows.Forms.DataGridViewCellMouseEventHandler(docsTgv_CellMouseUp);.AllowDrop = true;.DragEnter += factTgv_DragEnter;.DragDrop += factTgv_DragDrop;.Move += draggablePanel1_Move;.MouseUp += draggablePanel1_MouseUp;
docsTgv.DragEnter += docsTgv_DragEnter;.DragDrop += docsTgv_DragDrop;
DC_NameTextBox.Text = ParentContractSpec.name;_ProjectTextBox.Text = ParentContractSpec.proj_proj_id.name_proj;_ContractTextBox.Text = ParentContractSpec.cont_cont_id.name_cont;.Value = ParentContractSpec.create_date?? new DateTime(1753,1,1);(false);
}
#endregion
#region Разные доп функции
//Превратить все ячейки группы в тип TextBoxCell
private void NodeCellsToTextBoxCells(TreeGridNode treeGridNode)
{(int