//连接视图名称，视图在数据库写好 <%@ WebHandler Language="C#" Class="GetwmsReport" %>using System;using System.Drawing;using System.Data;using System.Data.SqlClient;using System.Collections.Generic;using System.Web;using System.Text;using CloudSaaS.DAL;using CloudSaaS.Model;using Newtonsoft.Json;using CloudSaaS.Common;using CloudSaaS.DB.Handler;using Newtonsoft.Json.Linq;public class GetwmsReport : IHttpHandler{    public void ProcessRequest(HttpContext context)    {        var json = string.Empty;          var req = context.Request["req"].Trim();        string tenantId = HttpContext.Current.Request.Cookies["tenantID"].Value;        switch(req){            case "GetDeliverSum":            json = GetDeliverSum(tenantId, context);//当日发货汇总            break;            case "GetDeliverDetail":            json = GetDeliverDetail(tenantId, context);//当日发货明细            break;            case "GetReceiptSum":            json = GetReceiptSum(tenantId, context);//当日收获汇总            break;            case "GetReceiptDetail":            json = GetReceiptDetail(tenantId, context);//当日收货明细            break;                  }            context.Response.ContentType = "text/json";        context.Response.Write(json);        context.Response.End();        context.Response.Close();    }/*--当日收货明细：UV_SYSWMSREPORT_1   --当日发货明细：UV_SYSWMSREPORT_2    --当日收货汇总：UV_SYSWMSREPORT_3    --当日发货汇总：UV_SYSWMSREPORT_4*/   /// 
    ///当日发货汇总    /// 
    ///     /// 
     
      当日发货汇总
         public string GetDeliverSum(string tenantId, HttpContext context)    {        DataTable dt = new DataTable();        StringBuilder strSql = new StringBuilder();        string hetong = context.Request["hetong"]; //摘要        string product = context.Request["product"]; //文件名称        string project = context.Request["project"];        strSql.Append("select * from UV_SYSWMSREPORT_4 where 1=1 ");              DataSet ds = CloudSaaS.DB.Handler.CloudDB.GetHandler(tenantId).Query(strSql.ToString());        if (ds.Tables.Count > 0)        {            dt = ds.Tables[0];           // obj.code = "200";          //  obj.msg = "操作成功!";        }        return Newtonsoft.Json.JsonConvert.SerializeObject(dt);    }       /// 
    ///当日发货明细    /// 
    ///     /// 
     
      当日发货明细
         public string GetDeliverDetail(string tenantId, HttpContext context)    {        DataTable dt = new DataTable();        StringBuilder strSql = new StringBuilder();        string hetong = context.Request["hetong"]; //摘要        string product = context.Request["product"]; //文件名称        string project = context.Request["project"];        strSql.Append("select * from UV_SYSWMSREPORT_2 where 1=1 ");              DataSet ds = CloudSaaS.DB.Handler.CloudDB.GetHandler(tenantId).Query(strSql.ToString());        if (ds.Tables.Count > 0)        {            dt = ds.Tables[0];           // obj.code = "200";            //obj.msg = "操作成功!";        }        return Newtonsoft.Json.JsonConvert.SerializeObject(dt);    }   /// 
    ///当日收货汇总    /// 
    ///     /// 
     
      当日收货汇总
         public string GetReceiptSum(string tenantId, HttpContext context)    {        DataTable dt = new DataTable();        StringBuilder strSql = new StringBuilder();        string hetong = context.Request["hetong"]; //摘要        string product = context.Request["product"]; //文件名称        string project = context.Request["project"];        strSql.Append("select * from UV_SYSWMSREPORT_3 where 1=1 ");              DataSet ds = CloudSaaS.DB.Handler.CloudDB.GetHandler(tenantId).Query(strSql.ToString());        if (ds.Tables.Count > 0)        {            dt = ds.Tables[0];           // obj.code = "200";           // obj.msg = "操作成功!";        }        return Newtonsoft.Json.JsonConvert.SerializeObject(dt);    }   /// 
    ///当日收货明细    /// 
    ///     /// 
     
      当日收货明细
         public string GetReceiptDetail(string tenantId, HttpContext context)    {        dynamic obj = new System.Dynamic.ExpandoObject();        obj.code = "1000";        obj.msg="提交时出现错误!";        try {          // DataTable dt = new DataTable();         //  dalSYSWMSInputBillHead dal = new dalSYSWMSInputBillHead(tenantId);            StringBuilder strSql = new StringBuilder();            string hetong = context.Request["hetong"]; //摘要            string product = context.Request["product"]; //文件名称            string project = context.Request["project"];            strSql.Append("select * from UV_SYSWMSREPORT_1 where 1=1 ");           /* if (!string.IsNullOrEmpty(hetong))           {                strSql.AppendFormat(" and 合同编号 like '%{0}%'",hetong);            }            // strSql.AppendFormat(" order by 序号 desc");            */         DataSet ds = CloudSaaS.DB.Handler.CloudDB.GetHandler(tenantId).Query(strSql.ToString());            if (ds.Tables.Count > 0)            {                obj.data = ds.Tables[0];                obj.code = "200";                obj.msg = "操作成功!";            }        }        catch (Exception ex)        {            string strMsg = string.Format("提交时出现错误{0}", ex.Message);            obj.code = "1000";            obj.msg = strMsg;        }       // return Newtonsoft.Json.JsonConvert.SerializeObject(obj);        return JsonConvert.SerializeObject(obj);    }    public bool IsReusable    {        get        {            return false;        }    }}