/// <summary>
/// Update depreciation
/// </summary>
/// <param name="inVo"></param>
private void UpdateDeprGrid(AccountManagerVo 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;
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
AccountManagerVo inVo = (AccountManagerVo)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.rank_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_rank b on a.rank_id = b.rank_id ");
sql.Append("left join m_asset c on a.asset_id = c.asset_id ");
sql.Append("group by b.rank_name");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
sql.Clear();
//EXECUTE READER FROM COMMAND
IDataReader datareader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
dt.Load(datareader);
datareader.Close();
AccountManagerVo outVo = new AccountManagerVo()
{
table = dt
};
return(outVo);
}
private void btnSearch_Click(object sender, EventArgs e)
{
CheckTreeView(trvAsset, false);
CheckTreeView(trvOther, true);
Vo = (AccountManagerVo)DefaultCbmInvoker.Invoke(new SearchAccountCbm(), Vo);
UpdateGrid();
}
private void Renew()
{
grt_Option.SelectedTab = tab_Search;
Vo = new AccountManagerVo();
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)
{
AccountManagerVo rankDepr = (AccountManagerVo)DefaultCbmInvoker.Invoke(new GetRankDeprCbm(), new AccountManagerVo());
UpdateDeprGrid(rankDepr);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
AccountManagerVo inVo = (AccountManagerVo)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();
AccountManagerVo outVo = new AccountManagerVo
{
table = dt
};
return(outVo);
}
