<%@ WebHandler Language="C#" Class="CustomPageDisplay"  %>

using System;
using System.Collections.Generic;
using System.Web;
using System.Data;
using System.IO;
using eMIS.Data;
using System.Data.Common;
using System.Web.SessionState;
using eMIS;
using System.Text;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;


public class CustomPageDisplay : IHttpHandler, IRequiresSessionState
{
    private string wwwroot;
    private string recordId;
    private int recordCount;
    private int recordPosition;
    private string menuId;
    private string templateId;
    private string displayToolbar;
    private bool isTab=false;
    private string tabName;
    private string userId;
    private HttpContext context;
    private string rnd = DateTime.Now.Ticks.ToString();

    public void ProcessRequest (HttpContext context)
    {
        bool tools = true;
        this.context = context;
        if (context.Session["userid"] == null)
        {
            LoginManager lm = new LoginManager(context);

            if (!lm.VerifyIdentity())
            {
                //context.Response.Write("会话丢失，请重新登陆！");
                //context.Response.End();

                //token=B06D9D344A389DC782B5E1A7F01E4583D777EF54A56607984193D6E447202410

                if (context.Request.QueryString["token"] != null)
                {
                    string[] a = DataManager.Decrypt( context.Request.QueryString["token"].ToString()).Split(',');

                    lm.Login(a[0]);
                    tools = false;
                }
                else
                {
                    context.Response.Write("会话丢失，请重新登陆！");
                    context.Response.End();
                }
            }
        }


        userId = context.Session["userid"].ToString();

        bool b = false;
        wwwroot = context.Request.ApplicationPath;

        string url = "";

        if (wwwroot == "/") wwwroot = "";

        StringBuilder sb = new StringBuilder();
        DataManager dm = new DataManager();

        menuId = context.Request.QueryString["proid"].ToString();
        recordId = context.Request.QueryString["recid"].ToString();
        displayToolbar = (context.Request.QueryString["toolbar"] == null ? "" : context.Request.QueryString["toolbar"].ToString());

        string flowId = (context.Request.QueryString["lcid"] == null ? "" : context.Request.QueryString["lcid"].ToString());
        if (flowId != "")
        {
            FlowManager flow = new FlowManager(flowId, dm);
            string objectId = flow.BusinessObjectID;
            BusinessObjectManager bom = new BusinessObjectManager(dm, objectId);
            menuId = bom.MenuID;

        }

        string f = (context.Request.QueryString["f"]==null?"":context.Request.QueryString["f"].ToString());

        InstanceManager inst = new InstanceManager(context,dm,menuId);




        if (recordId == "" && context.Request.QueryString["position"] != null)
        {
            recordPosition= int.Parse(context.Request.QueryString["position"].ToString());
            inst.RecordPosition = recordPosition;
            recordId = inst.PrimaryKeyValue;
        }
        else
        {
            inst.PrimaryKeyValue = recordId;
            recordPosition = 1;// inst.RecordPosition;
        }

        //context.Response.Write(inst.PrimaryKeyValue);
        //    context.Response.End();
        recordCount = 1;// inst.RecordCount;


        templateId = inst.Program.Properties["DZBJYM"].ToString();
        tabName = inst.Program.EditPageTabName;
        isTab = ( tabName!= "");





        if (inst.EditDataRow == null)
        {
            context.Response.Write("记录已删除！");
            context.Response.End();
        }

        inst.Tag.BusinessDataRow = inst.EditDataRow;

        if (templateId != "")
        {
            string r0="";
            if (templateId == "1")
            {
                r0 = context.Server.MapPath(wwwroot + "/App_Web/Programs/"+inst.ProgramID+"/template.htm");
            }
            else
            {
                DbDataReader reader = inst.SystemDbOperator.ExecuteReader("Select MBLJ,LX,MBMS From COM_ZDYMBB where ID=" + templateId);
                string r1 = "";
                if (reader.Read())
                {
                    r1 = reader[1].ToString();
                    r0 = reader[0].ToString();
                }
                reader.Close();

                if (r1 == "程序")
                {
                    context.Response.Redirect(wwwroot + r0 + (r0.IndexOf("?") == -1 ? "?" : "&") + "id=" + recordId + "&pid=" + menuId + "&recordcount=" + recordCount.ToString() + "&position=" + recordPosition + "&r=" + DateTime.Now.Ticks.ToString());

                }

                r0 = context.Server.MapPath(wwwroot + "/App_Web/Template/" + r0);
            }


            sb.Append("<html><body style='margin:0px;'>");
            sb.Append("<script type='text/javascript'>var wwwroot='"+wwwroot+"';var varSign='" + recordId + "';var NodeName='" +inst.FlowNode +"';pageType=3</script>");
            sb.AppendLine("<script type='text/javascript' src='Scripts/common.js?201807002'></script><script type='text/javascript' src='Scripts/CustomPageDisplay.js?2020004'></script>");
            sb.AppendLine("<link rel='stylesheet' href='"+wwwroot+"/Common6/Css/display.css' type='text/css' />");
            sb.AppendLine("<link rel='stylesheet' href='"+wwwroot+"/jslibs/font-awesome/css/font-awesome.min.css' type='text/css' />");
            if(displayToolbar!="0" && tools)
                WriteToolBar(sb);




            WriteCustomPage(context,sb,inst, r0);

            //if (isTab)
            //{
            //    sb.Append("<br/>");
            //    subprogs3div(sb, inst);
            //}

            sb.Append("</body></html>");
            context.Response.Write(sb.ToString());


        }
        else
        {
            int controlCount = inst.EditControls.Count;
            ControlManager cm = null;

            JObject json = JsonConvert.DeserializeObject<JObject>("{" + inst.Program.Properties["json"].ToString() + "}");


            JObject uicfg = (JObject)json["display"];
            bool flowlog = false;
            if (uicfg != null)
            {
                if (uicfg["flowlog"] != null)
                {
                    flowlog = uicfg["flowlog"].ToString()=="1";
                }
            }


            int total_cols = 2;
            bool ui_border = true;
            bool ui_columns = false;
            bool ui_subtab = true;
            JObject editcfg = (JObject)json["edit"];
            string desc_width = "120px";
            if (editcfg != null)
            {
                if (editcfg["columns"] != null)
                {
                    total_cols = int.Parse(editcfg["columns"].ToString());
                    ui_columns = true;
                }
                if (editcfg["border"] != null)
                {
                    //ui_border = editcfg["border"].ToString() == "1";
                }

                if (editcfg["subtab"] != null)
                {
                    ui_subtab = editcfg["subtab"].ToString() == "1";
                }
            }



            sb.Append("<html><head>");
            sb.Append("<script type='text/javascript'>var wwwroot='"+wwwroot+"';var varSign='" + recordId + "';var NodeName='" +inst.FlowNode +"';pageType=3</script>");
            sb.Append("<title>" + inst.Program.Properties["bt"].ToString()+ "</title></head><body style='font-family:Microsoft YaHei;margin:0px;'>");
            sb.AppendLine("<link rel='stylesheet' href='"+wwwroot+"/jslibs/font-awesome/css/font-awesome.min.css' type='text/css' />");
            sb.AppendLine("<script type='text/javascript' src='Scripts/CustomPageDisplay.js'></script>");
            sb.AppendLine("<script type='text/javascript' src='Scripts/common.js'></script><link rel='stylesheet' href='"+wwwroot+"/Common6/Css/display.css?2020001' type='text/css' />");
            if (displayToolbar != "0")
                WriteToolBar(sb);
            sb.Append("<table align='center' width='90%'><tr><td>");
            sb.Append("<table id='tab_label' style='cursor:default' cellpadding='2'><tr></tr></table></td></tr></table>");




            int control_cols = 1;
            int control_rows = 1;
            int cur_col_idx = 0;
            int cur_cols=1, cur_rows;
            string default_size_c;
            string default_size_r;
            int ii, iii=-1;

            int item_width = 100 / total_cols;
            int colnum = 0, colspan;

            string w;
            sb.Append("<div class='box' style='padding:10px;width:100%;text-align:center;'><div style='padding:10px;font-size:16px;'>"+inst.Program.Properties["bt"].ToString()+"</div>");


            sb.Append("<table cellspacing=0 cellpadding=0 border=0 style='border-collapse:collapse;'>");

            for (int i = 0; i < controlCount; i++)
            {
                cm = inst.EditControls[i];
                cm.PageType = 3;
                if (!cm.IsHidden)
                {

                    default_size_c = (cm.ControlType == "4"||cm.ControlType == "42"||cm.ControlType == "140" ? "2" : "1");
                    default_size_r= (cm.ControlType == "4"||cm.ControlType == "42" ? "3" : "1");
                    cur_cols = int.Parse(GetStyle(cm.ControlStyle, "colspan", default_size_c));
                    cur_rows = int.Parse(GetStyle(cm.ControlStyle, "rowspan", default_size_r));

                    cur_col_idx += cur_cols;

                    if (colnum==0)
                        sb.Append("<tr  >");

                    colnum += cur_cols;

                    sb.Append("<td class='box' style=\"text-align:center;width:" + desc_width + ";padding:6px;font-weight:bold;border-width:" + (ui_border ? "1px" : "0px") + ";border-style:solid;border-color:#c3cbda;background-color:#edf2f6;font-size:10.5pt;\">");
                    sb.Append(cm.ControlDescription);

                    w = (Convert.ToDouble(cur_cols) / Convert.ToDouble(total_cols) * 100).ToString("0");
                    colspan = cur_cols * 2 - 1;
                    sb.Append("</td><td style='padding:6px;text-align:left;font-size: 10.5pt; border-width:" + (ui_border ? "1px " : "0px") + ";border-style:solid;border-color:#c3cbda;' col_idx='" + cur_col_idx + "' "+(colspan==1?"name='autudisplay_td'":"")+" class='box' w='"+w+"' colspan='" + colspan + "'>");
                    cm.GetDisplayHtml(sb);
                    sb.Append("</td>");



                    if (colnum >= total_cols)
                    {
                        sb.Append("</tr>");
                        colnum = 0;
                    }
                }
            }


            //context.Response.Write(cur_col_idx);
            //context.Response.End();

            cur_cols = (cur_col_idx % total_cols);

            //context.Response.Write(cur_cols);
            //context.Response.End();
            
            if (cur_cols != 0)
            {
                
                cur_cols = total_cols - cur_cols;
                sb.Append("<td class='box' style=\"text-align:center;width:" + desc_width + ";padding:6px;font-weight:bold;border-width:" + (ui_border ? "1px" : "0px") + ";border-style:solid;border-color:#c3cbda;background-color:#edf2f6;font-size:10.5pt;\">");
              
                sb.Append("</td><td style='padding:6px;text-align:left;font-size: 10.5pt; border-width:" + (ui_border ? "1px " : "0px") + ";border-style:solid;border-color:#c3cbda;' col_idx='" + cur_col_idx + "'   class='box'  colspan='" + cur_cols + "'>");
               
                sb.Append("</td>");
                sb.Append("</tr>");
            }

            sb.Append("</table><script type='text/javascript'>autudisplayinit('"+desc_width+"');</script>");

            sb.Append("</div><table width=100% cellspacing=0 cellpadding=8><tr><td>");
            //if (isIP)
            //oPage.WriteSubprogramsRO("全部");
            //else

            //inst.AppendSubprogramsHtml(sb, "all");
            subprogs2(context,sb, inst, "all");

            sb.Append("</td></tr></table>");



            if (flowlog || menuId == "652824400")
            {
                sb.Append("<table width=100% cellspacing=0 cellpadding=8><tr><td style='padding:0px 0px 0px 16px;'>流程日志</td></tr><tr><td>");
                inst.WriteFlowLogs(sb, "", "1");
                sb.Append("</td></tr></table>");
            }

            sb.Append("</body></html>");



            context.Response.Write(sb.ToString());
        }



        if (url != "")
            context.Response.Redirect(url);
    }

    private string GetStyle(string style, string name,string def)
    {
        string r=def;
        int i = style.IndexOf(name);
        if (i == -1)
            return r;
        style += ";";
        i = style.IndexOf(":", i);
        int j = style.IndexOf(";",i);
        r = style.Substring(i+1, j - i-1);

        return r;
    }

    private string getfilename(string url)
    {
        int i = url.LastIndexOf("/");
        return url.Substring(i+1);
    }

    private string GetWidth(string style)
    {
        string s = style.ToLower() + ";";
        int i = s.IndexOf("width:");
        if (i == -1)
            return "";

        s = s.Substring(i, s.IndexOf(";", i) - i+1);
        return s;
    }

    private string GetTextAlign(string style)
    {
        string s = style.ToLower() + ";";
        int i = s.IndexOf("text-align:");
        if (i == -1)
            return "";

        s = s.Substring(i, s.IndexOf(";", i) - i + 1);
        return s;
    }

    private void WriteToolBar(StringBuilder sb)
    {
        sb.AppendLine("<STYLE TYPE='text/css'>");
        sb.AppendLine(".tb_td_t {padding-top:3px;padding-left:3px;padding-right:3px;cursor:default;}");
        sb.AppendLine(".tb_td_p {padding-left:3px;padding-right:3px;}");
        sb.AppendLine(".tb_overbutton { background-color: #adadd1; border-color: #000080; border-style: solid; border-width: 1px;}");
        sb.AppendLine(".tb_outbutton { background-color:; border-style: solid; border-width: 0px;padding:1px;}");
        sb.AppendLine("</STYLE>");

        sb.AppendLine("<script type='text/javascript'>");
        sb.AppendLine("var recordPosition=" + recordPosition + ",programId='" + menuId + "',templateId='" + templateId + "',wwwroot='"+wwwroot+"';");
        sb.AppendLine("function OverButton(o){o.className = 'tb_overbutton';}");

        sb.AppendLine("function OutButton(o){o.className = 'tb_outbutton';}");

        sb.AppendLine("function displayPageMove(i){var url='CustomPageDisplay.ashx?proid='+programId+'&recid=&position='+(recordPosition+i)+'&temid='+templateId+'&r=' + Math.random();document.location.href=url;}");
        sb.AppendLine("window.onbeforeprint=function(){document.getElementById('emToolBar').style.display='none';}; window.onafterprint=function(){document.getElementById('emToolBar').style.display='';};");
        sb.AppendLine("</script>");
        sb.AppendLine("<object id='WebBrowser' classid='CLSID:8856F961-340A-11D0-A96B-00C04FD705A2' height='0' width='0'></object>");
        sb.Append("<div id='emToolBar' style='background-image: url(" + wwwroot + "/Common6/Images/bg30.gif); ");
        sb.Append("HEIGHT: 32px;width:100%;' ><table border='0' cellspacing='0' cellpadding='0' width='100%'>");
        sb.Append("<tr><td><table height='30' border='0' cellspacing='1' cellpadding='0' style='font-size:9pt;'>");
        sb.Append("<tr valign='middle'><td><img src='" + wwwroot + "/Common6/Images/tool.gif'></td>");

        if (false && recordPosition != 1)
        {
            sb.Append("<td id='edi' onclick='displayPageMove(-1);' onmouseout='OutButton(this);' ");
            sb.Append("onmouseover='OverButton(this);' class='tb_outbutton'><table border='0' cellspacing='0' cellpadding='0' ");
            sb.Append(" style='font-size:9pt;'><tr><td class='tb_td_p'><img src='" + wwwroot + "/Common6/Images/moveprevious.gif'></td>");
            sb.Append("<td class='tb_td_t'>上一条</td></tr></table></td>");
            sb.Append("<td class='tb_td_t'>|</td>");
        }

        if (false && recordCount != recordPosition)
        {
            sb.Append("<td id='edi' onclick='displayPageMove(1);' onmouseout='OutButton(this);' ");
            sb.Append("onmouseover='OverButton(this);' class='tb_outbutton'><table border='0' cellspacing='0' cellpadding='0' ");
            sb.Append(" style='font-size:9pt;'><tr><td class='tb_td_p'><img src='" + wwwroot + "/Common6/Images/movenext.gif'></td>");
            sb.Append("<td class='tb_td_t'>下一条</td></tr></table></td>");
            sb.Append("<td class='tb_td_t'>|</td>");
        }

        sb.Append("<td id='edi' onclick='window.print();' onmouseout='OutButton(this);' ");
        sb.Append("onmouseover='OverButton(this);' class='tb_outbutton'><table border='0' cellspacing='0' cellpadding='0' ");
        sb.Append(" style='font-size:9pt;'><tr><td class='tb_td_p'><img src='" + wwwroot + "/Common6/Images/print.gif'></td>");
        sb.Append("<td class='tb_td_t'>打印</td></tr></table></td>");

       // sb.Append("<td class='tb_td_t'>|</td>");
       // sb.Append("<td onclick=\"document.getElementById('WebBrowser').ExecWB(7,1);\" onmouseout='OutButton(this);' onmouseover='OverButton(this);' class='tb_outbutton'><table border='0' cellspacing='0' cellpadding='0' style='font-size:9pt;'><tr><td class='tb_td_p'><img src='../../Common6/Images/preview.gif'></td>");
       // sb.Append("<td class='tb_td_t'>预览</td></tr></table></td>");


        sb.Append("<td class='tb_td_t'>|</td>");
        sb.Append("<td id='pre' onclick='document.location.reload();' onmouseout='OutButton(this);' ");
        sb.Append("onmouseover='OverButton(this);' class='tb_outbutton'><table border='0' cellspacing='0' cellpadding='0' ");
        sb.Append(" style='font-size:9pt;'><tr><td class='tb_td_p'><img src='" + wwwroot + "/Common6/Images/refresh.gif'></td>");
        sb.Append("<td class='tb_td_t'>刷新</td></tr></table></td>");


       // sb.Append("<td class='tb_td_t'>|</td>");
       // sb.Append("<td id='saveas' onclick=\"document.getElementById('WebBrowser').ExecWB(4,1);\" onmouseout='OutButton(this);' ");
       // sb.Append("onmouseover='OverButton(this);' class='tb_outbutton'><table border='0' cellspacing='0' cellpadding='0' ");
       // sb.Append(" style='font-size:9pt;'><tr><td class='tb_td_p'><img src='" + wwwroot + "/Common6/Images/SaveAs.gif'></td>");
      //  sb.Append("<td class='tb_td_t'>另存</td></tr></table></td>");


        sb.Append("<td class='tb_td_t'>|</td>");
        sb.Append("<td id='saveas' onclick=\"exp_pdf(event);\" onmouseout='OutButton(this);' ");
        sb.Append("onmouseover='OverButton(this);' class='tb_outbutton'><table border='0' cellspacing='0' cellpadding='0' ");
        sb.Append(" style='font-size:9pt;'><tr><td class='tb_td_p'><img src='" + wwwroot + "/Common6/Images/pdf.png'></td>");
        sb.Append("<td class='tb_td_t'>导出PDF</td></tr></table></td>");

        sb.Append("<td class='tb_td_t'>|</td>");
        sb.Append("<td id='pre' onclick='window.close();' onmouseout='OutButton(this);' ");
        sb.Append("onmouseover='OverButton(this);' class='tb_outbutton'><table border='0' cellspacing='0' cellpadding='0' ");
        sb.Append(" style='font-size:9pt;'><tr><td class='tb_td_p'><img src='" + wwwroot + "/Common6/Images/delete.gif'></td>");
        sb.Append("<td class='tb_td_t'>关闭</td></tr></table></td>");

        sb.Append("</tr></table></td><td align=right style='font-size:9pt;'>&nbsp;&nbsp;</td></tr></table></div>");

    }
    private void WriteCustomPage(HttpContext context,StringBuilder sb,InstanceManager instance,string templatePath)
    {

        StreamReader sr = new StreamReader(templatePath, Encoding.GetEncoding("utf-8"));
        string line;
        int beginPosition;
        int endPosition;
        int findPoistion;

        DataTable elements = instance.Program.EditElements;

        ControlManager control = null;

        string ms, str,fff;
        string[] a;
        int i;
        bool b = false;
        bool b2 = false;
        string s;

        while (!sr.EndOfStream)
        {
            line = sr.ReadLine();

            line = line.Replace("&lt;", "<");
            line = line.Replace("&gt;", ">");

            findPoistion = 0;


            while (true)
            {
                beginPosition = line.IndexOf("<#");

                if (beginPosition == -1)
                {
                    sb.Append(line.Substring(0));
                    break;
                }

                sb.Append(line.Substring(0,beginPosition));


                endPosition = line.IndexOf("#>");

                ms = line.Substring(beginPosition+2, endPosition - beginPosition - 2);

                line = line.Substring(endPosition+2);

                if (instance.EditControlDescriptionIndex.ContainsKey(ms))
                {
                    control = instance.EditControls[instance.EditControlDescriptionIndex[ms]];

                    control.Display = true;

                    control.GetDisplayHtml(sb);
                }
                else
                {
                    ms = ms.ToUpper();
                    if (ms.IndexOf("IF") != -1)
                        ms = StringHelper.GetRightString(ms);
                    str = "";

                    if (ms.IndexOf("GLCX3") != -1)
                    {
                        b = true;
                        //subprogs3(StringHelper.GetRightString(ms));
                    }
                    else if (ms.IndexOf("TABGLCX") != -1)
                    {
                        //subprogs2(sb, instance, StringHelper.GetRightString(ms));
                        //b2 = true;
                    }
                    else if (ms.IndexOf("GLCX") != -1)
                    {
                        subprogs2(context,sb, instance, StringHelper.GetRightString(ms));
                        b2 = true;
                    }

                    else if (ms.IndexOf("FLOWLOGS") != -1)
                    {
                        instance.WriteFlowLogs(sb,StringHelper.GetRightString(ms),"1");
                    }
                    else if(ms.IndexOf("FLOW") != -1)
                    {
                        sb.Append(instance.GetFlowLog(StringHelper.GetRightString(ms)));
                    }
                }



                findPoistion = endPosition + 2;
            }
        }

        sr.Close();

        if (b)
            instance.Context.Response.Write("<script type='text/javascript'>selectsubpro3(0);</script>");

        if (b2)
            instance.Context.Response.Write("<script type='text/javascript'>try {selectsubpro2(1);} catch(e){}</script>");

    }

    private void subprogs3tab(StringBuilder sb, InstanceManager instance)
    {
        DataRow row = null;
        string subprogid, xml, iframesrc, s, s2;
        int l = instance.Program.Subprograms.Rows.Count;
        sb.Append("<table border=0 cellpadding=2 cellspacing=2><tr>");
        if (isTab)
            sb.Append("<td>" + instance.Program.EditPageTabName + "</td>");

        int i;
        for (i = 0; i < l; i++)
        {
            row = instance.Program.Subprograms.Rows[i];
            sb.Append("<td>" + row["glms"].ToString() + "</td>");
        }
        sb.Append("</tr></table>");


    }

    private void subprogs3div(HttpContext context,StringBuilder sb, InstanceManager instance,InstanceManager parentInst)
    {
        DataRow row = null;
        string subprogid, xml, iframesrc,s,s2;
        int l = instance.Program.Subprograms.Rows.Count;

        for (int i = 0; i < l; i++)
        {
            row = instance.Program.Subprograms.Rows[i];
            if (tabName.IndexOf(row["glms"].ToString()) != -1)
            {
                subprogid = row["glcxid"].ToString();
                xml = row["xml"].ToString();
                if (subprogid == "")
                {
                    iframesrc = row["glcxmc"].ToString();
                    iframesrc = instance.Tag.ReplaceExpression(iframesrc, "colval");
                    sb.Append("<div id='subifra" + i.ToString() + "' style='display:none;width:100%;height:300px;'>");
                    sb.Append("<iframe frameborder='0' style='width:100%;height:100%;' iframesrc='" + iframesrc + "'>");
                    sb.Append("</iframe></div>");
                }
                else
                {
                    s = StringHelper.GetXmlValue(xml, "外键") + "='" + instance.EditDataRow[StringHelper.GetXmlValue(xml, "主键")].ToString() + "'";




                    s2 = row["gltj"].ToString();

                    s2 = parentInst.Tag.ReplaceExpression(s2, "COLVAL");



                    s2 = getJSTJ(instance.SystemDataManager,s2,subprogid,userId);

                    if (s2 != "")
                        s += " and (" + s2 + ")";


                    sb.Append("<div id='subifra" + i.ToString() + "' style='height:100px;width:100%;'>");
                    if (StringHelper.GetXmlValue(xml, "同页编辑") == "1")
                        getSubList2(context,sb, instance, subprogid, s);
                    else
                        getSubList1(sb, instance, subprogid, s);
                    sb.Append("</div>");
                }
            }
        }


    }

    private string getJSTJ(DataManager dm, string cond, string glcxid,string userid)
    {
        string s = cond;
        string s2;
        DataTable  tj = dm.ExecuteTable("select TJ from COM_XTCDB_JSTJ a,COM_YHGWDZB b,COM_XTCDB c where a.caidan_id=c.id and c.cxid="+glcxid+" and a.gangwei_id=b.gangwei_id and b.renyuan_id=" + userid + " order by a.cx");
        if (tj.Rows.Count != 0)
        {
            s2 = tj.Rows[0][0].ToString();
            if(s2!="")
                s += (s == "" ? "" : " and ") + "("+s2+")";
        }
        return s;
    }

    private void subprogs2(HttpContext context,StringBuilder sb,InstanceManager instance,string idx)
    {
        int l;
        int i;
        DataRow row =null;
        string s;
        string s2;
        string subprogid;
        string iframesrc;
        string c;
        string xml;

        if(int.TryParse(idx,out l))
        {
            row = instance.Program.Subprograms.Rows[l-1];
            xml = row["xml"].ToString();
            c = row["gltj"].ToString();

            c = instance.Tag.ReplaceExpression(c, "COLVAL");



            c = getJSTJ(instance.SystemDataManager,c,row["glcxid"].ToString(),userId);

            s = StringHelper.GetXmlValue(xml, "外键");



            if (s == "") s = "<#primarykey#>";
            if (c == "")
                c = s + "='" + instance.EditDataRow[StringHelper.GetXmlValue(xml, "主键")].ToString() + "'";
            else
                c += " and " + s + "='" + instance.EditDataRow[StringHelper.GetXmlValue(xml, "主键")].ToString() + "'";


           s = StringHelper.GetXmlValue(xml, "同页编辑");
            if(s=="1")
                getSubList2(context,sb, instance, row["glcxid"].ToString(), c);
            else if(s=="4")
                getSubList4(sb, instance, row["glcxid"].ToString(), c);
            else
                getSubList1(sb, instance, row["glcxid"].ToString(), c);
        }
        else
        {
            l = instance.Program.Subprograms.Rows.Count;
            if(l==0)
                return ;


            //sb.Append("<div style='z-index:-1;position:absolute;margin-top:-3px;width:100%;height:1px;");
            //sb.Append("background-color:#000000;padding:0px;overflow:hidden;'></div>");

            for(i=0;i<l;i++)
            {
                row = instance.Program.Subprograms.Rows[i];
                subprogid = row["glcxid"].ToString();
                xml = row["xml"].ToString();
                if (subprogid == "")
                {
                    iframesrc = row["glcxmc"].ToString();
                    instance.Tag.BusinessDataRow = instance.EditDataRow;
                    iframesrc = instance.Tag.ReplaceExpression(iframesrc, "colval");
                    sb.Append("<div id='subifra" + i.ToString() + "' style='display:none;width:100%;height:300px;'>");
                    sb.Append("<iframe frameborder='0' style='width:100%;height:100%;' iframesrc='" + iframesrc + "'>");
                    sb.Append("</iframe></div>");
                }
                else
                {
                    s = StringHelper.GetXmlValue(xml, "外键") + "='" + instance.EditDataRow[StringHelper.GetXmlValue(xml, "主键")].ToString() + "'";
                    s2 = row["gltj"].ToString();
                    s2 = instance.Tag.ReplaceExpression(s2, "COLVAL");


                    s2 = getJSTJ(instance.SystemDataManager,s2,subprogid,userId);

                    if (s2 != "")
                        s+=" and ("+ s2 + ")";






                    sb.Append("<table border=0 cellpadding=2 cellspacing=2><tr><td><img id='subimg"+ i.ToString() +"' src='images/close.gif'></td><td><a href='javascript:void(0);' onclick='openSubDiv("+i.ToString() +");'>");
                    sb.Append(row["glms"].ToString());
                    sb.Append("<a></td></tr></table>");

                    sb.Append("<div id='subifra" + i.ToString() + "' style='width:100%;'>");





                    if (StringHelper.GetXmlValue(xml, "同页编辑") == "1")
                        getSubList2(context,sb, instance,subprogid, s);
                    else
                        getSubList1(sb, instance, subprogid, s);
                    sb.Append("</div>");
                }
            }

            sb.Append("<script type='text/javascript'>SubPros='" + l.ToString() + "';SubProgType=2;</script>");
        }

    }


    public void getSubList4(StringBuilder sb, InstanceManager instance, string menuId, string cond)
    {

        InstanceManager inst = new InstanceManager(instance.Context, instance.SystemDataManager,menuId);
        inst.StateKey = "sdis";
        inst.InitState();

        cond = instance.Tag.ReplaceExpression(cond, "");

        inst.QueryCondition = cond;

        DataTable listData = inst.GetAllRecordDataTable("list");
        if (listData.Rows.Count != 0)
        {
            string keyval = listData.Rows[0][inst.Program.PrimaryKey].ToString();
            sb.Append("<iframe onload=\"this.style.height=(this.contentWindow.document.body.scrollHeight+30)+'px'\" style=\"border:0px;width:100%;overflow:hidden;\" src=\"CustomPageDisplay.ashx?proid="+menuId+"&recid="+keyval+"&temid=&toolbar=0&r="+rnd+"\"></iframe>");
        }

        
    }

    public void getSubList1(StringBuilder sb, InstanceManager instance, string menuId, string cond)
    {

        InstanceManager inst = new InstanceManager(instance.Context, instance.SystemDataManager, menuId);
        inst.StateKey = "sdis";
        inst.InitState();
        cond = instance.Tag.ReplaceExpression(cond, "");
        inst.QueryCondition = cond;

        DataTable listData = inst.GetAllRecordDataTable("edit");
        DataTable elements = inst.Program.EditElements;
        getSubList(sb, inst,listData, elements,1);
    }

    public void getSubList2(HttpContext context,StringBuilder sb, InstanceManager instance, string menuId, string cond)
    {

        InstanceManager inst = new InstanceManager(instance.Context, instance.SystemDataManager,menuId);
        inst.StateKey = "sdis";
        inst.InitState();

        cond = instance.Tag.ReplaceExpression(cond, "");

        inst.QueryCondition = cond;
        try
        {
            DataTable listData = inst.GetAllRecordDataTable("list");
            DataTable elements = inst.Program.ListElements;
            getSubList(sb, inst, listData, elements, 2);
        }
        catch (Exception exc)
        {

            context.Response.Write(menuId+":"+cond +exc.Message);
            context.Response.End();
        }
    }

    public void getSubList(StringBuilder sb, InstanceManager inst, DataTable listData, DataTable elements, int mode)
    {
        int elementsCount = elements.Rows.Count;
        string subProgramId = inst.ProgramID;
        int i,ii;
        string joinCellJs = "";
        string sx;
        sb.Append("<table id='table" + subProgramId + "' border=1 cellspacing='0' cellpadding='4' style='BORDER-COLLAPSE: collapse;font-size:10.5pt;'");
        sb.Append("bordercolor='#000000' align='center'  width='100%'><tr align=center><td style='width:10px;'></td>");

        string sTJFS = "", tjfs;
        for(i=0;i<elementsCount;i++)
        {
            if (elements.Rows[i]["YC"].ToString()=="0")
                sb.Append("<td style='font-weight:bold;'>" + elements.Rows[i]["kjms"]+"</td>");


            if (mode == 1)
            {
                sx=elements.Rows[i]["SX"].ToString();
                if (sx.IndexOf("merge") != -1)
                    joinCellJs = "UniteCol('" + subProgramId + "'," + (i+1).ToString() + ",0);" + joinCellJs;

                sx = StringHelper.GetParamValue(sx, "stat");
                if (sx != "")
                {
                    if (!sTJFS.Contains(sx))
                        sTJFS += (sTJFS == "" ? "" : ",") + sx;
                }
            }
            else
            {
                if (elements.Rows[i]["HB"].ToString() == "1")
                    joinCellJs = "UniteCol('" + subProgramId + "'," + (i+1).ToString() + ",0);" + joinCellJs;
            }
            
        }

        sb.Append("</tr>");
        ControlManager control = new ControlManager(inst);
        control.Display = true;
        string str,fff;
        string[] a;

        int cellIdx=0;

        //统计=======================================

        double[] var_sum, var_avg, var_max, var_min;
        double var_count, var_num;
        string[] a1, a2;
        int j;
        string s2;

        var_sum = new double[elementsCount];
        var_avg = new double[elementsCount];
        var_max = new double[elementsCount];
        var_min = new double[elementsCount];

        bool bSetBgcolor = false;
        string[] arr_bgcolor = new string[1];
        string[] arr_temp;
        string str_bg;
        string s;

        if (mode == 2)
        {
            

            s = inst.Program.Properties["JLYSSZ"].ToString();

            if (s != "")
            {
                bSetBgcolor = true;
                arr_bgcolor = s.Split(';');
            }
        }

        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;
        }
        
        //统计=========================================

        int c = listData.Rows.Count;
        string primaryKeyValue="0";
        DataRow[] rows;
        string param,s3,stat,format;
        for (int idx = 0; idx < c;idx++ )
        {

            str_bg = "#000000";

            if (bSetBgcolor)
            {
                primaryKeyValue = listData.Rows[idx][inst.Program.PrimaryKey].ToString();
                for (i = 0; i < arr_bgcolor.Length; i++)
                {
                    arr_temp = arr_bgcolor[i].Split(',');

                    if (inst.MeetTheCondition(arr_temp[0], primaryKeyValue))
                    {
                        str_bg = arr_temp[1];
                        break;
                    }
                }

            }

            sb.Append("<tr align=center style='color:"+str_bg+";'><td style='width:10px;'>"+ (idx+1).ToString() +"</td>");
            for (i = 0; i < elementsCount; i++)
            {
                control.Init(listData.Rows[idx], elements.Rows[i]);
                if (!control.IsHidden)
                {
                    if (control.ControlType == "46")
                    {
                        s2 = control.GetDataField;
                        rows = elements.Select("kjid=" + s2.Substring(2, s2.Length - 4));
                        s2 = StringHelper.GetRightString(rows[0]["dyzd"].ToString());
                        s2 = listData.Rows[idx][s2].ToString();
                        control.GetDataField = s2;
                    }

                    str = control.Text;
                    cellIdx++;

                    if (control.ControlType == "140")
                    {
                        param = control.GetParamValue("filename", "附件");
                        sb.Append("<td style='" + GetTextAlign(control.ControlStyle) + ";"+(str.Length>16?"white-space:normal; word-break:break-all;":"")+"'>");
                        if (str != "")
                        {
                            a = str.Split('|');
                            str = "";

                            for (ii = 0; ii < a.Length; ii++)
                            {
                                fff = a[ii];
                                if (fff.Contains(":"))
                                {
                                    s2 = StringHelper.GetRightString(fff, ":");
                                    fff = StringHelper.GetLeftString(fff, ":");
                                }
                                else
                                {
                                    if (fff.IndexOf("*") != -1)
                                    {
                                        a2 = fff.Split('*');
                                        fff = a2[1];
                                    }

                                    if (param == "filename")
                                    {
                                        s3 = fff;
                                        s3 = s3.Substring(s3.LastIndexOf("/") + 1);
                                        s3 = s3.Substring(0, s3.LastIndexOf("."));
                                        s2 = s3;
                                    }
                                    else
                                    {
                                        s2 = param + (ii + 1).ToString();
                                    }
                                }
                                sb.Append("&nbsp;<a href=\"javascript:void(0);\" onclick=\"getFile3('" + fff + "');\" style=\"color:blue\" title=\"" + fff.Substring(fff.LastIndexOf("/") + 1) + "\">" + s2 + "</a>");
                            }
                        }
                        sb.Append("</td>");
                    }
                    else if (control.ControlType == "3")
                    {
                        sb.Append("<td style='" + GetTextAlign(control.ControlStyle) + "'><a href='javascript:void(0);' onclick=\"ObjectDisplay('" + elements.Rows[i]["QZZD"].ToString() + "','" + control.Value + "');\"  style='color:blue' >" + str + "</a></td>");
                    }
                    else if (control.ControlType == "43")
                    {

                        sb.Append("<td style='" + GetTextAlign(control.ControlStyle) + "'>"+(control.Value=="1"?"<i class='fa fa-check-square-o' aria-hidden='true'></i>":"<i class='fa fa-square-o' aria-hidden='true'></i>")+"</td>");
                    }
                    else if (control.ControlType == "42")
                    {
                        if (control.Value != "")
                        {
                            a2 = control.Value.Split(':');
                            sb.Append("<td style='" + GetTextAlign(control.ControlStyle) + "'><a href='" + wwwroot +  "/common6/code/app/image.ashx?m=" + a2[0] + "' target='_blank'><img border='0' src='" + wwwroot +  "/common6/code/app/image.ashx?m=" + a2[0] + "&s="+control.GetParamValue("imgsize","640,480")+"'></a></td>");
                        }
                    }
                    else
                    {

                        //统计=================================
                        tjfs = StringHelper.GetParamValue(elements.Rows[i]["SX"].ToString(), "stat");
                        if (tjfs != "" && double.TryParse(str, out var_num))
                        {
                            //tjfs = elements.Rows[i]["TJFS"].ToString();
                            a1 = tjfs.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);

                            for (j = 0; j < a1.Length; j++)
                            {
                                switch (a1[j])
                                {
                                    case "sum":
                                        var_sum[i] = var_sum[i] + var_num;
                                        break;

                                    case "avg":
                                        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;
                                }
                            }
                        }
                        //统计========================================
                        s = control.GetParamValue("url", "");
                        if (s == "")
                        {
                            sb.Append("<td style='" + GetWidth(control.ControlStyle) + ";" + GetTextAlign(control.ControlStyle) + ";"+(str.Length>16?"white-space:normal; word-break:break-all;":"")+"'>" + str + "</td>");
                        }
                        else
                        {
                            inst.Tag.BusinessDataRow = listData.Rows[idx];
                            s = inst.Tag.ReplaceExpression(s, "colval");
                            s2 = control.GetParamValue("cond", "");
                            if (s2 != "")
                            {
                                s += "&cond="+DataManager.Encrypt(inst.Tag.ReplaceExpression(s2, "colval"));

                            }
                            sb.Append("<td style='" + GetWidth(control.ControlStyle) + ";" + GetTextAlign(control.ControlStyle) + ";color:blue;cursor:pointer;' onclick=\"OpenUrl('" + s + "','controlurl')\">" + str + "</td>");
                        }
                    }

                }
            }
            sb.Append("</tr>");
        }

        //统计
        if (sTJFS != "")
        {

            a1 = sTJFS.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries);

            for (j = 0; j < a1.Length; j++)
            {

                a2 = a1[j].Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);

                tjfs = a1[j];   //' 名称

                if (tjfs == "sum")
                    tjfs = "合计";

                sb.Append("<tr bgcolor=ffffff><td colspan=2  align=center>" + tjfs + "</td>");

                for (i = 1; i < elementsCount; i++)
                {

                   
                    
                    if (elements.Rows[i]["YC"].ToString()=="1")
                        continue;

                    
                    sb.Append("<td align='right'>");
                    stat = StringHelper.GetParamValue(elements.Rows[i]["SX"].ToString(), "stat");
                    format = elements.Rows[i]["YS"].ToString();
                    
                    if (stat != "")
                    {
                        switch (tjfs)
                        {
                            case "合计":
                                if (var_sum[i] != 0)
                                    sb.Append(FormatValue(format, var_sum[i].ToString()));
                                else
                                    sb.Append("&nbsp;");

                                break;

                            case "最大值":
                                if (var_max[i] != double.MinValue)
                                    sb.Append(var_max[i]);
                                else
                                    sb.Append("&nbsp;");

                                break;

                            case "最小值":
                                if (var_min[i] != double.MaxValue)
                                    sb.Append(var_min[i]);
                                else
                                    sb.Append("&nbsp;");

                                break;
                        }
                    }

                    sb.Append("</td>");
                    
                }


                sb.Append("</tr>");
            }

        }
        //统计========================================================


        sb.Append("</table><br><script type='text/javascript'>" + joinCellJs + "</script>");
    }


    private string GetFormat(string formatString)
    {
        int i = formatString.IndexOf("format:(");
        if (i == -1)
            return "";

        string s = formatString.Substring(i + 8, formatString.IndexOf(")", i) - i - 8);

        return s;

    }
    private string FormatValue(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 bool IsReusable
    {
        get
        {
            return false;
        }
    }

}