public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { WareHouseMainVo inVo = (WareHouseMainVo)vo; StringBuilder sql = new StringBuilder(); sql.Append(@"update t_warehouse_main set current_depreciation =:current_depreciation, monthly_depreciation=:monthly_depreciation, accum_depreciation_now =:accum_depreciation_now, net_value =:net_value "); sql.Append(" where warehouse_main_id =:warehouse_main_id"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameter("warehouse_main_id", inVo.WareHouseMainId); sqlParameter.AddParameter("current_depreciation", inVo.CurrentDepreciation); sqlParameter.AddParameter("monthly_depreciation", inVo.MonthlyDepreciation); sqlParameter.AddParameter("accum_depreciation_now", inVo.AccumDepreciation); sqlParameter.AddParameter("net_value", inVo.NetValue); //execute SQL WareHouseMainVo outVo = new WareHouseMainVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
private void ok_btn_Click(object sender, EventArgs e) { if (Checkdata()) { WareHouseMainVo outVo = new WareHouseMainVo(); WareHouseMainVo inVo = new WareHouseMainVo() { WareHouseMainId = WareHouseMainVo.WareHouseMainId, /// BeforeLocationId = ((LocationVo)this.before_location_cmb.SelectedItem).LocationId, DetailPositionId = ((DetailPositionVo)this.detail_position_cmb.SelectedItem).DetailPositionId, AfterLocationId = ((LocationVo)this.after_location_cmb.SelectedItem).LocationId, AssetId = ((AssetVo)this.no_cbm.SelectedItem).AssetId, QTY = Int16.Parse(qty_txt.Text), Unit = unit_cmb.Text, AssetNo = Int16.Parse(no_cbm.Text), AccountCodeId = ((AccountCodeVo)this.account_code_cmb.SelectedItem).AccountCodeId, AccountLocationId = ((AccountLocationVo)this.section_cd_cmb.SelectedItem).AccountLocationId, RankId = ((RankVo)this.rank_code_cmb.SelectedItem).RankId, CommnetsData = comments_txt.Text, StartDepreciation = start_depreciation_dtp.Value, EndDepreciation = end_depreciation_dtp.Value, CurrentDepreciation = double.Parse(current_depreciation_txt.Text), MonthlyDepreciation = double.Parse(monthl_depreciation_txt.Text), AccumDepreciation = double.Parse(accum_depreciation_txt.Text), NetValue = double.Parse(net_value_txt.Text), // LocationId = ((LocationVo)this.location_cmb.SelectedItem).LocationId, UserLocationId = ((UserLocationVo)this.user_location_name_cmb.SelectedItem).UserLocationId, RegistrationDateTime = DateTime.Now, FactoryCode = UserData.GetUserData().FactoryCode, RegistrationUserCode = UserData.GetUserData().UserCode }; try { if (inVo.WareHouseMainId > 0) { outVo = (WareHouseMainVo)DefaultCbmInvoker.Invoke(new Cbm.AddWareHouseMainCbm(), inVo); // outVo = (WareHouseVo)DefaultCbmInvoker.Invoke(new Cbm.AddWareHouseCbm(), inVo); } else { outVo = (WareHouseMainVo)DefaultCbmInvoker.Invoke(new Cbm.AddWareHouseMainCbm(), inVo); } } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } if (outVo.AffectedCount > 0) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, asset_code_lbl.Text + " : " + asset_code_txt.Text); logger.Info(messageData); popUpMessage.Information(messageData, Text); return; } } }
private void GridBind() { try { WareHouseMainVo whvos = new WareHouseMainVo() { AssetCode = asset_Code_txt.Text, RankCode = rank_code_cbm.Text, AssetType = asset_type_cbm.Text, AccountCodeCode = detail_position_cmb.Text, AccountLocationCode = select_search_cbm.Text, AssetInvoice = invoice_cbm.Text, AssetModel = asset_model_cbm.Text, AfterLocationCd = location_cbm.Text, AssetName = asset_name_cbm.Text, DetailPositionCd = detail_position_cmb.Text, LabelStatus = labelstatus_cmb.Text, Net_Value = net_value_cmb.Text, AssetPO = AssetPO_cmb.Text, NowLocation = inventoryLocation_cbm.Text, }; if (checkdata()) { if (select_search_cbm.Text == "Search History") { ValueObjectList <WareHouseMainVo> listvo = (ValueObjectList <WareHouseMainVo>)DefaultCbmInvoker.Invoke(new SearchWareHouseMainCbm(), whvos); warehouse_main_dgv.DataSource = listvo.GetList(); } else if (select_search_cbm.Text == "Search List") { ValueObjectList <WareHouseMainVo> listvo = (ValueObjectList <WareHouseMainVo>)DefaultCbmInvoker.Invoke(new SearchListWareHouseMainCbm(), whvos); warehouse_main_dgv.DataSource = listvo.GetList(); foreach (DataGridViewRow dr in warehouse_main_dgv.Rows) { string after = (string)dr.Cells["colafterlocation"].Value; string nowloc = (string)dr.Cells["colnowlocation"].Value; if (after != nowloc) { dr.DefaultCellStyle.ForeColor = Color.Blue; } } invertory_alarm(); counter(); } // calculator(); } } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } }
private void update_btn_Click(object sender, EventArgs e) { if (warehouse_main_dgv.SelectedCells.Count > 0) { WareHouseMainVo selectedvo = (WareHouseMainVo)warehouse_main_dgv.CurrentRow.DataBoundItem; if (new AddWareHouseMainForm { WareHouseMainVo = selectedvo, }.ShowDialog() == DialogResult.OK) { GridBind(); } } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { WareHouseMainVo inVo = (WareHouseMainVo)vo; StringBuilder sql = new StringBuilder(); sql.Append(@"insert into t_warehouse_main_history(asset_id, qty, unit_id, account_code_id, account_location_id, rank_id, comment_data, depreciation_start, depreciation_end, current_depreciation, monthly_depreciation, accum_depreciation_now, net_value, user_location_id, before_location_id, after_location_id, detail_position_id, registration_user_cd, registration_date_time, factory_cd)"); sql.Append(@"values(:asset_id, :qty,:unit_id, :account_code_id, :account_location_id, :rank_id, :comment_data, :depreciation_start, :depreciation_end, :current_depreciation, :monthly_depreciation, :accum_depreciation_now, :net_value, :user_location_id, :before_location_id, :after_location_id,:detail_position_id, :registration_user_cd,:registration_date_time, :factory_cd)"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameter("asset_id", inVo.AssetId); sqlParameter.AddParameter("qty", inVo.QTY); sqlParameter.AddParameter("unit_id", inVo.UnitId); sqlParameter.AddParameter("account_code_id", inVo.AccountCodeId); sqlParameter.AddParameter("account_location_id", inVo.AccountLocationId); sqlParameter.AddParameter("rank_id", inVo.RankId); sqlParameter.AddParameter("comment_data", inVo.CommnetsData); sqlParameter.AddParameter("depreciation_start", inVo.StartDepreciation); sqlParameter.AddParameter("depreciation_end", inVo.EndDepreciation); sqlParameter.AddParameter("current_depreciation", inVo.CurrentDepreciation); sqlParameter.AddParameter("monthly_depreciation", inVo.MonthlyDepreciation); sqlParameter.AddParameter("accum_depreciation_now", inVo.AccumDepreciation); sqlParameter.AddParameter("net_value", inVo.NetValue); // sqlParameter.AddParameter("location_id", inVo.LocationId); sqlParameter.AddParameter("before_location_id", inVo.BeforeLocationId); sqlParameter.AddParameter("after_location_id", inVo.AfterLocationId); sqlParameter.AddParameter("user_location_id", inVo.UserLocationId); sqlParameter.AddParameter("detail_position_id", inVo.DetailPositionId); sqlParameter.AddParameter("registration_user_cd", inVo.RegistrationUserCode); sqlParameter.AddParameter("registration_date_time", inVo.RegistrationDateTime); sqlParameter.AddParameter("factory_cd", inVo.FactoryCode); //execute SQL WareHouseMainVo outVo = new WareHouseMainVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { WareHouseMainVo inVo = (WareHouseMainVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <WareHouseMainVo> voList = new ValueObjectList <WareHouseMainVo>(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"select tam.account_code_name as Account_Name,sum(tam.acquistion_cost) as Total_AcquisitionCose,sum(tam.current_depreciation) as Total_CurrentDepreication,sum(tam.monthly_depreciation) as Total_MonthlyDepreication,sum(tam.accum_depreciation_now) as Total_AccumDepreication,sum(tam.net_value) as Total_NetBook from (select g.unit,a.account_code_name, g.warehouse_main_id,j.location_cd, e.asset_cd, e.asset_no, e.asset_name, e.asset_model, e.asset_serial, e.asset_supplier, g.qty, a.account_code_cd, b.account_location_cd, f.rank_cd, b.account_location_name, g.comment_data, e.asset_life, e.acquistion_date, e.acquistion_cost, g.depreciation_start, g.depreciation_end, g.current_depreciation,g.monthly_depreciation, g.accum_depreciation_now, g.net_value, e.asset_invoice, g.registration_date_time, g.registration_user_cd from t_warehouse_main g left join m_account_code a on a.account_code_id = g.account_code_id left join m_account_location b on b.account_location_id = g.account_location_id left join m_location c on c.location_id = g.before_location_id left join m_location j on c.location_id = g.after_location_id left join m_user_location d on d.user_location_id = g.user_location_id left join m_asset e on e.asset_id = g.asset_id left join m_rank f on f.rank_id = g.rank_id) tam group by tam.account_code_name "); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { WareHouseMainVo outVo = new WareHouseMainVo { // , h., i., k., o.prodution_work_content_name TotalAccumDepreication = double.Parse(dataReader["Total_AccumDepreication"].ToString()), TotalAcquisitionCose = double.Parse(dataReader["Total_AcquisitionCose"].ToString()), TotalCurrentDepreication = double.Parse(dataReader["Total_CurrentDepreication"].ToString()), TotalMonthlyDepreication = double.Parse(dataReader["Total_MonthlyDepreication"].ToString()), TotalNetBook = double.Parse(dataReader["Total_NetBook"].ToString()), AccountCodeName = dataReader["Account_Name"].ToString(), }; voList.add(outVo); } dataReader.Close(); return(voList); }
private void GridBind() { try { WareHouseMainVo whvos = new WareHouseMainVo() { AssetCode = asset_Code_txt.Text, RankCode = rank_code_cbm.Text, AssetType = asset_type_cbm.Text, AccountCodeCode = detail_position_cmb.Text, AccountLocationCode = select_search_cbm.Text, AssetInvoice = invoice_cbm.Text, AssetModel = asset_model_cbm.Text, AfterLocationCd = location_cbm.Text, AssetName = asset_name_cbm.Text, DetailPositionCd = detail_position_cmb.Text, LabelStatus = labelstatus_cmb.Text, Net_Value = net_value_cmb.Text, AssetPO = AssetPO_cmb.Text, }; if (checkdata()) { if (select_search_cbm.Text == "Search History") { ValueObjectList <WareHouseMainVo> listvo = (ValueObjectList <WareHouseMainVo>)DefaultCbmInvoker.Invoke(new SearchWareHouseMainCbm(), whvos); warehouse_main_dgv.DataSource = listvo.GetList(); } else if (select_search_cbm.Text == "Search List") { ValueObjectList <WareHouseMainVo> listvo = (ValueObjectList <WareHouseMainVo>)DefaultCbmInvoker.Invoke(new SearchListWareHouseMainCbm(), whvos); warehouse_main_dgv.DataSource = listvo.GetList(); invertory_alarm(); counter(); } // calculator(); } } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } }
void updatedatatodatabase() { if (warehouse_main_dgv.RowCount > 0) { WareHouseMainVo outVo = new WareHouseMainVo(); for (int i = 0; i < warehouse_main_dgv.RowCount; i++) { WareHouseMainVo inVo = new WareHouseMainVo() { WareHouseMainId = int.Parse(warehouse_main_dgv.Rows[i].Cells["colAcountMainId"].Value.ToString()), CurrentDepreciation = double.Parse(warehouse_main_dgv.Rows[i].Cells["colCurrentDepreciation"].Value.ToString()), MonthlyDepreciation = double.Parse(warehouse_main_dgv.Rows[i].Cells["colMonthlyDepreciation"].Value.ToString()), AccumDepreciation = double.Parse(warehouse_main_dgv.Rows[i].Cells["colAccumDepreciation"].Value.ToString()), NetValue = double.Parse(warehouse_main_dgv.Rows[i].Cells["colNetValue"].Value.ToString()), }; outVo = (WareHouseMainVo)DefaultCbmInvoker.Invoke(new UpdateWareHouseMainDGVCbm(), inVo); //update code } } }
private void Rank_Dep_btn_Click(object sender, EventArgs e) { account_depreciation_dgv.Visible = true; warehouse_main_dgv.Visible = false; account_depreciation_dgv.DataSource = null; account_depreciation_dgv.Columns[0].HeaderText = "Rank Name"; try { WareHouseMainVo whvos = new WareHouseMainVo() { }; ValueObjectList <WareHouseMainVo> listvo = (ValueObjectList <WareHouseMainVo>)DefaultCbmInvoker.Invoke(new Cbm.TotalRankDEPWareHouseMainCbm(), whvos); account_depreciation_dgv.DataSource = listvo.GetList(); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } }
private void user_location_code_txt_TextChanged(object sender, EventArgs e) { if ((user_location_code_txt.Text.Length == 13) || (user_location_code_txt.Text.Length == 10)) { WareHouseMainVo inVo = new WareHouseMainVo() { UserTem = user_location_code_txt.Text }; ValueObjectList <UserLocationVo> userlocationvo = (ValueObjectList <UserLocationVo>)DefaultCbmInvoker.Invoke(new GetUserLocationCbm(), new UserLocationVo { UserLocationCode = inVo.UserTem }); user_location_name_cmb.DisplayMember = "UserLocationName"; user_location_name_cmb.DataSource = userlocationvo.GetList(); } else { user_location_name_cmb.Text = ""; user_location_name_cmb.SelectedItem = null; } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { WareHouseMainVo inVo = ( WareHouseMainVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <WareHouseMainVo> voList = new ValueObjectList <WareHouseMainVo>(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"select g.warehouse_main_id from t_warehouse_main g left join m_asset e on e.asset_id = g.asset_id where 1=1 "); if (!String.IsNullOrEmpty(inVo.AssetCode)) { sql.Append(@" and e.asset_cd =:asset_cd"); sqlParameter.AddParameterString("asset_cd", inVo.AssetCode); } sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { WareHouseMainVo outVo = new WareHouseMainVo { WareHouseMainId = int.Parse(dataReader["warehouse_main_id"].ToString()), }; voList.add(outVo); } dataReader.Close(); return(voList); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { WareHouseMainVo inVo = (WareHouseMainVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <WareHouseMainVo> voList = new ValueObjectList <WareHouseMainVo>(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"select k.unit_name,c.location_cd as before, j.location_cd as after, h.detail_postion_cd, d.user_location_name ,g.warehouse_main_history_id,c.location_cd,e.asset_cd, e.asset_no, e.asset_name, e.asset_model, e.asset_serial, e.asset_supplier,e.asset_po, e.asset_invoice,e.label_status, g.qty, a.account_code_cd, b.account_location_cd, f.rank_cd, b.account_location_name, g.comment_data, e.asset_life, e.acquistion_date, e.acquistion_cost, e.asset_type, g.depreciation_start, g.depreciation_end, g.current_depreciation,g.monthly_depreciation, g.accum_depreciation_now, g.net_value, g.registration_date_time, g.registration_user_cd from t_warehouse_main_history g left join m_account_code a on a.account_code_id = g.account_code_id left join m_account_location b on b.account_location_id = g.account_location_id left join m_location c on c.location_id = g.before_location_id left join m_location j on j.location_id = g.after_location_id left join m_user_location d on d.user_location_id = g.user_location_id left join m_asset e on e.asset_id = g.asset_id left join m_rank f on f.rank_id = g.rank_id left join m_detail_postion h on h.detail_postion_id = g.detail_position_id left join m_unit k on k.unit_id = g.unit_id where 1=1 "); if (!String.IsNullOrEmpty(inVo.AssetCode)) { sql.Append(@" and e.asset_cd =:asset_cd"); sqlParameter.AddParameterString("asset_cd", inVo.AssetCode); } if (!String.IsNullOrEmpty(inVo.RankCode)) { sql.Append(" and f.rank_cd =:rank_cd"); sqlParameter.AddParameterString("rank_cd", inVo.RankCode); } if (!String.IsNullOrEmpty(inVo.AssetModel)) { sql.Append(" and e.asset_model =:asset_model"); sqlParameter.AddParameterString("asset_model", inVo.AssetModel); } if (!String.IsNullOrEmpty(inVo.AssetName)) { sql.Append(" and e.asset_name =:asset_name"); sqlParameter.AddParameterString("asset_name", inVo.AssetName); } if (!String.IsNullOrEmpty(inVo.AssetType)) { sql.Append(" and e.asset_type =:asset_type"); sqlParameter.AddParameterString("asset_type", inVo.AssetType); } if (!String.IsNullOrEmpty(inVo.AssetInvoice)) { sql.Append(" and e.asset_invoice =:asset_invoice"); sqlParameter.AddParameterString("asset_invoice", inVo.AssetInvoice); } if (!String.IsNullOrEmpty(inVo.AfterLocationCd)) { sql.Append(" and j.location_cd =:location_cd"); sqlParameter.AddParameterString("location_cd", inVo.AfterLocationCd); } if (!String.IsNullOrEmpty(inVo.DetailPositionCd)) { sql.Append(" and h.detail_postion_cd =:detail_postion_cd"); sqlParameter.AddParameterString("detail_postion_cd", inVo.DetailPositionCd); } if (!String.IsNullOrEmpty(inVo.LabelStatus))//label status { sql.Append(" and e.label_status =:label_status"); sqlParameter.AddParameterString("label_status", inVo.LabelStatus); } if (!String.IsNullOrEmpty(inVo.AssetPO))//label status { sql.Append(" and e.asset_po =:asset_po"); sqlParameter.AddParameterString("asset_po", inVo.AssetPO); } //if (!String.IsNullOrEmpty(inVo.Net_Value))//search theo net value //{ // if (inVo.Net_Value == "0$") // { // sql.Append(" and g.net_value = 0"); // } // else if (inVo.Net_Value == "1$") // { // sql.Append(" and g.net_value > 0 and g.net_value <2 "); // } //} sql.Append(" order by g.registration_date_time desc"); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { WareHouseMainVo outVo = new WareHouseMainVo { // , h., i., k., o.prodution_work_content_name WareHouseMainId = int.Parse(dataReader["warehouse_main_history_id"].ToString()), AfterLocationCd = dataReader["after"].ToString(), BeforeLocationCd = dataReader["before"].ToString(), DetailPositionCd = dataReader["detail_postion_cd"].ToString(), AssetCode = dataReader["asset_cd"].ToString(), AssetNo = int.Parse(dataReader["asset_no"].ToString()), AssetName = dataReader["asset_name"].ToString(), AssetModel = dataReader["asset_model"].ToString(), AssetSerial = dataReader["asset_serial"].ToString(), AssetSupplier = dataReader["asset_supplier"].ToString(), QTY = int.Parse(dataReader["qty"].ToString()), UnitName = dataReader["unit_name"].ToString(), UserLocationName = dataReader["user_location_name"].ToString(), AccountCodeCode = dataReader["account_code_cd"].ToString(), AccountLocationCode = dataReader["account_location_cd"].ToString(), RankCode = dataReader["rank_cd"].ToString(), AccountLocationName = dataReader["account_location_name"].ToString(), CommnetsData = dataReader["comment_data"].ToString(), AssetLife = int.Parse(dataReader["asset_life"].ToString()), AcquisitionDate = DateTime.Parse(dataReader["acquistion_date"].ToString()), AcquisitionCost = double.Parse(dataReader["acquistion_cost"].ToString()), StartDepreciation = DateTime.Parse(dataReader["depreciation_start"].ToString()), EndDepreciation = DateTime.Parse(dataReader["depreciation_end"].ToString()), CurrentDepreciation = double.Parse(dataReader["current_depreciation"].ToString()), MonthlyDepreciation = double.Parse(dataReader["monthly_depreciation"].ToString()), AccumDepreciation = double.Parse(dataReader["accum_depreciation_now"].ToString()), NetValue = double.Parse(dataReader["net_value"].ToString()), AssetType = dataReader["asset_type"].ToString(), AssetInvoice = (dataReader["asset_invoice"].ToString()), LabelStatus = (dataReader["label_status"].ToString()), AssetPO = dataReader["asset_po"].ToString(), RegistrationDateTime = DateTime.Parse(dataReader["registration_date_time"].ToString()), RegistrationUserCode = (dataReader["registration_user_cd"].ToString()), }; voList.add(outVo); } dataReader.Close(); return(voList); }
private void ok_btn_Click(object sender, EventArgs e) { if (Checkdata()) { InvertoryVo CheckTimeIdVo = (InvertoryVo)DefaultCbmInvoker.Invoke(new GetMaxCheckTimeIdCbm(), new InvertoryVo()); WareHouseMainVo outVo1 = new WareHouseMainVo(); WareHouseMainVo outVo2 = new WareHouseMainVo(); WareHouseMainVo inVo = new WareHouseMainVo() { WareHouseMainId = WareHouseMainVo.WareHouseMainId, /// BeforeLocationId = ((LocationVo)this.cmbBeforeLocation.SelectedItem).LocationId, DetailPositionId = ((DetailPositionVo)this.cmbDetailPosition.SelectedItem).DetailPositionId, AfterLocationId = ((LocationVo)this.cmbAfterLocation.SelectedItem).LocationId, AssetId = ((AssetVo)this.cmbNoNumber.SelectedItem).AssetId, QTY = Int16.Parse(txtqty.Text), UnitId = ((UnitVo)cmbUnit.SelectedItem).UnitId, AssetNo = Int16.Parse(cmbNoNumber.Text), AccountCodeId = ((AccountCodeVo)this.cmbAccountCode.SelectedItem).AccountCodeId, AccountLocationId = ((AccountLocationVo)this.cmbSectionCode.SelectedItem).AccountLocationId, RankId = ((RankVo)this.cmbRankCode.SelectedItem).RankId, CommnetsData = txtComment.Text, StartDepreciation = dtpStartDepreciation.Value, EndDepreciation = dtpEndDepreciation.Value, CurrentDepreciation = double.Parse(txtCurrentDepreciation.Text), MonthlyDepreciation = double.Parse(txtMonthlyDepreciation.Text), AccumDepreciation = double.Parse(txtAccumDepreciation.Text), NetValue = double.Parse(txtNetValue.Text), // LocationId = ((LocationVo)this.location_cmb.SelectedItem).LocationId, UserLocationId = ((UserLocationVo)this.cmbUserName.SelectedItem).UserLocationId, RegistrationDateTime = DateTime.Now, FactoryCode = UserData.GetUserData().FactoryCode, RegistrationUserCode = UserData.GetUserData().UserCode, InvertoryId = CheckTimeIdVo.InvertoryTimeId, }; try { if (inVo.WareHouseMainId > 0) //update { outVo1 = (WareHouseMainVo)DefaultCbmInvoker.Invoke(new UpdateWareHouseMainCbm(), inVo); //sai outVo2 = (WareHouseMainVo)DefaultCbmInvoker.Invoke(new AddWareHouseHistoryMainCbm(), inVo); } else//add { outVo1 = (WareHouseMainVo)DefaultCbmInvoker.Invoke(new AddWareHouseMainCbm(), inVo); outVo2 = (WareHouseMainVo)DefaultCbmInvoker.Invoke(new AddWareHouseHistoryMainCbm(), inVo); if (outVo1.AffectedCount > 0) { ValueObjectList <WareHouseMainVo> outVoWareHouse = (ValueObjectList <WareHouseMainVo>)DefaultCbmInvoker.Invoke(new GetWarehouseMainIdCbm(), new WareHouseMainVo() { AssetCode = txtAssetCode.Text }); InvertoryVo outVoCheckTime = new InvertoryVo(); InvertoryVo inVoCheckTime = new InvertoryVo() { WarehouseMainId = outVoWareHouse.GetList()[0].WareHouseMainId, InvertoryTimeId = CheckTimeIdVo.InvertoryTimeId, InvertoryValue = true, RegistrationUserCode = UserData.GetUserData().UserName, FactoryCode = UserData.GetUserData().FactoryCode, LocationID = ((LocationVo)this.cmbAfterLocation.SelectedItem).LocationId, }; outVoCheckTime = (InvertoryVo)DefaultCbmInvoker.Invoke(new AddInvertoryCheckCbm(), inVoCheckTime); } cmbUnit.Text = ""; txtAssetCode.Text = ""; } AccountMainVo accountOutVo = new AccountMainVo(); accountOutVo = (AccountMainVo)DefaultCbmInvoker.Invoke(new UpdateItemAccountMainCbm(), new AccountMainVo() { AssetId = inVo.AssetId, LocationId = inVo.AfterLocationId, RankId = inVo.RankId, UserLocationId = inVo.UserLocationId, RegistrationUserCode = inVo.RegistrationUserCode, RegistrationDateTime = DateTime.Now, }); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } if (outVo1.AffectedCount > 0) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, asset_code_lbl.Text + " : " + txtAssetCode.Text); logger.Info(messageData); popUpMessage.Information(messageData, Text); return; } if (outVo2.AffectedCount > 0) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, asset_code_lbl.Text + " : " + txtAssetCode.Text); logger.Info(messageData); popUpMessage.Information(messageData, Text); return; } } }
void addandupdate() { InvertoryVo checkvo = new InvertoryVo(); asset_Code_cmb.Select(); InvertoryCheck_dgv.DataSource = null; string str = asset_Code_cmb.Text; string[] arrListStr = str.Split(','); assetcodetrim = arrListStr[0]; //sua lai, doi warehouse va accout id thanh asset_id //sua database t_invertory_equipments doi warehouse id thanh asset_id ValueObjectList <WareHouseMainVo> Wlistvo = (ValueObjectList <WareHouseMainVo>)DefaultCbmInvoker.Invoke(new Cbm.GetWarehouseMainIdCbm(), new WareHouseMainVo() { AssetCode = assetcodetrim, }); List <WareHouseMainVo> Wlist = Wlistvo.GetList(); ValueObjectList <AccountMainVo> alistvo = (ValueObjectList <AccountMainVo>)DefaultCbmInvoker.Invoke(new Cbm.GetAccountMainIdCbm(), new AccountMainVo() { AssetCode = assetcodetrim, }); List <AccountMainVo> alist = alistvo.GetList(); if (checkdata()) { for (int i = 0; i < Wlist.Count; i++) { WareHouseMainVo w = Wlist[i]; AccountMainVo a = alist[i]; InvertoryVo outVo = new InvertoryVo(); InvertoryVo inVo = new InvertoryVo() { WarehouseMainId = w.WareHouseMainId, AccountMainId = a.AcountMainId, InvertoryTimeId = ((InvertoryVo)this.InvertoryTimeCode_cbm.SelectedItem).InvertoryTimeId, InvertoryValue = true, RegistrationUserCode = UserData.GetUserData().UserName, FactoryCode = UserData.GetUserData().FactoryCode, LocationID = ((LocationVo)this.location_cbm.SelectedItem).LocationId, // RankID = ((RankVo)this.rank_name_cbm.SelectedItem).RankId, }; try { checkvo = (InvertoryVo)DefaultCbmInvoker.Invoke(new CheckInvertoryRowCbm(), inVo); if (checkvo.AffectedCount == 1) { mess += assetcodetrim + " is checked into " + InvertoryTimeCode_cbm.Text + "\n"; //if(i == Wlist.Count -1) //{ // MessageBox.Show(mess, "Info", MessageBoxButtons.OK, MessageBoxIcon.Information); //} //MessageBox.Show("This machine:" + assetcodetrim + " is checked into " + InvertoryTimeCode_cbm.Text, "Messager", MessageBoxButtons.OK, MessageBoxIcon.Information); thongbao++; } if (checkvo.AffectedCount == 0) { outVo = (InvertoryVo)DefaultCbmInvoker.Invoke(new AddInvertoryCheckCbm(), inVo); outVo = (InvertoryVo)DefaultCbmInvoker.Invoke(new UpdateWHInvertoryCheckCbm(), inVo); outVo = (InvertoryVo)DefaultCbmInvoker.Invoke(new UpdateACCInvertoryCheckCbm(), inVo); // outVo = (InvertoryVo)DefaultCbmInvoker.Invoke(new UpdateACCRankCheckCbm(), inVo); } } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } } if (test == "b") { colRankNameNowTextBox.Visible = false; colRankNameNow.Visible = true; ValueObjectList <RankVo> rankcode = (ValueObjectList <RankVo>)DefaultCbmInvoker.Invoke(new GetRankCbm(), new RankVo()); colRankNameNow.DisplayMember = "RankName"; colRankNameNow.DataSource = rankcode.GetList(); } else { assetcodetrim = ""; } } }