public ValueObject Execute(TransactionContext trxContext, ValueObject vo) { UserVo inVo = (UserVo)vo; UserFactoryVo inVo2 = new UserFactoryVo { UserCode = inVo.UserCode, FactoryCd = inVo.RegistrationFactoryCode, RegistrationUserCode = inVo.RegistrationUserCode }; deleteUserFactoryDao.Execute(trxContext, inVo2); return(deleteUserDao.Execute(trxContext, vo)); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { UserFactoryVo inVo = (UserFactoryVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_user_factory"); sqlQuery.Append(" ( "); sqlQuery.Append(" user_cd, "); sqlQuery.Append(" factory_cd, "); sqlQuery.Append(" display_order, "); sqlQuery.Append(" registration_user_cd, "); sqlQuery.Append(" registration_date_time"); sqlQuery.Append(" ) "); sqlQuery.Append("VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :usercd ,"); sqlQuery.Append(" :factorycd ,"); sqlQuery.Append(" :displayorder,"); sqlQuery.Append(" :registrationusercode ,"); sqlQuery.Append(" now()"); sqlQuery.Append(" ); "); int cnt = 0; UserFactoryVo outVo = new UserFactoryVo(); foreach (UserFactoryVo userRecord in inVo.UserFactoryListVo) { //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("usercd", inVo.UserCode); sqlParameter.AddParameterString("factorycd", userRecord.FactoryCd); sqlParameter.AddParameterInteger("displayorder", userRecord.DisplayOrder); sqlParameter.AddParameterString("registrationusercode", inVo.RegistrationUserCode); outVo.AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter); } outVo.AffectedCount = cnt; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { UserFactoryVo inVo = (UserFactoryVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Delete from m_user_factory"); sqlQuery.Append(" Where user_cd = :usercd "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("usercd", inVo.UserCode); UserFactoryVo outVo = new UserFactoryVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { UserFactoryVo inVo = (UserFactoryVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("select user_cd, factory_cd, factory_name, display_order from ("); sqlQuery.Append("select mu.user_cd, mf.factory_cd, mf.factory_name, COALESCE(uf.display_order, 99) display_order"); sqlQuery.Append(" from m_mes_user mu "); sqlQuery.Append(" inner join m_factory mf on mf.factory_cd = mf.factory_cd"); sqlQuery.Append(" left outer join m_user_factory uf on uf.user_cd = mu.user_cd and uf.factory_cd = mf.factory_cd"); sqlQuery.Append(" where 1 = 1 "); if (inVo.UserCode != null) { sqlQuery.Append(" and mu.user_cd = :usercd "); } if (inVo.FactoryCd != null) { sqlQuery.Append(" and uf.factory_cd = :factorycd "); } sqlQuery.Append(") d"); sqlQuery.Append(" order by d.user_cd, d.display_order"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); if (inVo.UserCode != null) { sqlParameter.AddParameterString("usercd", inVo.UserCode); } if (inVo.FactoryCd != null) { sqlParameter.AddParameterString("factorycd", inVo.FactoryCd); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); UserFactoryVo outVo = new UserFactoryVo(); while (dataReader.Read()) { UserFactoryVo currOutVo = new UserFactoryVo { UserCode = dataReader["user_cd"].ToString(), FactoryCd = dataReader["factory_cd"].ToString(), FactoryName = dataReader["factory_name"].ToString(), DisplayOrder = Convert.ToInt32(dataReader["display_order"]) }; outVo.UserFactoryListVo.Add(currOutVo); } dataReader.Close(); return(outVo); }
/// <summary> /// Updates user role /// </summary> private void UpdateUserFactory() { TreeNodeCollection nodes = UserFactoryDetails_tv.Nodes; UserFactoryVo userFactoryInVo = new UserFactoryVo(); try { UserFactoryVo userFactoryCheckVo = (UserFactoryVo)base.InvokeCbm(new GetUserFactoryMasterMntCbm(), userFactoryInVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } int displayOrder = 0; foreach (TreeNode tn in nodes) { if (tn.ToolTipText == "Changed") { string userCd = tn.Tag.ToString(); userFactoryInVo.UserCode = userCd; userFactoryInVo.RegistrationUserCode = UserData.GetUserData().UserCode; foreach (TreeNode child in tn.Nodes) { if (child.Checked) { displayOrder = displayOrder + 1; UserFactoryVo userFactoryListVo = new UserFactoryVo { UserCode = userCd, FactoryCd = child.Tag.ToString(), DisplayOrder = displayOrder }; userFactoryInVo.UserFactoryListVo.Add(userFactoryListVo); } } try { UserFactoryVo userFactoryOutVo = (UserFactoryVo)base.InvokeCbm(new UpdateUserFactoryMasterMntCbm(), userFactoryInVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } } } messageData = new MessageData("mmci00002", Properties.Resources.mmci00002, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); }
/// <summary> /// Binds tree view with role /// </summary> /// <param name="userList"></param> private void PopulateTreeView(List <UserVo> userList) { UserFactoryDetails_tv.Nodes.Clear(); TreeNode[] headerNode = new TreeNode[userList.Count]; int i = 0; foreach (UserVo user in userList) { TreeNode child = new TreeNode { Text = user.UserCode + ": " + user.UserName, Tag = user.UserCode }; headerNode[i] = child; int node = 0; UserFactoryVo userFactoryInVo = new UserFactoryVo { UserCode = user.UserCode }; UserFactoryVo userFactoryOutVo; try { userFactoryOutVo = (UserFactoryVo)base.InvokeCbm(new GetUserFactoryMasterMntCbm(), userFactoryInVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } int childNodes = userFactoryOutVo.UserFactoryListVo.Count; TreeNode[] rootNodes = new TreeNode[childNodes]; List <UserFactoryVo> userFactoryList = userFactoryOutVo.UserFactoryListVo; foreach (UserFactoryVo userFactory in userFactoryList) { TreeNode rootChild = new TreeNode { Text = userFactory.FactoryName, Tag = userFactory.FactoryCd }; if (userFactory.DisplayOrder < 99) { rootChild.Checked = true; } rootNodes[node] = rootChild; headerNode[i].Nodes.Add(rootNodes[node]); node += 1; } UserFactoryDetails_tv.Nodes.Add(headerNode[i]); i += 1; } }