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; } }