public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
LineDefectiveReasonVo inVo = (LineDefectiveReasonVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Delete From m_line_defective_reason");
sqlQuery.Append(" Where ");
sqlQuery.Append(" defective_reason_id = :defrsnid ");
sqlQuery.Append(" and factory_cd = :faccd ");
if (inVo.LineId > 0)
{
sqlQuery.Append(" and line_id = :lid");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("defrsnid", inVo.DefectiveReasonId);
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
sqlParameter.AddParameterInteger("lid", inVo.LineId);
UpdateResultVo outVo = new UpdateResultVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
/// <summary>
/// Adds new proess defect
/// </summary>
/// <param name="LineId"></param>
/// <param name="defectRsnId"></param>
private int AddLineDefectReason(int LineId, int defectRsnId)
{
LineDefectiveReasonVo LinDefInVo = new LineDefectiveReasonVo
{
LineId = LineId,
DefectiveReasonId = defectRsnId,
//RegistrationDateTime = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"),
RegistrationUserCode = UserData.GetUserData().UserCode,
FactoryCode = UserData.GetUserData().FactoryCode
};
UpdateResultVo outVo = new UpdateResultVo();
try
{
outVo = (UpdateResultVo)base.InvokeCbm(new AddLineDefectiveReasonMasterMntCbm(), LinDefInVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
Logger.Error(exception.GetMessageData());
}
if (outVo != null && outVo.AffectedCount > 0)
{
return(outVo.AffectedCount);
}
return(0);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
LineDefectiveReasonVo inVo = (LineDefectiveReasonVo)arg;
UpdateResultVo outVo = new UpdateResultVo();
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Insert into m_line_defective_reason");
sqlQuery.Append(" ( ");
sqlQuery.Append(" defective_reason_id, ");
sqlQuery.Append(" line_id, ");
sqlQuery.Append(" registration_user_cd, ");
sqlQuery.Append(" registration_date_time, ");
sqlQuery.Append(" factory_cd ");
sqlQuery.Append(" ) ");
sqlQuery.Append("VALUES ");
sqlQuery.Append(" ( ");
sqlQuery.Append(" :defrid ,");
sqlQuery.Append(" :lineid ,");
sqlQuery.Append(" :registrationusercd ,");
sqlQuery.Append(" :registrationdatetime ,");
sqlQuery.Append(" :factrycode ");
sqlQuery.Append(" ); ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("lineid", inVo.LineId);
sqlParameter.AddParameterInteger("defrid", inVo.DefectiveReasonId);
sqlParameter.AddParameterString("registrationusercd", UserData.GetUserData().UserCode);
sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime);
sqlParameter.AddParameterString("factrycode", UserData.GetUserData().FactoryCode);
outVo.AffectedCount += sqlCommandAdapter.ExecuteNonQuery(sqlParameter);
return(outVo);
}
/// <summary>
/// Deletes Line defect
/// </summary>
/// <param name="lId"></param>
/// <param name="defRsnId"></param>
private int DeleteLineDefect(int lId, int defRsnId)
{
LineDefectiveReasonVo delInVo = new LineDefectiveReasonVo
{
LineId = lId,
DefectiveReasonId = defRsnId
};
UpdateResultVo delOutVo = new UpdateResultVo();
try
{
delOutVo = (UpdateResultVo)base.InvokeCbm(new DeleteLineDefectiveReasonMasterMntCbm(), delInVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
Logger.Error(exception.GetMessageData());
}
if (delOutVo != null && delOutVo.AffectedCount > 0)
{
return(delOutVo.AffectedCount);
}
return(0);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
LineDefectiveReasonVo inVo = (LineDefectiveReasonVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Select");
sqlQuery.Append(" ldr.line_defective_reason_id,");
sqlQuery.Append(" ldr.defective_reason_id,");
sqlQuery.Append(" ldr.line_id,");
sqlQuery.Append(" df.defective_reason_name,");
sqlQuery.Append(" l.line_name");
sqlQuery.Append(" from m_line_defective_reason ldr");
sqlQuery.Append(" inner join m_line l on ldr.line_id = l.line_id");
sqlQuery.Append(" inner join m_defective_reason df on ldr.defective_reason_id = df.defective_reason_id");
sqlQuery.Append(" where ldr.factory_cd = :faccd ");
if (inVo.DefectiveReasonId > 0)
{
sqlQuery.Append(" and ldr.defective_reason_id = :dfrid");
}
if (inVo.LineId > 0)
{
sqlQuery.Append(" and ldr.line_id = :lid");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
sqlParameter.AddParameterInteger("dfrid", inVo.DefectiveReasonId);
sqlParameter.AddParameterInteger("pwid", inVo.LineId);
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
ValueObjectList <LineDefectiveReasonVo> outVo = null;
while (dataReader.Read())
{
LineDefectiveReasonVo currOutVo = new LineDefectiveReasonVo
{
LineDefectiveReasonId = Convert.ToInt32(dataReader["line_defective_reason_id"]),
DefectiveReasonId = Convert.ToInt32(dataReader["defective_reason_id"]),
LineId = Convert.ToInt32(dataReader["line_id"]),
LineName = dataReader["line_name"].ToString(),
DefectiveReasonName = dataReader["defective_reason_name"].ToString()
};
if (outVo == null)
{
outVo = new ValueObjectList <LineDefectiveReasonVo>();
}
outVo.add(currOutVo);
}
dataReader.Close();
return(outVo);
}
