<%@ 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
{

    public void ProcessRequest (HttpContext context)
    {
        //context.Response.Redirect("ListGroup.ashx");

        string menuId = context.Request.QueryString["proid"].ToString();
        string userId = context.Session["userid"].ToString();

        string wwwroot = context.Request.ApplicationPath;
        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();
        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;
        int elementsCount = listElements.Rows.Count;
        int subprogramCount = pm.Subprograms.Rows.Count;
        int i,l,j,k;
        string s,s2,s3;
        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;

        string mini = (context.Request.QueryString["mini"]==null ? instManager.GetStateValue("mini") : context.Request.QueryString["mini"].ToString());

        if (context.Request.QueryString["strcondition"] !=null)
            instManager.DefaultCondition = context.Request.QueryString["strcondition"].ToString();

        if (context.Request.QueryString["QueryCondition"] != null)
            instManager.QueryCondition = context.Request.QueryString["QueryCondition"].ToString();

        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 (buttonGroupId != "")
        {
            instManager.ButtonGroupID = buttonGroupId;
        }


        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";
            else
                str = "style='cursor:pointer;'";
            if (instManager.CurrentPage == instManager.PageCount)
                str1 = "disabled";
            else
                str1 = "style='cursor:pointer;'";

            pagec = "<div style='width:100%;'><table style='color:#000000;' cellspacing=2 cellpadding=2 align=right height='24'><tr><td onclick='MoveFirst();' " + str + ">首页</td><td>|</td><td onclick='MovePrevious();' " + str + ">上一页</td><td>|</td><td onclick='MoveNext();' " + str1 + ">下一页</td><td>|</td><td onclick='MoveLast();' " + str1 + ">末页</td></tr></table></div>";
        }
        else
        {
            pagec = "&nbsp;";
        }

        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("<html>");
        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 + "'");
        }
        sb.Append(",CustomAction={" + pm.Properties["LJGJZD"].ToString() + "},Mini='" + mini + "',ParentValue='" + instManager.ParentPrimaryKeyValue + "',MultiDataSetCfg='',allowEdit='" + instManager.HasEditPopedom().ToString() + "',programJson={" + pm.Properties["json"].ToString() + "}</script>");

        sb.AppendLine("<script type='text/javascript' src='Scripts/common.js?15090622'></script>");
        sb.AppendLine("<script type='text/javascript' src='Scripts/kernel.js?15100922'></script>");
        sb.AppendLine("<link rel='stylesheet' href='../Css/Common.css' type='text/css'>");
        sb.AppendLine("<link rel='stylesheet' href='../Css/Default.css' type='text/css'>");
        sb.AppendLine("<link rel='stylesheet' href='" + ThemePath + "/web.css' type='text/css'>");
        sb.AppendLine("<STYLE TYPE='text/css' id=listpagestyle>");
        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;}");
        sb.AppendLine("#TABLE1 td{ border:solid 1px #cccccc; } ");
        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 style='margin:0px;overflow:hidden;' onresize=\"g('div_content').style.width='100%'\" oncontextmenu='//return false;'>");


        //<ui-head>
        
        sb.Append("<table cellspacing=0 cellpadding=0 width=100% height=5><tr><td></td></tr></table>");
        sb.Append("<table cellspacing=0 cellpadding=0 width=100% bgcolor='#EAF1FB' height=30 ><tr>");
        sb.Append("<td width=5 bgcolor='#EEEEEE'></td>");
        sb.Append("<td style='border: solid 1px #BDCFE3;'>");


        if (buttonGroupId == "")
            buttonGroupId = instManager.ButtonGroupID;

        string tempStr;

        if (buttonGroupId != "")
        {
            tempStr = "<table border=0 cellspacing=0 cellpadding=2><tr>";

            tempStr += "<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>";

            ToolBar toolbar = new ToolBar(sysData);

            sb.Append(toolbar.GetHtml(buttonGroupId, "查询", tempStr, wwwroot, instManager.MenuID, userId));
        }


        sb.Append("</td><td width=5 bgcolor='#EEEEEE'></td></tr></table>");

        string pageHeight = "0";
        if (mini == "")
        {
            pageHeight = "30";

            sb.Append("<table cellspacing=0 cellpadding=0 width=100% bgcolor='EEEEEE'><tr>");
            sb.Append("<td width=5 height='30'></td>");
            sb.Append("<td width=20 ><img src='" + ThemePath + "/list.png'></td><td width=180   style='font-size:14px;font-weight:bold;color:#555555;' ondblclick='getListWhere();'>" + pageTitle + "</td>");
            sb.Append("<td width=5></td>");
            sb.Append("<td >" + pagec + "</td>");
            sb.Append("</tr></table>");

        }

        sb.Append("<table cellspacing=0 cellpadding=0 border=0 width=100% height=1><tr><td width=5 ></td><td bgcolor=#ffffff><img src='../images/p.gif'></td><td width=5 ></td></tr></table>");
        sb.Append("<table cellspacing=0 cellpadding=0 border=0 style='width:100%;'><tr><td style='width:5px;'><img src='../images/p.gif'></td><td valign='top' style='background-color:#F7FFFF;background-image:url(" + ThemePath + "/list_back.png);background-repeat:no-repeat;background-position-x:center;background-position-y:center;'><div id='div_content' style='width:100%;overflow:auto;' >");


        //</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)
        {

            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 class=the_list_search width=100% ><tr>");
            sb.Append("<td width=99><img src='" + ThemePath + "/list_search_title.gif'></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%;background-color:#EEF1F9;padding:2px;border-color: #cccccc; border-style: solid; border-width: 1px;'>");
            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")
                        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;'>" + cm.ControlDescription + ":<select style='display:none;' name=ysf" + cm.ControlID + ">" + sYSF + "</select></td>");
                sb.Append("<td>" + 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>");

        }


        int displaySubprogramCount = 0;
        int openSubprogramCount = 0;

        //主表程序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]["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]["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 = "&strCondition=" + 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 id='TABLE1' border=1 cellspacing='0' cellpadding='4' style='BORDER-COLLAPSE: collapse' bordercolor='#cccccc' align='center'  width='100%'>");


        bool bSetBgcolor = false;
        string[] arr_bgcolor = new string[1];
        s = pm.Properties["JLYSSZ"].ToString();

        if( s!= "")
        {
            bSetBgcolor = true;
            arr_bgcolor = s.Split(';');
        }




        sb.Append("<tr align=center class=the_list_tr_desc><td width=1><input id='cheSelectRecordID' name='cheSelectRecordID' onclick='SelectAllRecordID(this)' value='' type='checkbox' ></td>");
        if (displaySubprogramCount > 0)
            sb.Append("<td width=1></td>");

        string[,] displayformat = new string[elementsCount,1];

        string yc;
        string joinCellJs = "";
        for(i=0;i< elementsCount;i++)
        {
            s = listElements.Rows[i]["YS"].ToString();
            yc = (listElements.Rows[i]["YC"].ToString() == "1" ? "display:none;" : "");
            if (listElements.Rows[i]["HB"].ToString() == "1")
                joinCellJs = "UniteCol(" + (i+1).ToString() + ",0);"+joinCellJs;

            sb.Append("<td style='" + s + ";cursor:pointer;" + yc + ";' 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);
        }

        l = pm.Subprograms.Rows.Count;

        for(i =0;i<l;i++)
        {
            xml = pm.Subprograms.Rows[i]["xml"].ToString();

            if(StringHelper.GetXmlValue(xml,"弹出窗口") == "1")
            {
                sb.Append("<td>" + pm.Subprograms.Rows[i]["glms"].ToString() + "</td>");
            }
        }
        sb.Append("</tr>");

        j = 2;


        //fujianxianshi = aco.mt.FlowMemo
        string guanjianziduan = pm.Properties["gjzd"].ToString();

        listDataTable = instManager.GetMulitRecordDataTable();
        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;
        for (int idx = 0; idx < c;idx++ )
        {
            businessDataRow = listDataTable.Rows[idx];
            tagManger.BusinessDataRow = businessDataRow;
            str_bg = "#000000";

            primaryKeyValue = businessDataRow[guanjianziduan].ToString();


            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='the_list_tr" + (rowIndex % 2).ToString() + "' rowtype=" + (rowIndex % 2).ToString() + " style='color:" + str_bg + ";' onmouseover='MouseOver(this);' onmouseout='MouseOut(this);'><td width=1><input type='checkbox' name='cheSelectRecordID' id='cheSelectRecordID' value='" + primaryKeyValue + "' ></td>");
            if (displaySubprogramCount != 0)
                sb.Append("<td width=1><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];
                control.Init(businessDataRow, row);
                elementType = control.ControlType;
                elementId = control.ControlID;
                fieldName = control.FieldName;
                tjfs = row["TJFS"].ToString();
                control.Display = true;

                yc = (row["YC"].ToString() == "1" ? "display:none;" : "");
                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 + "' style='" + yc + "" + control.ControlStyle + ";" + fontcolor + "' ondblclick='DblClickRow(this);' onclick=\"selectRow(this);editCell(this,'" + primaryKeyValue + "','" + control.ControlStyle + "','" + menuId + "','" + elementType + "','"+control.DefatuleValue+"',event)\">");


                if (elementType == "140")
                {


                    if (val != "")
                    {
                             isExistDownload = true;
                        arr_temp = val.Split('|');

                        for (j = 0; j < arr_temp.Length; j++)
                        {
                            s = arr_temp[j];
                            if (s != "")
                            {
                                s2 = control.GetParamValue("filename", "附件");

                                if (s.IndexOf("*") != -1)
                                {
                                    s3 = s.Split('*')[1];
                                    s3 = s3.Substring(s3.LastIndexOf("/") + 1);
                                    s3 = s3.Substring(0,s3.LastIndexOf("."));
                                    if (s2 == "filename")
                                    {
                                        s2 = s3;
                                    }
                                    else
                                    {
                                        s2 = s2 + (j + 1).ToString();
                                    }
                                    sb.Append("<a href='javascript:void(0);' onclick='getFile3(\"" + s + "\",event)'  style='color:blue' title='" + s3 + "'>"+ s2 + "</a>");
                                }
                                else
                                {

                                    if (s2 == "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) + "'>" + s2 + (j + 1).ToString() + "</a>");
                                    }
                                }
                            }

                            sb.Append(" ");
                        }
                    }
                }
                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 == "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('" + row["QZZD"].ToString() + "','" + 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++)
                    {

                        sb.Append((j == 0 ? "" : "&nbsp;") + "<a href='javascript:void(0);' onclick=\"ObjectDisplay('" + row["QZZD"].ToString() + "','" + arr_temp[j] + "');\"  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");
                            sb.Append("<a href='javascript:void(0);' style='"+(fontcolor==""?"color:blue;":fontcolor)+"' onclick=\"WinOpenNew('" + s + "','controlurl')\">" + val + "</a>");
                        }
                        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
                    {
                        sb.Append("<a href='javascript:void(0);' onclick=\"openFlowLog('" + menuId + "','" + primaryKeyValue + "');\" style='color:blue'>" + val + "</a>");
                    }



                }

                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");

                    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

                    url += "&strCondition=" + context.Server.UrlEncode(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";
                    }


                    if (primaryKey != "")
                    {
                        if (businessDataRow[primaryKey].ToString() == "") relationDesc = "";
                    }

                    sb.Append("<td><a id='rel_" + j + "' reltype='" + reltype + "' url=\"" + url + "\" href='javascript:void(0);' style='color:blue;' onclick='relprogram(this);'>" + 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>");

                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() + "_" + i.ToString() + "'style='cursor:pointer;' progid=" + pm.Subprograms.Rows[i]["glcxid"].ToString() + " condition=\"" + relationCondition + "\" onclick=\"rel_loadlist(" + rowIndex.ToString() + ",this.getAttribute('progid'),this.getAttribute('condition'));\">" + pm.Subprograms.Rows[i]["glms"].ToString() + "</td>");
                    }
                }

                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++)
                {
                    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 ;
                    DbDataReader r = instManager.BusinessDataManager.ExecuteReader(str);
                    r.Read();

                    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++)
                        {
                            sb.Append("<td align='right'>");
                            s = listElements.Rows[i]["YS"].ToString();//格式化样式
                            for (k = 0; k < r.FieldCount; k++)
                            {
                                if (r.GetName(k) == (tjfs + i.ToString()))
                                {
                                    //if (arr_temp1.Length == 5)
                                    sb.Append(Format(s,r[k].ToString()));
                                    //else
                                    //sb.Append(Math.Round(r.GetDecimal(k), int.Parse(arr_temp1[6])));
                                }
                            }

                            sb.Append("</td>");
                        }

                        for (i = 1; i < openSubprogramCount; i++)
                            sb.Append("<td></td>");

                        sb.Append("</tr>");
                    }

                    r.Close();
                }
            }
            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++)
                    {
                        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 = 1; i < openSubprogramCount; i++)
                        sb.Append("<td></td>");

                    sb.Append("</tr>");
                }
            }
        }

        sb.Append("</table><br />");

        //<ui-bottom>
        sb.Append("</div></td><td style='width:5px;' background='../images/list_r.gif'><img src='../images/p.gif'></td></tr></table>");


        if (mini == "")
        {

        }
        else
        {
            sb.Append("<table cellspacing=0 cellpadding=0 border=0 width=100% height=25><tr>");
            sb.Append("<td width=9><img src='../images/title_l2.gif'></td>");
            sb.Append("<td background='../images/title_c2.gif'>" + pagec + "</td>");
            sb.Append("<td width=9><img src='../images/title_r2.gif'></td>");
            sb.Append("</tr></table>");
        }
        
        //</ui-bottom>

        //sb.Append("<div id='RightKeyMenu' style='Z-INDEX: 100; display: none; POSITION: absolute; cursor:default;' class='border1'>");
        //sb.Append("<table style='TABLE-LAYOUT: fixed' style='border:1px solid #cccccc; ");
        //sb.Append("border-left:1px solid white;border-top:1px solid white; border-right:1px solid #868781; ");
        //sb.Append("border-bottom:1px solid #868781;' cellSpacing='1' cellPadding='2' width='150' background='../images/rkmenu_bg.gif' ");
        //sb.Append("bgColor='#F9F8F7' border='0'>");
        //sb.Append("<TR onmouseover=\"this.style.background='adadd1';\" onmouseout=\"this.style.background='';\">");
        //sb.Append("<TD onclick='hiddenRightKeyMenu();config_mymis();' >&nbsp;&nbsp;&nbsp;&nbsp;添加到我的MIS</TD>");
        //sb.Append("</TR>");
        //sb.Append("<TR onmouseover=\"this.style.background='adadd1';\" onmouseout=\"this.style.background='';\">");
        //sb.Append("<TD onclick='hiddenRightKeyMenu();promptset();' >&nbsp;&nbsp;&nbsp;&nbsp;设置任务提示</TD>");
        //sb.Append("</TR>");
        //sb.Append("<TR onmouseover=\"this.style.background='adadd1';\" onmouseout=\"this.style.background='';\">");
        //sb.Append("<TD onclick='hiddenRightKeyMenu();config_theme();' >&nbsp;&nbsp;&nbsp;&nbsp;设置系统颜色</TD>");
        //sb.Append("</TR>");
        //sb.Append("<TR onmouseover=\"this.style.background='adadd1';\" onmouseout=\"this.style.background='';\">");
        //sb.Append("<TD onclick='hiddenRightKeyMenu();config_surr();' >&nbsp;&nbsp;&nbsp;&nbsp;设置工作代理</TD>");
        //sb.Append("</TR>");
        //sb.Append("</table></div>");

        sb.Append("<div id='items_list' style='display:none;POSITION: absolute; background-color:#ffffff;overflow:auto;' class='blueborder'></div>");
        sb.Append("</BODY>");
        sb.Append("</HTML>");
        sb.Append("<script type='text/javascript'>");
        sb.Append("var pagecheight = " + pageHeight + ";");
        sb.Append("var OpenPageSize = '" + StringHelper.GetXmlValue(pm.Properties["xml"].ToString(),"popFormSize") + "';");
        sb.Append(" function Setsize()");
        sb.Append("{g('div_content').style.width = (document.body.clientWidth - 10) + 'px';");
        sb.Append("if (!isMobile) g('div_content').style.height = (document.body.clientHeight - 32 - pagecheight - 1 - 25) + 'px';} 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();</script>");
        sb.Append("<script type='text/javascript' src='" + wwwroot + "/App_Web/Programs/" + programId + "/listpage.js?15090622'></script>");


        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);
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }
}