DAL/DepartmentService.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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


namespace DAL
{
    public class DepartmentService
    {
        #region###查询所有部门
        public static DataSet GetDepartmentInfo() 
        {
            string sql = "select * from Department";
            return DBHelperSQL.Query(sql);
        }
        public static List<Department> GetDepartmentAll()
        {
            List<Department> list = new List<Department>();
            Department d = null;
            string sql = "select * from Department ORDER BY name,created";
            DataTable dt = DBHelperSQL.Query(sql).Tables[0];
            foreach (DataRow dr in dt.Rows)
            {
                d = new Department();
                d.Id = Convert.ToInt32(dr["id"]);
                d.Name = Convert.ToString(dr["name"]);
                d.Remarks = Convert.ToString(dr["remarks"]);
                d.Created = Convert.ToDateTime(dr["created"]);
                d.Status = Convert.ToInt32(dr["status"]);
                list.Add(d);
            }
            return list;
        
            
        }

        #endregion


        #region###根据ID查询部门
        public static Department GetDepartmentByID(int id) 
        {
            Department d = null;
            string sql = "select * from Department where id =" + id;
            DataTable dt = DBHelperSQL.Query(sql).Tables[0];
            foreach (DataRow dr in dt.Rows)
            {
                d = new Department();
                d.Id = Convert.ToInt32(dr["id"]);
                d.Name = Convert.ToString(dr["name"]);
                d.Remarks = Convert.ToString(dr["remarks"]);
                d.Created = Convert.ToDateTime(dr["created"]);
                d.Status = Convert.ToInt32(dr["status"]);
            }
            return d;   
        }