/// <summary> /// checks duplicate Line Building /// </summary> /// <param name="usrBuildingLineVo"></param> /// <returns></returns> private UserLineBuildingVo DuplicateCheck(UserLineBuildingVo usrBuildingLineVo) { UserLineBuildingVo outVo = new UserLineBuildingVo(); try { outVo = (UserLineBuildingVo)base.InvokeCbm(new CheckUserLineBuildingMasterMntCbm(), usrBuildingLineVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { UserLineBuildingVo inVo = (UserLineBuildingVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_user_line_building"); sqlQuery.Append(" ( "); sqlQuery.Append(" line_building_id, "); sqlQuery.Append(" user_cd, "); sqlQuery.Append(" registration_user_cd, "); sqlQuery.Append(" registration_date_time, "); sqlQuery.Append(" factory_cd "); sqlQuery.Append(" ) "); sqlQuery.Append("VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :linebuildingid ,"); sqlQuery.Append(" :usercd ,"); sqlQuery.Append(" :registrationusercode ,"); sqlQuery.Append(" :registrationdatetime ,"); sqlQuery.Append(" :factorycode "); sqlQuery.Append(" ); "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("usercd", inVo.UserCode); sqlParameter.AddParameterInteger("linebuildingid", inVo.LineBuildingId); sqlParameter.AddParameterString("registrationusercode", UserData.GetUserData().UserCode); sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycode", UserData.GetUserData().FactoryCode); UpdateResultVo outVo = new UpdateResultVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { UserLineBuildingVo inVo = (UserLineBuildingVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Delete from m_user_line_building"); sqlQuery.Append(" where factory_cd = :faccd "); if (inVo.LineBuildingId > 0) { sqlQuery.Append(" AND line_building_id = :linebuildingid"); } if (inVo.UserCode != null) { sqlQuery.Append(" AND user_cd = :usercd"); } if (inVo.LineBuildingidList.Count > 0) { sqlQuery.Append(" AND line_building_id = ANY(:idlist) "); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); sqlParameter.AddParameterInteger("linebuildingid", inVo.LineBuildingId); sqlParameter.AddParameterString("usercd", inVo.UserCode); sqlParameter.AddParameter("idlist", inVo.LineBuildingidList); UpdateResultVo outVo = new UpdateResultVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { UserLineBuildingVo inVo = (UserLineBuildingVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Select Count(*) as UserLineBuildingCount from m_user_line_building"); sqlQuery.Append(" where factory_cd = :faccd "); if (inVo.LineBuildingId >= 0) { sqlQuery.Append(" and line_building_id = :linebuildingid"); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); if (inVo.LineBuildingId >= 0) { sqlParameter.AddParameterInteger("linebuildingid", inVo.LineBuildingId); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); UserLineBuildingVo outVo = new UserLineBuildingVo(); while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32(dataReader["UserLineBuildingCount"]); } dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { UserLineBuildingVo inVo = (UserLineBuildingVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Select"); sqlQuery.Append(" lb.line_building_id,"); sqlQuery.Append(" lb.building_id,"); sqlQuery.Append(" lb.line_id,"); sqlQuery.Append(" b.building_cd,"); sqlQuery.Append(" b.building_name,"); sqlQuery.Append(" l.line_cd,"); sqlQuery.Append(" l.line_name,"); sqlQuery.Append(" ulb.line_building_id AS UserLineBuildingId,"); sqlQuery.Append(" ulb.user_cd"); sqlQuery.Append(" from m_line_building lb"); sqlQuery.Append(" inner join m_line l on lb.line_id = l.line_id"); sqlQuery.Append(" inner join m_building b on lb.building_id = b.building_id"); sqlQuery.Append(" left join m_user_line_building ulb on lb.line_building_id = ulb.line_building_id"); sqlQuery.Append(" where lb.factory_cd = :faccd "); if (inVo.BuildingId > 0) { sqlQuery.Append(" and lb.building_id = :buildingid"); } if (inVo.LineId > 0) { sqlQuery.Append(" and lb.line_id = :lid"); } if (inVo.LineCode != null) { sqlQuery.Append(" and l.line_cd = :lcd"); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); sqlParameter.AddParameterInteger("buildingid", inVo.BuildingId); sqlParameter.AddParameterInteger("lid", inVo.LineId); sqlParameter.AddParameterString("lcd", inVo.LineCode); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); ValueObjectList <UserLineBuildingVo> outVo = null; while (dataReader.Read()) { UserLineBuildingVo currOutVo = new UserLineBuildingVo { LineBuildingId = Convert.ToInt32(dataReader["line_building_id"]), BuildingId = Convert.ToInt32(dataReader["building_id"]), LineId = Convert.ToInt32(dataReader["line_id"]), LineCode = dataReader["line_cd"].ToString(), LineName = dataReader["line_name"].ToString(), BuildingCode = dataReader["building_cd"].ToString(), BuildingName = dataReader["building_name"].ToString(), UserLineBuildingId = ConvertDBNull <int>(dataReader, "UserLineBuildingId"), UserCode = ConvertDBNull <string>(dataReader, "user_cd") }; if (outVo == null) { outVo = new ValueObjectList <UserLineBuildingVo>(); } outVo.add(currOutVo); } dataReader.Close(); return(outVo); }
/// <summary> /// inserts/updates process on ok click /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Update_btn_Click(object sender, EventArgs e) { if (!CheckMandatory() || LineBuildingMasterVo == null || LineBuildingMasterVo.GetList() == null) { return; } UserLineBuildingVo inVo = new UserLineBuildingVo(); inVo.UserCode = User_cmb.SelectedValue.ToString(); inVo.LineBuildingidList = LineBuildingMasterVo.GetList().Where(t => t.BuildingId == Convert.ToInt32(Building_lst.SelectedValue)).Select(s => s.LineBuildingId).ToList(); try { UpdateResultVo outDeleteVo = (UpdateResultVo)base.InvokeCbm(new DeleteUserLineBuildingMasterMntCbm(), inVo, false); IntDelSuccess = outDeleteVo.AffectedCount; } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } inVo.BuildingId = Convert.ToInt32(Building_lst.SelectedValue); UpdateResultVo outVo = new UpdateResultVo(); foreach (UserLineBuildingVo item in Line_chlst.CheckedItems) { inVo.LineId = item.LineId; UserLineBuildingVo currentVo = LineBuildingMasterVo.GetList().Where(t => t.BuildingId == inVo.BuildingId && t.LineId == inVo.LineId).FirstOrDefault(); if (currentVo == null || currentVo.LineBuildingId == 0) { messageData = new MessageData("mmce00010", Properties.Resources.mmce00010, "LineBuildingId"); logger.Info(messageData); popUpMessage.Information(messageData, Text); return; } inVo.LineBuildingId = currentVo.LineBuildingId; try { outVo = (UpdateResultVo)base.InvokeCbm(new AddUserLineBuildingMasterMntCbm(), inVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } } IntSuccess = outVo.AffectedCount; if ((IntSuccess > 0) || (IntDelSuccess > 0)) { messageData = new MessageData("mmci00002", Properties.Resources.mmci00002, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); } }
/// <summary> /// Get Line Data. /// </summary> private void LoadLineListBox() { this.Cursor = Cursors.WaitCursor; Line_chlst.DataSource = null; UserLineBuildingVo inVo = new UserLineBuildingVo(); inVo.BuildingId = Convert.ToInt32(Building_lst.SelectedValue.ToString()); try { LineBuildingMasterVo = (ValueObjectList <UserLineBuildingVo>)base.InvokeCbm(new GetUserLineBuildingMasterMntCbm(), inVo, false); } catch (Framework.ApplicationException ex) { logger.Info(ex.GetMessageData()); popUpMessage.ApplicationError(ex.GetMessageData(), Text); } if (LineBuildingMasterVo == null || LineBuildingMasterVo.GetList() == null || LineBuildingMasterVo.GetList().Count == 0) { messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, Line_lbl.Text); logger.Info(messageData); popUpMessage.Information(messageData, Text); Update_btn.Enabled = false; this.Cursor = Cursors.Default; return; } List <UserLineBuildingVo> FilteruserlinebuildingVo = LineBuildingMasterVo.GetList().GroupBy(t => new { t.LineId }) .Select(g => new UserLineBuildingVo { LineId = g.First().LineId, LineBuildingId = g.First().LineBuildingId, BuildingId = g.First().BuildingId, BuildingCode = g.First().BuildingCode, BuildingName = g.First().BuildingName, LineCode = g.First().LineCode, LineName = g.First().LineCode + " " + g.First().LineName, }).ToList(); if (FilteruserlinebuildingVo.Count > 0) { Line_chlst.DataSource = FilteruserlinebuildingVo.OrderBy(o => o.LineCode).ToList(); Line_chlst.DisplayMember = "LineName"; Line_chlst.ValueMember = "LineId"; Update_btn.Enabled = true; } else { messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, Line_lbl.Text); logger.Info(messageData); popUpMessage.Information(messageData, Text); Update_btn.Enabled = false; } UserLineBuildingVo chekLineIdVo; Line_chlst.ClearSelected(); if (LineBuildingMasterVo != null || LineBuildingMasterVo.GetList() != null || LineBuildingMasterVo.GetList().Count > 0) { for (int i = 0; i < Line_chlst.Items.Count; i++) { UserLineBuildingVo currline = (UserLineBuildingVo)Line_chlst.Items[i]; chekLineIdVo = LineBuildingMasterVo.GetList().Where(t => t.LineId == currline.LineId && t.UserCode == User_cmb.SelectedValue.ToString()).FirstOrDefault(); if (chekLineIdVo == null) { continue; } if (chekLineIdVo.UserLineBuildingId > 0) { Line_chlst.SetItemChecked(i, true); } } } this.Cursor = Cursors.Default; }