asp.net 批量删除操作

最新推荐文章于 2024-04-19 19:24:46 发布

zjb1989923

最新推荐文章于 2024-04-19 19:24:46 发布

阅读量468

点赞数

文章标签： asp.net string delete

本文链接：https://blog.csdn.net/zjb1989923/article/details/6803726

版权

        /// <summary>
        /// 方法名称：DeleteSelect
        /// 作者：

        /// 用途：批量删除
        /// </summary>
        /// <param name="SelecedCataId"></param>
        /// <returns></returns>
        public static int DeleteSelect(string[] ArrayGRID)
        {
            string sqlStr = "delete from dbo.GR_JBXX where GRID in (";
            for (int i = 0; i < ArrayGRID.Length; i++)
            {
                if (i == ArrayGRID.Length - 1)
                {
                    sqlStr += ("'" + ArrayGRID[i] + "')");
                    break;
                }
                else
                {
                    sqlStr += ("'" + ArrayGRID[i] + "',");
                }
            }
            return DbHelperSQL.ExecuteSql(sqlStr);
        }