/// <summary>
/// 帮助控件查询接口
/// </summary>
/// <param name="helpID"></param>
/// <param name="keyword"></param>
/// <param name="codeField"></param>
/// <param name="nameField"></param>
/// <param name="isParent"></param>
/// <returns></returns>
public List <dynamic> getQueryHelpSwitch(string helpID, string keyword, string codeField, string nameField, string filter, bool isParent)
{
var svr = new FBSmartHelpService(context);
var model = svr.getModel(helpID);
return(DataModelCom.getQueryHelpSwitch(model.ModelID, keyword, codeField, nameField, filter, model.Filter, isParent, base.Db));
}
public List <FBDataModelCols> GetObjectColList(string ModelID, string ObjectID, bool hasRealtion)
{
if (string.IsNullOrEmpty(ObjectID))
{
ObjectID = DataModelCom.getMainModelObjectID(ModelID, base.Db);
}
List <FBDataModelCols> list = new List <FBDataModelCols>();
list = Db.Fetch <FBDataModelCols>("select * from FBDataModelCols where ModelID=@0 and ModelObjectID=@1", ModelID, ObjectID);
return(list);
}
/// <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);
}
/// <summary>
/// List Save
/// </summary>
/// <param name="modelID"></param>
/// <param name="ds"></param>
/// <param name="dsDel"></param>
public void saveModelList(string modelID, DataSet ds, DataTable dsDel)
{
//try
//{
// base.Db.BeginTransaction();
DataModelCom.saveModelList(modelID, ds, dsDel, base.Db);
// base.Db.CompleteTransaction();
//}
//catch (Exception ex)
//{
// base.Db.AbortTransaction();
// log.Error(ex.Message, ex);
// throw ex;
//}
}
public void deleteModel(string modelID, string dataid)
{
//try
//{
// base.Db.BeginTransaction();
// 启用依赖检查
DataModelCom.deleteModelByDataID(modelID, dataid, true, base.Db);
// this.Db.CompleteTransaction();
//}
//catch (Exception ex)
//{
// base.Db.AbortTransaction();
// throw ex;
//}
}
public JFBSmartHelp getRuntimeModel(string helpid)
{
Sql sql = new Sql(@"select id,modelID,title,viewtype as type,pageOption,pageSize,autoCol,filter,sort from FBSmartHelp where ID=@0", helpid);
JFBSmartHelp model = base.Db.FirstOrDefault <JFBSmartHelp>(sql);
var dmmodel = DataModelCom.getModelMainSchemaForWeb(model.modelID, base.Db);
model.treeInfo = dmmodel.treeInfo;//树形结构
model.pkCol = dmmodel.pkCol;
sql = new Sql(@"select ColName as name,ColCode as code,align,width, ord,Visible from FBSmartHelpCols where HelpID =@0 order by ord asc", helpid);
model.ColList = base.Db.Fetch <JFBSmartHelpCols>(sql);
return(model);
}
public void saveModelALL(string modelID, string dataID, DataSet ds, string status, TreeNode tree)
{
//try
//{
// base.Db.BeginTransaction();
FBDataModel model = this.GetModel(modelID);
DataModelCom.saveModelALL(modelID, model, dataID, ds, status, tree, base.Db);
// base.Db.CompleteTransaction();
//}
//catch (Exception ex)
//{
// base.Db.AbortTransaction();
// log.Error(ex.Message, ex);
// throw ex;
//}
}
public string remoteCheck(CheckExits model, string frmID, string dataModelID)
{
Sql sql = new NPoco.Sql(string.Format("select count(1) from {0} where {1}='{2}'", model.TableName, model.ValidField, model.ValidValue));
if (!string.IsNullOrEmpty(model.DataID))
{
sql.Append(string.Format(" and {0}<>'{1}' ", model.KeyField, model.DataID));
}
if (model.Filter != null)
{
sql.Append(ConditionParser.Serialize(model.Filter));
}
var ds = DataModelCom.getDataSource(dataModelID, this.Db);
Database ywdb = DataBaseManger.GetDB(ds);
if (ywdb.Single <long>(sql) > 0)
{
return(string.Format("{0}的值已存在", model.Label));
}
return("");
}
public List <Dictionary <string, object> > getModelTreeDataALL(string modeID, string keyWord, string filter, string order)
{
return(DataModelCom.getModelTreeDataALL(modeID, keyWord, filter, order, base.Db));
}
public List <Dictionary <string, object> > getModelTreeDataDictList(string modeID, string level, string path, string parentID, string keyWord, string filter, string order)
{
return(DataModelCom.getModelTreeData(modeID, level, path, parentID, keyWord, filter, order, base.Db));
}
public List <dynamic> getModelData(string modelID, string filter, string order)
{
return(DataModelCom.getModelData(modelID, filter, order, base.Db));
}
public GridViewModel <dynamic> getModelPageList(string modelID, int currentPage, int perPage, string filter, string order, out long totalPages, out long totalItems)
{
return(DataModelCom.getModelPageList(modelID, currentPage, perPage, filter, order, out totalPages, out totalItems, base.Db));
}
public List <dynamic> getModelDataByDataID(string modelID, string dataid, bool detail)
{
return(DataModelCom.getModelDataByDataID(modelID, dataid, detail, base.Db));
}
public List <JFBSchema> getModelSchemaForWeb(string modelID)
{
// 基础数据源
return(DataModelCom.getModelSchemaForWeb(modelID, base.Db));
}