/// <summary> /// Get Building data. /// </summary> private void GetBuilding() { BuildingVo outVo = new BuildingVo(); try { outVo = (BuildingVo)base.InvokeCbm(new GetBuildingMasterMntCbm(), new BuildingVo(), false); outVo.BuildingListVo.ForEach(p => p.BuildingName = p.BuildingId + " " + p.BuildingName); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } if (outVo.BuildingListVo.Count > 0) { isBuildingListLoading = true; Building_lst.DataSource = outVo.BuildingListVo; Building_lst.DisplayMember = "BuildingName"; Building_lst.ValueMember = "BuildingId"; Building_lst.SelectedIndex = -1; isBuildingListLoading = false; Update_btn.Enabled = true; } }
/// <summary> /// event to delete the selected record /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Delete_btn_Click(object sender, EventArgs e) { int selectedrowindex = Building_dgv.SelectedCells[0].RowIndex; DataGridViewRow selectedRow = Building_dgv.Rows[selectedrowindex]; messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, selectedRow.Cells["colBuildingCode"].Value.ToString()); logger.Info(messageData); DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text); if (dialogResult == DialogResult.OK) { BuildingVo inVo = new BuildingVo { BuildingId = Convert.ToInt32(selectedRow.Cells["colBuildingId"].Value), BuildingCode = selectedRow.Cells["colBuildingCode"].ToString() }; try { BuildingVo checkVo = CheckRelation(inVo); if (checkVo != null && checkVo.AffectedCount > 0) { messageData = new MessageData("mmce00007", Properties.Resources.mmce00007, BUILDING.ToString()); popUpMessage.Information(messageData, Text); return; } BuildingVo outVo = (BuildingVo)base.InvokeCbm(new DeleteBuildingMasterMntCbm(), inVo, false); if (outVo.AffectedCount > 0) { messageData = new MessageData("mmci00003", Properties.Resources.mmci00003, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); GridBind(FormConditionVo()); } else if (outVo.AffectedCount == 0) { messageData = new MessageData("mmci00007", Properties.Resources.mmci00004, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); GridBind(FormConditionVo()); } } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } } else if (dialogResult == DialogResult.Cancel) { //do something else } }
/// <summary> /// Fills all user records to gridview control /// </summary> private void GridBind(BuildingVo conditionInVo) { Building_dgv.DataSource = null; try { BuildingVo outVo = (BuildingVo)base.InvokeCbm(new GetBuildingMasterMntCbm(), conditionInVo, false); Building_dgv.AutoGenerateColumns = false; BindingSource buildingSource1 = new BindingSource(outVo.BuildingListVo, null); if (buildingSource1 != null && buildingSource1.Count > 0) { Building_dgv.DataSource = buildingSource1; } else { messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null); //"Building" logger.Info(messageData); popUpMessage.Information(messageData, Text); } Building_dgv.ClearSelection(); Update_btn.Enabled = false; Delete_btn.Enabled = false; } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } }
static public void SetBuildVo(GC_BuildingData data, BuildingVo vo) { vo.guid = data.Guid; vo.type = data.Type; vo.slot = data.Slot; vo.level = data.Level; }
/// <summary> /// selects user record for updation and show user form /// </summary> private void BindUpdateBuildingData() { int selectedrowindex = Building_dgv.SelectedCells[0].RowIndex; BuildingVo cavInVo = (BuildingVo)Building_dgv.Rows[selectedrowindex].DataBoundItem; AddBuildingForm newAddForm = new AddBuildingForm(CommonConstants.MODE_UPDATE, cavInVo); newAddForm.ShowDialog(this); if (newAddForm.IntSuccess > 0) { messageData = new MessageData("mmci00002", Properties.Resources.mmci00002, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); GridBind(FormConditionVo()); } else if (newAddForm.IntSuccess == 0) { messageData = new MessageData("mmci00007", Properties.Resources.mmci00004, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); GridBind(FormConditionVo()); } }
/// <summary> /// binds treeview with line building details /// </summary> private void BindTreeView() { BuildingVo buildingInVo = new BuildingVo(); if (Building_cmb.SelectedIndex > -1) { buildingInVo.BuildingId = Convert.ToInt32(Building_cmb.SelectedValue); } BuildingVo buildingOutVo = new BuildingVo(); try { buildingOutVo = (BuildingVo)base.InvokeCbm(new GetBuildingMasterMntCbm(), buildingInVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); Logger.Error(exception.GetMessageData()); return; } string message = string.Format(Properties.Resources.mmci00009); StartProgress(message); PopulateTreeView(buildingOutVo.BuildingListVo); CompleteProgress(); }
public uint Execute(PacketDistributed ipacket) { GC_Building_LevelUp packet = (GC_Building_LevelUp )ipacket; if (null == packet) { return((uint)PACKET_EXE.PACKET_EXE_ERROR); } //enter your logic if (packet.Ret == 0) { PlayerProxy proxy = GameFacade.GetProxy <PlayerProxy> (); for (int i = 0; i < proxy.city.buildList.Count; i++) { BuildingVo buildingData = proxy.city.buildList[i]; if (buildingData.guid == packet.BuildingID) { buildingData.level = packet.Level; EventManager.GetInstance().SendEvent(EventId.BuildingLevelUp, buildingData.guid); break; } } } return((uint)PACKET_EXE.PACKET_EXE_CONTINUE); }
private void BuildingLevelUp(object id) { long guid = (long)id; PlayerProxy proxy = GameFacade.GetProxy <PlayerProxy> (); for (int i = 0; i < proxy.city.buildList.Count; i++) { BuildingVo buildingData = proxy.city.buildList [i]; if (buildingData.guid == guid) { for (int j = 0; j < buildings.Count; j++) { if (buildings [j].guid == guid) { buildings [j].level = buildingData.level; EventManager.GetInstance().SendEvent("Private_RefreshBuildingLevel", guid); break; } } break; } } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { BuildingVo inVo = (BuildingVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Update m_building"); sqlQuery.Append(" Set "); sqlQuery.Append(" building_name = :buildingname, "); sqlQuery.Append(" factory_cd = :factorycd "); sqlQuery.Append(" Where "); sqlQuery.Append(" building_id = :buildingid;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("buildingid", inVo.BuildingId); sqlParameter.AddParameterString("buildingname", inVo.BuildingName); sqlParameter.AddParameterString("factorycd", inVo.FactoryCode); BuildingVo outVo = new BuildingVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
private void SetProxy(GC_LOGIN_RET packet) { PlayerProxy proxy = GameFacade.GetProxy <PlayerProxy>(); proxy.userid = packet.Userid; proxy.oid = packet.Oid; proxy.accesstoken = packet.Accesstoken; proxy.playername = packet.Playername; proxy.level = packet.Level; //城市数据 proxy.city.cityId = packet.City.CityId; proxy.city.tileId = packet.City.TileId; proxy.city.level = packet.City.Level; proxy.city.food = packet.City.Food; proxy.city.stone = packet.City.Stone; proxy.city.iron = packet.City.Iron; proxy.city.WorldPos = new Coord(packet.City.Posx, packet.City.Posz); proxy.city.buildList.Clear(); for (int i = 0; i < packet.City.buildlistCount; i++) { GC_BuildingData data = packet.City.GetBuildlist(i); BuildingVo vo = new BuildingVo(); PlayerProxy.SetBuildVo(data, vo); proxy.city.buildList.Add(vo); } proxy.city.trainList.Clear(); for (int i = 0; i < packet.City.trainListCount; i++) { GC_TrainData data = packet.City.GetTrainList(i); TrainVo vo = new TrainVo(); PlayerProxy.SetTrainVo(data, vo); proxy.city.trainList.Add(vo); } //英雄数据 proxy.heroList.Clear(); for (int i = 0; i < packet.HeroList.heroListCount; i++) { GC_HeroData data = packet.HeroList.GetHeroList(i); HeroVo vo = new HeroVo(); PlayerProxy.SetHeroVo(data, vo); proxy.heroList.Add(vo); } //队伍数据 proxy.marchList.Clear(); for (int i = 0; i < packet.Marchlist.marchlistCount; i++) { GC_MarchData data = packet.Marchlist.GetMarchlist(i); MarchVo vo = new MarchVo(); PlayerProxy.SetMarchVo(data, vo); proxy.marchList.Add(vo); } }
/// <summary> /// For setting selected user record into respective controls(textbox and combobox) for update operation /// passing selected user data as parameter /// </summary> /// <param name="dgvMoldType"></param> private void LoadUserData(BuildingVo dgvMoldType) { if (dgvMoldType != null) { this.BuildingCode_txt.Text = dgvMoldType.BuildingCode; this.BuildingName_txt.Text = dgvMoldType.BuildingName; this.FactoryCode_cmb.SelectedValue = dgvMoldType.FactoryCode; } }
/// <summary> /// Constructor for the form /// </summary> /// <param name="pmode"></param> /// <param name="userItem"></param> public AddBuildingForm(string pmode, BuildingVo userItem = null) { InitializeComponent(); mode = pmode; updateData = userItem; if (string.Equals(mode, CommonConstants.MODE_UPDATE)) { this.Text = UpdateText_lbl.Text; } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { try { //VARIABLE BuildingVo inVo = (BuildingVo)vo; StringBuilder query = new StringBuilder(); ValueObjectList <BuildingVo> listVo = new ValueObjectList <BuildingVo>(); //CREATE SQL ADAPTER AND PARAMETER LIST DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, query.ToString()); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); //QUERY STRING query.Append("Select * from m_building where 1=1 "); if (inVo.building_id > 0 || inVo != null) { query.Append("and building_id='").Append(inVo.building_id).Append("' "); } if (string.IsNullOrEmpty(inVo.building_cd)) { query.Append("and building_cd='").Append(inVo.building_cd).Append("' "); } query.Append("order by building_id"); //GET SQL ADAPTER sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, query.ToString()); //EXECUTE READER FROM COMMAND IDataReader datareader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (datareader.Read()) { BuildingVo outVo = new BuildingVo { building_id = (int)datareader["building_id"], building_cd = datareader["building_cd"].ToString(), building_name = datareader["building_name"].ToString(), registration_user_cd = datareader["registration_user_cd"].ToString(), registration_date_time = (DateTime)datareader["registration_date_time"], factory_cd = datareader["factory_cd"].ToString() }; listVo.add(outVo); } //CLEAR AND CLOSE CONNECTION query.Clear(); datareader.Close(); base.CloseConnection(trxContext); return(listVo); } catch { throw new NotImplementedException(); } }
/// <summary> /// form country and factory data for combo /// </summary> //private void FormDatatableFromVo() //{ // moldDatatable = new DataTable(); // moldDatatable.Columns.Add("id"); // moldDatatable.Columns.Add("code"); // try // { // MoldVo moldOutVo = (MoldVo)base.InvokeCbm(new GetMoldMasterMntCbm(), new MoldVo (), false); // foreach (MoldVo mold in moldOutVo.MoldListVo) // { // moldDatatable.Rows.Add(mold.MoldId, mold.MoldCode); // } // } // catch (Framework.ApplicationException exception) // { // popUpMessage.ApplicationError(exception.GetMessageData(), Text); // logger.Error(exception.GetMessageData()); // } //} /// <summary> /// checks duplicate mold Code /// </summary> /// <returns></returns> private BuildingVo DuplicateCheck(BuildingVo BuildingVo) { BuildingVo outVo = new BuildingVo(); try { outVo = (BuildingVo)base.InvokeCbm(new CheckBuildingMasterMntCbm(), BuildingVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { BuildingVo inVo = (BuildingVo)arg; StringBuilder sqlQuery = new StringBuilder(); //create SQL sqlQuery.Append("Select Count(*) as BuildingCount from m_building "); sqlQuery.Append(" where factory_cd = :faccd "); if (inVo.BuildingCode != null) { sqlQuery.Append(" and UPPER(building_cd) = UPPER(:buildingcd) "); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); if (inVo.BuildingCode != null) { sqlParameter.AddParameterString("buildingcd", inVo.BuildingCode); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); BuildingVo outVo = new BuildingVo { AffectedCount = 0 }; while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32(dataReader["BuildingCount"]); } dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { BuildingVo inVo = (BuildingVo)arg; BuildingVo outVo = new BuildingVo(); StringBuilder sqlQuery = new StringBuilder(); //create SQL sqlQuery.Append("select count(bdg.building_cd) as RoleCount from m_building bdg"); sqlQuery.Append(" inner join m_location ltn on ltn.building_id = bdg.building_id"); sqlQuery.Append(" where bdg.factory_cd = :faccd "); if (inVo.BuildingId > 0) { sqlQuery.Append(" and bdg.building_id = :buildingid "); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); if (inVo.BuildingId > 0) { sqlParameter.AddParameterInteger("buildingid", inVo.BuildingId); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); outVo.AffectedCount = 0; while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32("0" + dataReader["RoleCount"].ToString()); } dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { BuildingVo inVo = (BuildingVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_building"); sqlQuery.Append(" ( "); sqlQuery.Append(" building_cd, "); sqlQuery.Append(" building_name, "); //sqlQuery.Append(" building_id, "); sqlQuery.Append(" registration_user_cd, "); sqlQuery.Append(" registration_date_time, "); sqlQuery.Append(" factory_cd "); sqlQuery.Append(" ) "); sqlQuery.Append("VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :buildingcd ,"); sqlQuery.Append(" :buildingname ,"); //sqlQuery.Append(" :buildingid ,"); 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("buildingcd", inVo.BuildingCode); sqlParameter.AddParameterString("buildingname", inVo.BuildingName); //sqlParameter.AddParameterInteger("buildingid", inVo.BuildingId); sqlParameter.AddParameterString("registrationusercode", trxContext.UserData.UserCode); sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycode", inVo.FactoryCode); BuildingVo outVo = new BuildingVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
/// <summary> /// Load Building /// </summary> private void LoadBuilding() { BuildingVo outVo = new BuildingVo(); try { outVo = (BuildingVo)base.InvokeCbm(new GetBuildingMasterMntCbm(), new BuildingVo(), false); outVo.BuildingListVo.ForEach(p => p.BuildingName = p.BuildingCode + " " + p.BuildingName); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); Logger.Error(exception.GetMessageData()); return; } ComboBind(Building_cmb, outVo.BuildingListVo, "BuildingName", "BuildingId"); }
/// <summary> /// Creates seacrh condition as per user inputs /// </summary> /// <returns>search condition</returns> private BuildingVo FormConditionVo() { BuildingVo inVo = new BuildingVo(); if (BuildingCode_txt.Text != string.Empty) { inVo.BuildingCode = BuildingCode_txt.Text; } if (BuildingName_txt.Text != string.Empty) { inVo.BuildingName = BuildingName_txt.Text; } if (FactoryCode_cmb.SelectedIndex > -1) { inVo.FactoryCode = FactoryCode_cmb.SelectedValue.ToString(); } return(inVo); }
/// <summary> /// Get Building Information and set it in combo box /// </summary> private void GetBuildingInfomation() { BuildingVo buildinginVo = new BuildingVo(); BuildingVo buildingoutVo = new BuildingVo(); buildinginVo.FactoryCode = UserData.GetUserData().FactoryCode; try { buildingoutVo = (BuildingVo)DefaultCbmInvoker.Invoke(new GetBuildingMasterMntCbm(), buildinginVo); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } if (buildingoutVo != null && buildingoutVo.BuildingListVo.Count > 0) { ComboBind(Building_cmb, buildingoutVo.BuildingListVo, "BuildingName", "BuildingId"); } }
/// <summary> /// form country and factory data for combo /// </summary> private void FormDatatableFromVo() { buildingDatatable = new DataTable(); buildingDatatable.Columns.Add("id"); buildingDatatable.Columns.Add("name"); try { BuildingVo buOutVo = (BuildingVo)base.InvokeCbm(new GetBuildingMasterMntCbm(), new BuildingVo(), false); foreach (BuildingVo bu in buOutVo.BuildingListVo) { buildingDatatable.Rows.Add(bu.BuildingId, bu.BuildingName); } } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } }
//通过Slot设置兵营数据位置 public void SetBarrackData(int slot) { curSlot = slot; //获取当前兵营Slot在所有兵营中的index Dictionary <int, List <Tab_CityBuildingSlot> > slotDic = TableManager.GetCityBuildingSlot(); int indx = -1; foreach (KeyValuePair <int, List <Tab_CityBuildingSlot> > k in slotDic) { if (k.Value[0].BuildingType == slotDic[slot][0].BuildingType) { indx++; if (k.Key == slot) { break; } } } curSlotIndex = indx; //获取当前槽位建筑物的Guid for (int i = 0; i < playerProxy.city.buildList.Count; i++) { BuildingVo data = playerProxy.city.buildList [i]; if (data.slot == curSlot) { curBuildingGuid = data.guid; break; } } SetCurTroopIndex(); SetCurHeroIndex(); //更新界面 EventManager.GetInstance().SendEvent("Private_TroopTrainRefreshAll"); }
/// <summary> /// update the record to db /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Ok_btn_Click(object sender, EventArgs e) { BuildingVo inVo = new BuildingVo(); if (CheckMandatory()) { var sch = StringCheckHelper.GetInstance(); if (!sch.IsASCII(BuildingCode_txt.Text) || !sch.IsASCII(BuildingName_txt.Text)) { messageData = new MessageData("mmce00003", Properties.Resources.mmce00003); logger.Info(messageData); popUpMessage.ConfirmationOkCancel(messageData, Text); if (!sch.IsASCII(BuildingCode_txt.Text)) { BuildingCode_txt.Focus(); } else { BuildingName_txt.Focus(); } return; } inVo.BuildingCode = BuildingCode_txt.Text.Trim(); inVo.BuildingName = BuildingName_txt.Text.Trim(); inVo.FactoryCode = FactoryCode_cmb.SelectedValue.ToString(); if (string.Equals(mode, CommonConstants.MODE_ADD)) { BuildingVo checkVo = DuplicateCheck(inVo); if (checkVo != null && checkVo.AffectedCount > 0) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, BuildingCode_lbl.Text + " : " + BuildingCode_txt.Text); logger.Info(messageData); popUpMessage.ConfirmationOkCancel(messageData, Text); BuildingCode_txt.Focus(); return; } } try { if (string.Equals(mode, CommonConstants.MODE_ADD)) { BuildingVo outVo = (BuildingVo)base.InvokeCbm(new AddBuildingMasterMntCbm(), inVo, false); IntSuccess = outVo.AffectedCount; } else if (mode.Equals(CommonConstants.MODE_UPDATE)) { inVo.BuildingId = updateData.BuildingId; BuildingVo outVo = (BuildingVo)base.InvokeCbm(new UpdateBuildingMasterMntCbm(), inVo, false); IntSuccess = outVo.AffectedCount; } } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } if ((IntSuccess > 0) || (IntSuccess == 0)) { this.Close(); } } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { BuildingVo inVo = (BuildingVo)arg; StringBuilder sqlQuery = new StringBuilder(); //create SQL sqlQuery.Append("Select ct.building_id, ct.building_cd, ct.building_name, "); sqlQuery.Append(" ct.factory_cd from m_building ct "); sqlQuery.Append(" where 1 = 1 "); if (inVo.BuildingCode != null) { sqlQuery.Append(" and ct.building_cd like :buildingcd "); } if (inVo.BuildingName != null) { sqlQuery.Append(" and ct.building_name like :buildingname "); } if (inVo.FactoryCode != null) { sqlQuery.Append(" and factory_cd = :factorycd "); } sqlQuery.Append(" order by ct.building_cd"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); if (inVo.BuildingCode != null) { sqlParameter.AddParameterString("buildingcd", inVo.BuildingCode + "%"); } if (inVo.BuildingName != null) { sqlParameter.AddParameterString("buildingname", inVo.BuildingName + "%"); } if (inVo.FactoryCode != null) { sqlParameter.AddParameterString("factorycd", inVo.FactoryCode); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); BuildingVo outVo = new BuildingVo(); while (dataReader.Read()) { BuildingVo currOutVo = new BuildingVo { BuildingId = Convert.ToInt32(dataReader["building_id"]), BuildingCode = dataReader["building_cd"].ToString(), BuildingName = dataReader["building_name"].ToString(), FactoryCode = dataReader["factory_cd"].ToString() }; outVo.BuildingListVo.Add(currOutVo); } dataReader.Close(); return(outVo); }