public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
LineRestTimeVo inVo = (LineRestTimeVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Delete From m_line_rest_time");
sqlQuery.Append(" Where ");
sqlQuery.Append(" factory_cd = :faccd ");
if (inVo.LineId > 0)
{
sqlQuery.Append(" and line_id = :lineid ");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
//sqlParameter.AddParameterInteger("lineSapItemId", inVo.LineItemCycleTimeId);
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
sqlParameter.AddParameterInteger("lineid", inVo.LineId);
sqlParameter.AddParameterInteger("lineresttimeid", inVo.LineRestTimeId);
UpdateResultVo outVo = new UpdateResultVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
/// <summary>
/// Creates seacrh condition as per user inputs
/// </summary>
/// <returns>search condition</returns>
private LineRestTimeVo FormConditionVo()
{
LineRestTimeVo inVo = new LineRestTimeVo();
inVo.LineId = Convert.ToInt32(Line_cmb.SelectedValue);
return(inVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
LineRestTimeVo inVo = (LineRestTimeVo)arg;
StringBuilder sqlQuery = new StringBuilder();
//create SQL
sqlQuery.Append(" select ");
sqlQuery.Append(" line_rest_time_id, ");
sqlQuery.Append(" line_id, ");
sqlQuery.Append(" shift, ");
sqlQuery.Append(" plan_rest_minutes ");
sqlQuery.Append(" from m_line_rest_time ");
sqlQuery.Append(" where ");
sqlQuery.Append(" factory_cd = :factorycode ");
if (inVo.LineId > 0)
{
sqlQuery.Append(" and line_id = :lineid ");
}
sqlQuery.Append(" ORDER BY shift");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("lineid", inVo.LineId);
sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode);
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
ValueObjectList <LineRestTimeVo> lineRestTimeVo = null;
while (dataReader.Read())
{
LineRestTimeVo currVo = new LineRestTimeVo();
currVo.LineRestTimeId = ConvertDBNull <int>(dataReader, "line_rest_time_id");
currVo.LineId = ConvertDBNull <int>(dataReader, "line_id");
currVo.Shift = ConvertDBNull <int>(dataReader, "shift");
if (dataReader["plan_rest_minutes"] != null)
{
currVo.PlanRestMinutes = ConvertDBNull <int>(dataReader, "plan_rest_minutes");
}
if (lineRestTimeVo == null)
{
lineRestTimeVo = new ValueObjectList <LineRestTimeVo>();
}
lineRestTimeVo.add(currVo);
}
dataReader.Close();
return(lineRestTimeVo);
}
/// <summary>
/// Fills all user records to gridview control
/// </summary>
private void GridBind(LineRestTimeVo conditionInVo)
{
LineRestTime_dgv.DataSource = null;
ValueObjectList <LineRestTimeVo> loadVo = new ValueObjectList <LineRestTimeVo>();
loadVo.SetNewList(getShiftTemplateVo().GetList());
try
{
ValueObjectList <LineRestTimeVo> outVo = (ValueObjectList <LineRestTimeVo>)base.InvokeCbm(new GetLineRestTimeMasterMntCbm(), conditionInVo, false);
LineRestTime_dgv.AutoGenerateColumns = false;
if (outVo != null && outVo.GetList() != null && outVo.GetList().Count > 0)
{
foreach (LineRestTimeVo lineRestVo in outVo.GetList())
{
if (lineRestVo.Shift == Convert.ToInt32(GlobalMasterDataTypeEnum.SHIFT_DAY.GetValue()))
{
foreach (LineRestTimeVo restVo in loadVo.GetList().Where(v => v.Shift == Convert.ToInt32(GlobalMasterDataTypeEnum.SHIFT_DAY.GetValue())))
{
restVo.LineRestTimeId = lineRestVo.LineRestTimeId;
restVo.LineId = lineRestVo.LineId;
restVo.PlanRestMinutes = lineRestVo.PlanRestMinutes;
}
}
else if (lineRestVo.Shift == Convert.ToInt32(GlobalMasterDataTypeEnum.SHIFT_NIGHT.GetValue()))
{
foreach (LineRestTimeVo restVo in loadVo.GetList().Where(v => v.Shift == Convert.ToInt32(GlobalMasterDataTypeEnum.SHIFT_NIGHT.GetValue())))
{
restVo.LineRestTimeId = lineRestVo.LineRestTimeId;
restVo.LineId = lineRestVo.LineId;
restVo.PlanRestMinutes = lineRestVo.PlanRestMinutes;
}
}
}
}
LineRestTime_dgv.DataSource = loadVo.GetList();
LineRestTime_dgv.ClearSelection();
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
LineRestTimeVo inVo = (LineRestTimeVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append(" Insert into");
sqlQuery.Append(" m_line_rest_time ");
sqlQuery.Append(" ( ");
sqlQuery.Append(" line_id, ");
sqlQuery.Append(" shift, ");
sqlQuery.Append(" plan_rest_minutes, ");
sqlQuery.Append(" registration_user_cd, ");
sqlQuery.Append(" registration_date_time, ");
sqlQuery.Append(" factory_cd ");
sqlQuery.Append(" ) ");
sqlQuery.Append(" Values ");
sqlQuery.Append(" ( ");
sqlQuery.Append(" :lineid, ");
sqlQuery.Append(" :shift, ");
sqlQuery.Append(" :planrestminutes, ");
sqlQuery.Append(" :registrationusercd, ");
sqlQuery.Append(" :registrationdatetime, ");
sqlQuery.Append(" :factorycd ");
sqlQuery.Append(" ); ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("lineid", inVo.LineId);
sqlParameter.AddParameterInteger("shift", inVo.Shift);
sqlParameter.AddParameter("planrestminutes", inVo.PlanRestMinutes);
sqlParameter.AddParameterString("registrationusercd", trxContext.UserData.UserCode);
sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime);
sqlParameter.AddParameterString("factorycd", trxContext.UserData.FactoryCode);
UpdateResultVo outVo = new UpdateResultVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
/// <summary>
/// Create Shift TemplateVo
/// </summary>
private ValueObjectList <LineRestTimeVo> getShiftTemplateVo()
{
LineRestTimeVo dayVo = new LineRestTimeVo();
dayVo.Shift = Convert.ToInt32(GlobalMasterDataTypeEnum.SHIFT_DAY.GetValue());
dayVo.ShiftText = GlobalMasterDataTypeEnum.SHIFT_DAY.ToString();
LineRestTimeVo nightVo = new LineRestTimeVo();
nightVo.Shift = Convert.ToInt32(GlobalMasterDataTypeEnum.SHIFT_NIGHT.GetValue());
nightVo.ShiftText = GlobalMasterDataTypeEnum.SHIFT_NIGHT.ToString();
ValueObjectList <Vo.LineRestTimeVo> shiftVo = new ValueObjectList <Vo.LineRestTimeVo>();
shiftVo.add(dayVo);
shiftVo.add(nightVo);
return(shiftVo);
}
