public void ApplyFilter()
{
//where is my target grid?
string gridName = this["GridName"].GetValue <string>();
//look into properties to find controls for each field
BaseCriteriaCollection bcc = new BaseCriteriaCollection();
string[] ctls = this["FilterValueControls"].GetValue <string[]>();
string[] fields = this["FilterFields"].GetValue <string[]>();
string table = this["TableName"].GetValue <string>();
IProvider provider = DBCore.getInstance();
for (int i = 0; i < ctls.Length; i++)
{
string ctl = ctls[i];
string field = fields[i];
string value = (string)blockWeb[ctl].ProcessRequest("GetValue");
DBField fieldInfo = provider.GetField(table, field);
bcc.AddCriteria(field, new DynamicCriteria(field, fieldInfo.dataType, value, "="));
}
blockWeb[gridName].ProcessRequest("RefreshGrid", bcc);
WinUI.MessageBox.Show("Filter applied");
}
// Initializes the Constructor for Database keys
public AddChildren(DBCore keys, String filename, String name_spc, String checkinversion)
{
file_name = filename;
namespace_spc = name_spc;
checkin_ver = checkinversion;
thisdb = keys;
InitializeComponent();
Dictionary <int, DBElement> db = keys.GetEntireDB;
foreach (KeyValuePair <int, DBElement> entry in db)
{
String children = "";
if (entry.Value.ChilderenGetterSetter.Count() == 0)
{
children = "";
}
else
{
List <String> temp = entry.Value.ChilderenGetterSetter;
foreach (var x in temp)
{
children = children + x + ";";
}
}
Children_list.Items.Add(new Children
{
Keys = entry.Value.KeyGetterSetter,
Children_Value = children
});
}
}
private List <PagesModels> GetOnlyMenu(string userOpenId)
{
var list = new List <PagesModels>();
var userPageList = DBCore.Queryable <sy_userspages>().With(SqlWith.NoLock).Where(m => m.IsDeleted == false && m.UsersOpenId == userOpenId).ToList() ?? new List <sy_userspages>();
if (userPageList.Count > 0)
{
foreach (var item in userPageList)
{
var tempEntity = DBCore.Queryable <PagesModels>().With(SqlWith.NoLock).Where(m => m.IsDeleted == false && m.OpenId == item.PagesOpenId).First() ?? new PagesModels();
if (!string.IsNullOrWhiteSpace(tempEntity.OpenId) && !list.Contains(tempEntity))
{
list.Add(tempEntity);
}
}
}
var userRoleList = DBCore.Queryable <sy_usersroles>().With(SqlWith.NoLock).Where(m => m.IsDeleted == false && m.UsersOpenId == userOpenId).ToList() ?? new List <sy_usersroles>();
if (userRoleList.Count > 0)
{
foreach (var item in userRoleList)
{
var tempEntity = DBCore.Queryable <RolesModels>().With(SqlWith.NoLock).Where(m => m.IsDeleted == false && m.OpenId == item.RolesOpenId).First() ?? new RolesModels();
if (!string.IsNullOrWhiteSpace(tempEntity.OpenId))
{
var rolesPagesList = DBCore.Queryable <sy_rolespages>().With(SqlWith.NoLock).Where(m => m.IsDeleted == false && m.RolesOpenId == item.RolesOpenId).ToList() ?? new List <sy_rolespages>();
if (rolesPagesList.Count > 0)
{
foreach (var items in rolesPagesList)
{
var temEntity = DBCore.Queryable <PagesModels>().With(SqlWith.NoLock).Where(m => m.IsDeleted == false && m.OpenId == items.PagesOpenId).First() ?? new PagesModels();
if (!string.IsNullOrWhiteSpace(temEntity.OpenId) && !list.Contains(temEntity))
{
list.Add(temEntity);
}
}
}
}
}
}
return(list);
}
public string IsOperationCheck(string joinOpenId, string pageOpenId, string operationOpenId)
{
var list = DBCore.Queryable <sy_pagesoperations>().With(SqlWith.NoLock).Where(m => m.IsDeleted == false && m.JoinOpenId == joinOpenId && m.PagesOpenId == pageOpenId && m.OperationsOpenId == operationOpenId).ToList() ?? new List <sy_pagesoperations>();
return(list.Count > 0 ? "checked=\"checked\"" : string.Empty);
}
public string IsPageCheck(string roleOpenId, string pageOpenId)
{
var list = DBCore.Queryable <sy_rolespages>().With(SqlWith.NoLock).Where(m => m.IsDeleted == false && m.RolesOpenId == roleOpenId && m.PagesOpenId == pageOpenId).ToList() ?? new List <sy_rolespages>();
return(list.Count > 0 ? "checked=\"checked\"" : string.Empty);
}
public void BuildEntitys()
{
using var db = new DBCore(ConfigCore.Instance.DBCon).Db;
db.DbFirst.IsCreateAttribute().CreateClassFile(GetBuildPath("ChcheDomains\\DBDomain\\"), "CachesModules.Domains");
}
private void Load3DLayers2()
{
IWorkspace wsSource = GISOpr.getInstance().WorkSpace;
// 为了在Skyline下预览数据， 必须取得数据库的连接信息
DBCore db = new DBCore(true);
IList paramList = db.GetAll(typeof(Tbsysparams), "Paramid");
IPropertySet workspaceProperySet = new PropertySetClass();
foreach (Tbsysparams param in paramList)
{
if (param.Paramenname.ToUpper() == "SDESERVER")
workspaceProperySet.SetProperty("Server",param.Paramvalue);
if (param.Paramenname.ToUpper() == "SDEINSTANCE")
workspaceProperySet.SetProperty("Instance", param.Paramvalue);
if (param.Paramenname.ToUpper() == "SDEVERSION")
workspaceProperySet.SetProperty("Version", param.Paramvalue);
if (param.Paramenname.ToUpper() == "SDEUSER")
workspaceProperySet.SetProperty("User", param.Paramvalue);
if (param.Paramenname.ToUpper() == "SDEPASSWORD")
workspaceProperySet.SetProperty("Password", param.Paramvalue);
}
IWorkspaceCatalogItem itemWorkspace = new WorkspaceCatalogItem(workspaceProperySet,Hy.Catalog.Utility.enumWorkspaceType.SDE,null, "当前空间数据库");
if ((wsSource as IWorkspace2).get_NameExists(esriDatasetType.esriDTTable, "ThreeDimenLayersCache"))
{
IFeatureWorkspace fwsSource=(wsSource as IFeatureWorkspace);
ITable t3DLayers = fwsSource.OpenTable("ThreeDimenLayersCache");
ICursor cursor = t3DLayers.Search(null, true);
IRow rowLayer = cursor.NextRow();
int fNameIndex = cursor.FindField("LayerName");
int fTypeIndex = cursor.FindField("LayerType");
int f3DType = (int)enumCatalogType.FeatureClass3D;
while (rowLayer != null)
{
if (f3DType == Convert.ToInt32(rowLayer.get_Value(fTypeIndex)))
{
IFeatureClass fClass3D = fwsSource.OpenFeatureClass(rowLayer.get_Value(fNameIndex) as string);
//
ICatalogItem curItem = new FeatureClassCatalogItem((fClass3D as IDataset).FullName as IDatasetName, null);
curItem.WorkspaceItem = itemWorkspace;
TreeNode node3D = this.m_Node3D.Nodes.Add(curItem.Name);
node3D.ImageIndex = 19;
node3D.SelectedImageIndex = 19;
node3D.Tag = curItem;
}
rowLayer = cursor.NextRow();
}
}
else
{
// ParentName和Desription（以及LayerType）都保留，到支持栅格数据时可能用得到
string strSQL = @"Create Table ThreeDimenLayersCache(
LayerName varchar2(256) not null,
ParentName varchar2(256) ,
Description varchar(4000),
LayerType INTEGER default "
+ ((int)enumCatalogType.FeatureClass3D).ToString()
+ ")";
wsSource.ExecuteSQL(strSQL);
IEnumDatasetName enDatasetName = wsSource.get_DatasetNames(esriDatasetType.esriDTFeatureClass);
IDatasetName dsName3D = enDatasetName.Next();
while (dsName3D != null)
{
if ((dsName3D as IFeatureClass).ShapeType == esriGeometryType.esriGeometryMultiPatch)
{
// 存入数据库缓存并加载到树上
strSQL = string.Format("Insert into ThreeDimenLayersCache(LayerName) values('{0}')", dsName3D.Name);
wsSource.ExecuteSQL(strSQL);
//
ICatalogItem curItem = new FeatureClassCatalogItem(dsName3D, null);
curItem.WorkspaceItem = itemWorkspace;
TreeNode node3D = this.m_Node3D.Nodes.Add(curItem.Name);
node3D.ImageIndex = 19;
node3D.SelectedImageIndex = 19;
node3D.Tag = curItem;
}
dsName3D = enDatasetName.Next();
}
// FeatureDataset底下的3维FeatureClass
enDatasetName = wsSource.get_DatasetNames(esriDatasetType.esriDTFeatureDataset);
IDatasetName dsNameContainer = enDatasetName.Next();
while (dsNameContainer != null)
{
IEnumDatasetName enDsName3D = dsNameContainer.SubsetNames;
dsName3D = enDsName3D.Next();
while (dsName3D != null)
{
if (dsName3D is IFeatureClass && (dsName3D as IFeatureClass).ShapeType == esriGeometryType.esriGeometryMultiPatch)
{
// 存入数据库缓存并加载到树上
strSQL = string.Format("Insert into ThreeDimenLayersCache(LayerName) values('{0}')", dsName3D.Name);
wsSource.ExecuteSQL(strSQL);
//
ICatalogItem curItem = new FeatureClassCatalogItem(dsName3D, null);
curItem.WorkspaceItem = itemWorkspace;
TreeNode node3D = this.m_Node3D.Nodes.Add(curItem.Name);
node3D.ImageIndex = 19;
node3D.SelectedImageIndex = 19;
node3D.Tag = curItem;
}
dsName3D = enDsName3D.Next();
}
dsNameContainer = enDatasetName.Next();
}
}
m_Node3D.Expand();
}
private void Load3DLayers2()
{
IWorkspace wsSource = GISOpr.getInstance().WorkSpace;
// 为了在Skyline下预览数据， 必须取得数据库的连接信息
DBCore db = new DBCore(true);
IList paramList = db.GetAll(typeof(Tbsysparams), "Paramid");
IPropertySet workspaceProperySet = new PropertySetClass();
foreach (Tbsysparams param in paramList)
{
if (param.Paramenname.ToUpper() == "SDESERVER")
{
workspaceProperySet.SetProperty("Server", param.Paramvalue);
}
if (param.Paramenname.ToUpper() == "SDEINSTANCE")
{
workspaceProperySet.SetProperty("Instance", param.Paramvalue);
}
if (param.Paramenname.ToUpper() == "SDEVERSION")
{
workspaceProperySet.SetProperty("Version", param.Paramvalue);
}
if (param.Paramenname.ToUpper() == "SDEUSER")
{
workspaceProperySet.SetProperty("User", param.Paramvalue);
}
if (param.Paramenname.ToUpper() == "SDEPASSWORD")
{
workspaceProperySet.SetProperty("Password", param.Paramvalue);
}
}
IWorkspaceCatalogItem itemWorkspace = new WorkspaceCatalogItem(workspaceProperySet, Hy.Catalog.Utility.enumWorkspaceType.SDE, null, "当前空间数据库");
if ((wsSource as IWorkspace2).get_NameExists(esriDatasetType.esriDTTable, "ThreeDimenLayersCache"))
{
IFeatureWorkspace fwsSource = (wsSource as IFeatureWorkspace);
ITable t3DLayers = fwsSource.OpenTable("ThreeDimenLayersCache");
ICursor cursor = t3DLayers.Search(null, true);
IRow rowLayer = cursor.NextRow();
int fNameIndex = cursor.FindField("LayerName");
int fTypeIndex = cursor.FindField("LayerType");
int f3DType = (int)enumCatalogType.FeatureClass3D;
while (rowLayer != null)
{
if (f3DType == Convert.ToInt32(rowLayer.get_Value(fTypeIndex)))
{
IFeatureClass fClass3D = fwsSource.OpenFeatureClass(rowLayer.get_Value(fNameIndex) as string);
//
ICatalogItem curItem = new FeatureClassCatalogItem((fClass3D as IDataset).FullName as IDatasetName, null);
curItem.WorkspaceItem = itemWorkspace;
TreeNode node3D = this.m_Node3D.Nodes.Add(curItem.Name);
node3D.ImageIndex = 19;
node3D.SelectedImageIndex = 19;
node3D.Tag = curItem;
}
rowLayer = cursor.NextRow();
}
}
else
{
// ParentName和Desription（以及LayerType）都保留，到支持栅格数据时可能用得到
string strSQL = @"Create Table ThreeDimenLayersCache(
LayerName varchar2(256) not null,
ParentName varchar2(256) ,
Description varchar(4000),
LayerType INTEGER default "
+ ((int)enumCatalogType.FeatureClass3D).ToString()
+ ")";
wsSource.ExecuteSQL(strSQL);
IEnumDatasetName enDatasetName = wsSource.get_DatasetNames(esriDatasetType.esriDTFeatureClass);
IDatasetName dsName3D = enDatasetName.Next();
while (dsName3D != null)
{
if ((dsName3D as IFeatureClass).ShapeType == esriGeometryType.esriGeometryMultiPatch)
{
// 存入数据库缓存并加载到树上
strSQL = string.Format("Insert into ThreeDimenLayersCache(LayerName) values('{0}')", dsName3D.Name);
wsSource.ExecuteSQL(strSQL);
//
ICatalogItem curItem = new FeatureClassCatalogItem(dsName3D, null);
curItem.WorkspaceItem = itemWorkspace;
TreeNode node3D = this.m_Node3D.Nodes.Add(curItem.Name);
node3D.ImageIndex = 19;
node3D.SelectedImageIndex = 19;
node3D.Tag = curItem;
}
dsName3D = enDatasetName.Next();
}
// FeatureDataset底下的3维FeatureClass
enDatasetName = wsSource.get_DatasetNames(esriDatasetType.esriDTFeatureDataset);
IDatasetName dsNameContainer = enDatasetName.Next();
while (dsNameContainer != null)
{
IEnumDatasetName enDsName3D = dsNameContainer.SubsetNames;
dsName3D = enDsName3D.Next();
while (dsName3D != null)
{
if (dsName3D is IFeatureClass && (dsName3D as IFeatureClass).ShapeType == esriGeometryType.esriGeometryMultiPatch)
{
// 存入数据库缓存并加载到树上
strSQL = string.Format("Insert into ThreeDimenLayersCache(LayerName) values('{0}')", dsName3D.Name);
wsSource.ExecuteSQL(strSQL);
//
ICatalogItem curItem = new FeatureClassCatalogItem(dsName3D, null);
curItem.WorkspaceItem = itemWorkspace;
TreeNode node3D = this.m_Node3D.Nodes.Add(curItem.Name);
node3D.ImageIndex = 19;
node3D.SelectedImageIndex = 19;
node3D.Tag = curItem;
}
dsName3D = enDsName3D.Next();
}
dsNameContainer = enDatasetName.Next();
}
}
m_Node3D.Expand();
}
