private void GridBind()
{
try
{
WareHouseVo whvos = new WareHouseVo()
{
AssetCode = asset_Code_txt.Text,
RankCode = rank_code_cbm.Text,
AssetModel = asset_model_cbm.Text,
AssetName = asset_name_cbm.Text,
Invoice = invoice_cbm.Text,
AfterLocation = select_after_location_cbm.Text,
AssetType = asset_type_cbm.Text
};
if (select_search_cbm.Text == "Search History")
{
ValueObjectList <WareHouseVo> listvo = (ValueObjectList <WareHouseVo>)DefaultCbmInvoker.Invoke(new Cbm.SeachWareHouseCbm(), whvos);
ware_house_dgv.DataSource = listvo.GetList();
}
else if (select_search_cbm.Text == "Search List")
{
ValueObjectList <WareHouseVo> listvo = (ValueObjectList <WareHouseVo>)DefaultCbmInvoker.Invoke(new Cbm.SearchListWareHouseCbm(), whvos);
ware_house_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)
{
ValueObjectList <WareHouseVo> voList = new ValueObjectList <WareHouseVo>();
StringBuilder sql = new StringBuilder();
//CREATE SQL ADAPTER AND PARAMETER LIST
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("select distinct asset_type from m_asset order by asset_type");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
sql.Clear();
//EXECUTE READER FROM COMMAND
IDataReader datareader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (datareader.Read())
{
WareHouseVo outVo = new WareHouseVo
{
asset_type = datareader["asset_type"].ToString(),
};
voList.add(outVo);
}
datareader.Close();
return(voList);
}
private void GridBind()
{
try
{
WareHouseVo whvos = new WareHouseVo()
{
asset_type = cmbAssetType.Text,
asset_cd = txtAssetCode.Text,
asset_model = txtAssetModel.Text,
asset_name = cmbAssetName.Text,
rank_cd = cmbRankCode.Text,
location_cd = cmbLocation.Text,
net_value = cmbNetValue.Text,
asset_invoice = cmbInvoiceNo.Text,
label_status = cmbLabelStatus.Text,
invertory_time_cd = cmbInventory.Text,
};
ValueObjectList <WareHouseVo> whData = (ValueObjectList <WareHouseVo>)DefaultCbmInvoker.Invoke(new SearchWareHouseCbm(), whvos);
//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 (ware_house_dgv.SelectedCells.Count > 0)
{
WareHouseVo selectedvo = (WareHouseVo)ware_house_dgv.CurrentRow.DataBoundItem;
if (new AddWareHouseForm {
warehousevo = selectedvo,
}.ShowDialog() == DialogResult.OK)
{
GridBind();
}
}
}
private void ok_btn_Click(object sender, EventArgs e)
{
// WareHouseVo f = new WareHouseVo();
if (checkdata())
{
WareHouseVo outVo = new WareHouseVo();
WareHouseVo inVo = new WareHouseVo()
{
WareHouseId = warehousevo.WareHouseId,
AssetCode = asset_code_txt.Text,
RankId = ((RankVo)this.rank_name_cmb.SelectedItem).RankId,
Qty = Int16.Parse(qty_txt.Text),
Unit = unit_cmb.Text,
UserLocationCode = user_location_code_txt.Text,
TimeStart = timestart_dtp.Value,
BeforeLocation = ((LocationVo)this.before_location_cmb.SelectedItem).LocationCode,
AfterLocation = after_location_cmb.Text,
Comments = comments_txt.Text,
RegistrationUserCode = UserData.GetUserData().UserCode,
FactoryCode = UserData.GetUserData().FactoryCode,
RegistrationDateTime = DateTime.Now
};
try
{
if (inVo.WareHouseId > 0)
{
// outVo = (WareHouseVo)DefaultCbmInvoker.Invoke(new Cbm.UpdateWareHouseUserCbm(), inVo);
outVo = (WareHouseVo)DefaultCbmInvoker.Invoke(new Cbm.AddWareHouseCbm(), inVo);
}
else
{
outVo = (WareHouseVo)DefaultCbmInvoker.Invoke(new Cbm.AddWareHouseCbm(), 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 AddWareHouseForm_Load(object sender, EventArgs e)
{
WareHouseVo whvo = new WareHouseVo();
//load rank name
ValueObjectList <RankVo> rankname = (ValueObjectList <RankVo>)DefaultCbmInvoker.Invoke(new GetRankCbm(), new RankVo());
rank_name_cmb.DisplayMember = "RankName";
rank_name_cmb.DataSource = rankname.GetList();
//before_location_cmb load
LocationVo Locationvo = (LocationVo)DefaultCbmInvoker.Invoke(new GetLocationMasterMntCbm(), new LocationVo());
before_location_cmb.DisplayMember = "LocationCode";
before_location_cmb.DataSource = Locationvo.LocationListVo;
qty_txt.Text = "1";
unit_cmb.Items.Add("m");
unit_cmb.Items.Add("pcs");
unit_cmb.Items.Add("box");
unit_cmb.Items.Add("pallet");
unit_cmb.Items.Add("unit");
user_location_name_cbm.Enabled = false;
comments_txt.Enabled = true;
if (warehousevo.WareHouseId > 0)
{
asset_code_txt.Enabled = false;
timestart_dtp.Enabled = false;
unit_cmb.Enabled = false;
asset_code_txt.Text = warehousevo.AssetCode;
rank_name_cmb.Text = warehousevo.RankName;
qty_txt.Text = warehousevo.Qty.ToString();
unit_cmb.Text = warehousevo.Unit;
before_location_cmb.Text = warehousevo.BeforeLocation;
after_location_cmb.Text = warehousevo.AfterLocation;
timestart_dtp.Value = warehousevo.TimeStart;
this.TitleText = Com.Nidec.Mes.GlobalMasterMaintenance.CommonConstants.MODE_UPDATE;
}
else
{
comments_txt.Text = "Add";
this.TitleText = Com.Nidec.Mes.GlobalMasterMaintenance.CommonConstants.MODE_ADD;
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
WareHouseVo inVo = (WareHouseVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append(@"update t_warehouse set rank_id=:rank_id,
qty=:qty,
location_before_cd=:location_before_cd,
location_after_cd=:location_after_cd,
user_location_cd=:user_location_cd,
comments_remake=:comments_remake,
registration_date_time= :registration_date_time
");
sql.Append(" where warehouse_id =:warehouse_id");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameter("warehouse_id", inVo.WareHouseId);
sqlParameter.AddParameter("asset_cd", inVo.AssetCode);
sqlParameter.AddParameter("rank_id", inVo.RankId);
sqlParameter.AddParameter("qty", inVo.Qty);
sqlParameter.AddParameter("unit", inVo.Unit);
sqlParameter.AddParameter("user_location_cd", inVo.UserLocationCode);
sqlParameter.AddParameterDateTime("time_start", inVo.TimeStart);
sqlParameter.AddParameter("location_before_cd", inVo.BeforeLocation);
sqlParameter.AddParameter("location_after_cd", inVo.AfterLocation);
sqlParameter.AddParameter("comments_remake", inVo.Comments);
sqlParameter.AddParameter("registration_user_cd", inVo.RegistrationUserCode);
sqlParameter.AddParameter("registration_date_time", inVo.RegistrationDateTime);
sqlParameter.AddParameter("factory_cd", inVo.FactoryCode);
//execute SQL
WareHouseVo outVo = new WareHouseVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
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))
{
WareHouseVo inVo = new WareHouseVo()
{
UserTem = user_location_code_txt.Text
};
ValueObjectList <UserLocationVo> userlocationvo = (ValueObjectList <UserLocationVo>)DefaultCbmInvoker.Invoke(new GetUserLocationCbm(), new UserLocationVo {
UserLocationCode = inVo.UserTem
});
user_location_name_cbm.DisplayMember = "UserLocationName";
user_location_name_cbm.DataSource = userlocationvo.GetList();
}
else
{
user_location_name_cbm.Text = "";
user_location_name_cbm.SelectedItem = null;
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
WareHouseVo inVo = (WareHouseVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <WareHouseVo> voList = new ValueObjectList <WareHouseVo>();
//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.asset_cd))
{
sql.Append(@" and e.asset_cd =:asset_cd");
sqlParameter.AddParameterString("asset_cd", inVo.asset_cd);
}
if (!String.IsNullOrEmpty(inVo.rank_cd))
{
sql.Append(" and f.rank_cd =:rank_cd");
sqlParameter.AddParameterString("rank_cd", inVo.rank_cd);
}
if (!String.IsNullOrEmpty(inVo.asset_model))
{
sql.Append(" and e.asset_model =:asset_model");
sqlParameter.AddParameterString("asset_model", inVo.asset_model);
}
if (!String.IsNullOrEmpty(inVo.asset_name))
{
sql.Append(" and e.asset_name =:asset_name");
sqlParameter.AddParameterString("asset_name", inVo.asset_name);
}
if (!String.IsNullOrEmpty(inVo.asset_type))
{
sql.Append(" and e.asset_type =:asset_type");
sqlParameter.AddParameterString("asset_type", inVo.asset_type);
}
if (!String.IsNullOrEmpty(inVo.asset_invoice))
{
sql.Append(" and e.asset_invoice =:asset_invoice");
sqlParameter.AddParameterString("asset_invoice", inVo.asset_invoice);
}
if (!String.IsNullOrEmpty(inVo.location_cd))
{
sql.Append(" and j.location_cd =:location_cd");
sqlParameter.AddParameterString("location_cd", inVo.location_cd);
}
//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.label_status))//label status
{
sql.Append(" and e.label_status =:label_status");
sqlParameter.AddParameterString("label_status", inVo.label_status);
}
//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())
{
WareHouseVo outVo = new WareHouseVo
{
// , 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);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
WareHouseVo inVo = (WareHouseVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <WareHouseVo> voList = new ValueObjectList <WareHouseVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select d.warehouse_id, d.asset_cd, b.rank_name,b.rank_cd,d.time_start, a.asset_name, a.asset_model, a.asset_type, a.asset_invoice, d.comments_remake, a.asset_supplier, d.qty, d.unit, c.user_location_name, d.registration_date_time, d.location_before_cd, d.location_after_cd from t_warehouse d
left join m_asset a on a.asset_cd = d.asset_cd
left join m_rank b on b.rank_id = d.rank_id
left join m_user_location c on c.user_location_cd = d.user_location_cd
where 1=1 ");
if (!String.IsNullOrEmpty(inVo.AssetCode))
{
sql.Append(@" and d.asset_cd =:asset_cd");
sqlParameter.AddParameterString("asset_cd", inVo.AssetCode);
}
if (!String.IsNullOrEmpty(inVo.RankCode))
{
sql.Append(" and b.rank_cd =:rank_cd");
sqlParameter.AddParameterString("rank_cd", inVo.RankCode);
}
if (!String.IsNullOrEmpty(inVo.AssetModel))
{
sql.Append(" and a.asset_model =:asset_model");
sqlParameter.AddParameterString("asset_model", inVo.AssetModel);
}
if (!String.IsNullOrEmpty(inVo.AssetName))
{
sql.Append(" and a.asset_name =:asset_name");
sqlParameter.AddParameterString("asset_name", inVo.AssetName);
}
if (!String.IsNullOrEmpty(inVo.AssetType))
{
sql.Append(" and a.asset_type =:asset_type");
sqlParameter.AddParameterString("asset_type", inVo.AssetType);
}
if (!String.IsNullOrEmpty(inVo.Invoice))
{
sql.Append(" and a.asset_invoice =:asset_invoice");
sqlParameter.AddParameterString("asset_invoice", inVo.Invoice);
}
if (!String.IsNullOrEmpty(inVo.AfterLocation))
{
sql.Append(" and d.location_after_cd =:location_after_cd");
sqlParameter.AddParameterString("location_after_cd", inVo.AfterLocation);
}
sql.Append(" and d.warehouse_id in(select Max(warehouse_id) from t_warehouse group by asset_cd) ");
sql.Append(" order by d.registration_date_time desc");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
WareHouseVo outVo = new WareHouseVo
{
// , h., i., k., o.prodution_work_content_name
WareHouseId = int.Parse(dataReader["warehouse_id"].ToString()),
TimeStart = DateTime.Parse(dataReader["time_start"].ToString()),
AssetCode = dataReader["asset_cd"].ToString(),
RankName = dataReader["rank_name"].ToString(),
AssetName = dataReader["asset_name"].ToString(),
Qty = int.Parse(dataReader["qty"].ToString()),
Unit = dataReader["unit"].ToString(),
AssetModel = dataReader["asset_model"].ToString(),
AssetSupplier = dataReader["asset_supplier"].ToString(),
AssetType = dataReader["asset_type"].ToString(),
UserLocationName = dataReader["user_location_name"].ToString(),
Comments = dataReader["comments_remake"].ToString(),
RegistrationDateTime = DateTime.Parse(dataReader["registration_date_time"].ToString()),
BeforeLocation = dataReader["location_before_cd"].ToString(),
AfterLocation = dataReader["location_after_cd"].ToString(),
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
