private void CreateDownloadColumns() { try { GridView gv = new GridView(); GridViewColumn gvc; GridViewColumnHeader gvch; for (int i = 0; i < mListRecordScoreDetailColumns.Count; i++) { ViewColumnInfo columnInfo = mListRecordScoreDetailColumns[i]; if (columnInfo.Visibility == "1") { gvc = new GridViewColumn(); gvch = new GridViewColumnHeader(); gvch.Content = columnInfo.Display; gvch.Content = CurrentApp.GetLanguageInfo(string.Format("COL3102008{0}", columnInfo.ColumnName), columnInfo.Display); gvch.ToolTip = CurrentApp.GetLanguageInfo(string.Format("COL3102008{0}", columnInfo.ColumnName), columnInfo.Display); gvc.Header = gvch; gvc.Width = columnInfo.Width; gvc.DisplayMemberBinding = new Binding(columnInfo.ColumnName); gv.Columns.Add(gvc); } } LvRecordScoreDetail.View = gv; } catch (Exception ex) { ShowException(ex.Message); } }
public ViewColumnInfoItem(ViewColumnInfo viewColumnInfo) { mColumnName = viewColumnInfo.ColumnName; mSortID = viewColumnInfo.SortID; mIsVisible = viewColumnInfo.Visibility == "1"; mWidth = viewColumnInfo.Width; ViewColumnInfo = viewColumnInfo; }
private void LoadViewColumns() { try { WebRequest webRequest = new WebRequest(); webRequest.Code = (int)RequestCode.WSGetUserViewColumnList; webRequest.Session = CurrentApp.Session; webRequest.ListData.Add(CurrentApp.Session.UserInfo.UserID.ToString()); webRequest.ListData.Add("3102005"); // Service11012Client client = new Service11012Client(); Service11012Client client = new Service11012Client(WebHelper.CreateBasicHttpBinding(CurrentApp.Session), WebHelper.CreateEndpointAddress(CurrentApp.Session.AppServerInfo, "Service11012")); WebReturn webReturn = client.DoOperation(webRequest); /* * 这个句子是从wcf11012里面打印出来的 可以看到执行过后结果就是在这个设计查询条件的框框内3列的列头的信息 * SELECT A.C001, A.C002, A.C003, B.C016, B.C011, B.C004 * FROM T_00_102 A, T_11_203_00000 B * WHERE A.C001 = B.C002 AND A.C002 = B.C003 COLLATE DATABASE_DEFAULT * AND B.C001 = 1020000000000000001 AND A.C001 = 3102005 * ORDER BY B.C004 ASC */ client.Close(); if (!webReturn.Result) { ShowException(string.Format("Fail.\t{0}\t{1}", webReturn.Code, webReturn.Message)); return; } List <ViewColumnInfo> listColumns = new List <ViewColumnInfo>(); for (int i = 0; i < webReturn.ListData.Count; i++) { OperationReturn optReturn = XMLHelper.DeserializeObject <ViewColumnInfo>(webReturn.ListData[i]); if (!optReturn.Result) { ShowException(string.Format("Fail.\t{0}\t{1}", optReturn.Code, optReturn.Message)); return; } ViewColumnInfo columnInfo = optReturn.Data as ViewColumnInfo; if (columnInfo != null) { columnInfo.Display = columnInfo.ColumnName; listColumns.Add(columnInfo); } } listColumns = listColumns.OrderBy(c => c.SortID).ToList(); mListViewColumns.Clear(); for (int i = 0; i < listColumns.Count; i++) { mListViewColumns.Add(listColumns[i]); } } catch (Exception ex) { ShowException(ex.Message); } }
private void CreateObjcetKPIDetailColumns() { try { GridView gv = new GridView(); GridViewColumn gvc; GridViewColumnHeader gvch; for (int i = 0; i < mListObjcetKPIDetailColumns.Count; i++) { ViewColumnInfo columnInfo = mListObjcetKPIDetailColumns[i]; if (columnInfo.Visibility == "1") { gvc = new GridViewColumn(); gvch = new GridViewColumnHeader(); gvch.Content = columnInfo.Display; gvch.Content = CurrentApp.GetLanguageInfo(string.Format("COL4601001{0}", columnInfo.ColumnName), columnInfo.Display); gvch.ToolTip = CurrentApp.GetLanguageInfo(string.Format("COL4601001{0}", columnInfo.ColumnName), columnInfo.Display); gvc.Header = gvch; gvc.Width = columnInfo.Width; gvc.DisplayMemberBinding = new Binding(columnInfo.ColumnName); if (columnInfo.ColumnName == "KPIName") { gvc.DisplayMemberBinding = new Binding("StrKPIName"); } if (columnInfo.ColumnName == "ObjectType") { gvc.DisplayMemberBinding = new Binding("StrObjectType"); } if (columnInfo.ColumnName == "IsActive") { gvc.DisplayMemberBinding = new Binding("StrIsActive"); } if (columnInfo.ColumnName == "DropDown") { gvc.DisplayMemberBinding = new Binding("StrDropDown"); } if (columnInfo.ColumnName == "ApplyAll") { gvc.DisplayMemberBinding = new Binding("StrApplyAll"); } if (columnInfo.ColumnName == "ApplyCycle") { gvc.DisplayMemberBinding = new Binding("StrApplyCycle"); } gv.Columns.Add(gvc); } } LvRecordScoreDetail.View = gv; } catch (Exception ex) { ShowException(ex.Message); } }
private void InitObjcetKPIDetailColumns() { try { WebRequest webRequest = new WebRequest(); webRequest.Code = (int)RequestCode.WSGetUserViewColumnList; webRequest.Session = CurrentApp.Session; webRequest.ListData.Add(CurrentApp.Session.UserInfo.UserID.ToString()); webRequest.ListData.Add("4601001"); Service11012Client client = new Service11012Client(WebHelper.CreateBasicHttpBinding(CurrentApp.Session), WebHelper.CreateEndpointAddress(CurrentApp.Session.AppServerInfo, "Service11012")); WebReturn webReturn = client.DoOperation(webRequest); client.Close(); if (!webReturn.Result) { ShowException(string.Format("WSFail.\t{0}\t{1}", webReturn.Code, webReturn.Message)); return; } List <ViewColumnInfo> listColumns = new List <ViewColumnInfo>(); for (int i = 0; i < webReturn.ListData.Count; i++) { OperationReturn optReturn = XMLHelper.DeserializeObject <ViewColumnInfo>(webReturn.ListData[i]); if (!optReturn.Result) { ShowException(string.Format("Fail.\t{0}\t{1}", optReturn.Code, optReturn.Message)); return; } ViewColumnInfo columnInfo = optReturn.Data as ViewColumnInfo; if (columnInfo != null) { columnInfo.Display = columnInfo.ColumnName; if (columnInfo.ColumnName.Equals("StartTime") || columnInfo.ColumnName.Equals("StopTime")) { columnInfo.Visibility = "0"; } listColumns.Add(columnInfo); } } listColumns = listColumns.OrderBy(c => c.SortID).ToList(); mListObjcetKPIDetailColumns.Clear(); for (int i = 0; i < listColumns.Count; i++) { mListObjcetKPIDetailColumns.Add(listColumns[i]); //暂时 } CurrentApp.WriteLog("PageLoad", string.Format("Load ObjcetKPIDetailColumn")); } catch (Exception ex) { ShowException(ex.Message); } }
//文字列をDBのCHAR型項目から取得する時は、空白を削除する public override object BeforeCast_ViewColumnType(StringViewColumnType viewColumnType , ViewColumnInfo aViewColumnInfo , object viewColumnValue) { //テーブルカラムのデフォルト値からは空白を削除しない if (aViewColumnInfo.ViewName == "ColumnInfo" && aViewColumnInfo.ViewColumnName == "DefaultValue") { return(viewColumnValue.ToString()); } return(JkCastEditor.TrimWithDefaultValue(viewColumnValue.ToString(), null)); }
public static ViewColumnItem CreateItem(ViewColumnInfo info) { ViewColumnItem item = new ViewColumnItem(); item.ViewID = info.ViewID; item.ColumnName = info.ColumnName; item.Display = info.Display; item.SortID = info.SortID; item.Visibility = info.Visibility; item.Width = info.Width; return(item); }
private void LoadViewColumns() { try { mListViewColumns.Clear(); WebRequest webRequest = new WebRequest(); webRequest.Session = CurrentApp.Session; webRequest.Code = (int)RequestCode.WSGetUserViewColumnList; webRequest.ListData.Add(CurrentApp.Session.UserID.ToString()); webRequest.ListData.Add("4415001"); Service11012Client client = new Service11012Client( WebHelper.CreateBasicHttpBinding(CurrentApp.Session), WebHelper.CreateEndpointAddress(CurrentApp.Session.AppServerInfo, "Service11012")); WebReturn webReturn = client.DoOperation(webRequest); client.Close(); if (!webReturn.Result) { ShowException(string.Format("WSFail.\t{0}\t{1}", webReturn.Code, webReturn.Message)); return; } if (webReturn.ListData == null) { ShowException(string.Format("Fail.\tListData is null")); return; } int count = webReturn.ListData.Count; OperationReturn optReturn; for (int i = 0; i < count; i++) { string strInfo = webReturn.ListData[i]; optReturn = XMLHelper.DeserializeObject <ViewColumnInfo>(strInfo); if (!optReturn.Result) { ShowException(string.Format("Fail.\t{0}\t{1}", optReturn.Code, optReturn.Message)); return; } ViewColumnInfo info = optReturn.Data as ViewColumnInfo; if (info == null) { ShowException(string.Format("Fail.\tViewColumnInfo is null")); return; } mListViewColumns.Add(info); } CurrentApp.WriteLog("LoadViewColumns", string.Format("Load end.\t{0}", mListViewColumns.Count)); } catch (Exception ex) { ShowException(ex.Message); } }
/// <summary> /// 创建listview显示的列 /// </summary> private void CreateColumnsItems() { try { GridView gv = new GridView(); GridViewColumn gvc; GridViewColumnHeader gvch; for (int i = 0; i < mListColumnItems.Count; i++) { ViewColumnInfo columnInfo = mListColumnItems[i]; if (columnInfo.Visibility == "1") { gvc = new GridViewColumn(); gvch = new GridViewColumnHeader(); gvch.Content = columnInfo.Display; string str = CurrentApp.Session.LangTypeID.ToString(); gvch.Content = CurrentApp.GetLanguageInfo(string.Format("COL{0}{1}", mViewID, columnInfo.ColumnName), columnInfo.Display); gvch.ToolTip = CurrentApp.GetLanguageInfo(string.Format("COL{0}{1}", mViewID, columnInfo.ColumnName), columnInfo.Display); gvc.Header = gvch; gvc.Width = columnInfo.Width; DataTemplate dt = null; if (columnInfo.ColumnName == "BookmarkLevelStatusIcon") { dt = Resources["EnableIconCellTemplate"] as DataTemplate; } if (columnInfo.ColumnName == "BookmarkLeveColor") { dt = Resources["ColorCellTemplate"] as DataTemplate; } if (dt == null) { string strColName = columnInfo.ColumnName; gvc.DisplayMemberBinding = new Binding(strColName); } else { gvc.CellTemplate = dt; } gv.Columns.Add(gvc); } } int iCount = gv.Columns.Count; lvBookmarkLevelsObject.View = gv; } catch (Exception ex) { ShowException(ex.Message); } }
private void CreateAlarmColumns() { try { GridView gv = new GridView(); var listColumns = mListViewColumns.OrderBy(c => c.SortID).ToList(); for (int i = 0; i < listColumns.Count; i++) { ViewColumnInfo columnInfo = listColumns[i]; GridViewColumn gvc = new GridViewColumn(); GridViewColumnHeader gvch = new GridViewColumnHeader(); gvch.Content = CurrentApp.GetLanguageInfo(string.Format("COL4415001{0}", columnInfo.ColumnName), columnInfo.ColumnName); gvch.ToolTip = CurrentApp.GetLanguageInfo(string.Format("COL4415001{0}", columnInfo.ColumnName), columnInfo.ColumnName); gvc.Header = gvch; gvc.Width = columnInfo.Width; DataTemplate dt = null; string strName = columnInfo.ColumnName; if (strName == "Color") { dt = Resources["CellColorTemplate"] as DataTemplate; } if (strName == "State") { strName = "StrState"; } if (dt != null) { gvc.CellTemplate = dt; } else { gvc.DisplayMemberBinding = new Binding(strName); } gv.Columns.Add(gvc); } ListViewAlarmList.View = gv; } catch (Exception ex) { ShowException(ex.Message); } }
private void InitColumnData() { try { WebRequest webRequest = new WebRequest(); webRequest.Code = (int)RequestCode.WSGetUserViewColumnList; webRequest.Session = CurrentApp.Session; webRequest.ListData.Add(CurrentApp.Session.UserInfo.UserID.ToString()); webRequest.ListData.Add("3101001"); CurrentApp.MonitorHelper.AddWebRequest(webRequest); Service11012Client client = new Service11012Client(WebHelper.CreateBasicHttpBinding(CurrentApp.Session), WebHelper.CreateEndpointAddress(CurrentApp.Session.AppServerInfo, "Service11012")); WebReturn webReturn = client.DoOperation(webRequest); client.Close(); CurrentApp.MonitorHelper.AddWebReturn(webReturn); if (!webReturn.Result) { ShowException(string.Format("Fail.\t{0}\t{1}", webReturn.Code, webReturn.Message)); return; } if (webReturn.ListData == null) { ShowException(string.Format("No columns")); return; } mListGridColumns.Clear(); for (int i = 0; i < webReturn.ListData.Count; i++) { OperationReturn optReturn = XMLHelper.DeserializeObject <ViewColumnInfo>(webReturn.ListData[i]); if (!optReturn.Result) { ShowException(string.Format("Fail.\t{0}\t{1}", optReturn.Code, optReturn.Message)); return; } ViewColumnInfo column = optReturn.Data as ViewColumnInfo; if (column != null) { mListGridColumns.Add(column); } } CurrentApp.WriteLog("PageLoad", string.Format("Load ViewColumn")); } catch (Exception ex) { ShowException(ex.Message); } }
private void InitRecordDataColumns() { try { WebRequest webRequest = new WebRequest(); webRequest.Code = (int)RequestCode.WSGetUserViewColumnList; webRequest.Session = CurrentApp.Session; webRequest.ListData.Add(CurrentApp.Session.UserInfo.UserID.ToString()); webRequest.ListData.Add("1112001"); Service11012Client client = new Service11012Client(WebHelper.CreateBasicHttpBinding(CurrentApp.Session), WebHelper.CreateEndpointAddress(CurrentApp.Session.AppServerInfo, "Service11012")); WebReturn webReturn = client.DoOperation(webRequest); client.Close(); if (!webReturn.Result) { CurrentApp.ShowExceptionMessage(string.Format("WSFail.\t{0}\t{1}", webReturn.Code, webReturn.Message)); return; } List <ViewColumnInfo> listColumns = new List <ViewColumnInfo>(); for (int i = 0; i < webReturn.ListData.Count; i++) { OperationReturn optReturn = XMLHelper.DeserializeObject <ViewColumnInfo>(webReturn.ListData[i]); if (!optReturn.Result) { CurrentApp.ShowExceptionMessage(string.Format("Fail.\t{0}\t{1}", optReturn.Code, optReturn.Message)); return; } ViewColumnInfo columnInfo = optReturn.Data as ViewColumnInfo; if (columnInfo != null) { columnInfo.Display = columnInfo.ColumnName; listColumns.Add(columnInfo); } } listColumns = listColumns.OrderBy(c => c.SortID).ToList(); mListDomainDataColumns.Clear(); for (int i = 0; i < listColumns.Count; i++) { Dispatcher.Invoke(new Action(() => mListDomainDataColumns.Add(listColumns[i]))); } CurrentApp.WriteLog("PageLoad", string.Format("Load RecordColumn")); } catch (Exception ex) { CurrentApp.ShowExceptionMessage(ex.Message); } }
private void CreateOptLogColumns() { try { GridView gv = new GridView(); GridViewColumn gvc; GridViewColumnHeader gvch; for (int i = 0; i < mListOptLogColumns.Count; i++) { ViewColumnInfo columnInfo = mListOptLogColumns[i]; if (columnInfo.Visibility == "1") { gvc = new GridViewColumn(); gvch = new GridViewColumnHeader(); gvch.Content = columnInfo.Display; gvch.Content = CurrentApp.GetLanguageInfo(string.Format("COL1206001{0}", columnInfo.ColumnName), columnInfo.Display); gvch.ToolTip = CurrentApp.GetLanguageInfo(string.Format("COL1206001{0}", columnInfo.ColumnName), columnInfo.Display); gvc.Header = gvch; gvc.Width = columnInfo.Width; DataTemplate dt = null; if (columnInfo.ColumnName == "StrResult") { dt = (DataTemplate)Resources["CellResultTemplate"]; } if (columnInfo.ColumnName == "StrContent") { dt = (DataTemplate)Resources["CellContentTemplate"]; } if (dt != null) { gvc.CellTemplate = dt; } else { gvc.DisplayMemberBinding = new Binding(columnInfo.ColumnName); } gv.Columns.Add(gvc); } } ListViewOptLogs.View = gv; } catch (Exception ex) { ShowException(ex.Message); } }
/// <summary> /// 获得需要显示的列 /// </summary> private void LoadViewColumnItems() { mViewID = "5101001"; mListColumnItems = new ObservableCollection <ViewColumnInfo>(); try { WebRequest webRequest = new WebRequest(); webRequest.Code = (int)RequestCode.WSGetUserViewColumnList; webRequest.Session = CurrentApp.Session; webRequest.ListData.Add(CurrentApp.Session.UserInfo.UserID.ToString()); webRequest.ListData.Add(mViewID); Service11012Client client = new Service11012Client(WebHelper.CreateBasicHttpBinding(CurrentApp.Session), WebHelper.CreateEndpointAddress(CurrentApp.Session.AppServerInfo, "Service11012")); WebReturn webReturn = client.DoOperation(webRequest); CurrentApp.MonitorHelper.AddWebReturn(webReturn); client.Close(); if (!webReturn.Result) { ShowException(string.Format("WSFail.\t{0}\t{1}", webReturn.Code, webReturn.Message)); return; } List <ViewColumnInfo> listColumns = new List <ViewColumnInfo>(); for (int i = 0; i < webReturn.ListData.Count; i++) { OperationReturn optReturn = XMLHelper.DeserializeObject <ViewColumnInfo>(webReturn.ListData[i]); if (!optReturn.Result) { ShowException(string.Format("Fail.\t{0}\t{1}", optReturn.Code, optReturn.Message)); return; } ViewColumnInfo columnInfo = optReturn.Data as ViewColumnInfo; if (columnInfo != null) { columnInfo.Display = columnInfo.ColumnName; listColumns.Add(columnInfo); } } listColumns = listColumns.OrderBy(c => c.SortID).ToList(); mListColumnItems.Clear(); listColumns.ForEach(obj => mListColumnItems.Add(obj)); } catch (Exception ex) { ShowException(ex.Message); } }
private void CreateViewColumns()//创造每列的列头, 规格,名称,类型 { try { GridView gv = new GridView(); GridViewColumn gvc; GridViewColumnHeader gvch; //mListViewColumns:在LoadViewColumns()里为这个变量塞值进去~ for (int i = 0; i < mListViewColumns.Count; i++) { ViewColumnInfo columnInfo = mListViewColumns[i]; if (columnInfo.Visibility == "1") { gvc = new GridViewColumn(); gvch = new GridViewColumnHeader(); gvch.Content = columnInfo.Display; gvch.Content = CurrentApp.GetLanguageInfo(string.Format("COL3108001{0}", columnInfo.ColumnName), columnInfo.Display); gvch.ToolTip = CurrentApp.GetLanguageInfo(string.Format("COL3108001{0}", columnInfo.ColumnName), columnInfo.Display); gvc.Header = gvch; gvc.Width = columnInfo.Width; gvc.DisplayMemberBinding = new Binding(columnInfo.ColumnName); if (columnInfo.ColumnName == "NAME") { gvc.DisplayMemberBinding = new Binding("Display"); } if (columnInfo.ColumnName == "FORMAT") { gvc.DisplayMemberBinding = new Binding("StrFormat"); } if (columnInfo.ColumnName == "TYPE") { gvc.DisplayMemberBinding = new Binding("StrType"); } gv.Columns.Add(gvc); } } LvAvaliableParamItem.View = gv; } catch (Exception ex) { ShowException(ex.Message); } }
private void CreateSeatColumns() { try { GridView gv = new GridView(); var listColumns = mListViewColumns.OrderBy(c => c.SortID).ToList(); for (int i = 0; i < listColumns.Count; i++) { ViewColumnInfo columnInfo = listColumns[i]; GridViewColumn gvc = new GridViewColumn(); GridViewColumnHeader gvch = new GridViewColumnHeader(); gvch.Content = CurrentApp.GetLanguageInfo(string.Format("COL4413001{0}", columnInfo.ColumnName), columnInfo.ColumnName); gvch.ToolTip = CurrentApp.GetLanguageInfo(string.Format("COL4413001{0}", columnInfo.ColumnName), columnInfo.ColumnName); gvc.Header = gvch; gvc.Width = columnInfo.Width; string strName = columnInfo.ColumnName; if (strName == "State") { strName = "StrState"; } if (strName == "Level") { strName = "StrLevel"; } gvc.DisplayMemberBinding = new Binding(strName); gv.Columns.Add(gvc); } LvSeatList.View = gv; } catch (Exception ex) { ShowException(ex.Message); } }
/// <summary> /// 获取视图列 /// </summary> /// <param name="node">节点</param> /// <param name="ownerView">所有者视图</param> private ViewColumnInfo GetColumn(XmlNode node, ViewInfo ownerView) { var column = new ViewColumnInfo(ownerView); var xe = (XmlElement)node; column.ViewColumnId = xe.GetAttribute(Const.Id); foreach (XmlNode property in xe.ChildNodes) { property.CommonInfoHandle(column); switch (property.Name) { case Const.ADataType: column.DataType = property.InnerText; break; case Const.ALength: column.Length = property.InnerText; break; } } return(column); }
private void InitOptLogColumns() { try { //mListOptLogColumns.Clear(); //WebRequest webRequest = new WebRequest(); //webRequest.Code = (int)RequestCode.WSGetUserViewColumnList; //webRequest.Session = CurrentApp.Session; //webRequest.ListData.Add(CurrentApp.Session.UserInfo.UserID.ToString()); //webRequest.ListData.Add("1206001"); //Service11012Client client = new Service11012Client(WebHelper.CreateBasicHttpBinding(CurrentApp.Session), // WebHelper.CreateEndpointAddress(CurrentApp.Session.AppServerInfo, "Service11012")); //WebReturn webReturn = client.DoOperation(webRequest); //client.Close(); //if (!webReturn.Result) //{ // ShowException(string.Format("WSFail.\t{0}\t{1}", webReturn.Code, webReturn.Message)); // return; //} //List<ViewColumnInfo> listColumns = new List<ViewColumnInfo>(); //for (int i = 0; i < webReturn.ListData.Count; i++) //{ // OperationReturn optReturn = XMLHelper.DeserializeObject<ViewColumnInfo>(webReturn.ListData[i]); // if (!optReturn.Result) // { // ShowException(string.Format("Fail.\t{0}\t{1}", optReturn.Code, optReturn.Message)); // return; // } // ViewColumnInfo columnInfo = optReturn.Data as ViewColumnInfo; // if (columnInfo != null) // { // columnInfo.Display = columnInfo.ColumnName; // listColumns.Add(columnInfo); // } //} //listColumns = listColumns.OrderBy(c => c.SortID).ToList(); //mListOptLogColumns.Clear(); //for (int i = 0; i < listColumns.Count; i++) //{ // mListOptLogColumns.Add(listColumns[i]); //} mListOptLogColumns.Clear(); ViewColumnInfo info = new ViewColumnInfo(); info.ViewID = 1206001; info.ColumnName = "StrTime"; info.Display = info.ColumnName; info.Description = info.Display; info.Visibility = "1"; info.Width = 150; mListOptLogColumns.Add(info); info = new ViewColumnInfo(); info.ViewID = 1206001; info.ColumnName = "StrResult"; info.Display = ""; info.Description = ""; info.Visibility = "1"; info.Width = 30; mListOptLogColumns.Add(info); info = new ViewColumnInfo(); info.ViewID = 1206001; info.ColumnName = "StrOperation"; info.Display = info.ColumnName; info.Description = info.Display; info.Visibility = "1"; info.Width = 120; mListOptLogColumns.Add(info); info = new ViewColumnInfo(); info.ViewID = 1206001; info.ColumnName = "StrUser"; info.Display = info.ColumnName; info.Description = info.Display; info.Visibility = "1"; info.Width = 120; mListOptLogColumns.Add(info); info = new ViewColumnInfo(); info.ViewID = 1206001; info.ColumnName = "StrHost"; info.Display = info.ColumnName; info.Description = info.Display; info.Visibility = "1"; info.Width = 180; mListOptLogColumns.Add(info); info = new ViewColumnInfo(); info.ViewID = 1206001; info.ColumnName = "StrContent"; info.Display = info.ColumnName; info.Description = info.Display; info.Visibility = "1"; info.Width = 500; mListOptLogColumns.Add(info); CurrentApp.WriteLog("InitColumns", string.Format("Load OptLog Columns end.")); } catch (Exception ex) { ShowException(ex.Message); } }
private void CreateDomainDataColumns() { try { GridView gv = new GridView(); GridViewColumn gvc; GridViewColumnHeader gvch; for (int i = 0; i < mListDomainDataColumns.Count; i++) { ViewColumnInfo columnInfo = mListDomainDataColumns[i]; if (columnInfo.Visibility == "1") { gvc = new GridViewColumn(); gvch = new GridViewColumnHeader(); gvch.Content = columnInfo.Display; gvch.Content = CurrentApp.GetLanguageInfo(string.Format("COL1112001{0}", columnInfo.ColumnName), columnInfo.Display); gvch.ToolTip = CurrentApp.GetLanguageInfo(string.Format("COL1112001{0}", columnInfo.ColumnName), columnInfo.Display); //gvch.Command = QMMainPageCommands.GridViewColumnHeaderCommand; gvch.CommandParameter = columnInfo; gvc.Header = gvch; gvc.Width = columnInfo.Width; //Binding binding; DataTemplate dt = null; if (columnInfo.ColumnName == "SerialID") { dt = Resources["CellRecordListSerialIDTemplate"] as DataTemplate; } if (columnInfo.ColumnName == "State") { dt = Resources["ObjectStateCellTemplate"] as DataTemplate; } //if (columnInfo.ColumnName == "Password") //{ // dt = Resources["ObjectPasswordCellTemplate"] as DataTemplate; //} if (dt != null) { gvc.CellTemplate = dt; } else { gvc.DisplayMemberBinding = new Binding(columnInfo.ColumnName); } if (columnInfo.ColumnName == "Name") { gvc.DisplayMemberBinding = new Binding("DomainName"); } if (columnInfo.ColumnName == "Sort") { gvc.DisplayMemberBinding = new Binding("DomainCode"); } if (columnInfo.ColumnName == "User") { gvc.DisplayMemberBinding = new Binding("DomainUserName"); } gv.Columns.Add(gvc); } } LvDomianData.View = gv; } catch (Exception ex) { CurrentApp.ShowExceptionMessage(ex.Message); } }
private void CreateChildObjectColumns() { try { GridView gv = new GridView(); GridViewColumn gvc; GridViewColumnHeader gvch; for (int i = 0; i < mListChildObjectColumns.Count; i++) { ViewColumnInfo columnInfo = mListChildObjectColumns[i]; if (columnInfo.Visibility == "1") { gvc = new GridViewColumn(); gvch = new GridViewColumnHeader(); gvch.Content = columnInfo.Display; gvch.Content = App.GetLanguageInfo(string.Format("COL1110001{0}", columnInfo.ColumnName), columnInfo.Display); gvch.ToolTip = App.GetLanguageInfo(string.Format("COL1110001{0}", columnInfo.ColumnName), columnInfo.Display); gvc.Header = gvch; gvc.Width = columnInfo.Width; //Binding binding; DataTemplate dt; if (columnInfo.ColumnName == "Icon" || columnInfo.ColumnName == "Operation") { if (columnInfo.ColumnName == "Icon") { dt = Resources["IconCellTemplate"] as DataTemplate; if (dt != null) { gvc.CellTemplate = dt; } else { gvc.DisplayMemberBinding = new Binding(columnInfo.ColumnName); } } if (columnInfo.ColumnName == "Operation") { dt = Resources["OperationCellTemplate"] as DataTemplate; if (dt != null) { gvc.CellTemplate = dt; } else { gvc.DisplayMemberBinding = new Binding(columnInfo.ColumnName); } } } else { gvc.DisplayMemberBinding = new Binding(columnInfo.ColumnName); } gv.Columns.Add(gvc); } } LvChildObjects.View = gv; } catch (Exception ex) { App.ShowExceptionMessage(ex.Message); } }
private void LoadCustomColumnData() { try { mListObject_Kpi.Clear(); WebRequest webRequest = new WebRequest(); webRequest.Code = (int)RequestCode.WSGetUserViewColumnList; webRequest.Session = CurrentApp.Session; webRequest.ListData.Add(CurrentApp.Session.UserInfo.UserID.ToString()); webRequest.ListData.Add("4602001"); Service11012Client client = new Service11012Client(WebHelper.CreateBasicHttpBinding(CurrentApp.Session), WebHelper.CreateEndpointAddress(CurrentApp.Session.AppServerInfo, "Service11012")); WebReturn webReturn = client.DoOperation(webRequest); client.Close(); if (!webReturn.Result) { ShowException(string.Format("Fail.\t{0}\t{1}", webReturn.Code, webReturn.Message)); return; } List <ViewColumnInfo> listColumns = new List <ViewColumnInfo>(); for (int i = 0; i < webReturn.ListData.Count; i++) { OperationReturn optReturn = XMLHelper.DeserializeObject <ViewColumnInfo>(webReturn.ListData[i]); if (!optReturn.Result) { ShowException(string.Format("Fail.\t{0}\t{1}", optReturn.Code, optReturn.Message)); return; } ViewColumnInfo columnInfo = optReturn.Data as ViewColumnInfo; if (columnInfo != null) { columnInfo.Display = columnInfo.ColumnName; listColumns.Add(columnInfo); } } listColumns = listColumns.OrderBy(c => c.SortID).ToList(); if (listColumns.Where(p => p.SortID == 0).First().ColumnName == "UERName")//按对象分组 { rabObject.IsChecked = true; } else { rabKpi.IsChecked = true; } mListCustomColumns.Clear(); for (int i = 0; i < listColumns.Count; i++) { ViewColumnInfoItem item = new ViewColumnInfoItem(listColumns[i]); item.Display = CurrentApp.GetLanguageInfo(string.Format("4601P00{0}", item.LangID.ToString().Substring(1, 3)), item.ColumnName); item.StrIsVisible = CurrentApp.GetLanguageInfo(string.Format("4601P0004{0}", listColumns[i].Visibility), listColumns[i].Visibility); if (i % 2 != 0) { item.Background = Brushes.LightGray; } else { item.Background = Brushes.AntiqueWhite; } if (item.ColumnName == "UERName" || item.ColumnName == "KPIName")//对象、PM指标列不能修改顺序,在提交应用时再加上去 { mListObject_Kpi.Add(listColumns[i]); } else { mListCustomColumns.Add(item); } } } catch (Exception ex) { ShowException(ex.Message); } }
public OperationReturn ExportDataToExecel <T>(List <T> listData, List <ViewColumnInfo> listColumns, UMPApp currentApp) { OperationReturn optReturn = new OperationReturn(); optReturn.Result = true; optReturn.Code = 0; try { if (listData == null) { optReturn.Result = false; optReturn.Code = Defines.RET_OBJECT_NULL; optReturn.Message = string.Format("ListData is null"); return(optReturn); } if (listData.Count <= 0) { optReturn.Result = false; optReturn.Code = Defines.RET_NOT_EXIST; optReturn.Message = string.Format("No Record Data"); return(optReturn); } SaveFileDialog dialog = new SaveFileDialog(); dialog.DefaultExt = "xls"; dialog.Filter = "Excel Files (*.xls)|*.xls"; dialog.FilterIndex = 1; dialog.RestoreDirectory = true; if (dialog.ShowDialog() != true) { optReturn.Code = Defines.RET_ALREADY_EXIST; return(optReturn); } StringBuilder sb = new StringBuilder(); List <string> listFields = new List <string>(); int intColCount = listColumns.Count; //列标题 for (int i = 0; i < intColCount; i++) { string strTitle = currentApp.GetLanguageInfo( string.Format("COL{0}{1}", listColumns[i].ViewID, listColumns[i].ColumnName), listColumns[i].ColumnName); listFields.Add(FormatField(strTitle)); } BuildStringToRow(sb, listFields); //列数据 PropertyInfo[] listProperty; PropertyInfo property; for (int i = 0; i < listData.Count; i++) { T item = listData[i]; listFields.Clear(); listProperty = item.GetType().GetProperties(); for (int j = 0; j < intColCount; j++) { ViewColumnInfo column = listColumns[j]; property = listProperty.FirstOrDefault(p => p.Name == column.ColumnName); if (property != null) { var temp = property.GetValue(item, null); if (temp != null) { string strValue; switch (column.ColumnName) { case "Duration": strValue = Converter.Second2Time(Convert.ToDouble(temp)); break; case "StartRecordTime": case "StopRecordTime": strValue = Convert.ToDateTime(temp).ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); break; case "Direction": strValue = currentApp.GetLanguageInfo(string.Format("3102TIP001{0}", temp), temp.ToString()); break; default: strValue = temp.ToString(); break; } listFields.Add(FormatField(strValue)); } else { listFields.Add(FormatField(String.Empty)); } } else { listFields.Add(FormatField(string.Empty)); } } BuildStringToRow(sb, listFields); } StreamWriter streamWriter = new StreamWriter(dialog.OpenFile()); streamWriter.WriteLine("<?xml version=\"1.0\" encoding=\"utf-8\"?>"); streamWriter.WriteLine("<?mso-application progid=\"Excel.Sheet\"?>"); streamWriter.WriteLine("<Workbook xmlns=\"urn:schemas-microsoft-com:office:spreadsheet\">"); streamWriter.WriteLine("<DocumentProperties xmlns=\"urn:schemas-microsoft-com:office:office\">"); streamWriter.WriteLine("<Author>" + currentApp.Session.UserInfo.Account + "</Author>"); streamWriter.WriteLine("<Created>" + DateTime.Now.ToLocalTime().ToLongDateString() + "</Created>"); streamWriter.WriteLine("<LastSaved>" + DateTime.Now.ToLocalTime().ToLongDateString() + "</LastSaved>"); streamWriter.WriteLine("<Company>" + "VoiceCyber" + "</Company>"); streamWriter.WriteLine("<Version>1.00</Version>"); streamWriter.WriteLine("</DocumentProperties>"); streamWriter.WriteLine("<Worksheet ss:Name=\"UMP Export\" xmlns:ss=\"urn:schemas-microsoft-com:office:spreadsheet\">"); streamWriter.WriteLine("<Table>"); streamWriter.WriteLine(sb); streamWriter.WriteLine("</Table>"); streamWriter.WriteLine("</Worksheet>"); streamWriter.WriteLine("</Workbook>"); streamWriter.Close(); optReturn.Data = dialog.FileName; } catch (Exception ex) { optReturn.Result = false; optReturn.Code = Defines.RET_FAIL; optReturn.Message = ex.Message; } return(optReturn); }
private void InitColumns() { try { GridView gv = new GridView(); GridViewColumn gvc; GridViewColumnHeader gvch; for (int i = 0; i < mListGridColumns.Count; i++) { ViewColumnInfo columnInfo = mListGridColumns[i]; if (columnInfo.Visibility == "1") { gvc = new GridViewColumn(); gvch = new GridViewColumnHeader(); if (columnInfo.ColumnName == "Operation") { gvch.Content = string.Empty; } else { gvch.Content = CurrentApp.GetLanguageInfo(string.Format("COL3101001{0}", columnInfo.ColumnName), columnInfo.ColumnName); } gvch.ToolTip = CurrentApp.GetLanguageInfo(string.Format("COL3101001{0}", columnInfo.ColumnName), columnInfo.ColumnName); gvc.Header = gvch; gvc.Width = columnInfo.Width; if (columnInfo.ColumnName == "State" || columnInfo.ColumnName == "ViewClassic" || columnInfo.ColumnName == "ScoreType" || columnInfo.ColumnName == "Operation") { DataTemplate dt; if (columnInfo.ColumnName == "State") { dt = Resources["CellStateTemplate"] as DataTemplate; if (dt != null) { gvc.CellTemplate = dt; } else { gvc.DisplayMemberBinding = new Binding(columnInfo.ColumnName); } } if (columnInfo.ColumnName == "ViewClassic") { dt = Resources["CellViewClassicTemplate"] as DataTemplate; if (dt != null) { gvc.CellTemplate = dt; } else { gvc.DisplayMemberBinding = new Binding(columnInfo.ColumnName); } } if (columnInfo.ColumnName == "ScoreType") { dt = Resources["CellScoreTypeTemplate"] as DataTemplate; if (dt != null) { gvc.CellTemplate = dt; } else { gvc.DisplayMemberBinding = new Binding(columnInfo.ColumnName); } } if (columnInfo.ColumnName == "Operation") { dt = Resources["CellOperationTemplate"] as DataTemplate; if (dt != null) { gvc.CellTemplate = dt; } else { gvc.DisplayMemberBinding = new Binding(columnInfo.ColumnName); } } } else { gvc.DisplayMemberBinding = new Binding(columnInfo.ColumnName); } gv.Columns.Add(gvc); } } LvScoreSheets.View = gv; } catch (Exception ex) { ShowException(ex.Message); } }
private void CreateKPIDetailColumns() { try { GridView gv = new GridView(); GridViewColumn gvc; GridViewColumnHeader gvch; for (int i = 0; i < mListKPIDetailColumns.Count; i++) { ViewColumnInfo columnInfo = mListKPIDetailColumns[i]; if (columnInfo.Visibility == "1") { gvc = new GridViewColumn(); gvch = new GridViewColumnHeader(); gvch.Content = columnInfo.Display; gvch.Content = CurrentApp.GetLanguageInfo(string.Format("COL4603001{0}", columnInfo.ColumnName), columnInfo.Display); gvch.ToolTip = CurrentApp.GetLanguageInfo(string.Format("COL4603001{0}", columnInfo.ColumnName), columnInfo.Display); gvc.Header = gvch; gvc.Width = columnInfo.Width; //下面这句话要屏蔽掉,因为这里开始就重新绑定了名字之后 那么后面的就不会走进去了 //gvc.DisplayMemberBinding = new Binding(columnInfo.ColumnName); DataTemplate dt = null; if (columnInfo.ColumnName == "StateType") { dt = Resources["CellStateTypeTemplate"] as DataTemplate; } if (dt != null) { gvc.CellTemplate = dt; } else { //但是如果没有走到资源里 那么 这里还是要写绑定的 gvc.DisplayMemberBinding = new Binding(columnInfo.ColumnName); } if (columnInfo.ColumnName == "Active") { gvc.DisplayMemberBinding = new Binding("StrActive"); } if (columnInfo.ColumnName == "Description") { gvc.DisplayMemberBinding = new Binding("StrDescription"); } if (columnInfo.ColumnName == "UseType") { gvc.DisplayMemberBinding = new Binding("StrUseType"); } if (columnInfo.ColumnName == "ApplyCycle") { gvc.DisplayMemberBinding = new Binding("StrApplyCycle"); } //gvc.DisplayMemberBinding = new Binding(columnInfo.ColumnName); gv.Columns.Add(gvc); } } LvRecordScoreDetail.View = gv; } catch (Exception ex) { ShowException(ex.Message); } }
private void CreateColumnsItems() { try { GridView gv = new GridView(); GridViewColumn gvc; GridViewColumnHeader gvch; for (int i = 0; i < mListColumnItems.Count; i++) { ViewColumnInfo columnInfo = mListColumnItems[i]; if (columnInfo.Visibility == "1") { gvc = new GridViewColumn(); gvch = new GridViewColumnHeader(); gvch.Content = columnInfo.Display; gvch.Content = CurrentApp.GetLanguageInfo(string.Format("COL{0}{1}", mViewID, columnInfo.ColumnName), columnInfo.Display); gvch.ToolTip = CurrentApp.GetLanguageInfo(string.Format("COL{0}{1}", mViewID, columnInfo.ColumnName), columnInfo.Display); gvc.Header = gvch; gvc.Width = columnInfo.Width; DataTemplate dt = null; if (columnInfo.ColumnName == "Icon") { dt = Resources["IconCellTemplate"] as DataTemplate; } if (columnInfo.ColumnName == "IsEnabled") { dt = Resources["StateCellTemplate"] as DataTemplate; } if (columnInfo.ColumnName == "Operation") { dt = Resources["OperationCellTemplate"] as DataTemplate; } if (dt == null) { string strColName = columnInfo.ColumnName; if (strColName == "StartType") { strColName = "StrStartType"; } if (strColName == "CTIType") { strColName = "StrCTIType"; } if (strColName == "DeviceType") { strColName = "StrDeviceType"; } if (strColName == "MonitorMode") { strColName = "StrMonitorMode"; } gvc.DisplayMemberBinding = new Binding(strColName); } else { gvc.CellTemplate = dt; } gv.Columns.Add(gvc); } } LvResourceObjects.View = gv; } catch (Exception ex) { ShowException("CreateColumnsItems:" + ex.Message); } }