流程

先建个接口,弄个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);
        }

 

 

posted @ 2013-04-07 11:14  觉信  阅读(173)  评论(0编辑  收藏  举报