public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
SeachMachineWorkingStatusVo inVo = (SeachMachineWorkingStatusVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <SeachMachineWorkingStatusVo> voList = new ValueObjectList <SeachMachineWorkingStatusVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select mold_machine, mold_inspect_data, mold_inspect_date + mold_inspect_time as a, mold_remark from t_mold_status_machine where (mold_machine,mold_status_id) in(select mold_machine, max(mold_status_id) from t_mold_status_machine group by mold_machine) order by mold_inspect_data desc ");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
SeachMachineWorkingStatusVo outVo = new SeachMachineWorkingStatusVo
{
MOLDData = double.Parse(dataReader["mold_inspect_data"].ToString()),
MOLDMachine = dataReader["mold_machine"].ToString(),
MOLDDateTimeLoad = DateTime.Parse(dataReader["a"].ToString()),
MOLDRemark = dataReader["mold_remark"].ToString(),
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
public void callSection(string name)
{
if (name == "ST")
{
SeachMachineWorkingStatusVo callmachine = new SeachMachineWorkingStatusVo();
insert_ST_machine_status_dvg.AutoGenerateColumns = false;
ValueObjectList <SeachMachineWorkingStatusVo> listvo = null;
listvo = (ValueObjectList <SeachMachineWorkingStatusVo>)DefaultCbmInvoker.Invoke(new Cbm.SearchSTWorkingStatusCbm(), callmachine);
insert_ST_machine_status_dvg.DataSource = listvo.GetList();
}
else if (name == "CUTTING")
{
// listvo = (ValueObjectList<AddMachineStatusVo>)DefaultCbmInvoker.Invoke(new Cbm.SearchMACWorkingStatusCbm(), callmachine);
}
else if (name == "MOLD")
{
// listvo = (ValueObjectList<AddMachineStatusVo>)DefaultCbmInvoker.Invoke(new Cbm.SearchMOLDWorkingStatusCbm(), callmachine);
}
else if (name == "TD")
{
// listvo = (ValueObjectList<AddMachineStatusVo>)DefaultCbmInvoker.Invoke(new Cbm.SearchTDWorkingStatusCbm(), callmachine);
}
else if (name == "SP")
{
// listvo = (ValueObjectList<AddMachineStatusVo>)DefaultCbmInvoker.Invoke(new Cbm.SearchSPWorkingStatusCbm(), callmachine);
}
else
{
return;
}
}
