SQLServerDAL/Deliver.cs

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

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

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

using WMPT.Model;
using WMPT.DBUtility;
using System.Collections;
//using WMPT.IDAL;


namespace WMPT.SQLServerDAL
{
    public class Deliver
    {
        /// <summary>
        /// 后台获取列表
        /// </summary>
        /// <param name="pagesize">页尺寸</param>
        /// <param name="pageindex">页索引</param>
        /// <param name="strWhere">查询条件</param>
        /// <param name="orderName">排序字段</param>
        /// <param name="orderType">排序类型，1为降序，0为升序</param>
        /// <returns>图书列表</returns>
        ///此代码由杭景科技代码内部生成器自动生成
        public IList<DeliverInfo> GetDeliverList(int pagesize, int pageindex, string strWhere, string orderName, int orderType, string otherwhere)
        {
            IList<DeliverInfo> infos = new List<DeliverInfo>();
            SqlParameter[] parameters =
            {
                new SqlParameter("@pagesize", SqlDbType.Int),
                new SqlParameter("@pageindex", SqlDbType.Int),
                new SqlParameter("@orderfield", SqlDbType.VarChar,255),
                new SqlParameter("@ordertype", SqlDbType.VarChar,5),
                new SqlParameter("@where", SqlDbType.VarChar,1500),
                new SqlParameter("@otherwhere", SqlDbType.VarChar,1500)
            };
            parameters[0].Value = pagesize;
            parameters[1].Value = pageindex;
            parameters[2].Value = orderName;
            parameters[3].Value = orderType == 1 ? "desc" : "asc"; ;
            parameters[4].Value = strWhere;
            parameters[5].Value = otherwhere;

            using (SqlDataReader dr = SQLHelper.ExecuteReader(CommandType.StoredProcedure, "deliver_getlistWithState", parameters))
            {
                while (dr.Read())
                {
                    DeliverInfo info = new DeliverInfo();
                    info.DataId = HJConvert.ToInt32(dr["DataId"]);
                    info.CodeId = HJConvert.ToString(dr["CodeId"]);
                    info.Name = HJConvert.ToString(dr["Name"]);
                    info.Phone = HJConvert.ToString(dr["Phone"]);
                    info.Section = HJConvert.ToString(dr["Section"]);

                    DateTime lasttime = HJConvert.ToDateTime(dr["lasttime"]);
                    if ((DateTime.Now - lasttime).TotalMinutes < WMPT.Common.Constant.OffLineDoor)
                    {