SZDF：搜索框实现自动完成和连表搜索

2017-06-12 11:34:44  访问(1968) 赞(0) 踩(0)

• 内容
• TableListOperBeforeIQueryDriver
• EkSzdfSearchForm__Page

• 
  
  
  1、在EkSzdfSearchForm__Page设置自动完成和搜索模式
  2、在HrzzJszController__partial.cs设置连表搜索
  
  

• 
  // Areas\ZnbmHrzz\Controllers\HRZZ\HrzzJsz\HrzzJszController__partial.cs
  
         #region TableListOperBeforeIQueryDriver - 组合查询条件前设置查询逻辑（主要是做连表等设置）
  
          /// <summary>
          /// 组合查询条件前设置查询逻辑（主要是做连表等设置）
          /// </summary>
          /// <param name="bllMain"></param>
          /// <param name="entityMain"></param>
          /// <param name="hai"></param>
          /// <param name="xdbHelper">数据库链接串</param>
  
          public override void TableListOperBeforeIQueryDriver
              (
                  BaseBusiness bllMain,
                  BaseEntity entityMain,
                  HttpActionInfo hai,
                  DBHelper xdbHelper
              )
          {
              // 组合查询条件前设置查询逻辑（主要是做连表等设置） //
              base.TableListOperBeforeIQueryDriver(bllMain, entityMain, hai, xdbHelper);
  
              // 获得页面的属性 //
              eKing.SzdfPage.Areas.ZnbmHrzz.HRZZ.HrzzJsz.EkSzdfPage eKp
                  =
                  eKing.SzdfPage.Areas.ZnbmHrzz.HRZZ.HrzzJsz.EkSzdfPage.instance;
  
              //这里指定录入页面（同理可以指定其他页面）
              eKing.SzdfPage.Areas.ZnbmHrzz.HRZZ.HrzzJsz.EkSzdfSearchForm
                  sf
                  =
                  eKp.SearchForm;
  
              // 逻辑方法 //
              eKing.SzdfPage.Helpers.eKingSzdfPageHelper
                      wh
                      =
                      eKing.SzdfPage.Helpers.eKingSzdfPageHelper.ekInstance;
  
              // 数据表查询逻辑条件 //
              eKing.SzdfLib.Entity.HRZZ.UTB_SZDF_HRZZ_JSZ
                  entity
                  =
                  entityMain as eKing.SzdfLib.Entity.HRZZ.UTB_SZDF_HRZZ_JSZ;
  
  
              IFromTableDriver ifrom = entityMain;
              ISelectDriver iselect = entityMain;
              IQueryDriver iq = entityMain;
  
              eKing.SzdfLib.Entity.HR.UTB_SZDF_HR_USER_ITEM uiEntity
                  =
                  new eKing.SzdfLib.Entity.HR.UTB_SZDF_HR_USER_ITEM();
  
              iselect.AddISelectItemWithBaseEntity(entityMain);
              iselect.AddISelectItemWithEntityFieldInfo(uiEntity._TheName);
              uiEntity.selectPreName = "U__";
  
              ifrom.AddIFromTableItemWithBaseEntity("tu", uiEntity);
              iq.AddIQueryItemWithEntityFieldInfo(entity._User_Item_Id, uiEntity._ID);
  
  
  
          }
  
          #endregion TableListOperBeforeIQueryDriver - 组合查询条件前设置查询逻辑（主要是做连表等设置）
  
  

• // eKing.SzdfPage\Areas\ZnbmHrzz\HRZZ\HrzzJsz\EkSzdfSearchForm__Page.cs
  
  
              eKing.SzdfLib.TableAttribute.HR.UTB_SZDF_HR_USER_ITEM uTA
                  =
                  eKing.SzdfLib.TableAttribute.HR.UTB_SZDF_HR_USER_ITEM.instance;
  
  
              EkxPageInputCtrl ekx = null;
  
  
              #region User_Item_Id - 员工
  
  
              ekx = mv_User_Item_Id;
              ekx.EmCtrlTypeV
                  =
                  EkPageCreate.Enums.CtrlType.EmCtrlType.普通文本;
  
              ekx.EmAutoCompleterModelV
                  =
                  EkPageCreate.Enums.AutoCompleterModel.EmAutoCompleterModel.查询;
  
              ekx.AutoCompleterUrl
                  =
                  eKingSzdfPageHelper.ekInstance.AutoCompleterUrlDefaultGet
                  (
                      Enums.AutoCompleter.EmAutoCompleter.人员
                  );
  
              ekx.CtrlCssClass = "input_txt";
  
  
              ekx.SearchEntityName = "tu";
              ekx.SearchDataColumnName = uTA._TheName.Name;
  
              #endregion User_Item_Id - 员工
  
  

上一条：

下一条：

相关评论

发表评论

类型：	留言 建议 疑问
内容：
	(Alt+Enter)