public DataSourceExportToExcel(ActDSTableElement actDSTableElement)
{
InitializeComponent();
mActDSTableElement = actDSTableElement;
if (mActDSTableElement.ExcelConfig == null)
{
mActDSTableElement.ExcelConfig = new ExportToExcelConfig();
}
SetFilePath();
SetDataTable();
SetSheetName();
ExcelFilePath.Init(Context.GetAsContext(mActDSTableElement.Context), mActDSTableElement.ExcelConfig, nameof(ExportToExcelConfig.ExcelPath), true, true, UCValueExpression.eBrowserType.File, "xlsx");
xExcelExportQuery.Init(Context.GetAsContext(mActDSTableElement.Context), mActDSTableElement.ExcelConfig, nameof(ExportToExcelConfig.ExportQueryValue), true);
xExportSheetName.Init(Context.GetAsContext(mActDSTableElement.Context), mActDSTableElement.ExcelConfig, nameof(ExportToExcelConfig.ExcelSheetName), true);
BindingHandler.ObjFieldBinding(xRdoByCustomExport, RadioButton.IsCheckedProperty, mActDSTableElement.ExcelConfig, nameof(ExportToExcelConfig.IsCustomExport));
BindingHandler.ObjFieldBinding(xRdoByQueryExport, RadioButton.IsCheckedProperty, mActDSTableElement.ExcelConfig, nameof(ExportToExcelConfig.IsExportByQuery));
BindingHandler.ObjFieldBinding(xExportWhereChkBox, CheckBox.IsCheckedProperty, mActDSTableElement.ExcelConfig, nameof(ExportToExcelConfig.ExportByWhere));
ExcelFilePath.ValueTextBox.TextChanged += ExcelFilePathTextBox_TextChanged;
xExportSheetName.ValueTextBox.TextChanged += ExcelSheetNameTextBox_TextChanged;
xExcelExportQuery.ValueTextBox.TextChanged += ExcelExportQuery_ValueTextBox_TextChanged;
if (mDataTable != null)
{
InitColumnListGrid(mDataTable.Columns);
}
SetConditionGridView();
UpdateQueryValue();
}
public void ExecuteMarkAsDone()
{
//Add row
ObservableList <DataSourceTable> dataSourceTableList = liteDB.GetTablesList();
DataSourceTable dataSource = null;
List <string> mColumnNames = null;
foreach (DataSourceTable dataSourceTable in dataSourceTableList)
{
if (dataSourceTable.Name == "MyCustomizedDataTable")
{
dataSource = dataSourceTable;
}
}
DataTable dataTable = liteDB.GetQueryOutput(dataSource.Name);
dataSource.DataTable = dataTable;
liteDB.AddRow(mColumnNames, dataSource);
liteDB.SaveTable(dataTable);
//Clean up
ActDSTableElement actDSTable = new ActDSTableElement();
string query = "db.MyCustomizedDataTable.update GINGER_USED= \"False\"";
actDSTable.ControlAction = ActDSTableElement.eControlAction.MarkAllUnUsed;
liteDB.Execute(actDSTable, query);
//Arrange
query = "db.MyCustomizedDataTable.update GINGER_USED= \"True\"";
actDSTable.ControlAction = ActDSTableElement.eControlAction.MarkAsDone;
actDSTable.DSTableName = "MyCustomizedDataTable";
actDSTable.Customized = true;
actDSTable.ByNextAvailable = false;
actDSTable.ByRowNum = true;
actDSTable.LocateRowValue = "0";
actDSTable.LocateColTitle = "GINGER_ID";
actDSTable.MarkUpdate = true;
actDSTable.AddNewReturnParams = true;
//Act
liteDB.Execute(actDSTable, query);
//Assert
query = "db.MyCustomizedDataTable.find GINGER_USED= \"True\"";
DataTable dt = liteDB.GetQueryOutput(query);
Assert.AreEqual(1, dt.Rows.Count);
}
public void ExecuteGetValueByQuery()
{
//Arrange
ActDSTableElement actDSTable = new ActDSTableElement();
string query = "db.MyCustomizedDataTable.find limit 1";
actDSTable.ControlAction = ActDSTableElement.eControlAction.GetValue;
actDSTable.Customized = false;
actDSTable.ByNextAvailable = false;
actDSTable.ByRowNum = false;
actDSTable.ByQuery = true;
actDSTable.MarkUpdate = false;
actDSTable.AddNewReturnParams = true;
//Act
liteDB.Execute(actDSTable, query);
ActReturnValue value = actDSTable.GetReturnValue("GINGER_ID");
//Assert
Assert.AreEqual("1", value.Actual);
}
