private void AddMachineStatusForm_Load(object sender, EventArgs e)
{
LocationVo Locationvo = (LocationVo)DefaultCbmInvoker.Invoke(new GetLocationMasterMntCbm(), new LocationVo());
section_cbm.DataSource = Locationvo.LocationListVo;
section_cbm.DisplayMember = "LocationCode";
}
/// <summary>
/// Fills all user records to gridview control
/// </summary>
private void GridBind(LocationVo conditionInVo)
{
Location_dgv.DataSource = null;
try
{
LocationVo outVo = (LocationVo)base.InvokeCbm(new GetLocationMasterMntCbm(), conditionInVo, false);
Location_dgv.AutoGenerateColumns = false;
BindingSource bindingSource1 = new BindingSource(outVo.LocationListVo, null);
if (bindingSource1 != null && bindingSource1.Count > 0)
{
Location_dgv.DataSource = bindingSource1;
}
else
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
Location_dgv.ClearSelection();
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)
{
LocationVo inVo = (LocationVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <LocationVo> voList = new ValueObjectList <LocationVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"SELECT distinct location_cd from m_location order by location_cd");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
LocationVo outVo = new LocationVo
{
LocationCode = dataReader["location_cd"].ToString()
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
/// <summary>
/// selects user record for updation and show user form
/// </summary>
private void BindUpdateLocationData()
{
int selectedrowindex = Location_dgv.SelectedCells[0].RowIndex;
LocationVo cavInVo = (LocationVo)Location_dgv.Rows[selectedrowindex].DataBoundItem;
AddLocationForm newAddForm = new AddLocationForm(CommonConstants.MODE_UPDATE, cavInVo);
newAddForm.ShowDialog(this);
if (newAddForm.IntSuccess > 0)
{
messageData = new MessageData("mmci00002", Properties.Resources.mmci00002, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind(FormConditionVo());
}
else if (newAddForm.IntSuccess == 0)
{
messageData = new MessageData("mmci00007", Properties.Resources.mmci00007, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind(FormConditionVo());
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
LocationVo inVo = (LocationVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Update m_location");
sqlQuery.Append(" Set ");
sqlQuery.Append(" location_name = :locationname, ");
sqlQuery.Append(" building_id = :buildingid ");
sqlQuery.Append(" Where ");
sqlQuery.Append(" location_id = :locationid ");
sqlQuery.Append(" and factory_cd = :faccd ;");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("locationid", inVo.LocationId);
sqlParameter.AddParameterString("locationname", inVo.LocationName);
sqlParameter.AddParameterInteger("buildingid", inVo.BuildingId);
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
LocationVo outVo = new LocationVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
private void before_location_cmb_SelectedIndexChanged(object sender, EventArgs e)
{
//location
LocationVo Locationvo = (LocationVo)DefaultCbmInvoker.Invoke(new GetLocationMasterMntCbm(), new LocationVo());
cmbAfterLocation.DataSource = Locationvo.LocationListVo;
cmbAfterLocation.DisplayMember = "LocationCode";
}
private void DetailPositionForm_Load(object sender, EventArgs e)
{
LocationVo Locationvo = (LocationVo)DefaultCbmInvoker.Invoke(new GetLocationMasterMntCbm(), new LocationVo());
locationcd_cbm.DataSource = Locationvo.LocationListVo;
locationcd_cbm.DisplayMember = "LocationCode";
locationcd_cbm.Text = "";
}
private void AddPlanWorkingStatusForm_Load(object sender, EventArgs e)
{
rate_txt.ReadOnly = true;
LocationVo Locationvo = (LocationVo)DefaultCbmInvoker.Invoke(new GetLocationMasterMntCbm(), new LocationVo());
section_cbm.DataSource = Locationvo.LocationListVo;
section_cbm.DisplayMember = "LocationCode";
}
/// <summary>
/// For setting selected user record into respective controls(textbox and combobox) for update operation
/// passing selected user data as parameter
/// </summary>
/// <param name="dgvMoldType"></param>
private void LoadUserData(LocationVo dgvMoldType)
{
if (dgvMoldType != null)
{
this.LocationCode_txt.Text = dgvMoldType.LocationCode;
this.LocationName_txt.Text = dgvMoldType.LocationName;
this.Building_cmb.SelectedValue = dgvMoldType.BuildingId.ToString();
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
LocationVo inVo = (LocationVo)arg;
StringBuilder sqlQuery = new StringBuilder();
//create SQL
sqlQuery.Append("Select Count(*) as locationCount from m_location ");
sqlQuery.Append(" where 1 = 1 ");
if (inVo.LocationCode != null)
{
sqlQuery.Append(" and UPPER(location_cd) = UPPER(:locationcd) ");
}
//if (inVo.BuildingId > 0)
//{
// sqlQuery.Append(" and building_id = :buildingid ");
//}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
if (inVo.LocationCode != null)
{
sqlParameter.AddParameterString("locationcd", inVo.LocationCode);
}
//if (inVo.BuildingId > 0)
//{
// sqlParameter.AddParameterInteger("buildingid", inVo.BuildingId);
//}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
LocationVo outVo = new LocationVo {
AffectedCount = 0
};
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["locationCount"]);
}
dataReader.Close();
return(outVo);
}
/// <summary>
/// Constructor for the form
/// </summary>
/// <param name="pmode"></param>
/// <param name="userItem"></param>
public AddLocationForm(string pmode, LocationVo userItem = null)
{
InitializeComponent();
mode = pmode;
updateData = userItem;
if (string.Equals(mode, CommonConstants.MODE_UPDATE))
{
this.Text = UpdateText_lbl.Text;
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
try
{
//VARIABLE
LocationVo inVo = (LocationVo)vo;
StringBuilder query = new StringBuilder();
ValueObjectList <LocationVo> listVo = new ValueObjectList <LocationVo>();
//CREATE SQL ADAPTER AND PARAMETER LIST
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, query.ToString());
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
//QUERY STRING
query.Append("Select * from m_location where 1=1 ");
if (inVo.location_id > 0 || inVo != null)
{
query.Append("and location_id='").Append(inVo.location_id).Append("' ");
}
if (string.IsNullOrEmpty(inVo.location_cd))
{
query.Append("and location_cd='").Append(inVo.location_cd).Append("' ");
}
query.Append("order by location_id");
//GET SQL ADAPTER
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, query.ToString());
//EXECUTE READER FROM COMMAND
IDataReader datareader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (datareader.Read())
{
LocationVo outVo = new LocationVo
{
location_id = (int)datareader["location_id"],
location_cd = datareader["location_cd"].ToString(),
location_name = datareader["location_name"].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();
}
}
private void AddUserLocationForm_Load(object sender, EventArgs e)
{
UserLocationCode_txt.Select();
if (vo.UserLocationId > 0)
{
UserLocationCode_txt.Text = vo.UserLocationCode;
UserLocationName_txt.Text = vo.UserLocationName;
}
LocationVo Locationvo = (LocationVo)DefaultCbmInvoker.Invoke(new GetLocationMasterMntCbm(), new LocationVo());
locationcode_cmb.DataSource = Locationvo.LocationListVo;
locationcode_cmb.DisplayMember = "LocationCode";
locationcode_cmb.Text = "";
}
/// <summary>
/// event to delete the selected record
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Delete_btn_Click(object sender, EventArgs e)
{
int selectedrowindex = Location_dgv.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = Location_dgv.Rows[selectedrowindex];
messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, selectedRow.Cells["colLocationCode"].Value.ToString());
logger.Info(messageData);
DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text);
if (dialogResult == DialogResult.OK)
{
LocationVo inVo = new LocationVo();
inVo.LocationId = Convert.ToInt32(selectedRow.Cells["colLocationId"].Value);
try
{
LocationVo outVo = (LocationVo)base.InvokeCbm(new DeleteLocationMasterMntCbm(), inVo, false);
if (outVo.AffectedCount > 0)
{
messageData = new MessageData("mmci00003", Properties.Resources.mmci00003, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind(FormConditionVo());
}
else if (outVo.AffectedCount == 0)
{
messageData = new MessageData("mmci00007", Properties.Resources.mmci00007, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind(FormConditionVo());
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
else if (dialogResult == DialogResult.Cancel)
{
//do something else
}
}
private void before_location_cmb_SelectedIndexChanged(object sender, EventArgs e)
{
//location
LocationVo Locationvo = (LocationVo)DefaultCbmInvoker.Invoke(new GetLocationMasterMntCbm(), new LocationVo());
after_location_cmb.DataSource = Locationvo.LocationListVo;
after_location_cmb.DisplayMember = "LocationCode";
ValueObjectList <DetailPositionVo> detailposition = (ValueObjectList <DetailPositionVo>)DefaultCbmInvoker.Invoke(new GetDetailPositionCbm(), new DetailPositionVo());
detail_position_cmb.DisplayMember = "DetailPositionCode";
detail_position_cmb.DataSource = detailposition.GetList();
detail_position_cmb.Text = "";
}
/// <summary>
/// checks duplicate mold Code
/// </summary>
/// <returns></returns>
private LocationVo DuplicateCheck(LocationVo LocationVo)
{
LocationVo outVo = new LocationVo();
try
{
outVo = (LocationVo)base.InvokeCbm(new CheckLocationMasterMntCbm(), LocationVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
return(outVo);
}
private void WareHouseForm_Load(object sender, EventArgs e)
{
//this.Width = Screen.PrimaryScreen.WorkingArea.Width;
//this.Height = Screen.PrimaryScreen.WorkingArea.Height - 300;
//this.ware_house_dgv.Height = Screen.PrimaryScreen.WorkingArea.Height - 300;
AcceptButton = search_btn;
select_search_cbm.Items.Add("Search History");
select_search_cbm.Items.Add("Search List");
select_search_cbm.Text = "Search History";
ware_house_dgv.ReadOnly = true;
ValueObjectList <RankVo> rankcode = (ValueObjectList <RankVo>)DefaultCbmInvoker.Invoke(new GetRankCbm(), new RankVo());
rank_code_cbm.DisplayMember = "RankCode";
rank_code_cbm.DataSource = rankcode.GetList();
rank_code_cbm.Text = "";
ValueObjectList <AssetVo> assetvotype = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetTypeCbm(), new AssetVo());
asset_type_cbm.DisplayMember = "AssetType";
asset_type_cbm.DataSource = assetvotype.GetList();
asset_type_cbm.Text = "";
ValueObjectList <AssetVo> assetvomodel = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetModelCbm(), new AssetVo());
asset_model_cbm.DisplayMember = "AssetModel";
asset_model_cbm.DataSource = assetvomodel.GetList();
asset_model_cbm.Text = "";
ValueObjectList <AssetVo> assetvoname = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetNameCbm(), new AssetVo());
asset_name_cbm.DisplayMember = "AssetName";
asset_name_cbm.DataSource = assetvoname.GetList();
asset_name_cbm.Text = "";
ValueObjectList <AssetVo> assetvoinvoice = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetInvoiceCbm(), new AssetVo());
invoice_cbm.DisplayMember = "AssetInvoice";
invoice_cbm.DataSource = assetvoinvoice.GetList();
invoice_cbm.Text = "";
LocationVo Locationvo = (LocationVo)DefaultCbmInvoker.Invoke(new GetLocationMasterMntCbm(), new LocationVo());
select_after_location_cbm.DisplayMember = "LocationCode";
select_after_location_cbm.DataSource = Locationvo.LocationListVo;
select_after_location_cbm.Text = "";
}
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 arg)
{
LocationVo inVo = (LocationVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Insert into m_location");
sqlQuery.Append(" ( ");
sqlQuery.Append(" location_cd, ");
sqlQuery.Append(" location_name, ");
sqlQuery.Append(" building_id, ");
sqlQuery.Append(" registration_user_cd, ");
sqlQuery.Append(" registration_date_time, ");
sqlQuery.Append(" factory_cd ");
sqlQuery.Append(" ) ");
sqlQuery.Append("VALUES ");
sqlQuery.Append(" ( ");
sqlQuery.Append(" :locationcd ,");
sqlQuery.Append(" :locationname ,");
sqlQuery.Append(" :buildingid ,");
sqlQuery.Append(" :registrationusercode ,");
sqlQuery.Append(" :registrationdatetime ,");
sqlQuery.Append(" :factorycode ");
sqlQuery.Append(" ); ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("locationcd", inVo.LocationCode);
sqlParameter.AddParameterString("locationname", inVo.LocationName);
sqlParameter.AddParameterInteger("buildingid", inVo.BuildingId);
sqlParameter.AddParameterString("registrationusercode", trxContext.UserData.UserCode);
sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime);
sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode);
LocationVo outVo = new LocationVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
/// <summary>
/// Creates seacrh condition as per user inputs
/// </summary>
/// <returns>search condition</returns>
private LocationVo FormConditionVo()
{
LocationVo inVo = new LocationVo();
if (LocationCode_txt.Text != string.Empty)
{
inVo.LocationCode = LocationCode_txt.Text;
}
if (LocationName_txt.Text != string.Empty)
{
inVo.LocationName = LocationName_txt.Text;
}
if (Building_cmb.SelectedIndex > -1)
{
inVo.BuildingId = Convert.ToInt32(Building_cmb.SelectedValue);
}
return(inVo);
}
/// <summary>
/// form country and factory data for combo
/// </summary>
private void FormDatatableFromVo()
{
locationDatatable = new DataTable();
locationDatatable.Columns.Add("id");
locationDatatable.Columns.Add("name");
try
{
LocationVo locationOutVo = (LocationVo)base.InvokeCbm(new GetLocationMasterMntCbm(), new LocationVo(), false);
foreach (LocationVo location in locationOutVo.LocationListVo)
{
locationDatatable.Rows.Add(location.LocationId, location.LocationName);
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
private void InvertoryCheckForm_Load(object sender, EventArgs e)
{
AcceptButton = Invertory_btn;
ValueObjectList <InvertoryVo> detailposition = (ValueObjectList <InvertoryVo>)DefaultCbmInvoker.Invoke(new GetInvertoryTimeCbm(), new InvertoryVo());
InvertoryTimeCode_cbm.DisplayMember = "InvertoryTimeCode";
InvertoryTimeCode_cbm.DataSource = detailposition.GetList();
InvertoryTimeCode_cbm.Text = "";
LocationVo Locationvo = (LocationVo)DefaultCbmInvoker.Invoke(new GetLocationMasterMntCbm(), new LocationVo());
location_cbm.DisplayMember = "LocationCode";
location_cbm.DataSource = Locationvo.LocationListVo;
location_cbm.Text = "";
asset_Code_cmb.Select();
// ValueObjectList<RankVo> rankcode = (ValueObjectList<RankVo>)DefaultCbmInvoker.Invoke(new GetRankCbm(), new RankVo());
//InvertoryCheck_dgv.
// DisplayMember = "RankCode";
//rank_code_cbm.DataSource = rankcode.GetList();
//rank_code_cbm.Text = "";
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
LocationVo inVo = (LocationVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Delete From m_location");
sqlQuery.Append(" Where ");
sqlQuery.Append(" location_id = :locationid ;");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("locationid", inVo.LocationId);
LocationVo outVo = new LocationVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public AccountMainVo accountmainVo = new AccountMainVo(); //dv
private void AddAcountMainForm_Load(object sender, EventArgs e)
{
//rank
ValueObjectList <RankVo> rankname = (ValueObjectList <RankVo>)DefaultCbmInvoker.Invoke(new GetRankCbm(), new RankVo());
rank_code_cmb.DisplayMember = "RankCode";
rank_code_cmb.DataSource = rankname.GetList();
rank_code_cmb.Text = "";
//location
LocationVo Locationvo = (LocationVo)DefaultCbmInvoker.Invoke(new GetLocationMasterMntCbm(), new LocationVo());
location_cmb.DataSource = Locationvo.LocationListVo;
location_cmb.DisplayMember = "LocationCode";
location_cmb.Text = "";
// account_code
ValueObjectList <AccountCodeVo> accountcodevo = (ValueObjectList <AccountCodeVo>)DefaultCbmInvoker.Invoke(new GetAccountCodeCbm(), new AccountCodeVo());
account_code_cmb.DisplayMember = "AccountCodeCode";
account_code_cmb.DataSource = accountcodevo.GetList();
account_code_cmb.Text = "";
//accountlocationcode
ValueObjectList <AccountLocationVo> accountlocationcodevo = (ValueObjectList <AccountLocationVo>)DefaultCbmInvoker.Invoke(new GetAccountLocationCbm(), new AccountLocationVo());
section_cd_cmb.DisplayMember = "AccountLocationCode";
section_cd_cmb.DataSource = accountlocationcodevo.GetList();
section_cd_cmb.Text = "";
//cau cua dang
ValueObjectList <AssetVo> assetmodelvo = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetCbm(), new AssetVo());
no_cbm.DisplayMember = "AssetNo";
no_cbm.ValueMember = "AssetId";
no_cbm.DataSource = assetmodelvo.GetList();
//end
ValueObjectList <UnitVo> unit = (ValueObjectList <UnitVo>)DefaultCbmInvoker.Invoke(new GetUnitCbm(), new UnitVo());
unit_cmb.DisplayMember = "UnitCode";
unit_cmb.DataSource = unit.GetList();
unit_cmb.Text = "";
{
user_location_name_cmb.Enabled = false;
asset_model_cmb.Enabled = false;
end_depreciation_dtp.Enabled = false;
asset_life_cmb.Enabled = false;
acquisition_cost_cmb.Enabled = false;
current_depreciation_txt.Enabled = false;
monthl_depreciation_txt.Enabled = false;
accum_depreciation_txt.Enabled = false;
net_value_txt.Enabled = false;
}
if (accountmainVo.AcountMainId > 0)
{
asset_code_txt.Enabled = false;
no_cbm.Enabled = false;
no_cbm.Text = accountmainVo.AssetNo.ToString();
asset_code_txt.Text = accountmainVo.AssetCode;
asset_model_cmb.Text = accountmainVo.AssetModel;
rank_code_cmb.Text = accountmainVo.RankCode;
account_code_cmb.Text = accountmainVo.AccountCodeCode;
section_cd_cmb.Text = accountmainVo.AccountLocationCode;
location_cmb.Text = accountmainVo.AccountLocationName;
qty_txt.Text = accountmainVo.QTY.ToString();
unit_cmb.Text = accountmainVo.UnitName;
start_depreciation_dtp.Value = accountmainVo.StartDepreciation;
end_depreciation_dtp.Value = accountmainVo.EndDepreciation;
asset_life_cmb.Text = accountmainVo.AssetLife.ToString();
acquisition_cost_cmb.Text = accountmainVo.AcquisitionCost.ToString();
current_depreciation_txt.Text = accountmainVo.CurrentDepreciation.ToString();
monthl_depreciation_txt.Text = accountmainVo.MonthlyDepreciation.ToString();
accum_depreciation_txt.Text = accountmainVo.AccumDepreciation.ToString();
net_value_txt.Text = accountmainVo.NetValue.ToString();
this.TitleText = Com.Nidec.Mes.GlobalMasterMaintenance.CommonConstants.MODE_UPDATE;
}
else
{
comments_txt.Text = "Add";
this.TitleText = Com.Nidec.Mes.GlobalMasterMaintenance.CommonConstants.MODE_ADD;
}
}
/// <summary>
/// update the record to db
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Ok_btn_Click(object sender, EventArgs e)
{
LocationVo inVo = new LocationVo();
if (CheckMandatory())
{
var sch = StringCheckHelper.GetInstance();
if (!sch.IsASCII(LocationCode_txt.Text) || !sch.IsASCII(LocationName_txt.Text))
{
messageData = new MessageData("mmce00003", Properties.Resources.mmce00003);
logger.Info(messageData);
popUpMessage.ConfirmationOkCancel(messageData, Text);
if (!sch.IsASCII(LocationCode_txt.Text))
{
LocationCode_txt.Focus();
}
else
{
LocationName_txt.Focus();
}
return;
}
//if(LocationCode_txt.Text.Trim().Length < 4)
//{
// MessageData messageData = new MessageData("mmci00008", Properties.Resources.mmci00008, LocationCode_lbl.Text);
// popUpMessage.Warning(messageData, Text);
// LocationCode_txt.Focus();
// return;
//}
inVo.LocationCode = LocationCode_txt.Text.Trim();
inVo.LocationName = LocationName_txt.Text.Trim();
inVo.BuildingId = Convert.ToInt32(Building_cmb.SelectedValue);
if (string.Equals(mode, CommonConstants.MODE_ADD))
{
LocationVo checkVo = DuplicateCheck(inVo);
if (checkVo != null && checkVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, LocationCode_lbl.Text + " : " + LocationCode_txt.Text);
logger.Info(messageData);
popUpMessage.ConfirmationOkCancel(messageData, Text);
LocationCode_txt.Focus();
return;
}
}
try
{
if (string.Equals(mode, CommonConstants.MODE_ADD))
{
LocationVo outVo = (LocationVo)base.InvokeCbm(new AddLocationMasterMntCbm(), inVo, false);
IntSuccess = outVo.AffectedCount;
}
else if (mode.Equals(CommonConstants.MODE_UPDATE))
{
inVo.LocationId = updateData.LocationId;
LocationVo outVo = (LocationVo)base.InvokeCbm(new UpdateLocationMasterMntCbm(), inVo, false);
IntSuccess = outVo.AffectedCount;
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
if ((IntSuccess > 0) || (IntSuccess == 0))
{
this.Close();
}
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
LocationVo inVo = (LocationVo)arg;
StringBuilder sqlQuery = new StringBuilder();
//create SQL
sqlQuery.Append("Select ct.location_id, ct.location_cd, ct.location_name, md.building_id, md.building_name ");
sqlQuery.Append(" from m_location ct ");
sqlQuery.Append(" inner join m_building md on md.building_id = ct.building_id ");
sqlQuery.Append(" where ct.factory_cd = :faccd ");
if (inVo.LocationCode != null)
{
sqlQuery.Append(" and ct.location_cd like :locationcd ");
}
if (inVo.LocationName != null)
{
sqlQuery.Append(" and ct.location_name like :locationname ");
}
if (inVo.BuildingId != 0)
{
sqlQuery.Append(" and md.building_id = :buildingid ");
}
sqlQuery.Append(" order by ct.location_cd");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
if (inVo.LocationCode != null)
{
sqlParameter.AddParameterString("locationcd", inVo.LocationCode + "%");
}
if (inVo.LocationName != null)
{
sqlParameter.AddParameterString("locationname", inVo.LocationName + "%");
}
if (inVo.BuildingId != 0)
{
sqlParameter.AddParameterInteger("buildingid", inVo.BuildingId);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
LocationVo outVo = new LocationVo();
while (dataReader.Read())
{
LocationVo currOutVo = new LocationVo
{
LocationId = Convert.ToInt32(dataReader["location_id"]),
LocationCode = dataReader["location_cd"].ToString(),
LocationName = dataReader["location_name"].ToString(),
BuildingId = Convert.ToInt32(dataReader["building_id"]),
BuildingName = dataReader["building_name"].ToString()
};
outVo.LocationListVo.Add(currOutVo);
}
dataReader.Close();
return(outVo);
}
private void AccountMainForm_Load(object sender, EventArgs e)
{
{
account_depreciation_dgv.DefaultCellStyle.Font = new Font("Arial", 9);
account_depreciation_dgv.ColumnHeadersDefaultCellStyle.Font = new Font("Arial", 9, FontStyle.Bold);
account_main_dgv.DefaultCellStyle.Font = new Font("Arial", 9);
account_main_dgv.ColumnHeadersDefaultCellStyle.Font = new Font("Arial", 9, FontStyle.Bold);
}
AcceptButton = search_btn;
ValueObjectList <RankVo> rankcode = (ValueObjectList <RankVo>)DefaultCbmInvoker.Invoke(new GetRankCbm(), new RankVo());
rank_code_cbm.DisplayMember = "RankCode";
rank_code_cbm.DataSource = rankcode.GetList();
rank_code_cbm.Text = "";
ValueObjectList <AssetVo> assetvotype = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetTypeCbm(), new AssetVo());
asset_type_cbm.DisplayMember = "AssetType";
asset_type_cbm.DataSource = assetvotype.GetList();
asset_type_cbm.Text = "";
// account_code
ValueObjectList <AccountCodeVo> accountcodevo = (ValueObjectList <AccountCodeVo>)DefaultCbmInvoker.Invoke(new GetAccountCodeCbm(), new AccountCodeVo());
account_code_cmb.DisplayMember = "AccountCodeCode";
account_code_cmb.DataSource = accountcodevo.GetList();
account_code_cmb.Text = "";
//accountlocationcode
ValueObjectList <AccountLocationVo> accountlocationcodevo = (ValueObjectList <AccountLocationVo>)DefaultCbmInvoker.Invoke(new GetAccountLocationCbm(), new AccountLocationVo());
section_cd_cmb.DisplayMember = "AccountLocationCode";
section_cd_cmb.DataSource = accountlocationcodevo.GetList();
section_cd_cmb.Text = "";
ValueObjectList <AssetVo> assetvoinvoice = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetInvoiceCbm(), new AssetVo());
invoice_cbm.DisplayMember = "AssetInvoice";
invoice_cbm.DataSource = assetvoinvoice.GetList();
invoice_cbm.Text = "";
ValueObjectList <AssetVo> assetPO = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetPOCbm(), new AssetVo());
AssetPO_cmb.DisplayMember = "AssetPO";
AssetPO_cmb.DataSource = assetPO.GetList();
AssetPO_cmb.Text = "";
ValueObjectList <InvertoryVo> invertory = (ValueObjectList <InvertoryVo>)DefaultCbmInvoker.Invoke(new GetInvertoryTimeCbm(), new InvertoryVo());
invertory_cmb.DisplayMember = "InvertoryTimeCode";
invertory_cmb.DataSource = invertory.GetList();
ValueObjectList <AssetVo> assetvomodel = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetModelCbm(), new AssetVo());
asset_model_cbm.DisplayMember = "AssetModel";
asset_model_cbm.DataSource = assetvomodel.GetList();
asset_model_cbm.Text = "";
ValueObjectList <AssetVo> assetvoname = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetNameCbm(), new AssetVo());
asset_name_cbm.DisplayMember = "AssetName";
asset_name_cbm.DataSource = assetvoname.GetList();
asset_name_cbm.Text = "";
LocationVo Locationvo = (LocationVo)DefaultCbmInvoker.Invoke(new GetLocationMasterMntCbm(), new LocationVo());
location_cbm.DisplayMember = "LocationCode";
location_cbm.DataSource = Locationvo.LocationListVo;
location_cbm.Text = "";
}
private void WareHouseMainForm_Load(object sender, EventArgs e)
{
AcceptButton = search_btn;
select_search_cbm.Items.Add("Search History");
select_search_cbm.Items.Add("Search List");
select_search_cbm.Text = "Search History";
{
account_depreciation_dgv.DefaultCellStyle.Font = new Font("Arial", 9);
account_depreciation_dgv.ColumnHeadersDefaultCellStyle.Font = new Font("Arial", 9, FontStyle.Bold);
warehouse_main_dgv.DefaultCellStyle.Font = new Font("Arial", 9);
warehouse_main_dgv.ColumnHeadersDefaultCellStyle.Font = new Font("Arial", 9, FontStyle.Bold);
}
AcceptButton = search_btn;
ValueObjectList <RankVo> rankcode = (ValueObjectList <RankVo>)DefaultCbmInvoker.Invoke(new GetRankCbm(), new RankVo());
rank_code_cbm.DisplayMember = "RankCode";
rank_code_cbm.DataSource = rankcode.GetList();
rank_code_cbm.Text = "";
ValueObjectList <AssetVo> assetvotype = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetTypeCbm(), new AssetVo());
asset_type_cbm.DisplayMember = "AssetType";
asset_type_cbm.DataSource = assetvotype.GetList();
asset_type_cbm.Text = "";
// account_code
ValueObjectList <DetailPositionVo> detailposition = (ValueObjectList <DetailPositionVo>)DefaultCbmInvoker.Invoke(new GetDetailPositionCbm(), new DetailPositionVo());
detail_position_cmb.DisplayMember = "DetailPositionCode";
detail_position_cmb.DataSource = detailposition.GetList();
detail_position_cmb.Text = "";
ValueObjectList <AssetVo> assetvoinvoice = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetInvoiceCbm(), new AssetVo());
invoice_cbm.DisplayMember = "AssetInvoice";
invoice_cbm.DataSource = assetvoinvoice.GetList();
invoice_cbm.Text = "";
ValueObjectList <AssetVo> assetvomodel = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetModelCbm(), new AssetVo());
asset_model_cbm.DisplayMember = "AssetModel";
asset_model_cbm.DataSource = assetvomodel.GetList();
asset_model_cbm.Text = "";
ValueObjectList <AssetVo> assetvoname = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetNameCbm(), new AssetVo());
asset_name_cbm.DisplayMember = "AssetName";
asset_name_cbm.DataSource = assetvoname.GetList();
asset_name_cbm.Text = "";
LocationVo Locationvo = (LocationVo)DefaultCbmInvoker.Invoke(new GetLocationMasterMntCbm(), new LocationVo());
location_cbm.DisplayMember = "LocationCode";
location_cbm.DataSource = Locationvo.LocationListVo;
location_cbm.Text = "";
}
public WareHouseMainVo WareHouseMainVo = new WareHouseMainVo(); //dv
private void AddWareHouseMainForm_Load(object sender, EventArgs e)
{
//rank
ValueObjectList <RankVo> rankname = (ValueObjectList <RankVo>)DefaultCbmInvoker.Invoke(new GetRankCbm(), new RankVo());
cmbRankCode.DisplayMember = "RankCode";
cmbRankCode.DataSource = rankname.GetList();
cmbRankCode.Text = "";
//location
LocationVo Locationvo = (LocationVo)DefaultCbmInvoker.Invoke(new GetLocationMasterMntCbm(), new LocationVo());
cmbBeforeLocation.DataSource = Locationvo.LocationListVo;
cmbBeforeLocation.DisplayMember = "LocationCode";
cmbBeforeLocation.Text = "";
// account_code
ValueObjectList <AccountCodeVo> accountcodevo = (ValueObjectList <AccountCodeVo>)DefaultCbmInvoker.Invoke(new GetAccountCodeCbm(), new AccountCodeVo());
cmbAccountCode.DisplayMember = "AccountCodeCode";
cmbAccountCode.DataSource = accountcodevo.GetList();
cmbAccountCode.Text = "";
//accountlocationcode
ValueObjectList <AccountLocationVo> accountlocationcodevo = (ValueObjectList <AccountLocationVo>)DefaultCbmInvoker.Invoke(new GetAccountLocationCbm(), new AccountLocationVo());
cmbSectionCode.DisplayMember = "AccountLocationCode";
cmbSectionCode.DataSource = accountlocationcodevo.GetList();
cmbSectionCode.Text = "";
//cau cua dang
ValueObjectList <AssetVo> assetmodelvo = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetCbm(), new AssetVo());
cmbNoNumber.DisplayMember = "AssetNo";
cmbNoNumber.ValueMember = "AssetId";
cmbNoNumber.DataSource = assetmodelvo.GetList();
//end
ValueObjectList <UnitVo> unitvo = (ValueObjectList <UnitVo>)DefaultCbmInvoker.Invoke(new GetUnitCbm(), new UnitVo());
cmbUnit.DisplayMember = "UnitCode";
cmbUnit.DataSource = unitvo.GetList();
cmbUnit.Text = "";
{
cmbUserName.Enabled = false;
cmbAssetModel.Enabled = false;
dtpEndDepreciation.Enabled = false;
cmbAssetLife.Enabled = false;
cmbAcquisitionCost.Enabled = false;
txtCurrentDepreciation.Enabled = false;
txtMonthlyDepreciation.Enabled = false;
txtAccumDepreciation.Enabled = false;
txtNetValue.Enabled = false;
}
if (WareHouseMainVo.WareHouseMainId > 0)
{
txtAssetCode.Enabled = false;
cmbNoNumber.Enabled = false;
cmbBeforeLocation.Text = WareHouseMainVo.BeforeLocationCd;
cmbAfterLocation.Text = WareHouseMainVo.AfterLocationCd;
cmbDetailPosition.Text = WareHouseMainVo.DetailPositionCd;
cmbNoNumber.Text = WareHouseMainVo.AssetNo.ToString();
txtAssetCode.Text = WareHouseMainVo.AssetCode;
cmbAssetModel.Text = WareHouseMainVo.AssetModel;
cmbRankCode.Text = WareHouseMainVo.RankCode;
cmbAccountCode.Text = WareHouseMainVo.AccountCodeCode;
cmbSectionCode.Text = WareHouseMainVo.AccountLocationCode;
txtqty.Text = WareHouseMainVo.QTY.ToString();
cmbUnit.Text = WareHouseMainVo.UnitName;
dtpStartDepreciation.Value = WareHouseMainVo.StartDepreciation;
dtpEndDepreciation.Value = WareHouseMainVo.EndDepreciation;
cmbAssetLife.Text = WareHouseMainVo.AssetLife.ToString();
cmbAcquisitionCost.Text = WareHouseMainVo.AcquisitionCost.ToString();
txtCurrentDepreciation.Text = WareHouseMainVo.CurrentDepreciation.ToString();
txtMonthlyDepreciation.Text = WareHouseMainVo.MonthlyDepreciation.ToString();
txtAccumDepreciation.Text = WareHouseMainVo.AccumDepreciation.ToString();
txtNetValue.Text = WareHouseMainVo.NetValue.ToString();
this.TitleText = Com.Nidec.Mes.GlobalMasterMaintenance.CommonConstants.MODE_UPDATE;
}
else
{
txtComment.Text = "Add";
this.TitleText = Com.Nidec.Mes.GlobalMasterMaintenance.CommonConstants.MODE_ADD;
}
}
public WareHouseMainVo WareHouseMainVo = new WareHouseMainVo(); //dv
private void AddWareHouseMainForm_Load(object sender, EventArgs e)
{
user_location_name_cmb.Enabled = false;
asset_model_cmb.Enabled = false;
no_cbm.Enabled = false;
no_lbl.Enabled = false;
//rank
ValueObjectList <RankVo> rankname = (ValueObjectList <RankVo>)DefaultCbmInvoker.Invoke(new GetRankCbm(), new RankVo());
rank_code_cmb.DisplayMember = "RankCode";
rank_code_cmb.DataSource = rankname.GetList();
rank_code_cmb.Text = "";
//location
LocationVo Locationvo = (LocationVo)DefaultCbmInvoker.Invoke(new GetLocationMasterMntCbm(), new LocationVo());
before_location_cmb.DataSource = Locationvo.LocationListVo;
before_location_cmb.DisplayMember = "LocationCode";
before_location_cmb.Text = "";
// account_code
ValueObjectList <AccountCodeVo> accountcodevo = (ValueObjectList <AccountCodeVo>)DefaultCbmInvoker.Invoke(new GetAccountCodeCbm(), new AccountCodeVo());
account_code_cmb.DisplayMember = "AccountCodeCode";
account_code_cmb.DataSource = accountcodevo.GetList();
account_code_cmb.Text = "";
//accountlocationcode
ValueObjectList <AccountLocationVo> accountlocationcodevo = (ValueObjectList <AccountLocationVo>)DefaultCbmInvoker.Invoke(new GetAccountLocationCbm(), new AccountLocationVo());
section_cd_cmb.DisplayMember = "AccountLocationCode";
section_cd_cmb.DataSource = accountlocationcodevo.GetList();
section_cd_cmb.Text = "";
//cau cua dang
ValueObjectList <AssetVo> assetmodelvo = (ValueObjectList <AssetVo>)DefaultCbmInvoker.Invoke(new GetAssetCbm(), new AssetVo());
no_cbm.DisplayMember = "AssetNo";
no_cbm.ValueMember = "AssetId";
no_cbm.DataSource = assetmodelvo.GetList();
//end
{
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");
unit_cmb.Items.Add("set");
unit_cmb.Text = "";
}
{
user_location_name_cmb.Enabled = false;
asset_model_cmb.Enabled = false;
end_depreciation_dtp.Enabled = false;
asset_life_cmb.Enabled = false;
acquisition_cost_cmb.Enabled = false;
current_depreciation_txt.Enabled = false;
monthl_depreciation_txt.Enabled = false;
accum_depreciation_txt.Enabled = false;
net_value_txt.Enabled = false;
start_depreciation_dtp.Enabled = false;
}
if (WareHouseMainVo.WareHouseMainId > 0)
{
asset_code_txt.Enabled = false;
before_location_cmb.Text = WareHouseMainVo.BeforeLocationCd;
after_location_cmb.Text = WareHouseMainVo.AfterLocationCd;
detail_position_cmb.Text = WareHouseMainVo.DetailPositionCd;
no_cbm.Text = WareHouseMainVo.AssetNo.ToString();
asset_code_txt.Text = WareHouseMainVo.AssetCode;
asset_model_cmb.Text = WareHouseMainVo.AssetModel;
rank_code_cmb.Text = WareHouseMainVo.RankCode;
account_code_cmb.Text = WareHouseMainVo.AccountCodeCode;
section_cd_cmb.Text = WareHouseMainVo.AccountLocationCode;
qty_txt.Text = WareHouseMainVo.QTY.ToString();
unit_cmb.Text = WareHouseMainVo.Unit;
start_depreciation_dtp.Value = WareHouseMainVo.StartDepreciation;
end_depreciation_dtp.Value = WareHouseMainVo.EndDepreciation;
asset_life_cmb.Text = WareHouseMainVo.AssetLife.ToString();
acquisition_cost_cmb.Text = WareHouseMainVo.AcquisitionCost.ToString();
current_depreciation_txt.Text = WareHouseMainVo.CurrentDepreciation.ToString();
monthl_depreciation_txt.Text = WareHouseMainVo.MonthlyDepreciation.ToString();
accum_depreciation_txt.Text = WareHouseMainVo.AccumDepreciation.ToString();
net_value_txt.Text = WareHouseMainVo.NetValue.ToString();
// unit_cmb.SelectedItem = null;
//int assetid = 0;
this.TitleText = Com.Nidec.Mes.GlobalMasterMaintenance.CommonConstants.MODE_UPDATE;
}
else
{
comments_txt.Text = "Add";
this.TitleText = Com.Nidec.Mes.GlobalMasterMaintenance.CommonConstants.MODE_ADD;
}
}
