private void Gen(StringBuilder sb, string tmp, IViewInfo vwInfo)
{
string code = codeGen.Gen(tmp, vwInfo);
bool sqlLine = false;
bool sqlBegin = false;
using (StringReader sr = new StringReader(code))
{
string line;
while ((line = sr.ReadLine()) != null)
{
if (line.IndexOf(" sql = ") > -1 && sqlBegin == false)
{
sqlBegin = true;
sqlLine = true;
sb.Append(" ");
}
if (!string.IsNullOrEmpty(line) && !sqlLine)
{
sb.Append(" ");
}
sb.Append(line);
sb.Append(Environment.NewLine);
if (sqlBegin && line.EndsWith("\";"))
{
sqlBegin = false;
sqlLine = false;
}
}//while
}//using
sb.AppendLine();
}
public override void LoadDetail()
{
lblTableName.Text = "";
//lblTableDBDesc.Text = "";//db_desc
//lblTableLocalDesc.Text = "";//local_desc
txtTableNewDesc.Text = "";//new_desc
dgvSchema.Rows.Clear();
this.node = App.Instance.SelectedNode;
this.view = App.Instance.SelectedNode.Tag as IViewInfo;
if (this.view != null)
{
lblTableName.Text = this.view.RawName;
//lblTableDBDesc.Text = this.view.Description;//db_desc
//lblTableLocalDesc.Text = this.view.Attributes.ContainsKey("local_desc") ? this.view.Attributes["local_desc"] : "";//local_desc
//txtTableNewDesc.Text = this.view.Attributes.ContainsKey("new_desc") ? this.view.Attributes["new_desc"] : "";//new_desc
txtTableNewDesc.Text = this.view["local_desc"] ?? "";//local_desc
//foreach (var item in this.view.Columns)
//{
// int index = dgvSchema.Rows.Add();
// DataGridViewRow row = dgvSchema.Rows[index];
// //row.Tag = item.IsPrimaryKey;
// row.Cells[0].Value = item.RawName;
// row.Cells[1].Value = SQLHelper.GetFullSqlType(item);
// row.Cells[2].Value = item.Nullable ? true : false;
// //row.Cells[3].Value = item.Description;
// //row.Cells[4].Value = item.Attributes.ContainsKey("local_desc") ? item.Attributes["local_desc"] : "";
// //row.Cells[5].Value = item.Attributes.ContainsKey("new_desc") ? item.Attributes["new_desc"] : "";
// row.Cells[3].Value = item["local_desc"] ?? "";
//}
List<DataGridViewRow> rlist = new List<DataGridViewRow>();
foreach (var item in this.view.Columns)
{
DataGridViewTextBoxCell col1 = new DataGridViewTextBoxCell();
col1.Value = item.RawName;
DataGridViewTextBoxCell col2 = new DataGridViewTextBoxCell();
col2.Value = SQLHelper.GetFullSqlType(item);
DataGridViewCheckBoxCell col3 = new DataGridViewCheckBoxCell();
col3.Value = item.Nullable ? true : false;
DataGridViewTextBoxCell col4 = new DataGridViewTextBoxCell();
col4.Value = item["local_desc"] ?? "";
DataGridViewTextBoxCell col5 = new DataGridViewTextBoxCell();
DataGridViewRow row = new DataGridViewRow();
row.Cells.AddRange(new DataGridViewCell[] { col1, col2, col3, col4, col5 });
rlist.Add(row);
}
dgvSchema.Rows.AddRange(rlist.ToArray());
}
}
/// <summary>
/// Creates a view from a view object
/// </summary>
/// <param name="workspace">Workspace context</param>
/// <param name="view">View information</param>
public void Show( IWorkspace workspace, IViewInfo view )
{
if ( view is HostedViewInfo )
{
// Make sure the host window is visible
DockContent dockContent = m_UnhostedViewManager.Show( workspace, m_HostViewInfo );
Panel hostPanel = ( Panel )dockContent.Controls[ 0 ];
hostPanel.Controls.Clear( );
Control hostedControl = ( ( HostedViewInfo )view ).CreateControl( workspace );
hostedControl.Dock = DockStyle.Fill;
hostPanel.Controls.Add( hostedControl );
return;
}
if ( view is DockingViewInfo )
{
m_UnhostedViewManager.Show( workspace, view );
return;
}
throw new NotSupportedException( "Unsupported view type " + view.GetType( ) );
}
//private readonly string Temp_View_Model = Comm.GetTemplete("View.Model.cshtml");
//private readonly string Temp_View_Exist = Comm.GetTemplete("View.Exist.cshtml");
//private readonly string Temp_View_Get = Comm.GetTemplete("View.Get.cshtml");
//private readonly string Temp_View_GetAll = Comm.GetTemplete("View.GetAll.cshtml");
//private readonly string Temp_View_Top = Comm.GetTemplete("View.Top.cshtml");
//private readonly string Temp_View_Paged = Comm.GetTemplete("View.Paged.cshtml");
//private readonly string Temp_View_GetBytes = Comm.GetTemplete("_GetBytes.cshtml");
//private readonly string Temp_View_GetMany = Comm.GetTemplete("View._GetMany.cshtml");
public string GenDataAccessCode(string nameSpace, IViewInfo vwInfo)
{
StringBuilder sb = new StringBuilder();
sb.AppendLine("using System;");
sb.AppendLine("using System.Collections.Generic;");
sb.AppendLine("using System.Data;");
sb.AppendLine("using System.Data.SqlClient;");
sb.AppendLine("using System.Linq;");
sb.AppendLine("using System.Text;");
sb.AppendFormat("using {0};{1}", nameSpace, Environment.NewLine);
sb.AppendFormat("using {0}.Model;{1}", nameSpace, Environment.NewLine);
sb.AppendLine();
sb.AppendFormat("namespace {0}.DAL{1}", nameSpace, Environment.NewLine);
sb.AppendLine("{");
sb.AppendFormat(" public class {0}Access{1}", vwInfo.PascalName, Environment.NewLine);
sb.AppendLine(" {");
//Gen(sb, Comm.GetTemplete("View.Exist.cshtml"), vwInfo);
//Gen(sb, Comm.GetTemplete("View.Get.cshtml"), vwInfo);
//Gen(sb, Comm.GetTemplete("View.Top.cshtml"), vwInfo);
Gen(sb, Comm.GetTemplete("View.GetAll.cshtml"), vwInfo);
Gen(sb, Comm.GetTemplete("View.Paged.cshtml"), vwInfo);
if ((from col in vwInfo.Columns
where col.DbTargetType == "SqlDbType.Image" || col.DbTargetType == "SqlDbType.Binary"
|| col.DbTargetType == "SqlDbType.VarBinary" || col.DbTargetType == "SqlDbType.Timestamp"
select col).Count() > 0)
{
Gen(sb, Comm.GetTemplete("_GetBytes.cshtml"), vwInfo);
}
Gen(sb, Comm.GetTemplete("View._GetMany.cshtml"), vwInfo);
sb.AppendLine(" }");
sb.AppendLine("}");
return sb.ToString();
}
public override BUSJoinSpecification UIToBusiness(UIJoinSpecification UIEntity, TContext context, IViewInfo viewInfo, bool isNewRecord)
{
BUSJoinSpecification businessEntity = base.UIToBusiness(UIEntity, context, viewInfo, isNewRecord);
Join join = context.Joins
.AsNoTracking()
.Select(j => new
{
id = j.Id,
name = j.Name,
joinSpecifications = j.JoinSpecifications.Select(joinSpecification => new
{
id = joinSpecification.Id,
name = joinSpecification.Name
}),
table = new
{
id = j.Table.Id,
tableColumns = j.Table.TableColumns.Select(joinColumn => new
{
id = joinColumn.Id,
name = joinColumn.Name
})
},
tableId = j.TableId,
busComp = new
{
id = j.BusCompId,
table = new
{
id = j.BusComp.Table.Id,
tableColumns = j.BusComp.Table.TableColumns.Select(joinColumn => new
{
id = joinColumn.Id,
name = joinColumn.Name
})
},
fields = j.BusComp.Fields.Select(field => new
{
id = field.Id,
name = field.Name
})
},
busCompId = j.BusCompId,
})
.Select(j => new Join
{
Id = j.id,
Name = j.name,
JoinSpecifications = j.joinSpecifications.Select(joinSpecification => new JoinSpecification
{
Id = joinSpecification.id,
Name = joinSpecification.name
}).ToList(),
Table = new Table
{
Id = j.table.id,
TableColumns = j.table.tableColumns.Select(joinColumn => new TableColumn
{
Id = joinColumn.id,
Name = joinColumn.name
}).ToList()
},
TableId = j.tableId,
BusComp = new BusinessComponent
{
Id = j.busCompId,
Table = new Table
{
Id = j.busComp.table.id,
TableColumns = j.busComp.table.tableColumns.Select(tableColumn => new TableColumn
{
Id = tableColumn.id,
Name = tableColumn.name
}).ToList()
},
Fields = j.busComp.fields.Select(field => new Field
{
Id = field.id,
Name = field.name
}).ToList()
},
BusCompId = j.busCompId,
})
.FirstOrDefault(i => i.Id.ToString() == ComponentsRecordsInfo.GetSelectedRecord("Join"));
if (join == null)
{
businessEntity.ErrorMessage = "First you need create join.";
}
else
{
// Если запись новая и она не уникальна, записывается ошибка
JoinSpecification joinSpecification = join.JoinSpecifications?.FirstOrDefault(n => n.Name == UIEntity.Name);
if (joinSpecification != null && joinSpecification.Id != UIEntity.Id)
{
businessEntity.ErrorMessage = $"Join specification with this name is already exists in join {join.Name}.";
}
else
{
// BusComp
BusinessComponent busComp = join.BusComp;
// Join
businessEntity.Join = join;
businessEntity.JoinId = join.Id;
businessEntity.BusComp = join.BusComp;
businessEntity.BusCompId = join.BusCompId;
businessEntity.Table = join.Table;
businessEntity.TableId = join.TableId;
// Source field
Field field = busComp.Fields.FirstOrDefault(n => n.Name == UIEntity.SourceFieldName);
if (field != null)
{
businessEntity.SourceField = field;
businessEntity.SourceFieldId = field.Id;
businessEntity.SourceFieldName = field.Name;
}
// Destination column
TableColumn destinationColumn = join.Table.TableColumns.FirstOrDefault(n => n.Name == UIEntity.DestinationColumnName);
if (destinationColumn != null)
{
businessEntity.DestinationColumn = destinationColumn;
businessEntity.DestinationColumnId = destinationColumn.Id;
businessEntity.DestinationColumnName = destinationColumn.Name;
}
}
}
return(businessEntity);
}
public DirectoriesListController(ToolsContext context, IScreenInfo screenInfo, IViewInfo viewInfo)
: base(context, screenInfo, viewInfo)
{
}
public PickMapController(TContext context, IViewInfo viewInfo)
: base(context, viewInfo)
{
}
public string GenPagedCode(IViewInfo vwInfo)
{
return codeGen.Gen(Comm.GetTemplete("View.Paged.cshtml"), vwInfo);
}
public TableController(GSAppContext context,
IScreenInfo screenInfo,
IViewInfo viewInfo)
: base(context, screenInfo, viewInfo)
{
}
public void StartInitialize <TContext>(IViewInfo oldViewInfo, string viewName, TContext context)
where TContext : MainContext, new()
{
// Инициализация списков
ViewBCs = new List <BusinessComponent>();
ViewApplets = new List <Applet>();
AppletsSortedByLinks = oldViewInfo == null ? new List <Applet>() : oldViewInfo.AppletsSortedByLinks;
ViewItems = new List <ViewItem>();
BOComponents = new List <BusinessObjectComponent>();
if (ActionType != ActionType.Drilldown)
{
ActionType = ActionType.InitializeView;
}
// Получение представления
View = context.Views
.AsNoTracking()
.Select(v => new
{
id = v.Id,
name = v.Name,
busObjectId = v.BusObjectId,
viewItems = v.ViewItems.Select(vi => new
{
id = vi.Id,
name = vi.Name,
sequence = vi.Sequence,
appletId = vi.AppletId,
applet = vi.Applet == null ? null : new
{
id = vi.Applet.Id,
name = vi.Applet.Name,
busCompId = vi.Applet.BusCompId
}
})
})
.Select(v => new View
{
Id = v.id,
Name = v.name,
BusObjectId = v.busObjectId,
ViewItems = v.viewItems.Select(vi => new ViewItem
{
Id = vi.id,
Name = vi.name,
Sequence = vi.sequence,
AppletId = vi.appletId,
Applet = vi.applet == null ? null : new Applet
{
Id = vi.applet.id,
Name = vi.applet.name,
BusCompId = vi.applet.busCompId
}
}).ToList()
})
.FirstOrDefault(n => n.Name == viewName);
// Получение списка элементов представления
ViewItems = View.ViewItems.OrderBy(s => s.Sequence).ToList();
// Получение бизнес объекта, на котором основано представление
ViewBO = context.BusinessObjects
.AsNoTracking()
.Select(bo => new
{
id = bo.Id,
name = bo.Name,
boComponents = bo.BusObjectComponents.Select(boc => new
{
id = boc.Id,
name = boc.Name,
busCompId = boc.BusCompId,
busComp = boc.BusComp == null ? null : new
{
id = boc.BusComp.Id,
name = boc.BusComp.Name
},
linkId = boc.LinkId,
link = boc.Link == null ? null : new
{
id = boc.Link.Id,
name = boc.Link.Name,
parentBCId = boc.Link.ParentBCId,
parentFieldId = boc.Link.ParentFieldId,
childBCId = boc.Link.ChildBCId,
childFieldId = boc.Link.ChildFieldId
}
})
})
.Select(bo => new BusinessObject
{
Id = bo.id,
Name = bo.name,
BusObjectComponents = bo.boComponents.Select(boc => new BusinessObjectComponent
{
Id = boc.id,
Name = boc.name,
BusCompId = boc.busCompId,
BusComp = boc.busComp == null ? null : new BusinessComponent
{
Id = boc.busComp.id,
Name = boc.busComp.name
},
LinkId = boc.linkId,
Link = boc.link == null ? null : new Link
{
Id = boc.link.id,
Name = boc.link.name,
ParentBCId = boc.link.parentBCId,
ParentFieldId = boc.link.parentFieldId,
ChildBCId = boc.link.childBCId,
ChildFieldId = boc.link.childFieldId
}
}).ToList()
})
.FirstOrDefault(i => i.Id == View.BusObjectId);
// Заполнение списков с апплетами, бизнес компонентами и маршрутизацией
ViewItems.ForEach(viewItem =>
{
// Получение апплета для каждого элемента представления
Applet applet = context.Applets
.AsNoTracking()
.Include(b => b.BusComp)
.Include(col => col.Columns)
.ThenInclude(f => f.Field)
.Include(cntr => cntr.Controls)
.ThenInclude(cnUp => cnUp.ControlUPs)
.Include(cntr => cntr.Controls)
.ThenInclude(f => f.Field)
.FirstOrDefault(i => i.Id == viewItem.AppletId);
// Добавление апплета и его бизнес компоненты в список
if (ViewApplets.IndexOf(applet) == -1)
{
ViewApplets.Add(applet);
}
if (applet.BusComp != null)
{
BusinessObjectComponent component = ViewBO.BusObjectComponents.FirstOrDefault(i => i.BusCompId == applet.BusCompId);
if (ViewBCs.IndexOf(applet.BusComp) == -1)
{
ViewBCs.Add(applet.BusComp);
}
if (BOComponents.IndexOf(component) == -1)
{
BOComponents.Add(component);
}
}
});
CurrentApplet = ViewApplets.FirstOrDefault();
CurrentRecord = GetSelectedRecord(ViewBCs.FirstOrDefault(i => i.Id == CurrentApplet?.BusCompId)?.Name);
/*BOComponents.ForEach(objectComponent =>
* {
* objectComponent.SearchSpecArgs = GetSearchSpecification(objectComponent.Name, SearchSpecTypes.SearchSpecArgs);
* objectComponent.SearchSpecification = GetSearchSpecification(objectComponent.Name, SearchSpecTypes.SearchSpecification);
* objectComponent.SearchSpecificationByParent = GetSearchSpecification(objectComponent.Name, SearchSpecTypes.SearchSpecificationByParent);
* });*/
}
public virtual void CreateController(CodeWriter cw, IViewInfo view)
{
cw.WriteLine($"// {view.Name}");
}
public void Manufacture(IViewInfo viewInfo, Dossier dossier)
{
}
public BusinessObjectController(TContext context, IViewInfo viewInfo)
: base(context, viewInfo)
{
}
public string GenModelCode(IViewInfo vwInfo)
{
return codeGen.Gen(Comm.GetTemplete("View.Model.cshtml"), vwInfo);
}
public static string BuildSQL_Paged(IViewInfo view)
{
StringBuilder sb = new StringBuilder();
int len = view.Columns.Count;
for (int i = 0; i < len; i++)
{
IColumnInfo col = view.Columns[i];
//if (col.InPrimaryKey)
// continue;
sb.AppendFormat("[{0}]", col.RawName);
if (i != len - 1)
{
sb.Append("\r\n");
sb.Append(' ', 8);
sb.Append(",");
}
}
string whereStr = "";
string sql = string.Format(@"
SELECT * FROM (
SELECT {3}
,(ROW_NUMBER() OVER ({0})) AS RowNumber
FROM [{1}] {2}
) as t
WHERE PageNumber BETWEEN @Begin AND @End
SELECT @TotalCount = COUNT(*) FROM [{1}] {2}
", GetOrderBy(view), view.RawName, whereStr, sb.ToString());
return sql;
}
public InvoiceController(GSAppContext context, IViewInfo viewInfo)
: base(context, viewInfo)
{
}
public virtual void CreateHtmlView(CodeWriter cw, IViewInfo view)
{
cw.WriteLine($"<!-- {view.Name} -->");
}
public override BUSColumn UIToBusiness(UIColumn UIEntity, TContext context, IViewInfo viewInfo, bool isNewRecord)
{
BUSColumn businessEntity = base.UIToBusiness(UIEntity, context, viewInfo, isNewRecord);
Applet applet = context.Applets
.AsNoTracking()
.Select(a => new
{
id = a.Id,
name = a.Name,
busCompId = a.BusCompId,
columns = a.Columns.Select(column => new
{
id = column.Id,
name = column.Name
})
})
.Select(a => new Applet
{
Id = a.id,
Name = a.name,
BusCompId = a.busCompId,
Columns = a.columns.Select(column => new Column
{
Id = column.id,
Name = column.name
}).ToList()
})
.FirstOrDefault(n => n.Id.ToString() == ComponentsRecordsInfo.GetSelectedRecord("Applet"));
if (applet == null)
{
businessEntity.ErrorMessage = "First you need create applet.";
}
else
{
// Если запись новая и она не уникальна, записывается ошибка
Column column = applet.Columns?.FirstOrDefault(n => n.Name == UIEntity.Name);
if (column != null && column.Id != UIEntity.Id)
{
businessEntity.ErrorMessage = $"Column with this name is already exists in applet {applet.Name}.";
}
else
{
// Applet
businessEntity.Applet = applet;
businessEntity.AppletId = applet.Id;
// BusComp
BusinessComponent busComp = context.BusinessComponents
.AsNoTracking()
.Select(bc => new
{
id = bc.Id,
name = bc.Name,
fields = bc.Fields.Select(field => new
{
id = field.Id,
name = field.Name
})
})
.Select(bc => new BusinessComponent
{
Id = bc.id,
Name = bc.name,
Fields = bc.fields.Select(field => new Field
{
Id = field.id,
Name = field.name
}).ToList()
})
.FirstOrDefault(i => i.Id == applet.BusCompId);
// BusComp
if (busComp != null)
{
businessEntity.BusComp = busComp;
businessEntity.BusCompId = busComp.Id;
// Field
Field field = busComp.Fields.FirstOrDefault(n => n.Name == UIEntity.FieldName);
if (field != null)
{
businessEntity.Field = field;
businessEntity.FieldId = field.Id;
businessEntity.FieldName = field.Name;
}
}
}
if (string.IsNullOrWhiteSpace(UIEntity.ActionType))
{
businessEntity.ActionType = ActionType.None;
}
else
{
businessEntity.ActionType = (ActionType)Enum.Parse(typeof(ActionType), UIEntity.ActionType);
}
businessEntity.Readonly = UIEntity.Readonly;
businessEntity.Header = UIEntity.Header;
businessEntity.Type = UIEntity.Type;
businessEntity.Required = UIEntity.Required;
}
return(businessEntity);
}
public override BUSPickMap UIToBusiness(UIPickMap UIEntity, TContext context, IViewInfo viewInfo, bool isNewRecord)
{
BUSPickMap businessEntity = base.UIToBusiness(UIEntity, context, viewInfo, isNewRecord);
Field field = context.Fields.FirstOrDefault(i => i.Id.ToString() == ComponentsRecordsInfo.GetSelectedRecord("Field"));
if (field == null)
{
businessEntity.ErrorMessage = "First you need create field.";
}
else
{
// Если запись новая и она не уникальна, записывается ошибка
PickMap pickMap = field.PickMaps?.FirstOrDefault(n => n.Name == UIEntity.Name);
if (pickMap != null && pickMap.Id != UIEntity.Id)
{
businessEntity.ErrorMessage = $"Field pick map with this name is already exists in field {UIEntity.Name}.";
}
else
{
businessEntity.Field = field;
businessEntity.FieldId = field.Id;
// BusComp and pickList
PickList pickList = context.PickLists
.AsNoTracking()
.Select(pl => new
{
id = pl.Id,
busComp = new
{
id = pl.BusCompId,
fields = pl.BusComp.Fields.Select(field => new
{
id = field.Id,
name = field.Name,
})
}
})
.Select(pl => new PickList
{
Id = pl.id,
BusComp = new BusinessComponent
{
Id = pl.busComp.id,
Fields = pl.busComp.fields.Select(field => new Field
{
Id = field.id,
Name = field.name
}).ToList()
}
})
.FirstOrDefault(i => i.Id == field.PickListId);
// PickList
if (pickList != null)
{
businessEntity.PickList = pickList;
businessEntity.PickListId = pickList.Id;
BusinessComponent busComp = context.BusinessComponents
.AsNoTracking()
.Select(bc => new
{
id = bc.Id,
fields = bc.Fields.Select(field => new
{
id = field.Id,
name = field.Name,
})
})
.Select(bc => new BusinessComponent
{
Id = bc.id,
Fields = bc.fields.Select(field => new Field
{
Id = field.id,
Name = field.name
}).ToList()
})
.FirstOrDefault(i => i.Id == field.BusCompId);
BusinessComponent pickListBusComp = pickList.BusComp;
businessEntity.BusComp = busComp;
businessEntity.BusCompId = busComp.Id;
if (pickListBusComp != null)
{
businessEntity.PickListBusComp = pickListBusComp;
businessEntity.PickListBusCompId = pickListBusComp.Id;
// BusCompField
Field busCompField = busComp.Fields.FirstOrDefault(n => n.Name == UIEntity.BusCompFieldName);
if (busCompField != null)
{
businessEntity.BusCompField = busCompField;
businessEntity.BusCompFieldId = busCompField.Id;
businessEntity.BusCompFieldName = busCompField.Name;
}
// PickListField
Field pickListField = pickListBusComp.Fields.FirstOrDefault(n => n.Name == UIEntity.PickListFieldName);
if (pickListField != null)
{
businessEntity.PickListField = pickListField;
businessEntity.PickListFieldId = pickListField.Id;
businessEntity.PickListFieldName = pickListField.Name;
}
}
}
businessEntity.Constrain = UIEntity.Constrain;
}
}
return(businessEntity);
}
public override dynamic GetRecord(Type type, ToolsContext context, IViewInfo viewInfo, BusinessComponent busComp, string propertyName, string propertValue)
=> base.GetRecord(Type.GetType("GSCrmTools.Controllers.ApiControllers.BusinessComponentControllers." + busComp.Routing.Split("/api/")[1].Split('/')[0] + "Controller"),
context, viewInfo, busComp, propertyName, propertValue);
public ColumnController(TContext context, IViewInfo viewInfo)
: base(context, viewInfo)
{
}
/// <summary>
/// Starts a layout
/// </summary>
/// <param name="workspace">Current workspace</param>
/// <param name="name">Layout name</param>
/// <param name="views">All views that can be shown in this layout</param>
public void BeginLayout( IWorkspace workspace, string name, IViewInfo[] views )
{
List<IViewInfo> dockingViews = new List<IViewInfo>( Array.FindAll( views, delegate( IViewInfo view ) { return view is DockingViewInfo; } ) );
dockingViews.Add( m_HostViewInfo );
m_UnhostedViewManager.BeginLayout( workspace, name, dockingViews.ToArray( ) );
}
public DataMapFieldController(GSAppContext context, IScreenInfo screenInfo, IViewInfo viewInfo)
: base(context, screenInfo, viewInfo)
{
}
public PickMapController(ToolsContext context,
IScreenInfo screenInfo,
IViewInfo viewInfo)
: base(context, screenInfo, viewInfo)
{
}
public Account_Tile_AppletController(GSAppContext context, IScreenInfo screenInfo, IViewInfo viewInfo)
: base(context, screenInfo, viewInfo)
{
}
public Create_Account_Address_Popup_AppletController(GSAppContext context, IScreenInfo screenInfo, IViewInfo viewInfo)
: base(context, screenInfo, viewInfo)
{
}
public IconController(ToolsContext context, IViewInfo viewInfo)
: base(context, viewInfo)
{
}
public DrilldownController(ToolsContext context, IScreenInfo screenInfo, IViewInfo viewInfo)
: base(context, screenInfo, viewInfo)
{
}
/// <summary>
/// Creates a view from a view object
/// </summary>
/// <param name="workspace">Workspace context</param>
/// <param name="view">View information</param>
public void Show( IWorkspace workspace, IViewInfo view )
{
Arguments.CheckNotNull( workspace, "workspace" );
DockingViewInfo dockView = Arguments.CheckedNonNullCast<DockingViewInfo>( view, "view" );
Show( workspace, dockView );
}
public static string BuildGetByWhere(IViewInfo view)
{
StringBuilder sbSql = new StringBuilder();
sbSql.Append("\r\nSELECT ");// [");
int len = view.Columns.Count;
for (int i = 0; i < len; i++)
{
IColumnInfo col = view.Columns[i];
//if (col.InPrimaryKey)
// continue;
sbSql.AppendFormat("[{0}]", col.RawName);
if (i != len - 1)
{
sbSql.Append("\r\n");
sbSql.Append(' ', 6);
sbSql.Append(",");
}
}
sbSql.Append("\r\n");
sbSql.Append(' ', 2);
sbSql.Append("FROM [");
sbSql.Append(view.Schema);
sbSql.Append("].[");
sbSql.Append(view.RawName);
sbSql.Append("]\r\n");
sbSql.Append(GetOrderBy(view));
return sbSql.ToString();
}
/// <summary>
/// Registers all views available in the current layout
/// </summary>
private void RegisterViews( IViewInfo[] views )
{
if ( views == null )
{
return;
}
foreach ( IViewInfo view in views )
{
if ( view is DockingViewInfo )
{
m_Views.Add( ( DockingViewInfo )view );
}
}
}
public static string GetOrderBy(IViewInfo view)
{
IColumnInfo col = null;
//col = (from p in view.Columns
// where p.IsPrimaryKey && p.Identity
// select p).FirstOrDefault();
if (col == null)
{
col = (from p in view.Columns
where p.LanguageType == "Int32" && p.LowerName.Contains("id")
select p).FirstOrDefault();
}
if (col == null)
{
col = (from p in view.Columns
where p.LanguageType == "DateTime" && (p.LowerName.Contains("update") || p.LowerName.Contains("modif"))
select p).FirstOrDefault();
}
if (col == null)
{
col = (from p in view.Columns
where p.LanguageType == "DateTime" && (p.LowerName.Contains("create") || p.LowerName.Contains("add"))
select p).FirstOrDefault();
}
if (col == null)
{
col = view.Columns[0];
}
return "ORDER BY [" + col.RawName + "] DESC";
}
/// <summary>
/// Saves then closes the current layout before loading a new one
/// </summary>
private void SwitchLayout( IWorkspace workspace, string layoutName, IViewInfo[] views )
{
Arguments.CheckNotNull( workspace, "workspace" );
Arguments.CheckNotNullOrEmpty( layoutName, "layoutName" );
SaveLayout( );
CloseAllViews( );
m_LayoutName = layoutName;
RegisterViews( views );
LoadLayout( workspace );
SetupViewShowCommands( workspace, views );
}
public override BUSControlUP UIToBusiness(UIControlUP UIEntity, TContext context, IViewInfo viewInfo, bool isNewRecord)
{
BUSControlUP businessEntity = base.UIToBusiness(UIEntity, context, viewInfo, isNewRecord);
Control control = context.Controls
.AsNoTracking()
.Select(a => new
{
id = a.Id,
name = a.Name,
controlUPs = a.ControlUPs.Select(controlUP => new
{
id = controlUP.Id,
name = controlUP.Name
})
})
.Select(a => new Control
{
Id = a.id,
Name = a.name,
ControlUPs = a.controlUPs.Select(controlUP => new ControlUP
{
Id = controlUP.id,
Name = controlUP.name
}).ToList()
})
.FirstOrDefault(i => i.Id.ToString() == ComponentsRecordsInfo.GetSelectedRecord("Control"));
if (control == null)
{
businessEntity.ErrorMessage = "First you need create control.";
}
else
{
// Если запись новая и она не уникальна, записывается ошибка
ControlUP controlUP = control.ControlUPs?.FirstOrDefault(n => n.Name == UIEntity.Name);
if (controlUP != null && controlUP.Id != UIEntity.Id)
{
businessEntity.ErrorMessage = $"Control user property with this name is already exists in control {control.Name}.";
}
else
{
businessEntity.Control = control;
businessEntity.ControlId = control.Id;
}
}
return(businessEntity);
}
/// <summary>
/// Starts a layout
/// </summary>
/// <param name="workspace">Current workspace</param>
/// <param name="name">Layout name</param>
/// <param name="views">All views that can be displayed in this layout</param>
public void BeginLayout( IWorkspace workspace, string name, IViewInfo[] views )
{
SwitchLayout( workspace, name, views );
}
public override IEnumerable <ValidationResult> DataBUSValidate(SysInvoice_1 dataEntity, SysInvoice_2 businessEntity, IViewInfo viewInfo, GSAppContext context)
{
List <ValidationResult> result = base.DataBUSValidate(dataEntity, businessEntity, viewInfo, context).ToList();
Applet currentApplet = viewInfo.CurrentPopupApplet ?? viewInfo.CurrentApplet;
return(result);
}
public void Initialize()
{
this.storeFilePath = Path.Combine(Path.GetTempPath(), Path.GetTempFileName());
var viewInfoMock = new Mock <IViewInfo>();
viewInfoMock.Setup(x => x.Id).Returns(Guid.NewGuid());
viewInfoMock.Setup(e => e.Elements)
.Returns(new List <IAbstractElementInfo>
{
Mocks.Of <IElementInfo>().First(e => e.Id == Guid.NewGuid() && e.Cardinality == Cardinality.OneToOne && e.AutoCreate == true),
Mocks.Of <ICollectionInfo>().First(e => e.Id == Guid.NewGuid() && e.Cardinality == Cardinality.OneToOne && e.AutoCreate == true),
Mocks.Of <IElementInfo>().First(e => e.Id == Guid.NewGuid() && e.Cardinality == Cardinality.ZeroToMany)
});
viewInfoMock.Setup(x => x.ExtensionPoints)
.Returns(new List <IExtensionPointInfo>
{
Mocks.Of <IExtensionPointInfo>().First(e => e.Id == Guid.NewGuid() && e.Cardinality == Cardinality.OneToOne && e.AutoCreate == true && e.RequiredExtensionPointId == "ext_1"),
Mocks.Of <IExtensionPointInfo>().First(e => e.Id == Guid.NewGuid() && e.Cardinality == Cardinality.ZeroToMany && e.RequiredExtensionPointId == "ext_2"),
});
this.viewInfo = viewInfoMock.Object;
var providedExtension1 = Mocks.Of <IProvidedExtensionPointInfo>().First(x => x.ExtensionPointId == "ext_1");
var extensionPoint1 = Mocks.Of <IInstalledToolkitInfo>().First(x =>
x.Id == "ext_toolkit_1" &&
x.Schema.Pattern.Id == Guid.NewGuid() &&
x.Schema.Pattern.ExtensionId == "ext_toolkit_1" &&
x.Schema.Pattern.ProvidedExtensionPoints == new[] { providedExtension1 });
var providedExtension2 = Mocks.Of <IProvidedExtensionPointInfo>().First(x => x.ExtensionPointId == "ext_2");
var extensionPoint2 = Mocks.Of <IInstalledToolkitInfo>().First(x =>
x.Id == "ext_toolkit_2" &&
x.Schema.Pattern.Id == Guid.NewGuid() &&
x.Schema.Pattern.ExtensionId == "ext_toolkit_2" &&
x.Schema.Pattern.ProvidedExtensionPoints == new[] { providedExtension2 });
var toolkit = Mocks.Of <IInstalledToolkitInfo>().First(x =>
x.Id == "test_toolkit" &&
x.Schema.Pattern.Id == Guid.NewGuid() &&
x.Schema.Pattern.Views == new[] { viewInfo } &&
x.Schema.Pattern.ProvidedExtensionPoints == new[] { providedExtension1, providedExtension2 });
var patternManager = new Mock <IPatternManager>();
patternManager.Setup(x => x.InstalledToolkits)
.Returns(new[] { toolkit, extensionPoint1, extensionPoint2 });
var serviceProvider = new Mock <IServiceProvider>();
serviceProvider.Setup(x => x.GetService(typeof(IPatternManager)))
.Returns(patternManager.Object);
using (var store = new Microsoft.VisualStudio.Modeling.Store(serviceProvider.Object, typeof(Microsoft.VisualStudio.Modeling.CoreDomainModel), typeof(ProductStateStoreDomainModel)))
using (var tx = store.TransactionManager.BeginTransaction())
{
var productStore = store.ElementFactory.CreateElement <ProductState>();
var view = productStore
.CreateProduct(x => { x.ExtensionId = "test_toolkit"; x.DefinitionId = toolkit.Schema.Pattern.Id; })
.CreateView(x => x.DefinitionId = this.viewInfo.Id);
this.viewId = view.Id;
view.CreateElement(x => x.DefinitionId = this.viewInfo.Elements.ElementAt(2).Id);
view.CreateElement(x => x.DefinitionId = this.viewInfo.Elements.ElementAt(2).Id);
view.CreateExtension(x => { x.DefinitionId = extensionPoint1.Schema.Pattern.Id; x.ExtensionId = extensionPoint1.Schema.Pattern.ExtensionId; });
view.CreateExtension(x => { x.DefinitionId = extensionPoint2.Schema.Pattern.Id; x.ExtensionId = extensionPoint2.Schema.Pattern.ExtensionId; });
view.CreateExtension(x => { x.DefinitionId = extensionPoint2.Schema.Pattern.Id; x.ExtensionId = extensionPoint2.Schema.Pattern.ExtensionId; });
ProductStateStoreSerializationHelper.Instance.SaveModel(new Microsoft.VisualStudio.Modeling.SerializationResult(), productStore, this.storeFilePath);
tx.Commit();
}
this.store = new Microsoft.VisualStudio.Modeling.Store(serviceProvider.Object, typeof(Microsoft.VisualStudio.Modeling.CoreDomainModel), typeof(ProductStateStoreDomainModel));
}
public AppletInfo(IViewInfo viewInfo)
{
this.viewInfo = viewInfo;
}
public ViewController(ToolsContext context, IViewInfo viewInfo, IViewInfoUI viewInfoUI)
: base(context, viewInfo, viewInfoUI)
{
}
public ApplicationItemController(GSAppContext context,
IScreenInfo screenInfo,
IViewInfo viewInfo)
: base(context, screenInfo, viewInfo)
{
}
public void SetValuePropertyInfo(IViewInfo view, IColumnInfo p, ValueProperty destination)
{
SetValuePropertyInfo(view, view, p, destination);
}
public void Initialize()
{
this.storeFilePath = Path.Combine(Path.GetTempPath(), Path.GetTempFileName());
var viewInfoMock = new Mock<IViewInfo>();
viewInfoMock.Setup(x => x.Id).Returns(Guid.NewGuid());
viewInfoMock.Setup(e => e.Elements)
.Returns(new List<IAbstractElementInfo>
{
Mocks.Of<IElementInfo>().First(e => e.Id == Guid.NewGuid() && e.Cardinality == Cardinality.OneToOne && e.AutoCreate == true),
Mocks.Of<ICollectionInfo>().First(e => e.Id == Guid.NewGuid() && e.Cardinality == Cardinality.OneToOne && e.AutoCreate == true),
Mocks.Of<IElementInfo>().First(e => e.Id == Guid.NewGuid() && e.Cardinality == Cardinality.ZeroToMany)
});
viewInfoMock.Setup(x => x.ExtensionPoints)
.Returns(new List<IExtensionPointInfo>
{
Mocks.Of<IExtensionPointInfo>().First(e => e.Id == Guid.NewGuid() && e.Cardinality == Cardinality.OneToOne && e.AutoCreate == true && e.RequiredExtensionPointId == "ext_1"),
Mocks.Of<IExtensionPointInfo>().First(e => e.Id == Guid.NewGuid() && e.Cardinality == Cardinality.ZeroToMany && e.RequiredExtensionPointId == "ext_2"),
});
this.viewInfo = viewInfoMock.Object;
var providedExtension1 = Mocks.Of<IProvidedExtensionPointInfo>().First(x => x.ExtensionPointId == "ext_1");
var extensionPoint1 = Mocks.Of<IInstalledToolkitInfo>().First(x =>
x.Id == "ext_toolkit_1" &&
x.Schema.Pattern.Id == Guid.NewGuid() &&
x.Schema.Pattern.ExtensionId == "ext_toolkit_1" &&
x.Schema.Pattern.ProvidedExtensionPoints == new[] { providedExtension1 });
var providedExtension2 = Mocks.Of<IProvidedExtensionPointInfo>().First(x => x.ExtensionPointId == "ext_2");
var extensionPoint2 = Mocks.Of<IInstalledToolkitInfo>().First(x =>
x.Id == "ext_toolkit_2" &&
x.Schema.Pattern.Id == Guid.NewGuid() &&
x.Schema.Pattern.ExtensionId == "ext_toolkit_2" &&
x.Schema.Pattern.ProvidedExtensionPoints == new[] { providedExtension2 });
var toolkit = Mocks.Of<IInstalledToolkitInfo>().First(x =>
x.Id == "test_toolkit" &&
x.Schema.Pattern.Id == Guid.NewGuid() &&
x.Schema.Pattern.Views == new[] { viewInfo } &&
x.Schema.Pattern.ProvidedExtensionPoints == new[] { providedExtension1, providedExtension2 });
var patternManager = new Mock<IPatternManager>();
patternManager.Setup(x => x.InstalledToolkits)
.Returns(new[] { toolkit, extensionPoint1, extensionPoint2 });
var serviceProvider = new Mock<IServiceProvider>();
serviceProvider.Setup(x => x.GetService(typeof(IPatternManager)))
.Returns(patternManager.Object);
using (var store = new Microsoft.VisualStudio.Modeling.Store(serviceProvider.Object, typeof(Microsoft.VisualStudio.Modeling.CoreDomainModel), typeof(ProductStateStoreDomainModel)))
using (var tx = store.TransactionManager.BeginTransaction())
{
var productStore = store.ElementFactory.CreateElement<ProductState>();
var view = productStore
.CreateProduct(x => { x.ExtensionId = "test_toolkit"; x.DefinitionId = toolkit.Schema.Pattern.Id; })
.CreateView(x => x.DefinitionId = this.viewInfo.Id);
this.viewId = view.Id;
view.CreateElement(x => x.DefinitionId = this.viewInfo.Elements.ElementAt(2).Id);
view.CreateElement(x => x.DefinitionId = this.viewInfo.Elements.ElementAt(2).Id);
view.CreateExtension(x => { x.DefinitionId = extensionPoint1.Schema.Pattern.Id; x.ExtensionId = extensionPoint1.Schema.Pattern.ExtensionId; });
view.CreateExtension(x => { x.DefinitionId = extensionPoint2.Schema.Pattern.Id; x.ExtensionId = extensionPoint2.Schema.Pattern.ExtensionId; });
view.CreateExtension(x => { x.DefinitionId = extensionPoint2.Schema.Pattern.Id; x.ExtensionId = extensionPoint2.Schema.Pattern.ExtensionId; });
ProductStateStoreSerializationHelper.Instance.SaveModel(new Microsoft.VisualStudio.Modeling.SerializationResult(), productStore, this.storeFilePath);
tx.Commit();
}
this.store = new Microsoft.VisualStudio.Modeling.Store(serviceProvider.Object, typeof(Microsoft.VisualStudio.Modeling.CoreDomainModel), typeof(ProductStateStoreDomainModel));
}
public static void SetDbBindColumn(IViewInfo view, IColumnInfo p, DbBindColumn dbc)
{
SetDbBindColumn(view, view, p, dbc);
}
/// <summary>
/// Setup constructor
/// </summary>
/// <param name="viewManager">View manager</param>
public DefaultCommandDockingViews( IViewManager viewManager )
{
Arguments.CheckNotNull( viewManager, "viewManager" );
m_ViewManager = viewManager;
m_RenderTargetsView = new DockingViewInfo( "Render Targets", CreateRenderTargetsViewControl, DefaultCommands.ViewRenderingRenderTargets );
}
/// <summary>
/// Adds all view columns to the current object.
/// </summary>
/// <param name="view"></param>
public void AddProperties(IViewInfo view)
{
AddProperties(view, view, view.Columns, false, false);
}
/// <summary>
/// Adds the specified list of columns from the specified view to the current object.
/// </summary>
/// <param name="view"></param>
/// <param name="selectedColumns"></param>
public void AddProperties(IViewInfo view, IList <IColumnInfo> selectedColumns)
{
AddProperties(view, view, selectedColumns, false, false);
}
public string GenExistCode(IViewInfo vwInfo)
{
return codeGen.Gen(Comm.GetTemplete("View.Exist.cshtml"), vwInfo);
}
