public ValueObject Execute(TransactionContext trxContext, ValueObject vo) { List <ValueObject> inList = ((ValueObjectList <ValueObject>)vo).GetList(); LineVo lineInVo = (LineVo)inList.FirstOrDefault(); ProcessWorkLineVo processWorkLineInVo = (ProcessWorkLineVo)inList.Skip(1).FirstOrDefault(); LineVo lineOutVo = (LineVo)addLineMasterMntCbm.Execute(trxContext, lineInVo); int count = 0; if (lineOutVo != null && lineOutVo.LineId > 0) { count += 1; foreach (ProcessWorkLineVo curInVo in processWorkLineInVo.ProcessWorkLineListVo) { curInVo.LineId = lineOutVo.LineId; ProcessWorkLineVo processWorkLineOutVo = (ProcessWorkLineVo)addProcessWorkLineMasterMntCbm.Execute(trxContext, curInVo); } } lineOutVo.AffectedCount = count; return(lineOutVo); }
private void LoadProcessWork(int pLineId) { 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()); } ProcessWorkLineVo processWorkLineInVo = new ProcessWorkLineVo(); processWorkLineInVo.LineId = pLineId; ProcessWorkLineVo processWorkLineOutVo = (ProcessWorkLineVo)DefaultCbmInvoker.Invoke(new GetProcessWorkLineMasterMntCbm(), processWorkLineInVo); if (processWorkLineOutVo != null && pLineId > 0) { foreach (ProcessWorkVo item in outVo.ProcessWorkListVo) { item.IsExists = processWorkLineOutVo.ProcessWorkLineListVo.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(); LineVo lineInVo = (LineVo)inList.FirstOrDefault(); ProcessWorkLineVo processWorkLineInVo = (ProcessWorkLineVo)inList.Skip(1).FirstOrDefault(); LineVo lineOutVo = (LineVo)updateLineMasterMntCbm.Execute(trxContext, lineInVo); if (lineOutVo.AffectedCount > 0) { ProcessWorkLineVo deleteInVo = new ProcessWorkLineVo(); deleteInVo.LineId = lineInVo.LineId; ProcessWorkLineVo deleteOutVo = (ProcessWorkLineVo)deleteProcessWorkLineMasterMntCbm.Execute(trxContext, deleteInVo); foreach (ProcessWorkLineVo curInVo in processWorkLineInVo.ProcessWorkLineListVo) { curInVo.LineId = lineInVo.LineId; ProcessWorkLineVo processWorkLineOutVo = (ProcessWorkLineVo)addProcessWorkLineMasterMntCbm.Execute(trxContext, curInVo); } } return(lineOutVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { ProcessWorkLineVo inVo = (ProcessWorkLineVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Select pwm.process_work_id, pwm.line_id,ls.line_name"); sqlQuery.Append(" from m_processwork_line pwm "); sqlQuery.Append(" inner join m_line ls on ls.line_id = pwm.line_id "); sqlQuery.Append(" where 1 = 1 "); if (inVo.ProcessWorkId > 0) { sqlQuery.Append(" and pwm.process_work_id = :processworkid "); } if (inVo.LineName != null) { sqlQuery.Append(" and line_name like :linename "); } sqlQuery.Append(" order by line_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.LineName != null) { sqlParameter.AddParameterString("linename", inVo.LineName + "%"); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); ProcessWorkLineVo outVo = new ProcessWorkLineVo(); while (dataReader.Read()) { ProcessWorkLineVo currOutVo = new ProcessWorkLineVo { LineId = Convert.ToInt32(dataReader["line_id"]), LineName = dataReader["line_name"].ToString(), }; outVo.ProcessWorkLineListVo.Add(currOutVo); } dataReader.Close(); return(outVo); }
public ValueObject Execute(TransactionContext trxContext, ValueObject vo) { LineVo deleteLineOutVo = (LineVo)deleteLineMasterMntCbm.Execute(trxContext, vo); if (deleteLineOutVo.AffectedCount > 0) { ProcessWorkLineVo inVo = new ProcessWorkLineVo(); inVo.LineId = ((LineVo)vo).LineId; ProcessWorkLineVo deleteProcessWorkLineOutVo = (ProcessWorkLineVo)deleteProcessWorkLineMasterMntCbm.Execute(trxContext, inVo); } return(deleteLineOutVo); }
/// <summary> /// checks duplicate Process Code /// </summary> /// <param name="processVo"></param> /// <returns></returns> private ProcessWorkLineVo DuplicateCheck(ProcessWorkLineVo pwLineVo) { ProcessWorkLineVo outVo = new ProcessWorkLineVo(); try { outVo = (ProcessWorkLineVo)base.InvokeCbm(new CheckProcessWorkLineMasterMntCbm(), pwLineVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { ProcessWorkLineVo inVo = (ProcessWorkLineVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Delete from m_processwork_line"); sqlQuery.Append(" where factory_cd = :faccd "); if (inVo.ProcessWorkId > 0) { sqlQuery.Append(" AND process_work_id = :processworkid"); } if (inVo.LineId > 0) { sqlQuery.Append(" AND line_id = :lineid"); } //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.LineId > 0) { sqlParameter.AddParameterInteger("lineid", inVo.LineId); } ProcessWorkLineVo outVo = new ProcessWorkLineVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { ProcessWorkLineVo inVo = (ProcessWorkLineVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_processwork_line"); sqlQuery.Append(" ( "); sqlQuery.Append(" process_work_id, "); sqlQuery.Append(" line_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(" :lineid ,"); 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("lineid", inVo.LineId); sqlParameter.AddParameterInteger("processworkid", inVo.ProcessWorkId); sqlParameter.AddParameterString("registrationusercode", UserData.GetUserData().UserCode); sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycode", UserData.GetUserData().FactoryCode); ProcessWorkLineVo outVo = new ProcessWorkLineVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { ProcessWorkLineVo inVo = (ProcessWorkLineVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Select Count(*) as WorkCount from m_processwork_line"); sqlQuery.Append(" where factory_cd = :faccd "); if (inVo.LineId >= 0) { sqlQuery.Append(" and line_id = :lineid"); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); if (inVo.LineId >= 0) { sqlParameter.AddParameterInteger("lineid", inVo.LineId); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); ProcessWorkLineVo outVo = new ProcessWorkLineVo(); while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32(dataReader["WorkCount"]); } dataReader.Close(); return(outVo); }
private ProcessWorkLineVo GetSelectedProcessWork() { BindingSource bsProcessWork = (BindingSource)ProcessWork_dgv.DataSource; ProcessWorkLineVo processWorkLineInVo = new ProcessWorkLineVo(); if (bsProcessWork != null && bsProcessWork.List.Count > 0) { foreach (ProcessWorkVo processWorkVo in bsProcessWork.List) { if (processWorkVo.IsExists == "True") { ProcessWorkLineVo addVo = new ProcessWorkLineVo() { ProcessWorkId = processWorkVo.ProcessWorkId }; processWorkLineInVo.ProcessWorkLineListVo.Add(addVo); } } } return(processWorkLineInVo); }
private void ProcessWork_lst_SelectedIndexChanged(object sender, EventArgs e) { if (isProcessListLoading) { return; } if (ProcessWork_lst.SelectedIndex < 0) { return; } if (Line_chlst.Items.Count == 0) { LoadLineListBox(); } this.Cursor = Cursors.WaitCursor; ProcessWorkLineVo inVo = new ProcessWorkLineVo(); inVo.ProcessWorkId = Convert.ToInt32(ProcessWork_lst.SelectedValue.ToString()); ProcessWorkLineVo checkVo = (ProcessWorkLineVo)base.InvokeCbm(new GetProcessWorkLineMasterMntCbm(), new ProcessWorkLineVo(), false); Line_chlst.ClearSelected(); ProcessWorkLineVo outVo = (ProcessWorkLineVo)base.InvokeCbm(new GetProcessWorkLineMasterMntCbm(), inVo, false); for (int i = 0; i < Line_chlst.Items.Count; i++) { var Line = (LineVo)Line_chlst.Items[i]; Line_chlst.SetItemChecked(i, outVo.ProcessWorkLineListVo.Exists(x => x.LineId == Line.LineId)); } this.Cursor = Cursors.Default; }
private void Save_btn_Click(object sender, EventArgs e) { if (LineDetails_dgv.RowCount > 0 && LineDetails_dgv.Columns["colRemarks"].Visible == true) { if (processWorkList.Count == 0) { GetProcessWork(); } this.StartProgress(Properties.Resources.mmci00009); string previousLineCode = string.Empty; int uploadedCount = 0; int insertedCount = 0; LineVo lineVo = new LineVo(); ProcessWorkLineVo processWorkLineVo = new ProcessWorkLineVo(); foreach (DataRow row in excelUploadDt.Rows) { if (!string.IsNullOrEmpty(row["LineCode"].ToString()) && previousLineCode != row["LineCode"].ToString()) { lineVo = new LineVo(); processWorkLineVo = new ProcessWorkLineVo(); lineVo.LineCode = row["LineCode"].ToString(); lineVo.LineName = row["LineName"].ToString(); uploadedCount += 1; DataRow[] processWorkCodeList = excelUploadDt.Select("LineCode = '" + lineVo.LineCode + "'"); foreach (DataRow item in processWorkCodeList) { ProcessWorkLineVo addVo = new ProcessWorkLineVo(); ProcessWorkVo processWorkVo = processWorkList.Where(t => t.ProcessWorkCode == item["ProcessWorkCode"].ToString()).FirstOrDefault(); if (processWorkVo != null && processWorkVo.ProcessWorkId > 0) { addVo.ProcessWorkId = processWorkVo.ProcessWorkId; processWorkLineVo.ProcessWorkLineListVo.Add(addVo); } } ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>(); inVoList.add(lineVo); inVoList.add(processWorkLineVo); LineVo outVo = null; try { outVo = (LineVo)base.InvokeCbm(new AddLineMasterAndProcessworkCbm(), 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; } } previousLineCode = row["LineCode"].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_LINE_MASTER); } catch (Framework.ApplicationException exception) { this.CompleteProgress(); popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } LineVo lineVo = new LineVo(); ProcessWorkLineVo processWorkLineVo = new ProcessWorkLineVo(); LineDetails_dgv.DataSource = null; excelUploadDt.Columns.Add("Remarks"); var sch = StringCheckHelper.GetInstance(); bool inputDataNG = false; foreach (DataRow row in excelUploadDt.Rows) { if (row["LineCode"] == null || string.IsNullOrWhiteSpace(row["LineCode"].ToString())) { row["Remarks"] = string.Format(Properties.Resources.mmce00011, LineCode_lbl.Text); inputDataNG = true; continue; } if (!sch.IsASCII(row["LineCode"].ToString())) { row["Remarks"] = string.Format(Properties.Resources.mmci00017, LineCode_lbl.Text); inputDataNG = true; continue; } if (row["LineName"] == null || string.IsNullOrWhiteSpace(row["LineName"].ToString())) { row["Remarks"] = string.Format(Properties.Resources.mmce00011, LineName_lbl.Text); inputDataNG = true; continue; } lineVo = new LineVo(); processWorkLineVo = new ProcessWorkLineVo(); lineVo.LineCode = row["LineCode"].ToString(); lineVo.LineName = row["LineName"].ToString(); if (!ValidateProcessWorkCodeInExcel(excelUploadDt, lineVo.LineCode)) { row["Remarks"] = string.Format(Properties.Resources.mmci00019); inputDataNG = true; continue; } LineVo checkVo = DuplicateCheck(lineVo); if (checkVo != null && checkVo.AffectedCount > 0) { row["Remarks"] = string.Format(Properties.Resources.mmce00012, LineCode_lbl.Text + " : " + lineVo.LineCode); inputDataNG = true; continue; } var duplicates = excelUploadDt.AsEnumerable().GroupBy(r => r["LineCode"]).Where(gr => gr.Count() > 1).ToList(); if (duplicates.Any() && duplicates.Select(dupl => dupl.Key).ToList().FirstOrDefault().ToString() == row["LineCode"].ToString()) { row["Remarks"] = string.Format(Properties.Resources.mmce00009, LineCode_lbl.Text + " : " + row["LineCode"].ToString()); inputDataNG = true; continue; } } LineDetails_dgv.AutoGenerateColumns = false; isExcelUpload = true; LineDetails_dgv.Columns["colRemarks"].Visible = true; LineDetails_dgv.DataSource = excelUploadDt; if (inputDataNG) { Save_btn.Enabled = false; } else { Save_btn.Enabled = true; } this.CompleteProgress(); } }
/// <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()) { ProcessWorkLineVo inVo = new ProcessWorkLineVo(); inVo.ProcessWorkId = Convert.ToInt32(ProcessWork_lst.SelectedValue); ProcessWorkLineVo outDeleteCheckVo = (ProcessWorkLineVo)base.InvokeCbm(new GetProcessWorkLineMasterMntCbm(), inVo, false); if (outDeleteCheckVo.ProcessWorkLineListVo.Count > 0) { ProcessWorkLineVo outDeleteVo = (ProcessWorkLineVo)base.InvokeCbm(new DeleteProcessWorkLineMasterMntCbm(), inVo, false); IntDelSuccess = outDeleteVo.AffectedCount; } ProcessWorkLineVo outVo = new ProcessWorkLineVo(); inVo.FactoryCode = UserData.GetUserData().FactoryCode; inVo.RegistrationUserCode = UserData.GetUserData().UserCode; foreach (var item in Line_chlst.CheckedItems) { var Line = (LineVo)item; inVo.LineId = Line.LineId; if (Properties.Settings.Default.LINE_PER_PROCESSWORK_CONSTRAINT) { ProcessWorkLineVo checkVo = DuplicateCheck(inVo); if (checkVo != null && checkVo.AffectedCount > 0) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, Line_lbl.Text + " : " + Line_chlst.Text); logger.Info(messageData); popUpMessage.ApplicationError(messageData, Text); return; } } outVo = (ProcessWorkLineVo)base.InvokeCbm(new AddProcessWorkLineMasterMntCbm(), 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; } }