private void JigDrawForm_Load(object sender, EventArgs e)
{
ValueObjectList <ModelVo> modelvolist = (ValueObjectList <ModelVo>)DefaultCbmInvoker.Invoke(new GetModelCbm(), new ModelVo());
model_cmb.DisplayMember = "ModelCode";
BindingSource b1 = new BindingSource(modelvolist.GetList(), null);
model_cmb.DataSource = b1;
model_cmb.Text = "";
process_cmb.Text = "";
LocalSupplierVo suppliervolist = (LocalSupplierVo)DefaultCbmInvoker.Invoke(new GetLocalSupplierMasterMntCbm(),
new LocalSupplierVo());
supplier_cmb.DisplayMember = "LocalSupplierName";
supplier_cmb.DataSource = suppliervolist.LocalSupplierListVo;
supplier_cmb.Text = "";
ValueObjectList <DrawVo> drawvolist = (ValueObjectList <DrawVo>)DefaultCbmInvoker.Invoke(new GetDrawCbm(), new DrawVo());
drawing_cmb.DisplayMember = "DrawCode";
BindingSource b = new BindingSource(drawvolist.GetList(), null);
drawing_cmb.DataSource = b;
drawing_cmb.Text = "";
}
/// <summary>
/// Fills all user records to gridview control
/// </summary>
private void GridBind(LocalSupplierVo conditionInVo)
{
LocalSupplier_dgv.DataSource = null;
try
{
LocalSupplierVo outVo = (LocalSupplierVo)base.InvokeCbm(new GetLocalSupplierMasterMntCbm(), conditionInVo, false);
LocalSupplier_dgv.AutoGenerateColumns = false;
BindingSource bindingSource1 = new BindingSource(outVo.LocalSupplierListVo, null);
if (bindingSource1.Count > 0)
{
LocalSupplier_dgv.DataSource = bindingSource1;
}
else
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null); //process
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
LocalSupplier_dgv.ClearSelection();
Update_btn.Enabled = false;
Delete_btn.Enabled = false;
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
/// <summary>
/// selects user record for updation and show user form
/// </summary>
private void BindUpdateUserData()
{
int selectedrowindex = LocalSupplier_dgv.SelectedCells[0].RowIndex;
LocalSupplierVo selectedData = (LocalSupplierVo)LocalSupplier_dgv.Rows[selectedrowindex].DataBoundItem;
AddLocalSupplierForm newAddForm = new AddLocalSupplierForm(CommonConstants.MODE_UPDATE, selectedData);
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)
{
LocalSupplierVo inVo = (LocalSupplierVo)arg;
LocalSupplierVo outVo = new LocalSupplierVo();
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Select * from m_local_supplier ");
sqlQuery.Append(" where 1 = 1 ");
if (inVo.LocalSupplierCode != null)
{
sqlQuery.Append(" and local_supplier_cd like :localsuppliercd ");
}
if (inVo.LocalSupplierName != null)
{
sqlQuery.Append(" and local_supplier_name like :localsuppliername ");
}
sqlQuery.Append(" order by local_supplier_cd");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
if (inVo.LocalSupplierCode != null)
{
sqlParameter.AddParameterString("localsuppliercd", inVo.LocalSupplierCode + "%");
}
if (inVo.LocalSupplierName != null)
{
sqlParameter.AddParameterString("localsuppliername", inVo.LocalSupplierName + "%");
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
LocalSupplierVo currOutVo = new LocalSupplierVo
{
LocalSupplierId = Convert.ToInt32(dataReader["local_supplier_id"]),
LocalSupplierCode = dataReader["local_supplier_cd"].ToString(),
LocalSupplierName = dataReader["local_supplier_name"].ToString(),
};
outVo.LocalSupplierListVo.Add(currOutVo);
}
dataReader.Close();
return(outVo);
}
/// <summary>
/// For setting selected user record into respective controls(textbox and combobox) for update operation
/// passing selected user data as parameter
/// </summary>
/// <param name="dgvData"></param>
private void LoadUserData(LocalSupplierVo dgvData)
{
if (dgvData != null)
{
LocalSupplierCode_txt.Text = dgvData.LocalSupplierCode;
LocalSupplierName_txt.Text = dgvData.LocalSupplierName;
}
}
/// <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 = LocalSupplier_dgv.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = LocalSupplier_dgv.Rows[selectedrowindex];
messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, selectedRow.Cells["colLocalSupplierCode"].Value.ToString());
// Logger.Info(messageData);
DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text);
if (dialogResult == DialogResult.OK)
{
LocalSupplierVo inVo = new LocalSupplierVo
{
LocalSupplierId = Convert.ToInt32(selectedRow.Cells["colLocalSupplierId"].Value),
};
try
{
inVo.LocalSupplierCode = selectedRow.Cells["colLocalSupplierCode"].Value.ToString();
LocalSupplierVo tableCount = tableCount = CheckSupplierRelationCbm(inVo);
if (tableCount.AffectedCount > 0)
{
messageData = new MessageData("mmce00007", Properties.Resources.mmce00007, ProcessSupplier.ToString());
popUpMessage.Information(messageData, Text);
return;
}
LocalSupplierVo outVo = (LocalSupplierVo)base.InvokeCbm(new DeleteLocalSupplierMasterMntCbm(), 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
}
}
/// <summary>
/// constructor for the form
/// </summary>
/// <param name="pmode"></param>
/// <param name="dataItem"></param>
public AddLocalSupplierForm(string pmode, LocalSupplierVo dataItem = null)
{
InitializeComponent();
mode = pmode;
updateData = dataItem;
if (string.Equals(mode, CommonConstants.MODE_UPDATE))
{
this.Text = UpdateText_lbl.Text;
}
}
/// <summary>
/// checks duplicate Process Code
/// </summary>
/// <param name="processVo"></param>
/// <returns></returns>
private LocalSupplierVo DuplicateCheck(LocalSupplierVo localSupplierVo)
{
LocalSupplierVo outVo = new LocalSupplierVo();
try
{
outVo = (LocalSupplierVo)base.InvokeCbm(new CheckLocalSupplierMasterMntCbm(), localSupplierVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
return(outVo);
}
/// <summary>
/// Creates seacrh condition as per user inputs
/// </summary>
/// <returns>search condition</returns>
private LocalSupplierVo FormConditionVo()
{
LocalSupplierVo inVo = new LocalSupplierVo();
if (LocalSupplierCode_txt.Text != string.Empty)
{
inVo.LocalSupplierCode = LocalSupplierCode_txt.Text;
}
if (LocalSupplierName_txt.Text != string.Empty)
{
inVo.LocalSupplierName = LocalSupplierName_txt.Text;
}
return(inVo);
}
/// <summary>
/// Loads Process Work
/// </summary>
private void LoadLocalSupplier()
{
LocalSupplierVo outVo = new LocalSupplierVo();
try
{
outVo = (LocalSupplierVo)base.InvokeCbm(new GetLocalSupplierMasterMntCbm(), new LocalSupplierVo(), false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
ComboBind(Supplier_cmb, outVo.LocalSupplierListVo, "LocalSupplierName", "LocalSupplierId");
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
LocalSupplierVo inVo = (LocalSupplierVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Insert into m_local_supplier");
sqlQuery.Append(" ( ");
sqlQuery.Append(" local_supplier_cd, ");
sqlQuery.Append(" local_supplier_name, ");
sqlQuery.Append(" registration_user_cd, ");
sqlQuery.Append(" registration_date_time, ");
sqlQuery.Append(" factory_cd ");
sqlQuery.Append(" ) ");
sqlQuery.Append("VALUES ");
sqlQuery.Append(" ( ");
sqlQuery.Append(" :localsuppliercd ,");
sqlQuery.Append(" :localsuppliername ,");
sqlQuery.Append(" :registrationusercode ,");
sqlQuery.Append(" now() ,");
sqlQuery.Append(" :factorycode ");
sqlQuery.Append(" ); ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("localsuppliercd", inVo.LocalSupplierCode);
sqlParameter.AddParameterString("localsuppliername", inVo.LocalSupplierName);
sqlParameter.AddParameterString("registrationusercode", inVo.RegistrationUserCode);
//sqlParameter.AddParameterDateTime("registrationdatetime", inVo.RegistrationDateTime);
sqlParameter.AddParameterString("factorycode", inVo.FactoryCode);
LocalSupplierVo outVo = new LocalSupplierVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
LocalSupplierVo inVo = (LocalSupplierVo)arg;
StringBuilder sqlQuery = new StringBuilder();
//create SQL
sqlQuery.Append(" select Count(lsr.local_supplier_cd) as SupplierCount from m_local_supplier as lsr");
sqlQuery.Append(" inner join m_process_work_local_supplier as prsup on lsr.local_supplier_id = prsup.local_supplier_id ");
sqlQuery.Append(" where 1 = 1 ");
if (inVo.LocalSupplierCode != null)
{
sqlQuery.Append(" and UPPER(local_supplier_cd) = UPPER(:localsuppliercd)");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
if (inVo.LocalSupplierCode != null)
{
sqlParameter.AddParameterString("localsuppliercd", inVo.LocalSupplierCode);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
LocalSupplierVo outVo = new LocalSupplierVo();
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["SupplierCount"]);
}
dataReader.Close();
return(outVo);
}
/// <summary>
/// form country and factory data for combo
/// </summary>
private void FormDatatableFromVo()
{
localSupplierDatatable = new DataTable();
localSupplierDatatable.Columns.Add("id");
localSupplierDatatable.Columns.Add("code");
try
{
LocalSupplierVo localSupplierVo = (LocalSupplierVo)base.InvokeCbm(new GetLocalSupplierMasterMntCbm(), new LocalSupplierVo(), false);
foreach (LocalSupplierVo localSupplier in localSupplierVo.LocalSupplierListVo)
{
localSupplierDatatable.Rows.Add(localSupplier.LocalSupplierId, localSupplier.LocalSupplierName);
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
LocalSupplierVo inVo = (LocalSupplierVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Delete From m_local_supplier");
sqlQuery.Append(" Where ");
sqlQuery.Append(" local_supplier_id = :localsupplierid ;");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("localsupplierid", inVo.LocalSupplierId);
LocalSupplierVo outVo = new LocalSupplierVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
private void AddJigDrawForm_Load(object sender, EventArgs e)
{
status_cmb.Items.Add("OK");
status_cmb.Items.Add("NG");
ValueObjectList <ModelVo> modelvolist = null;
try
{
modelvolist = (ValueObjectList <ModelVo>)DefaultCbmInvoker.Invoke(getModelCbm, new ModelVo());
}
catch (Com.Nidec.Mes.Framework.ApplicationException ex)
{
logger.Error(ex.GetMessageData());
popUpMessage.ApplicationError(ex.GetMessageData(), Text);
return;
}
model_cmb.DisplayMember = "ModelCode";
BindingSource b1 = new BindingSource(modelvolist.GetList(), null);
model_cmb.DataSource = b1;
model_cmb.Text = "";
ValueObjectList <DrawVo> drawvolist = null;
try
{
drawvolist = (ValueObjectList <DrawVo>)DefaultCbmInvoker.Invoke(new GetDrawCbm(), new DrawVo());
}
catch (Com.Nidec.Mes.Framework.ApplicationException ex)
{
logger.Error(ex.GetMessageData());
popUpMessage.ApplicationError(ex.GetMessageData(), Text);
return;
}
drawing_cmb.DisplayMember = "DrawCode";
BindingSource b = new BindingSource(drawvolist.GetList(), null);
drawing_cmb.DataSource = b;
drawing_cmb.Text = "";
LocalSupplierVo suppliervolist = null;
try
{
suppliervolist = (LocalSupplierVo)DefaultCbmInvoker.Invoke(new GetLocalSupplierMasterMntCbm(), new LocalSupplierVo());
}
catch (Com.Nidec.Mes.Framework.ApplicationException ex)
{
logger.Error(ex.GetMessageData());
popUpMessage.ApplicationError(ex.GetMessageData(), Text);
return;
}
supplier_cmb.DisplayMember = "LocalSupplierName";
BindingSource b2 = new BindingSource(suppliervolist.LocalSupplierListVo, null);
supplier_cmb.DataSource = b2;
supplier_cmb.Text = "";
if (vo.JigID > 0)
{
model_cmb.Enabled = false;
supplier_cmb.Enabled = false;
model_cmb.Text = vo.ModelCode;
supplier_cmb.Text = vo.SupplierName;
process_cmb.Text = vo.ProcessName;
jig_code_txt.Text = vo.JigBCode;
drawing_cmb.Text = vo.DrawCode;
place_cmb.Text = vo.JigPlace;
status_cmb.Text = vo.Status;
timereceive_dtp.Value = vo.TimeReceive;
}
}
/// <summary>
/// inserts/updates process on ok click
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Ok_btn_Click(object sender, EventArgs e)
{
if (CheckMandatory())
{
var sch = StringCheckHelper.GetInstance();
if (string.IsNullOrEmpty(LocalSupplierCode_txt.Text) || string.IsNullOrEmpty(LocalSupplierName_txt.Text))
{
messageData = new MessageData("mmce00003", Properties.Resources.mmce00003);
logger.Info(messageData);
popUpMessage.ConfirmationOkCancel(messageData, Text);
if (string.IsNullOrEmpty(LocalSupplierCode_txt.Text))
{
LocalSupplierCode_txt.Focus();
}
else
{
LocalSupplierName_txt.Focus();
}
return;
}
LocalSupplierVo inVo = new LocalSupplierVo
{
LocalSupplierCode = LocalSupplierCode_txt.Text.Trim(),
LocalSupplierName = LocalSupplierName_txt.Text.Trim(),
//RegistrationDateTime = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"),
RegistrationUserCode = UserData.GetUserData().UserCode,
FactoryCode = UserData.GetUserData().FactoryCode
};
if (string.Equals(mode, CommonConstants.MODE_ADD))
{
LocalSupplierVo checkVo = DuplicateCheck(inVo);
if (checkVo != null && checkVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, LocalSupplierCode_lbl.Text + " : " + LocalSupplierCode_txt.Text);
logger.Info(messageData);
popUpMessage.ApplicationError(messageData, Text);
return;
}
}
try
{
if (string.Equals(mode, CommonConstants.MODE_ADD))
{
LocalSupplierVo outVo = (LocalSupplierVo)base.InvokeCbm(new AddLocalSupplierMasterMntCbm(), inVo, false);
IntSuccess = outVo.AffectedCount;
}
else if (mode.Equals(CommonConstants.MODE_UPDATE))
{
inVo.LocalSupplierId = updateData.LocalSupplierId;
LocalSupplierVo outVo = (LocalSupplierVo)base.InvokeCbm(new UpdateLocalSupplierMasterMntCbm(), 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();
}
}
}
