public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { CauseVo inVo = (CauseVo)vo; StringBuilder sql = new StringBuilder(); sql.Append("insert into public.m_ncvp_cause(machine_id,defective_reason_id,registration_user_cd,registration_date_time,factory_cd) "); sql.Append("values(:machine_id,:defective_reason_id,:registration_user_cd,now(),:factory_cd)"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); // DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("machine_id", inVo.MachineID); sqlParameter.AddParameterInteger("defective_reason_id", inVo.DefectiveID); sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode); sqlParameter.AddParameterString("registration_user_cd", inVo.RegistrationUserCode); //execute SQL CauseVo outVo = new CauseVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { CauseVo inVo = (CauseVo)vo; StringBuilder sql = new StringBuilder(); DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("delete from m_cause Where 1=1 "); if (inVo.CauseID > 0) { sql.Append(" and cause_id = :cause_id "); sqlParameter.AddParameterInteger("cause_id", inVo.CauseID); } //create command sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL CauseVo outVo = new CauseVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { CauseVo inVo = (CauseVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <CauseVo> voList = new ValueObjectList <CauseVo>(); DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("select cause_id, machine_id, defective_reason_id, registration_user_cd,registration_date_time,factory_cd from public.m_ncvp_cause"); sql.Append(" Where 1=1 "); // if (!String.IsNullOrEmpty(inVo.FactoryCode)) { sql.Append(" and factory_cd = :factory_cd "); sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode); } if (inVo.MachineID > 0) { sql.Append(" and machine_id = :machine_id "); sqlParameter.AddParameterInteger("machine_id", inVo.MachineID); } if (inVo.DefectiveID > 0) { sql.Append(" and defective_reason_id = :defective_reason_id "); sqlParameter.AddParameterInteger("defective_reason_id", inVo.DefectiveID); } if (inVo.CauseID > 0) { sql.Append(" and cause_id = :cause_id "); sqlParameter.AddParameterInteger("cause_id", inVo.CauseID); } //create command //DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { CauseVo outVo = new CauseVo { //convert CauseID = int.Parse(dataReader["cause_id"].ToString()), MachineID = int.Parse(dataReader["machine_id"].ToString()), DefectiveID = int.Parse(dataReader["defective_reason_id"].ToString()), RegistrationUserCode = dataReader["registration_user_cd"].ToString(), RegistrationDateTime = DateTime.Parse(dataReader["registration_date_time"].ToString()), FactoryCode = dataReader["factory_cd"].ToString() }; voList.add(outVo); } dataReader.Close(); return(voList); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { CauseVo inVo = (CauseVo)vo; StringBuilder sql = new StringBuilder(); DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("delete from public.m_ncvp_cause Where 1=1 "); if (!String.IsNullOrEmpty(inVo.FactoryCode)) { sql.Append(" and factory_cd = :factory_cd "); sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode); } if (inVo.MachineID > 0) { sql.Append(" and machine_id = :machine_id "); sqlParameter.AddParameterInteger("machine_id", inVo.MachineID); } if (inVo.DefectiveID > 0) { sql.Append(" and defective_reason_id = :defective_reason_id "); sqlParameter.AddParameterInteger("defective_reason_id", inVo.DefectiveID); } if (inVo.CauseID > 0) { sql.Append(" and cause_id = :cause_id "); sqlParameter.AddParameterInteger("cause_id", inVo.CauseID); } //create command sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL MachineVo outVo = new MachineVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { CauseVo inVo = (CauseVo)vo; StringBuilder sql = new StringBuilder(); sql.Append("insert into m_cause(machine_id,defective_reason_id,registration_user_cd,registration_date_time,factory_cd) "); sql.Append("values"); sql.Append(" ("); sql.Append(" :machine_id,"); sql.Append(" :defective_reason_id,"); sql.Append(" :registrationusercode,"); sql.Append(" :registrationdatetime,"); sql.Append(" :factorycode "); sql.Append(" ) "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); // DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("machine_id", inVo.MachineID); sqlParameter.AddParameterInteger("defective_reason_id", inVo.DefectiveID); sqlParameter.AddParameterString("registrationusercode", UserData.GetUserData().UserCode); sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycode", UserData.GetUserData().FactoryCode); //execute SQL CauseVo outVo = new CauseVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }