ERP/TradeManageNew/gp/gp_service.asmx.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using TradeModel;
using TradeData;
using NetLibrary.Data;
using System.Data;
using NetLibrary.ReportPrint;
using NetLibrary;

namespace TradeManageNew.gp
{
    /// <summary>
    /// gp_service 的摘要说明
    /// </summary>
    [WebService(Namespace = "http://tempuri.org/")]
    [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
    [System.ComponentModel.ToolboxItem(false)]
    // 若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务，请取消对下行的注释。
    [System.Web.Script.Services.ScriptService]
    public class gp_service : System.Web.Services.WebService
    {

        [WebMethod]
        public string HelloWorld()
        {
            return "Hello World";
        }

          #region 分页查询
        [WebMethod(EnableSession = true)]
        public JsonModel<List<GP_PriceMd>> GetListPrice(string code, string name, decimal? sprice, decimal? eprice,int tj, decimal? sprice2, decimal? eprice2, DateTime? StartDate, DateTime? StopDate, int off, int PageIndex, int PageSize, string Sort)
        {
          
            RefParameterCollection where = new RefParameterCollection();
            if(off==1)
                where.Add(new RefParameter("offdec", ">", 0, DbType.Decimal));
            if (off == 2)
                where.Add(new RefParameter("offdec", "=", 0, DbType.Decimal));
            if (off == 3)
                where.Add(new RefParameter("offdec", "<", 0, DbType.Decimal));
            if (string.IsNullOrEmpty(code) == false) where.Add(new RefParameter("a.code", "like", code, DbType.String));
            if (string.IsNullOrEmpty(name) == false) where.Add(new RefParameter("a.name", "like", name,DbType.String));
            if (sprice != null) where.Add(new RefParameter("a.dec3", ">=", sprice, System.Data.DbType.Decimal));
            if (eprice != null) where.Add(new RefParameter("a.dec3", "<=", eprice, System.Data.DbType.Decimal));
            if (sprice2 != null)
            {
                if(tj==1)
                    where.Add(new RefParameter("offdec", ">=", sprice2, System.Data.DbType.Decimal));
                if (tj == 2)
                    where.Add(new RefParameter("a.dec8", ">=", sprice2*100, System.Data.DbType.Decimal));
                if (tj == 3)
                    where.Add(new RefParameter("a.dec9", ">=", sprice2*10000, System.Data.DbType.Decimal));
            }
            if (eprice2 != null)
            {
                if (tj == 1)
                    where.Add(new RefParameter("offdec", "<=", eprice2, System.Data.DbType.Decimal));
                if (tj == 2)
                    where.Add(new RefParameter("a.dec8", "<=", eprice2 * 100, System.Data.DbType.Decimal));
                if (tj == 3)
                    where.Add(new RefParameter("a.dec9", "<=", eprice2 * 10000, System.Data.DbType.Decimal));
            }
            if (StartDate != null) where.Add(new RefParameter("dataDate", ">=", StartDate, System.Data.DbType.DateTime));
            if (StopDate != null) where.Add(new RefParameter("convert(varchar(10), dataDate, 120)", "<=", StopDate, System.Data.DbType.DateTime));
            JsonModel<List<GP_PriceMd>> resultModel = new JsonModel<List<GP_PriceMd>>();
            int RowCount = 0;
            resultModel.DataSource = DataNew.GetListPrice(where, PageIndex, PageSize, Sort, out RowCount);
            resultModel.RowCount = RowCount;
            return resultModel;
        }
        #endregion

    }
}