private void GridBind()
{
try
{
AccountMainVo whvos = new AccountMainVo()
{
AssetCode = asset_Code_txt.Text,
RankCode = rank_code_cbm.Text,
AssetType = asset_type_cbm.Text,
AccountCodeCode = account_code_cmb.Text,
AccountLocationCode = section_cd_cmb.Text,
AssetInvoice = invoice_cbm.Text,
AssetModel = asset_model_cbm.Text,
LocationCode = location_cbm.Text,
AssetName = asset_name_cbm.Text,
LabelStatus = labelstatus_cmb.Text,
Net_Value = net_value_cmb.Text,
AssetPO = AssetPO_cmb.Text,
//AssetNo =
};
if (checkdata())
{
ValueObjectList <AccountMainVo> listvo = (ValueObjectList <AccountMainVo>)DefaultCbmInvoker.Invoke(new SeachAccountMainCbm(), whvos);
account_main_dgv.DataSource = listvo.GetList();
// calculator();
// ReviewStatusLable();
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
private void GridBind()
{
try
{
AccountMainVo whvos = new AccountMainVo()
{
AssetCode = asset_Code_txt.Text,
RankCode = rank_code_cbm.Text,
AssetType = asset_type_cbm.Text,
AccountCodeCode = account_code_cmb.Text,
AccountLocationCode = section_cd_cmb.Text,
AssetInvoice = invoice_cbm.Text,
AssetModel = asset_model_cbm.Text,
LocationCode = location_cbm.Text,
AssetName = asset_name_cbm.Text,
//AssetNo =
};
ValueObjectList <AccountMainVo> listvo = (ValueObjectList <AccountMainVo>)DefaultCbmInvoker.Invoke(new Cbm.SeachAccountMainCbm(), whvos);
account_main_dgv.DataSource = listvo.GetList();
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
AccountMainVo inVo = (AccountMainVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append(@"update t_account_main set current_depreciation =:current_depreciation,
monthly_depreciation=:monthly_depreciation,
accum_depreciation_now =:accum_depreciation_now,
net_value =:net_value ");
sql.Append(" where account_main_id =:account_main_id");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameter("account_main_id", inVo.AcountMainId);
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
AccountMainVo outVo = new AccountMainVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
private void ok_btn_Click(object sender, EventArgs e)
{
if (Checkdata())
{
AccountMainVo outVo = new AccountMainVo();
AccountMainVo inVo = new AccountMainVo()
{
AcountMainId = accountmainVo.AcountMainId,
///
AssetId = ((AssetVo)this.no_cbm.SelectedItem).AssetId,
QTY = Int16.Parse(qty_txt.Text),
UnitId = ((UnitVo)unit_cmb.SelectedItem).UnitId,
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.AcountMainId > 0)
{
outVo = (AccountMainVo)DefaultCbmInvoker.Invoke(new Cbm.UpdateAccountMainCbm(), inVo);
// outVo = (WareHouseVo)DefaultCbmInvoker.Invoke(new Cbm.AddWareHouseCbm(), inVo);
}
else
{
outVo = (AccountMainVo)DefaultCbmInvoker.Invoke(new Cbm.AddAccountMainCbm(), 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;
}
unit_cmb.Text = "";
}
}
private void update_btn_Click(object sender, EventArgs e)
{
if (account_main_dgv.SelectedCells.Count > 0)
{
AccountMainVo selectedvo = (AccountMainVo)account_main_dgv.CurrentRow.DataBoundItem;
if (new AddAcountMainForm {
accountmainVo = selectedvo,
}.ShowDialog() == DialogResult.OK)
{
GridBind();
}
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
AccountMainVo inVo = (AccountMainVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <AccountMainVo> voList = new ValueObjectList <AccountMainVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select tam.rank_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, f.rank_name,g.account_main_id,c.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_account_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.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.rank_name ");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
AccountMainVo outVo = new AccountMainVo
{
// , 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);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
AccountMainVo inVo = (AccountMainVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append(@"insert into t_account_main(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, location_id, user_location_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, :location_id, :user_location_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("user_location_id", inVo.UserLocationId);
sqlParameter.AddParameter("registration_user_cd", inVo.RegistrationUserCode);
sqlParameter.AddParameter("registration_date_time", inVo.RegistrationDateTime);
sqlParameter.AddParameter("factory_cd", inVo.FactoryCode);
//execute SQL
AccountMainVo outVo = new AccountMainVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
void updatedatatodatabase()
{
if (account_main_dgv.RowCount > 0)
{
AccountMainVo outVo = new AccountMainVo();
for (int i = 0; i < account_main_dgv.RowCount; i++)
{
AccountMainVo inVo = new AccountMainVo()
{
AcountMainId = int.Parse(account_main_dgv.Rows[i].Cells["colAcountMainId"].Value.ToString()),
CurrentDepreciation = double.Parse(account_main_dgv.Rows[i].Cells["colCurrentDepreciation"].Value.ToString()),
MonthlyDepreciation = double.Parse(account_main_dgv.Rows[i].Cells["colMonthlyDepreciation"].Value.ToString()),
AccumDepreciation = double.Parse(account_main_dgv.Rows[i].Cells["colAccumDepreciation"].Value.ToString()),
NetValue = double.Parse(account_main_dgv.Rows[i].Cells["colNetValue"].Value.ToString()),
};
outVo = (AccountMainVo)DefaultCbmInvoker.Invoke(new UpdateAccountMainDGVCbm(), inVo);
}
}
}
private void Rank_Dep_btn_Click(object sender, EventArgs e)
{
account_depreciation_dgv.Visible = true;
account_main_dgv.Visible = false;
account_depreciation_dgv.DataSource = null;
account_depreciation_dgv.Columns[0].HeaderText = "Rank Name";
try
{
AccountMainVo whvos = new AccountMainVo()
{
};
ValueObjectList <AccountMainVo> listvo = (ValueObjectList <AccountMainVo>)DefaultCbmInvoker.Invoke(new TotalRankDEPAccountMainCbm(), 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))
{
AccountMainVo inVo = new AccountMainVo()
{
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)
{
AccountMainVo inVo = (AccountMainVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <AccountMainVo> voList = new ValueObjectList <AccountMainVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select g.account_main_id from t_account_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());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
AccountMainVo outVo = new AccountMainVo
{
// , h., i., k., o.prodution_work_content_name
AcountMainId = int.Parse(dataReader["account_main_id"].ToString()),
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
AccountMainVo inVo = (AccountMainVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append(@"update t_account_main set rank_id =:rank_id,
location_id =:location_id,
user_location_id =:user_location_id,
registration_user_cd =:registration_user_cd,
registration_date_time= :registration_date_time");
sql.Append(" where asset_id =:asset_id");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
//sqlParameter.AddParameter("asset_id", inVo.AcountMainId);
sqlParameter.AddParameter("asset_id", inVo.AssetId);
sqlParameter.AddParameter("rank_id", inVo.RankId);
sqlParameter.AddParameter("location_id", inVo.LocationId);
sqlParameter.AddParameter("user_location_id", inVo.UserLocationId);
sqlParameter.AddParameter("registration_user_cd", inVo.RegistrationUserCode);
sqlParameter.AddParameter("registration_date_time", inVo.RegistrationDateTime);
//execute SQL
AccountMainVo outVo = new AccountMainVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
AccountMainVo inVo = (AccountMainVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <AccountMainVo> voList = new ValueObjectList <AccountMainVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select g.unit, g.account_main_id,c.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_account_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.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
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.LocationCode))
{
sql.Append(" and c.location_cd =:location_cd");
sqlParameter.AddParameterString("location_cd", inVo.LocationCode);
}
if (!String.IsNullOrEmpty(inVo.AccountCodeCode))
{
sql.Append(" and a.account_code_cd =:account_code_cd");
sqlParameter.AddParameterString("account_code_cd", inVo.AccountCodeCode);
}
if (!String.IsNullOrEmpty(inVo.AccountLocationCode))
{
sql.Append(" and b.account_location_cd =:account_location_cd");
sqlParameter.AddParameterString("account_location_cd", inVo.AccountLocationCode);
}
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())
{
AccountMainVo outVo = new AccountMainVo
{
// , h., i., k., o.prodution_work_content_name
AcountMainId = int.Parse(dataReader["account_main_id"].ToString()),
LocationCode = dataReader["location_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()),
Unit = dataReader["unit"].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()),
AssetInvoice = (dataReader["asset_invoice"].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 = "";
}
}
}
