存储过程复习

最新推荐文章于 2022-11-29 21:32:23 发布

andycode

最新推荐文章于 2022-11-29 21:32:23 发布

阅读量316

点赞数

分类专栏： C#应用文章标签：存储 exception delete string cmd

本文链接：https://blog.csdn.net/andycode/article/details/6676368

版权

C#应用专栏收录该内容

32 篇文章 0 订阅

订阅专栏

CREATE PROC proc_DeleteSynchronousUpdateData
@TabName VARCHAR(50),
@ColName VARCHAR(20),
@FieldValue VARCHAR(50)
AS
BEGIN
EXEC('DELETE FROM ' + @TabName + ' WHERE ' + @ColName + ' = ' + @FieldValue)
END

EXEC proc_DeleteSynchronousUpdateData @TabName='App_Bill',@ColName='PrimaryKey',@FieldValue='0'

        /// <summary>
        /// 执行增、删、改
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public static int ExecuteNonQueryData(string procName,SqlParameter[] paramArray)
        {
            SqlCommand cmd = new SqlCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = procName;
            cmd.Parameters.AddRange(paramArray);
            try
            {
                OpenConn();
                cmd.Connection = conn;
                return cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 删除分销的明细
        /// </summary>
        /// <returns></returns>
        public int DeleteDistributeSellGoods(int foreignKey)
        {
            DAL.ExecuteNonQueryData("proc_DeleteSynchronousUpdateData", new SqlParameter[] {
                new SqlParameter("@TabName", "SP_FL_DistributeSellGoodsInfo"), new SqlParameter("@ColName", "ForeignKey"), new SqlParameter("@FieldValue", foreignKey) });
        }