YKT_DAL/DALCities.cs

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

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

using System;
using System.Collections.Generic;

using System.Text;
using System.Data;
using YKT.DBUtility;
using System.Data.SqlClient;
using YKT_Model;

namespace YKT_DAL
{
    public class DALCities
    {
        #region  成员方法

        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(string area_id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from YKT_Cities");
            strSql.Append(" where area_id=@area_id ");
            SqlParameter[] parameters = {
					new SqlParameter("@area_id", SqlDbType.NVarChar,50)};
            parameters[0].Value = area_id;

            return DbHelperSQL.Exists(strSql.ToString(), parameters);
        }


        /// <summary>
        /// 增加一条数据
        /// </summary>
        public void Add(ModelCities model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into YKT_Cities(");
            strSql.Append("area_id,area_name,area_level,area_parent_id)");
            strSql.Append(" values (");
            strSql.Append("@area_id,@area_name,@area_level,@area_parent_id)");
            SqlParameter[] parameters = {
					new SqlParameter("@area_id", SqlDbType.NVarChar,10),
					new SqlParameter("@area_name", SqlDbType.NVarChar,100),
					new SqlParameter("@area_level", SqlDbType.Int,4),
					new SqlParameter("@area_parent_id", SqlDbType.NVarChar,10)};
            parameters[0].Value = model.area_id;
            parameters[1].Value = model.area_name;
            parameters[2].Value = model.area_level;
            parameters[3].Value = model.area_parent_id;

            DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
        }
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public void Update(ModelCities model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update YKT_Cities set ");