/// <summary> /// delete IGroudpSymbol /// </summary> /// <param name="connection"></param> /// <param name="trans"></param> /// <param name="SymnbolID"></param> /// <returns></returns> internal bool DFDeleteBySymbolID(SqlConnection connection,SqlTransaction trans,int symnbolID) { DSTableAdapters.IGroupSymbolTableAdapter adap = new DSTableAdapters.IGroupSymbolTableAdapter(); adap.Connection = connection; adap.Transaction = trans; int? id = symnbolID; DS.IGroupSymbolDataTable tb = adap.GetIGroupSymbolBySymbolID(id); int count = tb.Rows.Count; DBWIGroupSymbolConfig iGroupSymbolConfig = new DBWIGroupSymbolConfig(); for (int i = 0; i < count; i++) { iGroupSymbolConfig.DFDeleteByIGroupSymbolID(connection, trans, tb[i].IGroupSymbolID); } adap.DeleteIGroupSymbolBySymbolID(symnbolID); return true; }
/// <summary> /// /// </summary> /// <param name="SymbolID"></param> internal bool DeleteIGroupSymbolBySymbolID(int SymbolID) { bool result = false; System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection); DSTableAdapters.IGroupSymbolTableAdapter adap = new DSTableAdapters.IGroupSymbolTableAdapter(); try { conn.Open(); adap.Connection = conn; int resultDelete = adap.DeleteIGroupSymbolBySymbolID(SymbolID); if (resultDelete > 0) result = true; } catch (Exception ex) { return false; } finally { adap.Connection.Close(); conn.Close(); } return result; }