/// <summary> /// inserts new record /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Ok_btn_Click(object sender, EventArgs e) { InspectionSpecificationVo inVo = new InspectionSpecificationVo(); var sch = StringCheckHelper.GetInstance(); if (!CheckMandatory()) { return; } inVo.InspectionSpecificationText = InspectionSpecificationText_txt.Text.Trim(); if (InspectionItemDataType == Convert.ToInt32(GlobalMasterDataTypeEnum.DATATYPE_DATETIME.GetValue()) && DateTime_pnl.Visible) { inVo.ValueFrom = DateFrom_dtp.Value.ToString(); if (!string.IsNullOrEmpty(DateTo_dtp.Text.Trim())) { inVo.ValueTo = DateTo_dtp.Value.ToString(); } } else { inVo.ValueFrom = ValueFrom_txt.Text; if (!string.IsNullOrWhiteSpace(ValueTo_txt.Text.Trim())) { inVo.ValueTo = ValueTo_txt.Text; } } inVo.Unit = Unit_txt.Text.Trim(); if (Operator_cmb.SelectedIndex > -1) { inVo.OperatorFrom = Operator_cmb.SelectedValue.ToString(); } if (!string.IsNullOrWhiteSpace(OperatorTo_txt.Text.Trim())) { inVo.OperatorTo = GlobalMasterDataTypeEnum.OPERATOR_LESSTHAN.GetValue(); } //inVo.InspectionItemId = Convert.ToInt32(InspectionItem_cmb.SelectedValue.ToString()); inVo.InspectionItemId = InspectionItemId; inVo.SpecificationResultJudgeType = Convert.ToInt32(SpecificationResultJudgeType_cmb.SelectedValue.ToString()); if (mode.Equals(CommonConstants.MODE_UPDATE)) { inVo.InspectionSpecificationId = inspectionspecificationid; } inVo.Mode = mode; //InspectionSpecificationVo checkVo = DuplicateCheck(inVo); //if (checkVo != null && checkVo.AffectedCount > 0) //{ // messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, InspectionSpecificationCode_lbl.Text + " : " + InspectionSpecificationCode_txt.Text + // Environment.NewLine + " OR " + Environment.NewLine + InspectionItem_lbl.Text + " : " + InspectionItem_cmb.Text); // logger.Info(messageData); // popUpMessage.ConfirmationOkCancel(messageData, Text); // return; //} if (string.Equals(mode, CommonConstants.MODE_ADD) || string.Equals(mode, CommonConstants.MODE_SELECT)) { inVo.InspectionSpecificationCode = InspectionItemCode + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + GlobalMasterDataTypeEnum.SPECIFICATION_CODE.GetValue(); UpdateResultVo outVo = null; try { outVo = (UpdateResultVo)base.InvokeCbm(new AddInspectionSpecificationMasterMntCbm(), inVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } if (outVo == null) { return; } IntSuccess = outVo.AffectedCount; } else if (mode.Equals(CommonConstants.MODE_UPDATE)) { inVo.InspectionSpecificationCode = InspectionSpecificationCode; //InspectionSpecificationVo outVo = (InspectionSpecificationVo)base.InvokeCbm(new UpdateInspectionSpecificationMasterMntCbm(), inVo, false); string message = string.Format(Properties.Resources.mmci00037, "Inspection Specification", InspectionSpecificationText_txt.Text); StartProgress(message); ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>(); InspectionFormatVo passformatVo = FormFormatVo(inVo.InspectionItemId); if (passformatVo == null || passformatVo.InspectionFormatId == 0) { return; } inVoList.add(passformatVo); inVoList.add(null); inVoList.add(null); inVoList.add(null); inVoList.add(inVo); inVoList.add(null); inVoList.add(null); InspectionReturnVo outVo = null; try { outVo = (InspectionReturnVo)base.InvokeCbm(new UpdateAllInspectionFunctionMasterMntCbm(), inVoList, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } finally { CompleteProgress(); } if (outVo != null && outVo.AffectedCount > 0) { IntSuccess = outVo.AffectedCount; InspectionItemId = outVo.InspectionItemId; } } if ((IntSuccess > 0)) { messageData = new MessageData("mmci00001", Properties.Resources.mmci00001, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); this.Close(); } }
public ValueObject Execute(TransactionContext trxContext, ValueObject vo) { ValueObjectList <ValueObjectList <ValueObject> > inVo = (ValueObjectList <ValueObjectList <ValueObject> >)vo; if (inVo == null || inVo.GetList() == null || inVo.GetList().Count == 0) { return(outVo); } ValueObjectList <ValueObject> updateSpecificationListVo = new ValueObjectList <ValueObject>(); UpdateResultVo returnitemSpecificationInsertedVo = null; updateSpecificationListVo = inVo.GetList()[inVo.GetList().Count - 1]; if (updateSpecificationListVo != null && updateSpecificationListVo.GetList() != null && updateSpecificationListVo.GetList().Count > 0) { UpdateSpecificationVo = new InspectionSpecificationVo(); UpdateSpecificationVo = (InspectionSpecificationVo)updateSpecificationListVo.GetList()[0]; } inVo.GetList().RemoveAt(inVo.GetList().Count - 1); //get inspection Specification list for the above fetched itemlist InspectionSpecificationListInVo = (ValueObjectList <InspectionSpecificationVo>)getInspectionSpecficationListCbm.Execute(trxContext, inVo); if (InspectionSpecificationListInVo == null || InspectionSpecificationListInVo.GetList() == null || InspectionSpecificationListInVo.GetList().Count == 0) { return(outVo); } if (UpdateSpecificationVo != null && UpdateSpecificationVo.InspectionSpecificationId > 0) { if (UpdateSpecificationVo.DeleteFlag) { InspectionSpecificationListInVo.GetList().Remove(InspectionSpecificationListInVo.GetList().Single(v => v.InspectionSpecificationId == UpdateSpecificationVo.InspectionSpecificationId)); } else { foreach (InspectionSpecificationVo ItemVo in InspectionSpecificationListInVo.GetList().Where(v => v.InspectionSpecificationId == UpdateSpecificationVo.InspectionSpecificationId)) { ItemVo.InspectionSpecificationCode = UpdateSpecificationVo.InspectionSpecificationCode; ItemVo.InspectionSpecificationText = UpdateSpecificationVo.InspectionSpecificationText; ItemVo.ValueFrom = UpdateSpecificationVo.ValueFrom; ItemVo.ValueTo = UpdateSpecificationVo.ValueTo; ItemVo.Unit = UpdateSpecificationVo.Unit; ItemVo.OperatorFrom = UpdateSpecificationVo.OperatorFrom; ItemVo.OperatorTo = UpdateSpecificationVo.OperatorTo; ItemVo.InspectionItemId = UpdateSpecificationVo.InspectionItemId; ItemVo.SpecificationResultJudgeType = UpdateSpecificationVo.SpecificationResultJudgeType; } } } foreach (ValueObjectList <ValueObject> getitemVo in inVo.GetList()) { InspectionItemVo OldInsProcessVo = (InspectionItemVo)getitemVo.GetList()[0]; InspectionItemVo NewInsProcessVo = (InspectionItemVo)getitemVo.GetList()[1]; foreach (InspectionSpecificationVo inspectionSpecificationVo in InspectionSpecificationListInVo.GetList().Where(v => v.InspectionItemId == OldInsProcessVo.InspectionItemId).Distinct()) { inspectionSpecificationVo.InspectionItemId = NewInsProcessVo.InspectionItemId; inspectionSpecificationVo.InspectionSpecificationCode = NewInsProcessVo.InspectionItemCode + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + GlobalMasterDataTypeEnum.SPECIFICATION_CODE.GetValue(); } if (UpdateSpecificationVo != null) { if (UpdateSpecificationVo.InspectionItemId == OldInsProcessVo.InspectionItemId) { UpdateSpecificationVo.InspectionItemId = NewInsProcessVo.InspectionItemId; } } } returnitemSpecificationInsertedVo = (UpdateResultVo)addInspectionSpecificationCopyCbm.Execute(trxContext, InspectionSpecificationListInVo); if (UpdateSpecificationVo != null) { if (outVo == null) { outVo = new InspectionReturnVo(); } outVo.InspectionItemId = UpdateSpecificationVo.InspectionItemId; } return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { ValueObjectList <ValueObjectList <ValueObject> > inVo = (ValueObjectList <ValueObjectList <ValueObject> >)arg; List <int> ItemList = new List <int>(); foreach (ValueObjectList <ValueObject> getItemVo in inVo.GetList()) { if ((((InspectionItemVo)getItemVo.GetList()[0]).InspectionItemId) != 0) { ItemList.Add(((InspectionItemVo)getItemVo.GetList()[0]).InspectionItemId); } } StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("select * "); sqlQuery.Append(" from m_inspection_specification"); sqlQuery.Append(" where factory_cd = :faccd "); sqlQuery.Append(" and inspection_item_id = ANY (:inspectionItemId) "); sqlQuery.Append(" order by inspection_specification_id "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); sqlParameter.AddParameter("inspectionItemId", ItemList); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); ValueObjectList <InspectionSpecificationVo> outVo = null; while (dataReader.Read()) { InspectionSpecificationVo currOutVo = new InspectionSpecificationVo(); currOutVo.InspectionSpecificationId = ConvertDBNull <int>(dataReader, "inspection_specification_id"); currOutVo.InspectionSpecificationCode = ConvertDBNull <string>(dataReader, "inspection_specification_cd"); currOutVo.InspectionSpecificationText = ConvertDBNull <string>(dataReader, "inspection_specification_text"); currOutVo.ValueFrom = ConvertDBNull <string>(dataReader, "value_from"); currOutVo.ValueTo = ConvertDBNull <string>(dataReader, "value_to"); currOutVo.Unit = ConvertDBNull <string>(dataReader, "unit"); currOutVo.OperatorFrom = ConvertDBNull <string>(dataReader, "operator_from"); currOutVo.OperatorTo = ConvertDBNull <string>(dataReader, "operator_to"); currOutVo.InspectionItemId = ConvertDBNull <int>(dataReader, "inspection_item_id"); currOutVo.SpecificationResultJudgeType = ConvertDBNull <int>(dataReader, "specification_result_judge_type"); if (outVo == null) { outVo = new ValueObjectList <InspectionSpecificationVo>(); } outVo.add(currOutVo); } dataReader.Close(); return(outVo); }
/// <summary> /// inserts new record /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Ok_btn_Click(object sender, EventArgs e) { InspectionSpecificationVo inVo = new InspectionSpecificationVo(); var sch = StringCheckHelper.GetInstance(); if (CheckMandatory() == true) { if (string.IsNullOrEmpty(InspectionSpecificationCode_txt.Text) || string.IsNullOrEmpty(InspectionSpecificationText_txt.Text)) { messageData = new MessageData("mmce00003", Properties.Resources.mmce00003); logger.Info(messageData); popUpMessage.ConfirmationOkCancel(messageData, Text); if (string.IsNullOrEmpty(InspectionSpecificationCode_txt.Text)) { InspectionSpecificationCode_txt.Focus(); } else if (string.IsNullOrEmpty(InspectionSpecificationText_txt.Text)) { InspectionSpecificationText_txt.Focus(); } return; } if (string.Equals(mode, CommonConstants.MODE_SELECT)) { if (InspectionSpecificationCode_txt.Text == updateData.InspectionSpecificationCode) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, InspectionSpecificationCode_lbl.Text + " : " + InspectionSpecificationCode_txt.Text); logger.Info(messageData); popUpMessage.ConfirmationOkCancel(messageData, Text); return; } if (InspectionSpecificationText_txt.Text == updateData.InspectionSpecificationText) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, InspectionSpecificationText_lbl.Text + " : " + InspectionSpecificationText_txt.Text); logger.Info(messageData); popUpMessage.ConfirmationOkCancel(messageData, Text); return; } } inVo.InspectionSpecificationCode = InspectionSpecificationCode_txt.Text.Trim(); inVo.InspectionSpecificationText = InspectionSpecificationText_txt.Text.Trim(); // inVo.ValueFrom = Convert.ToDecimal(ValueFrom_txt.Text.Trim()); if (!string.IsNullOrWhiteSpace(ValueTo_txt.Text.Trim())) { // inVo.ValueTo = Convert.ToDecimal(ValueTo_txt.Text.Trim()); } if (!string.IsNullOrWhiteSpace(Unit_txt.Text.Trim())) { inVo.Unit = Unit_txt.Text.Trim(); } if (!string.IsNullOrWhiteSpace(OperatorFrom_txt.Text.Trim())) { inVo.OperatorFrom = OperatorFrom_txt.Text.Trim(); } if (!string.IsNullOrWhiteSpace(OperatorTo_txt.Text.Trim())) { inVo.OperatorTo = OperatorTo_txt.Text.Trim(); } inVo.InspectionItemId = Convert.ToInt32(InspectionItem_cmb.SelectedValue.ToString()); inVo.SpecificationResultJudgeType = Convert.ToInt32(SpecificationResultJudgeType_cmb.SelectedValue.ToString()); if (mode.Equals(CommonConstants.MODE_UPDATE)) { inVo.InspectionSpecificationId = updateData.InspectionSpecificationId; } inVo.Mode = mode; InspectionSpecificationVo checkVo = DuplicateCheck(inVo); if (checkVo != null && checkVo.AffectedCount > 0) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, InspectionSpecificationCode_lbl.Text + " : " + InspectionSpecificationCode_txt.Text + Environment.NewLine + " OR " + Environment.NewLine + InspectionItem_lbl.Text + " : " + InspectionItem_cmb.Text); logger.Info(messageData); popUpMessage.ConfirmationOkCancel(messageData, Text); return; } try { if (string.Equals(mode, CommonConstants.MODE_ADD) || string.Equals(mode, CommonConstants.MODE_SELECT)) { UpdateResultVo outVo = (UpdateResultVo)base.InvokeCbm(new AddInspectionSpecificationMasterMntCbm(), inVo, false); IntSuccess = outVo.AffectedCount; } else if (mode.Equals(CommonConstants.MODE_UPDATE)) { InspectionSpecificationVo outVo = (InspectionSpecificationVo)base.InvokeCbm(new UpdateInspectionSpecificationMasterMntCbm(), 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(); } } }