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);
}
