public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
AssetVo inVo = (AssetVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <AssetVo> voList = new ValueObjectList <AssetVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"SELECT distinct asset_po from m_asset order by asset_po");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
AssetVo outVo = new AssetVo
{
AssetPO = dataReader["asset_po"].ToString()
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
private void BindUpdateCavityData()
{
int selectedrowindex = AssetDetails_dgv.SelectedCells[0].RowIndex;
AssetVo vo = (AssetVo)AssetDetails_dgv.Rows[selectedrowindex].DataBoundItem;
AddAssetForm addform = new AddAssetForm();
addform.vo = vo;
addform.ShowDialog(); //
if (addform.IntSuccess > 0)
{
messageData = new MessageData("mmci00002", Properties.Resources.mmci00002, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind();
}
else if (addform.IntSuccess == 0)
{
messageData = new MessageData("mmci00007", Properties.Resources.mmci00007, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind();
}
}
private void GridBind()
{
AssetDetails_dgv.DataSource = null;
try
{
AssetVo vo = new AssetVo
{
AssetCode = AssetCode_txt.Text,
AssetName = AssetName_txt.Text
};
ValueObjectList <AssetVo> volist = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetCbm(), vo);
if (volist.GetList() != null && volist.GetList().Count > 0)
{
AssetDetails_dgv.AutoGenerateColumns = false;
BindingSource bindingsource = new BindingSource(volist.GetList(), null);
AssetDetails_dgv.DataSource = bindingsource;
}
else
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
AssetDetails_dgv.ClearSelection();
Update_btn.Enabled = false;
Delete_btn.Enabled = false;
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
private void Ok_btn_Click(object sender, EventArgs e)
{
try
{
if (checkdate())
{
AssetVo outvo = new AssetVo();
AssetVo invo = new AssetVo
{
AssetId = vo.AssetId,
AssetNo = int.Parse(AssetNo_txt.Text),
AssetCode = AssetCode_txt.Text,
AssetName = AssetName_txt.Text,
AssetModel = AssetModel_txt.Text,
AssetSerial = AssetInvoice_txt.Text,
AssetInvoice = AssetInvoice_txt.Text,
AssetLife = double.Parse(AssetLife_txt.Text),
AcquistionDate = Asset_Acquistion_Date_dtp.Value,
AcquistionCost = double.Parse(Asset_Acquistion_Cost_txt.Text),
AssetSuppiler = AssetSupplier_txt.Text,
AssetType = AssetType_txt.Text,
FactoryCode = UserData.GetUserData().FactoryCode,
RegistrationUserCode = UserData.GetUserData().UserCode
};
try
{
if (invo.AssetId > 0)
{
outvo = (AssetVo)DefaultCbmInvoker.Invoke(new UpdateAssetCbm(), invo);
}
else
{
outvo = (AssetVo)DefaultCbmInvoker.Invoke(new AddAssetCbm(), invo);
}
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, AssetCode_lbl.Text + " : " + AssetCode_txt.Text);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
if ((IntSuccess > 0) || (IntSuccess == 0))
{
this.DialogResult = DialogResult.OK;
this.Close();
}
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
AssetVo inVo = (AssetVo)vo;
StringBuilder sql = new StringBuilder();
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty);
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("Select Count(*) as AssetCount ");
sql.Append(" from m_asset");
sql.Append(" Where 1=1 ");
if (!String.IsNullOrEmpty(inVo.FactoryCode))
{
sql.Append(" and factory_cd = :factory_cd ");
sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode);
}
if (!string.IsNullOrEmpty(inVo.AssetCode))
{
sql.Append(" and asset_cd = :asset_cd ");
sqlParameter.AddParameterString("asset_cd", inVo.AssetCode);
}
if (inVo.AssetNo > -1)
{
sql.Append(" and asset_no = :asset_no ");
sqlParameter.AddParameter("asset_no", inVo.AssetNo);
}
if (inVo.AssetId > 0)
{
sql.Append(" and asset_id != :asset_id "); ///?????
sqlParameter.AddParameterInteger("asset_id", inVo.AssetId);
}
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
AssetVo outVo = new AssetVo();
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["AssetCount"].ToString());
}
dataReader.Close();
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
AssetVo inVo = (AssetVo)vo;
StringBuilder sql = new StringBuilder();
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty);
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("delete from m_asset Where 1=1 ");
if (!String.IsNullOrEmpty(inVo.FactoryCode))
{
sql.Append(" and factory_cd = :factory_cd ");
sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode);
}
if (inVo.AssetId > 0)
{
sql.Append(" and asset_id = :asset_id ");
sqlParameter.AddParameterInteger("asset_id", inVo.AssetId);
}
if (!string.IsNullOrEmpty(inVo.AssetCode))
{
sql.Append(" and asset_cd = :asset_cd ");
sqlParameter.AddParameterString("asset_cd", inVo.AssetCode);
}
if (!string.IsNullOrEmpty(inVo.AssetName))
{
sql.Append(" and asset_name = :asset_name ");
sqlParameter.AddParameterString("asset_name", inVo.AssetName);
}
//create command
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
AssetVo outVo = new AssetVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
private void Delete_btn_Click(object sender, EventArgs e)
{
if (AssetDetails_dgv.SelectedRows.Count > 0)
{
int selectedrowindex = AssetDetails_dgv.SelectedCells[0].RowIndex;
AssetVo vo = (AssetVo)AssetDetails_dgv.Rows[selectedrowindex].DataBoundItem;
messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, vo.AssetCode);
logger.Info(messageData);
DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text);
if (dialogResult == DialogResult.OK)
{
try
{
AssetVo outVo = (AssetVo)DefaultCbmInvoker.Invoke(new DeleteAssetCbm(), vo);
if (outVo.AffectedCount > 0)
{
messageData = new MessageData("mmci00003", Properties.Resources.mmci00003, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind();
}
else if (outVo.AffectedCount == 0)
{
messageData = new MessageData("mmci00007", Properties.Resources.mmci00007, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind();
}
}
catch (Com.Nidec.Mes.Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
AssetVo inVo = (AssetVo)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_id =:asset_id");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("asset_id", inVo.AssetId);
sqlParameter.AddParameterInteger("asset_no", inVo.AssetNo);
sqlParameter.AddParameterString("asset_cd", inVo.AssetCode);
sqlParameter.AddParameterString("asset_name", inVo.AssetName);
sqlParameter.AddParameterString("asset_model", inVo.AssetModel);
sqlParameter.AddParameterString("asset_serial", inVo.AssetSerial);
sqlParameter.AddParameterString("asset_supplier", inVo.AssetSuppiler);
sqlParameter.AddParameterString("asset_invoice", inVo.AssetInvoice);
sqlParameter.AddParameter("asset_life", inVo.AssetLife);
sqlParameter.AddParameterDateTime("acquistion_date", inVo.AcquistionDate);
sqlParameter.AddParameter("acquistion_cost", inVo.AcquistionCost);
sqlParameter.AddParameterString("asset_type", inVo.AssetType);
sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode);
sqlParameter.AddParameterString("registration_user_cd", inVo.RegistrationUserCode);
sqlParameter.AddParameterString("label_status", inVo.LabelStatus);
sqlParameter.AddParameterString("asset_po", inVo.AssetPO);
//execute SQL
AssetVo outVo = new AssetVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
private void GridBind()
{
AssetDetails_dgv.DataSource = null;
try
{
AssetVo vo = new AssetVo
{
AssetCode = AssetCode_txt.Text,
AssetName = AssetName_txt.Text,
AssetNo = 10000, //ne vao trong gia tri o, nen chuyen database lai voi asset_no string Long
};
ValueObjectList <AssetVo> volist = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetCbm(), vo);
if (volist.GetList() != null && volist.GetList().Count > 0)
{
BindingSource bindingsource = new BindingSource(volist.GetList(), null);
AssetDetails_dgv.DataSource = bindingsource;
AssetDetails_dgv.Columns["colAssetCode"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
}
else
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
AssetDetails_dgv.ClearSelection();
setColor();
Update_btn.Enabled = false;
Delete_btn.Enabled = false;
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
AssetVo inVo = (AssetVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append("insert into m_asset(asset_cd,asset_no, asset_name, asset_model, asset_supplier, asset_invoice, asset_life,acquistion_date, acquistion_cost, asset_serial, asset_type, registration_user_cd, registration_date_time, factory_cd) ");
sql.Append("values(:asset_cd,:asset_no, :asset_name, :asset_model, :asset_supplier, :asset_invoice, :asset_life, :acquistion_date, :acquistion_cost, :asset_serial, :asset_type, :registration_user_cd,now(), :factory_cd)");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("asset_cd", inVo.AssetCode);
sqlParameter.AddParameterInteger("asset_no", inVo.AssetNo);
sqlParameter.AddParameterString("asset_name", inVo.AssetName);
sqlParameter.AddParameterString("asset_model", inVo.AssetModel);
sqlParameter.AddParameterString("asset_supplier", inVo.AssetSuppiler);
sqlParameter.AddParameterString("asset_invoice", inVo.AssetInvoice);
sqlParameter.AddParameterString("asset_serial", inVo.AssetSerial);
sqlParameter.AddParameter("asset_life", inVo.AssetLife);
sqlParameter.AddParameterDateTime("acquistion_date", inVo.AcquistionDate);
sqlParameter.AddParameter("acquistion_cost", inVo.AcquistionCost);
sqlParameter.AddParameterString("asset_type", inVo.AssetType);
sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode);
sqlParameter.AddParameterString("registration_user_cd", inVo.RegistrationUserCode);
sqlParameter.AddParameterDateTime("registration_date_time", inVo.RegistrationDateTime);
//execute SQL
AssetVo outVo = new AssetVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
AssetVo inVo = (AssetVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <AssetVo> voList = new ValueObjectList <AssetVo>();
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty);
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("select asset_id,asset_no,asset_cd,asset_name, asset_model, asset_supplier, asset_type, asset_serial, asset_invoice, asset_life, acquistion_date, acquistion_cost, registration_user_cd,registration_date_time,factory_cd from m_asset");
sql.Append(" Where 1=1 ");
if (!String.IsNullOrEmpty(inVo.FactoryCode))
{
sql.Append(" and factory_cd = :factory_cd ");
sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode);
}
if (inVo.AssetId > 0)
{
sql.Append(" and asset_id = :asset_id ");
sqlParameter.AddParameterInteger("asset_id", inVo.AssetId);
}
if (!string.IsNullOrEmpty(inVo.AssetCode))
{
sql.Append(" and asset_cd = :asset_cd ");
sqlParameter.AddParameterString("asset_cd", inVo.AssetCode);
}
if (!string.IsNullOrEmpty(inVo.AssetName))
{
sql.Append(" and asset_name = :asset_name ");
sqlParameter.AddParameterString("asset_name", inVo.AssetName);
}
//create command
//DbCommandAdaptor
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
AssetVo outVo = new AssetVo
{
AssetCode = dataReader["asset_cd"].ToString(),
AssetNo = int.Parse(dataReader["asset_no"].ToString()),
AssetId = int.Parse(dataReader["asset_id"].ToString()),
AssetName = dataReader["asset_name"].ToString(),
AssetModel = dataReader["asset_model"].ToString(),
AssetSuppiler = dataReader["asset_supplier"].ToString(),
AssetType = dataReader["asset_type"].ToString(),
AssetInvoice = dataReader["asset_invoice"].ToString(),
AssetSerial = dataReader["asset_serial"].ToString(),
AssetLife = double.Parse(dataReader["asset_life"].ToString()),
AcquistionCost = double.Parse(dataReader["acquistion_cost"].ToString()),
AcquistionDate = DateTime.Parse(dataReader["acquistion_date"].ToString()),
RegistrationUserCode = dataReader["registration_user_cd"].ToString(),
RegistrationDateTime = DateTime.Parse(dataReader["registration_date_time"].ToString()),
FactoryCode = dataReader["factory_cd"].ToString()
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
private bool checkdate()
{
if (AssetCode_txt.Text.Trim().Length == 0)
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, AssetCode_lbl.Text);
popUpMessage.Warning(messageData, Text);
AssetCode_txt.Focus();
return(false);
}
if (AssetName_txt.Text.Trim().Length == 0)
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, AssetName_lbl.Text);
popUpMessage.Warning(messageData, Text);
AssetName_txt.Focus();
return(false);
}
if (AssetModel_txt.Text.Trim().Length == 0)
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, AssetModel_lbl.Text);
popUpMessage.Warning(messageData, Text);
AssetModel_txt.Focus();
return(false);
}
if (AssetSupplier_txt.Text.Trim().Length == 0)
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, AssetSupplier_lbl.Text);
popUpMessage.Warning(messageData, Text);
AssetSupplier_txt.Focus();
return(false);
}
if (AssetInvoice_txt.Text.Trim().Length == 0)
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, AssetInvoice_lbl.Text);
popUpMessage.Warning(messageData, Text);
AssetInvoice_txt.Focus();
return(false);
}
if (AssetLife_txt.Text.Trim().Length == 0)
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, Life_lbl.Text);
popUpMessage.Warning(messageData, Text);
AssetLife_txt.Focus();
return(false);
}
if (Asset_Acquistion_Cost_txt.Text.Trim().Length == 0)
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, Acquistion_Cost_lbl.Text);
popUpMessage.Warning(messageData, Text);
Asset_Acquistion_Cost_txt.Focus();
return(false);
}
if (AssetNo_txt.Text.Trim().Length == 0)
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, AssetNo_lbl.Text);
popUpMessage.Warning(messageData, Text);
AssetNo_txt.Focus();
return(false);
}
if (Asset_Acquistion_Date_dtp.Value > DateTime.Now)
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, Acquistion_Date_lbl.Text);
popUpMessage.Warning(messageData, Text);
Asset_Acquistion_Date_dtp.Focus();
return(false);
}
AssetCode_txt.Text = AssetCode_txt.Text.Trim();
AssetNo_txt.Text = AssetNo_txt.Text.Trim();
AssetName_txt.Text = AssetName_txt.Text.Trim();
AssetModel_txt.Text = AssetModel_txt.Text.Trim();
AssetSupplier_txt.Text = AssetSupplier_txt.Text.Trim();
AssetInvoice_txt.Text = AssetInvoice_txt.Text.Trim();
AssetSerial_txt.Text = AssetSerial_txt.Text.Trim();
AssetLife_txt.Text = AssetLife_txt.Text.Trim();
Asset_Acquistion_Cost_txt.Text = Asset_Acquistion_Cost_txt.Text.Trim();
AssetVo outVo = new AssetVo(), inVo = new AssetVo {
AssetNo = int.Parse(AssetNo_txt.Text), AssetCode = AssetCode_txt.Text
};
try
{
outVo = (AssetVo)DefaultCbmInvoker.Invoke(new CheckAssetCbm(), inVo);
if (outVo.AffectedCount == 1)
{
messageData = new MessageData("mmce00001", AssetCode_lbl.Text + " : " + AssetCode_txt.Text + " is duplicate !", AssetCode_lbl.Text + " : " + AssetCode_txt.Text);
logger.Warn(messageData);
popUpMessage.Information(messageData, Text);
return(false);
}
}
catch (Com.Nidec.Mes.Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return(false);
}
return(true);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
try
{
//VARIABLE
AssetVo inVo = (AssetVo)vo;
StringBuilder query = new StringBuilder();
ValueObjectList <AssetVo> listVo = new ValueObjectList <AssetVo>();
//CREATE SQL ADAPTER AND PARAMETER LIST
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, query.ToString());
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
//QUERY STRING
query.Append("Select * from m_asset where 1=1 ");
if (inVo.asset_id > 0 || inVo != null)
{
query.Append("and asset_id='").Append(inVo.asset_id).Append("' ");
}
if (inVo.asset_no > 0 || inVo != null)
{
query.Append("and asset_no='").Append(inVo.asset_no).Append("' ");
}
if (string.IsNullOrEmpty(inVo.asset_cd))
{
query.Append("and asset_cd='").Append(inVo.asset_cd).Append("' ");
}
if (string.IsNullOrEmpty(inVo.asset_name))
{
query.Append("and asset_name='").Append(inVo.asset_name).Append("' ");
}
if (string.IsNullOrEmpty(inVo.asset_model))
{
query.Append("and asset_model='").Append(inVo.asset_model).Append("' ");
}
if (string.IsNullOrEmpty(inVo.asset_serial))
{
query.Append("and asset_serial='").Append(inVo.asset_serial).Append("' ");
}
if (string.IsNullOrEmpty(inVo.asset_supplier))
{
query.Append("and asset_supplier='").Append(inVo.asset_supplier).Append("' ");
}
if (string.IsNullOrEmpty(inVo.asset_invoice))
{
query.Append("and asset_invoice='").Append(inVo.asset_invoice).Append("' ");
}
if (inVo.asset_life > 0 || inVo != null)
{
query.Append("and asset_life='").Append(inVo.asset_life).Append("' ");
}
if (string.IsNullOrEmpty(inVo.asset_type))
{
query.Append("and asset_type='").Append(inVo.asset_type).Append("' ");
}
query.Append("order by asset_id");
//GET SQL ADAPTER
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, query.ToString());
//EXECUTE READER FROM COMMAND
IDataReader datareader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (datareader.Read())
{
AssetVo outVo = new AssetVo
{
asset_id = (int)datareader["asset_id"],
asset_no = (int)datareader["asset_no"],
asset_cd = datareader["asset_cd"].ToString(),
asset_name = datareader["asset_name"].ToString(),
asset_model = datareader["asset_model"].ToString(),
asset_serial = datareader["asset_serial"].ToString(),
asset_supplier = datareader["asset_supplier"].ToString(),
asset_invoice = datareader["asset_invoice"].ToString(),
asset_life = (double)datareader["asset_life"],
acquistion_date = (DateTime)datareader["acquistion_date"],
acquistion_cost = (double)datareader["acquistion_cost"],
asset_type = datareader["asset_type"].ToString(),
asset_po = datareader["asset_po"].ToString(),
label_status = datareader["label_status"].ToString(),
registration_user_cd = datareader["registration_user_cd"].ToString(),
registration_date_time = (DateTime)datareader["registration_date_time"],
factory_cd = datareader["factory_cd"].ToString()
};
listVo.add(outVo);
}
//CLEAR AND CLOSE CONNECTION
query.Clear();
datareader.Close();
base.CloseConnection(trxContext);
return(listVo);
}
catch
{
throw new NotImplementedException();
}
}
