public static string QuerySubscribeInfo(string subscribestart, string subscribeend, string declarationcode, string istrigger, string busitype, string busiunit, string ordercode,
                                                string cusno, string contract, string submitstart, string submitend, int pagesize, int lastnum)
        {
            string   sum  = "0";
            WGUserEn user = (WGUserEn)HttpContext.Current.Session["user"];

            if (user == null || user.GwyUserID <= 0)
            {
                return("");
            }
            DataTable infodt = SubscribeModel.getNewSubscribeInfo_Decl(subscribestart, subscribeend, declarationcode, istrigger, busitype, busiunit, ordercode, cusno, contract,
                                                                       submitstart, submitend, pagesize, lastnum, user.GwyUserID, out sum);

            //DataTable infodt = SubscribeModel.getNewSubscribeInfo_Decl(subscribestart, subscribeend, declarationcode, istrigger, busitype, busiunit, ordercode, cusno, contract,
            //    submitstart, submitend, pagesize, lastnum, 1124, out sum);
            if (infodt == null || infodt.Rows.Count == 0)
            {
                return("");
            }
            try
            {
                foreach (DataRow dr in infodt.Rows)
                {
                    if (string.IsNullOrEmpty(dr["transname"].ToString2()))
                    {
                        dr["transname"] = "";
                    }
                    if (string.IsNullOrEmpty(dr["tradename"].ToString2()))
                    {
                        dr["tradename"] = "";
                    }
                    if (string.IsNullOrEmpty(dr["status"].ToString2()))
                    {
                        dr["status"] = "";
                    }
                    if (string.IsNullOrEmpty(dr["customsstatus"].ToString2()))
                    {
                        dr["customsstatus"] = "";
                    }
                    dr["sum"] = sum;
                }
                IsoDateTimeConverter iso = new IsoDateTimeConverter();//序列化JSON对象时,日期的处理格式
                iso.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
                string json = JsonConvert.SerializeObject(infodt, iso);
                return(json);
            }
            catch (Exception e)
            {
                LogHelper.Write("MyBusiness_QueryData:" + e.Message);
                return("");
            }
        }
        public static string NewQuerySubscribeInfo()
        {
            WGUserEn user = (WGUserEn)HttpContext.Current.Session["user"];

            if (user == null || user.GwyUserID <= 0)
            {
                return("");
            }
            DataTable infodt = SubscribeModel.getNewSubscribeInfo_Decl(user.GwyUserID);

            //DataTable infodt = SubscribeModel.getNewSubscribeInfo_Decl(1124);

            if (infodt == null || infodt.Rows.Count == 0)
            {
                return("");
            }
            try
            {
                foreach (DataRow dr in infodt.Rows)
                {
                    if (string.IsNullOrEmpty(dr["transname"].ToString2()))
                    {
                        dr["transname"] = "";
                    }
                    if (string.IsNullOrEmpty(dr["tradename"].ToString2()))
                    {
                        dr["tradename"] = "";
                    }
                    if (string.IsNullOrEmpty(dr["status"].ToString2()))
                    {
                        dr["status"] = "";
                    }
                    if (string.IsNullOrEmpty(dr["customsstatus"].ToString2()))
                    {
                        dr["customsstatus"] = "";
                    }
                }
                IsoDateTimeConverter iso = new IsoDateTimeConverter();//序列化JSON对象时,日期的处理格式
                iso.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
                string json = JsonConvert.SerializeObject(infodt, iso);
                return(json);
            }
            catch (Exception e)
            {
                LogHelper.Write("MyBusiness_QueryData:" + e.Message);
                return("");
            }
        }