Разработка подсистемы документооборота в системе управления проектами сервисной компании
Дипломная работа - Компьютеры, программирование
Другие дипломы по предмету Компьютеры, программирование
s.order_number asc").ConvertAll(new Converter(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_group=connector.getAllDataFromDB("Pos_groupASpgWHEREpg.pt_pt_id=1ANDpg.cs_cs_id="+ParentContractSpec.cs_id).ConvertAll(newConverter(ConverterPos_group));(int j = 0; j < listPos_group.Count; j++)
listPositionsDocs=connector.getAllDataFromDB("PositionsASposWHEREpos.delISNULLANDpos.post_post_id=1ANDpos.pos_pos_idISNULLANDpos.pg_pg_id="+listPos_group[j].pg_id+"ANDpos.cs_cs_id="+ParentContractSpec.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
#endregion
}
#endregion
}
}
ZakupochnieSpecifikaciiForm.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.Interfaces;Forms.FormModels
{partial class ZakupochnieSpecifikaciiForm : TabPage, ISessionable
{Connector connector = new Connector();
public static string desc = "Форма ведения договоров представляет собой...";
public ZakupochnieSpecifikaciiForm()
{();
//filterPanel1.LocalDGV = unitsDGV;(false);
}
#region ConvertersStatuses ConverterStatuses(object obj)
{(Statuses)obj;
}Units_measur Converter(object obj)
{(Units_measur)obj;
}Contract_spec ConverterContract_spec(object obj)
{(Contract_spec)obj;
}Positions ConverterPositions(object obj)
{(Positions)obj;
}Propertyes ConverterPropertyes(object obj)
{(Propertyes)obj;
}
#endregion
#region Члены ISessionableConnector Connector
{
{connector;
}
{.connector = value;
}
}ISessionable SessionableTabPage
{
{this;
}
{new NotImplementedException();
}
}void updateView(bool onlyDetailTables)
{
#region Заполнение комбобоксов
//Заполнение комбобокса "Статус"
listStatuses=connector.getAllDataFromDB("Statuses").ConvertAll(newConverter(ConverterStatuses));(int i = 0; i < listStatuses.Count; i++)
{
((DataGridViewComboBoxColumn)mainDGV.Columns[9]).Items.Add(listStatuses[i].name);
}
//Заполнение комбобокса "Единица измерения"
listUnits_measur=connector.getAllDataFromDB("Units_measur").ConvertAll(newConverter(Converter));(int i = 0; i < listUnits_measur.Count; i++)
{
((DataGridViewComboBoxColumn)mainDGV.Columns[12]).Items.Add(listUnits_measur[i].short_name);
}
#endregion
listContract_spec=connector.getAllDataFromDB("Contract_spec").ConvertAll(newConverter(ConverterContract_spec));(int i = 0; i < listContract_spec.Count; i++)
listPositions=connector.getAllDataFromDB("PositionsASposWHEREpos.cs_cs_id="+listContract_spec[i].cs_id).ConvertAll(newConverter(ConverterPositions));(int j = 0; j < listPositions.Count; j++)
listPropertyes=connector.getAllDataFromDB("PropertyesASpropWHEREprop.prop_id="+listPositions[j].prop_prop_id.prop_id).ConvertAll(newConverter(ConverterPropertyes));.Rows.Add(listContract_spec[i].name, listContract_spec[i].proj_proj_id.code, listContract_spec[i].cont_cont_id.name_cont,_spec[i].create_date, listContract_spec[i].author, listContract_spec[i].client, listContract_spec[i].contractor,_spec[i].summa, listContract_spec[i].comment, listContract_spec[i].stat_stat_id.name, listPositions[j].article,[j].name, listPositions[j].um_um_id.short_name, listPositions[j].count, listPositions[j].val_val_id.name, listPositions[j].price,[j].summa, listPositions[j].delivery, listPositions[j].cancel, listPositions[j].official, listPropertyes[0].distributor,[0].price, listPropertyes[0].date_receipt, listPropertyes[0].date_delivery, listPropertyes[0].date_maturity,[0].account, listPropertyes[0].responsible);
}
}
#endregion
}
#endregion
}
}
ПРИЛОЖЕНИЕ В
Логистический процесс