/// <summary> /// 删除数据库中的一条数据 /// </summary> /// <typeparam name="T">数据类型</typeparam> /// <param name="id">数据id</param> /// <returns></returns> public bool DeleteGenericCacheDB <T>(int id) where T : BaseModel { Type type = typeof(T); //string sqlStr = "delete " + "[" + type.Name + "]" + " where id=@Id"; string sqlStr = GenericCacheDel <Company> .GetDelSql(); int rows = 0; using (SqlConnection conn = new SqlConnection(ConnStrNetVipClsTweDB)) { SqlCommand comm = new SqlCommand(sqlStr, conn); SqlParameter para = new SqlParameter("@Id", id); comm.Parameters.Add(para); conn.Open(); try { rows = comm.ExecuteNonQuery(); } catch (Exception e) { conn.Close(); throw e; } } if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除数据库中的一条数据 /// </summary> /// <typeparam name="T">数据类型</typeparam> /// <param name="id">数据id</param> /// <returns></returns> public bool DeleteGenericCacheDBDelegate <T>(int id) where T : BaseModel { Type type = typeof(T); //string sqlStr = "delete " + "[" + type.Name + "]" + " where id=@Id"; string sqlStr = GenericCacheDel <T> .GetDelSql(); int rows = 0; //using (SqlConnection conn = new SqlConnection(ConnStrNetVipClsTweDB)) //{ // SqlCommand comm = new SqlCommand(sqlStr, conn); // SqlParameter para = new SqlParameter("@Id", id); // comm.Parameters.Add(para); // conn.Open(); // try // { // rows = comm.ExecuteNonQuery(); // } // catch (Exception e) // { // conn.Close(); // throw e; // } //} Func <SqlCommand, int> func = comm => { SqlParameter para = new SqlParameter("@Id", id); comm.Parameters.Add(para); return(comm.ExecuteNonQuery()); }; rows = this.ExexuteSql(sqlStr, func); if (rows > 0) { return(true); } else { return(false); } }