countyvillage.cs

来自「该服务平台解决了计算机网络与移动网络之间信息交换问题」· CS 代码 · 共 130 行

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Microsoft.Practices.EnterpriseLibrary.Data;

namespace DataAccess.TableAccessor
{
    public class CountyVillage
    {
        private Database db;

        public CountyVillage()
        {
            db = DatabaseFactory.CreateDatabase("Connection String");
        }
        public int AddAreaInfo(string areaName, string remark)
        {
            string strSQL = string.Format("INSERT INTO Area  (AreaName, Remark) VALUES  ('{0}','{1}')", areaName, remark);
            try
            {
                return db.ExecuteNonQuery(CommandType.Text, strSQL);
            }
            catch
            {
                return 0;
            }
        }
        /// <summary>
        /// 得到所有的地市信息
        /// </summary>
        /// <returns></returns>
        public DataTable GetAreaInfo()
        {
            String strSql = "SELECT AreaID, AreaCode, AreaName, Remark FROM Area WHERE (IsValid <> 0) ORDER BY AreaID";
            DataSet ds = db.ExecuteDataSet(CommandType.Text, strSql);
            return ds.Tables[0];
        }
        /// <summary>
        /// 得到单个地市信息
        /// </summary>
        /// <param name="areaID"></param>
        /// <returns></returns>
        public DataTable GetAreaInfoByUserID(int areaID)
        {
            string strSQL = string.Format("SELECT AreaID, AreaName, Remark FROM Area WHERE (IsValid <> 0) AND AreaID = {0}", areaID);
            DataSet ds = db.ExecuteDataSet(CommandType.Text, strSQL);
            return ds.Tables[0];
        }
        /// <summary>
        /// 修改地市信息
        /// </summary>
        /// <param name="areaID"></param>
        /// <param name="areaName"></param>
        /// <param name="bak"></param>
        /// <returns></returns>
        public int UpdateArea(int areaID, string areaName, string bak)
        {
            string strSQL = string.Format("UPDATE Area SET AreaName ='{0}', Remark ='{1}'WHERE AreaID = {2}", areaName, bak, areaID);
            return db.ExecuteNonQuery(CommandType.Text, strSQL);
        }
        /// <summary>
        /// 删除地市
        /// </summary>
        /// <param name="areaID"></param>
        /// <returns></returns>
        public int DelArea(int areaID)
        {
            string strSQL = string.Format("UPDATE Area SET IsValid = 0 WHERE AreaID = {0}", areaID);
            return db.ExecuteNonQuery(CommandType.Text, strSQL);
        }
        /// <summary>
        /// 得到所有区县信息
        /// </summary>
        /// <param name="areaID"></param>
        /// <returns></returns>
        public DataTable GetCountyInfo(int areaID)
        {
            String strSql = string.Format("SELECT CountyID, CountyCode, CountyName, AreaID FROM " +
                "County WHERE (AreaID = {0})", areaID);
            DataSet ds = db.ExecuteDataSet(CommandType.Text, strSql);
            return ds.Tables[0];
        }
        /// <summary>
        /// 得到所有的乡镇信息
        /// </summary>
        /// <param name="areaID"></param>
        /// <param name="countyID"></param>
        /// <returns></returns>
        public DataTable GetVillageInfo(int areaID, int countyID)
        {
            String strSql = string.Format("SELECT VillageID, AreaID, CountyID, VillageCode, VillageName " +
                "FROM Village WHERE (AreaID = {0}) AND (CountyID = {1})", areaID, countyID);
            DataSet ds = db.ExecuteDataSet(CommandType.Text, strSql);
            return ds.Tables[0];
        }
        public DataTable GetMostCounty(int AreaID)
        {
            string strSql = string.Format("SELECT CountyID, CountyName FROM County " +
                "WHERE(AreaID = {0})", AreaID);
            DataSet ds = db.ExecuteDataSet(CommandType.Text, strSql);
            return ds.Tables[0];
        }

        public DataTable GetCountyName()
        {
            string strSql = "SELECT CountyID, CountyName FROM County";
            DataSet ds = db.ExecuteDataSet(CommandType.Text, strSql);
            return ds.Tables[0];
        }

        //public DataTable GetVillageInfo(int typeID,string countyID)
        //{
        //    string strSql = string.Format("SELECT VillageID, VillageName, CountyID FROM Village " +
        //        "WHERE (CountyID = '{0}' AND UserInfoID = {1})", countyID,typeID);
        //    DataSet ds = db.ExecuteDataSet(CommandType.Text, strSql);
        //    return ds.Tables[0];
        //}

        public DataTable GetVillageName(string countyID)
        {
            string strSql = string.Format("SELECT VillageID, VillageName, CountyID FROM Village " +
                "WHERE (CountyID = '{0}')", countyID);
            DataSet ds = db.ExecuteDataSet(CommandType.Text, strSql);
            return ds.Tables[0];
        }
    }
}