xs_tranferwaydal.cs

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

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

namespace DataAccess.DAL
{
    class Xs_TranferWayDAL
    {
        DataAccess.Comm.Comm c = new DataAccess.Comm.Comm();
        /// <summary>
        /// 查找运输方式设置
        /// </summary>
        /// <param name="TranferWay_Code"></param>
        /// <returns></returns>
        public List<Xs_TranferWay> SelectXs_TranferWay(string TranferWay_Code)
        {
            SqlConnection sqlcnn = c.conn();
            SqlCommand sqlcmd = new SqlCommand();
            sqlcmd.CommandText = "SelectXs_TranferWay";

            sqlcmd.CommandType = CommandType.StoredProcedure;
            sqlcmd.Parameters.AddWithValue("@TranferWay_Code", TranferWay_Code);
            sqlcmd.Connection = sqlcnn;
            SqlDataReader reader = null;
            List<Xs_TranferWay> list = new List<Xs_TranferWay>();
            try
            {
                sqlcnn.Open();
                reader = sqlcmd.ExecuteReader();
                while (reader.Read())
                {
                    Xs_TranferWay xs_tranferway = new Xs_TranferWay();
                    xs_tranferway.TranferWay_Code = reader["TranferWay_Code"].ToString();
                    xs_tranferway.TranferWay_type = reader["TranferWay_type"].ToString();
                    list.Add(xs_tranferway);
                }
            }
            catch (SqlException e)
            {
                throw e;
            }
            finally
            {
                if (sqlcnn.State != ConnectionState.Closed)
                {
                    sqlcnn.Close();
                }
            }
            return list;
        }
        /// <summary>
        /// 添加运输方式设置
        /// </summary>
        /// <param name="insert_xs_tranferway"></param>
        public void InsertXs_TranferWay(Xs_TranferWay insert_xs_tranferway)
        {
            SqlParameter[] parameter =
                { 
                   new SqlParameter("@TranferWay_Code",SqlDbType.VarChar,20),
                   new SqlParameter("@TranferWay_type",SqlDbType.VarChar,30)};
            parameter[0].Value = insert_xs_tranferway.TranferWay_Code;
            parameter[1].Value = insert_xs_tranferway.TranferWay_type;
            c.Excute("InsertXs_TranferWay", parameter);
               
        }
        /// <summary>
        /// 更新运输方式设置
        /// </summary>
        /// <param name="update_xs_tranferway"></param>
        public void UpdateXs_TranferWay(Xs_TranferWay update_xs_tranferway)
        {
            SqlParameter[] parameter =
                { 
                   new SqlParameter("@TranferWay_Code",SqlDbType.VarChar,20),
                   new SqlParameter("@TranferWay_type",SqlDbType.VarChar,30)};
            parameter[0].Value = update_xs_tranferway.TranferWay_Code;
            parameter[1].Value = update_xs_tranferway.TranferWay_type;
            c.Excute("UpdateXs_TranferWay", parameter);
        }
        /// <summary>
        /// 删除运输方式设置
        /// </summary>
        /// <param name="delete_xs_tranferway"></param>
        public void DeleteXs_TranferWay(Xs_TranferWay delete_xs_tranferway)
        {
            SqlParameter[] parameter =
                { 
                   new SqlParameter("@TranferWay_Code",SqlDbType.VarChar,20)};
            parameter[0].Value = delete_xs_tranferway.TranferWay_Code;
            c.Excute("DeleteXs_TranferWay", parameter);
        }

    }
}