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