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 UpdateAssetForm(AssetInfoVo inVo, bool addForm)
{
InitializeComponent();
checkAddFrm = addForm;
if (!addForm)
{
this.Width -= dgvAddAssetList.Width;
btnApply.Text = "Update Asset";
}
voInfo = inVo;
}
private void AddAssetList()
{
bool checkEmpty = false;
foreach (Control x in grUpdate.Controls)
{
if (string.IsNullOrEmpty(x.Text) && !(x is Label) && (x.Name != txtAssetPO.Name))
{
checkEmpty = true;
break;
}
}
if (checkEmpty)
{
MessageBox.Show("Must fill all infomation before add!", "CAUTION", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
voInfo = new AssetInfoVo
{
acquistion_cost = double.Parse(txtAcqCost.Text),
acquistion_date = dtpAcqDate.Value,
asset_cd = txtAssetCode.Text,
asset_invoice = txtAssetInvoice.Text,
asset_life = (double)numLife.Value,
asset_model = txtAssetModel.Text,
asset_name = txtAssetName.Text,
asset_no = (int)numAssetNo.Value,
asset_po = txtAssetPO.Text,
asset_serial = txtAssetSerial.Text,
asset_supplier = txtSupplier.Text,
asset_type = cmbAssetType.Text,
factory_cd = txtFactory.Text,
label_status = label
};
dgvAddAssetList.Rows.Add(voInfo.asset_cd, voInfo.asset_no, voInfo.asset_name, voInfo.asset_serial,
voInfo.asset_model, voInfo.asset_life, voInfo.acquistion_cost, voInfo.acquistion_date, voInfo.asset_invoice,
voInfo.asset_po, voInfo.asset_type, voInfo.factory_cd, voInfo.asset_supplier, voInfo.label_status);
infoList.Add(voInfo);
dgvAddAssetList.Refresh();
btnAddAsset.Enabled = infoList.Count > 0;
tsRowCount.Text = dgvAddAssetList.RowCount.ToString() + " rows";
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
AssetInfoVo inVo = (AssetInfoVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append(@"INSERT INTO m_asset(
asset_no, asset_cd, asset_name, asset_model, asset_serial, asset_supplier, asset_invoice, asset_life, acquistion_date,
acquistion_cost, asset_type, registration_user_cd, registration_date_time, factory_cd, label_status, asset_po)
VALUES(:asset_no, :asset_cd, :asset_name, :asset_model, :asset_serial, :asset_supplier,
:asset_invoice, :asset_life, :acquistion_date, :acquistion_cost, :asset_type, :registration_user_cd,
:registration_date_time, :factory_cd, :label_status, :asset_po)");
//CREATE SQL ADAPTER AND PARAMETER LIST
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("asset_no", inVo.asset_no);
sqlParameter.AddParameterString("asset_cd", inVo.asset_cd);
sqlParameter.AddParameterString("asset_name", inVo.asset_name);
sqlParameter.AddParameterString("asset_model", inVo.asset_model);
sqlParameter.AddParameterString("asset_serial", inVo.asset_serial);
sqlParameter.AddParameterString("asset_supplier", inVo.asset_supplier);
sqlParameter.AddParameterString("asset_invoice", inVo.asset_invoice);
sqlParameter.AddParameter("asset_life", inVo.asset_life);
sqlParameter.AddParameterDateTime("acquistion_date", inVo.acquistion_date);
sqlParameter.AddParameter("acquistion_cost", inVo.acquistion_cost);
sqlParameter.AddParameterString("asset_type", inVo.asset_type);
sqlParameter.AddParameterString("registration_user_cd", UserData.GetUserData().UserCode);
sqlParameter.AddParameterDateTime("registration_date_time", DateTime.Now);
sqlParameter.AddParameterString("factory_cd", UserData.GetUserData().FactoryCode);
sqlParameter.AddParameterString("label_status", inVo.label_status);
sqlParameter.AddParameterString("asset_po", inVo.asset_po);
sql.Clear();
//EXECUTE READER FROM COMMAND
AssetMaster2019Vo outVo = new AssetMaster2019Vo
{
executeInt = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
AssetInfoVo inVo = (AssetInfoVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append("update m_asset set asset_cd=:asset_cd,asset_no=:asset_no,asset_name=:asset_name, asset_model=:asset_model, asset_invoice =:asset_invoice, asset_serial =:asset_serial, asset_supplier=:asset_supplier,asset_life =:asset_life, acquistion_date=:acquistion_date, acquistion_cost=:acquistion_cost, asset_type=:asset_type, label_status=:label_status, asset_po = :asset_po");
sql.Append(" where asset_cd =:asset_cd and asset_no = :asset_no");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
sql.Clear();
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("asset_no", inVo.asset_no);
sqlParameter.AddParameterString("asset_cd", inVo.asset_cd);
sqlParameter.AddParameterString("asset_name", inVo.asset_name);
sqlParameter.AddParameterString("asset_model", inVo.asset_model);
sqlParameter.AddParameterString("asset_serial", inVo.asset_serial);
sqlParameter.AddParameterString("asset_supplier", inVo.asset_supplier);
sqlParameter.AddParameterString("asset_invoice", inVo.asset_invoice);
sqlParameter.AddParameter("asset_life", inVo.asset_life);
sqlParameter.AddParameterDateTime("acquistion_date", inVo.acquistion_date);
sqlParameter.AddParameter("acquistion_cost", inVo.acquistion_cost);
sqlParameter.AddParameterString("asset_type", inVo.asset_type);
sqlParameter.AddParameterString("factory_cd", inVo.factory_cd);
sqlParameter.AddParameterString("registration_user_cd", UserData.GetUserData().UserCode);
sqlParameter.AddParameterString("label_status", inVo.label_status);
sqlParameter.AddParameterString("asset_po", inVo.asset_po);
//execute SQL
AssetMaster2019Vo outVo = new AssetMaster2019Vo()
{
executeInt = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public AssetMaster2019Form()
{
InitializeComponent();
vo = new AssetMaster2019Vo();
voInfo = new AssetInfoVo();
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
AssetInfoVo inVo = (AssetInfoVo)vo;
ValueObjectList <AssetInfoVo> voList = new ValueObjectList <AssetInfoVo>();
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 m_asset where 1=1 ");
if (inVo.asset_id > 0)
{
sql.Append("and asset_id='").Append(inVo.asset_id).Append("' ");
}
if (!string.IsNullOrEmpty(inVo.asset_cd))
{
sql.Append("and asset_cd='").Append(inVo.asset_cd).Append("' ");
}
if (inVo.asset_no > 0)
{
sql.Append("and asset_no='").Append(inVo.asset_no).Append("' ");
}
if (!string.IsNullOrEmpty(inVo.asset_name))
{
sql.Append("and asset_name='").Append(inVo.asset_name).Append("' ");
}
if (!string.IsNullOrEmpty(inVo.asset_type))
{
sql.Append("and asset_type='").Append(inVo.asset_type).Append("' ");
}
if (!string.IsNullOrEmpty(inVo.label_status))
{
sql.Append("and label_status='").Append(inVo.label_status).Append("' ");
}
sql.Append("order by asset_id");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
sql.Clear();
//EXECUTE READER FROM COMMAND
IDataReader datareader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (datareader.Read())
{
AssetInfoVo outVo = new AssetInfoVo
{
asset_id = (int)datareader["asset_id"],
asset_cd = datareader["asset_cd"].ToString(),
asset_no = (int)datareader["asset_no"],
asset_name = datareader["asset_name"].ToString(),
asset_model = datareader["asset_model"].ToString(),
asset_serial = datareader["asset_serial"].ToString(),
acquistion_cost = (double)datareader["acquistion_cost"],
acquistion_date = (DateTime)datareader["acquistion_date"],
asset_life = (double)datareader["asset_life"],
asset_type = datareader["asset_type"].ToString(),
asset_invoice = datareader["asset_invoice"].ToString(),
asset_supplier = datareader["asset_supplier"].ToString(),
factory_cd = datareader["factory_cd"].ToString(),
label_status = datareader["label_status"].ToString(),
asset_po = datareader["asset_po"].ToString(),
registration_user_cd = datareader["registration_user_cd"].ToString(),
registration_date_time = (DateTime)datareader["registration_date_time"],
};
voList.add(outVo);
}
datareader.Close();
return(voList);
}