private void LoadProcessWork(int pMachineId) { ProcessWorkVo outVo = null; try { outVo = (ProcessWorkVo)DefaultCbmInvoker.Invoke(new GetProcessWorkMasterMntCbm(), new ProcessWorkVo()); outVo.ProcessWorkListVo.ForEach(t => t.ProcessWorkName = string.Concat(t.ProcessWorkCode + " ", t.ProcessWorkName)); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } ProcessWorkMachineVo processMachineLineInVo = new ProcessWorkMachineVo(); processMachineLineInVo.MachineId = pMachineId; ProcessWorkMachineVo processWorkMachineOutVo = (ProcessWorkMachineVo)DefaultCbmInvoker.Invoke(new GetProcessWorkMachineMasterMntCbm(), processMachineLineInVo); if (processWorkMachineOutVo != null && pMachineId > 0) { foreach (ProcessWorkVo item in outVo.ProcessWorkListVo) { item.IsExists = processWorkMachineOutVo.ProcessWorkMachineListVo.Exists(t => t.ProcessWorkId == item.ProcessWorkId) ? "True" : "False"; } } BindingSource bindingSource = new BindingSource(outVo.ProcessWorkListVo, null); ProcessWork_dgv.AutoGenerateColumns = false; ProcessWork_dgv.DataSource = bindingSource; }
public ValueObject Execute(TransactionContext trxContext, ValueObject vo) { List <ValueObject> inList = ((ValueObjectList <ValueObject>)vo).GetList(); MachineVo machineInVo = (MachineVo)inList.FirstOrDefault(); ProcessWorkMachineVo processWorkMachineInVo = (ProcessWorkMachineVo)inList.Skip(1).FirstOrDefault(); MachineVo machineOutVo = (MachineVo)updateMachineMasterMntCbm.Execute(trxContext, machineInVo); if (machineOutVo.AffectedCount > 0) { ProcessWorkMachineVo deleteInVo = new ProcessWorkMachineVo(); deleteInVo.MachineId = machineInVo.MachineId; ProcessWorkMachineVo deleteOutVo = (ProcessWorkMachineVo)deleteProcessWorkMachineMasterMntCbm.Execute(trxContext, deleteInVo); foreach (ProcessWorkMachineVo curInVo in processWorkMachineInVo.ProcessWorkMachineListVo) { curInVo.MachineId = machineInVo.MachineId; ProcessWorkMachineVo processWorkLineOutVo = (ProcessWorkMachineVo)addProcessWorkMachineMasterMntCbm.Execute(trxContext, curInVo); } } return(machineOutVo); }
public ValueObject Execute(TransactionContext trxContext, ValueObject vo) { List <ValueObject> inList = ((ValueObjectList <ValueObject>)vo).GetList(); MachineVo machineInVo = (MachineVo)inList.FirstOrDefault(); ProcessWorkMachineVo processWorkMachineInVo = (ProcessWorkMachineVo)inList.Skip(1).FirstOrDefault(); MachineVo machineOutVo = (MachineVo)addMachineMasterMntCbm.Execute(trxContext, machineInVo); int count = 0; if (machineOutVo != null && machineOutVo.MachineId > 0) { count += 1; foreach (ProcessWorkMachineVo curInVo in processWorkMachineInVo.ProcessWorkMachineListVo) { curInVo.MachineId = machineOutVo.MachineId; ProcessWorkMachineVo processWorkMachineOutVo = (ProcessWorkMachineVo)addProcessWorkMachineMasterMntCbm.Execute(trxContext, curInVo); } } machineOutVo.AffectedCount = count; return(machineOutVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { ProcessWorkMachineVo inVo = (ProcessWorkMachineVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Select pwm.process_work_id, pwm.machine_id,ls.machine_name"); sqlQuery.Append(" from m_processwork_machine pwm "); sqlQuery.Append(" inner join m_machine ls on ls.machine_id = pwm.machine_id "); sqlQuery.Append(" where 1 = 1 "); if (inVo.ProcessWorkId > 0) { sqlQuery.Append(" and pwm.process_work_id = :processworkid "); } if (inVo.MachineName != null) { sqlQuery.Append(" and machine_name like :machinename "); } sqlQuery.Append(" order by machine_name "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); if (inVo.ProcessWorkId > 0) { sqlParameter.AddParameterInteger("processworkid", inVo.ProcessWorkId); } if (inVo.MachineName != null) { sqlParameter.AddParameterString("machinename", inVo.MachineName + "%"); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); ProcessWorkMachineVo outVo = new ProcessWorkMachineVo(); while (dataReader.Read()) { ProcessWorkMachineVo currOutVo = new ProcessWorkMachineVo { MachineId = Convert.ToInt32(dataReader["machine_id"]), MachineName = dataReader["machine_name"].ToString(), }; outVo.ProcessWorkMachineListVo.Add(currOutVo); } dataReader.Close(); return(outVo); }
public ValueObject Execute(TransactionContext trxContext, ValueObject vo) { MachineVo deleteMachineOutVo = (MachineVo)deleteMachineMasterMntCbm.Execute(trxContext, vo); if (deleteMachineOutVo.AffectedCount > 0) { ProcessWorkMachineVo inVo = new ProcessWorkMachineVo(); inVo.MachineId = ((MachineVo)vo).MachineId; ProcessWorkMachineVo deleteProcessWorkMachineOutVo = (ProcessWorkMachineVo)deleteProcessWorkMachineMasterMntCbm.Execute(trxContext, inVo); } return(deleteMachineOutVo); }
/// <summary> /// checks duplicate Process Code /// </summary> /// <param name="processVo"></param> /// <returns></returns> private ProcessWorkMachineVo DuplicateCheck(ProcessWorkMachineVo pwmachineVo) { ProcessWorkMachineVo outVo = new ProcessWorkMachineVo(); try { outVo = (ProcessWorkMachineVo)base.InvokeCbm(new CheckProcessWorkMachineMasterMntCbm(), pwmachineVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } return(outVo); }
private void ProcessWork_lst_SelectedIndexChanged(object sender, EventArgs e) { if (isProcessListLoading) { return; } if (ProcessWork_lst.SelectedIndex < 0) { return; } if (Machine_chlst.Items.Count == 0) { LoadMachineListBox(); } this.Cursor = Cursors.WaitCursor; ProcessWorkMachineVo inVo = new ProcessWorkMachineVo(); //inVo.ProcessWorkId = Convert.ToInt32(ProcessWork_lst.SelectedIndex); inVo.ProcessWorkId = Convert.ToInt32(ProcessWork_lst.SelectedValue.ToString()); ProcessWorkMachineVo checkVo = (ProcessWorkMachineVo)base.InvokeCbm(new GetProcessWorkMachineMasterMntCbm(), new ProcessWorkMachineVo(), false); Machine_chlst.ClearSelected(); //for (int i = 0; i < Machine_chlst.Items.Count - 1; i++) //{ // var machine = (MachineVo)Machine_chlst.Items[i]; // if (checkVo.ProcessWorkMachineListVo.Exists(x => x.MachineId == machine.MachineId)) // { // Machine_chlst.SetItemCheckState(i, CheckState.Indeterminate); // } //} ProcessWorkMachineVo outVo = (ProcessWorkMachineVo)base.InvokeCbm(new GetProcessWorkMachineMasterMntCbm(), inVo, false); for (int i = 0; i < Machine_chlst.Items.Count; i++) { var machine = (MachineVo)Machine_chlst.Items[i]; Machine_chlst.SetItemChecked(i, outVo.ProcessWorkMachineListVo.Exists(x => x.MachineId == machine.MachineId)); } this.Cursor = Cursors.Default; }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { ProcessWorkMachineVo inVo = (ProcessWorkMachineVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Delete from m_processwork_machine"); sqlQuery.Append(" where factory_cd = :faccd "); if (inVo.ProcessWorkId > 0) { sqlQuery.Append(" AND process_work_id = :processworkid"); } if (inVo.MachineId > 0) { sqlQuery.Append(" AND machine_id = :machineid"); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); if (inVo.ProcessWorkId > 0) { sqlParameter.AddParameterInteger("processworkid", inVo.ProcessWorkId); } if (inVo.MachineId > 0) { sqlParameter.AddParameterInteger("machineid", inVo.MachineId); } ProcessWorkMachineVo outVo = new ProcessWorkMachineVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { ProcessWorkMachineVo inVo = (ProcessWorkMachineVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Select Count(*) as WorkCount from m_processwork_machine"); sqlQuery.Append(" where factory_cd = :faccd "); if (inVo.MachineId >= 0) { sqlQuery.Append(" and machine_id = :machineid"); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); if (inVo.MachineId >= 0) { sqlParameter.AddParameterInteger("machineid", inVo.MachineId); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); ProcessWorkMachineVo outVo = new ProcessWorkMachineVo(); while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32(dataReader["WorkCount"]); } dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { ProcessWorkMachineVo inVo = (ProcessWorkMachineVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_processwork_machine"); sqlQuery.Append(" ( "); sqlQuery.Append(" process_work_id, "); sqlQuery.Append(" machine_id, "); sqlQuery.Append(" registration_user_cd, "); sqlQuery.Append(" registration_date_time, "); sqlQuery.Append(" factory_cd "); sqlQuery.Append(" ) "); sqlQuery.Append("VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :processworkid ,"); sqlQuery.Append(" :machineid ,"); 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.AddParameterInteger("machineid", inVo.MachineId); sqlParameter.AddParameterInteger("processworkid", inVo.ProcessWorkId); sqlParameter.AddParameterString("registrationusercode", UserData.GetUserData().UserCode); sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycode", UserData.GetUserData().FactoryCode); ProcessWorkMachineVo outVo = new ProcessWorkMachineVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
private ProcessWorkMachineVo GetSelectedProcessWork() { BindingSource bsProcessWork = (BindingSource)ProcessWork_dgv.DataSource; ProcessWorkMachineVo processWorkMachineInVo = new ProcessWorkMachineVo(); if (bsProcessWork != null && bsProcessWork.List.Count > 0) { foreach (ProcessWorkVo processWorkVo in bsProcessWork.List) { if (processWorkVo.IsExists == "True") { ProcessWorkMachineVo addVo = new ProcessWorkMachineVo() { ProcessWorkId = processWorkVo.ProcessWorkId }; processWorkMachineInVo.ProcessWorkMachineListVo.Add(addVo); } } } return(processWorkMachineInVo); }
/// <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) { try { if (CheckMandatory()) { ProcessWorkMachineVo inVo = new ProcessWorkMachineVo(); inVo.ProcessWorkId = Convert.ToInt32(ProcessWork_lst.SelectedValue); ProcessWorkMachineVo outDeleteCheckVo = (ProcessWorkMachineVo)base.InvokeCbm(new GetProcessWorkMachineMasterMntCbm(), inVo, false); if (outDeleteCheckVo.ProcessWorkMachineListVo.Count > 0) { ProcessWorkMachineVo outDeleteVo = (ProcessWorkMachineVo)base.InvokeCbm(new DeleteProcessWorkMachineMasterMntCbm(), inVo, false); IntDelSuccess = outDeleteVo.AffectedCount; } ProcessWorkMachineVo outVo = new ProcessWorkMachineVo(); inVo.FactoryCode = UserData.GetUserData().FactoryCode; inVo.RegistrationUserCode = UserData.GetUserData().UserCode; foreach (var item in Machine_chlst.CheckedItems) { var machine = (MachineVo)item; inVo.MachineId = machine.MachineId; if (Properties.Settings.Default.MACHINE_PER_PROCESSWORK_CONSTRAINT) { ProcessWorkMachineVo checkVo = DuplicateCheck(inVo); if (checkVo != null && checkVo.AffectedCount > 0) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, Machine_lbl.Text + " : " + Machine_chlst.Text); logger.Info(messageData); popUpMessage.ApplicationError(messageData, Text); return; } } outVo = (ProcessWorkMachineVo)base.InvokeCbm(new AddProcessWorkMachineMasterMntCbm(), inVo, false); } IntSuccess = outVo.AffectedCount; if ((IntSuccess > 0) || (IntDelSuccess > 0)) { messageData = new MessageData("mmci00002", Properties.Resources.mmci00002, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); } } } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } }
private void Save_btn_Click(object sender, EventArgs e) { if (Machine_dgv.RowCount > 0 && Machine_dgv.Columns["colRemarks"].Visible == true) { if (processWorkList.Count == 0) { GetProcessWork(); } this.StartProgress(Properties.Resources.mmci00009); string previousMachineCode = string.Empty; int uploadedCount = 0; int insertedCount = 0; MachineVo machineVo = new MachineVo(); ProcessWorkMachineVo processWorkMachineVo = new ProcessWorkMachineVo(); foreach (DataRow row in excelUploadDt.Rows) { if (!string.IsNullOrEmpty(row["MachineCode"].ToString()) && previousMachineCode != row["MachineCode"].ToString()) { machineVo = new MachineVo(); processWorkMachineVo = new ProcessWorkMachineVo(); machineVo.MachineCode = row["MachineCode"].ToString(); machineVo.MachineName = row["MachineName"].ToString(); uploadedCount += 1; DataRow[] processWorkCodeList = excelUploadDt.Select("MachineCode = '" + machineVo.MachineCode + "'"); foreach (DataRow item in processWorkCodeList) { ProcessWorkMachineVo addVo = new ProcessWorkMachineVo(); if (processWorkList.Where(t => t.ProcessWorkCode == item["ProcessWorkCode"].ToString()).FirstOrDefault() != null) { addVo.ProcessWorkId = processWorkList.Where(t => t.ProcessWorkCode == item["ProcessWorkCode"].ToString()).FirstOrDefault().ProcessWorkId; processWorkMachineVo.ProcessWorkMachineListVo.Add(addVo); } } ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>(); inVoList.add(machineVo); inVoList.add(processWorkMachineVo); MachineVo outVo = null; try { outVo = (MachineVo)base.InvokeCbm(new AddMachineMasterAndProcessworkCbm(), inVoList, false); } catch (Framework.ApplicationException exception) { this.CompleteProgress(); popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } if (outVo != null && outVo.AffectedCount > 0) { insertedCount += outVo.AffectedCount; } } previousMachineCode = row["MachineCode"].ToString(); } this.CompleteProgress(); if (insertedCount > 0 && uploadedCount > 0 && insertedCount == uploadedCount) { messageData = new MessageData("mmci00010", Properties.Resources.mmci00010, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); GridBind(FormConditionVo()); } } else { messageData = new MessageData("mmci00016", Properties.Resources.mmci00016, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); } }
private void Upload_btn_Click(object sender, EventArgs e) { OpenFileDialog openDialog_dlg = new OpenFileDialog(); openDialog_dlg.Filter = "Excel Files(*.xls) |*.xls"; if (openDialog_dlg.ShowDialog() == DialogResult.OK) { this.StartProgress(Properties.Resources.mmci00009); try { excelUploadDt = new ExcelUpload().ReadExcel(openDialog_dlg.FileName, Properties.Settings.Default.EXCEL_SHEET_MACHINE_MASTER); } catch (Framework.ApplicationException exception) { this.CompleteProgress(); popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } MachineVo machineVo = new MachineVo(); ProcessWorkMachineVo processWorkMachineVo = new ProcessWorkMachineVo(); Machine_dgv.DataSource = null; excelUploadDt.Columns.Add("Remarks"); var sch = StringCheckHelper.GetInstance(); bool inputDataNG = false; foreach (DataRow row in excelUploadDt.Rows) { if (row["MachineCode"] == null || string.IsNullOrWhiteSpace(row["MachineCode"].ToString())) { row["Remarks"] = string.Format(Properties.Resources.mmce00011, MachineCode_lbl.Text); inputDataNG = true; continue; } if (!sch.IsASCII(row["MachineCode"].ToString())) { row["Remarks"] = string.Format(Properties.Resources.mmci00017, MachineCode_lbl.Text); inputDataNG = true; continue; } if (row["MachineName"] == null || string.IsNullOrWhiteSpace(row["MachineName"].ToString())) { row["Remarks"] = string.Format(Properties.Resources.mmce00011, MachineName_lbl.Text); inputDataNG = true; continue; } var duplicates = excelUploadDt.AsEnumerable().GroupBy(r => r["MachineCode"]).Where(gr => gr.Count() > 1).ToList(); if (duplicates.Any() && duplicates.Select(dupl => dupl.Key).ToList().FirstOrDefault().ToString() == row["MachineCode"].ToString()) { row["Remarks"] = string.Format(Properties.Resources.mmce00009, MachineCode_lbl.Text + " : " + row["MachineCode"].ToString()); inputDataNG = true; continue; } machineVo = new MachineVo(); processWorkMachineVo = new ProcessWorkMachineVo(); machineVo.MachineCode = row["MachineCode"].ToString(); machineVo.MachineName = row["MachineName"].ToString(); if (!ValidateProcessWorkCodeInExcel(excelUploadDt, machineVo.MachineCode)) { row["Remarks"] = string.Format(Properties.Resources.mmci00019); inputDataNG = true; continue; } MachineVo checkVo = DuplicateCheck(machineVo); if (checkVo != null && checkVo.AffectedCount > 0) { row["Remarks"] = string.Format(Properties.Resources.mmce00012, MachineCode_lbl.Text + " : " + machineVo.MachineCode); inputDataNG = true; continue; } } Machine_dgv.AutoGenerateColumns = false; isExcelUpload = true; Machine_dgv.Columns["colRemarks"].Visible = true; Machine_dgv.DataSource = excelUploadDt; if (inputDataNG) { Save_btn.Enabled = false; } else { Save_btn.Enabled = true; } this.CompleteProgress(); } }