public ftmEntityRelationshipTailDataMenu(int EntityRelationshipTailDataMenu, int relationshipTailID)
{
InitializeComponent();
EntityRelationshipTail = bizEntityRelationshipTail.GetEntityRelationshipTail(MyProjectManager.GetMyProjectManager.GetRequester(), relationshipTailID);
// BizTableDrivedEntity biz = new BizTableDrivedEntity();
// var entity = biz.GetTableDrivedEntity(MyProjectManager.GetMyProjectManager.GetRequester(), EntityID, EntityColumnInfoType.WithSimpleColumns, EntityRelationshipInfoType.WithoutRelationships);
// if (entity.IsView)
// colRelationshipTail.IsVisible = false;
// EntityDataMenuID = entityDataMenuID;
SetItems();
if (EntityRelationshipTailDataMenu == 0)
{
Message = new EntityRelationshipTailDataMenuDTO();
ShowMessage();
}
else
{
GetEntityRelationshipTailDataMenu(EntityRelationshipTailDataMenu);
}
colDataMenu.DisplayMemberPath = "Name";
colDataMenu.SelectedValueMemberPath = "ID";
ControlHelper.GenerateContextMenu(dtgColumns);
}
private void SetColumns(EntitySearchColumnsDTO condition)
{
colColumns.DisplayMemberPath = "Name";
colColumns.SelectedValueMemberPath = "ID";
BizTableDrivedEntity biz = new BizTableDrivedEntity();
if (condition.RelationshipTailID == 0)
{
var entity = biz.GetTableDrivedEntity(MyProjectManager.GetMyProjectManager.GetRequester(), EntityID, EntityColumnInfoType.WithSimpleColumns, EntityRelationshipInfoType.WithoutRelationships);
condition.vwValueColumns = entity.Columns;;
}
else
{
var relationshipTail = bizEntityRelationshipTail.GetEntityRelationshipTail(MyProjectManager.GetMyProjectManager.GetRequester(), condition.RelationshipTailID);
var entity = biz.GetTableDrivedEntity(MyProjectManager.GetMyProjectManager.GetRequester(), relationshipTail.TargetEntityID, EntityColumnInfoType.WithSimpleColumns, EntityRelationshipInfoType.WithoutRelationships);
condition.vwValueColumns = entity.Columns;
}
}
private void ColDataGridRelTargetDataMenuSetting_EditItemClicked(object sender, EditItemClickEventArg e)
{
if (e.DataConext is DataMenuDataViewRelationshipDTO)
{
var context = e.DataConext as DataMenuDataViewRelationshipDTO;
if (context.RelationshipTailID != 0)
{
var tail = bizEntityRelationshipTail.GetEntityRelationshipTail(MyProjectManager.GetMyProjectManager.GetRequester(), context.RelationshipTailID);
frmDataMenuSetting frm = new frmDataMenuSetting(tail.TargetEntityID, context.TargetDataMenuSettingID);
MyProjectManager.GetMyProjectManager.ShowDialog(frm, "رابطه های مرتبط");
frm.DataUpdated += (sender1, e1) => Frm_TailSelected(sender1, e1, sender as MyStaticLookup, context);
}
}
else if (e.DataConext is DataMenuGridViewRelationshipDTO)
{
var context = e.DataConext as DataMenuGridViewRelationshipDTO;
var tail = bizEntityRelationshipTail.GetEntityRelationshipTail(MyProjectManager.GetMyProjectManager.GetRequester(), context.RelationshipTailID);
frmDataMenuSetting frm = new frmDataMenuSetting(tail.TargetEntityID, context.TargetDataMenuSettingID);
MyProjectManager.GetMyProjectManager.ShowDialog(frm, "رابطه های مرتبط");
frm.DataUpdated += (sender1, e1) => Frm_TailSelected(sender1, e1, sender as MyStaticLookup, context);
}
}
private void SetSubListReports(EntityListReportSubsDTO subReport)
{
if (subReport.EntityRelationshipTailID != 0)
{
colSubListReport.DisplayMemberPath = "ReportTitle";
colSubListReport.SelectedValueMemberPath = "ID";
var relationshipTail = bizEntityRelationshipTail.GetEntityRelationshipTail(MyProjectManager.GetMyProjectManager.GetRequester(), subReport.EntityRelationshipTailID);
var listReports = bizEntityListReport.GetEntityListReports(MyProjectManager.GetMyProjectManager.GetRequester(), relationshipTail.TargetEntityID);
ObservableCollection <EntityListReportDTO> list = new ObservableCollection <EntityListReportDTO>();
listReports.ForEach(x => list.Add(x));
subReport.vwListReports = listReports;
// colSubListReport.ItemsSourceBinding = new Binding("vwListReports");
}
}
private void SetLetterRelationshipTemplates(LetterTemplateRelationshipFieldDTO field)
{
if (field.RelationshipTailID != 0)
{
if (field.RelationshipTail == null || field.RelationshipTail.ID != field.RelationshipTailID)
{
field.RelationshipTail = bizEntityRelationshipTail.GetEntityRelationshipTail(MyProjectManager.GetMyProjectManager.GetRequester(), field.RelationshipTailID);
}
field.tmpPartialLetterTemplates = bizLetterTemplate.GetPartialLetterTemplates(MyProjectManager.GetMyProjectManager.GetRequester(), field.RelationshipTail.TargetEntityID);
}
else
{
field.tmpPartialLetterTemplates = new List <PartialLetterTemplateDTO>();
field.RelationshipTail = null;
}
}
private void SetReportDetails(DR_Requester requester, Report report, List <ColumnSizeLocation> columnsSizeLocation)
{
bool hasSub = ListReportReportDTO.EntityListReportSubs.Any();
var detail = new Telerik.Reporting.DetailSection();
detail.Height = Telerik.Reporting.Drawing.Unit.Cm(0.5);
detail.Name = "detail";
ReportStyles.SetReportDetailStyle(detail.Style);
report.Items.Add(detail);
Panel panel = new Panel();
panel.Width = reportWidth;
ReportStyles.SetDetailPanelStyle(panel.Style, hasSub);
detail.Items.Add(panel);
//سکوریتی بروی ستوها اعمال شود
var columns = ListReportReportDTO.EntityListView.EntityListViewAllColumns;
int index = 0;
foreach (var column in columns)
{
if (ListReportReportDTO.ReportGroups != null)
{
if (ListReportReportDTO.ReportGroups.Any(x => x.ListViewColumnID == column.ID))
{
continue;
}
}
var columnTextbox = new TextBox();
columnTextbox.CanGrow = false;
columnTextbox.Name = column.Column.Name;
ReportStyles.SetDetailTextboxStyle(columnTextbox.Style);
var columnSizeLocation = columnsSizeLocation.First(x => x.LictViewColumnID == column.ID);
columnTextbox.Width = columnSizeLocation.Width;
columnTextbox.Location = new PointU(columnSizeLocation.XLocation - Unit.Cm(0.0), Unit.Cm(0));
columnTextbox.Height = detail.Height;
//var columnName = "";
//if (column.RelationshipTailID == 0)
//{
// columnName = column.Column.Name + "0";// + "'";
//}
//else
//{
//}
columnTextbox.Value = string.Format("= Fields.{0}", column.RelativeColumnName);
panel.Items.Add(columnTextbox);
index++;
}
int subIndex = 0;
foreach (var subDTO in ListReportReportDTO.EntityListReportSubs)
{
if (CheckSubReportIsRepeated(subDTO))
{
continue;
}
SubReport subReport = new SubReport();
subReport.Width = reportWidth;
subReport.Top = detail.Height + Unit.Cm(subIndex * 0.5);
subIndex++;
RR_ReportSourceRequest newrequest = new RR_ReportSourceRequest(Request.Requester);
newrequest.Identity = Request.Identity;
newrequest.Name = Request.Name;
var tail = bizEntityRelationshipTail.GetEntityRelationshipTail(requester, subDTO.EntityRelationshipTailID);
newrequest.SearchDataItems = new DP_SearchRepository(tail.TargetEntityID);
var entityListReport = bizEntityListReport.GetEntityListReport(requester, subDTO.EntityListReportID, true);
newrequest.ReportID = entityListReport.ID;
Unit SubReportWidth = reportWidth - Unit.Cm(1);
// var relationshipTail = bizEntityRelationshipTail.GetEntityRelationshipTail(subDTO.EntityRelationshipTailID);
ListReportResolver listReportResolver = new ListReportResolver(entityListReport, newrequest, SubReportWidth, this, subDTO, ReportLevel + 1);
var subListReportSource = listReportResolver.GetListReport(requester);
subReport.ReportSource = subListReportSource;
subReport.Left = Unit.Cm(0.5);
ReportStyles.SetSubreportStyle(subReport.Style);
foreach (var relColumn in subDTO.SubsColumnsDTO)
{
var parameter = new Parameter();
parameter.Name = relColumn.ParentEntityListViewColumnRelativeName;
parameter.Value = string.Format("= Fields.{0}", relColumn.ParentEntityListViewColumnRelativeName);
subReport.Parameters.Add(parameter);
}
detail.Items.Add(subReport);
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
if (txtName.Text == "")
{
MessageBox.Show("نام");
return;
}
if (lokFirstSideEntity.SelectedItem == null)
{
MessageBox.Show("موجودیت سمت اول انتخاب نشده است");
return;
}
if (lokSecondSideEntity.SelectedItem == null)
{
MessageBox.Show("موجودیت سمت دوم انتخاب نشده است");
return;
}
if (lokFirstDataMenu.SelectedItem != null)
{
Message.FirstSideDataMenuID = (int)lokFirstDataMenu.SelectedValue;
}
if (lokSecondDataMenu.SelectedItem != null)
{
Message.SecondSideDataMenuID = (int)lokSecondDataMenu.SelectedValue;
}
foreach (var item in Message.RelationshipsTails)
{
if (colRelationshipTail.ItemsSource != null && colRelationshipTail.ItemsSource is List <EntityRelationshipTailDTO> )
{
var tail = (colRelationshipTail.ItemsSource as List <EntityRelationshipTailDTO>).FirstOrDefault(x => x.ID == item.RelationshipTailID);
if (tail != null)
{
TableDrivedEntityDTO sEntity = lokSecondSideEntity.SelectedItem as TableDrivedEntityDTO;
if (tail.TargetEntityID != sEntity.ID)
{
MessageBox.Show("رشته رابطه" + " " + tail.EntityPath + " " + "با موجودیت" + " " + sEntity.Alias + " " + "در ارتباط نمی باشد");
return;
}
}
}
}
foreach (var item in Message.RelationshipsTails)
{
if (item.RelationshipTailID != 0)
{
var relationshipTail = bizEntityRelationshipTail.GetEntityRelationshipTail(MyProjectManager.GetMyProjectManager.GetRequester(), item.RelationshipTailID);
BizTableDrivedEntity bizTableDrivedEntity = new MyModelManager.BizTableDrivedEntity();
var entity = bizTableDrivedEntity.GetSimpleEntity(MyProjectManager.GetMyProjectManager.GetRequester(), relationshipTail.TargetEntityID);
var viewMessage = bizEntityRelationshipTail.CheckTailHasRelationshipWithView(relationshipTail);
if (viewMessage != "")
{
var message = "اشکال در تعریف لینک داده با موجودیت" + " " + string.IsNullOrEmpty(relationshipTail.TargetEntityAlias);
message += Environment.NewLine + "در رشته رابطه ارتباط با نمای" + " " + viewMessage + " " + "امکان پذیر نمی باشد";
MessageBox.Show(message);
return;
}
}
}
var firstEntity = lokFirstSideEntity.SelectedItem as TableDrivedEntityDTO;
var secondEntity = lokSecondSideEntity.SelectedItem as TableDrivedEntityDTO;
if (firstEntity.ServerID != secondEntity.ServerID)
{
BizDatabase bizDatabase = new BizDatabase();
if (!bizDatabase.LinkedServerExists(firstEntity.ServerID, secondEntity.ServerID))
{
MessageBox.Show("ارتباط لینک سرور بین موجودیت طرف اول و دوم وجود ندارد");
return;
}
}
foreach (var item in Message.RelationshipsTails)
{
if (item.RelationshipTailID != 0)
{
var relationshipTail = bizEntityRelationshipTail.GetEntityRelationshipTail(MyProjectManager.GetMyProjectManager.GetRequester(), item.RelationshipTailID);
var linkedServerMessage = bizEntityRelationshipTail.CheckRelationshipsLinkedServers(relationshipTail);
if (linkedServerMessage != "")
{
var message = "اشکال در رشته رابطه" + " " + string.IsNullOrEmpty(relationshipTail.EntityPath);
message += Environment.NewLine + linkedServerMessage;
MessageBox.Show(message);
return;
}
}
}
Message.NotJointEntities = chkNotJoint.IsChecked == true;
Message.ReportTitle = txtName.Text;
if (Message.ID == 0)
{
Message.TableDrivedEntityID = (int)lokFirstSideEntity.SelectedValue;
Message.SecondSideEntityID = (int)lokSecondSideEntity.SelectedValue;
}
Message.ID = bizDataLink.UpdateDataLink(Message);
MessageBox.Show("اطلاعات ثبت شد");
if (Updated != null)
{
Updated(this, new MyProject_WPF.UpdatedEventArg()
{
ID = Message.ID
});
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
if (txtName.Text == "")
{
MessageBox.Show("نام");
return;
}
if (lokFirstSideEntity.SelectedItem == null)
{
MessageBox.Show("موجودیت سمت اول انتخاب نشده است");
return;
}
foreach (var item in Message.RelationshipsTails)
{
if (item.RelationshipTailID != 0)
{
var relationshipTail = bizEntityRelationshipTail.GetEntityRelationshipTail(MyProjectManager.GetMyProjectManager.GetRequester(), item.RelationshipTailID);
BizTableDrivedEntity bizTableDrivedEntity = new MyModelManager.BizTableDrivedEntity();
var entity = bizTableDrivedEntity.GetSimpleEntity(MyProjectManager.GetMyProjectManager.GetRequester(), relationshipTail.TargetEntityID);
var viewMessage = bizEntityRelationshipTail.CheckTailHasRelationshipWithView(relationshipTail);
if (viewMessage != "")
{
var message = "اشکال در تعریف لینک داده با موجودیت" + " " + string.IsNullOrEmpty(relationshipTail.TargetEntityAlias);
message += Environment.NewLine + "در رشته رابطه ارتباط با نمای" + " " + viewMessage + " " + "امکان پذیر نمی باشد";
MessageBox.Show(message);
return;
}
}
}
foreach (var item in Message.RelationshipsTails)
{
if (item.RelationshipTailID != 0)
{
var relationshipTail = bizEntityRelationshipTail.GetEntityRelationshipTail(MyProjectManager.GetMyProjectManager.GetRequester(), item.RelationshipTailID);
var linkedServerMessage = bizEntityRelationshipTail.CheckRelationshipsLinkedServers(relationshipTail);
if (linkedServerMessage != "")
{
var message = "اشکال در رشته رابطه" + " " + string.IsNullOrEmpty(relationshipTail.EntityPath);
message += Environment.NewLine + linkedServerMessage;
MessageBox.Show(message);
return;
}
}
}
Message.ReportTitle = txtName.Text;
if (lokFirstDataMenu.SelectedItem != null)
{
Message.FirstSideDataMenuID = (int)lokFirstDataMenu.SelectedValue;
}
Message.TableDrivedEntityID = (int)lokFirstSideEntity.SelectedValue;
Message.NotJointEntities = chkNotJoint.IsChecked == true;
Message.ID = bizGraph.UpdateGraph(Message);
MessageBox.Show("اطلاعات ثبت شد");
if (Updated != null)
{
Updated(this, new MyProject_WPF.UpdatedEventArg()
{
ID = Message.ID
});
}
}
