ZSJ_BCY_Web_DAL/ProjectService.cs

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

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

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using ZSJ_BCY_Web_Model;

namespace ZSJ_BCY_Web_DAL
{
    public class ProjectService
    {
        /// <summary>
        /// 查询项目
        /// </summary>
        /// <returns></returns>
        public static List<Project> SelectProject()
        {

            string sql = "select * from Project";
            DataTable dt = DBHelper.Query(sql);
            List<Project> list = new List<Project>();
            foreach (DataRow item in dt.Rows)
            {
                Project project = new Project()
                {
                    Id = Convert.ToInt32(item["Id"]),
                    ProjectName = Convert.ToString(item["ProjectName"]),
                    ProjectPrice = Convert.ToInt32(item["ProjectPrice"]),
                    ProjectRemarks = Convert.ToString(item["ProjectRemarks"]),
                    ProjectStatus = Convert.ToInt32(item["ProjectStatus"])

                };
                list.Add(project);
            }
            return list;

        }

        /// <summary>
        /// 查询项目  （分页存储过程）
        /// </summary>
        /// <param name="pageindex"></param>
        /// <param name="pagesize"></param>
        /// <param name="totalcount"></param>
        /// <returns></returns>
        public static List<Project> SelectProject(int pageindex, int pagesize, ref int totalcount)
        {
            string procName = "GetPageProject";
            SqlParameter[] pame = { 
            new SqlParameter("@pageindex",pageindex),
            new SqlParameter("@pagesize",pagesize),
            new SqlParameter("@tatolcount",totalcount)
            };
            pame[2].Direction = ParameterDirection.Output;

            SqlDataReader reader = DBHelper.ExecuteReaderproc(procName,pame);
            List<Project> list = new List<Project>();