protected override void OnRefFilter(object sender, RefActivatingEventArgs e) { if (e.BindingFieldName.Equals("Name_emp")) { string str = ""; string id_dep = this.gv_invite.GetFocusedRow <CiordInviteConsDO>().Id_dep; if (id_dep != null) { str += " id_dep='" + id_dep + "'"; } if (str == "") { return; } e.WherePart = str; } if (e.BindingFieldName.Equals("Name_dep")) { string str = ""; str += string.Format("id_dep <> '{0}' and SD_DEPTTP='01'", UserManager.getInstance().CurrentDept.Id_dep); if (str == "") { return; } e.WherePart = str; } }
void xapFormControl1_RefFilter(object sender, RefActivatingEventArgs e) { if (e.BindingFieldName.Equals("Name_outtp")) { e.WherePart = string.Format("bd_udidoc.code <> '5'"); } }
private new void OnRefFilter(object sender, RefActivatingEventArgs e) { if (e.BindingFieldName == "Name_route") { e.WherePart = string.Format("id_route in ({0})", new GetSrvVsRouteImp().GetDosageVsRounte("'" + string.Join("','", EmsHeadDO.Emsdrugs.EmsOrDrugList.Select(p => p.Id_srv).ToList()) + "'")); } //不需要添加 if (e.BindingFieldName.Equals("Name_dep")) { if (EmsHeadDO.Emsdrugs.Str_mp_dep_ids != null && EmsHeadDO.Emsdrugs.Str_mp_dep_ids != "") { e.WherePart = string.Format(" id_dep in({0})", EmsHeadDO.Emsdrugs.Str_mp_dep_ids); } } if (e.BindingFieldName.Equals("Name_unit_sale"))//计量单位 { if (drug.Str_unit_pkg_ids != null && drug.Str_unit_pkg_ids != "") { e.WherePart = string.Format("id_measdoc in ({0})", drug.Str_unit_pkg_ids); } } if (e.BindingFieldName.Equals("Name_freq")) { e.WherePart = string.Format("bd_freq.FG_ACTIVE='Y'", drug.Str_unit_pkg_ids); } if (e.BindingFieldName.Equals("Name_routedes")) { e.WherePart = string.Format("BD_ROUTE_DES.FG_ENTP_IP='Y'"); } }
protected override void OnXapFormControl_RefFilter(object sender, RefActivatingEventArgs e) { var sbm = new StringObjectMap(); if (e.BindingFieldName.Equals("Name_diag")) { e.WherePart = this.GetViewModel().OnRefFilterData(e.BindingFieldName, sbm); e.RefParams.AddParam("id_ent", (this.GetViewModel().GetEmsUIDTO() as EmsUIDTO).PatInfo.Id_ent); } else if (e.BindingFieldName.Equals("Name_mp_dep")) { e.WherePart = this.GetViewModel().OnRefFilterData(e.BindingFieldName, sbm); } else if (e.BindingFieldName.Equals("Name_srv")) { if ((this.GetViewModel().GetEmsUIDTO() as EmsUIDTO).MedSrvDO.Fg_set != null && (this.GetViewModel().GetEmsUIDTO() as EmsUIDTO).MedSrvDO.Fg_set == true) { e.RefParams.AddParam("Fg_set", "Y"); } else { e.RefParams.AddParam("Fg_set", "N"); } e.RefParams.AddParam("Id_srv", (this.GetViewModel().GetEmsUIDTO() as EmsUIDTO).MedSrvDO.Id_srv); } else { e.WherePart = this.GetViewModel().OnRefFilterData(e.BindingFieldName, sbm); } foreach (var item in sbm) { e.RefParams.AddParam(item.Key, item.Value); } }
private void xQOnRefFilter(object sender, RefActivatingEventArgs e) { if (e.BindingFieldName.Equals("Name_srv")) { e.WherePart = string.Format(" Sd_srvtp like '0103%'"); } if (e.BindingFieldName.Equals("Name_mm")) { EmsOrDrug drugDo = gv.GetFocusedRow().RowDataSource as EmsOrDrug; if (drugDo.Id_srv == null) { drugDo.Id_srv = "xxxx"; } e.WherePart = string.Format("id_mm in ({0})", cof.GetSrvMmStr(this.EmsHeadDO, drugDo.Id_srv)); } if (e.BindingFieldName.Equals("Name_dep")) { if (this.EmsHeadDO.Emsdrugs.Str_mp_dep_ids != null && this.EmsHeadDO.Emsdrugs.Str_mp_dep_ids != "") { e.WherePart = string.Format(" id_dep in({0})", this.EmsHeadDO.Emsdrugs.Str_mp_dep_ids); } //e.RefParams.AddParam("Dep", this.EmsHeadDO.Emsdrugs.Str_mp_dep_ids); } //if (e.BindingFieldName.Equals("Total_count_unit"))//计量单位 //{ // if (drug.Str_unit_pkg_ids != null && drug.Str_unit_pkg_ids != "") // e.WherePart = string.Format("id_measdoc in ({0})", drug.Str_unit_pkg_ids); // //e.RefParams.AddParam("Dis", drug.Str_unit_pkg_ids); //} }
//void btnOK_MouseClick(object sender, MouseEventArgs e) //{ // this.xapFormControl1.SaveForm(); // this.Save(this); //} private new void OnRefFilter(object sender, RefActivatingEventArgs e) { if (e.BindingFieldName.Equals("Name_di")) { e.RefParams.AddParam("id_ent", CiHeadDo.PatInfo.Id_ent); } }
/// <summary> /// 参照控件数据过滤 /// </summary> protected override void OnRefFilter(object sender, RefActivatingEventArgs e) { switch (e.BindingFieldName) { case "Mm_name": CiOrdBtTestDO CiDo = this.model.XapAggDO.Parent as CiOrdBtTestDO; e.RefParams.AddParam("id_srv", CiDo.Id_srv_bt); break; } }
private new void OnRefFilter(object sender, RefActivatingEventArgs e) { if (e.BindingFieldName.Equals("Name_dep")) { if (CiHeadDo.Emsdrugs.Str_mp_dep_ids != null && CiHeadDo.Emsdrugs.Str_mp_dep_ids != "") { e.WherePart = string.Format(" id_dep in({0})", CiHeadDo.Emsdrugs.Str_mp_dep_ids); } } }
private void xapFormControl_RefFilter(object sender, RefActivatingEventArgs e) { FreqDefDO freq = null; if (orcofirm != null) { freq = model.GetDefDo(orcofirm.Id_freq); } model.HandleRefFilter(sender, e, orcofirm, freq); }
void xapFormControl1_RefFilter(object sender, RefActivatingEventArgs e) { if (e.BindingFieldName.Equals("Name_mp_dep") && !string.IsNullOrWhiteSpace(idDepMps)) { e.WherePart = string.Format("id_dep in ({0})", idDepMps); } else if (e.BindingFieldName.Equals("Name_diag")) { e.RefParams.AddParam("id_ent", CiHeadDo.PatInfo.Id_ent); } }
/// <summary> /// 参照内容过滤条件 /// </summary> /// <param name="sendthrow new NotImplementedException();er"></param> /// <param name="e"></param> //void OnXapFormControl_RefFilter(object sender, RefActivatingEventArgs e) protected override void OnXapFormControl_RefFilter(object sender, RefActivatingEventArgs e) { if (this.GetViewModel() != null) { e.WherePart = this.GetViewModel().OnRefFilterData(e.BindingFieldName); } else { e.WherePart = ""; } }
private void xapFormControl_RefFilter(object sender, RefActivatingEventArgs e) { var drug = e.DataObject as AddFeeDTO; if (e.BindingFieldName.Equals("Name_mm")) { e.WherePart = " bd_mm.id_srv = '" + drug.Id_srv + "'"; } if (e.BindingFieldName.Equals("Name_srv")) { // this.FireSelected(this.model.orConfirm); if (or != null && or.Id_hp != null) { e.RefParams.AddParam("hp", or.Id_hp); } string sql = model.srvScopeSql; if (sql != null) { e.WherePart = sql; } } if (e.BindingFieldName.Equals("Name_mp_dep")) { var drugs = e.DataObject as EmsOrDrug; OrWfExDeptDTO[] ow = null; string depis = ""; if (drugs != null) { ow = model.getMpDept(drugs, or); } if (ow != null) { foreach (OrWfExDeptDTO o in ow) { depis += "'" + o.Id_dept + "',"; } e.WherePart = " bd_dep.id_dep in (" + depis.Substring(0, depis.Count() - 1) + ")"; } } if (e.BindingFieldName.Equals("Name_freq")) { //if (freq != null && freq.Sd_frequnitct.Equals(BdSrvDictCodeConst.SD_FREQUNIT_ONCE)) //{ // e.Cancel = true; //} //else { e.Cancel = false; e.WherePart = " bd_freq.fg_active ='Y'"; } } }
private void OnRefFilter(object sender, RefActivatingEventArgs e) { //string ref_fldname = e.BindingFieldName; //if (ref_fldname == "Parent_name") //{ // if (!string.IsNullOrWhiteSpace(this.model_place.DataInst.Id_plc)) // { // e.WherePart = string.Format("Id_plc !='{0}'", this.model_place.DataInst.Id_plc); // } //} }
private void xapFormControl_RefFilter(object sender, RefActivatingEventArgs e) { //不走 if (e.BindingFieldName.Equals("Name_ciprnsheettp")) { var str = string.Format("length(bd_udidoc.code) =( select max( length(code)) from bd_udidoc where id_udidoclist='{0}')", CiDictCodeTypeConst.ID_CIPRNSHEETTP); str += string.Format(" and bd_udidoc.code not in ('{0}','{1}','{2}')", CiDictCodeConst.SD_CIPRNSHEETTP_BTAPP, CiDictCodeConst.SD_CIPRNSHEETTP_BTUSEAPP, CiDictCodeConst.SD_CIPRNSHEETTP_OPAPP); e.WherePart = str; } }
protected override void OnRefFilter(object sender, RefActivatingEventArgs e) { base.OnRefFilter(sender, e); if (e.BindingFieldName.Equals("Name_bed")) { e.RefParams.AddParam("iddepnur", model.orConfirm.Id_dep_nur); } else if (e.BindingFieldName.Equals("Name_dep_nur")) { e.RefParams.AddParam("sddepttp", model.orConfirm.Id_dep_nur); } }
public void HandleRefFilter(object sender, RefActivatingEventArgs e, OrConfirm or, FreqDefDO freq) { var drug = e.DataObject as AddFeeDTO; if (e.BindingFieldName.Equals("Name_mm")) { e.WherePart = " bd_mm.id_srv = '" + drug.Id_srv + "'"; } if (e.BindingFieldName.Equals("Name_srv")) { // this.FireSelected(this.model.orConfirm); if (or != null && or.Id_hp != null) { e.RefParams.AddParam("hp", or.Id_hp); } string sql = " BD_SRV.Fg_Use_Ip='Y' "; if (srvScopeSql != null) { e.WherePart = sql + " and " + srvScopeSql; } //如果医嘱的频次为持续,该医嘱只能补时间量纲的服务 if (or.Id_freq == "0001AA1000000006AEHV")//##???? 持续 { e.WherePart = sql + " and " + srvScopeSql + " and " + " bd_measdoc.sd_oppdimen='07' "; } } if (e.BindingFieldName.Equals("Name_dep")) { var drugs = e.DataObject as AddFeeDTO; FArrayList ow = null; string depis = ""; if (drugs != null) { ow = getMpDept(drugs, or); } if (ow != null) { foreach (OrWfExDeptDTO o in ow) { depis += "'" + o.Id_dept + "',"; } e.WherePart = " bd_dep.id_dep in (" + depis.Substring(0, depis.Count() - 1) + ")"; } } if (e.BindingFieldName.Equals("Name_freq")) { e.Cancel = false; e.WherePart = " bd_freq.fg_active ='Y'"; } }
/// <summary> ///引用参照条件事件处理 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected override void OnXapFormControl_RefFilter(object sender, RefActivatingEventArgs e) { var sbm = new StringObjectMap(); e.SearchText = QueryHelper.SQLEnCode(e.SearchText); e.WherePart = this.GetViewModel().OnRefFilterData(e.BindingFieldName, sbm); foreach (KeyValuePair <string, object> item in sbm) { e.RefParams.AddParam(item.Key, item.Value); } }
protected override void OnRefFilter(object sender, RefActivatingEventArgs e) { //UserRender userRender_emp = xapFormControl.GetUserRender("cons", "name_dep_emp"); //string str = EmsHeadDO.Emsapcons.Id_dep_emp; if (e.BindingFieldName.Equals("Name_emp_doctor")) { if (EmsHeadDO.Emsapcons.Id_dep_emp != null) { e.WherePart = " id_dep='" + EmsHeadDO.Emsapcons.Id_dep_emp + "'"; } } }
private new void OnRefFilter(object sender, RefActivatingEventArgs e) { if (e.BindingFieldName.Equals("Name_diag")) { e.RefParams.AddParam("id_ent", this.EmsHeadDO.PatInfo.Id_ent); //e.WherePart = " id_ent ='" + this.EmsHeadDO.PatInfo.Id_ent + "'"; } else if (e.BindingFieldName.Equals("Name_mp_dep") && !string.IsNullOrWhiteSpace(idDepMps)) { e.WherePart = string.Format("id_dep in ({0})", idDepMps); } }
private new void OnRefFilter(object sender, RefActivatingEventArgs e) { if (e.BindingFieldName == "Name_route") { e.WherePart = string.Format("id_route in ({0})", new GetSrvVsRouteImp().GetDosageVsRounte("'" + string.Join("','", this.EmsHeadDO.Emsdrugs.EmsOrDrugList.Select(p => p.Id_srv).ToList()) + "'")); } if (e.BindingFieldName.Equals("Name_srv")) { e.WherePart = string.Format(" Sd_srvtp in ('010104','010204','010203','010103')"); } if (e.BindingFieldName.Equals("Name_mm")) { EmsOrDrug drugDo = gv.GetFocusedRow().RowDataSource as EmsOrDrug; if (drugDo.Id_srv == null) { drugDo.Id_srv = "xxxx"; } e.WherePart = string.Format("id_mm in ({0})", cof.GetSrvMmStr(this.EmsHeadDO, drugDo.Id_srv)); } if (e.BindingFieldName.Equals("Name_dep")) { if (this.EmsHeadDO.Emsdrugs.Str_mp_dep_ids != null && this.EmsHeadDO.Emsdrugs.Str_mp_dep_ids != "") { e.WherePart = string.Format(" id_dep in({0})", this.EmsHeadDO.Emsdrugs.Str_mp_dep_ids); } //e.RefParams.AddParam("Dep", this.EmsHeadDO.Emsdrugs.Str_mp_dep_ids); } if (e.BindingFieldName.Equals("Total_count_unit"))//计量单位 { if (emsOrDrug.Str_unit_pkg_ids != null && emsOrDrug.Str_unit_pkg_ids != "") { e.WherePart = string.Format("id_measdoc in ({0})", emsOrDrug.Str_unit_pkg_ids); } //e.RefParams.AddParam("Dis", drug.Str_unit_pkg_ids); } if (e.BindingFieldName.Equals("Name_unit_sale"))//计量单位 { int focusOrDrug = gv.GetFocusedRow().Index; drug = this.EmsHeadDO.Emsdrugs.EmsOrDrugList[focusOrDrug]; if (drug.Str_unit_pkg_ids != null && drug.Str_unit_pkg_ids != "") { e.WherePart = string.Format("id_measdoc in ({0})", drug.Str_unit_pkg_ids); } else { e.WherePart = string.Format("id_measdoc in ({0})", drug.Id_unit_sale); } } }
/// <summary> /// 改写参照过滤条件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected override void OnXapFormControl_RefFilter(object sender, RefActivatingEventArgs e) { var drug = e.DataObject as CiOrdFeeSrvDTO; if (e.BindingFieldName.Equals("Name_srv")) { e.WherePart = " bd_srv.fg_use_op='Y' and bd_srv.fg_or='N' and bd_srv.fg_bl = 'Y' "; } //执行科室的名字匹配错了 else if (e.BindingFieldName.Equals("Name_dep") && drug.getAttrVal("str_id_mp_deps") != null) { e.WherePart = String.Format("id_dep in({0})", drug.getAttrVal <String>("str_id_mp_deps")); } }
protected override void OnRefFilter(object sender, RefActivatingEventArgs e) { if (e.BindingFieldName.Equals("Name_emp_doctor")) { string str = ""; // 获取当前行 受邀科室id string id_dep = this.assistGrid.GetFocusedRow <EmsItemInCons>().Id_dep_emp; if (id_dep != null) { str += " bd_psndoc.id_dep='" + id_dep + "'"; } // 受邀科室医生职称是否有限制 if (this.consDo.Fg_emptitlelimit == true && !string.IsNullOrEmpty(this.consDo.Id_emptitle)) { string id_emptitles = ""; string[] ids = this.consDo.Id_emptitle.Split(','); foreach (string id in ids) { id_emptitles += "'" + id + "',"; } if (str != "") { str += " and "; } str += " bd_psndoc.id_emptitle in (" + id_emptitles.Substring(0, id_emptitles.Length - 1) + ")"; } if (str == "") { return; } e.WherePart = str; } if (e.BindingFieldName.Equals("Name_dep_emp")) { string str = ""; str += string.Format("id_dep <> '{0}' and SD_DEPTTP='01'", UserManager.getInstance().CurrentDept.Id_dep); if (str == "") { return; } e.WherePart = str; } if (e.BindingFieldName.Equals("Name_org")) { if (consDo != null && consDo.Fg_inorg == false) { e.WherePart = string.Format("id_org <> '{0}'", UserManager.getInstance().CurrentOrg.Id_org); } } }
private new void OnRefFilter(object sender, RefActivatingEventArgs e) { if (e.BindingFieldName.Equals("Name_srv")) { e.WherePart = string.Format(" Sd_srvtp in ('010104','010204','010203','010103','010199')"); } else if (e.BindingFieldName.Equals("Name_mm")) { EmsOrDrug drugDo = gv.GetFocusedRow().RowDataSource as EmsOrDrug; if (drugDo.Id_srv == null) { drugDo.Id_srv = "xxxx"; } e.WherePart = string.Format("id_mm in ({0})", cof.GetSrvMmStr(EmsHeadDO, drugDo.Id_srv)); } else if (e.BindingFieldName.Equals("Name_dep")) { if (EmsHeadDO.Emsdrugs.EmsOrDrugList[0].Str_mp_dep_ids != null && EmsHeadDO.Emsdrugs.EmsOrDrugList[0].Str_mp_dep_ids != "") { e.WherePart = string.Format(" id_dep in({0})", EmsHeadDO.Emsdrugs.EmsOrDrugList[0].Str_mp_dep_ids); } } else if (e.BindingFieldName.Equals("Total_count_unit")) //计量单位 { if (emsOrDrug.Str_unit_pkg_ids != null && emsOrDrug.Str_unit_pkg_ids != "") { e.WherePart = string.Format("id_measdoc in ({0})", emsOrDrug.Str_unit_pkg_ids); } } else if (e.BindingFieldName == "Name_route") { e.WherePart = string.Format("id_route in ({0})", new GetSrvVsRouteImp().GetDosageVsRounte("'" + string.Join("','", EmsHeadDO.Emsdrugs.EmsOrDrugList.Select(p => p.Id_srv).ToList()) + "'")); } else if (e.BindingFieldName.Equals("Name_unit_sale")) //计量单位 { EmsOrDrug drug = xapFormControl1.GetFocused <EmsOrDrug>("drug"); if (drug.Str_unit_pkg_ids != null && drug.Str_unit_pkg_ids != "") { e.WherePart = string.Format("id_measdoc in ({0})", drug.Str_unit_pkg_ids); } } else if (e.BindingFieldName.Equals("Name_routedes")) { e.WherePart = string.Format("BD_ROUTE_DES.FG_ENTP_OP='Y'"); } else if (e.BindingFieldName.Equals("Name_freq")) { e.WherePart = string.Format("FG_ACTIVE='Y'"); } }
protected override void OnXapFormControl_RefFilter(object sender, RefActivatingEventArgs e) { if (this.GetViewModel() != null) { e.WherePart = this.GetViewModel().OnRefFilterData(e.BindingFieldName); if (e.BindingFieldName.Equals("Name_diag")) { e.RefParams.AddParam("id_ent", (this.GetViewModel().GetEmsUIDTO() as EmsUIDTO).PatInfo.Id_ent); } } else { e.WherePart = ""; } }
protected new void OnRefFilter(object sender, RefActivatingEventArgs e) { if (e.BindingFieldName.Equals("Name_diag")) { e.RefParams.AddParam("id_ent", this.EmsHeadDO.PatInfo.Id_ent); } else if (e.BindingFieldName.Equals("Name_mp_dep") && !string.IsNullOrWhiteSpace(idDepMps)) { e.WherePart = string.Format("id_dep in ({0})", idDepMps); } else if (e.BindingFieldName.Equals("No_pathgy_old")) { e.WherePart = string.Format(" B.id_pat='{0}' and A.no_pathgy is not null", this.EmsHeadDO.PatInfo.Id_pat); } }
protected override void OnRefFilter(object sender, RefActivatingEventArgs e) { if (e.BindingFieldName.Equals("Name_emp_doctor")) { if (assistGrid.DataTable.DataSource != null) { XapDataList <EmsItemInCons> list = assistGrid.DataTable.DataSource as XapDataList <EmsItemInCons>; string str_Id_dep_emp = list[0].Id_dep_emp; if (str_Id_dep_emp != null) { e.WherePart = " id_dep='" + str_Id_dep_emp + "'"; } } } }
private new void OnRefFilter(object sender, RefActivatingEventArgs e) { if (e.BindingFieldName.Equals("Name_di")) { e.WherePart = " id_ent ='" + CiHeadDo.PatInfo.Id_ent + "'"; //if (str_id_dis != null) //{ // e.RefParams.AddParam("Dis", str_id_dis); //} //if (this.ent4BannerDto != null) //{ // e.RefParams.AddParam("id_ent", this.ent4BannerDto.Id_ent); //} } }
protected override void OnXapFormControl_RefFilter(object sender, RefActivatingEventArgs e) { if (null != this.GetViewModel()) { var sbm = new StringObjectMap(); e.WherePart = GetViewModel().OnRefFilterData(e.BindingFieldName, sbm); if (e.BindingFieldName.Equals("Name_diag")) { e.RefParams.AddParam("id_ent", (this.GetViewModel().GetEmsUIDTO() as EmsUIDTO).PatInfo.Id_ent); } foreach (var item in sbm) { e.RefParams.AddParam(item.Key, item.Value); } } }
protected override void OnXapFormControl_RefFilter(object sender, RefActivatingEventArgs e) { var sbm = new StringObjectMap(); if (this.GetViewModel() != null) { e.WherePart = this.GetViewModel().OnRefFilterData(e.BindingFieldName, sbm); } else { e.WherePart = ""; } foreach (var item in sbm) { e.RefParams.AddParam(item.Key, item.Value); } }
private new void OnRefFilter(object sender, RefActivatingEventArgs e) { if (e.BindingFieldName.Equals("Name_mp_dep")) { if (this.drug.Str_mp_dep_ids != null && this.drug.Str_mp_dep_ids != "") { e.WherePart = string.Format(" id_dep in({0})", this.drug.Str_mp_dep_ids); } } else if (e.BindingFieldName.Equals("Name_dep_wh")) { if (this.drug.Str_wh_dep_ids != null && this.drug.Str_wh_dep_ids != "") { e.WherePart = string.Format(" id_dep in({0})", this.drug.Str_wh_dep_ids); } } }