public void TestProduct1()
{
IProductFactory pf = new MockProductFactory();
string xmlPath = Path.Combine(Environment.CurrentDirectory, "ProductSample.xml");
ProductBase product = pf.CreateProduct("TestProduct", xmlPath);
// as if we are taking order transactions from database
Dictionary <string, object> row = new Dictionary <string, object>();
row.Add("Amount", 3000);
//row.Add("Amount", (Decimal)3000);
//row.Add("Amount", DBNull.Value);
//row.Add("Amount", null);
row.Add("DealPrice", (Decimal)1.25);
row.Add("DealerID", "Somebody");
IDataSourceStore dsStore = new DataSourceStore();
IDataSource ds = new TableDataSource(row);
dsStore.AddDataSource(ds);
foreach (var evDef in product.GetHoldEvents(dsStore))
{
foreach (var result in product.TakeReactionsFor(evDef, dsStore))
{
Decimal amount = (Decimal)result.Item2["Amount"];
Assert.AreEqual <Decimal>(-3000, amount);
// insert dictionary columns into database accounting table
}
}
}
public void SETFASTREPORT4()
{
//20210902密
Class1 TKID = new Class1();//用new 建立類別實體
SqlConnectionStringBuilder sqlsb = new SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString);
//資料庫使用者密碼解密
sqlsb.Password = TKID.Decryption(sqlsb.Password);
sqlsb.UserID = TKID.Decryption(sqlsb.UserID);
String connectionString;
sqlConn = new SqlConnection(sqlsb.ConnectionString);
StringBuilder SQL1 = new StringBuilder();
SQL1 = SETSQL4();
Report report4 = new Report();
report4.Load(@"REPORT\訂單排產狀況表.frx");
report4.Dictionary.Connections[0].ConnectionString = sqlsb.ConnectionString;
TableDataSource table = report4.GetDataSource("Table") as TableDataSource;
table.SelectCommand = SQL1.ToString();
report4.Preview = previewControl4;
report4.Show();
}
public void SETFASTREPORT2()
{
string SQL;
string SQL2;
report1 = new Report();
report1.Load(@"REPORT\原物料的進貨矩陣.frx");
// 20210902密
Class1 TKID = new Class1();//用new 建立類別實體
SqlConnectionStringBuilder sqlsb = new SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString);
//資料庫使用者密碼解密
sqlsb.Password = TKID.Decryption(sqlsb.Password);
sqlsb.UserID = TKID.Decryption(sqlsb.UserID);
String connectionString;
sqlConn = new SqlConnection(sqlsb.ConnectionString);
report1.Dictionary.Connections[0].ConnectionString = sqlsb.ConnectionString;
//report1.Dictionary.Connections[0].ConnectionString = "server=192.168.1.105;database=TKPUR;uid=sa;pwd=dsc";
TableDataSource Table = report1.GetDataSource("Table") as TableDataSource;
SQL = SETFASETSQL2();
Table.SelectCommand = SQL;
report1.Preview = previewControl2;
report1.Show();
}
public void SETFASTREPORT()
{
StringBuilder SQL = new StringBuilder();
Report report1 = new Report();
if (comboBox5.Text.Equals("遊覽車對帳明細表"))
{
report1.Load(@"REPORT\遊覽車對帳明細表.frx");
SQL = SETSQL();
}
else if (comboBox5.Text.Equals("多年期月份團務比較表"))
{
report1.Load(@"REPORT\多年期月份團務比較表.frx");
SQL = SETSQL2();
}
report1.Dictionary.Connections[0].ConnectionString = ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString;
TableDataSource table = report1.GetDataSource("Table") as TableDataSource;
table.SelectCommand = SQL.ToString();
report1.SetParameterValue("P1", dateTimePicker4.Value.ToString("yyyy/MM/dd"));
report1.SetParameterValue("P2", dateTimePicker5.Value.ToString("yyyy/MM/dd"));
report1.Preview = previewControl1;
report1.Show();
}
protected void BeginInsertBatch(Action<IEnumerable<TableStorageOperationState>> action)
{
var ds = new TableDataSource<TableEntry>();
int enteries = DEFAULT_ENTERIES;
if (txtEnteries.Text != "")
enteries = Convert.ToInt32(txtEnteries.Text);
int size = DEFAULT_SIZE;
if (txtSize.Text != "")
size = Convert.ToInt32(txtSize.Text);
byte[] data = new byte[size];
var list = new List<TableEntry>();
for (int i = 0; i < enteries; i++)
{
// Spread partition key into groups with the max entity transaction count
string partitionKey = Math.Ceiling((double)(i+1) / (Data.Constants.MAX_ENTITY_TRANSACTION_COUNT * Convert.ToInt32(txtPartitions.Text))).ToString();
list.Add(new TableEntry(partitionKey, data));
}
ds.AddTableEntryAsync(list, action);
}
private void LoadDataSources(Dictionary <string, Dictionary <string, object> > configuration)
{
foreach (KeyValuePair <string, Dictionary <string, object> > sourceEntry in configuration)
{
string name = sourceEntry.Key;
string type = (string)sourceEntry.Value["type"];
if (type == "sql")
{
_dataSources[name] = new SqlDataSource(_app, name, sourceEntry.Value);
Runtime.TraceInfo("Created sql data source named '%s'.", name);
}
else if (type == "tableStorage")
{
_dataSources[name] = new TableDataSource(_app, name, sourceEntry.Value);
Runtime.TraceInfo("Created table storage data source named '%s'.", name);
}
else if (type == "inproc")
{
_dataSources[name] = new InprocDataSource(_app, name, sourceEntry.Value);
Runtime.TraceInfo("Created local in-memory data source named '%s'.", name);
}
else
{
Runtime.Abort("Missing or invalid type attribute for data source named '%s'.", name);
}
}
}
private void Initialization()
{
if (tableDataSource == null)
{
DataTable filterRefTable = DataSourceHelper.GetDataTable(DataSource);
// Initialization SessionWorker
if (SessionWorker == null)
{
var sw = new SessionWorker {
Key = Guid.NewGuid().ToString()
};
sw.SetSession(HttpContext.Current.Session);
sw.Object = filterRefTable.DataSet;
SessionWorker = sw;
}
// Initialization tableDataSource
Type tableAdapterType =
TableAdapterTools.GetTableAdapterType(filterRefTable.GetType());
tableDataSource = new TableDataSource
{
ID = "tableDataSource_ID",
TypeName = tableAdapterType.FullName,
SelectMethod = this._storage.SelectMethod,
FillType = TableDataSourceFillType.ParametersNotChanged,
SessionWorker = this.SessionWorker,
SetFilterByCustomConditions = false,
};
tableDataSource.View.CustomConditions.AddRange(_storage.CustomConditions);
}
}
public MyTableView()
{
InitializeComponent();
Delegate = new TableDelegate();
DataSource = new TableDataSource();
}
public void SETFASTREPORT5(string SDAY, string TG006)
{
//20210902密
Class1 TKID = new Class1();//用new 建立類別實體
SqlConnectionStringBuilder sqlsb = new SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString);
//資料庫使用者密碼解密
sqlsb.Password = TKID.Decryption(sqlsb.Password);
sqlsb.UserID = TKID.Decryption(sqlsb.UserID);
String connectionString;
sqlConn = new SqlConnection(sqlsb.ConnectionString);
StringBuilder SQL1 = new StringBuilder();
SQL1 = SETSQL5(SDAY, TG006);
Report report1 = new Report();
report1.Load(@"REPORT\銷售年報-業務員-客戶.frx");
report1.Dictionary.Connections[0].ConnectionString = sqlsb.ConnectionString;
TableDataSource table = report1.GetDataSource("Table") as TableDataSource;
table.SelectCommand = SQL1.ToString();
//report1.SetParameterValue("P1", dateTimePicker1.Value.ToString("yyyyMMdd"));
//report1.SetParameterValue("P2", dateTimePicker2.Value.ToString("yyyyMMdd"));
report1.Preview = previewControl4;
report1.Show();
}
public TableEntriesFactory(TableDataSource source, Workspace workspace, DocumentId documentId) :
base(source)
{
_source = source;
_workspace = workspace;
_documentId = documentId;
}
public void SETFASTREPORT()
{
//20210902密
Class1 TKID = new Class1();//用new 建立類別實體
SqlConnectionStringBuilder sqlsb = new SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString);
//資料庫使用者密碼解密
sqlsb.Password = TKID.Decryption(sqlsb.Password);
sqlsb.UserID = TKID.Decryption(sqlsb.UserID);
String connectionString;
sqlConn = new SqlConnection(sqlsb.ConnectionString);
string SQL;
report1 = new Report();
report1.Load(@"REPORT\業務商品排名表.frx");
report1.Dictionary.Connections[0].ConnectionString = sqlsb.ConnectionString;
TableDataSource Table = report1.GetDataSource("Table") as TableDataSource;
SQL = SETFASETSQL();
Table.SelectCommand = SQL;
report1.Preview = previewControl1;
report1.Show();
}
public void SETFASTREPORT()
{
string SQL;
Report report1 = new Report();
report1.Load(@"REPORT\每月個人伙食費統計表.frx");
//20210902密
Class1 TKID = new Class1();//用new 建立類別實體
SqlConnectionStringBuilder sqlsb = new SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString);
//資料庫使用者密碼解密
sqlsb.Password = TKID.Decryption(sqlsb.Password);
sqlsb.UserID = TKID.Decryption(sqlsb.UserID);
String connectionString;
sqlConn = new SqlConnection(sqlsb.ConnectionString);
report1.Dictionary.Connections[0].ConnectionString = sqlsb.ConnectionString;
//report1.Dictionary.Connections[0].ConnectionString = "server=192.168.1.105;database=TKPUR;uid=sa;pwd=dsc";
TableDataSource Table = report1.GetDataSource("Table") as TableDataSource;
SQL = SETFASETSQL();
report1.SetParameterValue("P1", dateTimePicker1.Value.ToString("yyyy/MM/dd"));
Table.SelectCommand = SQL;
report1.Preview = previewControl1;
report1.Show();
}
public void SETFASTREPORT()
{
//20210902密
Class1 TKID = new Class1();//用new 建立類別實體
SqlConnectionStringBuilder sqlsb = new SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString);
//資料庫使用者密碼解密
sqlsb.Password = TKID.Decryption(sqlsb.Password);
sqlsb.UserID = TKID.Decryption(sqlsb.UserID);
String connectionString;
sqlConn = new SqlConnection(sqlsb.ConnectionString);
StringBuilder SQL1 = new StringBuilder();
SQL1 = SETSQL();
Report report1 = new Report();
report1.Load(@"REPORT\銷售商品-客戶表.frx");
report1.Dictionary.Connections[0].ConnectionString = sqlsb.ConnectionString;
TableDataSource table = report1.GetDataSource("Table") as TableDataSource;
table.SelectCommand = SQL1.ToString();
//report1.SetParameterValue("P1", textBox1.Text);
//report1.SetParameterValue("P2", textBox2.Text);
report1.Preview = previewControl1;
report1.Show();
}
protected void btnRecreate_Click(object sender, EventArgs e)
{
var ds = new TableDataSource<TableEntry>();
ds.DeleteTestTable();
System.Threading.Thread.Sleep(40000);
ds.CreateTestTable();
}
private async void btnDeleteAll_Click(object sender, RoutedEventArgs e)
{
if (await TableDataSource.DeleteEntities(tablelist))
{
tablelist = null;
lstEntities.ItemsSource = null;
}
}
public QueryWizardForm(TableDataSource table)
{
FTable = table;
InitializeComponent();
Localize();
Init();
Config.RestoreFormState(this);
}
private void SetDetails()
{
TableDataSource dataSource = new TableDataSource();
dataSource.Table = Table;
report.Page.Details.DataSource = dataSource;
}
public TableEntriesFactory(TableDataSource source, Workspace workspace, ProjectId projectId, DocumentId documentId, object id)
{
_source = source;
_workspace = workspace;
_projectId = projectId;
_documentId = documentId;
_id = id;
}
public async Task LintSolutionUseTsconfigs()
{
MockUIHierarchyItem mockSolutionHierarchyItem = new MockUIHierarchyItem()
{
Object = solution
};
UIHierarchyItem[] selectedItems = new UIHierarchyItem[] { mockSolutionHierarchyItem };
MockErrorsTableDataSource mockErrorsTableDataSource = new MockErrorsTableDataSource();
TableDataSource.InjectMockErrorsTableDataSource(mockErrorsTableDataSource);
settings.UseTsConfig = true;
try
{
bool hasVSErrors = await LintFilesCommandBase.LintLintLint(false, selectedItems);
Assert.IsFalse(hasVSErrors);
Assert.IsTrue(mockErrorsTableDataSource.HasErrors());
Assert.AreEqual(7, mockErrorsTableDataSource.Snapshots.Count);
// Note file5 is referenced by a tsconfig that isn't in the project, so doesn't get included
string expected1 = Path.GetFullPath(@"../../artifacts/tsconfig/multiple/a/file1.ts");
string expected2 = Path.GetFullPath(@"../../artifacts/tsconfig/multiple/b/file2.ts");
string expected3 = Path.GetFullPath(@"../../artifacts/tsconfig/multiple/b/file3.ts");
string expected4 = Path.GetFullPath(@"../../artifacts/tsconfig/multiple/a/c/file4.ts");
//string expected5 = Path.GetFullPath(@"../../artifacts/tsconfig/none/b/file5.ts");
string expected6 = Path.GetFullPath(@"../../artifacts/tsconfig/multiple/a/c/file6.tsx");
string expected7 = Path.GetFullPath(@"../../artifacts/tsconfig/multiple/file7.ts");
string expected8 = Path.GetFullPath(@"../../artifacts/tsconfig/multiple/test.ts");
Assert.IsTrue(mockErrorsTableDataSource.Snapshots.Keys.Contains(expected1));
Assert.IsTrue(mockErrorsTableDataSource.Snapshots.Keys.Contains(expected2));
Assert.IsTrue(mockErrorsTableDataSource.Snapshots.Keys.Contains(expected3));
Assert.IsTrue(mockErrorsTableDataSource.Snapshots.Keys.Contains(expected4));
//Assert.IsTrue(mockErrorsTableDataSource.Snapshots.Keys.Contains(expected5));
Assert.IsTrue(mockErrorsTableDataSource.Snapshots.Keys.Contains(expected6));
Assert.IsTrue(mockErrorsTableDataSource.Snapshots.Keys.Contains(expected7));
Assert.IsTrue(mockErrorsTableDataSource.Snapshots.Keys.Contains(expected8));
// Similar to TslintWithTsconfigTest.LintAll, again this level of detail may be too much
Assert.AreEqual(3, mockErrorsTableDataSource.Snapshots[expected1].Count());
Assert.AreEqual(4, mockErrorsTableDataSource.Snapshots[expected2].Count());
Assert.AreEqual(3, mockErrorsTableDataSource.Snapshots[expected3].Count());
Assert.AreEqual(3, mockErrorsTableDataSource.Snapshots[expected4].Count());
//Assert.AreEqual(4, mockErrorsTableDataSource.Snapshots[expected5].Count());
Assert.AreEqual(11, mockErrorsTableDataSource.Snapshots[expected6].Count());
Assert.AreEqual(4, mockErrorsTableDataSource.Snapshots[expected7].Count());
Assert.AreEqual(5, mockErrorsTableDataSource.Snapshots[expected8].Count());
}
finally
{
TableDataSource.InjectMockErrorsTableDataSource(null);
settings.UseTsConfig = false;
}
}
public void SETFASTREPORT()
{
//20210902密
Class1 TKID = new Class1();//用new 建立類別實體
SqlConnectionStringBuilder sqlsb = new SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString);
//資料庫使用者密碼解密
sqlsb.Password = TKID.Decryption(sqlsb.Password);
sqlsb.UserID = TKID.Decryption(sqlsb.UserID);
String connectionString;
sqlConn = new SqlConnection(sqlsb.ConnectionString);
StringBuilder SQL1 = new StringBuilder();
Report report1 = new Report();
if (comboBox1.Text.Trim().Equals("ERP各業務總金額"))
{
report1.Load(@"REPORT\ERP各業務總金額.frx");
SQL1 = SETSQL();
}
else if (comboBox1.Text.Trim().Equals("ERP各業務總金額、月份金額"))
{
report1.Load(@"REPORT\ERP各業務總金額、月份金額.frx");
SQL1 = SETSQL2();
}
else if (comboBox1.Text.Trim().Equals("ERP各業務總金額、月份、客戶金額"))
{
report1.Load(@"REPORT\ERP各業務總金額、月份、客戶金額.frx");
SQL1 = SETSQL3();
}
else if (comboBox1.Text.Trim().Equals("ERP各業務總金額、月份、客戶、商品金額"))
{
report1.Load(@"REPORT\ERP各業務總金額、月份、客戶、商品金額.frx");
SQL1 = SETSQL4();
}
else if (comboBox1.Text.Trim().Equals("ERP各商品合計"))
{
report1.Load(@"REPORT\ERP各商品合計.frx");
SQL1 = SETSQL5();
}
report1.Dictionary.Connections[0].ConnectionString = sqlsb.ConnectionString;
TableDataSource table = report1.GetDataSource("Table") as TableDataSource;
table.SelectCommand = SQL1.ToString();
//report1.SetParameterValue("P1", dateTimePicker1.Value.ToString("yyyyMMdd"));
//report1.SetParameterValue("P2", dateTimePicker2.Value.ToString("yyyyMMdd"));
report1.Preview = previewControl1;
report1.Show();
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
// Prepare table. We use standart data table
DataTable table = new DataTable();
table.Columns.Add("Sine", typeof(double));
table.Columns.Add("Time", typeof(DateTime));
table.Columns.Add("Index", typeof(int));
table.Columns.Add("Sqrt", typeof(double));
for (int i = 0; i < 100; i++)
{
table.Rows.Add(
Math.Sin(i / 10.0),
DateTime.Now + new TimeSpan(0, 0, i),
i,
Math.Sqrt(i));
}
// Prepare data source with mapping
TableDataSource data = new TableDataSource(table);
// X is time in seconds
data.SetXMapping(row => ((DateTime)row["Time"] - (DateTime)table.Rows[0][1]).TotalSeconds);
// Y is value of "Sine" column
data.SetYMapping(row => 10 * (double)row["Sine"]);
// Map HSB color computes from "Index" column to dependency property Brush of marker
data.AddMapping(ShapePointMarker.FillProperty,
row => new SolidColorBrush(new HsbColor(3 * (int)row["Index"], 1, 1).ToArgbColor()));
// Map "Sqrt" based values to marker size
data.AddMapping(ShapePointMarker.SizeProperty,
row => 4 + (double)row["Sqrt"]);
// Plot first graph
plotter.AddLineGraph(data,
new Pen(Brushes.Blue, 2),
new CirclePointMarker(),
new PenDescription("First series (Sine)"));
// Prepare data source for second graph. table.Rows is enumerable,
// so we can plot its contents as IEnumerable with items of TableRow type
EnumerableDataSource <DataRow> data2 = new EnumerableDataSource <DataRow>(table.Rows);
// X is time in seconds again
data2.SetXMapping(row => ((DateTime)row["Time"] - (DateTime)table.Rows[0][1]).TotalSeconds);
// Y is value of "Sqrt" column
data2.SetYMapping(row => (double)row["Sqrt"]);
// Plot second graph without markers
plotter.AddLineGraph(data2,
Colors.Red, 3.0,
"Second series (Sqrt)");
// Force evertyhing plotted to be visible
plotter.Viewport.FitToView();
}
public TableEntriesFactory(TableDataSource source, Workspace workspace, ProjectId projectId, DocumentId documentId, object id) :
base(source)
{
_source = source;
_workspace = workspace;
_projectId = projectId;
_documentId = documentId;
_id = id;
_errorSource = (id as ErrorSourceId)?.ErrorSource ?? string.Empty;
}
/// <summary>
/// Initializes a new instance of the <see cref="TableDataSourceFacts"/> class.
/// </summary>
public TableDataSourceFacts()
{
this.operation = Substitute.For <IDataOperationInfo>();
this.operation.OperationId.ReturnsForAnyArgs(Guid.NewGuid());
this.target = new TableDataSource(this.ConnectionFactory, "dbo.wibble")
{
Parent = this.operation
};
}
private async void btnDelete_Click(object sender, RoutedEventArgs e)
{
var entity = (DynamicTableEntity)lstEntities.SelectedItem;
if (await TableDataSource.DeleteEntity(entity))
{
tablelist.Remove(entity);
lstEntities.ItemsSource = tablelist;
}
}
protected VisualStudioBaseTodoListTable(
Workspace workspace,
ITodoListProvider todoListProvider,
string identifier,
ITableManagerProvider provider
) : base(workspace, provider, StandardTables.TasksTable)
{
_source = new TableDataSource(workspace, todoListProvider, identifier);
AddInitialTableSource(workspace.CurrentSolution, _source);
}
public TableEntriesSource(
TableDataSource source,
Workspace workspace,
DocumentId documentId
)
{
_source = source;
_workspace = workspace;
_documentId = documentId;
}
public void SETFASTREPORT2()
{
StringBuilder MID = new StringBuilder();
StringBuilder ID = new StringBuilder();
MID.Clear();
ID.Clear();
foreach (DataGridViewRow row in dataGridView4.Rows)
{
if (Convert.ToBoolean(row.Cells[0].Value))
{
MID.AppendFormat(@" '{0}',", row.Cells["MID"].Value.ToString());
ID.AppendFormat(@" '{0}',", row.Cells["ID"].Value.ToString());
}
}
MID.AppendFormat(@" '01e5cf12-ccd4-4d80-a767-0298eaed9bc2'");
ID.AppendFormat(@" '01e5cf12-ccd4-4d80-a767-0298eaed9bc2'");
string SQL;
string SQL2;
report1 = new Report();
report1.Load(@"REPORT\請購變更單明細.frx");
//20210902密
Class1 TKID = new Class1();//用new 建立類別實體
SqlConnectionStringBuilder sqlsb = new SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString);
//資料庫使用者密碼解密
sqlsb.Password = TKID.Decryption(sqlsb.Password);
sqlsb.UserID = TKID.Decryption(sqlsb.UserID);
String connectionString;
sqlConn = new SqlConnection(sqlsb.ConnectionString);
report1.Dictionary.Connections[0].ConnectionString = sqlsb.ConnectionString;
//report1.Dictionary.Connections[0].ConnectionString = "server=192.168.1.105;database=TKPUR;uid=sa;pwd=dsc";
TableDataSource Table = report1.GetDataSource("Table") as TableDataSource;
TableDataSource Table1 = report1.GetDataSource("Table1") as TableDataSource;
SQL = SETFASETSQL3(MID.ToString());
Table.SelectCommand = SQL;
SQL2 = SETFASETSQL4(ID.ToString());
Table1.SelectCommand = SQL2;
report1.Preview = previewControl2;
report1.Show();
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
// Prepare table. We use standart data table
DataTable table = new DataTable();
table.Columns.Add("Sine", typeof(double));
table.Columns.Add("Time", typeof(DateTime));
table.Columns.Add("Index", typeof(int));
table.Columns.Add("Sqrt", typeof(double));
for (int i = 0; i < 100; i++)
{
table.Rows.Add(
Math.Sin(i / 10.0),
DateTime.Now + new TimeSpan(0, 0, i),
i,
Math.Sqrt(i));
}
// Prepare data source with mapping
TableDataSource data = new TableDataSource(table);
// X is time in seconds
data.SetXMapping(row => ((DateTime)row["Time"] - (DateTime)table.Rows[0][1]).TotalSeconds);
// Y is value of "Sine" column
data.SetYMapping(row => 10 * (double)row["Sine"]);
// Map HSB color computes from "Index" column to dependency property Brush of marker
data.AddMapping(ShapePointMarker.FillProperty,
row => new SolidColorBrush(new HsbColor(3 * (int)row["Index"], 1, 1).ToArgbColor()));
// Map "Sqrt" based values to marker size
data.AddMapping(ShapePointMarker.SizeProperty,
row => 4 + (double)row["Sqrt"]);
// Plot first graph
plotter.AddLineGraph(data,
new Pen(Brushes.Blue, 2),
new CirclePointMarker(),
new PenDescription("First series (Sine)"));
// Prepare data source for second graph. table.Rows is enumerable,
// so we can plot its contents as IEnumerable with items of TableRow type
EnumerableDataSource<DataRow> data2 = new EnumerableDataSource<DataRow>(table.Rows);
// X is time in seconds again
data2.SetXMapping(row => ((DateTime)row["Time"] - (DateTime)table.Rows[0][1]).TotalSeconds);
// Y is value of "Sqrt" column
data2.SetYMapping(row => (double)row["Sqrt"]);
// Plot second graph without markers
plotter.AddLineGraph(data2,
Colors.Red, 3.0,
"Second series (Sqrt)");
// Force evertyhing plotted to be visible
plotter.Viewport.FitToView();
}
public override void CreateTable(TableDataSource source)
{
if (DataSet.Tables.Contains(source.TableName))
{
source.Table = DataSet.Tables[source.TableName];
base.CreateTable(source);
}
else
{
source.Table = null;
}
}
protected UIHierarchyItem[] Arrange(string solutionPath)
{
Initialize(solutionPath);
MockUIHierarchyItem mockSolutionHierarchyItem = new MockUIHierarchyItem()
{
Object = solution
};
selectedItems = new UIHierarchyItem[] { mockSolutionHierarchyItem };
mockErrorsTableDataSource = new MockErrorsTableDataSource();
TableDataSource.InjectMockErrorsTableDataSource(mockErrorsTableDataSource);
return(selectedItems);
}
//This will take a long time, because it require to delete the Table first,
//then recreate it and add data to it.
private async void btnRegenerate_Click(object sender, RoutedEventArgs e)
{
btnDelete.IsEnabled = false;
btnDeleteAll.IsEnabled = false;
btnRegenerate.IsEnabled = false;
if (await TableDataSource.DeleteTable())
{
tablelist = await TableDataSource.CreateSampleData();
lstEntities.ItemsSource = tablelist;
}
btnDelete.IsEnabled = true;
btnDeleteAll.IsEnabled = true;
btnRegenerate.IsEnabled = true;
}
public void SETFASTREPORT2()
{
string SQL;
report2 = new Report();
report2.Load(@"REPORT\業務客戶排名表.frx");
report2.Dictionary.Connections[0].ConnectionString = ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString;
TableDataSource Table = report2.GetDataSource("Table") as TableDataSource;
SQL = SETFASETSQL2();
Table.SelectCommand = SQL;
report2.Preview = previewControl2;
report2.Show();
}
public void TestIsEqual_DateTime_NotEqual_TableField()
{
Field sourceField = new LiteralField("DateTime", "sourceField", "2016-02-28");
Field targetField = new TableField("DateTime", "targetField");
SimpleCondition condition = new IsEqual(sourceField, targetField);
IDataSourceStore dsStore = new DataSourceStore();
IDataSource ds = new TableDataSource(new Dictionary <string, object>()
{
{ "targetField", "2016-02-27" }
});
bool isHold = condition.IsSimpleConditonHold(dsStore.AddDataSource(ds));
bool expected = false;
Assert.AreEqual <bool>(expected, isHold);
}
/// <summary>
/// Adds a file dataset (Shapefile or raster) to a new local dynamic map service layer.
/// </summary>
/// <param name="workspaceType">The workspace type (FileGDB, Raster, SDE, Shapefile) <see cref="http://resources.arcgis.com/en/help/runtime-wpf/apiref/index.html?ESRI.ArcGIS.Client.Local~ESRI.ArcGIS.Client.Local.WorkspaceFactoryType.html"/>.</param>
/// <param name="directoryPath">A <see cref="System.String"/> representing the directory path.</param>
/// <param name="fileNames">A <see cref="System.Collections.Generic.List{System.String}"/> representing the name of the file (for raster datasets this must include the extension).</param>
/// <param name="callback">The Action delegate to call back on once the dynamic layer work is complete.</param>
public void AddFileDatasetToDynamicMapServiceLayer(WorkspaceFactoryType workspaceType, string directoryPath, List<string> fileNames, Action<ArcGISLocalDynamicMapServiceLayer> callback)
{
try
{
// Generate a unique workspace ID (any unique string).
string uniqueId = Guid.NewGuid().ToString();
// Create a new WorkspaceInfo object with a unique ID.
WorkspaceInfo workspaceInfo = new WorkspaceInfo(uniqueId, workspaceType, "DATABASE=" + directoryPath);
// Create a new LocalMapService instance.
LocalMapService localMapService = new LocalMapService
{
// Set the path property.
Path = _emptyMpkPath,
// Enable the dynamic layers capability.
EnableDynamicLayers = true
};
// Register the workspace to be used with this service.
localMapService.DynamicWorkspaces.Add(workspaceInfo);
// Asynchronously start the local map service.
localMapService.StartAsync(x =>
{
// Create the local dynamic map service layer.
ArcGISLocalDynamicMapServiceLayer arcGisLocalDynamicMapServiceLayer = null;
// Create a new ArcGISLocalDynamicMapServiceLayer passing in the newly started local service.
arcGisLocalDynamicMapServiceLayer = new ArcGISLocalDynamicMapServiceLayer(localMapService)
{
// Assign the filename as the map layer ID.
ID = "Workspace: " + (new DirectoryInfo(directoryPath)).Name,
// Enable the dynamic layers capability.
EnableDynamicLayers = true,
};
// Handle the layer initialized event inline to perform the layer dynamic layer management.
arcGisLocalDynamicMapServiceLayer.Initialized += (s, e) =>
{
// Create a DynamicLayerInfoCollection to hold the new datasets as "dynamic layers".
DynamicLayerInfoCollection dynamicLayerInfoCollection = new DynamicLayerInfoCollection();
// Create a LayerDrawingOptionsCollection to specify the symbology for each layer.
LayerDrawingOptionsCollection layerDrawingOptionsCollection = new LayerDrawingOptionsCollection();
// Iterate over each of the selected files in the workspace.
int counter = 0;
foreach (string fileName in fileNames)
{
// Create a new DynamicLayerInfo (to make changes to existing map service layers use the CreateDynamicLayerInfosFromLayerInfos() method.
DynamicLayerInfo dynamicLayerInfo = new DynamicLayerInfo
{
// Assign a layer ID.
ID = counter,
// Specify a friendly name.
Name = "Dataset: " + fileName
};
// Create a DataSource object to represent the physical datasource implementation (table or raster) which will become the DataSource
// property of a new LayerDataSource in the map service. Other supported datasource types are JoinDataSource and QueryDataSource.
DataSource dataSource = null;
// If the workspace type is Raster create a new RasterDataSource.
if (workspaceInfo.FactoryType == WorkspaceFactoryType.Raster)
{
// Create a new RasterDataSource object
dataSource = new RasterDataSource
{
// Match the DataSourceName to the physical filename on disk (including extension).
DataSourceName = fileName,
// Provide the WorkspaceID (the unique workspace identifier created earlier). A LocalMapService may have multiple dynamic workspaces.
WorkspaceID = workspaceInfo.Id
};
}
else
{
// Else if the workspace is not Raster create a new TableDataSource
dataSource = new TableDataSource
{
// Match the DataSourceName to the physical filename on disk (excluding extension).
DataSourceName = fileName,
// Provide the WorkspaceID (the unique workspace identifier created earlier). A LocalMapService may have multiple dynamic workspaces.
WorkspaceID = workspaceInfo.Id
};
/*
* Apply a renderer for vector layers.
* Note: It is always necessary to provide a renderer when the layer being added (represented by a DynamicLayerInfo) is part of a new
* DynamicLayerInfoCollection as opposed to using the CreateDynamicLayerInfosFromLayerInfos() method which creates a DynamicLayerInfoCollection
* containing the existing layers in the map service.
*/
// Create a new LayerDrawingOptions object to hold the renderer information.
var layerDrawOpt = new LayerDrawingOptions()
{
// Match up the LayerID to the ID of the layer within the service.
LayerID = counter,
};
// We need to determine the geometry type of the new feature class.
// To do this, we will submit a request to the ..\MapServer\dynamicLayer?.. endpoint which will return the service level metadata,
// allowing us to identify the geometry type and create an appropriate renderer.
// Note:- This is a workaround until the next release where GetAllDetails will honor the DynamicLayerInfoCollection.
// Create a new WebClient instance to make the request and download the response.
WebClient webClient = new WebClient();
// Register an asynchronous handler in which to create the renderers and apply the to the dynamic map service layer.
webClient.DownloadDataCompleted += (client, downloadDataEventArgs) =>
{
// Read the JSON response as XML
XmlReader reader = System.Runtime.Serialization.Json.JsonReaderWriterFactory.CreateJsonReader(downloadDataEventArgs.Result, new XmlDictionaryReaderQuotas());
// Get the root XML element
XElement root = XElement.Load(reader);
// Query for the "geometryType" element
XElement geometryType = root.XPathSelectElement("//geometryType");
// Create the render based on the geometry type
switch (geometryType.Value)
{
case "esriGeometryPoint":
layerDrawOpt.Renderer = new SimpleRenderer() { Symbol = new SimpleMarkerSymbol() { Color = new SolidColorBrush(GetRandomColor()), Size = 8 } };
break;
case "esriGeometryPolyline":
layerDrawOpt.Renderer = new SimpleRenderer() { Symbol = new SimpleLineSymbol() { Color = new SolidColorBrush(GetRandomColor()) } };
break;
case "esriGeometryPolygon":
layerDrawOpt.Renderer = new SimpleRenderer() { Symbol = new SimpleFillSymbol() { Fill = new SolidColorBrush(GetRandomColor()), BorderBrush = new SolidColorBrush(GetRandomColor()) } };
break;
}
// Set the LayerDrawingOptions property on the local dynamic map service layer (the LayerID property ties this to the DynamicLayerInfo object).
layerDrawingOptionsCollection.Add(layerDrawOpt);
// Update the layer drawing options property on the dynamic map service layer.
arcGisLocalDynamicMapServiceLayer.LayerDrawingOptions = layerDrawingOptionsCollection;
// Need to refresh the layer after the renderer(s) have been applied.
arcGisLocalDynamicMapServiceLayer.Refresh();
};
// Make the request for the service metadata
// e.g. http://127.0.0.1:<PORT>/arcgis/rest/services/<MPK_NAME>/MapServer/dynamicLayer?layer={"id":0,"source":{"type":"dataLayer","dataSource":{"type":"table","workspaceId":"MyWorkspace","dataSourceName":"MyFeatureClassName"}}}
webClient.DownloadDataAsync(new Uri(arcGisLocalDynamicMapServiceLayer.Url
+ "/dynamicLayer?layer={'id':" + counter.ToString() + ","
+ "'source':{'type':'dataLayer','dataSource':{"
+ "'type':'table',"
+ "'workspaceId':'" + workspaceInfo.Id + "',"
+ "'dataSourceName':'" + fileName + "'"
+ "}}}"));
}
// Set the Source property of the DynamicLayerInfo object.
dynamicLayerInfo.Source = new LayerDataSource { DataSource = dataSource };
// Add the new DynamicLayerInfo object to the collection.
dynamicLayerInfoCollection.Add(dynamicLayerInfo);
// Increment the counter which is being used to assign Layer IDs.
counter++;
}
// Update the DynamicLayerInfos property on the dynamic map service layer.
arcGisLocalDynamicMapServiceLayer.DynamicLayerInfos = dynamicLayerInfoCollection;
// Call the Action delegate.
callback(arcGisLocalDynamicMapServiceLayer);
};
// Call the Initialize method on the layer to initialize the layer properties.
arcGisLocalDynamicMapServiceLayer.Initialize();
});
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private async Task<ArcGISDynamicMapServiceLayer> AddFileDatasetToDynamicMapServiceLayer(WorkspaceFactoryType workspaceType, string directoryPath, List<string> fileNames)
{
try
{
// Create a new WorkspaceInfo object with a unique ID.
string uniqueId = Guid.NewGuid().ToString();
WorkspaceInfo workspaceInfo = new WorkspaceInfo(uniqueId, workspaceType, "DATABASE=" + directoryPath);
// Create and initialize a new LocalMapService instance.
LocalMapService localMapService = new LocalMapService(_emptyMapPackage) { EnableDynamicLayers = true };
localMapService.DynamicWorkspaces.Add(workspaceInfo);
await localMapService.StartAsync();
// Create and initialize new ArcGISLocalDynamicMapServiceLayer over the local service.
var dynLayer = new ArcGISDynamicMapServiceLayer()
{
ID = "Workspace: " + (new DirectoryInfo(directoryPath)).Name,
ServiceUri = localMapService.UrlMapService
};
await dynLayer.InitializeAsync();
// Create a DynamicLayerInfoCollection to hold the new datasets as "dynamic layers".
DynamicLayerInfoCollection dynamicLayerInfoCollection = new DynamicLayerInfoCollection();
dynLayer.DynamicLayerInfos = dynamicLayerInfoCollection;
// Create a LayerDrawingOptionsCollection to specify the symbology for each layer.
LayerDrawingOptionCollection layerDrawingOptionsCollection = new LayerDrawingOptionCollection();
dynLayer.LayerDrawingOptions = layerDrawingOptionsCollection;
// Iterate over each of the selected files in the workspace.
int counter = 0;
foreach (string fileName in fileNames)
{
// Create a new DynamicLayerInfo (to make changes to existing map service layers use the CreateDynamicLayerInfosFromLayerInfos() method.
DynamicLayerInfo dynamicLayerInfo = new DynamicLayerInfo { ID = counter, Name = "Dataset: " + fileName };
// Create a DataSource object to represent the physical datasource implementation (table or raster) which will become the DataSource
// property of a new LayerDataSource in the map service. Other supported datasource types are JoinDataSource and QueryDataSource.
DataSource dataSource = null;
// If the workspace type is Raster create a new RasterDataSource.
if (workspaceInfo.FactoryType == WorkspaceFactoryType.Raster)
{
// Create a new RasterDataSource object
dataSource = new RasterDataSource
{
// Match the DataSourceName to the physical filename on disk (including extension).
DataSourceName = fileName,
// Provide the WorkspaceID (the unique workspace identifier created earlier). A LocalMapService may have multiple dynamic workspaces.
WorkspaceID = workspaceInfo.Id
};
}
else
{
// Else if the workspace is not Raster create a new TableDataSource
dataSource = new TableDataSource
{
// Match the DataSourceName to the physical filename on disk (excluding extension).
DataSourceName = fileName,
// Provide the WorkspaceID (the unique workspace identifier created earlier). A LocalMapService may have multiple dynamic workspaces.
WorkspaceID = workspaceInfo.Id
};
}
// Set the Source property of the DynamicLayerInfo object.
dynamicLayerInfo.Source = new LayerDataSource { DataSource = dataSource };
// Add the new DynamicLayerInfo object to the collection.
dynamicLayerInfoCollection.Add(dynamicLayerInfo);
// Create a new LayerDrawingOptions object to hold the renderer information.
var layerDrawOpt = new LayerDrawingOptions()
{
// Match up the LayerID to the ID of the layer within the service.
LayerID = counter,
};
// Use the GetDetails method which now supports dynamic data sources to determine the geometry type of the new datasource.
var featureLayerInfo = await dynLayer.GetDetailsAsync(dynamicLayerInfo.ID);
switch (featureLayerInfo.GeometryType)
{
case GeometryType.Envelope:
layerDrawOpt.Renderer = new SimpleRenderer() { Symbol = new SimpleFillSymbol() { Color = GetRandomColor(), Outline = new SimpleLineSymbol() { Color = GetRandomColor() } } };
break;
case GeometryType.MultiPoint:
layerDrawOpt.Renderer = new SimpleRenderer() { Symbol = new SimpleMarkerSymbol() { Color = GetRandomColor(), Size = 8 } };
break;
case GeometryType.Point:
layerDrawOpt.Renderer = new SimpleRenderer() { Symbol = new SimpleMarkerSymbol() { Color = GetRandomColor(), Size = 8 } };
break;
case GeometryType.Polygon:
layerDrawOpt.Renderer = new SimpleRenderer() { Symbol = new SimpleFillSymbol() { Color = GetRandomColor(), Outline = new SimpleLineSymbol() { Color = GetRandomColor() } } };
break;
case GeometryType.Polyline:
layerDrawOpt.Renderer = new SimpleRenderer() { Symbol = new SimpleLineSymbol() { Color = GetRandomColor() } };
break;
default:
break;
}
// Set the LayerDrawingOptions property on the local dynamic map service layer (the LayerID property ties this to the DynamicLayerInfo object).
layerDrawingOptionsCollection.Add(layerDrawOpt);
counter++;
}
return dynLayer;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
return null;
}
}
