DAL.MSSQL/DAL_Admin/City.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

using System.Data;
using System.Data.SqlClient;
namespace DAL.MSSQL.DAL_Admin
{
    public class City:IDAL.IDAL_Admin.ICity
    {


        /// <summary>
        /// 删除区域信息
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public int Del_Info(int id)
        {
            StringBuilder sb = new StringBuilder();
            sb.Append("if not exists(select id from Sys_City where ct_parentid=@id)");
            sb.Append(" begin");
            sb.Append(" delete from Sys_City where id=@id");
            sb.Append(" select 1");
            sb.Append(" end");
            sb.Append(" else");
            sb.Append(" select -1");//有子节点

            return Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.connStr, CommandType.Text, sb.ToString(), new SqlParameter("@id", id)));

        }


        /// <summary>
        /// 编辑更新区域 （不更新区域上级）
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int Set_Info_edit(Model.Model_Admin.City model)
        {
            StringBuilder sb = new StringBuilder();

            sb.Append(" if exists(select id from Sys_City where ct_name=@ct_name and id<>@id)");
            sb.Append(" select -1");//重复的区域名称
            sb.Append(" else");
            sb.Append(" begin");
            sb.Append(" update Sys_City set ct_name=@ct_name,ct_sort=@ct_sort,ct_remarks=@ct_remarks where id=@id");//不更新上级
            sb.Append(" select 1");
            sb.Append(" end");



            SqlParameter[] parms = {
                new SqlParameter("@ct_name", SqlDbType.VarChar,50),
                new SqlParameter("@ct_sort", SqlDbType.Int),
                new SqlParameter("@ct_remarks", SqlDbType.VarChar,100),
                new SqlParameter("@id", SqlDbType.Int),
                };