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