private void AddMachineStatusForm_Load(object sender, EventArgs e) { LocationVo Locationvo = (LocationVo)DefaultCbmInvoker.Invoke(new GetLocationMasterMntCbm(), new LocationVo()); section_cbm.DataSource = Locationvo.LocationListVo; section_cbm.DisplayMember = "LocationCode"; }
/// <summary> /// Fills all user records to gridview control /// </summary> private void GridBind(LocationVo conditionInVo) { Location_dgv.DataSource = null; try { LocationVo outVo = (LocationVo)base.InvokeCbm(new GetLocationMasterMntCbm(), conditionInVo, false); Location_dgv.AutoGenerateColumns = false; BindingSource bindingSource1 = new BindingSource(outVo.LocationListVo, null); if (bindingSource1 != null && bindingSource1.Count > 0) { Location_dgv.DataSource = bindingSource1; } else { messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); } Location_dgv.ClearSelection(); Update_btn.Enabled = false; Delete_btn.Enabled = false; } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { LocationVo inVo = (LocationVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <LocationVo> voList = new ValueObjectList <LocationVo>(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"SELECT distinct location_cd from m_location order by location_cd"); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { LocationVo outVo = new LocationVo { LocationCode = dataReader["location_cd"].ToString() }; voList.add(outVo); } dataReader.Close(); return(voList); }
/// <summary> /// selects user record for updation and show user form /// </summary> private void BindUpdateLocationData() { int selectedrowindex = Location_dgv.SelectedCells[0].RowIndex; LocationVo cavInVo = (LocationVo)Location_dgv.Rows[selectedrowindex].DataBoundItem; AddLocationForm newAddForm = new AddLocationForm(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.mmci00007, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); GridBind(FormConditionVo()); } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { LocationVo inVo = (LocationVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Update m_location"); sqlQuery.Append(" Set "); sqlQuery.Append(" location_name = :locationname, "); sqlQuery.Append(" building_id = :buildingid "); sqlQuery.Append(" Where "); sqlQuery.Append(" location_id = :locationid "); sqlQuery.Append(" and factory_cd = :faccd ;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("locationid", inVo.LocationId); sqlParameter.AddParameterString("locationname", inVo.LocationName); sqlParameter.AddParameterInteger("buildingid", inVo.BuildingId); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); LocationVo outVo = new LocationVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
private void before_location_cmb_SelectedIndexChanged(object sender, EventArgs e) { //location LocationVo Locationvo = (LocationVo)DefaultCbmInvoker.Invoke(new GetLocationMasterMntCbm(), new LocationVo()); cmbAfterLocation.DataSource = Locationvo.LocationListVo; cmbAfterLocation.DisplayMember = "LocationCode"; }
private void DetailPositionForm_Load(object sender, EventArgs e) { LocationVo Locationvo = (LocationVo)DefaultCbmInvoker.Invoke(new GetLocationMasterMntCbm(), new LocationVo()); locationcd_cbm.DataSource = Locationvo.LocationListVo; locationcd_cbm.DisplayMember = "LocationCode"; locationcd_cbm.Text = ""; }
private void AddPlanWorkingStatusForm_Load(object sender, EventArgs e) { rate_txt.ReadOnly = true; LocationVo Locationvo = (LocationVo)DefaultCbmInvoker.Invoke(new GetLocationMasterMntCbm(), new LocationVo()); section_cbm.DataSource = Locationvo.LocationListVo; section_cbm.DisplayMember = "LocationCode"; }
/// <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(LocationVo dgvMoldType) { if (dgvMoldType != null) { this.LocationCode_txt.Text = dgvMoldType.LocationCode; this.LocationName_txt.Text = dgvMoldType.LocationName; this.Building_cmb.SelectedValue = dgvMoldType.BuildingId.ToString(); } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { LocationVo inVo = (LocationVo)arg; StringBuilder sqlQuery = new StringBuilder(); //create SQL sqlQuery.Append("Select Count(*) as locationCount from m_location "); sqlQuery.Append(" where 1 = 1 "); if (inVo.LocationCode != null) { sqlQuery.Append(" and UPPER(location_cd) = UPPER(:locationcd) "); } //if (inVo.BuildingId > 0) //{ // sqlQuery.Append(" and building_id = :buildingid "); //} //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); if (inVo.LocationCode != null) { sqlParameter.AddParameterString("locationcd", inVo.LocationCode); } //if (inVo.BuildingId > 0) //{ // sqlParameter.AddParameterInteger("buildingid", inVo.BuildingId); //} //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); LocationVo outVo = new LocationVo { AffectedCount = 0 }; while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32(dataReader["locationCount"]); } dataReader.Close(); return(outVo); }
/// <summary> /// Constructor for the form /// </summary> /// <param name="pmode"></param> /// <param name="userItem"></param> public AddLocationForm(string pmode, LocationVo 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 LocationVo inVo = (LocationVo)vo; StringBuilder query = new StringBuilder(); ValueObjectList <LocationVo> listVo = new ValueObjectList <LocationVo>(); //CREATE SQL ADAPTER AND PARAMETER LIST DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, query.ToString()); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); //QUERY STRING query.Append("Select * from m_location where 1=1 "); if (inVo.location_id > 0 || inVo != null) { query.Append("and location_id='").Append(inVo.location_id).Append("' "); } if (string.IsNullOrEmpty(inVo.location_cd)) { query.Append("and location_cd='").Append(inVo.location_cd).Append("' "); } query.Append("order by location_id"); //GET SQL ADAPTER sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, query.ToString()); //EXECUTE READER FROM COMMAND IDataReader datareader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (datareader.Read()) { LocationVo outVo = new LocationVo { location_id = (int)datareader["location_id"], location_cd = datareader["location_cd"].ToString(), location_name = datareader["location_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(); } }
private void AddUserLocationForm_Load(object sender, EventArgs e) { UserLocationCode_txt.Select(); if (vo.UserLocationId > 0) { UserLocationCode_txt.Text = vo.UserLocationCode; UserLocationName_txt.Text = vo.UserLocationName; } LocationVo Locationvo = (LocationVo)DefaultCbmInvoker.Invoke(new GetLocationMasterMntCbm(), new LocationVo()); locationcode_cmb.DataSource = Locationvo.LocationListVo; locationcode_cmb.DisplayMember = "LocationCode"; locationcode_cmb.Text = ""; }
/// <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 = Location_dgv.SelectedCells[0].RowIndex; DataGridViewRow selectedRow = Location_dgv.Rows[selectedrowindex]; messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, selectedRow.Cells["colLocationCode"].Value.ToString()); logger.Info(messageData); DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text); if (dialogResult == DialogResult.OK) { LocationVo inVo = new LocationVo(); inVo.LocationId = Convert.ToInt32(selectedRow.Cells["colLocationId"].Value); try { LocationVo outVo = (LocationVo)base.InvokeCbm(new DeleteLocationMasterMntCbm(), 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.mmci00007, 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 } }
private void before_location_cmb_SelectedIndexChanged(object sender, EventArgs e) { //location LocationVo Locationvo = (LocationVo)DefaultCbmInvoker.Invoke(new GetLocationMasterMntCbm(), new LocationVo()); after_location_cmb.DataSource = Locationvo.LocationListVo; after_location_cmb.DisplayMember = "LocationCode"; ValueObjectList <DetailPositionVo> detailposition = (ValueObjectList <DetailPositionVo>)DefaultCbmInvoker.Invoke(new GetDetailPositionCbm(), new DetailPositionVo()); detail_position_cmb.DisplayMember = "DetailPositionCode"; detail_position_cmb.DataSource = detailposition.GetList(); detail_position_cmb.Text = ""; }
/// <summary> /// checks duplicate mold Code /// </summary> /// <returns></returns> private LocationVo DuplicateCheck(LocationVo LocationVo) { LocationVo outVo = new LocationVo(); try { outVo = (LocationVo)base.InvokeCbm(new CheckLocationMasterMntCbm(), LocationVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } return(outVo); }
private void WareHouseForm_Load(object sender, EventArgs e) { //this.Width = Screen.PrimaryScreen.WorkingArea.Width; //this.Height = Screen.PrimaryScreen.WorkingArea.Height - 300; //this.ware_house_dgv.Height = Screen.PrimaryScreen.WorkingArea.Height - 300; AcceptButton = search_btn; select_search_cbm.Items.Add("Search History"); select_search_cbm.Items.Add("Search List"); select_search_cbm.Text = "Search History"; ware_house_dgv.ReadOnly = true; ValueObjectList <RankVo> rankcode = (ValueObjectList <RankVo>)DefaultCbmInvoker.Invoke(new GetRankCbm(), new RankVo()); rank_code_cbm.DisplayMember = "RankCode"; rank_code_cbm.DataSource = rankcode.GetList(); rank_code_cbm.Text = ""; ValueObjectList <AssetVo> assetvotype = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetTypeCbm(), new AssetVo()); asset_type_cbm.DisplayMember = "AssetType"; asset_type_cbm.DataSource = assetvotype.GetList(); asset_type_cbm.Text = ""; ValueObjectList <AssetVo> assetvomodel = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetModelCbm(), new AssetVo()); asset_model_cbm.DisplayMember = "AssetModel"; asset_model_cbm.DataSource = assetvomodel.GetList(); asset_model_cbm.Text = ""; ValueObjectList <AssetVo> assetvoname = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetNameCbm(), new AssetVo()); asset_name_cbm.DisplayMember = "AssetName"; asset_name_cbm.DataSource = assetvoname.GetList(); asset_name_cbm.Text = ""; ValueObjectList <AssetVo> assetvoinvoice = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetInvoiceCbm(), new AssetVo()); invoice_cbm.DisplayMember = "AssetInvoice"; invoice_cbm.DataSource = assetvoinvoice.GetList(); invoice_cbm.Text = ""; LocationVo Locationvo = (LocationVo)DefaultCbmInvoker.Invoke(new GetLocationMasterMntCbm(), new LocationVo()); select_after_location_cbm.DisplayMember = "LocationCode"; select_after_location_cbm.DataSource = Locationvo.LocationListVo; select_after_location_cbm.Text = ""; }
private void AddWareHouseForm_Load(object sender, EventArgs e) { WareHouseVo whvo = new WareHouseVo(); //load rank name ValueObjectList <RankVo> rankname = (ValueObjectList <RankVo>)DefaultCbmInvoker.Invoke(new GetRankCbm(), new RankVo()); rank_name_cmb.DisplayMember = "RankName"; rank_name_cmb.DataSource = rankname.GetList(); //before_location_cmb load LocationVo Locationvo = (LocationVo)DefaultCbmInvoker.Invoke(new GetLocationMasterMntCbm(), new LocationVo()); before_location_cmb.DisplayMember = "LocationCode"; before_location_cmb.DataSource = Locationvo.LocationListVo; qty_txt.Text = "1"; unit_cmb.Items.Add("m"); unit_cmb.Items.Add("pcs"); unit_cmb.Items.Add("box"); unit_cmb.Items.Add("pallet"); unit_cmb.Items.Add("unit"); user_location_name_cbm.Enabled = false; comments_txt.Enabled = true; if (warehousevo.WareHouseId > 0) { asset_code_txt.Enabled = false; timestart_dtp.Enabled = false; unit_cmb.Enabled = false; asset_code_txt.Text = warehousevo.AssetCode; rank_name_cmb.Text = warehousevo.RankName; qty_txt.Text = warehousevo.Qty.ToString(); unit_cmb.Text = warehousevo.Unit; before_location_cmb.Text = warehousevo.BeforeLocation; after_location_cmb.Text = warehousevo.AfterLocation; timestart_dtp.Value = warehousevo.TimeStart; this.TitleText = Com.Nidec.Mes.GlobalMasterMaintenance.CommonConstants.MODE_UPDATE; } else { comments_txt.Text = "Add"; this.TitleText = Com.Nidec.Mes.GlobalMasterMaintenance.CommonConstants.MODE_ADD; } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { LocationVo inVo = (LocationVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_location"); sqlQuery.Append(" ( "); sqlQuery.Append(" location_cd, "); sqlQuery.Append(" location_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(" :locationcd ,"); sqlQuery.Append(" :locationname ,"); 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("locationcd", inVo.LocationCode); sqlParameter.AddParameterString("locationname", inVo.LocationName); sqlParameter.AddParameterInteger("buildingid", inVo.BuildingId); sqlParameter.AddParameterString("registrationusercode", trxContext.UserData.UserCode); sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode); LocationVo outVo = new LocationVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
/// <summary> /// Creates seacrh condition as per user inputs /// </summary> /// <returns>search condition</returns> private LocationVo FormConditionVo() { LocationVo inVo = new LocationVo(); if (LocationCode_txt.Text != string.Empty) { inVo.LocationCode = LocationCode_txt.Text; } if (LocationName_txt.Text != string.Empty) { inVo.LocationName = LocationName_txt.Text; } if (Building_cmb.SelectedIndex > -1) { inVo.BuildingId = Convert.ToInt32(Building_cmb.SelectedValue); } return(inVo); }
/// <summary> /// form country and factory data for combo /// </summary> private void FormDatatableFromVo() { locationDatatable = new DataTable(); locationDatatable.Columns.Add("id"); locationDatatable.Columns.Add("name"); try { LocationVo locationOutVo = (LocationVo)base.InvokeCbm(new GetLocationMasterMntCbm(), new LocationVo(), false); foreach (LocationVo location in locationOutVo.LocationListVo) { locationDatatable.Rows.Add(location.LocationId, location.LocationName); } } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } }
private void InvertoryCheckForm_Load(object sender, EventArgs e) { AcceptButton = Invertory_btn; ValueObjectList <InvertoryVo> detailposition = (ValueObjectList <InvertoryVo>)DefaultCbmInvoker.Invoke(new GetInvertoryTimeCbm(), new InvertoryVo()); InvertoryTimeCode_cbm.DisplayMember = "InvertoryTimeCode"; InvertoryTimeCode_cbm.DataSource = detailposition.GetList(); InvertoryTimeCode_cbm.Text = ""; LocationVo Locationvo = (LocationVo)DefaultCbmInvoker.Invoke(new GetLocationMasterMntCbm(), new LocationVo()); location_cbm.DisplayMember = "LocationCode"; location_cbm.DataSource = Locationvo.LocationListVo; location_cbm.Text = ""; asset_Code_cmb.Select(); // ValueObjectList<RankVo> rankcode = (ValueObjectList<RankVo>)DefaultCbmInvoker.Invoke(new GetRankCbm(), new RankVo()); //InvertoryCheck_dgv. // DisplayMember = "RankCode"; //rank_code_cbm.DataSource = rankcode.GetList(); //rank_code_cbm.Text = ""; }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { LocationVo inVo = (LocationVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Delete From m_location"); sqlQuery.Append(" Where "); sqlQuery.Append(" location_id = :locationid ;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("locationid", inVo.LocationId); LocationVo outVo = new LocationVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public AccountMainVo accountmainVo = new AccountMainVo(); //dv private void AddAcountMainForm_Load(object sender, EventArgs e) { //rank ValueObjectList <RankVo> rankname = (ValueObjectList <RankVo>)DefaultCbmInvoker.Invoke(new GetRankCbm(), new RankVo()); rank_code_cmb.DisplayMember = "RankCode"; rank_code_cmb.DataSource = rankname.GetList(); rank_code_cmb.Text = ""; //location LocationVo Locationvo = (LocationVo)DefaultCbmInvoker.Invoke(new GetLocationMasterMntCbm(), new LocationVo()); location_cmb.DataSource = Locationvo.LocationListVo; location_cmb.DisplayMember = "LocationCode"; location_cmb.Text = ""; // account_code ValueObjectList <AccountCodeVo> accountcodevo = (ValueObjectList <AccountCodeVo>)DefaultCbmInvoker.Invoke(new GetAccountCodeCbm(), new AccountCodeVo()); account_code_cmb.DisplayMember = "AccountCodeCode"; account_code_cmb.DataSource = accountcodevo.GetList(); account_code_cmb.Text = ""; //accountlocationcode ValueObjectList <AccountLocationVo> accountlocationcodevo = (ValueObjectList <AccountLocationVo>)DefaultCbmInvoker.Invoke(new GetAccountLocationCbm(), new AccountLocationVo()); section_cd_cmb.DisplayMember = "AccountLocationCode"; section_cd_cmb.DataSource = accountlocationcodevo.GetList(); section_cd_cmb.Text = ""; //cau cua dang ValueObjectList <AssetVo> assetmodelvo = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetCbm(), new AssetVo()); no_cbm.DisplayMember = "AssetNo"; no_cbm.ValueMember = "AssetId"; no_cbm.DataSource = assetmodelvo.GetList(); //end ValueObjectList <UnitVo> unit = (ValueObjectList <UnitVo>)DefaultCbmInvoker.Invoke(new GetUnitCbm(), new UnitVo()); unit_cmb.DisplayMember = "UnitCode"; unit_cmb.DataSource = unit.GetList(); unit_cmb.Text = ""; { user_location_name_cmb.Enabled = false; asset_model_cmb.Enabled = false; end_depreciation_dtp.Enabled = false; asset_life_cmb.Enabled = false; acquisition_cost_cmb.Enabled = false; current_depreciation_txt.Enabled = false; monthl_depreciation_txt.Enabled = false; accum_depreciation_txt.Enabled = false; net_value_txt.Enabled = false; } if (accountmainVo.AcountMainId > 0) { asset_code_txt.Enabled = false; no_cbm.Enabled = false; no_cbm.Text = accountmainVo.AssetNo.ToString(); asset_code_txt.Text = accountmainVo.AssetCode; asset_model_cmb.Text = accountmainVo.AssetModel; rank_code_cmb.Text = accountmainVo.RankCode; account_code_cmb.Text = accountmainVo.AccountCodeCode; section_cd_cmb.Text = accountmainVo.AccountLocationCode; location_cmb.Text = accountmainVo.AccountLocationName; qty_txt.Text = accountmainVo.QTY.ToString(); unit_cmb.Text = accountmainVo.UnitName; start_depreciation_dtp.Value = accountmainVo.StartDepreciation; end_depreciation_dtp.Value = accountmainVo.EndDepreciation; asset_life_cmb.Text = accountmainVo.AssetLife.ToString(); acquisition_cost_cmb.Text = accountmainVo.AcquisitionCost.ToString(); current_depreciation_txt.Text = accountmainVo.CurrentDepreciation.ToString(); monthl_depreciation_txt.Text = accountmainVo.MonthlyDepreciation.ToString(); accum_depreciation_txt.Text = accountmainVo.AccumDepreciation.ToString(); net_value_txt.Text = accountmainVo.NetValue.ToString(); this.TitleText = Com.Nidec.Mes.GlobalMasterMaintenance.CommonConstants.MODE_UPDATE; } else { comments_txt.Text = "Add"; this.TitleText = Com.Nidec.Mes.GlobalMasterMaintenance.CommonConstants.MODE_ADD; } }
/// <summary> /// update the record to db /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Ok_btn_Click(object sender, EventArgs e) { LocationVo inVo = new LocationVo(); if (CheckMandatory()) { var sch = StringCheckHelper.GetInstance(); if (!sch.IsASCII(LocationCode_txt.Text) || !sch.IsASCII(LocationName_txt.Text)) { messageData = new MessageData("mmce00003", Properties.Resources.mmce00003); logger.Info(messageData); popUpMessage.ConfirmationOkCancel(messageData, Text); if (!sch.IsASCII(LocationCode_txt.Text)) { LocationCode_txt.Focus(); } else { LocationName_txt.Focus(); } return; } //if(LocationCode_txt.Text.Trim().Length < 4) //{ // MessageData messageData = new MessageData("mmci00008", Properties.Resources.mmci00008, LocationCode_lbl.Text); // popUpMessage.Warning(messageData, Text); // LocationCode_txt.Focus(); // return; //} inVo.LocationCode = LocationCode_txt.Text.Trim(); inVo.LocationName = LocationName_txt.Text.Trim(); inVo.BuildingId = Convert.ToInt32(Building_cmb.SelectedValue); if (string.Equals(mode, CommonConstants.MODE_ADD)) { LocationVo checkVo = DuplicateCheck(inVo); if (checkVo != null && checkVo.AffectedCount > 0) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, LocationCode_lbl.Text + " : " + LocationCode_txt.Text); logger.Info(messageData); popUpMessage.ConfirmationOkCancel(messageData, Text); LocationCode_txt.Focus(); return; } } try { if (string.Equals(mode, CommonConstants.MODE_ADD)) { LocationVo outVo = (LocationVo)base.InvokeCbm(new AddLocationMasterMntCbm(), inVo, false); IntSuccess = outVo.AffectedCount; } else if (mode.Equals(CommonConstants.MODE_UPDATE)) { inVo.LocationId = updateData.LocationId; LocationVo outVo = (LocationVo)base.InvokeCbm(new UpdateLocationMasterMntCbm(), 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) { LocationVo inVo = (LocationVo)arg; StringBuilder sqlQuery = new StringBuilder(); //create SQL sqlQuery.Append("Select ct.location_id, ct.location_cd, ct.location_name, md.building_id, md.building_name "); sqlQuery.Append(" from m_location ct "); sqlQuery.Append(" inner join m_building md on md.building_id = ct.building_id "); sqlQuery.Append(" where ct.factory_cd = :faccd "); if (inVo.LocationCode != null) { sqlQuery.Append(" and ct.location_cd like :locationcd "); } if (inVo.LocationName != null) { sqlQuery.Append(" and ct.location_name like :locationname "); } if (inVo.BuildingId != 0) { sqlQuery.Append(" and md.building_id = :buildingid "); } sqlQuery.Append(" order by ct.location_cd"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); if (inVo.LocationCode != null) { sqlParameter.AddParameterString("locationcd", inVo.LocationCode + "%"); } if (inVo.LocationName != null) { sqlParameter.AddParameterString("locationname", inVo.LocationName + "%"); } if (inVo.BuildingId != 0) { sqlParameter.AddParameterInteger("buildingid", inVo.BuildingId); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); LocationVo outVo = new LocationVo(); while (dataReader.Read()) { LocationVo currOutVo = new LocationVo { LocationId = Convert.ToInt32(dataReader["location_id"]), LocationCode = dataReader["location_cd"].ToString(), LocationName = dataReader["location_name"].ToString(), BuildingId = Convert.ToInt32(dataReader["building_id"]), BuildingName = dataReader["building_name"].ToString() }; outVo.LocationListVo.Add(currOutVo); } dataReader.Close(); return(outVo); }
private void AccountMainForm_Load(object sender, EventArgs e) { { account_depreciation_dgv.DefaultCellStyle.Font = new Font("Arial", 9); account_depreciation_dgv.ColumnHeadersDefaultCellStyle.Font = new Font("Arial", 9, FontStyle.Bold); account_main_dgv.DefaultCellStyle.Font = new Font("Arial", 9); account_main_dgv.ColumnHeadersDefaultCellStyle.Font = new Font("Arial", 9, FontStyle.Bold); } AcceptButton = search_btn; ValueObjectList <RankVo> rankcode = (ValueObjectList <RankVo>)DefaultCbmInvoker.Invoke(new GetRankCbm(), new RankVo()); rank_code_cbm.DisplayMember = "RankCode"; rank_code_cbm.DataSource = rankcode.GetList(); rank_code_cbm.Text = ""; ValueObjectList <AssetVo> assetvotype = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetTypeCbm(), new AssetVo()); asset_type_cbm.DisplayMember = "AssetType"; asset_type_cbm.DataSource = assetvotype.GetList(); asset_type_cbm.Text = ""; // account_code ValueObjectList <AccountCodeVo> accountcodevo = (ValueObjectList <AccountCodeVo>)DefaultCbmInvoker.Invoke(new GetAccountCodeCbm(), new AccountCodeVo()); account_code_cmb.DisplayMember = "AccountCodeCode"; account_code_cmb.DataSource = accountcodevo.GetList(); account_code_cmb.Text = ""; //accountlocationcode ValueObjectList <AccountLocationVo> accountlocationcodevo = (ValueObjectList <AccountLocationVo>)DefaultCbmInvoker.Invoke(new GetAccountLocationCbm(), new AccountLocationVo()); section_cd_cmb.DisplayMember = "AccountLocationCode"; section_cd_cmb.DataSource = accountlocationcodevo.GetList(); section_cd_cmb.Text = ""; ValueObjectList <AssetVo> assetvoinvoice = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetInvoiceCbm(), new AssetVo()); invoice_cbm.DisplayMember = "AssetInvoice"; invoice_cbm.DataSource = assetvoinvoice.GetList(); invoice_cbm.Text = ""; ValueObjectList <AssetVo> assetPO = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetPOCbm(), new AssetVo()); AssetPO_cmb.DisplayMember = "AssetPO"; AssetPO_cmb.DataSource = assetPO.GetList(); AssetPO_cmb.Text = ""; ValueObjectList <InvertoryVo> invertory = (ValueObjectList <InvertoryVo>)DefaultCbmInvoker.Invoke(new GetInvertoryTimeCbm(), new InvertoryVo()); invertory_cmb.DisplayMember = "InvertoryTimeCode"; invertory_cmb.DataSource = invertory.GetList(); ValueObjectList <AssetVo> assetvomodel = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetModelCbm(), new AssetVo()); asset_model_cbm.DisplayMember = "AssetModel"; asset_model_cbm.DataSource = assetvomodel.GetList(); asset_model_cbm.Text = ""; ValueObjectList <AssetVo> assetvoname = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetNameCbm(), new AssetVo()); asset_name_cbm.DisplayMember = "AssetName"; asset_name_cbm.DataSource = assetvoname.GetList(); asset_name_cbm.Text = ""; LocationVo Locationvo = (LocationVo)DefaultCbmInvoker.Invoke(new GetLocationMasterMntCbm(), new LocationVo()); location_cbm.DisplayMember = "LocationCode"; location_cbm.DataSource = Locationvo.LocationListVo; location_cbm.Text = ""; }
private void WareHouseMainForm_Load(object sender, EventArgs e) { AcceptButton = search_btn; select_search_cbm.Items.Add("Search History"); select_search_cbm.Items.Add("Search List"); select_search_cbm.Text = "Search History"; { account_depreciation_dgv.DefaultCellStyle.Font = new Font("Arial", 9); account_depreciation_dgv.ColumnHeadersDefaultCellStyle.Font = new Font("Arial", 9, FontStyle.Bold); warehouse_main_dgv.DefaultCellStyle.Font = new Font("Arial", 9); warehouse_main_dgv.ColumnHeadersDefaultCellStyle.Font = new Font("Arial", 9, FontStyle.Bold); } AcceptButton = search_btn; ValueObjectList <RankVo> rankcode = (ValueObjectList <RankVo>)DefaultCbmInvoker.Invoke(new GetRankCbm(), new RankVo()); rank_code_cbm.DisplayMember = "RankCode"; rank_code_cbm.DataSource = rankcode.GetList(); rank_code_cbm.Text = ""; ValueObjectList <AssetVo> assetvotype = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetTypeCbm(), new AssetVo()); asset_type_cbm.DisplayMember = "AssetType"; asset_type_cbm.DataSource = assetvotype.GetList(); asset_type_cbm.Text = ""; // account_code ValueObjectList <DetailPositionVo> detailposition = (ValueObjectList <DetailPositionVo>)DefaultCbmInvoker.Invoke(new GetDetailPositionCbm(), new DetailPositionVo()); detail_position_cmb.DisplayMember = "DetailPositionCode"; detail_position_cmb.DataSource = detailposition.GetList(); detail_position_cmb.Text = ""; ValueObjectList <AssetVo> assetvoinvoice = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetInvoiceCbm(), new AssetVo()); invoice_cbm.DisplayMember = "AssetInvoice"; invoice_cbm.DataSource = assetvoinvoice.GetList(); invoice_cbm.Text = ""; ValueObjectList <AssetVo> assetvomodel = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetModelCbm(), new AssetVo()); asset_model_cbm.DisplayMember = "AssetModel"; asset_model_cbm.DataSource = assetvomodel.GetList(); asset_model_cbm.Text = ""; ValueObjectList <AssetVo> assetvoname = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetNameCbm(), new AssetVo()); asset_name_cbm.DisplayMember = "AssetName"; asset_name_cbm.DataSource = assetvoname.GetList(); asset_name_cbm.Text = ""; LocationVo Locationvo = (LocationVo)DefaultCbmInvoker.Invoke(new GetLocationMasterMntCbm(), new LocationVo()); location_cbm.DisplayMember = "LocationCode"; location_cbm.DataSource = Locationvo.LocationListVo; location_cbm.Text = ""; }
public WareHouseMainVo WareHouseMainVo = new WareHouseMainVo(); //dv private void AddWareHouseMainForm_Load(object sender, EventArgs e) { //rank ValueObjectList <RankVo> rankname = (ValueObjectList <RankVo>)DefaultCbmInvoker.Invoke(new GetRankCbm(), new RankVo()); cmbRankCode.DisplayMember = "RankCode"; cmbRankCode.DataSource = rankname.GetList(); cmbRankCode.Text = ""; //location LocationVo Locationvo = (LocationVo)DefaultCbmInvoker.Invoke(new GetLocationMasterMntCbm(), new LocationVo()); cmbBeforeLocation.DataSource = Locationvo.LocationListVo; cmbBeforeLocation.DisplayMember = "LocationCode"; cmbBeforeLocation.Text = ""; // account_code ValueObjectList <AccountCodeVo> accountcodevo = (ValueObjectList <AccountCodeVo>)DefaultCbmInvoker.Invoke(new GetAccountCodeCbm(), new AccountCodeVo()); cmbAccountCode.DisplayMember = "AccountCodeCode"; cmbAccountCode.DataSource = accountcodevo.GetList(); cmbAccountCode.Text = ""; //accountlocationcode ValueObjectList <AccountLocationVo> accountlocationcodevo = (ValueObjectList <AccountLocationVo>)DefaultCbmInvoker.Invoke(new GetAccountLocationCbm(), new AccountLocationVo()); cmbSectionCode.DisplayMember = "AccountLocationCode"; cmbSectionCode.DataSource = accountlocationcodevo.GetList(); cmbSectionCode.Text = ""; //cau cua dang ValueObjectList <AssetVo> assetmodelvo = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetCbm(), new AssetVo()); cmbNoNumber.DisplayMember = "AssetNo"; cmbNoNumber.ValueMember = "AssetId"; cmbNoNumber.DataSource = assetmodelvo.GetList(); //end ValueObjectList <UnitVo> unitvo = (ValueObjectList <UnitVo>)DefaultCbmInvoker.Invoke(new GetUnitCbm(), new UnitVo()); cmbUnit.DisplayMember = "UnitCode"; cmbUnit.DataSource = unitvo.GetList(); cmbUnit.Text = ""; { cmbUserName.Enabled = false; cmbAssetModel.Enabled = false; dtpEndDepreciation.Enabled = false; cmbAssetLife.Enabled = false; cmbAcquisitionCost.Enabled = false; txtCurrentDepreciation.Enabled = false; txtMonthlyDepreciation.Enabled = false; txtAccumDepreciation.Enabled = false; txtNetValue.Enabled = false; } if (WareHouseMainVo.WareHouseMainId > 0) { txtAssetCode.Enabled = false; cmbNoNumber.Enabled = false; cmbBeforeLocation.Text = WareHouseMainVo.BeforeLocationCd; cmbAfterLocation.Text = WareHouseMainVo.AfterLocationCd; cmbDetailPosition.Text = WareHouseMainVo.DetailPositionCd; cmbNoNumber.Text = WareHouseMainVo.AssetNo.ToString(); txtAssetCode.Text = WareHouseMainVo.AssetCode; cmbAssetModel.Text = WareHouseMainVo.AssetModel; cmbRankCode.Text = WareHouseMainVo.RankCode; cmbAccountCode.Text = WareHouseMainVo.AccountCodeCode; cmbSectionCode.Text = WareHouseMainVo.AccountLocationCode; txtqty.Text = WareHouseMainVo.QTY.ToString(); cmbUnit.Text = WareHouseMainVo.UnitName; dtpStartDepreciation.Value = WareHouseMainVo.StartDepreciation; dtpEndDepreciation.Value = WareHouseMainVo.EndDepreciation; cmbAssetLife.Text = WareHouseMainVo.AssetLife.ToString(); cmbAcquisitionCost.Text = WareHouseMainVo.AcquisitionCost.ToString(); txtCurrentDepreciation.Text = WareHouseMainVo.CurrentDepreciation.ToString(); txtMonthlyDepreciation.Text = WareHouseMainVo.MonthlyDepreciation.ToString(); txtAccumDepreciation.Text = WareHouseMainVo.AccumDepreciation.ToString(); txtNetValue.Text = WareHouseMainVo.NetValue.ToString(); this.TitleText = Com.Nidec.Mes.GlobalMasterMaintenance.CommonConstants.MODE_UPDATE; } else { txtComment.Text = "Add"; this.TitleText = Com.Nidec.Mes.GlobalMasterMaintenance.CommonConstants.MODE_ADD; } }
public WareHouseMainVo WareHouseMainVo = new WareHouseMainVo(); //dv private void AddWareHouseMainForm_Load(object sender, EventArgs e) { user_location_name_cmb.Enabled = false; asset_model_cmb.Enabled = false; no_cbm.Enabled = false; no_lbl.Enabled = false; //rank ValueObjectList <RankVo> rankname = (ValueObjectList <RankVo>)DefaultCbmInvoker.Invoke(new GetRankCbm(), new RankVo()); rank_code_cmb.DisplayMember = "RankCode"; rank_code_cmb.DataSource = rankname.GetList(); rank_code_cmb.Text = ""; //location LocationVo Locationvo = (LocationVo)DefaultCbmInvoker.Invoke(new GetLocationMasterMntCbm(), new LocationVo()); before_location_cmb.DataSource = Locationvo.LocationListVo; before_location_cmb.DisplayMember = "LocationCode"; before_location_cmb.Text = ""; // account_code ValueObjectList <AccountCodeVo> accountcodevo = (ValueObjectList <AccountCodeVo>)DefaultCbmInvoker.Invoke(new GetAccountCodeCbm(), new AccountCodeVo()); account_code_cmb.DisplayMember = "AccountCodeCode"; account_code_cmb.DataSource = accountcodevo.GetList(); account_code_cmb.Text = ""; //accountlocationcode ValueObjectList <AccountLocationVo> accountlocationcodevo = (ValueObjectList <AccountLocationVo>)DefaultCbmInvoker.Invoke(new GetAccountLocationCbm(), new AccountLocationVo()); section_cd_cmb.DisplayMember = "AccountLocationCode"; section_cd_cmb.DataSource = accountlocationcodevo.GetList(); section_cd_cmb.Text = ""; //cau cua dang ValueObjectList <AssetVo> assetmodelvo = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetCbm(), new AssetVo()); no_cbm.DisplayMember = "AssetNo"; no_cbm.ValueMember = "AssetId"; no_cbm.DataSource = assetmodelvo.GetList(); //end { unit_cmb.Items.Add("m"); unit_cmb.Items.Add("pcs"); unit_cmb.Items.Add("box"); unit_cmb.Items.Add("pallet"); unit_cmb.Items.Add("unit"); unit_cmb.Items.Add("set"); unit_cmb.Text = ""; } { user_location_name_cmb.Enabled = false; asset_model_cmb.Enabled = false; end_depreciation_dtp.Enabled = false; asset_life_cmb.Enabled = false; acquisition_cost_cmb.Enabled = false; current_depreciation_txt.Enabled = false; monthl_depreciation_txt.Enabled = false; accum_depreciation_txt.Enabled = false; net_value_txt.Enabled = false; start_depreciation_dtp.Enabled = false; } if (WareHouseMainVo.WareHouseMainId > 0) { asset_code_txt.Enabled = false; before_location_cmb.Text = WareHouseMainVo.BeforeLocationCd; after_location_cmb.Text = WareHouseMainVo.AfterLocationCd; detail_position_cmb.Text = WareHouseMainVo.DetailPositionCd; no_cbm.Text = WareHouseMainVo.AssetNo.ToString(); asset_code_txt.Text = WareHouseMainVo.AssetCode; asset_model_cmb.Text = WareHouseMainVo.AssetModel; rank_code_cmb.Text = WareHouseMainVo.RankCode; account_code_cmb.Text = WareHouseMainVo.AccountCodeCode; section_cd_cmb.Text = WareHouseMainVo.AccountLocationCode; qty_txt.Text = WareHouseMainVo.QTY.ToString(); unit_cmb.Text = WareHouseMainVo.Unit; start_depreciation_dtp.Value = WareHouseMainVo.StartDepreciation; end_depreciation_dtp.Value = WareHouseMainVo.EndDepreciation; asset_life_cmb.Text = WareHouseMainVo.AssetLife.ToString(); acquisition_cost_cmb.Text = WareHouseMainVo.AcquisitionCost.ToString(); current_depreciation_txt.Text = WareHouseMainVo.CurrentDepreciation.ToString(); monthl_depreciation_txt.Text = WareHouseMainVo.MonthlyDepreciation.ToString(); accum_depreciation_txt.Text = WareHouseMainVo.AccumDepreciation.ToString(); net_value_txt.Text = WareHouseMainVo.NetValue.ToString(); // unit_cmb.SelectedItem = null; //int assetid = 0; this.TitleText = Com.Nidec.Mes.GlobalMasterMaintenance.CommonConstants.MODE_UPDATE; } else { comments_txt.Text = "Add"; this.TitleText = Com.Nidec.Mes.GlobalMasterMaintenance.CommonConstants.MODE_ADD; } }