/// <summary>
/// 获取表单数据源的字段合集
/// </summary>
/// <param name="frmid"></param>
/// <param name="dmid"></param>
/// <returns></returns>
public List <JFBFormDS> getFormDS(string frmid, string dmid)
{
List <FBDataModelObjects> list = DataModelCom.getModelDSList(dmid, true, base.Db);
List <JFBFormDS> ds = new List <JFBFormDS>();
foreach (FBDataModelObjects model in list)
{
JFBFormDS info = new JFBFormDS();
info.id = model.ID;
info.ismain = model.isMain == "1" ? true : false;
info.issys = true;
info.dataid = model.ObjectID;//
info.modelid = model.ModelID;
info.text = model.Name;
info.name = model.Code;
List <JFBFormDSFields> collist = new List <JFBFormDSFields>();
foreach (FBDataModelCols col in model.ColList)
{
collist.Add(new JFBFormDSFields {
id = col.Label, fieldid = col.ID, text = col.Label + "[" + col.Name + "]", type = col.DataType, isrelated = col.isRelated == "1"
});
}
info.columns = collist;
ds.Add(info);
}
//添加用户自定义数据源信息
List <FBDataSource> customDS = DataSourceCom.getFormDataSource(frmid, base.Db);
foreach (var model in customDS)
{
JFBFormDS info = new JFBFormDS();
info.id = model.ID;
info.ismain = false;
info.issys = false;
info.dataid = model.ID;
info.modelid = model.ID;
info.text = model.Name;
List <JFBFormDSFields> collist = new List <JFBFormDSFields>();
foreach (FBDataSourceCols col in model.ColList)
{
collist.Add(new JFBFormDSFields {
id = col.Code, fieldid = col.ID, text = col.Code + "[" + col.Name + "]", type = col.DataType, isrelated = false
});
}
info.columns = collist;
ds.Add(info);
}
return(ds);
}
public bool execDataSource(string sourceID, string frmID, Dictionary <string, object> arr)
{
DataSourceCom.execDataSource(sourceID, frmID, arr, base.Db);
//execDataSource(sourceID, frmID, arr);
return(true);
}
public List <Dictionary <string, object> > getModelTreeDataALL(string modeID, string keyWord, string filter, string order, Dictionary <string, object> formstate)
{
return(DataSourceCom.getDSTreeDataALL(modeID, keyWord, filter, order, formstate, base.Db));
}
public List <Dictionary <string, object> > getModelTreeDataDictList(string modeID, string level, string path, string parentID, string keyWord, string filter, string order)
{
return(DataSourceCom.getDSTreeData(modeID, level, path, parentID, keyWord, filter, order, base.Db));
}
public GridViewModel <dynamic> getDSPageList(string dsID, int currentPage, int perPage, string filter, string order, out long totalPages, out long totalItems)
{
return(DataSourceCom.getDSPageList(dsID, currentPage, perPage, filter, order, out totalPages, out totalItems, base.Db));
}
