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);
}
}
