D7QUANTAI/DSWebMobile/Handler/Consignation.ashx.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Text.RegularExpressions;
using System.Web;
using DSWeb.MvcShipping.DAL.MsOpSeaeDAL;
using DSWeb.MvcShipping.Models.MsOpSeae;
using DSWebComponent;
using DSWebMobileService;
using Newtonsoft.Json;
using DSWebMobileService.Common;

namespace DSWebMobile.Handler
{
    /// <summary>
    /// Consignation 的摘要说明
    /// </summary>
    public class Consignation : IHttpHandler, System.Web.SessionState.IRequiresSessionState
    {

        public void ProcessRequest(HttpContext context)
        {
            string action = context.Request.QueryString["action"].ToString();
            switch (action)
            {
                case "0":
                    GetDataListByUser(context);
                    break;
                case "1":
                    GetDataInfo(context);
                    break;
            }
        }

        private void GetDataInfo(HttpContext context)
        {
            string relBSNO = "";

            string bsno = Encrypt.DesDecrypt("#7c&e@63", context.Request.QueryString["b"].ToString());

            string pattern = "\0";
            string replacement = "";

            Regex rgx = new Regex(pattern);
            relBSNO = rgx.Replace(bsno, replacement);
            pattern = "\t";
            Regex rgx2 = new Regex(pattern);
            relBSNO = rgx2.Replace(relBSNO, replacement);

            MsOpSeae head = MsOpSeaeDAL.GetData("BSNO='" + relBSNO + "'");
            string BSNO = head.BSNO;
            string BSSTATUSREF = head.BSSTATUSREF;                 //业务锁定
            string FEESTATUSREF = head.FEESTATUSREF;                //费用锁定
            string ACCDATE = head.ACCDATE;               //会计期间
            string BLTYPE = head.BLTYPE;                //装运方式
            string CUSTOMERNAME = head.CUSTOMERNAME;          //委托单位
            string BSSOURCE = head.BSSOURCE;              //业务来源
            string BSSOURCEDETAIL = head.BSSOURCEDETAIL;        //来源明细
            string SALEDEPT = head.SALEDEPT;              //所属部门
            string OP = head.OP;                    //操作员
            string SALE = head.SALE;                  //揽货人
            string DOC = head.DOC;                   //单证
            string CUSTSERVICE = head.CUSTSERVICE;           //客服员
            string CUSTNO = head.CUSTNO;                //委托编号
            string ORDERNO = head.ORDERNO;               //订舱编号
            string MBLNO = head.MBLNO;                 //主提单号
            string HBLNO = head.HBLNO;                 //分提单号
            //
            bool ISFUMIGATION = head.ISFUMIGATION;          //熏蒸:服务项目
            bool ISSTORAGE = head.ISSTORAGE;             //仓储:服务项目
            bool ISLAND = head.ISLAND;                //陆运:服务项目
            bool ISCUSTOMS = head.ISCUSTOMS;             //报关:服务项目
            bool ISINSPECTION = head.ISINSPECTION;          //报检:服务项目
            bool ISBOOKING = head.ISBOOKING;             //订舱:服务项目
            bool ISAGENT = head.ISAGENT;               //使用代理:服务项目
            bool ISHBLNO = head.ISHBLNO;               //分单签单:服务项目
            //
            string STLNAME = head.STLNAME;               //结算方式
            string STLDATE = head.STLDATE;               //结算时间
            string CONTRACTNO = head.CONTRACTNO;            //服务合同号
            string OPERATORCODE = head.OPERATORCODE;          //客户操作代码
            string OPERATOR = head.OP;              //客户操作名称
            string FINANCIALSTAFFCODE = head.FINANCIALSTAFFCODE;    //客户财务代码
            string FINANCIALSTAFF = head.FINANCIALSTAFF;        //客户财务名称
            string OPERATOREMAIL = head.OPERATOREMAIL;         //操作电子邮箱
            string OPERATORTEL = head.OPERATORTEL;           //操作电话
            string OPERATORFAX = head.OPERATORFAX;           //操作传真
            string FINANCIALSTAFFEMAIL = head.FINANCIALSTAFFEMAIL;   //财务电子邮箱
            string FINANCIALSTAFFTEL = head.FINANCIALSTAFFTEL;     //财务电话
            string FINANCIALSTAFFFAX = head.FINANCIALSTAFFFAX;     //财务传真

            //货物
            string MANIFESTSTATUSREF = head.MANIFESTSTATUS;     //舱单状态
            string OPSTATUS = head.OPSTATUS;              //费用状态
            string BSDATE = head.BSDATE.ToString();                //接单日期
            if (BSDATE.IndexOf("1900") == -1)
            {
                BSDATE = BSDATE.Substring(0, BSDATE.IndexOf(" "));
                BSDATE = BSDATE.Replace("/", "-");
            }
            else 
            {
                BSDATE = "";
            }

            string INPUTBY = head.INPUTBY;               //录入人
            string CORPID = head.CORPID;                //分公司代码
            string VESSEL = head.VESSEL;                //船名
            string VOYNO = head.VOYNO;                 //航次
            string ETD = head.ETD;                   //到港日期
            //ETD = ETD.Substring(0, ETD.IndexOf(" "));
            //ETD = ETD.Replace("/", "-");

            string PORTLOAD = head.PORTLOAD;              //装货港
            string PORTDISCHARGE = head.PORTDISCHARGE;         //卸货港
            string CNTRNO = head.CNTRTOTAL;                //集装箱大写
            string TEU = head.TEU.ToString();                   //箱TEU
            string CNTRTOTAL = head.CNTRTOTAL;             //集装箱全部内容
            string GOODSNAME = head.GOODSNAME;             //品名
            string KGS = head.KGS.ToString();                   //毛重
            KGS = KGS.Substring(0, KGS.Length - 2);

            string CUSTOMSER = head.CUSTOMSER;             //报关行
            string PKGS = head.PKGS.ToString();                  //件数
            string KINDPKGS = head.KINDPKGS;              //件数包装
            string REMARK = head.REMARK;                //备注
            REMARK = REMARK.Replace("\n", "     ");
            REMARK = REMARK.Replace("/", "-");
            REMARK = REMARK.Replace("\"", "'");

            string YARD = head.YARD;                  //场站 靠泊码头
            string CBM = head.CBM.ToString();                   //立方数/尺码
            CBM = CBM.Substring(0, CBM.Length - 2);

            string SHIPAGENCY = head.SHIPAGENCY;                //船代

            //CNTRSEALNO = head.CNTRSEALNO;            //箱号封号
            string CARRIER = head.CARRIER;               //船公司
            string TRUCKER = head.TRUCKER;               //承运车队
            string CUSTOMSNUM = head.CUSTOMSNUM.ToString();            //报关票数
            string NOPKGS = head.NOPKGS;                //件数包装
            string GROSSWEIGHT = head.GROSSWEIGHT;           //货物毛重
            string MEASUREMENT = head.MEASUREMENT;           //货物尺码
            string DESCRIPTION = head.DESCRIPTION;           //货物描述
            DESCRIPTION = DESCRIPTION.Replace("\n", "     ");
            DESCRIPTION = DESCRIPTION.Replace("/", "-");
            DESCRIPTION = DESCRIPTION.Replace("\"", "'");

            string TOTALNO = head.TOTALNO;               //件数大写
            string TRANSNO = head.TRANSNO;               //运单号
            string SHIPPERID = head.SHIPPERID;             //发货人
            string CONSIGNEEID = head.CONSIGNEEID;           //收货人
            string NOTIFYPARTYID = head.NOTIFYPARTYID;         //通知人
            string SHIPPER = head.SHIPPER;               //发货人内容
            SHIPPER = SHIPPER.Replace("\n", "     ");
            SHIPPER = SHIPPER.Replace("/", "-");
            SHIPPER = SHIPPER.Replace("\"", "'");

            string CONSIGNEE = head.CONSIGNEE;             //收货人内容
            CONSIGNEE = CONSIGNEE.Replace("\n", "     ");
            CONSIGNEE = CONSIGNEE.Replace("/", "-");
            CONSIGNEE = CONSIGNEE.Replace("\"", "'");

            string NOTIFYPARTY = head.NOTIFYPARTY;           //通知人内容
            NOTIFYPARTY = NOTIFYPARTY.Replace("\n", "     ");
            NOTIFYPARTY = NOTIFYPARTY.Replace("/", "-");
            NOTIFYPARTY = NOTIFYPARTY.Replace("\"", "'");

            string AGENTID = head.AGENTID;               //国外代理
            string AGENT = head.AGENT;                 //国外代理内容
            AGENT = AGENT.Replace("\n", "     ");
            AGENT = AGENT.Replace("/", "-");
            AGENT = AGENT.Replace("\"", "'");

            //其它
            string CLOSINGDATE = head.CLOSINGDATE;           //截港日期
            if (CLOSINGDATE != null && CLOSINGDATE != "")
            {
                if (CLOSINGDATE.IndexOf("1900") == -1)
                {
                    CLOSINGDATE = CLOSINGDATE.Substring(0, CLOSINGDATE.IndexOf(" "));
                    CLOSINGDATE = CLOSINGDATE.Replace("/", "-");
                }
                else
                {
                    CLOSINGDATE = "";
                }
            }

            string ETA = head.ETA;                   //预抵日期
            if (ETA != null && ETA != "")
            {
                if (ETA.IndexOf("1900") == -1)
                {
                    //ETA = ETA.Substring(0, ETA.IndexOf(" "));
                    //ETA = ETA.Replace("/", "-");
                }
                else
                {
                    ETA = "";
                }
            }

            string PlACERECEIPT = head.PLACERECEIPT;          //收货地
            string PLACEDELIVERY = head.PLACEDELIVERY;         //交货地
            string DESTINATION = head.DESTINATION;           //目的地
            string NOBILL = head.NOBILL;                //提单份数
            string ISSUETYPE = head.ISSUETYPE;             //签单方式
            string ISSUEDATE = head.ISSUEDATE;             //签单日期
            if (ISSUEDATE != null && ISSUEDATE != "")
            {
                if (ISSUEDATE.IndexOf("1900") == -1)
                {
                    //ISSUEDATE = ISSUEDATE.Substring(0, ISSUEDATE.IndexOf(" "));
                    //ISSUEDATE = ISSUEDATE.Replace("/", "-");
                }
                else
                {
                    ISSUEDATE = "";
                }
            }

            string ISSUEPLACE = head.ISSUEPLACE;            //签单地点
            string BLFRT = head.BLFRT;                 //付费方式
            string PREPARDAT = head.PREPARDAT;             //预付地点
            string PAYABLEAT = head.PAYABLEAT;             //到付地点
            string SERVICE = head.SERVICE;               //运输条款
            string MARKS = head.MARKS;                 //唛头
            MARKS = MARKS.Replace("\n", "     ");
            MARKS = MARKS.Replace("/", "-");
            MARKS = MARKS.Replace("\"", "'");

            string LANE = head.LANE;                  //航线
            string FORWARDER = head.FORWARDER;             //订舱公司
            string INVNO = head.INVNO;                 //发票号
            string CARGOID = head.CARGOID;               //货物标识
            string DCLASS = head.DCLASS;                //危险品分类/等级
            string DUNNO = head.DUNNO;                 //危险品编号
            string REEFERF = head.REEFERF;               //冷藏通风量
            string TEMPID = head.TEMPID;                //温度单位
            string TEMPSET = head.TEMPSET;               //设置温度
            string PACKINGTYPE = head.PACKINGTYPE;           //装箱类型
            string WAREHOUSE = head.WAREHOUSE;             //仓库
            string CLOSEDOCDATE = head.CLOSEDOCDATE;          //截单日期
            if (CLOSEDOCDATE != null && CLOSEDOCDATE != "")
            {
                if (CLOSEDOCDATE.IndexOf("1900") == -1)
                {
                    CLOSEDOCDATE = CLOSEDOCDATE.Substring(0, CLOSEDOCDATE.IndexOf(" "));
                    CLOSEDOCDATE = CLOSEDOCDATE.Replace("/", "-");
                }
                else
                {
                    CLOSEDOCDATE = "";
                }
            }

            string INTOPORTDATE = head.INTOPORTDATE;          //集港日期
            if (INTOPORTDATE != null && INTOPORTDATE != "")
            {
                if (INTOPORTDATE.IndexOf("1900") == -1)
                {
                    INTOPORTDATE = INTOPORTDATE.Substring(0, INTOPORTDATE.IndexOf(" "));
                    INTOPORTDATE = INTOPORTDATE.Replace("/", "-");
                }
                else
                {
                    INTOPORTDATE = "";
                }
            }

            string MBLFRT = head.MBLFRT;                //MBL付费方式
            string SOURCECODE = head.SOURCECODE;            //集装箱（器）来源代码
            string DPAGE = head.DPAGE;                 //危险品页号
            string DLABEL = head.DLABEL;                //危险品标签
            string LINKMAN = head.LINKMAN;               //危险品联系人
            string VESSELID = head.VESSELID;              //船舶呼号
            string ISSUEPLACEID = head.ISSUEPLACEID;          //提单签发地代码                    
            string HSCODE = head.HSCODE;                //HS编码  

            //var json = JsonConvert.SerializeObject(head);
            string json = "";
            json += "{";
            json += "\"BSNO\" : \"" + BSNO + "\", ";                  //业务编号
            json += "\"BSSTATUSREF\" : \"" + BSSTATUSREF + "\", ";                  //业务锁定
            json += "\"FEESTATUSREF\" : \"" + FEESTATUSREF + "\", ";                 //费用锁定
            json += "\"ACCDATE\" : \"" + ACCDATE + "\", ";                //会计期间
            json += "\"BLTYPE\" : \"" + BLTYPE + "\", ";                 //装运方式
            json += "\"CUSTOMERNAME\" : \"" + CUSTOMERNAME + "\", ";           //委托单位
            json += "\"BSSOURCE\" : \"" + BSSOURCE + "\", ";               //业务来源
            json += "\"BSSOURCEDETAIL\" : \"" + BSSOURCEDETAIL + "\", ";         //来源明细
            json += "\"SALEDEPT\" : \"" + SALEDEPT + "\", ";               //所属部门
            json += "\"OP\" : \"" + OP + "\", ";                     //操作员
            json += "\"SALE\" : \"" + SALE + "\", ";                   //揽货人
            json += "\"DOC\" : \"" + DOC + "\", ";                    //单证
            json += "\"CUSTSERVICE\" : \"" + CUSTSERVICE + "\", ";            //客服员
            json += "\"CUSTNO\" : \"" + CUSTNO + "\", ";                 //委托编号
            json += "\"ORDERNO\" : \"" + ORDERNO + "\", ";                //订舱编号
            json += "\"MBLNO\" : \"" + MBLNO + "\", ";                  //主提单号
            json += "\"HBLNO\" : \"" + HBLNO + "\", ";                  //分提单号

            json += "\"ISFUMIGATION\" : \"" + ISFUMIGATION + "\", ";           //熏蒸: \"" + 服务项目
            json += "\"ISSTORAGE\" : \"" + ISSTORAGE + "\", ";              //仓储: \"" + 服务项目
            json += "\"ISLAND\" : \"" + ISLAND + "\", ";                 //陆运: \"" + 服务项目
            json += "\"ISCUSTOMS\" : \"" + ISCUSTOMS + "\", ";              //报关: \"" + 服务项目
            json += "\"ISINSPECTION\" : \"" + ISINSPECTION + "\", ";           //报检: \"" + 服务项目
            json += "\"ISBOOKING\" : \"" + ISBOOKING + "\", ";              //订舱: \"" + 服务项目
            json += "\"ISAGENT\" : \"" + ISAGENT + "\", ";                //使用代理: \"" + 服务项目
            json += "\"ISHBLNO\" : \"" + ISHBLNO + "\", ";                //分单签单: \"" + 服务项目
            json += "\"STLNAME\" : \"" + STLNAME + "\", ";                //结算方式
            json += "\"STLDATE\" : \"" + STLDATE + "\", ";                //结算时间
            json += "\"CONTRACTNO\" : \"" + CONTRACTNO + "\", ";             //服务合同号
            json += "\"OPERATORCODE\" : \"" + OPERATORCODE + "\", ";           //客户操作代码
            json += "\"OPERATOR\" : \"" + OPERATOR + "\", ";               //客户操作名称
            json += "\"FINANCIALSTAFFCODE\" : \"" + FINANCIALSTAFFCODE + "\", ";     //客户财务代码
            json += "\"FINANCIALSTAFF\" : \"" + FINANCIALSTAFF + "\", ";         //客户财务名称
            json += "\"OPERATOREMAIL\" : \"" + OPERATOREMAIL + "\", ";          //操作电子邮箱
            json += "\"OPERATORTEL\" : \"" + OPERATORTEL + "\", ";            //操作电话
            json += "\"OPERATORFAX\" : \"" + OPERATORFAX + "\", ";            //操作传真
            json += "\"FINANCIALSTAFFEMAIL\" : \"" + FINANCIALSTAFFEMAIL + "\", ";    //财务电子邮箱
            json += "\"FINANCIALSTAFFTEL\" : \"" + FINANCIALSTAFFTEL + "\", ";      //财务电话
            json += "\"FINANCIALSTAFFFAX\" : \"" + FINANCIALSTAFFFAX + "\", ";      //财务传真

            json += "\"MANIFESTSTATUSREF\" : \"" + MANIFESTSTATUSREF + "\", ";      //舱单状态
            json += "\"OPSTATUS\" : \"" + OPSTATUS + "\", ";               //费用状态
            json += "\"BSDATE\" : \"" + BSDATE + "\", ";                 //接单日期

            json += "\"INPUTBY\" : \"" + INPUTBY + "\", ";                //录入人
            json += "\"CORPID\" : \"" + CORPID + "\", ";                 //分公司代码
            json += "\"VESSEL\" : \"" + VESSEL + "\", ";                 //船名
            json += "\"VOYNO\" : \"" + VOYNO + "\", ";                  //航次
            json += "\"ETD\" : \"" + ETD + "\", ";                    //到港日期

            json += "\"PORTLOAD\" : \"" + PORTLOAD + "\", ";               //装货港
            json += "\"PORTDISCHARGE\" : \"" + PORTDISCHARGE + "\", ";          //卸货港
            json += "\"CNTRNO\" : \"" + CNTRNO + "\", ";                 //集装箱大写
            json += "\"TEU\" : \"" + TEU + "\", ";                    //箱TEU
            json += "\"CNTRTOTAL\" : \"" + CNTRTOTAL + "\", ";              //集装箱全部内容
            json += "\"GOODSNAME\" : \"" + GOODSNAME + "\", ";              //品名
            json += "\"KGS\" : \"" + KGS + "\", ";                    //毛重
            json += "\"CUSTOMSER\" : \"" + CUSTOMSER + "\", ";              //报关行
            json += "\"PKGS\" : \"" + PKGS + "\", ";                   //件数
            json += "\"KINDPKGS\" : \"" + KINDPKGS + "\", ";               //件数包装
            json += "\"REMARK\" : \"" + REMARK + "\", ";                 //备注
            json += "\"YARD\" : \"" + YARD + "\", ";                   //场站 靠泊码头
            json += "\"CBM\" : \"" + CBM + "\", ";                    //立方数/尺码
            json += "\"SHIPAGENCY\" : \"" + SHIPAGENCY + "\", ";              //船代
            json += "\"CARRIER\" : \"" + CARRIER + "\", ";                //船公司
            json += "\"TRUCKER\" : \"" + TRUCKER + "\", ";                //承运车队
            json += "\"CUSTOMSNUM\" : \"" + CUSTOMSNUM + "\", ";             //报关票数
            json += "\"NOPKGS\" : \"" + NOPKGS + "\", ";                 //件数包装
            json += "\"GROSSWEIGHT\" : \"" + GROSSWEIGHT + "\", ";            //货物毛重
            json += "\"MEASUREMENT\" : \"" + MEASUREMENT + "\", ";            //货物尺码
            json += "\"DESCRIPTION\" : \"" + DESCRIPTION + "\", ";            //货物描述
            json += "\"TOTALNO\" : \"" + TOTALNO + "\", ";                //件数大写
            json += "\"TRANSNO\" : \"" + TRANSNO + "\", ";                //运单号
            json += "\"SHIPPERID\" : \"" + SHIPPERID + "\", ";              //发货人
            json += "\"CONSIGNEEID\" : \"" + CONSIGNEEID + "\", ";            //收货人
            json += "\"NOTIFYPARTYID\" : \"" + NOTIFYPARTYID + "\", ";          //通知人
            json += "\"SHIPPER\" : \"" + SHIPPER + "\", ";                //发货人内容
            json += "\"CONSIGNEE\" : \"" + CONSIGNEE + "\", ";              //收货人内容
            json += "\"NOTIFYPARTY\" : \"" + NOTIFYPARTY + "\", ";            //通知人内容
            json += "\"AGENTID\" : \"" + AGENTID + "\", ";                //国外代理
            json += "\"AGENT\" : \"\", ";                  //" + AGENT + "国外代理内容

            json += "\"CLOSINGDATE\" : \"" + CLOSINGDATE + "\", ";            //截港日期

            json += "\"ETA\" : \"" + ETA + "\", ";                    //预抵日期

            json += "\"PlACERECEIPT\" : \"" + PlACERECEIPT + "\", ";           //收货地
            json += "\"PLACEDELIVERY\" : \"" + PLACEDELIVERY + "\", ";          //交货地
            json += "\"DESTINATION\" : \"" + DESTINATION + "\", ";            //目的地
            json += "\"NOBILL\" : \"" + NOBILL + "\", ";                 //提单份数
            json += "\"ISSUETYPE\" : \"" + ISSUETYPE + "\", ";              //签单方式
            json += "\"ISSUEDATE\" : \"" + ISSUEDATE + "\", ";              //签单日期

            json += "\"ISSUEPLACE\" : \"" + ISSUEPLACE + "\", ";             //签单地点
            json += "\"BLFRT\" : \"" + BLFRT + "\", ";                  //付费方式
            json += "\"PREPARDAT\" : \"" + PREPARDAT + "\", ";              //预付地点
            json += "\"PAYABLEAT\" : \"" + PAYABLEAT + "\", ";              //到付地点
            json += "\"SERVICE\" : \"" + SERVICE + "\", ";                //运输条款
            json += "\"MARKS\" : \"" + MARKS + "\", ";                  //唛头
            json += "\"LANE\" : \"" + LANE + "\", ";                   //航线
            json += "\"FORWARDER\" : \"" + FORWARDER + "\", ";              //订舱公司
            json += "\"INVNO\" : \"" + INVNO + "\", ";                  //发票号
            json += "\"CARGOID\" : \"" + CARGOID + "\", ";                //货物标识
            json += "\"DCLASS\" : \"" + DCLASS + "\", ";                 //危险品分类/等级
            json += "\"DUNNO\" : \"" + DUNNO + "\", ";                  //危险品编号
            json += "\"REEFERF\" : \"" + REEFERF + "\", ";                //冷藏通风量
            json += "\"TEMPID\" : \"" + TEMPID + "\", ";                 //温度单位
            json += "\"TEMPSET\" : \"" + TEMPSET + "\", ";                //设置温度
            json += "\"PACKINGTYPE\" : \"" + PACKINGTYPE + "\", ";            //装箱类型
            json += "\"WAREHOUSE\" : \"" + WAREHOUSE + "\", ";              //仓库
            json += "\"CLOSEDOCDATE\" : \"" + CLOSEDOCDATE + "\", ";           //截单日期

            json += "\"INTOPORTDATE\" : \"" + INTOPORTDATE + "\", ";           //集港日期

            json += "\"MBLFRT\" : \"" + MBLFRT + "\", ";                 //MBL付费方式
            json += "\"SOURCECODE\" : \"" + SOURCECODE + "\", ";             //集装箱（器）来源代码
            json += "\"DPAGE\" : \"" + DPAGE + "\", ";                  //危险品页号
            json += "\"DLABEL\" : \"" + DLABEL + "\", ";                 //危险品标签
            json += "\"LINKMAN\" : \"" + LINKMAN + "\", ";                //危险品联系人
            json += "\"VESSELID\" : \"" + VESSELID + "\", ";               //船舶呼号
            json += "\"ISSUEPLACEID\" : \"" + ISSUEPLACEID + "\", ";           //提单签发地代码                    
            json += "\"HSCODE\" : \"" + HSCODE + "\" ";                 //HS编码  /**/
            json += "}";
            string result = "[" + json + "]";
            //string result = "[{\" BSNO \":\"111\"}]";
            context.Response.ContentType = "text/plain";
            context.Response.Write(result.ToString());
            context.Response.End();
        }

        private void GetDataListByUser(HttpContext context)
        {
            string relStrCondition = "";
            string relETDFromDate = "";
            string relETDToDate = "";
            string relAccFromDate = "";
            string relAccToDate = "";

            string aaa = context.Request.Form["ef"].ToString();
            string strCondition = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["s"].ToString());
            string etdFromDate = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["ef"].ToString());
            string etdToDate = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["et"].ToString());
            string accFromDate = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["af"].ToString());
            string accToDate = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["at"].ToString());

            string pattern = "\0";
            string replacement = "";

            int start = int.Parse(context.Request.QueryString["t"].ToString());
            int limit = int.Parse(context.Request.QueryString["l"].ToString());

            Regex rgx = new Regex(pattern);
            relStrCondition = rgx.Replace(strCondition, replacement);
            relETDFromDate = rgx.Replace(etdFromDate, replacement);
            relETDToDate = rgx.Replace(etdToDate, replacement);
            relAccFromDate = rgx.Replace(accFromDate, replacement);
            relAccToDate = rgx.Replace(accToDate, replacement);
            pattern = "\t";
            Regex rgx2 = new Regex(pattern);
            relStrCondition = rgx2.Replace(relStrCondition, replacement);
            relETDFromDate = rgx.Replace(relETDFromDate, replacement);
            relETDToDate = rgx.Replace(relETDToDate, replacement);
            relAccFromDate = rgx.Replace(relAccFromDate, replacement);
            relAccToDate = rgx.Replace(relAccToDate, replacement);

            if (strCondition != "")
            {
                if (relStrCondition[0] == ',') { relStrCondition = relStrCondition.Substring(1, relStrCondition.Length - 1); }
            }

            if (relStrCondition != "" && relETDFromDate != "")
            {
                relStrCondition += " and ETD>='" + relETDFromDate + " 00:00:00'";
            }
            else if (relStrCondition != "" && relETDFromDate == "") 
            {
                //relStrCondition += " and B.ETD>='" + DateTime.Today.Year.ToString() + "-" + DateTime.Today.Month.ToString() + "-01 00:00:00'";
            }
            else if (relStrCondition == "" && relETDFromDate != "")
            {
                relStrCondition += " ETD>='" + relETDFromDate + " 00:00:00'";
            }
            else if (relStrCondition == "" && relETDFromDate == "") 
            {
                relStrCondition += " ETD>='" + DateTime.Today.Year.ToString() + "-" + DateTime.Today.Month.ToString() + "-01 00:00:00'";
            }
            if (relETDFromDate != "" && relETDToDate != "") { relStrCondition += " and ETD<='" + relETDToDate + " 23:59:59'"; }
            else if (relStrCondition.IndexOf("ETD") != -1 && relETDToDate == "") 
            {
                if (DateTime.Today.Month.ToString() == "01" || DateTime.Today.Month.ToString() == "03" || DateTime.Today.Month.ToString() == "05" || DateTime.Today.Month.ToString() == "07" || DateTime.Today.Month.ToString() == "08" || DateTime.Today.Month.ToString() == "10" || DateTime.Today.Month.ToString() == "12") { relStrCondition += " and ETD<='" + DateTime.Today.Year.ToString() + "-" + DateTime.Today.Month.ToString() + "-31 23:59:59'"; }
                else if (DateTime.Today.Month.ToString() == "04" || DateTime.Today.Month.ToString() == "06" || DateTime.Today.Month.ToString() == "09" || DateTime.Today.Month.ToString() == "11") { relStrCondition += " and ETD<='" + DateTime.Today.Year.ToString() + "-" + DateTime.Today.Month.ToString() + "-30 23:59:59'"; }
                else if (DateTime.Today.Month.ToString() == "02") { relStrCondition += " and ETD<='" + DateTime.Today.Year.ToString() + "-" + DateTime.Today.Month.ToString() + "-29 23:59:59'"; }
            }
            if (relStrCondition != "" && relAccFromDate != "") { relStrCondition += " and ACCDATE>='" + relAccFromDate.Substring(0, 7) + "'"; }
            else if (relStrCondition == "" && relAccFromDate != "") { relStrCondition += " ACCDATE>='" + relAccFromDate.Substring(0, 7) + "'"; }
            if (relAccToDate != "") { relStrCondition += " and ACCDATE<='" + relAccToDate.Substring(0,7) + "'"; }

            var dataList = DSWebMobileService.MsOpSeaeServer.GetDataList(relStrCondition, SessionUtil.Session["USERID"].ToString(), SessionUtil.Session["SHOWNAME"].ToString(), SessionUtil.Session["COMPANYID"].ToString(), "", "true");
            //var list = dataList.Skip(start).Take(limit);
            string json = JsonConvert.SerializeObject(dataList);

            StringBuilder sb = new StringBuilder();

            context.Response.ContentType = "text/plain";
            context.Response.Write(json);
            context.Response.End();
        }


        public bool IsReusable
        {
            get
            {
                return false;
            }
        }
    }
}