<%@ WebHandler Language="C#" Class="DataShow"  %>
using System;
using System.Collections.Generic;
using System.Web;
using System.Data;
using System.Data.Common;
using System.Web.SessionState;
using System.Text;
using eMIS;

public class DataShow : IHttpHandler , IRequiresSessionState
{
    private int fixedcolumns=0;
    private int displaySubprogramCount = 0;
    private int openSubprogramCount = 0;
    private int elementsCount = 0;
    private int subProgramCount = 0;
    private string joinCellJs = "";
    private int headMaxRow = 0;
    private int headMaxCel = 0;


    public void ProcessRequest (HttpContext context)
    {
        //context.Response.Redirect("ListGroup.ashx");
        string ver = "2020245";


        if (context.Session["userid"] == null)
        {
            LoginManager lm = new LoginManager(context);
            if (!lm.VerifyIdentity())
            {
                context.Response.Write("会话丢失，请重新登陆！");
                context.Response.End();
            }
        }

        string wwwroot = context.Request.ApplicationPath;
        string menuId = context.Request.QueryString["proid"]==null?"":context.Request.QueryString["proid"].ToString();
        string menups = menuId;
        string userId = context.Session["userid"].ToString();
        string stateKey = "";
        if (!DataManager.IsNumber(menuId))
        {
            menuId = DataManager.Decrypt(menuId);
            stateKey = StringHelper.GetRightString(menuId);
            menuId = StringHelper.GetLeftString(menuId);
        }


        PageIdManager pim = new PageIdManager();
        string instanceId = null;
        if (context.Request.QueryString["id"] != null)
        {
            pim.Init(context.Request.QueryString["id"].ToString());
            menuId = pim.MenuID;
            instanceId = pim.Key;
        }


        string userAgent = context.Request.UserAgent.ToLower();

        bool isMobile=false;
        if (userAgent.Contains("android") || userAgent.Contains("iphone") || userAgent.Contains("ipad"))
            isMobile = true;


        if (wwwroot == "/") wwwroot = "";

        string ip = "";// HttpContext.Current.Request.UserHostAddress;

        string url_dt = DateTime.Now.Ticks.ToString();
        string rand = DataManager.GetToken(userId,url_dt,ip);


        string ThemePath = wwwroot + "/Themes/" + context.Session["theme"].ToString();

        string buttonGroupId = (context.Request.QueryString["bgid"] == null ? "" : context.Request.QueryString["bgid"].ToString());


        DataManager sysData = new DataManager();
        sysData.Operator.OpenConnection();
        InstanceManager instManager = new InstanceManager(context,sysData,menuId);
        instManager.StateKey = stateKey;

        /*
    if (context.Session["userid"].ToString() == "400002")
    {
        context.Response.Write(instManager.GetStateValue("dc"));
        context.Response.End();
    }
    */

        instManager.InstanceId = instanceId;

        string programId = instManager.ProgramID;
        ProgramManager pm = instManager.Program;
        DataTable listElements = pm.ListElements;
        DataRow businessDataRow = null;

        TagManager tagManger = new TagManager();
        tagManger.Context = context;
        elementsCount = listElements.Rows.Count;
        subProgramCount = pm.Subprograms.Rows.Count;
        int i,l,j,k,ii;
        string s,s2,s3,web,param,s4;
        string tjfs;
        string[] arr_temp;
        string[] arr_temp1;
        string url="", xml, str_bg, elementType;
        string primaryKeyValue;
        string primaryKey, foreignKey, relationDesc, relationCondition;
        DataTable listDataTable;
        string systemName = DataManager.GetSystemName();
        string str1 = "", str, pagec="", reltype;
        int colspan;
        string subPrimaryKeyValue;
        DataTable dt1 = null;
        bool isExistDownload = false;
        bool first,last,b1;


        HttpCookie cookie = context.Request.Cookies.Get("ps" + menuId);

        int PageSize;

        if (cookie == null)
        {
            PageSize = instManager.PageSize;
        }
        else
        {
            PageSize=   int.Parse(cookie.Value);
            instManager.PageSize = PageSize;
        }


        cookie = context.Request.Cookies.Get("pk" + menuId);
        string spk = "";
        if (cookie != null)
        {
            spk = ","+cookie.Value.Replace("%2C", ",")+",";
        }




        string mini = (context.Request.QueryString["mini"]==null ? instManager.GetStateValue("mini") : context.Request.QueryString["mini"].ToString());


        if (context.Request.QueryString["qcond"] != null)
        {
            s = context.Request.QueryString["qcond"].ToString();
            s =DataManager.SqlDecode(s);
            instManager.AllowSaveState = true;
            instManager.QueryCondition = s;

        }

        if (context.Request.QueryString["dcond"] != null)
        {
            s = context.Request.QueryString["dcond"].ToString();
            s = DataManager.SqlDecode(s);
            instManager.DefaultCondition = s;
        }
        if (context.Request.QueryString["dcond2"] != null)
        {
            s = context.Request.QueryString["dcond2"].ToString();
            s = DataManager.SqlDecode(s);
            instManager.DefaultCondition2 = s;
        }


        string pageTitle = pm.Properties["bt"].ToString();
        if (instManager.FlowNode != "")
        {
            //pageTitle += "-" + instManager.Flow.GetNodeProperty(instManager.Flow.CurrentNodeID, "jdmc");
        }


        if (context.Request.QueryString["var"] != null)
        {
            instManager.SetStateValue("vr", context.Request.QueryString["var"].ToString());
        }

        if (context.Request.QueryString["cpara"] != null)
        {
            s = context.Request.QueryString["cpara"].ToString();
            s = DataManager.UrlDecode(s);
            instManager.SetStateValue("vr",s );
        }

        string gstat = "",gstatf="";
        if (context.Request.QueryString["gstat"] != null)
        {
            gstat = DataManager.UrlDecode( context.Request.QueryString["gstat"].ToString());
            gstatf = context.Request.QueryString["gstatf"].ToString();
            instManager.SetStateValue("gs", gstat);
            instManager.SetStateValue("gsf", gstatf);
        }
        else
        {
            gstat = instManager.GetStateValue("gs");
            gstatf = instManager.GetStateValue("gsf");
        }



        string sessionVar = instManager.GetStateValue("vr");

        if (buttonGroupId != "")
        {
            instManager.ButtonGroupID = buttonGroupId;
        }

        //if (context.Session["usercnname"].ToString() == "管理员")
        //{
           //context.Response.Write(instManager.ListSqlWhere);
           //context.Response.End();
        //}

        string programJson = pm.Properties["json"].ToString();
        ProgramJson progJson =Newtonsoft.Json.JsonConvert.DeserializeObject<ProgramJson>("{"+programJson+"}");


        StringBuilder sb = new StringBuilder();




        //if (instManager.PageCount > 1)
        //{
        //    if (instManager.CurrentPage == 1)
        //    {
        //        str = "disabled";
        //        first = true;
        //    }
        //    else
        //    {
        //        str = "style='cursor:pointer;'";
        //        first = false;
        //    }
        //    if (instManager.CurrentPage == instManager.PageCount)
        //    {
        //        str1 = "disabled";
        //        last = true;
        //    }
        //    else
        //    {
        //        str1 = "style='cursor:pointer;'";
        //        last = false;
        //    }

        //    // pagec = "<div style='width:100%;'><table style='color:#000000;' cellspacing=2 cellpadding=2 align=right height='24'><tr><td><a href='action/data_search3.ashx?mid="+menuId+"&f=s'>已选<span id='selectedspan'>0</span></a> <a href='action/data_search3.ashx?mid="+menuId+"&f=a'>全部</a></td><td>|</td><td "+(first?"":"onclick='MoveFirst();'")+" " + str + ">首页</td><td>|</td><td "+(first?"":"onclick='MovePrevious();'")+" " + str + ">上页</td><td>|</td><td "+(last?"":"onclick='MoveNext();' ")+" " + str1 + ">下页</td><td>|</td><td "+(last?"":"onclick='MoveLast();' ")+" " + str1 + ">末页</td></tr></table></div>";
        //}
        //else
        //{
        //    // pagec = "<div style='width:100%;'><table style='color:#000000;' cellspacing=2 cellpadding=2 align=right height='24'><tr><td><a href='action/data_search3.ashx?mid="+menuId+"&f=s'>已选<span id='selectedspan'>0</span></a> <a href='action/data_search3.ashx?mid="+menuId+"&f=a'>全部</a></td><td>|</td><td style='color:#999999'>首页</td><td>|</td><td style='color:#999999'>上页</td><td>|</td><td  style='color:#999999'>下页</td><td>|</td><td style='color:#999999'>末页</td></tr></table></div>";
        //}

        s = instManager.SqlOrder;

        string sortColumn = "";
        string sortOrder = "";

        if (s != "")
        {
            //s = s.Replace(",", " ");
            //arr_temp = s.Split(' ');
            //sortColumn = arr_temp[0];
            //sortOrder = arr_temp[1];
        }

        //sb.Append(instManager.GetListSqlWhere());

        /*
    if (context.Session["superman"].ToString() == "1")
    {
        context.Response.Write(instManager.DefaultCondition + "<br><br>");
        context.Response.Write(instManager.ListSqlWhere);
        context.Response.End();
    }
    */

        sb.AppendLine("<!DOCTYPE html><html style=\"height:100%;\">");
        sb.AppendLine("<head>");
        string DZDYYM = pm.Properties["DZDYYM"].ToString();

        sb.Append("<script type='text/javascript'>var token='"+rand+"',procfg={};pageType=1,ProID='" + menuId + "',progId='"+programId+"',menups='"+menups+"', SRPS='" + instManager.RecPrint + "',MRPS='" + instManager.LisPrint + "',CurrentPosition=" + instManager.CurrentPage.ToString() + ",TotalCount=0,ParentName='" + instManager.GetStateValue("fkv") + "',sHB='',NodeName='" + instManager.FlowNode + "',HasChart=false,wwwroot='" + wwwroot + "',");
        if(DZDYYM=="")
        {
            sb.Append("reportId='',CusPagPrint=''");
        }
        else
        {
            if(DZDYYM.IndexOf(".")==-1)
                sb.Append("reportId='" + DZDYYM + "',CusPagPrint=''");
            else
                sb.Append("reportId='',CusPagPrint='" + DZDYYM + "'");
        }
        string hasEditPopedom = instManager.HasEditPopedom().ToString();

        sb.Append(",CustomAction={" + pm.Properties["LJGJZD"].ToString() + "},Mini='" + mini + "',ParentValue='" + instManager.ParentPrimaryKeyValue + "',MultiDataSetCfg='',allowEdit='" + hasEditPopedom + "',programJson={" + programJson + "},vr='"+sessionVar+"',superman=('1'=='" + context.Session["superman"].ToString() + "'),sub_instid='"+pim.GetID(userId,menuId,"1")+"',pageid='"+(instanceId==null?"":pim.ID)+"',pagekey='"+(instanceId==null?menuId:pim.Key)+"';</script>");

        sb.AppendLine("<script type='text/javascript' src='"+wwwroot+"/App_Files/profiles/"+programId+"/"+userId+".js?"+url_dt+"'></script>");
        sb.AppendLine("<script type='text/javascript' src='Scripts/common.js?"+ver+"'></script>");
        sb.AppendLine("<script type='text/javascript' src='Scripts/kernel.js?"+ver+"'></script>");


        sb.AppendLine("<link rel='stylesheet' href='" + ThemePath + "/default.css?"+ver+"' type='text/css'>");
        sb.AppendLine("<link rel='stylesheet' href='"+wwwroot+"/jslibs/font-awesome/css/font-awesome.min.css' type='text/css'>");


        sb.AppendLine("<STYLE TYPE='text/css' id='listpagestyle'>");
        sb.AppendLine(".fixedc {left:0px;}");
        sb.AppendLine(".fixedr { top:0px;}");
        sb.AppendLine(".fixedp {position: relative;}");
        sb.AppendLine(".relationdiv {}");
        sb.AppendLine(".input { FONT-FAMILY: 宋体;FONT-SIZE: 9pt; background-color: #ffffff; border:0px solid #ffffff;}");
        sb.AppendLine(".p9{ FONT-FAMILY: 宋体; FONT-SIZE: 9pt}");
        sb.AppendLine(".adiv { border: 2px inset #FFFFFF; width:132px;}");


        i = programJson.IndexOf("fixedcolumns");
        if (i == -1)
        {

            sb.AppendLine("#TABLE1 td{ border:solid 1px #cccccc;} ");
        }
        else
        {
            fixedcolumns = int.Parse(StringHelper.GetParamValue(programJson, "fixedcolumns"));
            sb.AppendLine("#TABLE1 td{ border:0px;word-break:nowrap;white-space:nowrap;} ");
        }

        sb.AppendLine("</STYLE>");
        sb.AppendLine("<title>" + pageTitle +  " - 列表</title>");
        sb.AppendLine("<meta http-equiv='Content-Type' content='text/html; charset=utf-8'>");
        sb.AppendLine("</head>");
        sb.AppendLine("<body class='datalist_body' "+(isMobile?"style='overflow:auto;'":"")+" oncontextmenu='//return false;' onresize='em_lt_page_resize();'>");
        //<ui-head>
        string pageHeight = "0";

        pageHeight = "30";

        //sb.Append("<div style='padding:10px;font-size:15px;font-weight:bold;'>"+pageTitle+"</div>");

        s = StringHelper.GetParamValue(sessionVar, "objlist");
        if (s != "")
        {
            arr_temp = s.Split(',');
            BusinessObjectManager bom = new BusinessObjectManager(instManager.SystemDataManager);
            for (i = 0; i < arr_temp.Length; i++)
            {
                bom.MenuID = null;
                bom.ObjectID = arr_temp[i];
                if(bom.MenuID!=menuId)
                    sb.Append("&nbsp;&nbsp;<input type='button' value='"+bom.Description+"' onclick=\"ObjectSelectList3('"+arr_temp[i]+"','"+s+"')\">");
            }
        }
        else
        {
            //sb.Append("&nbsp;");
        }


        //sb.Append("");
        //sb.Append(pagec);





        if (buttonGroupId == "")
            buttonGroupId = instManager.ButtonGroupID;


        //context.Response.Write(buttonGroupId);
        //context.Response.End();

        if (buttonGroupId != "")
        {
            //tempStr = "<table border=0 cellspacing=0 cellpadding=2><tr>";

            //tempStr += (mini==""?"":"<td>"+pagec+"</td>")+"<td>共" + instManager.RecordCount.ToString() + "条  " + instManager.CurrentPage + "/" + instManager.PageCount + "页</td><td><INPUT id=text1 class='input3' style='line-height:10px;HEIGHT: 13px; WIDTH: 24px' onkeydown='if(event.keyCode==13) TowardPage(this.value)'></td><td><img id=toward alt='转到' name=toward src='../Images/toward.gif' onmouseover=this.style.cursor='pointer' onclick=\"TowardPage(g('text1').value)\"></img></td></tr></table>";

            ToolBar2 toolbar = new ToolBar2(sysData);

            sb.Append("<div style='padding:2px 2px 0px 2px;'>");
            s = progJson.rowEdit ? "134" : "112";
            if(isMobile)
                sb.Append("<div id='emToolBar' class='box em_toolbar em_list_toolbar'><div class='box em_toolbar_left' style='float:left;width:100%;overflow:hidden;'>");
            else
                sb.Append("<div id='emToolBar' class='box em_toolbar em_list_toolbar'><div class='box em_toolbar_left'  style='float:left;width:calc(100% - "+s+"px);overflow:hidden;'>");


            sb.Append(toolbar.GetHtml(buttonGroupId, "查询", "", wwwroot,instManager.MenuID,userId));

            sb.Append("<div id='em_toolbar_add' style='float:left;height:14px;'></div></div>");
            //<div style='float:left;height:14px;padding-right:10px;'><i title='查询' class='fa fa-search em_hover_red'   aria-hidden='true' onclick='em_lt_data_search_disp();'></i></div>
            sb.Append("<div id='em_toolbar_mov' class='em_hover_red em_lt_but_d' onclick='em_toolbar_move();' style='display:none;float:left;height:14px;padding-left:6px;'><i class='fa fa-chevron-circle-right' aria-hidden='true' style='line-height: 14px;'></i></div>");


            if (!isMobile)
            {
                sb.Append("<div style='float:right;'>");


                sb.Append("<div style='float:right;height:14px;line-height:14px;padding:4px 10px 4px 0px;'><i title='刷新' class='fa fa-repeat em_hover_red em_lt_but_d'    aria-hidden='true' onclick='em_lt_page_refresh();'></i></div>");
                sb.Append("<div style='float:right;height:14px;line-height:14px;padding:4px 10px 4px 0px;'><i title='还原默认列宽度' class='fa fa-columns em_hover_red em_lt_but_d'    aria-hidden='true' onclick='em_lt_del_cookie_width(" + menuId + ");'></i></div>");
                sb.Append("<div style='float:right;height:14px;line-height:14px;padding:4px 10px 4px 0px;'><i title='切换表格样式' class='fa fa fa-table em_hover_red em_lt_but_d' aria-hidden='true' onclick='em_lt_table_mode_set();'></i></div>");
                if(progJson.rowEdit)
                    sb.Append("<div style='float:right;height:14px;line-height:14px;padding:4px 10px 4px 0px;'><i title='打开编辑' class='fa fa-pencil-square-o em_hover_red em_lt_but_d' aria-hidden='true' onclick='em_lt_set_rowedit(this);'></i></div>");

                sb.Append("<div  style='float:right;height:18px;padding:2px 10px 2px 0px;'><div style='width:2px;height:18px;background-color:#f0f0f0;'></div></div>");

                sb.Append("<div style='clear:both;'></div></div>");
            }
            sb.Append("<div style='clear:both;'></div></div>");
            sb.Append("</div>");
        }



        //</ui-head>

        string sTJFS = pm.Properties["TJFS"].ToString();

        double[] var_sum,var_avg,var_max,var_min;
        double var_count,var_num;
        string html;

        var_sum = new double[elementsCount];
        var_avg = new double[elementsCount];
        var_max = new double[elementsCount];
        var_min = new double[elementsCount];

        if (sTJFS!= "")
        {


            for (i=0;i<elementsCount;i++)
            {
                var_sum[i] = 0;
                var_avg[i] = 0;
                var_max[i] = double.MinValue;
                var_min[i] = double.MaxValue;
            }

            var_count = 0;
        }

        //列表快捷查询
        DataRow[] rows = listElements.Select("LBKJCX=1");
        ValueTagManager tag = new ValueTagManager(instManager);
        ControlManager cm = new ControlManager(instManager);
        cm.PageType = 1;
        l = rows.Length;

        DataRow busRow = null;
        string controlIdList = "";
        string list_ls_eles="[{}";

        string cookieName;
        if (instManager.ParentID != "")
            cookieName = "ls_hidd2";
        else
            cookieName = "ls_hidd";
        cookie = context.Request.Cookies.Get(cookieName);
        string ls_hidd = cookie==null?"1":cookie.Value;

        sb.Append("<div id='div_list_search' style='padding:2px 2px 0px 2px;width:auto;"+(l==0||ls_hidd=="1"?"display:none;":"")+"'><div style='width:100%;' >");
        string sYSF = "<option>=</option><option>>=</option><option><=</option><option><></option><option>></option><option><</option><option>like</option>";

        sb.Append("<table border=0 cellspacing=0 cellpadding=0 width=100% ><tr>");
        sb.Append("<td width=99></td></tr></table>");
        sb.Append("<form id='f" + menuId + "' name='f" + menuId + "' action='action/data_search.ashx?pid=" + menuId + "&f=2' method=post style='padding:0px;margin:0px;'><div style='width:100%;'>");
        s = "\t" + instManager.GetStateValue("lqv") + "\t";


        //分组统计选项
        if (progJson.groupStat != null)
        {
            sb.Append("<div style='float:left;height:30px;padding:6px 2px 6px 2px;'>");
            html = "<select id='gstat_c' title='分类汇总' onchange='groupStatChange();' style='border: 0px currentColor; border-image: none; width: 120px; font-size: 12px; background-color: transparent;color:dodgerblue;' size='1'  ><option disabled  style='color: gray; display: none;' value='' selected>分类汇总</option><option value=''>不汇总</option>";

            foreach (string f in progJson.groupStat.groupColumns)
                html += "<option value='"+f+"' "+(gstat==f?"selected":"")+">分类字段:"+f+"</option>";

            html +="</select>";

            sb.Append("<div style='background-color:#F5F6FA;padding:0px 2px 4px 2px;border-radius:4px;'>" + html + "</div></div>");

            sb.Append("<div style='float:left;height:30px;padding:6px 2px 6px 2px;'>");

            sb.Append("<div style='background-color:#F5F6FA;padding:0px 2px 4px 2px;border-radius:4px;'><select onchange='groupStatChange();' id='gstat_f' style='border:0px currentColor; border-image: none; width: 120px; font-size: 12px; background-color: transparent;color:dodgerblue;' size='1' ><option value='sum' "+(gstatf=="sum"?"selected":"")+" >汇总方式:求和</option><option value='avg' "+(gstatf=="avg"?"selected":"")+" >汇总方式:平均</option><option value='max' "+(gstatf=="max"?"selected":"")+" >汇总方式:最大</option><option value='min' "+(gstatf=="min"?"selected":"")+" >汇总方式:最小</option></select></div>");
            sb.Append("</div>");
        }
        //分组统计选项


        for (i = 0;i<l;i++)
        {
            cm.Init(busRow, rows[i]);
            cm.SearchUi = true;
            if (cm.ControlType == "4")
                cm.ControlType = "1";
            if(cm.ControlType=="1")
                cm.ControlStyle = "border:0px;background-color:transparent;width:120px;font-size:12px;";
            else
                cm.ControlStyle = "border:0px;background-color:transparent;width:120px;font-size:12px;";
            //j = s.IndexOf("\tc" + cm.ControlID + "\t");
            //if (j != -1)
            //{
            //    j=j + cm.ControlID.Length + 3;
            //    k = s.IndexOf("\t",j);
            //   cm.Value = s.Substring(j, k - j);
            // }

            list_ls_eles += ",{id:'"+cm.ControlID+"',desc:'"+cm.ControlDescription+"',dataType:"+cm.DataType+",contType:"+cm.ControlType+",progId:'"+programId+"'}";
            controlIdList += ",'" + cm.ControlID + "'";
            if (cm.GetParamValue("multi", "0") == "0")
            {
                if (rows[i]["QZZDLX"].ToString() == "1" && rows[i]["KJLX"].ToString() == "1" && cm.GetParamValue("search","")=="")
                    sYSF = "<option>like</option>";
                else
                    sYSF = "<option>=</option>";
            }
            else
            {
                sYSF = "<option>in</option>";
            }

            sb.Append("<div style='float:left;height:25px;padding:2px 2px 2px 2px;'>");
            sb.Append("<div style='background-color:#F5F6FA;padding:0px 2px 4px 2px;border-radius:4px;'>" + cm.GetHtml() + "</div><select style='display:none;' name=ysf" + cm.ControlID + ">" + sYSF + "</select></div>");

        }


        //从表

        //l = instManager.Program.Subprograms.Rows.Count;

        string glcxid, fk, pk,subtn,subcid,subparas="",cid;
        DataTable elements;
        InstanceManager sub;

        foreach (DataRow row in instManager.Program.Subprograms.Rows)
        {

            xml = row["xml"].ToString();
            if (StringHelper.GetXmlValue(xml, "参与主表查询") == "1")
            {
                glcxid = row["glcxid"].ToString();
                fk = StringHelper.GetXmlValue(xml, "外键");
                pk = StringHelper.GetXmlValue(xml, "主键");


                sub = new InstanceManager(context,instManager.BusinessDataManager , glcxid);
                sub.InitState();
                cm = new ControlManager(sub);
                cm.MultiProgramKey = "p"+glcxid;

                subtn = sub.Program.ListTableName;

                elements = sub.Program.QueryElements;
                l = elements.Rows.Count;
                cm.PageType = 1;
                subparas += ";" + glcxid + "," + fk + "," + pk + "," + subtn;

                for (i = 0; i < l; i++)
                {
                    cm.Init(null, elements.Rows[i]);
                    cid = glcxid + "_" + cm.ControlID;
                    cm.ControlID = cid;
                    cm.SearchUi = true;
                    cm.ControlStyle = "border:0px;background-color:transparent;width:120px;font-size:12px;";
                    cm.ControlDescription = row["glms"].ToString()+cm.ControlDescription;

                    list_ls_eles += ",{id:'"+cm.ControlID+"',desc:'"+cm.ControlDescription+"',dataType:"+cm.DataType+",contType:"+cm.ControlType+",progId:'"+glcxid+"'}";

                    if (cm.GetParamValue("multi", "0") == "0")
                    {
                        if (cm.DataType == "1" && cm.ControlType == "1" && cm.GetParamValue("search","")=="")
                            sYSF = "<option>like</option>";
                        else
                            sYSF = "<option>=</option>";
                    }
                    else
                    {
                        sYSF = "<option>in</option>";
                    }

                    sb.Append("<div style='float:left;height:25px;padding:2px 2px 2px 2px;'>");
                    sb.Append("<div style='background-color:#F5F6FA;padding:0px 2px 4px 2px;border-radius:4px;'>" + cm.GetHtml() + "</div><select style='display:none;' name=ysf" + cm.ControlID + ">" + sYSF + "</select></div>");


                }

            }

        }



        sb.Append("<div style='float:left;height:25px;padding:2px 2px 2px 2px;' onclick='em_lt_search_submit();'>");
        sb.Append("<div class='but' style='background-color:#3F9AE6;'><input type='button' style='color:white;font-size:12px;' value='搜索'  class='but_desc' readonly ></div></div>");


        sb.Append("<div style='float:left;height:25px;padding:2px 2px 2px 2px;'>");
        sb.Append("<div style='padding: 0px 4px 4px 4px; border-radius: 4px; background-color: rgb(245, 246, 250);' id='em_search_cfg_but' onclick='em_lt_set_search_cfg(this);'><i title='查询选项' class='fa fa-angle-right em_hover_red' style='font-size:12px;' aria-hidden='true' ></i></div>");
        sb.Append("</div>");

        sb.Append("<div style='float:left;display:none;' id='em_sea_cfg_div'>");
        sb.Append("<div style='float:left;height:25px;padding:2px 2px 2px 2px;'>");
        sb.Append("<div style='padding: 0px 2px 4px; border-radius: 4px; background-color: rgb(245, 246, 250);'><select id='em_search_log'   style='border: 0px currentColor; border-image: none; font-size: 12px; background-color: transparent;'><option value='and'>且</option><option value='or'>或</option></select></div>");
        sb.Append("</div>");

        sb.Append("<div style='float:left;height:25px;padding:2px 2px 2px 2px;'>");
        sb.Append("<div style='padding: 0px 2px 4px; border-radius: 4px; background-color: rgb(245, 246, 250);'><select id='em_search_comp'   style='border: 0px currentColor; border-image: none; font-size: 12px; background-color: transparent;'><option value=''>默认比较</option><option value='equ'>等于</option><option value='notequ'>不等于</option><option value='gre'>大于</option><option value='greequ'>大于等于</option><option value='les'>小于</option><option value='lesequ'>小于等于</option><option value='lik'>包含</option><option value='notlik'>不包含</option></select></div>");
        sb.Append("</div>");


        sb.Append("<div style='float:left;height:25px;padding:2px 2px 2px 2px;'>");
        sb.Append("<div style='padding: 0px 2px 4px; border-radius: 4px; background-color: rgb(245, 246, 250);'><select id='em_search_poli'  onchange='em_search_poli_change();' style='border: 0px currentColor; border-image: none; font-size: 12px; background-color: transparent;'><option value='0'>保留条件检索</option><option value='1'>每次重新检索</option><option value='2'>替换条件检索</option></select></div>");
        sb.Append("</div>");
        sb.Append("<div style='clear:both;'></div></div>");

        sb.Append("<div style='clear:both;'></div></div></form>");

        sb.Append("<div style='height:1px;'><span></span></div>");

        sb.Append("<div class='em_lt_hr'></div></form></div>");

        sb.Append("<div id='div_list_search_result' style='width:auto;font-size:12px;padding:2px;'><div style='float:left;'><div style='padding:6px 6px 6px 6px;'>查询条件&nbsp;<i class='fa fa-angle-right' aria-hidden='true'></i></div></div><div id='e_ls_items' style='float:left'></div><div style='clear:both;'></div></div>");
        sb.Append("</div>");

        s = instManager.GetStateValue("lqv").Replace("\"","");



        list_ls_eles += "]";
        sb.Append("<script type='text/javascript'>var em_lt_info={page:{},sub_open:0,cal_row_h:[],cus_col_w:{},eles:"+list_ls_eles+",order_text:\"\",cond_items:\""+s+"\",cond_groups:\"\",cond_group_cur:0};var controlIdList=[" + (controlIdList == "" ? "" : controlIdList.Substring(1)) + "];em_lt_cond_items_init();</script>");

        sb.Append("<div style='width:auto;padding:2px 2px 2px 2px;'><div id='div_content' style='width:100%;height:400px;overflow:hidden;' >");

        //<ui-bottom>
        sb.Append("</div></div>"); //div_content



        sb.Append("<div style='padding:0px 10px 0px 10px;'><div id='datalist_bottom' class='datalist_bottom'>");

        if (isMobile)
        {
            sb.Append("<div id='div_page_buttons' style='height:30px;padding:6px;border-radius: 6px;background-color:#eeeeee;text-align:center;width:100%;display: -webkit-flex; display: flex;justify-content:space-between;' class='page_buttons page_buttons_h box'></div>");


            sb.Append("<div style='padding:20px 0px 0px 3px;'>");
            sb.Append("<div style='float:left;height:20px;width:50%'><div style='float:left;' class='page_buttons_h'>每页显示</div>");
            sb.Append("<div style='float:left;padding-left:10px;' class='page_buttons_h'><select onchange='em_lt_psize_change(this.value)' class='em_lt_psize'>");
            string[] asize = new string[] { "10", "20","30","40", "50","100" };

            for (i = 0; i < asize.Length; i++)
            {
                s = asize[i];
                sb.Append("<option value='" + s + "' " + (s == PageSize.ToString() ? "selected" : "") + ">" + s + "条</option>");
            }
            if (!",10,30,50,".Contains("," + PageSize + ","))
                sb.Append("<option value='" + PageSize + "' selected >" + PageSize + "条</option>");

            sb.Append("</select></div></div>");

            sb.Append("<div style='float:right;height:20px;width:50%;'>");

            sb.Append("<div class='page_buttons_h' style='float:right;'><input type='text' id='page_select_idx' onkeydown='em_lt_page_select2(event);' class='em_lt_page_idx'><input type='text' class='em_lt_page_go' readonly value='GO' onclick='em_lt_page_select();'></div>");

            sb.Append("<div style='float:right;color:#666666;padding-right:10px;' class='page_buttons_h'>共<span id='em_lt_rcount'></span>条</div></div>");
            sb.Append("<div style='clear:both;'></div>");
            sb.Append("</div>");
        }
        else
        {
            sb.Append("<div style='float:left;width:20%;height:20px;'><div style='float:left;' class='page_buttons_h'>每页显示</div>");
            sb.Append("<div style='float:left;padding-left:4px;' class='page_buttons_h'><select onchange='em_lt_psize_change(this.value)' class='em_lt_psize'>");
            string[] asize = new string[] { "10", "20","30","40", "50","100" };

            for (i = 0; i < asize.Length; i++)
            {
                s = asize[i];
                sb.Append("<option value='" + s + "' " + (s == PageSize.ToString() ? "selected" : "") + ">" + s + "条</option>");
            }
            if (!",10,30,50,".Contains("," + PageSize + ","))
                sb.Append("<option value='" + PageSize + "' selected >" + PageSize + "条</option>");

            sb.Append("</select></div></div>");
            sb.Append("<div id='div_page_buttons' style='float:left;text-align:center;width:60%;' class='page_buttons page_buttons_h'></div><div style='float:right;width:20%;height:20px;'>");

            sb.Append("<div class='page_buttons_h' style='float:right;'><input type='text' id='page_select_idx' onkeydown='em_lt_page_select2(event);' class='em_lt_page_idx'><input type='text' class='em_lt_page_go' value='GO' onclick='em_lt_page_select();'></div>");

            sb.Append("<div style='float:right;color:#666666;padding-right:10px;' class='page_buttons_h'>共<span id='em_lt_rcount'></span>条</div></div>");
            sb.Append("<div style='clear:both;'></div>");
        }

        sb.Append("</div></div><div id='div_page_bottom' style='width:100%;height:0px;'></div>");

        //</ui-bottom>




        sb.Append("<script type='text/javascript'>");

        sb.Append("var pagecheight = " + pageHeight + ";displaySubprogramCount="+displaySubprogramCount.ToString()+";");
        sb.Append("var OpenPageSize = '" + StringHelper.GetXmlValue(pm.Properties["xml"].ToString(),"popFormSize") + "';");
        sb.Append("em_lt_init();");


        //document.styleSheets("listpagestyle").rules[0].style.width = document.body.clientWidth - 50


        sb.Append("var commroot = '"+wwwroot+"/common6';var pagetype = '查询';function Modify(){}");



        sb.Append("var tableheadorderbyc = document.getElementsByName('tableheadorderby');");
        sb.Append("for (var i = 0; i < tableheadorderbyc.length; i++)");
        sb.Append("GetSortIco(tableheadorderbyc[i]);");
        sb.Append(" switch ('" + instManager.GetStateValue("js") + "'){case 'impprolist' : impprolist(); break;case 'addObjectSelectButtons0' : addObjectSelectButtons(0); break;case 'addObjectSelectButtons1' : addObjectSelectButtons(1); break;default :break;}");
        sb.Append(joinCellJs);

        sb.Append("listButtons();cellMerge(g('TABLE1'),"+headMaxRow+","+headMaxCel+")</script>");
        sb.Append("<script type='text/javascript' src='" + wwwroot + "/App_Web/Programs/" + programId + "/listpage.js?"+rand+"'></script>");

        sb.Append("</body>");
        sb.Append("</html>");
        sysData.Operator.CloseConnection();
        context.Response.Write(sb.ToString());

    }

    private string Format(string formatString, string valueString)
    {
        int i = formatString.IndexOf("format:(");
        if (i == -1)
            return valueString;
        if (valueString == "")
            return "";
        string s = formatString.Substring(i + 8, formatString.IndexOf(")", i) - i - 8);
        string[] a = s.Split(',');
        string ret = valueString;
        switch (a[0])
        {
            case "datetime":
                ret = DateTime.Parse(valueString).ToString(a[1]);
                break;
            case "number":
                double d;
                if (double.TryParse(valueString, out d))
                    ret = d.ToString(a[1]);
                else
                    ret = "";
                break;
            default:
                break;
        }

        return ret;

    }


    public void setDisplayFormat(int idx,string s)
    {
        //dim s1,fn,ft,i,k
        //if s= "" then
        //    fn = ""
        //else
        //    i = instr(s,"displayformat")
        //    if i <1 then
        //        fn= ""
        //    else
        //        i = i + 14
        //        k = instr(i,s,"(")
        //        fn = mid(s,i,k-i)
        //        i = instr(k,s,")") - 1
        //        ft = mid(s,k+1,i-k)
        //    end if
        //end if
        //displayFormat(idx,0) = fn
        //displayFormat(idx,1) = ft
    }

    private string getDisplay(int idx,string v)
    {
        string r=v;
        //if displayFormat(idx,0) = "" then
        //    r = v
        //else
        //    select case displayFormat(idx,0)
        //        case "date"
        //            r = emisformatdate(displayFormat(idx,1),v)
        //        case "money"
        //            r = emisformatmoney(displayFormat(idx,1),v)
        //    end select
        //end if
        return r;
    }




    private string emisformatmoney(string ft,string v)
    {
        string r;

        r = v;
        if (v != "")
        {
            string f = ft + ",,,";
            string[] a = f.Split(',');

            if (a[0] == "")
                a[0] = "￥";
            if (a[1] == "")
                a[1] = "1";
            if (a[2] == "")
                a[2] = "-1";
            if (a[1] == "1")
                r = Math.Round(Convert.ToDecimal(r),Convert.ToInt16(a[1])).ToString();
            r = a[0] + r;
        }

        return r;
    }

    private string GetItemValue(string itemsString,string itemName)
    {
        int i = itemsString.IndexOf("\"" + itemName + "\" : \"") + itemName.Length + 6;
        int j = itemsString.IndexOf("\"",i);
        return itemsString.Substring(i, j - i);
    }

    private void GetTableHead(StringBuilder sb,ProgramManager pm,DataTable listElements)
    {
        sb.Append("<tr align=center class=the_list_tr_desc><td width=1 "+(fixedcolumns==0?"":" style='z-index:999;' class='fixedp fixedr fixedc the_list_tr_desc'")+"><input id='cheSelectRecordID' name='cheSelectRecordID' onclick='SelectAllRecordID(this)' value='' type='checkbox' ></td>");
        if (displaySubprogramCount > 0)
            sb.Append("<td width=1 "+(fixedcolumns==0?"":" style='z-index:999;' class='fixedp fixedr fixedc the_list_tr_desc'")+"></td>");

        string[,] displayformat = new string[elementsCount,1];
        string s,xml;
        string yc;
        int i;
        for(i=0;i< elementsCount;i++)
        {
            if (listElements.Rows[i]["YC"].ToString() != "1")
            {
                s = listElements.Rows[i]["YS"].ToString();
                yc = "";
                if (listElements.Rows[i]["HB"].ToString() == "1")
                    joinCellJs = "UniteCol(" + (i + 1).ToString() + ",0);" + joinCellJs;

                sb.Append("<td style='" + s + ";cursor:pointer;" + yc);
                if (fixedcolumns != 0)
                {

                    if (fixedcolumns > i)
                        sb.Append(";z-index:999;' class='the_list_tr_desc fixedp fixedr fixedc' ");
                    else
                        sb.Append(";z-index:888;' class='the_list_tr_desc fixedp fixedr' ");

                }
                else
                {
                    sb.Append("' class='the_list_tr_desc'");
                }
                sb.Append(" onclick ='funcOrder(this.firstChild);'  title='点击可排序'><span style='width:100%;' >" + listElements.Rows[i]["kjms"].ToString() + "<a border=0 name='tableheadorderby' column='" + StringHelper.GetRightString(listElements.Rows[i]["dyzd"].ToString()) + "'></a></span></td>");
                setDisplayFormat(i, s);
            }
        }


        for(i =0;i<subProgramCount;i++)
        {
            xml = pm.Subprograms.Rows[i]["xml"].ToString();

            if(StringHelper.GetXmlValue(xml,"弹出窗口") == "1")
            {
                if (fixedcolumns != 0)
                    sb.Append("<td class='the_list_tr_desc fixedp fixedr'>" + pm.Subprograms.Rows[i]["glms"].ToString() + "</td>");
                else
                    sb.Append("<td>" + pm.Subprograms.Rows[i]["glms"].ToString() + "</td>");
                openSubprogramCount++; ;
            }
        }
        sb.Append("</tr>");


    }

    public bool CustomTableHead(HttpContext context,StringBuilder sb,ProgramManager pm,DataTable listElements)
    {
        //==================================================
        //自定义表头

        int i,ii;

        string[,] arr_head = new string[elementsCount,5];
        string[] arr_temp;
        string s,xml;
        string desc;
        for(i=0;i< elementsCount;i++)
        {
            if (listElements.Rows[i]["YC"].ToString() != "1")
            {
                s = listElements.Rows[i]["ExtAttr"].ToString();
                headMaxCel++;

                if (s != "")
                {
                    s = StringHelper.GetXmlValue2(s, "titles");
                    if (s != "")
                    {
                        arr_temp = s.Split(new char[] { '\t'},StringSplitOptions.RemoveEmptyEntries);
                        if (arr_temp.Length > headMaxRow)
                            headMaxRow = arr_temp.Length;
                        for (ii = 0; ii < arr_temp.Length; ii++)
                            arr_head[i, ii] = arr_temp[ii];
                    }

                }
            }
        }




        if (headMaxRow == 0)
            return false;



        //context.Response.Write(headMaxRow.ToString());
        //context.Response.End();

        if (headMaxRow != 0)
        {


            for (i = 0; i < headMaxRow; i++)
            {
                sb.Append("<tr align=center style='background-color:#E7EFF8;'>");

                if (i == 0)
                {
                    sb.Append("<td width=1 ><input id='cheSelectRecordID' name='cheSelectRecordID' onclick='SelectAllRecordID(this)' value='' type='checkbox' ></td>");
                }
                else
                {
                    sb.Append("<td width=1 ></td>");
                }


                for (ii = 0; ii < elementsCount; ii++)
                {

                    if (listElements.Rows[i]["YC"].ToString() != "1")
                    {
                        desc = arr_head[ii, i];

                        if (desc == "")
                            desc = listElements.Rows[ii]["kjms"].ToString();

                        if (i == headMaxRow - 1)
                        {
                            sb.Append("<td  title='"+desc+"'><span onclick ='funcOrder(this);' style='width:100%;cursor:pointer;' >");
                            sb.Append(desc + "<a border=0 name='tableheadorderby' column='" + StringHelper.GetRightString(listElements.Rows[ii]["dyzd"].ToString()) + "'></a></span>");

                            sb.Append("</td>");
                        }
                        else
                        {
                            sb.Append("<td  title='"+desc+"'>" + desc + "</td>");
                        }
                    }
                }

                if (i == 0)
                {
                    for (ii = 0; ii < subProgramCount; ii++)
                    {
                        xml = pm.Subprograms.Rows[ii]["xml"].ToString();

                        if (StringHelper.GetXmlValue(xml, "弹出窗口") == "1")
                        {

                            sb.Append("<td rowspan='"+headMaxRow+"'>"+pm.Subprograms.Rows[i]["glms"].ToString()+"</td>");
                        }
                    }
                }
                sb.Append("</tr>");
            }




        }

        return true;

        //=====================================================
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }
}