/// <summary>
/// Fills all user records to gridview control
/// </summary>
private void GridBind(ProcessVo conditionInVo)
{
Process_dgv.DataSource = null;
try
{
ProcessVo outVo = (ProcessVo)base.InvokeCbm(new GetProcessMasterMntCbm(), conditionInVo, false);
Process_dgv.AutoGenerateColumns = false;
BindingSource bindingSource1 = new BindingSource(outVo.ProcessListVo, null);
if (bindingSource1.Count > 0)
{
Process_dgv.DataSource = bindingSource1;
}
else
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null); //process
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
Process_dgv.ClearSelection();
Update_btn.Enabled = false;
Delete_btn.Enabled = false;
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
private void LoadProcessListBox()
{
isProcessListLoading = true;
ProcessVo outPwVo = (ProcessVo)DefaultCbmInvoker.Invoke(new GetProcessMasterMntCbm(), new ProcessVo());
if (outPwVo.ProcessListVo.Count > 0)
{
outPwVo.ProcessListVo.ForEach(p => p.ProcessName = p.ProcessCode + " " + p.ProcessName);
Process_lst.DataSource = outPwVo.ProcessListVo;
Process_lst.DisplayMember = "ProcessName";
Process_lst.ValueMember = "ProcessId";
Process_lst.SelectedIndex = -1;
isProcessListLoading = false;
Update_btn.Enabled = true;
}
else
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, Process_lbl.Text);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
Update_btn.Enabled = false;
}
}
private void ReportDownTimeForm_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 = "";
ProcessVo processvo = (ProcessVo)DefaultCbmInvoker.Invoke(new GetProcessMasterMntCbm(), new ProcessVo());
process_cmb.DisplayMember = "ProcessName";
BindingSource b2 = new BindingSource(processvo.ProcessListVo, null);
process_cmb.DataSource = b2;
process_cmb.Text = "";
MachineVo machinevo = (MachineVo)DefaultCbmInvoker.Invoke(new GetMachineMasterMntCbm(), new MachineVo());
machine_cmb.DisplayMember = "MachineName";
BindingSource b4 = new BindingSource(machinevo.MachineListVo, null);
machine_cmb.DataSource = b4;
machine_cmb.Text = "";
line_cmb.Text = "";
cause_cmb.Text = "";
action_cmb.Text = "";
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
ProcessVo inVo = (ProcessVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <ProcessVo> voList = new ValueObjectList <ProcessVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"SELECT b.process_id, b.process_name from m_process b, m_ncvp_model_process a where a.process_id = b.process_id and model_id = :model_id order by process_id");
sqlParameter.AddParameterInteger("model_id", inVo.ProcessId);
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
ProcessVo outVo = new ProcessVo
{
ProcessId = int.Parse(dataReader["process_id"].ToString()),
ProcessName = dataReader["process_name"].ToString()
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
/// <summary>
/// selects user record for updation and show user form
/// </summary>
private void BindUpdateUserData()
{
int selectedrowindex = Process_dgv.SelectedCells[0].RowIndex;
ProcessVo selectedData = (ProcessVo)Process_dgv.Rows[selectedrowindex].DataBoundItem;
AddProcessForm newAddForm = new AddProcessForm(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)
{
ProcessVo inVo = (ProcessVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Delete From m_process");
sqlQuery.Append(" Where ");
sqlQuery.Append(" process_id = :processid");
sqlQuery.Append(" and factory_cd = :factcd;");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("processid", inVo.ProcessId);
sqlParameter.AddParameterString("factcd", UserData.GetUserData().FactoryCode);
ProcessVo outVo = new ProcessVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
ProcessVo inVo = (ProcessVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Update m_process");
sqlQuery.Append(" Set ");
sqlQuery.Append(" process_name = :processname ");
//sqlQuery.Append(" next_process_cd = :nextprocesscd ");
sqlQuery.Append(" Where ");
sqlQuery.Append(" process_id = :processid ;");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("processid", inVo.ProcessId);
sqlParameter.AddParameterString("processname", inVo.ProcessName);
//sqlParameter.AddParameterString("nextprocesscd", inVo.NextPocessCode);
ProcessVo outVo = new ProcessVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
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(ProcessVo dgvData)
{
if (dgvData != null)
{
ProcessCode_txt.Text = dgvData.ProcessCode;
ProcessName_txt.Text = dgvData.ProcessName;
//NextProcessCode_txt.Text = dgvData.NextPocessCode;
}
}
/// <summary>
/// constructor for the form
/// </summary>
/// <param name="pmode"></param>
/// <param name="dataItem"></param>
public AddProcessForm(string pmode, ProcessVo dataItem = null)
{
InitializeComponent();
mode = pmode;
updateData = dataItem;
if (string.Equals(mode, CommonConstants.MODE_UPDATE))
{
this.Text = UpdateText_lbl.Text;
}
}
private static List <ProcessVo> ToVoList(List <ProcessEntity> entityList)
{
var processList = new List <ProcessVo>();
foreach (var entity in entityList)
{
ProcessVo process = ToVo(entity);
processList.Add(process);
}
return(processList);
}
private void btnInsSave_Click(object sender, EventArgs e)
{
ProcessVo insertVo = new ProcessVo();
insertVo.Process_Group = cbInsertGroup.Text;
insertVo.Process_Code = txtInsertCode.Text;
insertVo.Process_Name = txtInsertName.Text;
insertVo.Use_YN = rbUse.Checked ? "Y" : "N";
insertVo.Remark = txtInsRemark.Text;
ProcessService service = new ProcessService();
service.InsertProcess(insertVo);
CommonClass.InitControl(pnlParent1);
frm.btnS.PerformClick();
}
/// <summary>
/// checks process relation to other tables in DB
/// </summary>
/// <param name="processVo"></param>
/// <returns></returns>
private ProcessVo CheckRelation(ProcessVo processVo)
{
ProcessVo outVo = new ProcessVo();
try
{
outVo = (ProcessVo)base.InvokeCbm(new CheckProcessRelationCbm(), processVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
return(outVo);
}
private void btnUpButton_Click(object sender, EventArgs e)
{
ProcessVo updateVo = new ProcessVo();
updateVo.Process_Code = txtUpCode.Text;
updateVo.Process_Name = txtUpName.Text;
updateVo.Process_Group = cbUpdateGroup.Text;
updateVo.Use_YN = rbUpTrue.Checked ? "Y" : "N";
updateVo.Remark = txtUpRemark.Text;
ProcessService service = new ProcessService();
service.UpdateProcess(updateVo);
CommonClass.InitControl(panel1);
frm.btnS.PerformClick();
}
private void ReportDownTimeForm_Load(object sender, EventArgs e)
{
int usr_cd;
//Load ComboBox
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;
ProcessVo processvo = (ProcessVo)DefaultCbmInvoker.Invoke(new GetProcessMasterMntCbm(), new ProcessVo());
assy_cmb.DisplayMember = "ProcessName";
BindingSource b2 = new BindingSource(processvo.ProcessListVo, null);
assy_cmb.DataSource = b2;
MachineVo machinevo = (MachineVo)DefaultCbmInvoker.Invoke(new GetMachineMasterMntCbm(), new MachineVo());
machine_cmb.DisplayMember = "MachineName";
BindingSource b4 = new BindingSource(machinevo.MachineListVo, null);
machine_cmb.DataSource = b4;
ResetControlValues.ResetControlValue(Search_tbpnl);
//Check Permission
ReportDownTimeVo inVo = new ReportDownTimeVo
{
RegistrationUserCode = UserData.GetUserData().UserCode
};
ReportDownTimeVo usrvo = (ReportDownTimeVo)DefaultCbmInvoker.Invoke(new CheckPermissionCbm(), new ReportDownTimeVo {
RegistrationUserCode = inVo.RegistrationUserCode
});
usr_cd = usrvo.AffectedCount;
if (usr_cd == 1)
{
update_btn.Enabled = true;
Delete_btn.Enabled = true;
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
ProcessVo inVo = (ProcessVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("select pr.process_cd, pw.process_work_id"); // up.process_id as UserProcessId,
sqlQuery.Append(" from m_process pr");
//sqlQuery.Append(" left outer join m_user_process up on up.process_id = pr.process_id");
sqlQuery.Append(" left outer join m_process_work pw on pw.process_id = pr.process_id");
sqlQuery.Append(" where pr.factory_cd = :factcd ");
if (inVo.ProcessCode != null)
{
sqlQuery.Append(" and UPPER(process_cd) = UPPER(:processcd)");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("factcd", UserData.GetUserData().FactoryCode);
if (inVo.ProcessCode != null)
{
sqlParameter.AddParameterString("processcd", inVo.ProcessCode);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
ProcessVo outVo = new ProcessVo();
while (dataReader.Read())
{
//outVo.UserProcessId = Convert.ToInt32("0" + dataReader["UserProcessId"]);
outVo.ProcessWorkId = Convert.ToInt32("0" + dataReader["process_work_id"]);
}
dataReader.Close();
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
ProcessVo inVo = (ProcessVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Insert into m_process");
sqlQuery.Append(" ( ");
sqlQuery.Append(" process_cd, ");
sqlQuery.Append(" process_name, ");
//sqlQuery.Append(" next_process_cd, ");
sqlQuery.Append(" registration_user_cd, ");
sqlQuery.Append(" registration_date_time, ");
sqlQuery.Append(" factory_cd ");
sqlQuery.Append(" ) ");
sqlQuery.Append("VALUES ");
sqlQuery.Append(" ( ");
sqlQuery.Append(" :processcd ,");
sqlQuery.Append(" :processname ,");
//sqlQuery.Append(" :nextprocesscd ,");
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("processcd", inVo.ProcessCode);
sqlParameter.AddParameterString("processname", inVo.ProcessName);
//sqlParameter.AddParameterString("nextprocesscd", inVo.NextPocessCode);
sqlParameter.AddParameterString("registrationusercode", inVo.RegistrationUserCode);
//sqlParameter.AddParameterDateTime("registrationdatetime", inVo.RegistrationDateTime);
sqlParameter.AddParameterString("factorycode", inVo.FactoryCode);
ProcessVo outVo = new ProcessVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
private void CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
tcParent2.SelectedIndex = 1;
string upDateID = dgvSearchResult.Rows[e.RowIndex].Cells[1].Value.ToString();
ProcessVo updateVo = list.Find(x => x.Process_Code == upDateID);
txtUpCode.Text = updateVo.Process_Code;
txtUpName.Text = updateVo.Process_Name;
cbUpdateGroup.Text = updateVo.Process_Group;
if (updateVo.Use_YN == "Y")
{
rbUpTrue.Checked = true;
}
else
{
rbUpFalse.Checked = true;
}
txtUpRemark.Text = updateVo.Remark;
}
private void AddUpdateReportDownTimeFrom_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 = "";
ProcessVo processvo = (ProcessVo)DefaultCbmInvoker.Invoke(new GetProcessMasterMntCbm(), new ProcessVo());
process_cmb.DisplayMember = "ProcessName";
BindingSource b2 = new BindingSource(processvo.ProcessListVo, null);
process_cmb.DataSource = b2;
process_cmb.Text = "";
MachineVo machinevo = (MachineVo)DefaultCbmInvoker.Invoke(new GetMachineMasterMntCbm(), new MachineVo());
machine_cmb.DisplayMember = "MachineName";
BindingSource b4 = new BindingSource(machinevo.MachineListVo, null);
machine_cmb.DataSource = b4;
machine_cmb.Text = "";
process_work_cmb.Text = "";
line_cmb.Text = "";
cause_cmb.Text = "";
action_cmb.Text = "";
if (reportDownTimeVo.DowntimeReportId > 0)
{
model_cmb.Text = reportDownTimeVo.ModelCode;
machine_cmb.Enabled = false;
process_cmb.Text = reportDownTimeVo.ProcessName;
process_work_cmb.Text = reportDownTimeVo.ProcessWorkName;
line_cmb.Text = reportDownTimeVo.LineCode;
cause_cmb.Text = reportDownTimeVo.DefectiveReasonName;
action_cmb.Text = reportDownTimeVo.ProductionWorkContentName;
remake_txt.Text = reportDownTimeVo.Remakes;
}
}
/// <summary>
/// Creates seacrh condition as per user inputs
/// </summary>
/// <returns>search condition</returns>
private ProcessVo FormConditionVo()
{
ProcessVo inVo = new ProcessVo();
if (ProcessCode_txt.Text != string.Empty)
{
inVo.ProcessCode = ProcessCode_txt.Text;
}
if (ProcessName_txt.Text != string.Empty)
{
inVo.ProcessName = ProcessName_txt.Text;
}
//if (NextProcessCode_txt.Text != string.Empty)
//{
// inVo.NextPocessCode = NextProcessCode_txt.Text;
//}
return(inVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
ProcessVo inVo = (ProcessVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Select Count(*) as ProcessCount from m_process ");
sqlQuery.Append(" where factory_cd = :factcd ");
if (inVo.ProcessCode != null)
{
sqlQuery.Append(" and UPPER(process_cd) = UPPER(:processcd)");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("factcd", UserData.GetUserData().FactoryCode);
if (inVo.ProcessCode != null)
{
sqlParameter.AddParameterString("processcd", inVo.ProcessCode);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
ProcessVo outVo = new ProcessVo();
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["ProcessCount"]);
}
dataReader.Close();
return outVo;
}
private void ModelProcessMasterForm_Load(object sender, EventArgs e)
{
try
{
ProcessVo processvo = (ProcessVo)DefaultCbmInvoker.Invoke(getProcessMasterMntCbm, new ProcessVo());
ValueObjectList <ModelVo> modellist = (ValueObjectList <ModelVo>)DefaultCbmInvoker.Invoke(getModelCbm, new ModelVo());
modelname_cmb.DisplayMember = "ModelName";
modelname_cmb.DataSource = modellist.GetList();
modelname_cmb.SelectedIndex = -1;
foreach (ProcessVo vo in processvo.ProcessListVo)
{
modelprocess.Add(new ModelProcess {
mvo = vo, Selected = false, ModelProcessId = 0
});
}
BindingSource bds = new BindingSource(modelprocess, null);
Process_dgv.DataSource = bds;
}
catch { } //gfg
}
/// <summary>
/// form country and factory data for combo
/// </summary>
private void FormDatatableFromVo()
{
processDatatable = new DataTable();
processDatatable.Columns.Add("id");
processDatatable.Columns.Add("code");
try
{
ProcessVo processOutVo = (ProcessVo)base.InvokeCbm(new GetProcessMasterMntCbm(), new ProcessVo(), false);
foreach (ProcessVo process in processOutVo.ProcessListVo)
{
processDatatable.Rows.Add(process.ProcessId, process.ProcessCode);
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
private void AddProcessWForm_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 = "";
ProcessVo processvo = (ProcessVo)DefaultCbmInvoker.Invoke(new GetProcessMasterMntCbm(), new ProcessVo());
Assy_cmb.DisplayMember = "ProcessName";
BindingSource b2 = new BindingSource(processvo.ProcessListVo, null);
Assy_cmb.DataSource = b2;
Assy_cmb.Text = "";
MachineVo machinevo = (MachineVo)DefaultCbmInvoker.Invoke(new GetMachineMasterMntCbm(), new MachineVo());
Machine_cmb.DisplayMember = "MachineName";
BindingSource b4 = new BindingSource(machinevo.MachineListVo, null);
Machine_cmb.DataSource = b4;
Machine_cmb.Text = "";
ProcessCode_txt.Select();
Model_cmb.ResetText();
Assy_cmb.ResetText();
Machine_cmb.ResetText();
if (vo.ProcessWorkId > 0)
{
ProcessCode_txt.Text = vo.ProcessWorkCode;
ProcessName_txt.Text = vo.ProcessWorkName;
Model_cmb.Text = vo.Model;
Assy_cmb.Text = vo.Assy;
Machine_cmb.Text = vo.Machine;
}
}
private static ProcessVo ToVo(ProcessEntity entity)
{
var process = new ProcessVo();
process.Id = entity.Id;
process.Name = entity.Name;
process.Description = entity.Description;
process.DataStatus = entity.DataStatus;
process.StepList = JsonConvert.DeserializeObject <List <StepVo> >(entity.Steps);
if (!string.IsNullOrEmpty(entity.Params))
{
process.ParamList = JsonConvert.DeserializeObject <List <ParamVo> >(entity.Params);
}
process.CreateBy = entity.CreateBy;
process.CreateTime = entity.CreateTime;
process.LastUpdateBy = entity.LastUpdateBy;
process.LastUpdateTime = entity.LastUpdateTime;
return(process);
}
private ProcessEntity ToEntity(ProcessVo process)
{
ProcessEntity entity = new ProcessEntity();
entity.Id = process.Id;
entity.Name = process.Name;
entity.Description = process.Description;
if (process.StepList != null && process.StepList.Count > 0)
{
entity.Steps = JsonConvert.SerializeObject(process.StepList);
}
if (process.ParamList != null && process.ParamList.Count > 0)
{
entity.Params = JsonConvert.SerializeObject(process.ParamList);
}
entity.DataStatus = 1;
entity.CreateBy = "HarrisZhang";
entity.CreateTime = DateTime.Now;
entity.LastUpdateBy = "HarrisZhang";
entity.LastUpdateTime = DateTime.Now;
return(entity);
}
/// <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 = Process_dgv.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = Process_dgv.Rows[selectedrowindex];
messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, selectedRow.Cells["colProcessCode"].Value.ToString());
// Logger.Info(messageData);
DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text);
if (dialogResult == DialogResult.OK)
{
ProcessVo inVo = new ProcessVo
{
ProcessId = Convert.ToInt32(selectedRow.Cells["colProcessId"].Value),
ProcessCode = selectedRow.Cells["colProcessCode"].Value.ToString()
};
try
{
ProcessVo checkVo = CheckRelation(inVo);
if (checkVo != null)
{
StringBuilder message = new StringBuilder();
if (checkVo.UserProcessId > 0)
{
message.Append(ProcessRelationTables.UserProcess);
}
if (checkVo.ProcessWorkId > 0)
{
if (message.Length > 0)
{
message.Append(" And ");
}
message.Append(ProcessRelationTables.ProcessWork);
}
if (message.Length > 0)
{
messageData = new MessageData("mmce00007", Properties.Resources.mmce00007, message.ToString());
popUpMessage.Information(messageData, Text);
return;
}
}
ProcessVo outVo = (ProcessVo)base.InvokeCbm(new DeleteProcessMasterMntCbm(), 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
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
ProcessVo inVo = (ProcessVo)arg;
ProcessVo outVo = new ProcessVo();
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Select * from m_process ");
sqlQuery.Append(" where factory_cd = :factcd ");
if (inVo.ProcessCode != null)
{
sqlQuery.Append(" and process_cd like :processcd ");
}
if (inVo.ProcessName != null)
{
sqlQuery.Append(" and process_name like :processname ");
}
//if (inVo.NextPocessCode != null)
//{
// sqlQuery.Append(" and next_process_cd like :nextprocesscd ");
//}
sqlQuery.Append(" order by process_cd");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("factcd", UserData.GetUserData().FactoryCode);
if (inVo.ProcessCode != null)
{
sqlParameter.AddParameterString("processcd", inVo.ProcessCode + "%");
}
if (inVo.ProcessName != null)
{
sqlParameter.AddParameterString("processname", inVo.ProcessName + "%");
}
//if (inVo.NextPocessCode != null)
//{
// sqlParameter.AddParameterString("nextprocesscd", inVo.NextPocessCode + "%");
//}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
ProcessVo currOutVo = new ProcessVo
{
ProcessId = Convert.ToInt32(dataReader["process_id"]),
ProcessCode = dataReader["process_cd"].ToString(),
ProcessName = dataReader["process_name"].ToString()
//NextPocessCode = dataReader["next_process_cd"].ToString()
};
outVo.ProcessListVo.Add(currOutVo);
}
dataReader.Close();
return(outVo);
}
/// <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())
{
string nextPocessCode = string.Empty;
var sch = StringCheckHelper.GetInstance();
if (!sch.IsASCII(ProcessCode_txt.Text))
{
messageData = new MessageData("mmce00003", Properties.Resources.mmce00003);
logger.Info(messageData);
popUpMessage.ConfirmationOkCancel(messageData, Text);
ProcessCode_txt.Focus();
return;
}
else if (!sch.IsASCII(ProcessName_txt.Text))
{
messageData = new MessageData("mmce00003", Properties.Resources.mmce00003);
logger.Info(messageData);
popUpMessage.ConfirmationOkCancel(messageData, Text);
ProcessName_txt.Focus();
return;
}
//if (NextProcessCode_txt.Text != null)
//{
// nextPocessCode = NextProcessCode_txt.Text;
//}
ProcessVo inVo = new ProcessVo
{
ProcessCode = ProcessCode_txt.Text.Trim(),
ProcessName = ProcessName_txt.Text.Trim(),
//NextPocessCode = nextPocessCode,
//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))
{
ProcessVo checkVo = DuplicateCheck(inVo);
if (checkVo != null && checkVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, ProcessCode_lbl.Text + " : " + ProcessCode_txt.Text);
logger.Info(messageData);
popUpMessage.ApplicationError(messageData, Text);
return;
}
}
try
{
if (string.Equals(mode, CommonConstants.MODE_ADD))
{
ProcessVo outVo = (ProcessVo)base.InvokeCbm(new AddProcessMasterMntCbm(), inVo, false);
IntSuccess = outVo.AffectedCount;
}
else if (mode.Equals(CommonConstants.MODE_UPDATE))
{
inVo.ProcessId = updateData.ProcessId;
ProcessVo outVo = (ProcessVo)base.InvokeCbm(new UpdateProcessMasterMntCbm(), 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();
}
}
}
