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