<%@ 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");

        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"].ToString();
        string userId = context.Session["userid"].ToString();
        string rand = DateTime.Now.Ticks.ToString();


        if (wwwroot == "/") wwwroot = "";



        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);
        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["qcon"] != null)
        {
            s = context.Request.QueryString["qcon"].ToString();
            s = eMIS.Utility.JsSecurity.DecryptByAES(s);
            if (s.IndexOf("   ") != -1)
                instManager.DefaultCondition = s;
            else
                context.Response.End();
        }

        if (context.Request.QueryString["dcon"] != null)
        {
            s = context.Request.QueryString["dcon"].ToString();
            s = eMIS.Utility.JsSecurity.DecryptByAES(s);
            if (s.IndexOf("   ") != -1)
                instManager.DefaultCondition = s;
            else
                context.Response.End();
        }

        if (context.Request.QueryString["qcond"] != null)
        {
            s = context.Request.QueryString["qcond"].ToString();
            s =DataManager.SqlDecode(s);
            instManager.QueryCondition = s;

        }

        if (context.Request.QueryString["dcond"] != null)
        {
            s = context.Request.QueryString["dcond"].ToString();
            s = DataManager.SqlDecode(s);
            instManager.DefaultCondition = 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 sessionVar = instManager.GetStateValue("vr");

        if (buttonGroupId != "")
        {
            instManager.ButtonGroupID = buttonGroupId;
        }

        //if (context.Session["usercnname"].ToString() == "管理员")
        //{
        //   context.Response.Write(instManager.ListSqlWhere);
        //   context.Response.End();
        //}


        StringBuilder sb = new StringBuilder();

        //'arr_relpro = aco.GetRelationProgram(1)
        //'RelProCount = UBound(arr_relpro)


        //RelProCount = aco.DetailPrograms.L2.count
        //rel1count = aco.DetailPrograms.L1.count

        //mini = aco.mini
        //ElementCount = UBound(arr_list)
        //'sb.Append aco.SQLSelectPart()
        //if RelProCount > 0 then str_selectpart = aco.SQLSelectPart()

        //set o = aco.GetListPageObject()

        //o.Init(aco)

        //For i = 1 To ElementCount
        //    If arr_list(i, 0) = "" Then
        //        ElementCount = i - 1
        //        Exit For
        //    End If
        //    If arr_list(i, 7) = "1" Then HeBing = "UniteCol(" & i & "," & i & ");" & HeBing
        //Next

        //sTemp = aco.SQLOrderbyPart

        //If sTemp <> "" Then
        //    sTemp = Replace(sTemp, ",", " ")
        //    arr_temp = Split(sTemp, " ")
        //    SortColumn = arr_temp(2)
        //    SortOrder = arr_temp(3)
        //End If

        //aco.GetPrintSetting


        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());


        sb.AppendLine("<!DOCTYPE html><html xmlns='http://www.w3.org/1999/xhtml' style='height:100%;'>");
        sb.AppendLine("<head>");
        string DZDYYM = pm.Properties["DZDYYM"].ToString();

        sb.Append("<script type='text/javascript'>var pageType=1,ProID='" + menuId + "',SRPS='" + instManager.RecPrint + "',MRPS='" + instManager.LisPrint + "',SortColumn='" + sortColumn + "',SortOrder='" + sortOrder + "',CurrentPosition=" + instManager.CurrentPage.ToString() + ",TotalCount=" + instManager.PageCount.ToString() + ",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();
        string programJson = pm.Properties["json"].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() + "');</script>");

        sb.AppendLine("<script type='text/javascript' src='Scripts/common.js?201807003'></script>");
        sb.AppendLine("<script type='text/javascript' src='Scripts/kernel.js?2019003'></script>");

        sb.AppendLine("<link rel='stylesheet' href='" + ThemePath + "/default.css?2019001' 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' oncontextmenu='//return false;'>");

        //<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;



        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-left:10px;'>");
            sb.Append(toolbar.GetHtml(buttonGroupId, "查询", "", wwwroot,instManager.MenuID,userId));
            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;

        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;
        string controlIdList = "";
        DataRow busRow = null;



        if (l != 0)
        {

            sb.Append("<div id='div_list_search' style='padding:10px;width:auto;'><div style='margin-bottom:0px;width:100%;height:1px;background-color:#B9E0CE;'></div><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";

            for(i = 0;i<l;i++)
            {
                cm.Init(busRow, rows[i]);
                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);
                }
                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:30px;'><table><tr><td style='white-space: nowrap;font-size:12px;'>" + cm.ControlDescription + ":<select style='display:none;' name=ysf" + cm.ControlID + ">" + sYSF + "</select></td>");
                sb.Append("<td style='font-size:12px;'>" + cm.GetHtml() + "</td></tr></table></div>");

            }

            sb.Append("<div style='float:left;'><table><tr><td><input type=button value='搜索' onclick='list_search();' class=but2></td></tr></table></div><div style='clear:both;'></div></div></form>");

            sb.Append("<div style='height:1px;'><span></span></div>");
            sb.Append("<script type='text/javascript'>var controlIdList=[" + (controlIdList == "" ? "" : controlIdList.Substring(1)) + "]</script>");

            sb.Append("<div style='width:100%;height:1px;background-color:#B9E0CE;'></div></form></div></div>");

        }

        sb.Append("<div style='width:auto;padding:10px;'><div id='div_content' style='width:100%;height:400px;overflow:auto;' >");




        //主表程序ID
        if (instManager.ParentID != "" && mini == "")
        {


            InstanceManager parentInst = new InstanceManager(context, sysData,instManager.ParentID);
            ProgramManager parentProg = parentInst.Program;  // new ProgramManager(sysData, instManager.ParentID);
            parentInst.PrimaryKeyValue = instManager.ParentPrimaryKeyValue;

            sb.Append("<table border=1 cellspacing='0' cellpadding='4' style='BORDER-COLLAPSE: collapse' bordercolor='#cccccc' align='center'  width='100%'><tr class=the_list_tr_desc>");

            DataTable parentList = parentProg.ListElements;
            l = parentList.Rows.Count;

            for (i = 0; i < l; i++)
            {
                if (parentList.Rows[i]["yc"].ToString() =="0" && parentList.Rows[i]["kjlx"].ToString() != "140")
                {
                    sb.Append("<td>" + parentList.Rows[i]["kjms"].ToString() + "</td>");
                }
            }

            sb.Append("</tr><tr bgcolor='FFFFFF'>");


            listDataTable = parentInst.GetListDataTableByPrimaryKey();
            int ll = listDataTable.Rows.Count;
            ControlManager controlsub = new ControlManager(parentInst);
            for (j = 0; j < ll;j++ )
            {

                for (i = 0; i < l; i++)
                {
                    if (parentList.Rows[i]["yc"].ToString() =="0" && parentList.Rows[i]["kjlx"].ToString() != "140")
                    {
                        controlsub.Init(listDataTable.Rows[j],parentList.Rows[i]);
                        //sb.Append("<td>" + listDataTable.Rows[j][i].ToString() + "</td>");
                        sb.Append("<td>" + controlsub.Text + "</td>");
                    }
                }
            }

            sb.Append("</tr></table><br>");

            sb.Append("<table cellspacing=2 cellpadding=2><tr>");


            DataRow dr = null;
            businessDataRow = listDataTable.Rows[0];
            tagManger.BusinessDataRow = businessDataRow;
            for (i = 0; i < parentProg.Subprograms.Rows.Count; i++)
            {
                dr = parentProg.Subprograms.Rows[i];
                xml = dr["xml"].ToString();

                if (StringHelper.GetXmlValue(xml, "弹出窗口") == "1" && dr["glcxid"].ToString()!="")
                {
                    primaryKey = StringHelper.GetXmlValue(xml, "主键");
                    foreignKey = StringHelper.GetXmlValue(xml, "外键");

                    relationCondition = dr["gltj"].ToString();

                    url = foreignKey + "='" + businessDataRow[primaryKey] + "'";

                    if (relationCondition != "")
                        url += " and " + tagManger.ReplaceExpression(relationCondition, "colval");

                    url = "&cond=" + DataManager.Encrypt(url);
                    url = wwwroot + tagManger.ReplaceExpression(dr["glcx"].ToString(), "colval") + "&relationFlag=true&parentid=" + instManager.ParentID + "&parentvalue=" + instManager.ParentPrimaryKeyValue + url;


                    sb.Append("<td><a");

                    if (dr["glcxid"].ToString() == menuId)
                        sb.Append(" disabled");
                    else
                        sb.Append(" href=\"" + url + "\" style='color:blue'");


                    sb.Append(">" + dr["glms"].ToString() + "</a></td>");

                }



            }


            sb.Append("</tr></table>");

        }

        //2014-02-23 去除else
        for (i = 0; i < subProgramCount; i++)
        {

            xml = pm.Subprograms.Rows[i]["xml"].ToString();

            if (StringHelper.GetXmlValue(xml, "同页显示") == "1")
            {
                displaySubprogramCount++;
            }
        }





        sb.Append("<table class='list_table' border=0 cellspacing='0' cellpadding='0' style='width:100%;font-size:12px;border:0px;z-index:-1;' align='center' >");


        bool bSetBgcolor = false;
        string[] arr_bgcolor = new string[1];
        s = pm.Properties["JLYSSZ"].ToString();

        if( s!= "")
        {
            bSetBgcolor = true;
            arr_bgcolor = s.Split(';');
        }



        if(! CustomTableHead( context,sb, pm, listElements))
            GetTableHead(sb, pm, listElements);


        j = 2;


        //fujianxianshi = aco.mt.FlowMemo
        string guanjianziduan = pm.Properties["gjzd"].ToString();

        listDataTable = instManager.GetMulitRecordDataTable();
        listDataTable.TableName = instManager.Program.ListTableName;
        int rowIndex = 0;
        DataRow row = null;
        string fieldName;
        string val;

        string elementId;
        string fontcolor="";

        ControlManager control = new ControlManager(instManager);
        int c=listDataTable.Rows.Count;
        businessDataRow = null;
        string trclass,yc;
        for (int idx = 0; idx < c;idx++ )
        {
            businessDataRow = listDataTable.Rows[idx];
            tagManger.BusinessDataRow = businessDataRow;
            str_bg = "#000000";

            primaryKeyValue = businessDataRow[guanjianziduan].ToString();

            trclass = (rowIndex % 2 == 0 ? "list_table_tr_odd" : "list_table_tr_eve");

            if (bSetBgcolor)
            {
                for (i = 0; i < arr_bgcolor.Length; i++)
                {
                    arr_temp = arr_bgcolor[i].Split(',');

                    if (instManager.MeetTheCondition(tagManger.ReplaceExpression(arr_temp[0], ""), primaryKeyValue))
                    {
                        str_bg = arr_temp[1];
                        break;
                    }
                }
            }


            sb.Append("<tr class='list_table_tr "+trclass+"' rowtype=" + (rowIndex % 2).ToString() + " style='color:" + str_bg + ";'><td width=1 "+(fixedcolumns==0?"":" class='fixedp fixedc "+ trclass+"'")+"><input onclick=\"selectpk(this.checked,'"+primaryKeyValue+"')\" type='checkbox' name='cheSelectRecordID' id='cheSelectRecordID' "+(spk.Contains(","+primaryKeyValue+",")?"checked":"")+" value='" + primaryKeyValue + "' ></td>");
            if (displaySubprogramCount != 0)
                sb.Append("<td width=1 "+(fixedcolumns==0?"":" class='fixedp fixedc " + trclass + "'")+"><img id=rel_img" + rowIndex.ToString() + " src='../images/cat.gif' style='cursor:pointer' onclick='rel_displayProg(" + rowIndex.ToString() + ")'></td>");



            for (i = 0; i < elementsCount; i++)
            {
                row = listElements.Rows[i];
                if (row["YC"].ToString() != "1")
                {
                    control.Init(businessDataRow, row);
                    elementType = control.ControlType;
                    elementId = control.ControlID;
                    fieldName = control.FieldName;
                    tjfs = row["TJFS"].ToString();
                    control.Display = true;

                    yc = "";

                    if (elementType == "46")
                    {
                        s2 = row["QZZD"].ToString();
                        rows = listElements.Select("kjid=" + s2.Substring(2, s2.Length - 4));
                        s2 = StringHelper.GetRightString(rows[0]["dyzd"].ToString());
                        s2 = businessDataRow[s2].ToString();
                        control.GetDataField = s2;
                    }

                    if (instManager.FieldPopedom.AllowRead(fieldName))
                        val = control.Text;
                    else
                        val = "******";

                    val = val.Replace("\r\n", "<br/>");

                    s = control.GetParamValue("setcolor", "");
                    if (s != "")
                    {
                        arr_temp = s.Split(',');
                        s = tagManger.ReplaceExpression(arr_temp[1], "COLVAL");
                        dt1 = new DataTable();
                        if ((bool)dt1.Compute(s, ""))
                        {
                            fontcolor = "color:" + arr_temp[0] + ";";
                        }
                        else
                        {
                            fontcolor = "";
                        }
                    }
                    else
                    {
                        fontcolor = "";
                    }

                    sb.Append("<td title='" + control.ControlDescription + "' ");


                    if (fixedcolumns > i)
                        sb.Append("class='" + trclass + " fixedp fixedc'");


                    sb.Append(" style ='" + yc + "" + control.ControlStyle + ";" + fontcolor + "' ondblclick='DblClickRow(this);' onclick=\"selectRow(this);");
                    if (hasEditPopedom == "True")
                        sb.Append("editCell(this,'" + primaryKeyValue + "','" + control.ControlStyle + "','" + menuId + "','" + elementType + "','" + control.DefatuleValue + "',event);");

                    sb.Append("\">");


                    if (elementType == "140")
                    {


                        if (val != "")
                        {
                            param = control.GetParamValue("filename", "附件");

                            isExistDownload = true;
                            arr_temp = val.Split('|');
                            web = "";
                            ii = arr_temp.Length;
                            for (j = 0; j < ii; j++)
                            {
                                s = arr_temp[j];
                                if (s != "")
                                {


                                    if (s.IndexOf("*") != -1)
                                    {
                                        arr_temp1 = s.Split('*');
                                        if (arr_temp1[0] == "w")
                                        {
                                            web = arr_temp1[1];
                                            s3 = arr_temp1[3];
                                        }
                                        else
                                        {
                                            s3 = arr_temp1[1];
                                            s = (web == "" ? "" : "w*" + web + "*0*") + s;
                                        }
                                        s3 = s3.Substring(s3.LastIndexOf("/") + 1);
                                        s3 = s3.Substring(0, s3.LastIndexOf("."));
                                        if (param == "filename")
                                        {
                                            s2 = s3;
                                        }
                                        else
                                        {
                                            s2 = param + (j + 1).ToString();
                                        }
                                        sb.Append("<a href='javascript:void(0);' onclick='getFile3(\"" + s + "\",event)'  style='color:blue' title='" + s3 + "'>" + s2 + "</a>");
                                    }
                                    else
                                    {

                                        if (param == "filename")
                                        {
                                            s2 = s.Substring(s.LastIndexOf("/") + 1);
                                            s2 = s2.Substring(0, s2.LastIndexOf("."));
                                            sb.Append("<a href='javascript:void(0);' onclick='getFile1(\"" + menuId + "\",\"" + primaryKeyValue + "\",\"" + elementId + "\",\"" + j.ToString() + "\")'  style='color:blue' title='" + s2 + "'>" + s2 + "</a>");
                                        }
                                        else
                                        {
                                            sb.Append("<a href='javascript:void(0);' onclick='getFile1(\"" + menuId + "\",\"" + primaryKeyValue + "\",\"" + elementId + "\",\"" + j.ToString() + "\")'  style='color:blue' title='" + s.Substring(s.LastIndexOf("/") + 1) + "'>" + param + (j + 1).ToString() + "</a>");
                                        }
                                    }
                                }

                                if (j != ii - 1)
                                    sb.Append("&nbsp;&nbsp;&nbsp;&nbsp;");
                            }
                        }
                    }
                    else if (elementType == "42")
                    {
                        if (val != "")
                        {
                            arr_temp = val.Split('*');
                            sb.Append("<a href='" + wwwroot + arr_temp[0] + "/" + arr_temp[2] + arr_temp[1] + "' target='_blank'><img border='0' src='" + wwwroot + arr_temp[0] + "/" + arr_temp[2] + "_s" + arr_temp[1] + "'></a>");
                        }
                    }
                    else if (elementType == "142")
                    {
                        if (val != "")
                        {
                            sb.Append("<a href='javascript:void(0);' style='color:blue;' onclick=\"getFileDoc('" + val + "');\">查看</a>");
                        }
                    }
                    else if (elementType == "3")
                    {
                        j = int.Parse(control.GetParamValue("maxlength", "0"));
                        if (j != 0 && val.Length > j)
                            s = val.Substring(0, j) + "..";
                        else
                            s = val;
                        sb.Append("<a href='javascript:void(0);' onclick=\"ObjectDisplay('" + control.GetDataField + "','" + control.Value + "');\"  style='color:blue' title=\"" + val + "\">" + s + "</a>");
                    }
                    else if (elementType == "46")
                    {
                        j = int.Parse(control.GetParamValue("maxlength", "0"));
                        if (j != 0 && val.Length > j)
                            s = val.Substring(0, j) + "..";
                        else
                            s = val;

                        sb.Append("<a href='javascript:void(0);' onclick=\"ObjectDisplay('" + control.GetDataField + "','" + control.Value + "');\"  style='color:blue' title=\"" + val + "\">" + s + "</a>");
                    }
                    else if (elementType == "45")
                    {
                        arr_temp = control.Value.Split(',');
                        arr_temp1 = val.Split(',');
                        for (j = 0; j < arr_temp.Length; j++)
                        {
                            s = arr_temp[j];
                            if (s.IndexOf("$") == -1)
                            {
                                s2 = control.GetParamValue("objlist", row["QZZD"].ToString());
                                if (s2.IndexOf(",") != -1) s2 = s2.Split(',')[0];
                                sb.Append((j == 0 ? "" : "&nbsp;") + "<a href='javascript:void(0);' onclick=\"ObjectDisplay('" + s2 + "','" + arr_temp[j] + "');\"  style='color:blue' >" + arr_temp1[j] + "</a>");
                            }
                            else
                            {
                                sb.Append((j == 0 ? "" : "&nbsp;") + "<a href='javascript:void(0);' onclick=\"ObjectDisplay('" + StringHelper.GetLeftString(s, "$") + "','" + StringHelper.GetRightString(s, "$") + "');\"  style='color:blue' >" + arr_temp1[j] + "</a>");
                            }
                        }
                    }
                    else
                    {
                        if (sTJFS != "" && double.TryParse(val, out var_num))
                        {

                            arr_temp = tjfs.Split(',');

                            for (j = 0; j < arr_temp.Length; j++)
                            {
                                switch (arr_temp[j])
                                {
                                    case "Total":
                                        var_sum[i] = var_sum[i] + var_num;
                                        break;

                                    case "Average":
                                        var_avg[i] = var_avg[i] + var_num;
                                        break;

                                    case "Max":
                                        if (var_num > var_max[i])
                                            var_max[i] = var_num;
                                        break;

                                    case "Min":
                                        if (var_num < var_min[i])
                                            var_min[i] = var_num;
                                        break;
                                }
                            }
                        }
                        if (control.FieldName.ToLower() != "ztms")
                        {
                            s = control.GetParamValue("url", "");
                            if (s != "")
                            {
                                s = tagManger.ReplaceExpression(s, "ColVal");
                                s2 = control.GetParamValue("urldesc", val);
                                s3 = control.GetParamValue("cond", "");
                                s4 = control.GetParamValue("urldisplay", "");
                                b1 = true;
                                if (s4 != "")
                                {
                                    s4 = tagManger.ReplaceExpression(s4, "ColVal");

                                    DataTable eval = new DataTable();
                                    b1 = (bool)eval.Compute(s4, "");
                                    val = "";

                                }

                                if (b1)
                                {
                                    if (s3 != "")
                                    {
                                        s3 = tagManger.ReplaceExpression(s3, "ColVal");
                                        s3 = DataManager.Encrypt(s3);
                                        s += (s.Contains("?") ? "&" : "?") + "cond=" + s3;
                                    }

                                    s3 = control.GetParamValue("para", "");

                                    if (s3 != "")
                                    {
                                        s3 = s3.Replace("&", ";");
                                        s3 = tagManger.ReplaceExpression(s3, "ColVal");



                                        s3 = DataManager.UrlEncode(s3);


                                        s += ((s.Contains("?") ? "&" : "?") + "cpara=" + s3);

                                        //if (context.Session["usercnname"].ToString() == "系统用户")
                                        //{
                                        //    context.Response.Write(s);
                                        //    context.Response.End();
                                        //}
                                    }
                                    if (val == "")
                                        sb.Append("<a href='javascript:void(0);' style='" + (fontcolor == "" ? "color:blue;" : fontcolor) + "' cfg=\"" + s + "\" onclick=\"listopenurl(this.getAttribute('cfg'))\">" + s2 + "</a>");
                                    else
                                        sb.Append("<a href='javascript:void(0);' style='" + (fontcolor == "" ? "color:blue;" : fontcolor) + "' cfg=\"" + s + "\" onclick=\"listopenurl(this.getAttribute('cfg'))\">" + val + "</a>");
                                }
                                else
                                {
                                    sb.Append("&nbsp;");
                                }
                            }
                            else
                            {
                                j = int.Parse(control.GetParamValue("maxlength", "0"));
                                if (j != 0 && val.Length > j)
                                    sb.Append("<a title=\"" + val + "\">" + val.Substring(0, j) + "..</a>");
                                else
                                    sb.Append(val);

                            }
                        }
                        else
                        {
                            if (control.GetParamValue("ztms", "1") == "1")
                                sb.Append("<a href='javascript:void(0);' onclick=\"openFlowLog('" + menuId + "','" + primaryKeyValue + "');\" style='color:blue'>" + val + "</a>");
                            else
                                sb.Append(val);

                        }



                    }

                    sb.Append("</td>");
                }
            }


            l = pm.Subprograms.Rows.Count;
            for (i = 0; i < l; i++)
            {
                row = pm.Subprograms.Rows[i];
                xml = row["xml"].ToString();

                if (StringHelper.GetXmlValue(xml, "弹出窗口") == "1")
                {
                    url = tagManger.ReplaceExpression(row["glcx"].ToString(), "ColVal");
                    ii=url.IndexOf(";");
                    if (ii!=-1)
                    {
                        s3 = StringHelper.GetParamValue(url+";","para");
                        url = url.Substring(0, ii);

                        if (s3!="")
                        {
                            s3=tagManger.ReplaceExpression(s3, "ColVal");
                            s3 = s3.Replace("&", ";");
                            url += "&cpara=" + DataManager.UrlEncode(s3);
                        }
                        //context.Response.Write(url);
                        //context.Response.End();

                    }


                    relationDesc = row["glms"].ToString();

                    primaryKey = StringHelper.GetXmlValue(xml, "主键");
                    foreignKey = StringHelper.GetXmlValue(xml, "外键");

                    relationCondition = row["gltj"].ToString();


                    if (relationCondition != "")
                        relationCondition = tagManger.ReplaceExpression(relationCondition, "ColVal");
                    else
                        relationCondition = "1=1";


                    if (primaryKey != "" && foreignKey != "")
                    {
                        subPrimaryKeyValue = businessDataRow[primaryKey].ToString();
                        relationCondition = foreignKey + "='" + subPrimaryKeyValue + "' and " + relationCondition;
                    }

                    //if Parameter <> "" then Parameter = o.tag.ReplaceExpression(Parameter,"ColVal")

                    //显示从表的记录数，即关联程序描述为字段名的时候

                    //If InStr(1, str_selectpart, "." & relationDesc & ",") > 0 Then
                    //    relationDesc = relationDesc & "(" & o.UserRecordsetValue(relationDesc) & ")"
                    // End If

                    if (primaryKey != "")
                    {
                        if (businessDataRow[primaryKey].ToString() == "") relationDesc = "";
                    }

                    if (url.Substring(0, 2) != "js")
                    {
                        if (relationCondition != "1=1")
                        {
                            // url += "&strcondition=" + context.Server.UrlEncode(relationCondition);
                            if (relationCondition != "") relationCondition += "   ";
                            url += "&cond=" + DataManager.Encrypt(relationCondition);
                        }

                        if (primaryKey != "")
                            url += "&relationFlag=true&parentid=" + menuId + "&parentvalue=" + primaryKeyValue + "&ForeignKey=" + foreignKey + "&PrimaryKeyValue=" + businessDataRow[primaryKey].ToString();

                        if (url.Substring(0, 1) == "/")
                        {
                            url = wwwroot + url;
                            reltype = "0";
                        }
                        else if (url.Substring(0, 1) == ":")
                        {
                            reltype = "1";
                        }
                        else
                        {
                            reltype = "0";
                        }

                        sb.Append("<td><a id='rel_" + j + "' reltype='" + reltype + "' url=\"" + url + "\" href='javascript:void(0);' style='color:blue;' onclick='relprogram(this);'>" + relationDesc + "</a></td>");
                    }
                    else
                    {
                        sb.Append("<td><a id=\"rel_" + j + "\"  href=\"javascript:void(0);\" style=\"color:blue;\" onclick=\"" + url.Substring(3) + "\">" + relationDesc + "</a></td>");
                    }


                }
            }

            sb.Append("</tr>");

            if (displaySubprogramCount != 0)
            {

                sb.Append("<tr id=rel_tr" + rowIndex.ToString() + " style='display:none'><td></td><td></td><td  colspan=" + (elementsCount + displaySubprogramCount) + "><table><tr>");
                j = 0;
                for (i = 0; i < subProgramCount; i++)
                {
                    row = pm.Subprograms.Rows[i];
                    xml = row["xml"].ToString();

                    if (StringHelper.GetXmlValue(xml, "同页显示") == "1")
                    {
                        primaryKey = StringHelper.GetXmlValue(xml, "主键");
                        foreignKey = StringHelper.GetXmlValue(xml, "外键");

                        relationCondition = row["gltj"].ToString();


                        if (relationCondition != "")
                            relationCondition = tagManger.ReplaceExpression(relationCondition, "ColVal");
                        else
                            relationCondition = "1=1";


                        if (primaryKey != "" && foreignKey != "")
                            relationCondition = foreignKey + "='" + businessDataRow[primaryKey].ToString() + "' and " + relationCondition;


                        sb.Append("<td id='rel_td_desc_" + rowIndex.ToString() + "_" + j.ToString() + "' style='cursor:pointer;border:0px;' progid=" + pm.Subprograms.Rows[i]["glcxid"].ToString() + " condition=\"" + relationCondition + "\" onclick=\"rel_loadlist(" + rowIndex.ToString() + ",this.getAttribute('progid'),this.getAttribute('condition'));\"><div id='r_d_" + rowIndex.ToString() + "_" + pm.Subprograms.Rows[i]["glcxid"].ToString() + "' style='padding:4px;border-radius:4px;'>" + pm.Subprograms.Rows[i]["glms"].ToString() + "</div></td>");
                        j++;
                    }
                }

                sb.Append("</tr></table><div  id=rel_td" + rowIndex.ToString() + " ></div><br>&nbsp;</td></tr>");

            }

            rowIndex++;
        }





        if (sTJFS != "")
        {
            //if (instManager.CurrentPage == instManager.PageCount)  //'最后一页需要统计
            if(true)
            {

                s = pm.ListTableName;
                str = "";
                for (i = 1; i < elementsCount; i++)
                {
                    if (listElements.Rows[i]["YC"].ToString() != "1")
                    {
                        tjfs = listElements.Rows[i]["tjfs"].ToString();
                        if (tjfs != "")
                        {
                            arr_temp = tjfs.Split(',');
                            fieldName = listElements.Rows[i]["dyzd"].ToString();

                            for (j = 0; j < arr_temp.Length; j++)
                            {
                                switch (arr_temp[j])
                                {
                                    case "Total":
                                        str = str + ",sum(" + fieldName + ") as 总计" + i.ToString();
                                        break;
                                    case "Average":
                                        str = str + ",avg(" + fieldName + ") as 平均值" + i.ToString();
                                        break;
                                    case "Max":
                                        str = str + ",max(" + fieldName + ") as 最大值" + i.ToString();
                                        break;
                                    case "Min":
                                        str = str + ",min(" + fieldName + ") as 最小值" + i.ToString();
                                        break;
                                    case "Count":
                                        str = str + ",count(" + fieldName + ") as 记录数" + i.ToString();
                                        break;
                                }
                            }
                        }
                    }
                }

                if (str != "")
                {
                    str = str.Substring(1);
                    str = "select " + str + " from " + pm.ListTableName + " where " + instManager.ListSqlWhere ;
                    DataTable  dtr = instManager.BusinessDataManager.ExecuteTable(str);


                    arr_temp = sTJFS.Split(new char[]{';'},StringSplitOptions.RemoveEmptyEntries);

                    if (displaySubprogramCount > 0)
                        colspan = 3;
                    else
                        colspan = 2;

                    for (j = 0; j < arr_temp.Length; j++)
                    {
                        arr_temp1 = arr_temp[j].Split(',');

                        tjfs = arr_temp1[5];  //' 名称

                        sb.Append("<tr bgcolor=ffffff><td colspan=" + colspan + " align=center>" + tjfs + "</td>");

                        for (i = 1; i < elementsCount; i++)
                        {
                            if (listElements.Rows[i]["YC"].ToString() != "1")
                            {
                                sb.Append("<td align='right'>");


                                s = listElements.Rows[i]["YS"].ToString();//格式化样式
                                for (k = 0; k < dtr.Columns.Count; k++)
                                {
                                    if (dtr.Columns[k].ColumnName == (tjfs + i.ToString()))
                                    {
                                        //if (arr_temp1.Length == 5)
                                        sb.Append(Format(s, dtr.Rows[0][k].ToString()));
                                        //else
                                        //sb.Append(Math.Round(r.GetDecimal(k), int.Parse(arr_temp1[6])));
                                    }
                                }

                                sb.Append("</td>");
                            }
                        }

                        for (i = 0; i < openSubprogramCount; i++)
                            sb.Append("<td></td>");

                        sb.Append("</tr>");
                    }
                }
            }
            else
            {
                arr_temp = sTJFS.Split(new char[]{';'},StringSplitOptions.RemoveEmptyEntries);
                if (displaySubprogramCount > 0)
                    colspan = 3;
                else
                    colspan = 2;

                for (j = 0; j < arr_temp.Length; j++)
                {

                    arr_temp1 = arr_temp[j].Split(',');

                    tjfs = arr_temp1[5];   //' 名称

                    if (tjfs == "总计")
                        tjfs = "小计";

                    sb.Append("<tr bgcolor=ffffff><td colspan=" + colspan + "  align=center>" + tjfs + "</td>");

                    for (i = 1; i < elementsCount; i++)
                    {
                        if (listElements.Rows[i]["YC"].ToString() != "1")
                        {
                            sb.Append("<td align='right'>");

                            s = listElements.Rows[i]["YS"].ToString();//格式化样式
                            switch (tjfs)
                            {
                                case "小计":
                                    if (var_sum[i] != 0)
                                        sb.Append(Format(s, var_sum[i].ToString()));
                                    else
                                        sb.Append("&nbsp;");

                                    break;

                                case "最大值":
                                    if (var_max[i] != double.MinValue)
                                        sb.Append(Format(s, var_max[i].ToString()));
                                    else
                                        sb.Append("&nbsp;");

                                    break;

                                case "最小值":
                                    if (var_min[i] != double.MaxValue)
                                        sb.Append(Format(s, var_min[i].ToString()));
                                    else
                                        sb.Append("&nbsp;");

                                    break;
                            }

                            sb.Append("</td>");
                        }
                    }

                    for (i = 0; i < openSubprogramCount; i++)
                        sb.Append("<td></td>");

                    sb.Append("</tr>");
                }
            }
        }

        sb.Append("</table><br />");


        //<ui-bottom>
        sb.Append("</div></div>"); //div_content

        string pagebuttoms = "";

        if (instManager.PageCount <= 1)
        {
            pagebuttoms = "<div class='page_button'>&lt;</div><div class='page_button_c' >1</div><div class='page_button'>&gt;</div>";
        }
        else
        {
            pagebuttoms = "<div class='page_button'><i class='fa fa-angle-left' aria-hidden='true'></i></div><div class='page_button' >1</div><div class='page_button' >2</div><div class='page_button' >…</div><div class='page_button_c' >"+instManager.CurrentPage+"</div><div class='page_button' >…</div><div class='page_button' >"+(instManager.PageCount-1).ToString()+"</div><div class='page_button' >"+instManager.PageCount.ToString()+"</div><div class='page_button'><i class='fa fa-angle-right ' aria-hidden='true'></i></div>";
        }

        sb.Append("<div style='padding:10px;'><div id='datalist_bottom' class='datalist_bottom'><div style='float:left;width:20%;height:26px;'><div style='float:left;font-size:14px;line-height:26px;'>每页显示</div>");
        sb.Append("<div style='float:left;padding-left:4px;height:26px;'><select onchange='em_lt_psize_change(this.value)' style='color:white;border: solid 1px #2B9F7A;font-size:14px;background-color:#2B9F7A;border-radius:4px;'>");
        string[] asize = new string[] { "10","30","50" };

        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:left;text-align:center;width:60%;height:26px;' class='page_buttons'>"+pagebuttoms+"</div><div style='float:right;width:20%;'>");

        sb.Append("<div style='float:right;height:26px;'><input type='text' style='border:solid 1px #2B9F7A;background-color:#ffffff;border-radius:4px 0px 0px 4px;width:30px;font-size:10px;height:18px;'><input type='text' style='width:20px;border:solid 1px #2B9F7A;height:18px; font-size:10px;background-color:#2B9F7A;color:white;border-radius:0px 4px 4px 0px;text-align:center;' value='GO'></div>");

        sb.Append("<div style='float:right;color:#666666;font-size:14px;padding-right:10px;height:26px;line-height:26px;'>共" + instManager.RecordCount + "条</div></div>");
        sb.Append("<div style='clear:both;'></div></div></div>");

        //</ui-bottom>



        sb.Append("</body>");
        sb.Append("</html>");
        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_setsize();");
    
        if(isExistDownload)
            sb.Append("addButton('批量下载附件','down.png','getFilesPackage();');");

        //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>");

        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;
        }
    }
}