/// <summary> /// 列表删除模型 /// </summary> /// <param name="ModelID"></param> public void DeleteModelInfo(string ModelID) { try { base.Db.BeginTransaction(); FBMeta.deleteCheck(ModelID, base.Db); FBMeta.DeleteMetaData(ModelID, base.Db);//删除元数据 Sql sql = new Sql(@"delete from FBDataModel where ID=@0", ModelID); base.Db.Execute(sql); sql = new Sql(@"delete from FBMetaData where ID=@0", ModelID); base.Db.Execute(sql); sql = new Sql(@"delete from FBDataModelObjects where ModelID=@0", ModelID); base.Db.Execute(sql); sql = new Sql(@"delete from FBDataModelCols where ModelID=@0", ModelID); base.Db.Execute(sql); this.Db.CompleteTransaction(); } catch (Exception ex) { base.Db.AbortTransaction(); throw ex; } }
public void deleteData(string helpid) { try { base.Db.BeginTransaction(); FBMeta.deleteCheck(helpid, base.Db); FBMeta.DeleteMetaData(helpid, base.Db);//删除元数据 base.Db.Execute(new NPoco.Sql("delete from FBSmartHelp where id=@0", helpid)); this.Db.CompleteTransaction(); } catch (Exception ex) { base.Db.AbortTransaction(); throw ex; } }
public void DeleteObject(string ID) { try { base.Db.BeginTransaction(); FBMeta.deleteCheck(ID, base.Db); FBMeta.DeleteMetaData(ID, base.Db); base.Db.Execute(new NPoco.Sql("delete from FBDataObject where id=@0", ID)); this.Db.CompleteTransaction(); } catch (Exception ex) { base.Db.AbortTransaction(); throw ex; } }
/// <summary> /// 删除自定义数据源 /// </summary> /// <param name="id"></param> public void deleteData(string id) { try { base.Db.BeginTransaction(); FBMeta.deleteCheck(id, base.Db); FBMeta.DeleteMetaData(id, base.Db);//删除元数据 base.Db.Execute(new NPoco.Sql("delete from FBDataSource where id=@0", id)); base.Db.Execute(new NPoco.Sql("delete from FBDataSourceCols where DSID=@0", id)); this.Db.CompleteTransaction(); } catch (Exception ex) { base.Db.AbortTransaction(); throw ex; } }
/// <summary> /// 删除数据 /// </summary> /// <param name="id"></param> public void DeleteData(string id) { try { base.Db.BeginTransaction(); FBMeta.deleteCheck(id, base.Db); FBMeta.DeleteMetaData(id, base.Db); base.Remove(new NPoco.Sql("delete from FBDataObject where id=@id", id)); this.Db.CompleteTransaction(); } catch (Exception ex) { base.Db.AbortTransaction(); throw ex; } }
/// <summary> /// 删除表单 /// </summary> /// <param name="frmID"></param> public void deleteData(string frmID) { try { base.Db.BeginTransaction(); FBMeta.deleteCheck(frmID, base.Db); FBMeta.DeleteMetaData(frmID, base.Db);//删除元数据 base.Db.Execute(new NPoco.Sql("delete from FBForm where id=@0", frmID)); base.Db.Execute(new NPoco.Sql("delete from FBFormDS where FormID=@0", frmID)); base.Db.Execute(new NPoco.Sql("delete from FBFormToolBar where FormID=@0", frmID)); base.Db.CompleteTransaction(); } catch (Exception ex) { base.Db.AbortTransaction(); throw ex; } }
/// <summary> /// 删除自定义数据源 /// </summary> /// <param name="id"></param> public void deleteData(string id) { try { base.Db.BeginTransaction(); FBMeta.deleteCheck(id, base.Db); FBMeta.DeleteMetaData(id, base.Db);//删除元数据 base.Db.Execute(new NPoco.Sql("delete from FBComponent where ID=@0", id)); base.Db.Execute(new NPoco.Sql("delete from FBCMPMethod where CMPID=@0", id)); base.Db.Execute(new NPoco.Sql("delete from FBCMPPara where CMPID=@0", id)); this.Db.CompleteTransaction(); } catch (Exception ex) { base.Db.AbortTransaction(); throw ex; } }