void UC_DBManager_Loaded(object sender, RoutedEventArgs e)
{
imgServerSource.Source = new BitmapImage(new Uri(System.IO.Path.Combine(App.GStrApplicationDirectory, @"Images\00000010.ico"), UriKind.RelativeOrAbsolute));
if (App.GLstConnectedServers.Count > 0)
{
TreeView tree;
for (int i = 0; i < App.GLstConnectedServers.Count; i++)
{
tree = new TreeView();
tree.SelectedItemChanged += tree_SelectedItemChanged;
TreeViewItem item = new TreeViewItem();
item.IsExpanded = true;
item.Header = App.GLstConnectedServers[i].Host;
item.DataContext = "S-" + App.GLstConnectedServers[i].Host;
item.Tag = App.GLstConnectedServers[i];
TreeViewItemProps.SetItemImageName(item, System.IO.Path.Combine(App.GStrApplicationDirectory, @"Images\00000017.ico"));
item.SetResourceReference(TreeViewItem.StyleProperty, "TreeViewItemWithImg");
tree.Items.Add(item);
BindDBInUMPServer(item);
//如果已经存在树 则删掉再加 用于刷新
if (spContent.Children.Count >= 3)
{
spContent.Children.RemoveAt(2);
}
spContent.Children.Add(tree);
tree.BorderThickness = new Thickness(0);
tree.Background = Brushes.Transparent;
}
}
}
/// <summary>
/// 绑定UMP服务器所配置的数据库
/// </summary>
/// <param name="selectedItem"></param>
void BindDBInUMPServer(TreeViewItem root)
{
ServerInfomation server = root.Tag as ServerInfomation;
List <DBInfo> lstDBs = ServerConfigOperationInServer.GetAllDBs(server.Host, server.Port);
TreeViewItem dbItem;
string strDBType = string.Empty;
for (int i = 0; i < lstDBs.Count; i++)
{
dbItem = new TreeViewItem();
switch (lstDBs[i].DbType)
{
case (int)Enums.DBType.MSSQL:
strDBType = "MSSQL";
break;
case (int)Enums.DBType.MySql:
strDBType = "MySql";
break;
case (int)Enums.DBType.Oracle:
strDBType = "Oracle";
break;
}
dbItem.Header = lstDBs[i].Host + " (" + strDBType + ")";
dbItem.DataContext = "DB-" + lstDBs[i].Host;
dbItem.Tag = lstDBs[i];
TreeViewItemProps.SetItemImageName(dbItem, System.IO.Path.Combine(App.GStrApplicationDirectory, @"Images\00000015.ico"));
dbItem.SetResourceReference(TreeViewItem.StyleProperty, "TreeViewItemWithImg");
root.Items.Add(dbItem);
}
}
private void ShowMyControlOrg(TreeViewItem ATreeViewItem, string AStrParentOrgID)
{
string LStrVerificationCode104 = string.Empty;
string LStrOrgID = string.Empty;
string LStrOrgName = string.Empty;
string LStrOrgParent = string.Empty;
string LStrImagesPath = string.Empty;
try
{
LStrImagesPath = System.IO.Path.Combine(App.GClassSessionInfo.LocalMachineInfo.StrCommonApplicationData, @"UMP.Client\Themes", App.GClassSessionInfo.ThemeInfo.Name, @"Images\S1103");
LStrVerificationCode104 = App.CreateVerificationCode(EncryptionAndDecryption.UMPKeyAndIVType.M104);
DataRow[] LDataRowOrg = App.IDataTable11006.Select("C004 = " + AStrParentOrgID);
foreach (DataRow LDataRowSingleOrg in LDataRowOrg)
{
LStrOrgID = LDataRowSingleOrg["C001"].ToString();
if (App.IDataTable11201UO.Select("C004 = " + LStrOrgID).Length <= 0)
{
continue;
}
LStrOrgName = LDataRowSingleOrg["C002"].ToString();
LStrOrgName = EncryptionAndDecryption.EncryptDecryptString(LStrOrgName, LStrVerificationCode104, EncryptionAndDecryption.UMPKeyAndIVType.M104);
TreeViewItem LTreeViewItemSubOrg = new TreeViewItem();
LTreeViewItemSubOrg.Header = LStrOrgName;
LTreeViewItemSubOrg.DataContext = LStrOrgID;
TreeViewItemProps.SetItemImageName(LTreeViewItemSubOrg, LStrImagesPath + @"\S1103004.ico");
ATreeViewItem.Items.Add(LTreeViewItemSubOrg);
ShowMyControlOrg(LTreeViewItemSubOrg, LStrOrgID);
IListrTVItemAllOrg.Add(LTreeViewItemSubOrg);
}
}
catch { }
}
private void ShowControlAgentUser(TreeViewItem ATreeViewItem, string AStrOrgID, UCTreeViewYoung AUCTreeViewYoung, string AStrAgentID)
{
string LStrUserID = string.Empty;
string LStrUserAccount = string.Empty;
string LStrUserName = string.Empty;
string LStrVerificationCode104 = string.Empty;
string LStrImagesPath = string.Empty;
LStrVerificationCode104 = App.CreateVerificationCode(EncryptionAndDecryption.UMPKeyAndIVType.M104);
LStrImagesPath = System.IO.Path.Combine(App.GClassSessionInfo.LocalMachineInfo.StrCommonApplicationData, @"UMP.Client\Themes", App.GClassSessionInfo.ThemeInfo.Name, @"Images\S1103");
DataRow[] LDataRowOrgUsers = App.IDataTable11005.Select("C006 = " + AStrOrgID, "C001 ASC");
foreach (DataRow LDataRowSingleOrgUser in LDataRowOrgUsers)
{
LStrUserID = LDataRowSingleOrgUser["C001"].ToString();
if (App.IDataTable11201UA.Select("C003 = " + LStrUserID + " AND C004 = " + AStrAgentID).Length <= 0)
{
continue;
}
LStrUserAccount = LDataRowSingleOrgUser["C002"].ToString();
LStrUserAccount = EncryptionAndDecryption.EncryptDecryptString(LStrUserAccount, LStrVerificationCode104, EncryptionAndDecryption.UMPKeyAndIVType.M104);
LStrUserName = LDataRowSingleOrgUser["C003"].ToString();
LStrUserName = EncryptionAndDecryption.EncryptDecryptString(LStrUserName, LStrVerificationCode104, EncryptionAndDecryption.UMPKeyAndIVType.M104);
TreeViewItem LTreeViewItemUser = new TreeViewItem();
LTreeViewItemUser.Header = LStrUserAccount + " (" + LStrUserName + ")";
LTreeViewItemUser.DataContext = LStrUserID;
TreeViewItemProps.SetItemImageName(LTreeViewItemUser, LStrImagesPath + @"\S1103005.png");
ATreeViewItem.Items.Add(LTreeViewItemUser);
AUCTreeViewYoung.SetItemCheckedStatus(true, LStrUserID);
}
//AUCTreeViewYoung.SetItemCheckedDisabled(false, "102" + App.GClassSessionInfo.RentInfo.Token + "00000000001");
//AUCTreeViewYoung.SetItemCheckedDisabled(false, App.GClassSessionInfo.UserInfo.UserID.ToString());
}
/// <summary>
/// 选择数据库事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void dbItem_Selected(TreeViewItem selectedItem)
{
try
{
UC_DBOperation uc_db = new UC_DBOperation(this);
spOperator.Children.Clear();
spOperator.Children.Add(uc_db);
UC_DBOpeartionDefault uc_DBOpeartionDefault = new UC_DBOpeartionDefault(this);
spOperator.Children.Add(uc_DBOpeartionDefault);
App.GCurrentDBServer = selectedItem.Tag as DBInfo;
////没有打开过 才加载语言种类
//if (selectedItem.Items.Count <= 0)
//{
selectedItem.Items.Clear();
InitTreeLanguageItem(selectedItem);
//}
TreeViewItemProps.SetItemImageName(selectedItem, System.IO.Path.Combine(App.GStrApplicationDirectory, @"Images\00000015.ico"));
DataTable dt = GetAllLanguages(selectedItem);
UC_LanguageData uc_LanData = new UC_LanguageData(dt, this);
dpData.Children.Clear();
dpData.Children.Add(uc_LanData);
//lstAllLans = uc_LanData.lstViewrSource;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message,
this.TryFindResource("ErrorMsgTitle").ToString(), MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public void ShowType212LeftSubObjects()
{
string LStrIconPngName = string.Empty;
string LStrServerData001 = string.Empty;
string LStrServerData011 = string.Empty;
string LStrServerData012 = string.Empty;
string LStrServerData013 = string.Empty;
string LStrServerData014 = string.Empty;
string LStrServerData015 = string.Empty;
string LStrServerData016 = string.Empty;
string LStrServerData017 = string.Empty;
string LStrServerData018 = string.Empty;
try
{
DataRow[] LDataRowCurrentLevelType = App.IDataTable00010.Select("C001 = 212");
LStrIconPngName = LDataRowCurrentLevelType[0]["C005"].ToString();
foreach (TreeViewItem LTreeViewItemSingleResurce in TreeViewResourceList.Items)
{
if (LTreeViewItemSingleResurce.DataContext.ToString() != "212")
{
continue;
}
CheckAndInitType212Data();
LTreeViewItemSingleResurce.Items.Clear();
DataRow[] LDataRowDECServer = App.IListDataSetReturn[1].Tables[0].Select("C001 >= 2120000000000000001 AND C001 < 2130000000000000000 AND C011 = '1'", "C012 ASC");
foreach (DataRow LDataRowSingleDecServer in LDataRowDECServer)
{
LStrServerData001 = LDataRowSingleDecServer["C001"].ToString();
LStrServerData011 = LDataRowSingleDecServer["C011"].ToString();
LStrServerData012 = LDataRowSingleDecServer["C012"].ToString();
LStrServerData013 = LDataRowSingleDecServer["C013"].ToString();
LStrServerData014 = LDataRowSingleDecServer["C014"].ToString();
LStrServerData014 = EncryptionAndDecryption.EncryptDecryptString(LStrServerData014, IStrVerificationCode104, EncryptionAndDecryption.UMPKeyAndIVType.M104);
LStrServerData015 = LDataRowSingleDecServer["C015"].ToString();
LStrServerData015 = EncryptionAndDecryption.EncryptDecryptString(LStrServerData015, IStrVerificationCode104, EncryptionAndDecryption.UMPKeyAndIVType.M104);
LStrServerData016 = LDataRowSingleDecServer["C016"].ToString();
LStrServerData016 = EncryptionAndDecryption.EncryptDecryptString(LStrServerData016, IStrVerificationCode104, EncryptionAndDecryption.UMPKeyAndIVType.M104);
LStrServerData017 = LDataRowSingleDecServer["C017"].ToString();
LStrServerData017 = EncryptionAndDecryption.EncryptDecryptString(LStrServerData017, IStrVerificationCode104, EncryptionAndDecryption.UMPKeyAndIVType.M104);
LStrServerData018 = LDataRowSingleDecServer["C018"].ToString();
LStrServerData018 = EncryptionAndDecryption.EncryptDecryptString(LStrServerData018, IStrVerificationCode104, EncryptionAndDecryption.UMPKeyAndIVType.M104);
TreeViewItem LTreeViewItemDECServer = new TreeViewItem();
LTreeViewItemDECServer.Header = LStrServerData017;
LTreeViewItemDECServer.DataContext = LStrServerData001;
TreeViewItemProps.SetItemImageName(LTreeViewItemDECServer, IStrImageFolder + @"\" + LStrIconPngName);
LTreeViewItemSingleResurce.Items.Add(LTreeViewItemDECServer);
}
LTreeViewItemSingleResurce.IsExpanded = true;
break;
}
}
catch (Exception ex) { MessageBox.Show(ex.ToString()); }
}
public void ShowSubServerFolderEnd(DataTable ADataTableFolders)
{
string LStrSingleFolder = string.Empty;
string LStrParentFolder = string.Empty;
List <string> LListStrSplitPath = new List <string>();
string LStrImagesPath = string.Empty;
try
{
string path = App.GStrApplicationDirectory.Substring(0, App.GStrApplicationDirectory.LastIndexOf("\\"));
LStrImagesPath = string.Format("Style{0}", App.GStrSeasonCode);
LStrImagesPath = System.IO.Path.Combine(path, @"Themes", LStrImagesPath, @"Images\S0001");
if (ADataTableFolders == null)
{
return;
}
if (ITreeViewItemExpand == null)
{
LStrParentFolder = string.Empty;
}
else
{
LStrParentFolder = ITreeViewItemExpand.DataContext.ToString();
}
foreach (DataRow LDataRowSingleFolder in ADataTableFolders.Rows)
{
TreeViewItem LTreeViewItemFolder = new TreeViewItem();
LStrSingleFolder = LDataRowSingleFolder[0].ToString();
if (LStrSingleFolder.Substring(0, 1) == "$")
{
continue;
}
LTreeViewItemFolder.Header = LStrSingleFolder;
LTreeViewItemFolder.Tag = "0";
LTreeViewItemFolder.DataContext = System.IO.Path.Combine(LStrParentFolder, LStrSingleFolder) + @"\";
TreeViewItemProps.SetItemImageName(LTreeViewItemFolder, LStrImagesPath + @"\S0001013.ico");
if (ITreeViewItemExpand == null)
{
TreeViewServerFolder.Items.Add(LTreeViewItemFolder);
}
else
{
ITreeViewItemExpand.Items.Add(LTreeViewItemFolder);
}
LTreeViewItemFolder.Expanded += LTreeViewItemFolder_Expanded;
}
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
finally
{
if (ITreeViewItemExpand != null)
{
ITreeViewItemExpand.IsExpanded = true;
}
}
}
public void ShowSubServerFolderEnd(DataTable ADataTableFolders)
{
string LStrSingleFolder = string.Empty;
string LStrParentFolder = string.Empty;
List <string> LListStrSplitPath = new List <string>();
string LStrImagesPath = string.Empty;
try
{
LStrImagesPath = System.IO.Path.Combine(App.GClassSessionInfo.LocalMachineInfo.StrCommonApplicationData, @"UMP.Client\Themes", App.GClassSessionInfo.ThemeInfo.Name, @"Images\S0001");
if (ADataTableFolders == null)
{
return;
}
if (ITreeViewItemExpand == null)
{
LStrParentFolder = string.Empty;
}
else
{
LStrParentFolder = ITreeViewItemExpand.DataContext.ToString();
}
foreach (DataRow LDataRowSingleFolder in ADataTableFolders.Rows)
{
TreeViewItem LTreeViewItemFolder = new TreeViewItem();
LStrSingleFolder = LDataRowSingleFolder[0].ToString();
if (LStrSingleFolder.Substring(0, 1) == "$")
{
continue;
}
LTreeViewItemFolder.Header = LStrSingleFolder;
LTreeViewItemFolder.Tag = "0";
LTreeViewItemFolder.DataContext = System.IO.Path.Combine(LStrParentFolder, LStrSingleFolder) + @"\";
TreeViewItemProps.SetItemImageName(LTreeViewItemFolder, LStrImagesPath + @"\S0001013.ico");
if (ITreeViewItemExpand == null)
{
TreeViewServerFolder.Items.Add(LTreeViewItemFolder);
}
else
{
ITreeViewItemExpand.Items.Add(LTreeViewItemFolder);
}
LTreeViewItemFolder.Expanded += LTreeViewItemFolder_Expanded;
}
}
catch { }
finally
{
if (ITreeViewItemExpand != null)
{
ITreeViewItemExpand.IsExpanded = true;
}
}
}
public void AddApplicationServer2TreeView(List <string> AListStrConnectedInfo, DataSet ADataSetServerParameters)
{
try
{
//加入根节点
TreeViewItem LTreeViewItemRoot = new TreeViewItem();
LTreeViewItemRoot.DataContext = ADataSetServerParameters;
LTreeViewItemRoot.Tag = AListStrConnectedInfo;
LTreeViewItemRoot.Name = "TVI001";
TreeViewItemProps.SetItemImageName(LTreeViewItemRoot, App.GStrApplicationDirectory + @"\Images\00000018.ico");
TreeViewServerObjects.Items.Add(LTreeViewItemRoot);
//加入服务器 证书信息
TreeViewItem LTreeViewItemCertificate = new TreeViewItem();
LTreeViewItemCertificate.DataContext = ADataSetServerParameters.Tables[0];
LTreeViewItemCertificate.Name = "TVI002";
LTreeViewItemRoot.Items.Add(LTreeViewItemCertificate);
//加入UMP.PF站点
TreeViewItem LTreeViewItemSite = new TreeViewItem();
LTreeViewItemSite.DataContext = ADataSetServerParameters.Tables[1];
LTreeViewItemSite.Name = "TVI003";
LTreeViewItemRoot.Items.Add(LTreeViewItemSite);
//加入License Server 节点
if (ADataSetServerParameters.Tables[3] != null)
{
TreeViewItem LTreeViewItemLicenseServer = new TreeViewItem();
LTreeViewItemLicenseServer.DataContext = ADataSetServerParameters.Tables[3];
LTreeViewItemLicenseServer.Name = "TVI007";
LTreeViewItemRoot.Items.Add(LTreeViewItemLicenseServer);
}
//加入 UMPDataDB 节点
TreeViewItem LTreeViewItemDataDB = new TreeViewItem();
LTreeViewItemDataDB.DataContext = ADataSetServerParameters.Tables[2];
LTreeViewItemDataDB.Name = "TVI004";
LTreeViewItemRoot.Items.Add(LTreeViewItemDataDB);
ResetTreeViewItemHeader();
LTreeViewItemRoot.IsExpanded = true;
TreeViewServerObjects.Focus();
LTreeViewItemRoot.IsSelected = true;
}
catch (Exception ex)
{
App.ShowExceptionMessage("AddApplicationServer2TreeView()\n" + ex.ToString());
}
}
private void ShowAllResourceType(TreeViewItem ATreeViewItemParent, int AIntParentType)
{
string LStrIconPngName = string.Empty;
int LIntCurrentType = 0;
try
{
if (ATreeViewItemParent == null)
{
TreeViewResourceList.Items.Clear();
}
DataRow[] LDataRowCurrentLevelType = App.IDataTable00010.Select("C002 = " + AIntParentType.ToString() + " AND C004 = '1'", "C003 ASC");
foreach (DataRow LDataRowSingleType in LDataRowCurrentLevelType)
{
LIntCurrentType = int.Parse(LDataRowSingleType["C001"].ToString());
DataRow[] LDataRowOperation = App.IDataTableOperation.Select("C002 = 1110" + LIntCurrentType.ToString() + "00");
if (LDataRowOperation.Length != 1)
{
continue;
}
LStrIconPngName = LDataRowSingleType["C005"].ToString();
TreeViewItem LTreeViewItemType = new TreeViewItem();
LTreeViewItemType.Header = App.GetDisplayCharater("TreeViewResourceList", "RType" + LIntCurrentType.ToString());
LTreeViewItemType.DataContext = LIntCurrentType.ToString();
TreeViewItemProps.SetItemImageName(LTreeViewItemType, IStrImageFolder + @"\" + LStrIconPngName);
if (ATreeViewItemParent == null)
{
TreeViewResourceList.Items.Add(LTreeViewItemType);
}
else
{
ATreeViewItemParent.Items.Add(LTreeViewItemType);
}
}
if (ATreeViewItemParent != null)
{
ATreeViewItemParent.IsExpanded = true;
}
}
catch (Exception ex) { MessageBox.Show(ex.ToString()); }
}
public void ShowInformation(List <string> AListStrParentOrg, string AStrAgentID)
{
int LIntAllParent = 0;
int LIntCurrent = 0;
string LStrImagesPath = string.Empty;
TreeViewItem LTreeViewItemParent = null;
TreeViewManager.Items.Clear();
ShowOrgUserTreeView(AListStrParentOrg);
UCTreeViewYoung LUCTreeViewYoung = GridObjectSelect.Children[0] as UCTreeViewYoung;
LStrImagesPath = System.IO.Path.Combine(App.GClassSessionInfo.LocalMachineInfo.StrCommonApplicationData, @"UMP.Client\Themes", App.GClassSessionInfo.ThemeInfo.Name, @"Images\S1103");
TreeViewManager.Items.Clear();
LIntAllParent = AListStrParentOrg.Count - 1;
for (LIntCurrent = LIntAllParent; LIntCurrent >= 0; LIntCurrent--)
{
string[] LStrArrayOrg = AListStrParentOrg[LIntCurrent].Split(App.AscCodeToChr(27).ToCharArray());
TreeViewItem LTreeViewItemOrg = new TreeViewItem();
LTreeViewItemOrg.Header = LStrArrayOrg[1];
LTreeViewItemOrg.DataContext = LStrArrayOrg[0];
if (LStrArrayOrg[0].Substring(3, 5) == App.GClassSessionInfo.RentInfo.Token && LStrArrayOrg[0].Substring(8) == "00000000001")
{
TreeViewItemProps.SetItemImageName(LTreeViewItemOrg, LStrImagesPath + @"\S1103000.ico");
}
else
{
TreeViewItemProps.SetItemImageName(LTreeViewItemOrg, LStrImagesPath + @"\S1103004.ico");
}
if (LTreeViewItemParent == null)
{
TreeViewManager.Items.Add(LTreeViewItemOrg); LTreeViewItemOrg.IsExpanded = true;
}
else
{
LTreeViewItemParent.Items.Add(LTreeViewItemOrg);
}
LTreeViewItemParent = LTreeViewItemOrg;
ShowControlAgentUser(LTreeViewItemParent, LStrArrayOrg[0], LUCTreeViewYoung, AStrAgentID);
}
}
public void ShowMyControlOrg()
{
string LStrMyOrg = string.Empty;
string LStrOrgID = string.Empty;
string LStrOrgName = string.Empty;
string LStrOrgParent = string.Empty;
string LStrVerificationCode104 = string.Empty;
string LStrImagesPath = string.Empty;
try
{
IListrTVItemAllOrg.Clear();
TreeViewMyCtrlOrg.Items.Clear();
LStrImagesPath = System.IO.Path.Combine(App.GClassSessionInfo.LocalMachineInfo.StrCommonApplicationData, @"UMP.Client\Themes", App.GClassSessionInfo.ThemeInfo.Name, @"Images\S1103");
LStrVerificationCode104 = App.CreateVerificationCode(EncryptionAndDecryption.UMPKeyAndIVType.M104);
DataRow[] LDataRowMyInfo = App.IDataTable11005.Select("C001 = " + App.GClassSessionInfo.UserInfo.UserID.ToString());
LStrMyOrg = LDataRowMyInfo[0]["C006"].ToString();
LStrOrgID = LStrMyOrg;
DataRow[] LDataRowOrg = App.IDataTable11006.Select("C001 = " + LStrOrgID);
LStrOrgName = LDataRowOrg[0]["C002"].ToString();
LStrOrgName = EncryptionAndDecryption.EncryptDecryptString(LStrOrgName, LStrVerificationCode104, EncryptionAndDecryption.UMPKeyAndIVType.M104);
LStrOrgParent = LDataRowOrg[0]["C004"].ToString();
TreeViewItem LTreeViewItemRoot = new TreeViewItem();
LTreeViewItemRoot.Header = LStrOrgName;
LTreeViewItemRoot.DataContext = LStrOrgID;
if (LStrOrgParent != "0")
{
TreeViewItemProps.SetItemImageName(LTreeViewItemRoot, LStrImagesPath + @"\S1103004.ico");
}
else
{
TreeViewItemProps.SetItemImageName(LTreeViewItemRoot, LStrImagesPath + @"\S1103000.ico");
}
TreeViewMyCtrlOrg.Items.Add(LTreeViewItemRoot);
ShowMyControlOrg(LTreeViewItemRoot, LStrOrgID);
LTreeViewItemRoot.IsExpanded = true;
IListrTVItemAllOrg.Add(LTreeViewItemRoot);
}
catch { }
}
public void RefreshTreeViewItemAfterOpenDatabase(DataTable ADataTableRentList)
{
try
{
if (ITreeViewItemCurrentSelected.Name != "TVI004")
{
return;
}
ITreeViewItemCurrentSelected.Items.Clear();
DataTable LDataTableDBProfile = ITreeViewItemCurrentSelected.DataContext as DataTable;
TreeViewItem LTreeViewItemAllRentList = new TreeViewItem();
LTreeViewItemAllRentList.DataContext = "";
LTreeViewItemAllRentList.Name = "TVI008";
LTreeViewItemAllRentList.Tag = "";
TreeViewItemProps.SetItemImageName(LTreeViewItemAllRentList, App.GStrApplicationDirectory + @"\Images\00000038.ico");
ITreeViewItemCurrentSelected.Items.Add(LTreeViewItemAllRentList);
ITreeViewItemCurrentSelected.IsExpanded = true;
ResetTreeViewItemHeader();
GetRentLogicPartitionInfo(LDataTableDBProfile, ADataTableRentList);
}
catch { }
}
private void ShowRentAndRentLogicPartitionInfo()
{
string LStrRentToken = string.Empty;
ITreeViewItemCurrentSelected = ITreeViewItemCurrentSelected.Items[0] as TreeViewItem;
ITreeViewItemCurrentSelected.IsSelected = true;
foreach (DataRow LDataRowSingleRent in IDataTableRentList.Rows)
{
//加入租户信息
TreeViewItem LTreeViewItemRent = new TreeViewItem();
LStrRentToken = LDataRowSingleRent["C021"].ToString();
LTreeViewItemRent.Header = LDataRowSingleRent["C002"].ToString();
LTreeViewItemRent.DataContext = LDataRowSingleRent;
LTreeViewItemRent.Name = "TVI005";
TreeViewItemProps.SetItemImageName(LTreeViewItemRent, App.GStrApplicationDirectory + @"\Images\00000031.ico");
ITreeViewItemCurrentSelected.Items.Add(LTreeViewItemRent);
foreach (DataTable LDataTableSingleRentLPInfo in IListDataTableRentLogicPartitionInfo)
{
if (LDataTableSingleRentLPInfo.TableName != "T_RENT_" + LStrRentToken)
{
continue;
}
foreach (DataRow LDataRowSingleLogicPartion in LDataTableSingleRentLPInfo.Rows)
{
TreeViewItem LTreeViewItemRentLogicPartition = new TreeViewItem();
LTreeViewItemRentLogicPartition.DataContext = LDataRowSingleLogicPartion;
LTreeViewItemRentLogicPartition.Name = "TVI006";
LTreeViewItemRentLogicPartition.Tag = LStrRentToken;
LTreeViewItemRent.Items.Add(LTreeViewItemRentLogicPartition);
}
}
}
ResetTreeViewItemHeader();
ITreeViewItemCurrentSelected.IsExpanded = true;
}
/// <summary>
/// 在选择中数据库时 加载语言类型列表
/// </summary>
/// <param name="dbItem"></param>
private void InitTreeLanguageItem(TreeViewItem dbItem)
{
try
{
TreeViewItem parentItem = dbItem.Parent as TreeViewItem;
ServerInfomation serverInfo = parentItem.Tag as ServerInfomation;
App.GCurrentUmpServer = serverInfo;
DBInfo dbInfo = dbItem.Tag as DBInfo;
ReturnResult result = AboutLanguagesInServer.WCFOperationMthodA("Http", serverInfo.Host, serverInfo.Port
, 1, dbInfo);
if (result.BoolReturn)
{
if (result.DataSetReturn.Tables.Count > 0)
{
DataTable dt = result.DataSetReturn.Tables[0];
TreeViewItem item;
for (int i = 0; i < dt.Rows.Count; i++)
{
item = new TreeViewItem();
item.Header = dt.Rows[i]["C005"].ToString();
item.Tag = dt.Rows[i];
item.DataContext = "Lan-" + dt.Rows[i]["C005"].ToString();
TreeViewItemProps.SetItemImageName(item, System.IO.Path.Combine(App.GStrApplicationDirectory, @"Images\00000027.ico"));
item.SetResourceReference(TreeViewItem.StyleProperty, "TreeViewItemWithImg");
dbItem.Items.Add(item);
}
}
dbItem.IsExpanded = true;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message,
this.TryFindResource("ErrorMsgTitle").ToString(), MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public void ShowType213LeftSubObjects()
{
string LStrIconPngName = string.Empty;
string LStrServerData011 = string.Empty;
string LStrServerData012 = string.Empty;
string LStrServerData013 = string.Empty;
string LStrServerData014 = string.Empty;
string LStrServerData017 = string.Empty;
string LStrServerData018 = string.Empty;
try
{
DataRow[] LDataRowCurrentLevelType = App.IDataTable00010.Select("C001 = 213");
LStrIconPngName = LDataRowCurrentLevelType[0]["C005"].ToString();
foreach (TreeViewItem LTreeViewItemSingleResurce in TreeViewResourceList.Items)
{
if (LTreeViewItemSingleResurce.DataContext.ToString() != "213")
{
continue;
}
CheckAndInitType213Data();
LTreeViewItemSingleResurce.Items.Clear();
DataRow[] LDataRowCtiHubServer = App.IListDataSetReturn[2].Tables[0].Select("C001 = 2130000000000000001 OR C001 = 2130000000000000002", "C001 ASC");
#region 显示Server1
LStrServerData011 = LDataRowCtiHubServer[0]["C011"].ToString();
LStrServerData012 = LDataRowCtiHubServer[0]["C012"].ToString();
LStrServerData013 = LDataRowCtiHubServer[0]["C013"].ToString();
LStrServerData014 = LDataRowCtiHubServer[0]["C014"].ToString();
LStrServerData014 = EncryptionAndDecryption.EncryptDecryptString(LStrServerData014, IStrVerificationCode104, EncryptionAndDecryption.UMPKeyAndIVType.M104);
LStrServerData017 = LDataRowCtiHubServer[0]["C017"].ToString();
LStrServerData017 = EncryptionAndDecryption.EncryptDecryptString(LStrServerData017, IStrVerificationCode104, EncryptionAndDecryption.UMPKeyAndIVType.M104);
LStrServerData018 = LDataRowCtiHubServer[0]["C018"].ToString();
LStrServerData018 = EncryptionAndDecryption.EncryptDecryptString(LStrServerData018, IStrVerificationCode104, EncryptionAndDecryption.UMPKeyAndIVType.M104);
TreeViewItem LTreeViewItemServer1 = new TreeViewItem();
if (LStrServerData011 == "0")
{
LTreeViewItemServer1.Header = "(" + App.GetDisplayCharater("UCResourceType211", "C012V" + LStrServerData012) + ") " + App.GetDisplayCharater("1110012");
}
else
{
LTreeViewItemServer1.Header = "(" + App.GetDisplayCharater("UCResourceType211", "C012V" + LStrServerData012) + ") " + LStrServerData017;// +":" + LStrServerData014;
}
LTreeViewItemServer1.DataContext = "2130000000000000001";
TreeViewItemProps.SetItemImageName(LTreeViewItemServer1, IStrImageFolder + @"\" + LStrIconPngName);
LTreeViewItemSingleResurce.Items.Add(LTreeViewItemServer1);
#endregion
#region 显示Server2
LStrServerData011 = LDataRowCtiHubServer[1]["C011"].ToString();
LStrServerData012 = LDataRowCtiHubServer[1]["C012"].ToString();
LStrServerData013 = LDataRowCtiHubServer[1]["C013"].ToString();
LStrServerData014 = LDataRowCtiHubServer[1]["C014"].ToString();
LStrServerData014 = EncryptionAndDecryption.EncryptDecryptString(LStrServerData014, IStrVerificationCode104, EncryptionAndDecryption.UMPKeyAndIVType.M104);
LStrServerData017 = LDataRowCtiHubServer[1]["C017"].ToString();
LStrServerData017 = EncryptionAndDecryption.EncryptDecryptString(LStrServerData017, IStrVerificationCode104, EncryptionAndDecryption.UMPKeyAndIVType.M104);
LStrServerData018 = LDataRowCtiHubServer[1]["C018"].ToString();
LStrServerData018 = EncryptionAndDecryption.EncryptDecryptString(LStrServerData018, IStrVerificationCode104, EncryptionAndDecryption.UMPKeyAndIVType.M104);
TreeViewItem LTreeViewItemServer2 = new TreeViewItem();
if (LStrServerData011 == "0")
{
LTreeViewItemServer2.Header = "(" + App.GetDisplayCharater("UCResourceType211", "C012V" + LStrServerData012) + ") " + App.GetDisplayCharater("1110012");
}
else
{
LTreeViewItemServer2.Header = "(" + App.GetDisplayCharater("UCResourceType211", "C012V" + LStrServerData012) + ") " + LStrServerData017;// +":" + LStrServerData014;
}
LTreeViewItemServer2.DataContext = "2130000000000000002";
TreeViewItemProps.SetItemImageName(LTreeViewItemServer2, IStrImageFolder + @"\" + LStrIconPngName);
LTreeViewItemSingleResurce.Items.Add(LTreeViewItemServer2);
#endregion
LTreeViewItemSingleResurce.IsExpanded = true;
break;
}
}
catch (Exception ex) { MessageBox.Show(ex.ToString()); }
}
private void DisplayObjectCharactersTreeViewItem(TreeViewItem ATreeViewItem)
{
string LStrItemName = string.Empty;
string LStrHeader = string.Empty;
try
{
LStrItemName = ATreeViewItem.Name;
if (ATreeViewItem.Header != null)
{
LStrHeader = ATreeViewItem.Header.ToString();
}
#region 跟节点
if (LStrItemName == "TVI001")
{
List <string> LListStrConnectedInfo = ATreeViewItem.Tag as List <string>;
if (LListStrConnectedInfo[0] == "127.0.0.1")
{
LStrHeader = string.Format(App.GetDisplayCharater("M01025"), App.GetDisplayCharater("M01026"));
}
else
{
LStrHeader = string.Format(App.GetDisplayCharater("M01025"), LListStrConnectedInfo[0]);
}
}
#endregion
#region 安全证书节点
if (LStrItemName == "TVI002")
{
LStrHeader = App.GetDisplayCharater("M01037");
DataTable LDataTableCertificate = ATreeViewItem.DataContext as DataTable;
if (LDataTableCertificate.Rows.Count != 3)
{
TreeViewItemProps.SetItemImageName(ATreeViewItem, App.GStrApplicationDirectory + @"\Images\00000024.ico");
}
else
{
TreeViewItemProps.SetItemImageName(ATreeViewItem, App.GStrApplicationDirectory + @"\Images\00000023.ico");
}
}
#endregion
#region Site 绑定信息节点
if (LStrItemName == "TVI003")
{
bool LBoolBinded = false;
LStrHeader = "UMP.PF (" + App.GetDisplayCharater("M01027") + ")";
DataTable LDataTableIISBindingInfo = ATreeViewItem.DataContext as DataTable;
foreach (DataRow LDataRowBinding in LDataTableIISBindingInfo.Rows)
{
if (LDataRowBinding["Used"].ToString() == "1")
{
LBoolBinded = true; break;
}
}
if (LBoolBinded)
{
TreeViewItemProps.SetItemImageName(ATreeViewItem, App.GStrApplicationDirectory + @"\Images\00000019.ico");
}
else
{
TreeViewItemProps.SetItemImageName(ATreeViewItem, App.GStrApplicationDirectory + @"\Images\00000020.ico");
}
}
#endregion
#region License Server节点
if (LStrItemName == "TVI007")
{
bool LBoolExistEnabled = false;
LStrHeader = App.GetDisplayCharater("M01104");
DataTable LDataTableLicenseServer = ATreeViewItem.DataContext as DataTable;
foreach (DataRow LDataRowSingleLicenseServer in LDataTableLicenseServer.Rows)
{
if (LDataRowSingleLicenseServer["OtherInfo"].ToString() == "1")
{
LBoolExistEnabled = true; break;
}
}
if (LBoolExistEnabled)
{
TreeViewItemProps.SetItemImageName(ATreeViewItem, App.GStrApplicationDirectory + @"\Images\00000035.ico");
}
else
{
TreeViewItemProps.SetItemImageName(ATreeViewItem, App.GStrApplicationDirectory + @"\Images\00000036.ico");
}
}
#endregion
#region 数据库节点
if (LStrItemName == "TVI004")
{
DataTable LDataTableDBProfileInfo = ATreeViewItem.DataContext as DataTable;
if (LDataTableDBProfileInfo.Rows.Count == 0)
{
LStrHeader = App.GetDisplayCharater("M01053");
TreeViewItemProps.SetItemImageName(ATreeViewItem, App.GStrApplicationDirectory + @"\Images\00000026.png");
}
else
{
if (LDataTableDBProfileInfo.Rows[0]["CanConnect"].ToString() == "1")
{
LStrHeader = string.Format(App.GetDisplayCharater("M01052"), LDataTableDBProfileInfo.Rows[0]["OtherArgs"].ToString());
TreeViewItemProps.SetItemImageName(ATreeViewItem, App.GStrApplicationDirectory + @"\Images\00000027.png");
App.IsCreatedDB = true;
}
else
{
LStrHeader = App.GetDisplayCharater("M01054");
TreeViewItemProps.SetItemImageName(ATreeViewItem, App.GStrApplicationDirectory + @"\Images\00000028.png");
}
}
}
#endregion
#region 租户列表节点
if (LStrItemName == "TVI008")
{
LStrHeader = App.GetDisplayCharater("M01114");
}
#endregion
#region 租户表逻辑分区节点
string LStrAlias = string.Empty;
if (LStrItemName == "TVI006")
{
DataRow LDataRowLogicPartitionInfo = ATreeViewItem.DataContext as DataRow;
LStrAlias = LDataRowLogicPartitionInfo["Alias"].ToString();
LStrAlias = App.GetConvertedData("LPT" + LStrAlias);
LStrHeader = LStrAlias;
if (LDataRowLogicPartitionInfo["S01"].ToString() == "1")
{
TreeViewItemProps.SetItemImageName(ATreeViewItem, App.GStrApplicationDirectory + @"\Images\00000032.ico");
}
else
{
TreeViewItemProps.SetItemImageName(ATreeViewItem, App.GStrApplicationDirectory + @"\Images\00000033.ico");
}
}
#endregion
ATreeViewItem.Header = LStrHeader;
for (int LIntLoopChildren = 0; LIntLoopChildren < ATreeViewItem.Items.Count; LIntLoopChildren++)
{
TreeViewItem LTreeViewItemChild = (TreeViewItem)ATreeViewItem.Items[LIntLoopChildren];
DisplayObjectCharactersTreeViewItem(LTreeViewItemChild);
}
}
catch (Exception ex)
{
App.ShowExceptionMessage("DisplayObjectCharactersTreeViewItem()\n" + ex.ToString());
}
}
public void ShowControlOrgAgent()
{
string LStrMyOrg = string.Empty;
string LStrOrgID = string.Empty;
string LStrOrgName = string.Empty;
string LStrOrgParent = string.Empty;
string LStrVerificationCode104 = string.Empty;
string LStrImagesPath = string.Empty;
try
{
TreeViewOrgAgent.Items.Clear();
IListTVIOrg.Clear();
IListTVIAgent.Clear();
LStrImagesPath = System.IO.Path.Combine(App.GClassSessionInfo.LocalMachineInfo.StrCommonApplicationData, @"UMP.Client\Themes", App.GClassSessionInfo.ThemeInfo.Name, @"Images\S1103");
LStrVerificationCode104 = App.CreateVerificationCode(EncryptionAndDecryption.UMPKeyAndIVType.M104);
DataRow[] LDataRowMyInfo = App.IDataTable11005.Select("C001 = " + App.GClassSessionInfo.UserInfo.UserID.ToString());
LStrMyOrg = LDataRowMyInfo[0]["C006"].ToString();
LStrOrgID = LStrMyOrg;
DataRow[] LDataRowOrg = App.IDataTable11006.Select("C001 = " + LStrOrgID);
LStrOrgName = LDataRowOrg[0]["C002"].ToString();
LStrOrgName = EncryptionAndDecryption.EncryptDecryptString(LStrOrgName, LStrVerificationCode104, EncryptionAndDecryption.UMPKeyAndIVType.M104);
LStrOrgParent = LDataRowOrg[0]["C004"].ToString();
TreeViewItem LTreeViewItemRoot = new TreeViewItem();
LTreeViewItemRoot.Header = LStrOrgName;
LTreeViewItemRoot.DataContext = LStrOrgID;
if (LStrOrgParent != "0")
{
TreeViewItemProps.SetItemImageName(LTreeViewItemRoot, LStrImagesPath + @"\S1103004.ico");
}
else
{
TreeViewItemProps.SetItemImageName(LTreeViewItemRoot, LStrImagesPath + @"\S1103000.ico");
}
TreeViewOrgAgent.Items.Add(LTreeViewItemRoot);
IListTVIOrg.Add(LTreeViewItemRoot);
ShowOrgAgent(LTreeViewItemRoot, LStrOrgID);
LTreeViewItemRoot.IsExpanded = true;
LTreeViewItemRoot.Focus();
LTreeViewItemRoot.BringIntoView();
IUCBasicInfo.IPageParent = this;
IUCSkillInfo.IPageParent = this;
IUCManger.IPageParent = this;
//StackPanelAgentProperties.Children.Clear();
//IUCBasicInfo.BorderThickness = new Thickness(1, 1, 1, 1);
//IUCBasicInfo.BorderBrush = Brushes.LightGray;
//StackPanelAgentProperties.Children.Add(IUCBasicInfo);
//IUCSkillInfo.Margin = new Thickness(0, 5, 0, 0);
//IUCSkillInfo.BorderThickness = new Thickness(1, 1, 1, 1);
//IUCSkillInfo.BorderBrush = Brushes.LightGray;
//StackPanelAgentProperties.Children.Add(IUCSkillInfo);
//IUCManger.Margin = new Thickness(0, 5, 0, 0);
//IUCManger.BorderThickness = new Thickness(1, 1, 1, 1);
//IUCManger.BorderBrush = Brushes.LightGray;
//StackPanelAgentProperties.Children.Add(IUCManger);
ShowElementContent();
IUCBasicInfo.ShowElementContent();
IUCBasicInfo.ShowMyControlOrg();
IUCSkillInfo.ShowElementContent();
IUCManger.ShowElementContent();
}
catch (Exception ex)
{
//MessageBox.Show(ex.ToString(),"3");
}
}
private void ShowOrgAgent(TreeViewItem ATreeViewItem, string AStrParentOrgID)
{
string LStrVerificationCode104 = string.Empty;
string LStrOrgID = string.Empty;
string LStrOrgName = string.Empty;
string LStrOrgParent = string.Empty;
string LStrImagesPath = string.Empty;
string LStrAgentStatus = string.Empty;
string LStrAgentID = string.Empty;
string LStrAgentCode = string.Empty;
string LStrAgentName = string.Empty;
try
{
LStrImagesPath = System.IO.Path.Combine(App.GClassSessionInfo.LocalMachineInfo.StrCommonApplicationData, @"UMP.Client\Themes", App.GClassSessionInfo.ThemeInfo.Name, @"Images\S1103");
LStrVerificationCode104 = App.CreateVerificationCode(EncryptionAndDecryption.UMPKeyAndIVType.M104);
DataRow[] LDataRowOrg = App.IDataTable11006.Select("C004 = " + AStrParentOrgID);
foreach (DataRow LDataRowSingleOrg in LDataRowOrg)
{
LStrOrgID = LDataRowSingleOrg["C001"].ToString();
if (App.IDataTable11201UO.Select("C004 = " + LStrOrgID).Length <= 0)
{
continue;
}
LStrOrgName = LDataRowSingleOrg["C002"].ToString();
LStrOrgName = EncryptionAndDecryption.EncryptDecryptString(LStrOrgName, LStrVerificationCode104, EncryptionAndDecryption.UMPKeyAndIVType.M104);
TreeViewItem LTreeViewItemSubOrg = new TreeViewItem();
LTreeViewItemSubOrg.Header = LStrOrgName;
LTreeViewItemSubOrg.DataContext = LStrOrgID;
TreeViewItemProps.SetItemImageName(LTreeViewItemSubOrg, LStrImagesPath + @"\S1103004.ico");
ATreeViewItem.Items.Add(LTreeViewItemSubOrg);
IListTVIOrg.Add(LTreeViewItemSubOrg);
ShowOrgAgent(LTreeViewItemSubOrg, LStrOrgID);
LTreeViewItemSubOrg.IsExpanded = true;
}
DataRow[] LDataRowAgent = App.IDataTable11101.Select("C011 = '" + AStrParentOrgID + "' AND C002 = 1", "C017 ASC");
foreach (DataRow LDataRowSingleAgent in LDataRowAgent)
{
LStrAgentID = LDataRowSingleAgent["C001"].ToString();
LStrAgentCode = LDataRowSingleAgent["C017"].ToString();
//LStrAgentCode = EncryptionAndDecryption.EncryptDecryptString(LStrAgentCode, LStrVerificationCode104, EncryptionAndDecryption.UMPKeyAndIVType.M104);
if (App.IDataTable11201UA.Select("C003 = " + App.GClassSessionInfo.UserInfo.UserID.ToString() + " AND C004 = " + LStrAgentID).Length <= 0)
{
continue;
}
LStrAgentName = LDataRowSingleAgent["C018"].ToString();
LStrAgentName = EncryptionAndDecryption.EncryptDecryptString(LStrAgentName, LStrVerificationCode104, EncryptionAndDecryption.UMPKeyAndIVType.M104);
LStrAgentStatus = LDataRowSingleAgent["C012"].ToString();
TreeViewItem LTreeViewItemSubAgent = new TreeViewItem();
LTreeViewItemSubAgent.Header = "(" + LStrAgentCode + ") " + LStrAgentName;
LTreeViewItemSubAgent.DataContext = LStrAgentID;
if (LStrAgentStatus == "1")
{
TreeViewItemProps.SetItemImageName(LTreeViewItemSubAgent, LStrImagesPath + @"\S1103001.ico");
}
else
{
TreeViewItemProps.SetItemImageName(LTreeViewItemSubAgent, LStrImagesPath + @"\S1103002.ico");
}
ATreeViewItem.Items.Add(LTreeViewItemSubAgent);
IListTVIAgent.Add(LTreeViewItemSubAgent);
}
}
catch (Exception ex) { MessageBox.Show(ex.ToString()); }
}
public static extern IntPtr SendMessage(HandleRef hWnd, int msg, int wParam, ref TreeViewItemProps lParam);
