public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { AccountManagerFAWHVo inVo = (AccountManagerFAWHVo)vo; DataTable dt = new DataTable(); StringBuilder sql = new StringBuilder(); //CREATE SQL ADAPTER AND PARAMETER LIST DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("select b.account_code_name, "); sql.Append("SUM(c.acquistion_cost) as acquistion_cost, "); sql.Append("SUM(a.monthly_depreciation) as monthly_depreciation,"); sql.Append("SUM(a.current_depreciation) as current_depreciation, "); sql.Append("SUM(a.accum_depreciation_now) as accum_depreciation_now, "); sql.Append("SUM(a.net_value) as net_value "); sql.Append("from t_account_main a "); sql.Append("left join m_account_code b on a.account_code_id = b.account_code_id "); sql.Append("left join m_asset c on a.asset_id = c.asset_id "); sql.Append("group by b.account_code_name"); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); sql.Clear(); //EXECUTE READER FROM COMMAND IDataReader datareader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); dt.Load(datareader); datareader.Close(); AccountManagerFAWHVo outVo = new AccountManagerFAWHVo() { table = dt }; return(outVo); }
private void UpdateDeprGrid(AccountManagerFAWHVo inVo) { if (inVo.table.Rows.Count > 0) { dgvDeprCalc.DataSource = inVo.table; dgvDeprCalc.Columns["acquistion_cost"].DefaultCellStyle.Format = "N3"; dgvDeprCalc.Columns["monthly_depreciation"].DefaultCellStyle.Format = "N3"; dgvDeprCalc.Columns["current_depreciation"].DefaultCellStyle.Format = "N3"; dgvDeprCalc.Columns["accum_depreciation_now"].DefaultCellStyle.Format = "N3"; dgvDeprCalc.Columns["net_value"].DefaultCellStyle.Format = "N3"; dgvDeprCalc.Columns["acquistion_cost"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dgvDeprCalc.Columns["monthly_depreciation"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dgvDeprCalc.Columns["current_depreciation"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dgvDeprCalc.Columns["accum_depreciation_now"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dgvDeprCalc.Columns["net_value"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dgvDeprCalc.Columns["acquistion_cost"].HeaderText = "Acquisition Cost ($)"; dgvDeprCalc.Columns["monthly_depreciation"].HeaderText = "Monthly Depreception ($)"; dgvDeprCalc.Columns["current_depreciation"].HeaderText = "Current Depreception ($)"; dgvDeprCalc.Columns["accum_depreciation_now"].HeaderText = "Accum Depreception ($)"; dgvDeprCalc.Columns["net_value"].HeaderText = "Netbooks ($)"; try { dgvDeprCalc.Columns["account_code_name"].HeaderText = "Account Code Name"; } catch { dgvDeprCalc.Columns["rank_name"].HeaderText = "Rank Name"; } dgvDeprCalc.Refresh(); grt_Option.SelectedTab = tab_depreciation; } }
private void btnSearch_Click(object sender, EventArgs e) { CheckTreeView(trvAsset, false); CheckTreeView(trvOther, true); Vo.asset_cd = txtAssetCode.Text; Vo.asset_name = txtAssetName.Text; Vo = (AccountManagerFAWHVo)DefaultCbmInvoker.Invoke(new SearchAccountFAWHCbm(), Vo); UpdateGrid(); }
private void Renew() { grt_Option.SelectedTab = tab_Search; Vo = new AccountManagerFAWHVo(); dgvAccountData.DataSource = null; dgvAccCounter.Rows.Clear(); dgvDeprCalc.DataSource = null; foreach (TreeNode root in trvAsset.Nodes) { root.Checked = false; } foreach (TreeNode root in trvOther.Nodes) { root.Checked = false; } }
private void btnRankDepr_Click(object sender, EventArgs e) { AccountManagerFAWHVo rankDepr = (AccountManagerFAWHVo)DefaultCbmInvoker.Invoke(new GetRankDeprFAWHCbm(), new AccountManagerFAWHVo()); UpdateDeprGrid(rankDepr); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { AccountManagerFAWHVo inVo = (AccountManagerFAWHVo)vo; DataTable dt = new DataTable(); StringBuilder sql = new StringBuilder(); //CREATE SQL ADAPTER AND PARAMETER LIST DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("select a.account_main_id as \"Account_ID\" ,b.asset_cd as \"Asset_Code\", b.asset_no as \"Asset_No\", b.asset_name as \"Asset_Name\", b.asset_model as \"Asset_Model\", b.asset_serial as \"Asset_Serial\", b.asset_supplier as \"Asset_Supplier\", "); sql.Append("b.asset_type as \"Asset_Type\", a.qty as \"Qty\", c.unit_name as \"Unit\", e.account_code_name as \"Account_Code\", d.rank_name as \"Rank\", "); sql.Append("f.account_location_cd as \"Section_Code\", f.account_location_name as \"Section_Name\", g.location_cd as \"Now Location\", "); sql.Append("b.asset_life as \"Life\", b.acquistion_date as \"Acquisition_Date\", a.depreciation_start as \"Depreciation_Start\", a.depreciation_end as \"Depreciation_End\", "); sql.Append("b.acquistion_cost as \"Acquisition_Cost\", a.monthly_depreciation as \"Monthly_Depr\", a.current_depreciation as \"Current_Depr\", a.accum_depreciation_now as \"Accum_Depr\", a.net_value as \"Net_Value\", "); sql.Append("j.user_location_name as \"User_Location\", a.comment_data as \"Comment\", a.registration_date_time as \"Reg_Date\", a.registration_user_cd as \"Reg_User\", "); sql.Append("h.invertory_time_name as \"Inventory_Time\", b.asset_invoice as \"Invoice\", i.factory_name as \"Factory\", b.label_status as \"Label\" "); sql.Append("from t_account_main a left join m_asset b on a.asset_id = b.asset_id "); sql.Append("left join m_unit c on a.unit_id = c.unit_id "); sql.Append("left join m_rank d on a.rank_id = d.rank_id "); sql.Append("left join m_account_code e on a.account_code_id = e.account_code_id "); sql.Append("left join m_account_location f on a.account_location_id = f.account_location_id "); sql.Append("left join m_location g on a.location_id = g.location_id "); sql.Append("left join m_invertory_time h on a.invertory_time_id = h.invertory_time_id "); sql.Append("left join m_factory i on a.factory_cd = i.factory_cd "); sql.Append("left join m_user_location j on a.user_location_id = j.user_location_id "); sql.Append("where 1=1 "); if (inVo.list_account_cd.Length > 3) { sql.Append("and e.account_code_id in (").Append(inVo.list_account_cd).Append(") "); } if (inVo.list_account_location.Length > 3) { sql.Append("and f.account_location_id in (").Append(inVo.list_account_location).Append(") "); } if (inVo.list_asset_invoice.Length > 3) { sql.Append("and b.asset_invoice in (").Append(inVo.list_asset_invoice).Append(") "); } if (inVo.list_asset_label.Length > 3) { sql.Append("and b.label_status in (").Append(inVo.list_asset_label).Append(") "); } if (inVo.list_asset_model.Length > 3) { sql.Append("and b.asset_model in (").Append(inVo.list_asset_model).Append(") "); } if (inVo.list_asset_type.Length > 3) { sql.Append("and b.asset_type in (").Append(inVo.list_asset_type).Append(") "); } if (inVo.list_factory.Length > 3) { sql.Append("and i.factory_cd in (").Append(inVo.list_factory).Append(") "); } if (inVo.list_invertory_times.Length > 3) { sql.Append("and h.invertory_time_id in (").Append(inVo.list_invertory_times).Append(") "); } if (inVo.list_location.Length > 3) { sql.Append("and g.location_id in (").Append(inVo.list_location).Append(") "); } if (inVo.list_rank.Length > 3) { sql.Append("and d.rank_id in (").Append(inVo.list_rank).Append(") "); } if (inVo.list_unit.Length > 3) { sql.Append("and c.unit_id in (").Append(inVo.list_unit).Append(") "); } if (!string.IsNullOrEmpty(inVo.asset_cd)) { sql.Append("and b.asset_cd like '%").Append(inVo.asset_cd).Append("%' "); } if (!string.IsNullOrEmpty(inVo.asset_name)) { sql.Append("and b.asset_name like '%").Append(inVo.asset_name).Append("%' "); sqlParameter.AddParameterString("asset_name", inVo.asset_name); } if (inVo.value_expired) { sql.Append("and a.net_value <= '0' "); } if (inVo.value_valid) { sql.Append("and a.net_value > '0' "); } sql.Append("order by b.asset_cd"); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); sql.Clear(); //EXECUTE READER FROM COMMAND IDataReader datareader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); dt.Load(datareader); datareader.Close(); AccountManagerFAWHVo outVo = new AccountManagerFAWHVo { table = dt }; return(outVo); }