private bool Form_LoadControl(object sender, object data)
{
//交易指令表
TSDataGridViewHelper.AddColumns(this.gridView, _gridConfig.GetGid(GridId));
Dictionary <string, string> colDataMap = GridViewBindingHelper.GetPropertyBinding(typeof(CommandManagementItem));
TSDataGridViewHelper.SetDataBinding(this.gridView, colDataMap);
//交易证券表
TSDataGridViewHelper.AddColumns(this.secuGridView, _gridConfig.GetGid(GridSecurityId));
colDataMap = GridViewBindingHelper.GetPropertyBinding(typeof(CommandManagementSecurityItem));
TSDataGridViewHelper.SetDataBinding(this.secuGridView, colDataMap);
//委托证券表
TSDataGridViewHelper.AddColumns(this.entrustGridView, _gridConfig.GetGid(GridEntrustId));
colDataMap = GridViewBindingHelper.GetPropertyBinding(typeof(CommandManagementEntrustItem));
TSDataGridViewHelper.SetDataBinding(this.entrustGridView, colDataMap);
//成交证券表
TSDataGridViewHelper.AddColumns(this.dealGridView, _gridConfig.GetGid(GridDealId));
colDataMap = GridViewBindingHelper.GetPropertyBinding(typeof(CommandManagementDealItem));
TSDataGridViewHelper.SetDataBinding(this.dealGridView, colDataMap);
this.gridView.DataSource = _dataSource;
this.secuGridView.DataSource = _secuDataSource;
this.entrustGridView.DataSource = _entrustDataSource;
this.dealGridView.DataSource = _dealDataSource;
return(true);
}
private bool Form_LoadControl(object sender, object data)
{
TSDataGridViewHelper.AddColumns(this.gridView, _gridConfig.GetGid(GridId));
Dictionary <string, string> colDataMap = GridViewBindingHelper.GetPropertyBinding(typeof(InstanceItem));
TSDataGridViewHelper.SetDataBinding(this.gridView, colDataMap);
this.gridView.DataSource = _dataSource;
return(true);
}
private bool Form_LoadControl(object sender, object data)
{
TSDataGridViewHelper.AddColumns(this.dataGridView, _gridConfig.GetGid(GridId));
Dictionary <string, string> colDataMap = GridViewBindingHelper.GetPropertyBinding(typeof(MonitorUnit));
TSDataGridViewHelper.SetDataBinding(this.dataGridView, colDataMap);
LoadBottomButton();
return(true);
}
private bool Form_LoadControl(object sender, object data)
{
//Load Command Trading
TSDataGridViewHelper.AddColumns(this.gridView, _gridConfig.GetGid(GridId));
Dictionary <string, string> gridColDataMap = GridViewBindingHelper.GetPropertyBinding(typeof(EntrustSecurityItem));
TSDataGridViewHelper.SetDataBinding(this.gridView, gridColDataMap);
this.gridView.DataSource = _dataSource;
return(true);
}
private bool Form_LoadControl(object sender, object data)
{
//Load Command Trading
TSDataGridViewHelper.AddColumns(this.secuGridView, _gridConfig.GetGid(GridCancelRedoId));
Dictionary <string, string> gridColDataMap = GridViewBindingHelper.GetPropertyBinding(typeof(CancelRedoItem));
TSDataGridViewHelper.SetDataBinding(this.secuGridView, gridColDataMap);
this.secuGridView.DataSource = _secuDataSource;
//Load combobox
LoadEntrustControl();
return(true);
}
private void Form_Load(object sender, EventArgs e)
{
GridConfig gridConfig = ConfigManager.Instance.GetGridConfig();
TSGrid hsGrid = gridConfig.GetGid("templatestock");
TSDataGridViewHelper.AddColumns(this.tsDataGridView1, hsGrid);
Dictionary <string, string> colFieldMap = GridViewBindingHelper.GetPropertyBinding(typeof(TemplateStock));
TSDataGridViewHelper.SetDataBinding(this.tsDataGridView1, colFieldMap);
var stocks = GenerateData(hsGrid);
_tempStocks = new SortableBindingList <TemplateStock>(stocks);
this.tsDataGridView1.DataSource = _tempStocks;
}
private void Form_Load(object sender, EventArgs e)
{
TSGrid hsGrid = GetGridConfig();
TSDataGridViewHelper.AddColumns(this.tsDataGridView1, hsGrid);
Dictionary <string, string> columnMap = GridViewBindingHelper.GetPropertyBinding(typeof(NumericItem));
TSDataGridViewHelper.SetDataBinding(this.tsDataGridView1, columnMap);
this.tsDataGridView1.DataSource = _dataSource;
//Load Data
var listData = GetData();
foreach (var item in listData)
{
_dataSource.Add(item);
}
}
private bool Form_LoadControl(object sender, object data)
{
//set the tempGridView
TSDataGridViewHelper.AddColumns(this.tempGridView, _gridConfig.GetGid(GridTemplate));
Dictionary <string, string> tempColDataMap = GridViewBindingHelper.GetPropertyBinding(typeof(StockTemplate));
TSDataGridViewHelper.SetDataBinding(this.tempGridView, tempColDataMap);
//set the secuGridView
TSDataGridViewHelper.AddColumns(this.secuGridView, _gridConfig.GetGid(GridStock));
Dictionary <string, string> securityColDataMap = GridViewBindingHelper.GetPropertyBinding(typeof(TemplateStock));
TSDataGridViewHelper.SetDataBinding(this.secuGridView, securityColDataMap);
this.tempGridView.DataSource = _tempDataSource;
this.secuGridView.DataSource = _spotDataSource;
return(true);
}
private bool Form_LoadControl(object sender, object data)
{
TSDataGridViewHelper.AddColumns(this.srcGridView, _gridConfig.GetGid(GridSourceId));
Dictionary <string, string> colDataMap = GridViewBindingHelper.GetPropertyBinding(typeof(SourceHoldingItem));
TSDataGridViewHelper.SetDataBinding(this.srcGridView, colDataMap);
this.srcGridView.DataSource = _srcDataSource;
TSDataGridViewHelper.AddColumns(this.destGridView, _gridConfig.GetGid(GridDestId));
colDataMap = GridViewBindingHelper.GetPropertyBinding(typeof(DestinationHoldingItem));
TSDataGridViewHelper.SetDataBinding(this.destGridView, colDataMap);
this.destGridView.DataSource = _destDataSource;
LoadTradeDirectionOption();
//Load child control
LoadProductControl();
return(true);
}
private bool Form_LoadControl(object sender, object data)
{
//set the monitorGridView
TSDataGridViewHelper.AddColumns(this.monitorGridView, _gridConfig.GetGid(MonitorGridId));
Dictionary <string, string> monitorColDataMap = GridViewBindingHelper.GetPropertyBinding(typeof(OpenPositionItem));
TSDataGridViewHelper.SetDataBinding(this.monitorGridView, monitorColDataMap);
//set the securityGridView
TSDataGridViewHelper.AddColumns(this.securityGridView, _gridConfig.GetGid(SecurityGridId));
Dictionary <string, string> securityColDataMap = GridViewBindingHelper.GetPropertyBinding(typeof(OpenPositionSecurityItem));
TSDataGridViewHelper.SetDataBinding(this.securityGridView, securityColDataMap);
//Load bottom button
LoadBottomButton();
this.monitorGridView.DataSource = _monitorDataSource;
this.securityGridView.DataSource = _securityDataSource;
return(true);
}
private void Form_Load(object sender, EventArgs e)
{
TSGrid hsGrid = GetGridConfig();
TSDataGridViewHelper.AddColumns(this.tsDataGridView1, hsGrid);
Dictionary <string, string> columnMap = GridViewBindingHelper.GetPropertyBinding(typeof(TSDGVCbItem));
TSDataGridViewHelper.SetDataBinding(this.tsDataGridView1, columnMap);
//List<ComboOptionItem> cbItems = new List<ComboOptionItem>() { "Cb1", "Cb2", "Cb3", "Cb4" };
ComboOption cbOption = GetComboBoxData();
TSDataGridViewHelper.SetDataBinding(this.tsDataGridView1, "combobox", cbOption);
this.tsDataGridView1.DataSource = _dataSource;
//Load Data
var listData = GetData();
foreach (var item in listData)
{
_dataSource.Add(item);
}
}
private Model.Data.DataTable GridToExecl(List <TemplateStock> tempStocks, out List <DataHeader> cellRanges)
{
TSGrid hsGrid = _gridConfig.GetGid(GridStock);
var gridColumns = hsGrid.Columns;
var sheetConfig = ConfigManager.Instance.GetImportConfig().GetSheet("stocktemplate");
cellRanges = sheetConfig.Columns;
var sheetColumns = ConfigManager.Instance.GetImportConfig().GetColumnHeader(cellRanges);
Dictionary <string, DataColumnHeader> colHeadMap = new Dictionary <string, DataColumnHeader>();
foreach (var column in sheetColumns)
{
//colHeadMap.Add(column.Name, column);
var gridColumn = gridColumns.Find(p => p.Text.Equals(column.Name));
if (gridColumn != null)
{
if (!colHeadMap.ContainsKey(gridColumn.Name))
{
colHeadMap.Add(gridColumn.Name, column);
}
}
}
//实体类标签名与Excel DataTable DataRow.Columns中列索引映射表
Dictionary <string, int> excelNameColumnIndexMap = new Dictionary <string, int>();
for (int i = 0, count = sheetColumns.Count; i < count; i++)
{
if (!excelNameColumnIndexMap.ContainsKey(sheetColumns[i].Name))
{
excelNameColumnIndexMap.Add(sheetColumns[i].Name, i);
}
}
Dictionary <string, int> fieldNameColumnIndexMap = new Dictionary <string, int>();
for (int i = 0, count = gridColumns.Count; i < count; i++)
{
var column = gridColumns[i];
int index = sheetColumns.FindIndex(p => p.Name.Equals(column.Text));
if (index >= 0)
{
if (!fieldNameColumnIndexMap.ContainsKey(column.Name))
{
fieldNameColumnIndexMap.Add(column.Name, index);
}
}
}
Model.Data.DataTable table = new Model.Data.DataTable
{
ColumnIndex = new Dictionary <string, int>(),
Rows = new List <Model.Data.DataRow>()
};
table.ColumnIndex = excelNameColumnIndexMap;
var attFieldMap = GridViewBindingHelper.GetPropertyBinding(typeof(TemplateStock));
foreach (var tempStock in tempStocks)
{
Model.Data.DataRow dataRow = new Model.Data.DataRow
{
Columns = new List <DataValue>(new DataValue[table.ColumnIndex.Count])
};
foreach (var kv in attFieldMap)
{
if (!attFieldMap.ContainsKey(kv.Key) || !fieldNameColumnIndexMap.ContainsKey(kv.Key))
{
continue;
}
string fieldName = attFieldMap[kv.Key];
int valIndex = fieldNameColumnIndexMap[kv.Key];
var field = tempStock.GetType().GetProperty(fieldName);
if (field == null)
{
continue;
}
Model.Data.DataValue dataValue = new DataValue();
if (colHeadMap.ContainsKey(kv.Key))
{
dataValue.Type = colHeadMap[kv.Key].Type;
}
dataValue.Value = field.GetValue(tempStock, null);
dataRow.Columns[valIndex] = dataValue;
if (valIndex >= 0 && valIndex < dataRow.Columns.Count)
{
dataRow.Columns[valIndex] = dataValue;
}
}
table.Rows.Add(dataRow);
}
return(table);
}
private List <TemplateStock> ExcelToGrid(Model.Data.DataTable excelData)
{
List <TemplateStock> stockList = new List <TemplateStock>();
var template = GetSelectTemplate();
if (template == null)
{
return(stockList);
}
//用于获取二维表表头名字与Excel中表头进行匹配，获取Excel DataTable中列的位置
TSGrid hsGrid = _gridConfig.GetGid(GridStock);
var gridColumns = hsGrid.Columns;
//标签与属性名映射表
var attFieldMap = GridViewBindingHelper.GetPropertyBinding(typeof(TemplateStock));
//实体类标签名与Excel DataTable DataRow.Columns中列索引映射表
Dictionary <string, int> fieldNameColumnIndexMap = new Dictionary <string, int>();
for (int i = 0, count = gridColumns.Count; i < count; i++)
{
var column = gridColumns[i];
string origtext = column.Text;
string text = origtext;
if (text.Contains("(%)"))
{
text = text.Replace("(%)", string.Empty);
}
if (excelData.ColumnIndex.ContainsKey(origtext))
{
if (!fieldNameColumnIndexMap.ContainsKey(column.Name))
{
fieldNameColumnIndexMap.Add(column.Name, excelData.ColumnIndex[origtext]);
}
}
else if (excelData.ColumnIndex.ContainsKey(text))
{
if (!fieldNameColumnIndexMap.ContainsKey(column.Name))
{
fieldNameColumnIndexMap.Add(column.Name, excelData.ColumnIndex[text]);
}
}
}
foreach (var row in excelData.Rows)
{
TemplateStock stock = new TemplateStock();
stock.TemplateNo = template.TemplateId;
foreach (var kv in fieldNameColumnIndexMap)
{
if (!attFieldMap.ContainsKey(kv.Key) || !fieldNameColumnIndexMap.ContainsKey(kv.Key))
{
continue;
}
string fieldName = attFieldMap[kv.Key];
int valIndex = fieldNameColumnIndexMap[kv.Key];
var field = stock.GetType().GetProperty(fieldName);
if (field == null || !field.CanWrite)
{
continue;
}
DataValueType valType = DataValueType.String;
var gridColomn = gridColumns.Find(p => p.Name.Equals(kv.Key));
if (gridColomn != null)
{
valType = gridColomn.ValueType;
}
var val = row.Columns[valIndex];
if (val != null)
{
switch (val.Type)
{
case DataValueType.Int:
field.SetValue(stock, val.GetInt());
break;
case DataValueType.Float:
field.SetValue(stock, val.GetDouble());
break;
case DataValueType.String:
if (valType == DataValueType.Int)
{
field.SetValue(stock, val.GetInt());
}
else if (valType == DataValueType.Float)
{
field.SetValue(stock, val.GetDouble());
}
else
{
field.SetValue(stock, val.GetStr());
}
break;
default:
break;
}
}
else
{
}
}
if (!string.IsNullOrEmpty(stock.SecuCode))
{
var secuInfo = _securityInfoList.Find(p => p.SecuCode.Equals(stock.SecuCode) && p.SecuType == SecurityType.Stock);
if (secuInfo != null)
{
stock.SecuName = secuInfo.SecuName;
stock.Exchange = secuInfo.ExchangeCode;
}
}
stockList.Add(stock);
}
return(stockList);
}
