Medical/Mobile/getcachedata.ashx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Data;
using System.IO;
using System.Linq;
using System.Text;
using System.Text.RegularExpressions;
using System.Web;


namespace WebApplication.Mobile
{
    /// <summary>
    /// getcachedata 的摘要说明
    /// </summary>
    public class getcachedata : IHttpHandler
    {

        public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType = "text/plain";
            if (context.Request["labelid"] != null && context.Request["currentsize"] != null)
            {
                Model.Cache.GZXX_Label model = new Model.Cache.GZXX_Label();
                BLL.Cache.GZXX_Label bll = new BLL.Cache.GZXX_Label();
                model = bll.GetLabelInfo(int.Parse(context.Request["labelid"].ToString().Split('_')[0]));
                //string sql = "select * from " + model.ModelTable + " where classid = " + model.ModelClass + " " + model.SqlType + " order by " + model.SqlOrderBy;
                BLL.Models.GZXX_Model mll = new BLL.Models.GZXX_Model();
                DataTable dt = new DataTable();
                int count = 0;
                if (model.LabelType == 3)
                {
                    dt = mll.GetDataTable("*,(case when dateadd(day,3,AddDate) > getdate() then 'is_new' else '' end) as isnew", model.ModelTable, " where verify = 1 and ((select [ParentClassID] from GZXX_Class where GZXX_Class.ClassID =" + model.ModelTable + ".ClassID) = " + model.ModelClass + " or classid = " + model.ModelClass + ") " + model.SqlType, model.PageSize * (int.Parse(context.Request["currentsize"]) - 1), model.PageSize, null, " order by " + model.SqlOrderBy);
                    count = mll.GetCount(model.ModelTable, " where verify = 1 and ((select [ParentClassID] from GZXX_Class where GZXX_Class.ClassID =" + model.ModelTable + ".ClassID) = " + model.ModelClass + " or classid = " + model.ModelClass + ") " + model.SqlType, null);
                }
                else if (model.LabelType == 2)
                {
                    try
                    {
                        string[] arr = context.Request["term"].Split(new string[] { "@@@" }, StringSplitOptions.None);
                        for (int k = 0; k < arr.Length; k++)
                        {
                            if (arr[k] == "&ClassID") 
                            {
                                
                            }
                            model.SqlType = model.SqlType.Replace("{参数" + (k + 1) + "}", "'" + arr[k] + "'");
                        }
                    }
                    catch (Exception) { }
                    if (context.Request["keshi"] != null)
                    {
                        if (context.Request["keshi"] != "")
                        {
                            model.SqlType += " and keshi = '" + context.Request["keshi"].ToString() + "'";
                        }
                    }
                    dt = mll.GetDataTable("*,(case when dateadd(day,3,AddDate) > getdate() then 'is_new' else '' end) as isnew", model.ModelTable, " where verify = 1 " + model.SqlType, model.PageSize * (int.Parse(context.Request["currentsize"]) - 1), model.PageSize, null, " order by " + model.SqlOrderBy);
                    count = mll.GetCount(model.ModelTable, " where verify = 1 " + model.SqlType, null);
                }