/// <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(); } } }