/// <summary>
/// Adds new Line Work Content
/// </summary>
/// <param name="LineId"></param>
/// <param name="workContId"></param>
private int AddLineWorkContent(int LineId, int workContId)
{
LineWorkContentVo lineWorkContentInVo = new LineWorkContentVo
{
LineId = LineId,
WorkContentId = workContId,
RegistrationUserCode = UserData.GetUserData().UserCode,
FactoryCode = UserData.GetUserData().FactoryCode
};
UpdateResultVo outVo = new UpdateResultVo();
try
{
outVo = (UpdateResultVo)base.InvokeCbm(new AddLineWorkContentMasterMntCbm(), lineWorkContentInVo, 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)
{
LineWorkContentVo inVo = (LineWorkContentVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Delete From m_line_work_content");
sqlQuery.Append(" Where ");
sqlQuery.Append(" work_content_id = :workContid ");
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("workContid", inVo.WorkContentId);
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
sqlParameter.AddParameterInteger("lid", inVo.LineId);
UpdateResultVo outVo = new UpdateResultVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
LineWorkContentVo inVo = (LineWorkContentVo)arg;
UpdateResultVo outVo = new UpdateResultVo();
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Insert into m_line_work_content");
sqlQuery.Append(" ( ");
sqlQuery.Append(" work_content_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(" :workContid ,");
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("workContid", inVo.WorkContentId);
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>
/// Delete Line work content
/// </summary>
/// <param name="lId"></param>
/// <param name="workContId"></param>
private int DeleteLineWorkContent(int lId, int workContId)
{
LineWorkContentVo delInVo = new LineWorkContentVo
{
LineId = lId,
WorkContentId = workContId
};
UpdateResultVo delOutVo = new UpdateResultVo();
try
{
delOutVo = (UpdateResultVo)base.InvokeCbm(new DeleteLineWorkContentMasterMntCbm(), 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)
{
LineWorkContentVo inVo = (LineWorkContentVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Select");
sqlQuery.Append(" lwc.line_work_content_id,");
sqlQuery.Append(" lwc.work_content_id,");
sqlQuery.Append(" lwc.line_id,");
sqlQuery.Append(" wc.work_content_name,");
sqlQuery.Append(" l.line_name");
sqlQuery.Append(" from m_line_work_content lwc");
sqlQuery.Append(" inner join m_line l on lwc.line_id = l.line_id");
sqlQuery.Append(" inner join m_work_content wc on lwc.work_content_id = wc.work_content_id");
sqlQuery.Append(" where lwc.factory_cd = :faccd ");
if (inVo.WorkContentId > 0)
{
sqlQuery.Append(" and lwc.work_content_id = :wcid");
}
if (inVo.LineId > 0)
{
sqlQuery.Append(" and lwc.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("wcid", inVo.WorkContentId);
sqlParameter.AddParameterInteger("lid", inVo.LineId);
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
ValueObjectList <LineWorkContentVo> outVo = null;
while (dataReader.Read())
{
LineWorkContentVo currOutVo = new LineWorkContentVo
{
LineWorkContentId = Convert.ToInt32(dataReader["line_work_content_id"]),
WorkContentId = Convert.ToInt32(dataReader["work_content_id"]),
LineId = Convert.ToInt32(dataReader["line_id"]),
LineName = dataReader["line_name"].ToString(),
WorkContentName = dataReader["work_content_name"].ToString()
};
if (outVo == null)
{
outVo = new ValueObjectList <LineWorkContentVo>();
}
outVo.add(currOutVo);
}
dataReader.Close();
return(outVo);
}
