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