private void saveDependence(string ID, Database db) { var sql = new Sql(@" select ModelID from FBSmartHelp where ID=@0 ", ID); List <string> list = db.Fetch <string>(sql); List <FBMetaDependence> listSave = new List <FBMetaDependence>(); foreach (var item in list) { FBMetaDependence model = new FBMetaDependence(); model.SourceID = ID; model.TargetID = item.ToString(); listSave.Add(model); } FBMeta.SaveDependence(ID, listSave, db); }
private void saveDependence(string ModelID, Database db) { var sql = new Sql(@" select ObjectID from FBDataModelObjects where ModelID=@0 union all select ObjectID from FBDataModelRealtions where ModelID = @0", ModelID); List <string> list = db.Fetch <string>(sql); List <FBMetaDependence> listSave = new List <FBMetaDependence>(); foreach (var item in list) { FBMetaDependence model = new FBMetaDependence(); model.SourceID = ModelID; model.TargetID = item.ToString(); listSave.Add(model); } FBMeta.SaveDependence(ModelID, listSave, db); }
private void saveDependence(string frmID, string modelID, List <string> list, Database db) { if (!string.IsNullOrEmpty(modelID)) { list.Add(modelID); } List <FBMetaDependence> listSave = new List <FBMetaDependence>(); var sql = new Sql("select DSID from FBFormDS where FormID=@0", frmID); var list1 = db.Fetch <string>(sql); list = list.Union(list1).ToList <string>(); //剔除重复项 foreach (var item in list) { FBMetaDependence model = new FBMetaDependence(); model.SourceID = frmID; model.TargetID = item.ToString(); listSave.Add(model); } FBMeta.SaveDependence(frmID, listSave, db); }