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