private void SelectObjects()
{
foreach (var type in typesRepo.GetQuery().OrderBy(x => x.SHORTNAME))
{
AddItem(type);
}
}
private void RefrechData()
{
foreach (var item in _repoObjSynchView.GetQuery())
{
AddRow(item);
}
}
public void RefreshData()
{
sectionBox.DisplayMember = "SECTION_";
sectionBox.ValueMember = "ID";
sectionBox.DataSource = _repoSections.GetQuery().ToList();
signDocBox.DisplayMember = "SIGN";
signDocBox.ValueMember = "ID";
var list = _repoSignDocs.GetQuery().Select(
x => new { x.SIGN, x.ID }).ToList();
list.Add(new { SIGN = string.Empty, ID = 0 });
signDocBox.DataSource = list;
boTypeBox.DisplayMember = "BOTYPENAME";
boTypeBox.ValueMember = "BOTYPE";
boTypeBox.DataSource = _repoBoTypes.GetQuery().Select(
x => new { x.BOTYPENAME, x.BOTYPE }).OrderBy(
x => x.BOTYPENAME).ToList();
ompSectionBox.DisplayMember = "SECTION";
ompSectionBox.ValueMember = "CODE";
ompSectionBox.DataSource = _repoOmpSections.GetQuery().Select(
x => new { SECTION = x.NAME, x.CODE }).OrderBy(x => x.SECTION).ToList();
paramBox.DisplayMember = "PARAM";
paramBox.ValueMember = "CODE";
paramBox.DataSource = _repoObjParams.GetQuery().Select(
x => new { PARAM = x.NAME, CODE = x.ID }).OrderBy(x => x.CODE).ToList();
}
private void OnBoTypeChanged(object sender, EventArgs e)
{
if (boTypeBox.SelectedValue == null)
{
return;
}
int boType = (int)boTypeBox.SelectedValue;
boStateBox.DisplayMember = "BOSTATENAME";
boStateBox.ValueMember = "BOSTATE";
boStateBox.DataSource = _repoBoStates.GetQuery().Where(
x => x.BOTYPE == boType).Select(
x => new { BOSTATENAME = x.NAME, BOSTATE = x.CODE }).ToList();
groupFileBox.DisplayMember = "GROUPNAME";
groupFileBox.ValueMember = "GROUPCODE";
var list = _repoAttachGroups.GetQuery().Where(
x => x.BOTYPE == boType).Select(
x => new { GROUPNAME = x.NAME, GROUPCODE = x.CODE }).ToList();
list.Add(new { GROUPNAME = string.Empty, GROUPCODE = 0 });
groupFileBox.DataSource = list;
}
private void BuildNodes(TreeNode parent)
{
foreach (var folder in foldersRepo.GetQuery().Where(x => x.F_LEVEL == (int)parent.Tag))
{
TreeNode node = new TreeNode(parent.Tag + " " + folder.F_NAME);
node.Tag = folder.F_OWNER;
parent.Nodes.Add(node);
BuildNodes(node);
}
}
private void LoadOperTypes()
{
var types = _repoOperTypes.GetQuery()
.Select(x => new { Key = x.CODE, Value = x.NAME })
.OrderBy(x => x.Value)
.ToList();
types.Add(new { Key = -1, Value = String.Empty });
operTypeBox.ValueMember = "Key";
operTypeBox.DisplayMember = "Value";
operTypeBox.DataSource = new BindingSource(types, null);
}
public void LoadData(
IViewRepository <SEPO_TASK_FOLDER_LIST> foldersRepo,
IViewRepository <SEPO_TASK_LIST> tasksRepo,
TreeNode node = null,
int parent = 0)
{
var folders = foldersRepo.GetQuery()
.Where(x => ((x.ID_PARENT == null) ? 0 : x.ID_PARENT.ID) == parent)
.OrderBy(x => x.ID);
foreach (var folder in folders)
{
TreeTaskNode childNode = new TreeTaskNode(folder.NAME, TreeTaskNodeType.Folder);
childNode.Tag = folder.ID;
childNode.ImageKey = "folder";
childNode.SelectedImageKey = "folder";
if (node == null)
{
this.Nodes.Add(childNode);
}
else
{
node.Nodes.Add(childNode);
}
LoadData(foldersRepo, tasksRepo, childNode, folder.ID);
}
var tasks = tasksRepo.GetQuery()
.Where(x => x.ID_FOLDER.ID == parent)
.OrderBy(x => x.ID);
foreach (var task in tasks)
{
TreeTaskNode taskNode = new TreeTaskNode(task.NAME, TreeTaskNodeType.File);
taskNode.Tag = task.ID;
taskNode.ImageKey = "task";
taskNode.SelectedImageKey = "task";
if (node == null)
{
this.Nodes.Add(taskNode);
}
else
{
node.Nodes.Add(taskNode);
}
}
}
public void UpdateScene(decimal id_record = -1)
{
this.Items.Clear();
var attrs = attrsRepo.GetQuery();
if (id_record != -1)
{
attrs = attrs.Where(x => x.ID_RECORD == id_record);
}
foreach (var attr in attrs)
{
AddItem(attr);
}
}
public StdFoldersView(
decimal id_record,
IViewRepository <V_SEPO_STD_TABLES> trepo,
IViewRepository <SEPO_STD_FOLDERS> frepo)
{
tablesRepo = trepo;
foldersRepo = frepo;
foreach (var table in tablesRepo.GetQuery().Where(x => x.ID_RECORD == id_record))
{
TreeNode tbl_node = new TreeNode(table.F_TABLE + " " + table.F_DESCR);
tbl_node.Tag = table.F_LEVEL;
this.Nodes.Add(tbl_node);
BuildNodes(tbl_node);
}
this.ExpandAll();
}
private void OnTFlexSectionChanged(object sender, EventArgs e)
{
if (sectionBox.SelectedValue == null)
{
return;
}
SEPO_TFLEX_SPEC_SECTIONS section = _repoSections.GetById((int)sectionBox.SelectedValue);
typeObjBox.DisplayMember = "NAME";
typeObjBox.ValueMember = "ID";
var list = _repoSectionTypes.GetQuery()
.Where(x => x.ID_SECTION == section)
.Select(x => new { ID = x.ID, NAME = x.NAME })
.ToList();
list.Add(new { ID = 0, NAME = string.Empty });
typeObjBox.DataSource = list;
}
public void UpdateScene(decimal lvl = -1, bool is_edit_items = false)
{
var schemes = schemesRepo.GetQuery();
if (lvl > -1)
{
schemes = schemes.Where(x => x.H_LEVEL == lvl);
}
if (is_edit_items)
{
schemes = schemes.Where(x => x.ISEDIT == ((is_edit_items) ? 1 : 0));
}
schemes.OrderBy(x => x.F_TABLE);
foreach (var scheme in schemes)
{
AddItem(scheme);
}
}
public LoadFixtureView(IViewRepository <V_SEPO_FIXTURE_DOCS> docsRepo, IRepository <SEPO_OSN_ALL> objRepo, string sign)
{
_docsRepo = docsRepo;
_objRepo = objRepo;
_sign = sign;
InitializeComponent();
var query = _docsRepo.GetQuery();
if (_sign != String.Empty)
{
query = query.Where(x => x.NAME == _sign);
}
query = query.OrderBy(x => x.NAME);
foreach (var obj in query)
{
DataGridViewRow row = new DataGridViewRow();
row.Tag = obj.ART_ID;
row.CreateCells(
scene,
obj.ART_ID,
obj.DOC_ID,
obj.NAME,
obj.REVISION,
obj.STATE,
obj.FILENAME,
obj.FILE_ISLOAD);
scene.Rows.Add(row);
}
scene.CellEndEdit += Scene_CellEndEdit;
}
