public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
WareHouseMainVo inVo = (WareHouseMainVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append(@"update t_warehouse_main set current_depreciation =:current_depreciation,
monthly_depreciation=:monthly_depreciation,
accum_depreciation_now =:accum_depreciation_now,
net_value =:net_value ");
sql.Append(" where warehouse_main_id =:warehouse_main_id");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameter("warehouse_main_id", inVo.WareHouseMainId);
sqlParameter.AddParameter("current_depreciation", inVo.CurrentDepreciation);
sqlParameter.AddParameter("monthly_depreciation", inVo.MonthlyDepreciation);
sqlParameter.AddParameter("accum_depreciation_now", inVo.AccumDepreciation);
sqlParameter.AddParameter("net_value", inVo.NetValue);
//execute SQL
WareHouseMainVo outVo = new WareHouseMainVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
private void ok_btn_Click(object sender, EventArgs e)
{
if (Checkdata())
{
WareHouseMainVo outVo = new WareHouseMainVo();
WareHouseMainVo inVo = new WareHouseMainVo()
{
WareHouseMainId = WareHouseMainVo.WareHouseMainId,
///
BeforeLocationId = ((LocationVo)this.before_location_cmb.SelectedItem).LocationId,
DetailPositionId = ((DetailPositionVo)this.detail_position_cmb.SelectedItem).DetailPositionId,
AfterLocationId = ((LocationVo)this.after_location_cmb.SelectedItem).LocationId,
AssetId = ((AssetVo)this.no_cbm.SelectedItem).AssetId,
QTY = Int16.Parse(qty_txt.Text),
Unit = unit_cmb.Text,
AssetNo = Int16.Parse(no_cbm.Text),
AccountCodeId = ((AccountCodeVo)this.account_code_cmb.SelectedItem).AccountCodeId,
AccountLocationId = ((AccountLocationVo)this.section_cd_cmb.SelectedItem).AccountLocationId,
RankId = ((RankVo)this.rank_code_cmb.SelectedItem).RankId,
CommnetsData = comments_txt.Text,
StartDepreciation = start_depreciation_dtp.Value,
EndDepreciation = end_depreciation_dtp.Value,
CurrentDepreciation = double.Parse(current_depreciation_txt.Text),
MonthlyDepreciation = double.Parse(monthl_depreciation_txt.Text),
AccumDepreciation = double.Parse(accum_depreciation_txt.Text),
NetValue = double.Parse(net_value_txt.Text),
// LocationId = ((LocationVo)this.location_cmb.SelectedItem).LocationId,
UserLocationId = ((UserLocationVo)this.user_location_name_cmb.SelectedItem).UserLocationId,
RegistrationDateTime = DateTime.Now,
FactoryCode = UserData.GetUserData().FactoryCode,
RegistrationUserCode = UserData.GetUserData().UserCode
};
try
{
if (inVo.WareHouseMainId > 0)
{
outVo = (WareHouseMainVo)DefaultCbmInvoker.Invoke(new Cbm.AddWareHouseMainCbm(), inVo);
// outVo = (WareHouseVo)DefaultCbmInvoker.Invoke(new Cbm.AddWareHouseCbm(), inVo);
}
else
{
outVo = (WareHouseMainVo)DefaultCbmInvoker.Invoke(new Cbm.AddWareHouseMainCbm(), inVo);
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
if (outVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, asset_code_lbl.Text + " : " + asset_code_txt.Text);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
return;
}
}
}
private void GridBind()
{
try
{
WareHouseMainVo whvos = new WareHouseMainVo()
{
AssetCode = asset_Code_txt.Text,
RankCode = rank_code_cbm.Text,
AssetType = asset_type_cbm.Text,
AccountCodeCode = detail_position_cmb.Text,
AccountLocationCode = select_search_cbm.Text,
AssetInvoice = invoice_cbm.Text,
AssetModel = asset_model_cbm.Text,
AfterLocationCd = location_cbm.Text,
AssetName = asset_name_cbm.Text,
DetailPositionCd = detail_position_cmb.Text,
LabelStatus = labelstatus_cmb.Text,
Net_Value = net_value_cmb.Text,
AssetPO = AssetPO_cmb.Text,
NowLocation = inventoryLocation_cbm.Text,
};
if (checkdata())
{
if (select_search_cbm.Text == "Search History")
{
ValueObjectList <WareHouseMainVo> listvo = (ValueObjectList <WareHouseMainVo>)DefaultCbmInvoker.Invoke(new SearchWareHouseMainCbm(), whvos);
warehouse_main_dgv.DataSource = listvo.GetList();
}
else if (select_search_cbm.Text == "Search List")
{
ValueObjectList <WareHouseMainVo> listvo = (ValueObjectList <WareHouseMainVo>)DefaultCbmInvoker.Invoke(new SearchListWareHouseMainCbm(), whvos);
warehouse_main_dgv.DataSource = listvo.GetList();
foreach (DataGridViewRow dr in warehouse_main_dgv.Rows)
{
string after = (string)dr.Cells["colafterlocation"].Value;
string nowloc = (string)dr.Cells["colnowlocation"].Value;
if (after != nowloc)
{
dr.DefaultCellStyle.ForeColor = Color.Blue;
}
}
invertory_alarm();
counter();
}
// calculator();
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
private void update_btn_Click(object sender, EventArgs e)
{
if (warehouse_main_dgv.SelectedCells.Count > 0)
{
WareHouseMainVo selectedvo = (WareHouseMainVo)warehouse_main_dgv.CurrentRow.DataBoundItem;
if (new AddWareHouseMainForm {
WareHouseMainVo = selectedvo,
}.ShowDialog() == DialogResult.OK)
{
GridBind();
}
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
WareHouseMainVo inVo = (WareHouseMainVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append(@"insert into t_warehouse_main_history(asset_id, qty, unit_id, account_code_id, account_location_id, rank_id, comment_data,
depreciation_start, depreciation_end, current_depreciation, monthly_depreciation,
accum_depreciation_now, net_value, user_location_id, before_location_id, after_location_id, detail_position_id, registration_user_cd, registration_date_time, factory_cd)");
sql.Append(@"values(:asset_id, :qty,:unit_id, :account_code_id, :account_location_id, :rank_id, :comment_data,
:depreciation_start, :depreciation_end, :current_depreciation, :monthly_depreciation,
:accum_depreciation_now, :net_value, :user_location_id, :before_location_id, :after_location_id,:detail_position_id, :registration_user_cd,:registration_date_time, :factory_cd)");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameter("asset_id", inVo.AssetId);
sqlParameter.AddParameter("qty", inVo.QTY);
sqlParameter.AddParameter("unit_id", inVo.UnitId);
sqlParameter.AddParameter("account_code_id", inVo.AccountCodeId);
sqlParameter.AddParameter("account_location_id", inVo.AccountLocationId);
sqlParameter.AddParameter("rank_id", inVo.RankId);
sqlParameter.AddParameter("comment_data", inVo.CommnetsData);
sqlParameter.AddParameter("depreciation_start", inVo.StartDepreciation);
sqlParameter.AddParameter("depreciation_end", inVo.EndDepreciation);
sqlParameter.AddParameter("current_depreciation", inVo.CurrentDepreciation);
sqlParameter.AddParameter("monthly_depreciation", inVo.MonthlyDepreciation);
sqlParameter.AddParameter("accum_depreciation_now", inVo.AccumDepreciation);
sqlParameter.AddParameter("net_value", inVo.NetValue);
// sqlParameter.AddParameter("location_id", inVo.LocationId);
sqlParameter.AddParameter("before_location_id", inVo.BeforeLocationId);
sqlParameter.AddParameter("after_location_id", inVo.AfterLocationId);
sqlParameter.AddParameter("user_location_id", inVo.UserLocationId);
sqlParameter.AddParameter("detail_position_id", inVo.DetailPositionId);
sqlParameter.AddParameter("registration_user_cd", inVo.RegistrationUserCode);
sqlParameter.AddParameter("registration_date_time", inVo.RegistrationDateTime);
sqlParameter.AddParameter("factory_cd", inVo.FactoryCode);
//execute SQL
WareHouseMainVo outVo = new WareHouseMainVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
WareHouseMainVo inVo = (WareHouseMainVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <WareHouseMainVo> voList = new ValueObjectList <WareHouseMainVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select tam.account_code_name as Account_Name,sum(tam.acquistion_cost) as Total_AcquisitionCose,sum(tam.current_depreciation) as Total_CurrentDepreication,sum(tam.monthly_depreciation) as Total_MonthlyDepreication,sum(tam.accum_depreciation_now)
as Total_AccumDepreication,sum(tam.net_value) as Total_NetBook from (select g.unit,a.account_code_name, g.warehouse_main_id,j.location_cd,
e.asset_cd, e.asset_no, e.asset_name, e.asset_model, e.asset_serial, e.asset_supplier, g.qty, a.account_code_cd, b.account_location_cd,
f.rank_cd, b.account_location_name, g.comment_data, e.asset_life, e.acquistion_date, e.acquistion_cost, g.depreciation_start, g.depreciation_end,
g.current_depreciation,g.monthly_depreciation, g.accum_depreciation_now, g.net_value, e.asset_invoice, g.registration_date_time, g.registration_user_cd from t_warehouse_main g
left join m_account_code a on a.account_code_id = g.account_code_id
left join m_account_location b on b.account_location_id = g.account_location_id
left join m_location c on c.location_id = g.before_location_id
left join m_location j on c.location_id = g.after_location_id
left join m_user_location d on d.user_location_id = g.user_location_id
left join m_asset e on e.asset_id = g.asset_id
left join m_rank f on f.rank_id = g.rank_id) tam group by tam.account_code_name ");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
WareHouseMainVo outVo = new WareHouseMainVo
{
// , h., i., k., o.prodution_work_content_name
TotalAccumDepreication = double.Parse(dataReader["Total_AccumDepreication"].ToString()),
TotalAcquisitionCose = double.Parse(dataReader["Total_AcquisitionCose"].ToString()),
TotalCurrentDepreication = double.Parse(dataReader["Total_CurrentDepreication"].ToString()),
TotalMonthlyDepreication = double.Parse(dataReader["Total_MonthlyDepreication"].ToString()),
TotalNetBook = double.Parse(dataReader["Total_NetBook"].ToString()),
AccountCodeName = dataReader["Account_Name"].ToString(),
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
private void GridBind()
{
try
{
WareHouseMainVo whvos = new WareHouseMainVo()
{
AssetCode = asset_Code_txt.Text,
RankCode = rank_code_cbm.Text,
AssetType = asset_type_cbm.Text,
AccountCodeCode = detail_position_cmb.Text,
AccountLocationCode = select_search_cbm.Text,
AssetInvoice = invoice_cbm.Text,
AssetModel = asset_model_cbm.Text,
AfterLocationCd = location_cbm.Text,
AssetName = asset_name_cbm.Text,
DetailPositionCd = detail_position_cmb.Text,
LabelStatus = labelstatus_cmb.Text,
Net_Value = net_value_cmb.Text,
AssetPO = AssetPO_cmb.Text,
};
if (checkdata())
{
if (select_search_cbm.Text == "Search History")
{
ValueObjectList <WareHouseMainVo> listvo = (ValueObjectList <WareHouseMainVo>)DefaultCbmInvoker.Invoke(new SearchWareHouseMainCbm(), whvos);
warehouse_main_dgv.DataSource = listvo.GetList();
}
else if (select_search_cbm.Text == "Search List")
{
ValueObjectList <WareHouseMainVo> listvo = (ValueObjectList <WareHouseMainVo>)DefaultCbmInvoker.Invoke(new SearchListWareHouseMainCbm(), whvos);
warehouse_main_dgv.DataSource = listvo.GetList();
invertory_alarm();
counter();
}
// calculator();
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
void updatedatatodatabase()
{
if (warehouse_main_dgv.RowCount > 0)
{
WareHouseMainVo outVo = new WareHouseMainVo();
for (int i = 0; i < warehouse_main_dgv.RowCount; i++)
{
WareHouseMainVo inVo = new WareHouseMainVo()
{
WareHouseMainId = int.Parse(warehouse_main_dgv.Rows[i].Cells["colAcountMainId"].Value.ToString()),
CurrentDepreciation = double.Parse(warehouse_main_dgv.Rows[i].Cells["colCurrentDepreciation"].Value.ToString()),
MonthlyDepreciation = double.Parse(warehouse_main_dgv.Rows[i].Cells["colMonthlyDepreciation"].Value.ToString()),
AccumDepreciation = double.Parse(warehouse_main_dgv.Rows[i].Cells["colAccumDepreciation"].Value.ToString()),
NetValue = double.Parse(warehouse_main_dgv.Rows[i].Cells["colNetValue"].Value.ToString()),
};
outVo = (WareHouseMainVo)DefaultCbmInvoker.Invoke(new UpdateWareHouseMainDGVCbm(), inVo); //update code
}
}
}
private void Rank_Dep_btn_Click(object sender, EventArgs e)
{
account_depreciation_dgv.Visible = true;
warehouse_main_dgv.Visible = false;
account_depreciation_dgv.DataSource = null;
account_depreciation_dgv.Columns[0].HeaderText = "Rank Name";
try
{
WareHouseMainVo whvos = new WareHouseMainVo()
{
};
ValueObjectList <WareHouseMainVo> listvo = (ValueObjectList <WareHouseMainVo>)DefaultCbmInvoker.Invoke(new Cbm.TotalRankDEPWareHouseMainCbm(), whvos);
account_depreciation_dgv.DataSource = listvo.GetList();
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
private void user_location_code_txt_TextChanged(object sender, EventArgs e)
{
if ((user_location_code_txt.Text.Length == 13) || (user_location_code_txt.Text.Length == 10))
{
WareHouseMainVo inVo = new WareHouseMainVo()
{
UserTem = user_location_code_txt.Text
};
ValueObjectList <UserLocationVo> userlocationvo = (ValueObjectList <UserLocationVo>)DefaultCbmInvoker.Invoke(new GetUserLocationCbm(), new UserLocationVo {
UserLocationCode = inVo.UserTem
});
user_location_name_cmb.DisplayMember = "UserLocationName";
user_location_name_cmb.DataSource = userlocationvo.GetList();
}
else
{
user_location_name_cmb.Text = "";
user_location_name_cmb.SelectedItem = null;
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
WareHouseMainVo inVo = ( WareHouseMainVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <WareHouseMainVo> voList = new ValueObjectList <WareHouseMainVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select g.warehouse_main_id from t_warehouse_main g
left join m_asset e on e.asset_id = g.asset_id
where 1=1 ");
if (!String.IsNullOrEmpty(inVo.AssetCode))
{
sql.Append(@" and e.asset_cd =:asset_cd");
sqlParameter.AddParameterString("asset_cd", inVo.AssetCode);
}
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
WareHouseMainVo outVo = new WareHouseMainVo
{
WareHouseMainId = int.Parse(dataReader["warehouse_main_id"].ToString()),
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
WareHouseMainVo inVo = (WareHouseMainVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <WareHouseMainVo> voList = new ValueObjectList <WareHouseMainVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select k.unit_name,c.location_cd as before, j.location_cd as after, h.detail_postion_cd, d.user_location_name ,g.warehouse_main_history_id,c.location_cd,e.asset_cd, e.asset_no, e.asset_name, e.asset_model, e.asset_serial, e.asset_supplier,e.asset_po, e.asset_invoice,e.label_status, g.qty, a.account_code_cd, b.account_location_cd, f.rank_cd, b.account_location_name, g.comment_data, e.asset_life, e.acquistion_date, e.acquistion_cost, e.asset_type, g.depreciation_start, g.depreciation_end, g.current_depreciation,g.monthly_depreciation, g.accum_depreciation_now, g.net_value, g.registration_date_time, g.registration_user_cd from t_warehouse_main_history g
left join m_account_code a on a.account_code_id = g.account_code_id
left join m_account_location b on b.account_location_id = g.account_location_id
left join m_location c on c.location_id = g.before_location_id
left join m_location j on j.location_id = g.after_location_id
left join m_user_location d on d.user_location_id = g.user_location_id
left join m_asset e on e.asset_id = g.asset_id
left join m_rank f on f.rank_id = g.rank_id
left join m_detail_postion h on h.detail_postion_id = g.detail_position_id
left join m_unit k on k.unit_id = g.unit_id
where 1=1 ");
if (!String.IsNullOrEmpty(inVo.AssetCode))
{
sql.Append(@" and e.asset_cd =:asset_cd");
sqlParameter.AddParameterString("asset_cd", inVo.AssetCode);
}
if (!String.IsNullOrEmpty(inVo.RankCode))
{
sql.Append(" and f.rank_cd =:rank_cd");
sqlParameter.AddParameterString("rank_cd", inVo.RankCode);
}
if (!String.IsNullOrEmpty(inVo.AssetModel))
{
sql.Append(" and e.asset_model =:asset_model");
sqlParameter.AddParameterString("asset_model", inVo.AssetModel);
}
if (!String.IsNullOrEmpty(inVo.AssetName))
{
sql.Append(" and e.asset_name =:asset_name");
sqlParameter.AddParameterString("asset_name", inVo.AssetName);
}
if (!String.IsNullOrEmpty(inVo.AssetType))
{
sql.Append(" and e.asset_type =:asset_type");
sqlParameter.AddParameterString("asset_type", inVo.AssetType);
}
if (!String.IsNullOrEmpty(inVo.AssetInvoice))
{
sql.Append(" and e.asset_invoice =:asset_invoice");
sqlParameter.AddParameterString("asset_invoice", inVo.AssetInvoice);
}
if (!String.IsNullOrEmpty(inVo.AfterLocationCd))
{
sql.Append(" and j.location_cd =:location_cd");
sqlParameter.AddParameterString("location_cd", inVo.AfterLocationCd);
}
if (!String.IsNullOrEmpty(inVo.DetailPositionCd))
{
sql.Append(" and h.detail_postion_cd =:detail_postion_cd");
sqlParameter.AddParameterString("detail_postion_cd", inVo.DetailPositionCd);
}
if (!String.IsNullOrEmpty(inVo.LabelStatus))//label status
{
sql.Append(" and e.label_status =:label_status");
sqlParameter.AddParameterString("label_status", inVo.LabelStatus);
}
if (!String.IsNullOrEmpty(inVo.AssetPO))//label status
{
sql.Append(" and e.asset_po =:asset_po");
sqlParameter.AddParameterString("asset_po", inVo.AssetPO);
}
//if (!String.IsNullOrEmpty(inVo.Net_Value))//search theo net value
//{
// if (inVo.Net_Value == "0$")
// {
// sql.Append(" and g.net_value = 0");
// }
// else if (inVo.Net_Value == "1$")
// {
// sql.Append(" and g.net_value > 0 and g.net_value <2 ");
// }
//}
sql.Append(" order by g.registration_date_time desc");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
WareHouseMainVo outVo = new WareHouseMainVo
{
// , h., i., k., o.prodution_work_content_name
WareHouseMainId = int.Parse(dataReader["warehouse_main_history_id"].ToString()),
AfterLocationCd = dataReader["after"].ToString(),
BeforeLocationCd = dataReader["before"].ToString(),
DetailPositionCd = dataReader["detail_postion_cd"].ToString(),
AssetCode = dataReader["asset_cd"].ToString(),
AssetNo = int.Parse(dataReader["asset_no"].ToString()),
AssetName = dataReader["asset_name"].ToString(),
AssetModel = dataReader["asset_model"].ToString(),
AssetSerial = dataReader["asset_serial"].ToString(),
AssetSupplier = dataReader["asset_supplier"].ToString(),
QTY = int.Parse(dataReader["qty"].ToString()),
UnitName = dataReader["unit_name"].ToString(),
UserLocationName = dataReader["user_location_name"].ToString(),
AccountCodeCode = dataReader["account_code_cd"].ToString(),
AccountLocationCode = dataReader["account_location_cd"].ToString(),
RankCode = dataReader["rank_cd"].ToString(),
AccountLocationName = dataReader["account_location_name"].ToString(),
CommnetsData = dataReader["comment_data"].ToString(),
AssetLife = int.Parse(dataReader["asset_life"].ToString()),
AcquisitionDate = DateTime.Parse(dataReader["acquistion_date"].ToString()),
AcquisitionCost = double.Parse(dataReader["acquistion_cost"].ToString()),
StartDepreciation = DateTime.Parse(dataReader["depreciation_start"].ToString()),
EndDepreciation = DateTime.Parse(dataReader["depreciation_end"].ToString()),
CurrentDepreciation = double.Parse(dataReader["current_depreciation"].ToString()),
MonthlyDepreciation = double.Parse(dataReader["monthly_depreciation"].ToString()),
AccumDepreciation = double.Parse(dataReader["accum_depreciation_now"].ToString()),
NetValue = double.Parse(dataReader["net_value"].ToString()),
AssetType = dataReader["asset_type"].ToString(),
AssetInvoice = (dataReader["asset_invoice"].ToString()),
LabelStatus = (dataReader["label_status"].ToString()),
AssetPO = dataReader["asset_po"].ToString(),
RegistrationDateTime = DateTime.Parse(dataReader["registration_date_time"].ToString()),
RegistrationUserCode = (dataReader["registration_user_cd"].ToString()),
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
private void ok_btn_Click(object sender, EventArgs e)
{
if (Checkdata())
{
InvertoryVo CheckTimeIdVo = (InvertoryVo)DefaultCbmInvoker.Invoke(new GetMaxCheckTimeIdCbm(), new InvertoryVo());
WareHouseMainVo outVo1 = new WareHouseMainVo();
WareHouseMainVo outVo2 = new WareHouseMainVo();
WareHouseMainVo inVo = new WareHouseMainVo()
{
WareHouseMainId = WareHouseMainVo.WareHouseMainId,
///
BeforeLocationId = ((LocationVo)this.cmbBeforeLocation.SelectedItem).LocationId,
DetailPositionId = ((DetailPositionVo)this.cmbDetailPosition.SelectedItem).DetailPositionId,
AfterLocationId = ((LocationVo)this.cmbAfterLocation.SelectedItem).LocationId,
AssetId = ((AssetVo)this.cmbNoNumber.SelectedItem).AssetId,
QTY = Int16.Parse(txtqty.Text),
UnitId = ((UnitVo)cmbUnit.SelectedItem).UnitId,
AssetNo = Int16.Parse(cmbNoNumber.Text),
AccountCodeId = ((AccountCodeVo)this.cmbAccountCode.SelectedItem).AccountCodeId,
AccountLocationId = ((AccountLocationVo)this.cmbSectionCode.SelectedItem).AccountLocationId,
RankId = ((RankVo)this.cmbRankCode.SelectedItem).RankId,
CommnetsData = txtComment.Text,
StartDepreciation = dtpStartDepreciation.Value,
EndDepreciation = dtpEndDepreciation.Value,
CurrentDepreciation = double.Parse(txtCurrentDepreciation.Text),
MonthlyDepreciation = double.Parse(txtMonthlyDepreciation.Text),
AccumDepreciation = double.Parse(txtAccumDepreciation.Text),
NetValue = double.Parse(txtNetValue.Text),
// LocationId = ((LocationVo)this.location_cmb.SelectedItem).LocationId,
UserLocationId = ((UserLocationVo)this.cmbUserName.SelectedItem).UserLocationId,
RegistrationDateTime = DateTime.Now,
FactoryCode = UserData.GetUserData().FactoryCode,
RegistrationUserCode = UserData.GetUserData().UserCode,
InvertoryId = CheckTimeIdVo.InvertoryTimeId,
};
try
{
if (inVo.WareHouseMainId > 0) //update
{
outVo1 = (WareHouseMainVo)DefaultCbmInvoker.Invoke(new UpdateWareHouseMainCbm(), inVo); //sai
outVo2 = (WareHouseMainVo)DefaultCbmInvoker.Invoke(new AddWareHouseHistoryMainCbm(), inVo);
}
else//add
{
outVo1 = (WareHouseMainVo)DefaultCbmInvoker.Invoke(new AddWareHouseMainCbm(), inVo);
outVo2 = (WareHouseMainVo)DefaultCbmInvoker.Invoke(new AddWareHouseHistoryMainCbm(), inVo);
if (outVo1.AffectedCount > 0)
{
ValueObjectList <WareHouseMainVo> outVoWareHouse = (ValueObjectList <WareHouseMainVo>)DefaultCbmInvoker.Invoke(new GetWarehouseMainIdCbm(), new WareHouseMainVo()
{
AssetCode = txtAssetCode.Text
});
InvertoryVo outVoCheckTime = new InvertoryVo();
InvertoryVo inVoCheckTime = new InvertoryVo()
{
WarehouseMainId = outVoWareHouse.GetList()[0].WareHouseMainId,
InvertoryTimeId = CheckTimeIdVo.InvertoryTimeId,
InvertoryValue = true,
RegistrationUserCode = UserData.GetUserData().UserName,
FactoryCode = UserData.GetUserData().FactoryCode,
LocationID = ((LocationVo)this.cmbAfterLocation.SelectedItem).LocationId,
};
outVoCheckTime = (InvertoryVo)DefaultCbmInvoker.Invoke(new AddInvertoryCheckCbm(), inVoCheckTime);
}
cmbUnit.Text = "";
txtAssetCode.Text = "";
}
AccountMainVo accountOutVo = new AccountMainVo();
accountOutVo = (AccountMainVo)DefaultCbmInvoker.Invoke(new UpdateItemAccountMainCbm(), new AccountMainVo()
{
AssetId = inVo.AssetId, LocationId = inVo.AfterLocationId, RankId = inVo.RankId, UserLocationId = inVo.UserLocationId, RegistrationUserCode = inVo.RegistrationUserCode, RegistrationDateTime = DateTime.Now,
});
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
if (outVo1.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, asset_code_lbl.Text + " : " + txtAssetCode.Text);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
return;
}
if (outVo2.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, asset_code_lbl.Text + " : " + txtAssetCode.Text);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
return;
}
}
}
void addandupdate()
{
InvertoryVo checkvo = new InvertoryVo();
asset_Code_cmb.Select();
InvertoryCheck_dgv.DataSource = null;
string str = asset_Code_cmb.Text;
string[] arrListStr = str.Split(',');
assetcodetrim = arrListStr[0];
//sua lai, doi warehouse va accout id thanh asset_id
//sua database t_invertory_equipments doi warehouse id thanh asset_id
ValueObjectList <WareHouseMainVo> Wlistvo = (ValueObjectList <WareHouseMainVo>)DefaultCbmInvoker.Invoke(new Cbm.GetWarehouseMainIdCbm(), new WareHouseMainVo()
{
AssetCode = assetcodetrim,
});
List <WareHouseMainVo> Wlist = Wlistvo.GetList();
ValueObjectList <AccountMainVo> alistvo = (ValueObjectList <AccountMainVo>)DefaultCbmInvoker.Invoke(new Cbm.GetAccountMainIdCbm(), new AccountMainVo()
{
AssetCode = assetcodetrim,
});
List <AccountMainVo> alist = alistvo.GetList();
if (checkdata())
{
for (int i = 0; i < Wlist.Count; i++)
{
WareHouseMainVo w = Wlist[i];
AccountMainVo a = alist[i];
InvertoryVo outVo = new InvertoryVo();
InvertoryVo inVo = new InvertoryVo()
{
WarehouseMainId = w.WareHouseMainId,
AccountMainId = a.AcountMainId,
InvertoryTimeId = ((InvertoryVo)this.InvertoryTimeCode_cbm.SelectedItem).InvertoryTimeId,
InvertoryValue = true,
RegistrationUserCode = UserData.GetUserData().UserName,
FactoryCode = UserData.GetUserData().FactoryCode,
LocationID = ((LocationVo)this.location_cbm.SelectedItem).LocationId,
// RankID = ((RankVo)this.rank_name_cbm.SelectedItem).RankId,
};
try
{
checkvo = (InvertoryVo)DefaultCbmInvoker.Invoke(new CheckInvertoryRowCbm(), inVo);
if (checkvo.AffectedCount == 1)
{
mess += assetcodetrim + " is checked into " + InvertoryTimeCode_cbm.Text + "\n";
//if(i == Wlist.Count -1)
//{
// MessageBox.Show(mess, "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
//}
//MessageBox.Show("This machine:" + assetcodetrim + " is checked into " + InvertoryTimeCode_cbm.Text, "Messager", MessageBoxButtons.OK, MessageBoxIcon.Information);
thongbao++;
}
if (checkvo.AffectedCount == 0)
{
outVo = (InvertoryVo)DefaultCbmInvoker.Invoke(new AddInvertoryCheckCbm(), inVo);
outVo = (InvertoryVo)DefaultCbmInvoker.Invoke(new UpdateWHInvertoryCheckCbm(), inVo);
outVo = (InvertoryVo)DefaultCbmInvoker.Invoke(new UpdateACCInvertoryCheckCbm(), inVo);
// outVo = (InvertoryVo)DefaultCbmInvoker.Invoke(new UpdateACCRankCheckCbm(), inVo);
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
if (test == "b")
{
colRankNameNowTextBox.Visible = false;
colRankNameNow.Visible = true;
ValueObjectList <RankVo> rankcode = (ValueObjectList <RankVo>)DefaultCbmInvoker.Invoke(new GetRankCbm(), new RankVo());
colRankNameNow.DisplayMember = "RankName";
colRankNameNow.DataSource = rankcode.GetList();
}
else
{
assetcodetrim = "";
}
}
}
