Estsh-Yiri/Estsh.Core.Services/Services/AirOvenService.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using Estsh.Web.Dal;
using Estsh.Web.Util;
using System.Collections;
using System.Data;


namespace Estsh.Core.Services
{
    public class AirOvenService
    {
        AirOvenDal dal = new AirOvenDal(RemotingProxyProvider._remotingProxy);


        /// <summary>
        /// 客户产线集合
        /// </summary>
        ///// <returns>数据集</returns>
        //public ArrayList GetCustPDLineName()
        //{
        //    return dal.GetCustPDLineName();
        //}


        /// <summary>
        /// 根据分页条件获取分页菜单数据
        /// </summary>
        /// <param name="PartMasterName"></param>
        /// <param name="pager"></param>
        /// <param name="direction"></param>
        /// <param name="sort"></param>
        /// <returns></returns>
        public Hashtable getShippingListByPage(String txtStartTime, String txtEndTime, String shipping_sn, Pager pager)
        {
            Hashtable result = new Hashtable();
            String strWhere = "1=1 ";

              //开始结束时间
            if (!string.IsNullOrEmpty(txtStartTime) && !string.IsNullOrEmpty(txtEndTime))
            {
                strWhere += "  AND 测试日期 +' '+ 测试日期   between  '" + txtStartTime + "' and  '" + txtEndTime + "'";
            }

            if (!string.IsNullOrEmpty(shipping_sn))
            {
                strWhere += " and 条码= '" + shipping_sn + "'";
            }


            //String orderBy = "";
            //if (sort != null && !"".Equals(sort.Trim()))
            //{
            //    orderBy += sort + " " + direction;
            //}
            //else
            //{
            //    orderBy += " f.cust_pdline_name " + direction;
            //}

            result = dal.getShippingListByPage(pager, strWhere);
              return result;
        }


        /// <summary>
        /// 根据分页条件获取分页菜单数据(导出时使用)
        /// </summary>
        /// <param name="ModelPartName"></param>
        /// <param name="pager"></param>
        /// <param name="direction"></param>
        /// <param name="sort"></param>
        /// <returns></returns>
        public DataTable getShippingExport(string txtStartTime, string txtEndTime, String 条码, Pager pager)
        {
            DataTable result = null;
            string strWhere = " 1=1 ";
            //开始结束时间
            if (!string.IsNullOrEmpty(txtStartTime) && !string.IsNullOrEmpty(txtEndTime))
            {
                strWhere += " AND 测试日期 +' '+ 测试日期   between  '" + txtStartTime + "' and  '" + txtEndTime + "'";
            }

            if (!string.IsNullOrEmpty(条码))
            {
                strWhere += " and 条码= " + 条码 + "'";
            }

            result = dal.getShippingExport(pager.pageSize, pager.pageNo, strWhere);
            return result;
        }
    }


}