private void btnApply_Click(object sender, EventArgs e) { try { AssetInfoVo outAsset = (AssetInfoVo)DefaultCbmInvoker.Invoke(new GetAssetInfoCbm(), new AssetInfoVo { asset_cd = txtAssetCode.Text, asset_no = int.Parse(txtAssetNo.Text) }); AccountInfoVo outVo = new AccountInfoVo { account_main_id = accountVo.account_main_id, asset_id = outAsset.asset_id, qty = int.Parse(txtQty.Text), unit_id = int.Parse(cmbUnit.ValueMember), account_code_id = int.Parse(cmbAccountCode.ValueMember), account_location_id = int.Parse(cmbSection.ValueMember), rank_id = int.Parse(cmbRank.ValueMember), comment_data = txtComment.Text, depreciation_start = dtpDeprStart.Value, depreciation_end = dtpDeprEnd.Value, location_id = int.Parse(cmbLocation.ValueMember), user_location_id = user_location_id, }; outVo = (AccountInfoVo)DefaultCbmInvoker.Invoke(new UpdateAccountInfoCbm(), outVo); MessageBox.Show("Update finish!!!", "Notice", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.Message, "WARRING", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { AccountInfoVo inVo = (AccountInfoVo)vo; StringBuilder sql = new StringBuilder(); //CREATE SQL ADAPTER AND PARAMETER LIST DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("UPDATE t_account_main SET asset_id='").Append(inVo.asset_id).Append("', "); sql.Append("qty='").Append(inVo.qty).Append("', unit_id='").Append(inVo.unit_id).Append("', "); sql.Append("account_code_id='").Append(inVo.account_code_id).Append("', "); sql.Append("account_location_id='").Append(inVo.account_location_id).Append("', "); sql.Append("rank_id='").Append(inVo.rank_id).Append("', comment_data='").Append(inVo.comment_data).Append("', "); sql.Append("depreciation_start='").Append(inVo.depreciation_start).Append("', "); sql.Append("depreciation_end='").Append(inVo.depreciation_end).Append("', "); sql.Append("current_depreciation='").Append(inVo.current_depreciation).Append("', "); sql.Append("monthly_depreciation='").Append(inVo.monthly_depreciation).Append("', "); sql.Append("accum_depreciation_now='").Append(inVo.accum_depreciation).Append(", "); sql.Append("net_value='").Append(inVo.net_value).Append(", "); sql.Append("location_id='").Append(inVo.location_id).Append(", "); sql.Append("user_location_id='").Append(inVo.user_location_id).Append(", "); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); sql.Clear(); //EXECUTE READER FROM COMMAND inVo.update = sqlCommandAdapter.ExecuteNonQuery(sqlParameter); return(inVo); }
public UpdateAccountInfoForm(int account_id) { InitializeComponent(); //pnlAddAccount.Visible = false; //this.Width -= pnlAddAccount.Width; accountVo.account_main_id = account_id; accountVo = (AccountInfoVo)DefaultCbmInvoker.Invoke(new GetAccountInfoCbm(), accountVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { AccountInfoVo inVo = (AccountInfoVo)vo; StringBuilder sql = new StringBuilder(); //CREATE SQL ADAPTER AND PARAMETER LIST DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("Select * from t_account_main where 1=1 "); sql.Append("and account_main_id ='").Append(inVo.account_main_id).Append("' "); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); sql.Clear(); //EXECUTE READER FROM COMMAND IDataReader datareader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (datareader.Read()) { inVo.asset_id = (int)datareader["asset_id"]; inVo.qty = (int)datareader["qty"]; inVo.unit_id = (int)datareader["unit_id"]; inVo.account_code_id = (int)datareader["account_code_id"]; inVo.account_location_id = (int)datareader["account_location_id"]; inVo.rank_id = (int)datareader["rank_id"]; inVo.comment_data = datareader["comment_data"].ToString(); inVo.depreciation_start = (DateTime)datareader["depreciation_start"]; inVo.depreciation_end = (DateTime)datareader["depreciation_end"]; inVo.current_depreciation = (double)datareader["current_depreciation"]; inVo.monthly_depreciation = (double)datareader["monthly_depreciation"]; inVo.accum_depreciation = (double)datareader["accum_depreciation_now"]; inVo.net_value = (double)datareader["net_value"]; inVo.location_id = (int)datareader["location_id"]; inVo.user_location_id = (int)datareader["user_location_id"]; inVo.registration_user_cd = datareader["registration_user_cd"].ToString(); inVo.registration_date_time = (DateTime)datareader["registration_date_time"]; inVo.factory_cd = datareader["factory_cd"].ToString(); inVo.invertory_time_id = (int)datareader["invertory_time_id"]; } datareader.Close(); return(inVo); }