gy_departmentdal.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 Gy_DepartmentDAL
    {
        //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<Gy_Department> SelectGy_Customer(string Department_code)
        {
            SqlConnection sqlcnn = c.conn();
            SqlCommand sqlcmd = new SqlCommand();
            sqlcmd.CommandText = "SelectGy_Department";

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

            try
            {
                sqlcnn.Open();
                reader = sqlcmd.ExecuteReader();
                while (reader.Read())
                {
                    Gy_Department gy_department = new Gy_Department();
                    gy_department.Department_code = reader["Department_code"].ToString();
                    gy_department.Department_name = reader["Department_name"].ToString();
                    gy_department.Department_xsflag =Convert.ToBoolean( reader["Department_xsflag"].ToString());
                    gy_department.Department_xsflag =Convert.ToBoolean(reader["Department_xsflag"].ToString());
                    list.Add(gy_department); 
                }
            }
            catch (SqlException e)
            {
                throw e;
            }
            finally
            {
                if (sqlcnn.State != ConnectionState.Closed)
                {
                    sqlcnn.Close();
                }
            }
            return list;
        }
        /// <summary>
        /// 添加部门
        /// </summary>
        /// <param name="Department_code"></param>
        /// <param name="Department_name"></param>
        /// <param name="Department_xsflag"></param>
        //public void InsertGy_Department(string Department_code, string Department_name, string Department_xsflag)
         public void InsertGy_Department(Gy_Department insert_gy_department)
        {

            SqlParameter[] parameters = { 
					new SqlParameter("@Department_code", SqlDbType.VarChar,20),
					new SqlParameter("@Department_name", SqlDbType.VarChar,50),
					new SqlParameter("@Department_xsflag", SqlDbType.Bit,1)};
            parameters[0].Value = insert_gy_department.Department_code;
            parameters[1].Value = insert_gy_department.Department_name;
            parameters[2].Value = insert_gy_department.Department_xsflag;
            c.Excute("InsertGy_Department", parameters);
        }
        /// <summary>
        /// 更新部门
        /// </summary>
        /// <param name="Department_code"></param>
        /// <param name="Department_name"></param>
        /// <param name="Department_xsflag"></param>
        //public void UpdateGy_Department(string Department_code, string Department_name, string Department_xsflag)
         public void UpdateGy_Department(Gy_Department update_gy_department)
         {
             SqlParameter[] parameters = { 
					new SqlParameter("@Department_code", SqlDbType.VarChar,20),
					new SqlParameter("@Department_name", SqlDbType.VarChar,50),
					new SqlParameter("@Department_xsflag", SqlDbType.Bit,1)};
             parameters[0].Value = update_gy_department.Department_code;
             parameters[1].Value = update_gy_department.Department_name;
             parameters[2].Value = update_gy_department.Department_xsflag;
             c.Excute("UpdateGy_Department", parameters);
         }
       /// <summary>
       /// 删除部门
       /// </summary>
       /// <param name="Department_code"></param>
        public void DeleteGy_Department(Gy_Department delete_gy_department)
        {
            SqlParameter[] parameters = {
					new SqlParameter("@Department_code", SqlDbType.VarChar,20)};
            parameters[0].Value = delete_gy_department.Department_code;
            c.Excute("DeleteGy_Department", parameters);
        }
    }
}