流程
先建个接口,弄个DAL操作,再BLL操作
接口:
/// <summary> /// 删除一批记录 (按主键列表)(创建人:YZK 创建时间:2011-11-22 9:01:53) /// </summary> /// <param name="_SqlParameterLoading">删除条件</param> /// <returns>放回影响行数</returns> void DeleteLinkInfo(SqlParameterLoading _SqlParameterLoading);
DAL层:删除记录
/// <summary> /// 删除一批记录 (按主键列表)(创建人:YZK 创建时间:2011-11-22 9:01:53) /// </summary> /// <param name="_SqlParameterLoading">修改的条件</param> /// <returns>成功返回影响行数</returns> public void DeleteLinkInfo(SqlParameterLoading _SqlParameterLoading) { string DELETE_LinkInfo_SQL = @"DELETE FROM T_CMS_LINK_INFO WHERE 1 = 1 {0} ;"; string SqlText = string.Format(DELETE_LinkInfo_SQL, _SqlParameterLoading.GetWhereStr()); using (IDbConnection conn = ConnectionConstruct.LoadInterNetConnection()) { sqlServer.ExecuteNonQuery(conn, CommandType.Text, SqlText, _SqlParameterLoading.GetParameters()); } }
BLL层:
/// <summary> /// 删除一条记录(根据主键)(创建人:YZK 创建时间:2011-11-22 9:01:53) /// </summary> /// <param name="Link_id">主键</param> /// <returns>成功返回影响行数</returns> public static void DeleteLinkInfo(SqlParameterLoading _SqlParameterLoading) { dal.DeleteLinkInfo(_SqlParameterLoading); }