test/Member/CoreEntity/DAL/DeptDAL.cs

using Common.Model;
using CoreEntity.Entity;
using System;
using System.Collections.Generic;
using System.Data;
using System.Text;
using ZcPeng.PublicLibrary;

namespace CoreEntity.DAL
{
    public class DeptDAL
    {
        public static List<DeptDoc> getDept()
        {
            DataTable dt = new DataTable();
            string commandTextSupp = "Select * From DeptDoc";
            string resultSupp;

            List<List<Object>> parametersSupp = new List<List<Object>>();
            DataAccess.GetValues(commandTextSupp, ref dt, DataAccess.ToParameters(parametersSupp).ToArray(), out resultSupp);
            
            if (dt!=null && dt.Rows.Count > 0)
            {
                List<DeptDoc> suplist = (List<DeptDoc>)ModelConvertHelper<DeptDoc>.ConvertToModel(dt);
                return suplist;
            }
            return null;
        }
    }
}