xs_areasetdal.cs

来自「为了便于企业对客户按照地区进行统计查询分析」· CS 代码 · 共 116 行

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Model; 

namespace DataAccess.DAL
{
    class XS_AreasetDAL
    {
        //Comm.Comm c = new Comm.Comm();
        DataAccess.Comm.Comm c = new DataAccess.Comm.Comm();
        /// <summary>
        /// 查找地区设置
        /// </summary>
        /// <param name="Department_code"></param>
        /// <returns></returns>
        public List<XS_Areaset> SelectXS_Areaset(string AreaCode)
        {
            SqlConnection sqlcnn = c.conn();
            SqlCommand sqlcmd = new SqlCommand();
            sqlcmd.CommandText = "SelectXS_AreasetDAL";

            sqlcmd.CommandType = CommandType.StoredProcedure;
            sqlcmd.Parameters.AddWithValue("@AreaCode", AreaCode);
            sqlcmd.Connection = sqlcnn;
            SqlDataReader reader = null;
            List<XS_Areaset> list = new List<XS_Areaset>();

            try
            {
                sqlcnn.Open();
                reader = sqlcmd.ExecuteReader();
                while (reader.Read())
                {
                    XS_Areaset xs_areaset = new XS_Areaset();
                    xs_areaset.AreaCode = reader["AreaCode"].ToString();
                    xs_areaset.AreaName = reader["AreaName"].ToString();
                    xs_areaset.CodeLevel =Convert.ToInt32( reader["CodeLevel"].ToString());
                    xs_areaset.ParentCode = reader["ParentCode"].ToString();
                    xs_areaset.EndFlag =Convert.ToBoolean( reader["EndFlag"].ToString());
                    list.Add(xs_areaset);
                }
            }
            catch (SqlException e)
            {
                throw e;
            }
            finally
            {
                if (sqlcnn.State != ConnectionState.Closed)
                {
                    sqlcnn.Close();
                }
            }
            return list;
        }

        

        //public void InsertXS_Areaset(string AreaCode, string AreaName, int CodeLevel, string ParentCode, string EndFlag)
        /// <summary>
        /// 添加地区设置
        /// </summary>
        /// <param name="insert_xs_areaset"></param>
        public void InsertXS_Areaset(XS_Areaset insert_xs_areaset)
        {

            SqlParameter[] parameters = { 
					new SqlParameter("@AreaCode", SqlDbType.VarChar,20),
					new SqlParameter("@AreaName", SqlDbType.VarChar,50),
					new SqlParameter("@CodeLevel", SqlDbType.Int,4),
					new SqlParameter("@ParentCode", SqlDbType.VarChar,20),
					new SqlParameter("@EndFlag", SqlDbType.Bit,1)}; 
            parameters[0].Value = insert_xs_areaset.AreaCode;
            parameters[1].Value = insert_xs_areaset.AreaName;
            parameters[2].Value = insert_xs_areaset.CodeLevel;
            parameters[3].Value = insert_xs_areaset.ParentCode;
            parameters[4].Value = insert_xs_areaset.EndFlag;
            c.Excute("InsertXS_Areaset", parameters);
        }
        /// <summary>
        /// 更新地区设置
        /// </summary>
        /// <param name="update_xs_areaset"></param>
        public void UpdateXS_Areaset(XS_Areaset update_xs_areaset)
        {
            SqlParameter[] parameters = { 
					new SqlParameter("@AreaCode", SqlDbType.VarChar,20),
					new SqlParameter("@AreaName", SqlDbType.VarChar,50),
					new SqlParameter("@CodeLevel", SqlDbType.Int,4),
					new SqlParameter("@ParentCode", SqlDbType.VarChar,20),
					new SqlParameter("@EndFlag", SqlDbType.Bit,1)};
            parameters[0].Value = update_xs_areaset.AreaCode;
            parameters[1].Value = update_xs_areaset.AreaName;
            parameters[2].Value = update_xs_areaset.CodeLevel;
            parameters[3].Value = update_xs_areaset.ParentCode;
            parameters[4].Value = update_xs_areaset.EndFlag;
            c.Excute("UpdateXS_Areaset", parameters);
        }
        /// <summary>
        /// 删除地区设置
        /// </summary>
        /// <param name="delete_xs_areaset"></param>
        public void DeleteXS_Areaset(XS_Areaset delete_xs_areaset)
        {

            SqlParameter[] parameters = { 
					new SqlParameter("@AreaCode", SqlDbType.VarChar,20) };
            parameters[0].Value = delete_xs_areaset.AreaCode;
            c.Excute("DeleteXS_Areaset", parameters);
        }
    }
}