public static IEnumerable GetDataList(MyDataService.DataSetData data)
{
if (data.Tables.Count == 0)
return null;
MyDataService.DataTableInfo tableInfo = data.Tables[0];
System.Type dataType = BuildDataObjectType(tableInfo.Columns, "MyDataObject");
//ObservableCollection<DataObject> l = new ObservableCollection<DataObject>();
var listType = typeof(ObservableCollection<>).MakeGenericType(new[] { dataType });
var list = Activator.CreateInstance(listType);
XDocument xd = XDocument.Parse(data.DataXML);
var table = from row in xd.Descendants(tableInfo.TableName)
select row.Elements().ToDictionary(r => r.Name, r => r.Value);
foreach (var r in table)
{
var rowData = Activator.CreateInstance(dataType) as DataObject;
if (rowData != null)
{
foreach (MyDataService.DataColumnInfo col in tableInfo.Columns)
{
if (r.ContainsKey(col.ColumnName) && col.DataTypeName != typeof(System.Byte[]).FullName && col.DataTypeName != typeof(System.Guid).FullName)
rowData.SetFieldValue(col.ColumnName, r[col.ColumnName], true);
}
}
listType.GetMethod("Add").Invoke(list, new[] { rowData });
}
ObservableCollection<DataObject> l = list as ObservableCollection<DataObject>;
return list as IEnumerable;
}
public IActionResult About()
{
var misDatos = new MyDataService();
var model = misDatos.ObtenerDatos();
return(View(model));
}
public void WhereLikeTest()
{
var service = new MyDataService();
var options = new QueryOptions
{
};
var data = service.GetCustAddrCountListLike(options, "FirstName", "%ja%");
Assert.Equal(2, data.Count);
}
public void PagingTest()
{
var service = new MyDataService();
var options = new QueryOptions
{
ApplyPagination = true,
PageSize = 5
};
var data = service.GetCustAddrCountList(options);
Assert.Equal(5, data.Count);
Assert.True(options.PageReturnTotalCount > 0);
}
public IEnumerable <IVm> Get(VmKind vmKind)
{
var dataService = new MyDataService();
return(dataService.Get(vmKind));
}
void ws_GetDataSetDataCompleted(object sender, MyDataService.GetDataSetDataCompletedEventArgs e)
{
if (e.Error != null)
return;
else if (e.ServiceError != null)
return;
IEnumerable list = DynamicDataBuilder.GetDataList(e.Result);
theGrid.Columns.Clear();
theGrid.ItemsSource = DynamicDataBuilder.GetDataList(e.Result);
theGrid.HorizontalContentAlignment = HorizontalAlignment.Center;
}
void ws_GetDataSetDataCompleted(object sender, MyDataService.GetDataSetDataCompletedEventArgs e)
{
if (e.Error != null)
return;
else if (e.ServiceError != null)
return;
//添加Seri
var _ColumnSeri = new ColumnSeries();
_ColumnSeri.ItemsSource = DynamicDataBuilder.GetDataList(e.Result);
_ColumnSeri.Title = _BarName;
if (e.Result.Tables.Count > 0)
{
int Number = 0;
if (e.Result.Tables[0].Columns.Count >= 2)
{
foreach (MyDataService.DataColumnInfo column in e.Result.Tables[0].Columns)
{
if (Number == 0)
_ColumnSeri.IndependentValuePath = column.ColumnName;
else if (Number == 1)
{
if (column.DataTypeName == "System.String")
{
return;
}
_ColumnSeri.DependentValuePath = column.ColumnName;
}
Number++;
}
}
}
_Chart.Title = _TitleName;
_Chart.Series.Clear();
_Chart.Axes.Clear();
_Chart.Axes.Add(new CategoryAxis() { Title=_XaxisName, Orientation= AxisOrientation.X });
_Chart.Axes.Add(new LinearAxis(){Title = _YaxisName,Orientation = AxisOrientation.Y });
_Chart.Series.Add(_ColumnSeri);
}
