/// <summary> /// SaveQnTopic /// </summary> /// <param name="mainVo"></param> /// <param name="lstSub"></param> /// <param name="fieldId"></param> /// <returns></returns> public int SaveQnTopic(EntityDicQnSummary mainVo, List <EntityDicQnSummary> lstSub, out string fieldId) { using (Biz209 biz = new Biz209()) { return(biz.SaveQnTopic(mainVo, lstSub, out fieldId)); } }
/// <summary> /// Save /// </summary> void Save() { EntityDicQnSummary mainVo = new EntityDicQnSummary(); mainVo.qnClassId = 2; mainVo.typeId = Convert.ToString(this.cboType.SelectedIndex + 1); mainVo.isParent = 1; mainVo.fieldName = this.txtFieldName.Text.Trim(); mainVo.comment = this.txtComment.Text.Trim(); mainVo.isEssential = this.rdoEssential.SelectedIndex; mainVo.status = this.rdoStatus.SelectedIndex; mainVo.sortNo = Function.Int(this.txtSortNo.Text); mainVo.parentFieldId = " "; if (this.TopicVo != null) { mainVo.fieldId = this.TopicVo.fieldId; } if (string.IsNullOrEmpty(mainVo.fieldName)) { DialogBox.Msg("题目名称不能为空,请填写。"); this.txtFieldName.Focus(); return; } this.gvItems.CloseEditor(); List <EntityDicQnSummary> lstSub = new List <EntityDicQnSummary>(); if (this.gvItems.RowCount > 0) { lstSub = this.gvDataBindingSourceItems.DataSource as List <EntityDicQnSummary>; } string fieldId = string.Empty; using (ProxyHms proxy = new ProxyHms()) { if (proxy.Service.SaveQnTopic(mainVo, lstSub, out fieldId) > 0) { if (this.TopicVo == null) { this.TopicVo = new EntityDicQnSummary() { fieldId = fieldId }; } this.IsRequireRefresh = true; DialogBox.Msg("保存题目成功!"); } else { DialogBox.Msg("保存题目失败。"); } } }
/// <summary> /// SaveQnTopic /// </summary> /// <param name="mainVo"></param> /// <param name="lstSub"></param> /// <param name="fieldId"></param> /// <returns></returns> public int SaveQnTopic(EntityDicQnSummary mainVo, List <EntityDicQnSummary> lstSub, out string fieldId) { int affectRows = 0; SqlHelper svc = null; fieldId = string.Empty; try { fieldId = mainVo.fieldId; svc = new SqlHelper(EnumBiz.onlineDB); List <DacParm> lstParm = new List <DacParm>(); int num = 0; if (string.IsNullOrEmpty(fieldId)) { int nextId = svc.GetNextID("dicQnSummary", "fieldId"); fieldId = "T" + nextId.ToString().PadLeft(6, '0'); mainVo.fieldId = fieldId; if (mainVo.sortNo == 0) { mainVo.sortNo = nextId; } if (lstSub != null) { foreach (EntityDicQnSummary item in lstSub) { item.fieldId = fieldId + Convert.ToString(++num).PadLeft(2, '0'); } } } else { EntityDicQnSummary vo = new EntityDicQnSummary(); vo.fieldId = fieldId; vo.parentFieldId = fieldId; lstParm.Add(svc.GetDelParm(vo, EntityDicQnSummary.Columns.fieldId)); lstParm.Add(svc.GetDelParm(vo, EntityDicQnSummary.Columns.parentFieldId)); } if (lstSub != null) { num = 0; foreach (EntityDicQnSummary item in lstSub) { item.qnClassId = mainVo.qnClassId; item.typeId = mainVo.typeId; item.fieldId = fieldId + num; item.parentFieldId = fieldId; item.isEssential = mainVo.isEssential; item.isParent = 0; item.status = mainVo.status; item.sortNo = ++num; item.fieldId = fieldId + num.ToString().PadLeft(3, '0'); } } lstParm.Add(svc.GetInsertParm(mainVo)); if (lstSub != null && lstSub.Count > 0) { lstParm.Add(svc.GetInsertParm(lstSub.ToArray())); } affectRows = svc.Commit(lstParm); } catch (Exception e) { ExceptionLog.OutPutException(e); affectRows = -1; } finally { svc = null; } return(affectRows); }
/// <summary> /// ctor /// </summary> /// <param name="_topicVo"></param> public frmPopup20902(EntityDicQnSummary _topicVo) { InitializeComponent(); TopicVo = _topicVo; this.Text += "-【" + _topicVo.fieldName + "】"; }
/// <summary> /// Save /// </summary> void Save() { EntityDicQnMain vo = new EntityDicQnMain(); vo.qnName = this.txtQnName.Text.Trim(); vo.qnDesc = this.txtQnDesc.Text.Trim(); vo.status = this.cboStatus.SelectedIndex; vo.classId = 2; // 自定义问卷 vo.creatorId = GlobalLogin.objLogin.EmpNo; vo.creatDate = DateTime.Now; if (this.QnVo != null && this.QnVo.qnId > 0) { vo.qnId = this.QnVo.qnId; } // 明细缓 this.gridView.CloseEditor(); lstDicQnSetting = new List <EntityDicQnSetting>(); List <EntityQnSetting> data = this.gridControl.DataSource as List <EntityQnSetting>; List <EntityDicQnDetail> lstDet = new List <EntityDicQnDetail>(); foreach (EntityQnSetting item in data) { if (item.isCheck == 1) { lstDet.Add(new EntityDicQnDetail() { fieldId = item.fieldId, qnId = item.qnId }); EntityDicQnSummary qnSummaryVo = lstQnSummary.Find(r => r.fieldId == item.fieldId); if (qnSummaryVo != null) { EntityDicQnSetting setVo = new EntityDicQnSetting(); setVo = Function.MapperToModel(setVo, qnSummaryVo); setVo.qnId = item.qnId; lstDicQnSetting.Add(setVo); } List <EntityDicQnSummary> lstSub = lstQnSummary.FindAll(r => r.parentFieldId == item.fieldId); if (lstSub != null) { foreach (var summaryVo in lstSub) { EntityDicQnSetting setVo = new EntityDicQnSetting(); setVo = Function.MapperToModel(setVo, summaryVo); setVo.qnId = item.qnId; lstDicQnSetting.Add(setVo); } } } } decimal qnId = 0; using (ProxyHms proxy = new ProxyHms()) { if (proxy.Service.SaveQNnormal(vo, lstDet, out qnId, null, lstDicQnSetting) > 0) { if (this.QnVo == null) { this.QnVo = new EntityDicQnMain() { qnId = qnId }; } this.IsRequireRefresh = true; DialogBox.Msg("保存问卷成功!"); } else { DialogBox.Msg("保存问卷失败。"); } } }