xs_tradesetdal.cs

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

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

namespace DataAccess.DAL
{
    class Xs_TradeSetDAL
    {
        DataAccess.Comm.Comm c = new DataAccess.Comm.Comm();       　
        /// <summary>
        /// 查找行业设置
        /// </summary>
        /// <param name="TradeCode"></param>
        /// <returns></returns>
        public List<Xs_TradeSet> SelectXs_TradeSet(string TradeCode)
        {
            SqlConnection sqlcnn = c.conn();
            SqlCommand sqlcmd = new SqlCommand();
            sqlcmd.CommandText = "SelectXs_TradeSet";
            sqlcmd.CommandType = CommandType.StoredProcedure;
            sqlcmd.Parameters.AddWithValue("@TradeCode", TradeCode);
            sqlcmd.Connection = sqlcnn;
            SqlDataReader reader = null;
            List<Xs_TradeSet> list = new List<Xs_TradeSet>();
            try
            {
                sqlcnn.Open();
                reader = sqlcmd.ExecuteReader();
                while (reader.Read())
                {
                    Xs_TradeSet xs_tradeset = new Xs_TradeSet();
                    xs_tradeset.TradeCode = reader["TradeCode"].ToString();
                    xs_tradeset.TradeName = reader["TradeName"].ToString();
                    xs_tradeset.CodeLevel = Convert.ToInt32(reader["CodeLevel"].ToString());
                    xs_tradeset.ParentCode =reader["ParentCode"].ToString();
                    xs_tradeset.EndFlag = Convert.ToBoolean( reader["EndFlag"].ToString());
                    list.Add(xs_tradeset);
                }
            }
            catch (SqlException e)
            {
                throw e;
            }
            finally
            {
                if (sqlcnn.State != ConnectionState.Closed)
                {
                    sqlcnn.Close();
                }
            }
            return list;
        }
        /// <summary>
        /// 添加行业设置
        /// </summary>
        /// <param name="insert_xs_tradeset"></param>
        public void InsertXs_TradeSet(Xs_TradeSet insert_xs_tradeset)
        {
            SqlParameter[] parameters = { 
					new SqlParameter("@TradeCode", SqlDbType.VarChar,20),
					new SqlParameter("@TradeName", 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_tradeset.TradeCode;
            parameters[1].Value = insert_xs_tradeset.TradeName;
            parameters[2].Value = insert_xs_tradeset.CodeLevel;
            parameters[3].Value = insert_xs_tradeset.ParentCode;
            parameters[4].Value = insert_xs_tradeset.EndFlag;
            c.Excute("InsertXs_TradeSet", parameters);
        }
        /// <summary>
        /// 更新行业设置　
        /// </summary>
        /// <param name="update_xs_tradeset"></param>
        public void UpdateXs_TradeSet(Xs_TradeSet update_xs_tradeset)
        {
            SqlParameter[] parameters = { 
					new SqlParameter("@TradeCode", SqlDbType.VarChar,20),
					new SqlParameter("@TradeName", 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_tradeset.TradeCode;
            parameters[1].Value = update_xs_tradeset.TradeName;
            parameters[2].Value = update_xs_tradeset.CodeLevel;
            parameters[3].Value = update_xs_tradeset.ParentCode;
            parameters[4].Value = update_xs_tradeset.EndFlag;
            c.Excute("UpdateXs_TradeSet", parameters);
        }
        /// <summary>
        /// 删除行业设置
        /// </summary>
        /// <param name="delete_xs_tradeset"></param>
        public void DeleteXs_TradeSet(Xs_TradeSet delete_xs_tradeset)
        {
            SqlParameter[] parameters = { 
					new SqlParameter("@TradeCode", SqlDbType.VarChar,20) };
            parameters[0].Value = delete_xs_tradeset.TradeCode;
            c.Excute("DeleteXs_TradeSet", parameters);
        }
    }
}