public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
StringBuilder sql = new StringBuilder();
ValueObjectList <PQMDataViewerVo> VoList = new ValueObjectList <PQMDataViewerVo>();
//CREATE SQL ADAPTER AND PARAMETER LIST
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
//ADD COMMAND
sql.Append(@"select distinct model from procinsplink order by model asc");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//EXECUTE READER FROM COMMAND
IDataReader datareader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (datareader.Read())
{
//CREATE OJECT INCLUDE MODEL VALUE
PQMDataViewerVo outVo = new PQMDataViewerVo()
{
Model = datareader["model"].ToString(),
};
VoList.add(outVo);
}
datareader.Close();
return(VoList);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
PQMDataViewerVo InVo = (PQMDataViewerVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <PQMDataViewerVo> VoList = new ValueObjectList <PQMDataViewerVo>();
//CREATE SQL ADAPTER AND PARAMETER LIST
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
//ADD COMMAND
if (!string.IsNullOrEmpty(InVo.Model))
{
sql.Append(@"select distinct process from processtbl where 1=1");
sql.Append(@" and model = :model ");
sqlParameter.AddParameterString("model", InVo.Model);
sql.Append(@"order by process asc");
}
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//EXECUTE READER FROM COMMAND
IDataReader datareader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (datareader.Read())
{
//CREATE OJECT INCLUDE MODEL VALUE
PQMDataViewerVo outVo = new PQMDataViewerVo()
{
Process = datareader["process"].ToString(),
};
VoList.add(outVo);
}
datareader.Close();
return(VoList);
}
private Task <DataTable> GetDataToTable()
{
return(Task.Run(() =>
{
GetTableName();
GetSernoList();
GetInslist();
Vo.SernoDataTable = new DataTable();
Vo.InspectDataTable = new DataTable();
PQMDataViewerVo inspectable = (PQMDataViewerVo)DefaultCbmInvoker
.Invoke(new GetInspectDataTablePQMCbm(), new PQMDataViewerVo()
{
PQMConnectionString = Vo.PQMConnectionString,
SernoDBList = Vo.SernoDBList,
InspectList = Vo.InspectList,
SernoList = Vo.SernoList,
DateTimeFrom = Vo.DateTimeFrom,
DateTimeTo = Vo.DateTimeTo,
CheckLot = Vo.CheckLot
}
, connection);
PQMDataViewerVo sernotable = (PQMDataViewerVo)DefaultCbmInvoker
.Invoke(new GetSernoDataTablePQMCbm(), new PQMDataViewerVo()
{
PQMConnectionString = Vo.PQMConnectionString,
SernoDBList = Vo.SernoDBList,
SernoList = Vo.SernoList,
DateTimeFrom = Vo.DateTimeFrom,
DateTimeTo = Vo.DateTimeTo,
CheckLot = Vo.CheckLot
}
, connection);
Vo.InspectDataTable = inspectable.InspectDataTable;
Vo.SernoDataTable = sernotable.SernoDataTable;
DataTable pivot = new DataTable();
pivot = LinQ_Class.Pivot(Vo.InspectDataTable, Vo.InspectDataTable.Columns["inspect"]
, Vo.InspectDataTable.Columns["inspectdata"], Vo.InspectDataTable.Columns["judge"]);
//if (rbtnData.Checked)
//{
// Vo.InspectDataTable.Columns.Remove("judge");
// pivot = LinQ_Class.Pivot(Vo.InspectDataTable, Vo.InspectDataTable.Columns["inspect"]
// , Vo.InspectDataTable.Columns["inspectdata"]);
//}
//if (rbtnJudge.Checked)
//{
// Vo.InspectDataTable.Columns.Remove("inspectdata");
// pivot = LinQ_Class.Pivot(Vo.InspectDataTable, Vo.InspectDataTable.Columns["inspect"]
// , Vo.InspectDataTable.Columns["judge"]);
//}
Vo.JoinedTable = LinQ_Class.Joined(Vo.SernoDataTable, pivot);
pivot.Clear();
//Vo.ThreadComplete = true;
//GetTable.Abort();
return Vo.JoinedTable;
}));
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
PQMDataViewerVo InVo = (PQMDataViewerVo)vo;
StringBuilder sql = new StringBuilder();
DataTable temp = new DataTable();
DataTable dt = new DataTable();
//CREATE SQL ADAPTER AND PARAMETER LIST
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
//SELECT TABLE FOLLOW DATETIME
foreach (string table in InVo.SernoDBList)
{
sql.Append("select serno, inspectdate, inspect, inspectdata from "
+ table + "data where inspect in (" + InVo.InspectList.ToString() + ")");
if (InVo.SernoList.Length > 0)
{
if (InVo.CheckLot)
{
sql.Append(" and lot in (" + InVo.SernoList.ToString() + ")");
}
else
{
sql.Append(" and serno in (" + InVo.SernoList.ToString() + ")");
}
}
else
{
sql.Append(" and inspectdate >= '" + InVo.DateTimeFrom.ToString("yyyy-MM-dd HH:mm:ss")
+ "' and inspectdate <= '" + InVo.DateTimeTo.ToString("yyyy-MM-dd HH:mm:ss") + "'");
}
sql.Append(" order by inspect asc, inspectdate asc");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
sql.Clear();
//EXECUTE READER FROM COMMAND
IDataReader datareader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
//GET DATATABLE FROM SQL
temp.Load(datareader);
dt.Merge(temp);
temp.Clear();
}
PQMDataViewerVo OutVo = new PQMDataViewerVo
{
InspectDataTable = dt
};
return(OutVo);
}
private void GetDataToTable()
{
try
{
GetTableName();
GetSernoList();
GetInslist();
Vo.SernoDataTable = new DataTable();
Vo.InspectDataTable = new DataTable();
PQMDataViewerVo inspectable = (PQMDataViewerVo)DefaultCbmInvoker
.Invoke(new GetInspectDataTablePQMCbm(), new PQMDataViewerVo()
{
PQMConnectionString = Vo.PQMConnectionString,
SernoDBList = Vo.SernoDBList,
InspectList = Vo.InspectList,
SernoList = Vo.SernoList,
DateTimeFrom = Vo.DateTimeFrom,
DateTimeTo = Vo.DateTimeTo,
CheckLot = Vo.CheckLot
}
, connection);
PQMDataViewerVo sernotable = (PQMDataViewerVo)DefaultCbmInvoker
.Invoke(new GetSernoDataTablePQMCbm(), new PQMDataViewerVo()
{
PQMConnectionString = Vo.PQMConnectionString,
SernoDBList = Vo.SernoDBList,
SernoList = Vo.SernoList,
DateTimeFrom = Vo.DateTimeFrom,
DateTimeTo = Vo.DateTimeTo,
CheckLot = Vo.CheckLot
}
, connection);
Vo.InspectDataTable = inspectable.InspectDataTable;
Vo.SernoDataTable = sernotable.SernoDataTable;
DataTable pivot = new DataTable();
pivot = LinQ_Class.Pivot(Vo.InspectDataTable, Vo.InspectDataTable.Columns["inspect"]
, Vo.InspectDataTable.Columns["inspectdata"]);
Vo.JoinedTable = LinQ_Class.Joined(Vo.SernoDataTable, pivot);
pivot.Clear();
Vo.ThreadComplete = true;
GetTable.Abort();
}
catch (Framework.SystemException ex)
{
MessageBox.Show("Please select model and inspect before search data!");
//MessageBox.Show(ex.GetMessageData().ToString());
}
}
