using System;
using System.Data;
using System.Text;
using BP.DA;
using BP.Sys;
using BP.En;
using System.Collections;
using System.IO;
using BP.Difference;

namespace BP.WF.HttpHandler
{
    /// <summary>
    /// 页面功能实体
    /// </summary>
    public class WF_Comm_Sys : DirectoryPageBase
    {
        /// <summary>
        /// 加密字符串
        /// </summary>
        /// <returns></returns>
        public string JiaMi_Init()
        {
            string str = "ssss";
            DecryptAndEncryptionHelper.DecryptAndEncryptionHelper en = new DecryptAndEncryptionHelper.DecryptAndEncryptionHelper();
            return en.Encrypto(str);

            // DecryptAndEncryptionHelper.Encrypto decode = new DecryptAndEncryptionHelper.decode();
            //eturn decode.decode_exe(str);
        }
        public string ImpData_Init()
        {
            return "";
        }
        private string ImpData_DoneMyPK(Entities ens, DataTable dt)
        {
            //错误信息
            string errInfo = "";
            EntityMyPK en = (EntityMyPK)ens.GetNewEntity;
            //定义属性.
            Attrs attrs = en.EnMap.Attrs;

            int impWay = this.GetRequestValInt("ImpWay");

            #region 清空方式导入.
            //清空方式导入.
            int count = 0;//导入的行数
            int changeCount = 0;//更新数据的行数
            String successInfo = "";
            if (impWay == 0)
            {
                ens.ClearTable();
                foreach (DataRow dr in dt.Rows)
                {
                    en = (EntityMyPK)ens.GetNewEntity;
                    //给实体赋值
                    errInfo += SetEntityAttrVal("", dr, attrs, en, dt, 0);
                    //获取PKVal
                    en.PKVal = en.InitMyPKVals();
                    if (en.RetrieveFromDBSources() == 0)
                    {
                        en.Insert();
                        count++;
                        successInfo += "&nbsp;&nbsp;<span>MyPK=" + en.PKVal + "的导入成功</span><br/>";
                    }

                }
            }

            #endregion 清空方式导入.

            #region 更新方式导入
            if (impWay == 1 || impWay == 2)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    en = (EntityMyPK)ens.GetNewEntity;
                    //给实体赋值
                    errInfo += SetEntityAttrVal("", dr, attrs, en, dt, 1);

                    //获取PKVal
                    en.PKVal = en.InitMyPKVals();
                    if (en.RetrieveFromDBSources() == 0)
                    {
                        en.Insert();
                        count++;
                        successInfo += "&nbsp;&nbsp;<span>MyPK=" + en.PKVal + "的导入成功</span><br/>";
                    }
                    else
                    {
                        changeCount++;
                        SetEntityAttrVal("", dr, attrs, en, dt, 1);
                        successInfo += "&nbsp;&nbsp;<span>MyPK=" + en.PKVal + "的更新成功</span><br/>";
                    }
                }
            }
            #endregion

            return "errInfo=" + errInfo + "@Split" + "count=" + count + "@Split" + "successInfo=" + successInfo + "@Split" + "changeCount=" + changeCount;
        }
        /// <summary>
        /// 执行导入
        /// </summary>
        /// <returns></returns>
        public string ImpData_Done()
        {

            var files = HttpContextHelper.RequestFiles(); //context.Request.Files;
            if (files.Count == 0)
                return "err@请选择要导入的数据信息。";

            string errInfo = "";

            string ext = ".xls";
            string fileName = System.IO.Path.GetFileName(files[0].FileName);
            if (fileName.Contains(".xlsx"))
                ext = ".xlsx";

            //设置文件名
            string fileNewName = DateTime.Now.ToString("yyyyMMddHHmmssff") + ext;

            //文件存放路径
            string filePath = BP.Difference.SystemConfig.PathOfTemp + "/" + fileNewName;
            //files[0].SaveAs(filePath);
            HttpContextHelper.UploadFile(files[0], filePath);
            //从excel里面获得数据表.
            DataTable dt = DBLoad.ReadExcelFileToDataTable(filePath);

            //删除临时文件
            System.IO.File.Delete(filePath);

            if (dt.Rows.Count == 0)
                return "err@无导入的数据";

            //获得entity.
            Entities ens = ClassFactory.GetEns(this.EnsName);
            Entity en = ens.GetNewEntity;

            if (en.PK.Equals("MyPK") == true)
                return this.ImpData_DoneMyPK(ens, dt);

            if (en.IsNoEntity == false)
            {
                return "err@必须是EntityNo或者EntityMyPK实体,才能导入.";
            }

            string noColName = ""; //实体列的编号名称.
            string nameColName = ""; //实体列的名字名称.

            Attr attr = en.EnMap.GetAttrByKey("No");
            noColName = attr.Desc; //
            BP.En.Map map = en.EnMap;
            String codeStruct = map.CodeStruct;
            attr = map.GetAttrByKey("Name");
            nameColName = attr.Desc; //

            //定义属性.
            Attrs attrs = en.EnMap.Attrs;

            int impWay = this.GetRequestValInt("ImpWay");

            #region 清空方式导入.
            //清空方式导入.
            int count = 0;//导入的行数
            int changeCount = 0;//更新的行数
            String successInfo = "";
            if (impWay == 0)
            {
                ens.ClearTable();
                foreach (DataRow dr in dt.Rows)
                {
                    string no = dr[noColName].ToString();
                    string name = dr[nameColName].ToString();

                    //判断是否是自增序列，序列的格式
                    if (!DataType.IsNullOrEmpty(codeStruct))
                    {
                        no = no.PadLeft(System.Int32.Parse(codeStruct), '0');
                    }

                    EntityNoName myen = ens.GetNewEntity as EntityNoName;
                    myen.No = no;
                    if (myen.IsExits == true)
                    {
                        errInfo += "err@编号[" + no + "][" + name + "]重复.";
                        continue;
                    }

                    myen.Name = name;

                    en = ens.GetNewEntity;

                    //给实体赋值
                    errInfo += SetEntityAttrVal(no, dr, attrs, en, dt, 0);
                    count++;
                    successInfo += "&nbsp;&nbsp;<span>" + noColName + "为" + no + "," + nameColName + "为" + name + "的导入成功</span><br/>";
                }
            }

            #endregion 清空方式导入.

            #region 更新方式导入
            if (impWay == 1 || impWay == 2)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    string no = dr[noColName].ToString();
                    string name = dr[nameColName].ToString();
                    //判断是否是自增序列，序列的格式
                    if (!DataType.IsNullOrEmpty(codeStruct))
                    {
                        no = no.PadLeft(System.Int32.Parse(codeStruct), '0');
                    }
                    EntityNoName myen = ens.GetNewEntity as EntityNoName;
                    myen.No = no;
                    if (myen.IsExits == true)
                    {
                        //给实体赋值
                        errInfo += SetEntityAttrVal(no, dr, attrs, myen, dt, 1);
                        changeCount++;
                        successInfo += "&nbsp;&nbsp;<span>" + noColName + "为" + no + "," + nameColName + "为" + name + "的更新成功</span><br/>";
                        continue;
                    }
                    myen.Name = name;

                    //给实体赋值
                    errInfo += SetEntityAttrVal(no, dr, attrs, en, dt, 0);
                    count++;
                    successInfo += "&nbsp;&nbsp;<span>" + noColName + "为" + no + "," + nameColName + "为" + name + "的导入成功</span><br/>";
                }
            }
            #endregion

            return "errInfo=" + errInfo + "@Split" + "count=" + count + "@Split" + "successInfo=" + successInfo + "@Split" + "changeCount=" + changeCount;
        }

        private string SetEntityAttrVal(string no, DataRow dr, Attrs attrs, Entity en, DataTable dt, int saveType)
        {
            string errInfo = "";
            //按照属性赋值.
            foreach (Attr item in attrs)
            {
                if (item.Key == "No")
                {
                    en.SetValByKey(item.Key, no);
                    continue;
                }
                if (item.Key == "Name")
                {
                    en.SetValByKey(item.Key, dr[item.Desc].ToString());
                    continue;
                }


                if (dt.Columns.Contains(item.Desc) == false)
                    continue;

                //枚举处理.
                if (item.MyFieldType == FieldType.Enum)
                {
                    string val = dr[item.Desc].ToString();

                    SysEnum se = new SysEnum();
                    int i = se.Retrieve(SysEnumAttr.EnumKey, item.UIBindKey, SysEnumAttr.Lab, val);

                    if (i == 0)
                    {
                        errInfo += "err@枚举[" + item.Key + "][" + item.Desc + "]，值[" + val + "]不存在.";
                        continue;
                    }

                    en.SetValByKey(item.Key, se.IntKey);
                    continue;
                }

                //外键处理.
                if (item.MyFieldType == FieldType.FK)
                {
                    string val = dr[item.Desc].ToString();
                    Entity attrEn = item.HisFKEn;
                    int i = attrEn.Retrieve("Name", val);
                    if (i == 0)
                    {
                        errInfo += "err@外键[" + item.Key + "][" + item.Desc + "]，值[" + val + "]不存在.";
                        continue;
                    }

                    if (i != 1)
                    {
                        errInfo += "err@外键[" + item.Key + "][" + item.Desc + "]，值[" + val + "]重复..";
                        continue;
                    }

                    //把编号值给他.
                    en.SetValByKey(item.Key, attrEn.GetValByKey("No"));
                    continue;
                }

                //boolen类型的处理..
                if (item.MyDataType == DataType.AppBoolean)
                {
                    string val = dr[item.Desc].ToString();
                    if (val == "是" || val == "有")
                        en.SetValByKey(item.Key, 1);
                    else
                        en.SetValByKey(item.Key, 0);
                    continue;
                }

                string myval = dr[item.Desc].ToString();
                en.SetValByKey(item.Key, myval);
            }

            try
            {
                if (en.IsNoEntity == true)
                {
                    if (saveType == 0)
                        en.Insert();
                    else
                        en.Update();
                }

            }
            catch (Exception ex)
            {
                return "err@" + ex.Message;
            }

            return errInfo;
        }


        /// <summary>
        /// 构造函数
        /// </summary>
        public WF_Comm_Sys()
        {
        }
        /// <summary>
        /// 函数库
        /// </summary>
        /// <returns></returns>
        public string SystemClass_FuncLib()
        {
            string expFileName = "all-wcprops,dir-prop-base,entries";
            string expDirName = ".svn";

            string pathDir = BP.Difference.SystemConfig.PathOfData + "JSLib/";

            string html = "";
            html += "<fieldset>";
            html += "<legend>" + "系统自定义函数. 位置:" + pathDir + "</legend>";


            //.AddFieldSet();
            DirectoryInfo dir = new DirectoryInfo(pathDir);
            DirectoryInfo[] dirs = dir.GetDirectories();
            foreach (DirectoryInfo mydir in dirs)
            {
                if (expDirName.Contains(mydir.Name))
                    continue;

                html += "事件名称" + mydir.Name;
                html += "<ul>";
                FileInfo[] fls = mydir.GetFiles();
                foreach (FileInfo fl in fls)
                {
                    if (expFileName.Contains(fl.Name))
                        continue;

                    html += "<li>" + fl.Name + "</li>";
                }
                html += "</ul>";
            }
            html += "</fieldset>";

            pathDir = BP.Difference.SystemConfig.PathOfDataUser + "JSLib/";
            html += "<fieldset>";
            html += "<legend>" + "用户自定义函数. 位置:" + pathDir + "</legend>";

            dir = new DirectoryInfo(pathDir);
            dirs = dir.GetDirectories();
            foreach (DirectoryInfo mydir in dirs)
            {
                if (expDirName.Contains(mydir.Name))
                    continue;

                html += "事件名称" + mydir.Name;
                html += "<ul>";
                FileInfo[] fls = mydir.GetFiles();
                foreach (FileInfo fl in fls)
                {
                    if (expFileName.Contains(fl.Name))
                        continue;
                    html += "<li>" + fl.Name + "</li>";
                }
                html += "</ul>";
            }
            html += "</fieldset>";
            return html;
        }

        #region 系统实体属性.
        public string SystemClass_EnsCheck()
        {
            try
            {
                BP.En.Entity en = BP.En.ClassFactory.GetEn(this.EnName);
                BP.En.Map map = en.EnMap;
                en.CheckPhysicsTable();
                string msg = "";
                // string msg = "";
                string table = "";
                string sql = "";
                string sql1 = "";
                string sql2 = "";
                int COUNT1 = 0;
                int COUNT2 = 0;

                DataTable dt = new DataTable();
                Entity refen = null;
                foreach (Attr attr in map.Attrs)
                {
                    /**/
                    if (attr.MyFieldType == FieldType.FK || attr.MyFieldType == FieldType.PKFK)
                    {
                        refen = ClassFactory.GetEns(attr.UIBindKey).GetNewEntity;
                        table = refen.EnMap.PhysicsTable;
                        sql1 = "SELECT COUNT(*) FROM " + table;

                        Attr pkAttr = refen.EnMap.GetAttrByKey(refen.PK);
                        sql2 = "SELECT COUNT( distinct " + pkAttr.Field + ") FROM " + table;

                        COUNT1 = DBAccess.RunSQLReturnValInt(sql1);
                        COUNT2 = DBAccess.RunSQLReturnValInt(sql2);

                        if (COUNT1 != COUNT2)
                        {
                            msg += "<BR>@关联表(" + refen.EnMap.EnDesc + ")主键不唯一，它会造成数据查询不准确或者意向不到的错误：<BR>sql1=" + sql1 + " <BR>sql2=" + sql2;
                            msg += "@SQL= SELECT * FROM (  select " + refen.PK + ",  COUNT(*) AS NUM  from " + table + " GROUP BY " + refen.PK + " ) WHERE NUM!=1";
                        }

                        sql = "SELECT " + attr.Field + " FROM " + map.PhysicsTable + " WHERE " + attr.Field + " NOT IN (SELECT " + pkAttr.Field + " FROM " + table + " )";
                        dt = DBAccess.RunSQLReturnTable(sql);
                        if (dt.Rows.Count == 0)
                            continue;
                        else
                            msg += "<BR>:有" + dt.Rows.Count + "个错误。" + attr.Desc + " sql= " + sql;
                    }
                    if (attr.MyFieldType == FieldType.PKEnum || attr.MyFieldType == FieldType.Enum)
                    {
                        sql = "SELECT " + attr.Field + " FROM " + map.PhysicsTable + " WHERE " + attr.Field + " NOT IN ( select Intkey FROM " + BP.Sys.Base.Glo.SysEnum() + " WHERE ENUMKEY='" + attr.UIBindKey + "' )";
                        dt = DBAccess.RunSQLReturnTable(sql);
                        if (dt.Rows.Count == 0)
                            continue;
                        else
                            msg += "<BR>:有" + dt.Rows.Count + "个错误。" + attr.Desc + " sql= " + sql;
                    }
                }

                // 检查pk是否一致。
                if (en.PKs.Length == 1)
                {
                    sql1 = "SELECT COUNT(*) FROM " + map.PhysicsTable;
                    COUNT1 = DBAccess.RunSQLReturnValInt(sql1);

                    Attr attrMyPK = en.EnMap.GetAttrByKey(en.PK);
                    sql2 = "SELECT COUNT(DISTINCT " + attrMyPK.Field + ") FROM " + map.PhysicsTable;
                    COUNT2 = DBAccess.RunSQLReturnValInt(sql2);
                    if (COUNT1 != COUNT2)
                    {
                        msg += "@物理表(" + map.EnDesc + ")中主键不唯一;它会造成数据查询不准确或者意向不到的错误：<BR>sql1=" + sql1 + " <BR>sql2=" + sql2;
                        msg += "@SQL= SELECT * FROM (  select " + en.PK + ",  COUNT(*) AS NUM  from " + map.PhysicsTable + " GROUP BY " + en.PK + " ) WHERE NUM!=1";
                    }
                }

                if (msg == "")
                    return map.EnDesc + ":数据体检成功,完全正确.";

                string info = map.EnDesc + ":数据体检信息：体检失败" + msg;
                return info;

            }
            catch (Exception ex)
            {
                return "err@" + ex.Message;
            }
        }
        public string SystemClass_Fields_UI()
        {
            return SystemClass_Fields_UI_Ext(this.EnsName);
        }
        public string SystemClass_Fields_UI_Ext(string ensName)
        {
            Entities ens = ClassFactory.GetEns(ensName);
            Entity en = ens.GetNewEntity;

            BP.En.Map map = en.EnMap;
            en.CheckPhysicsTable();

            string html = "<table style='width:95%;font-size'>";

            html += "<caption>" + map.EnDesc + "," + ensName + "," + map.PhysicsTable + "</caption>";

            //html += "<tr>";
            //html += "<th colspan=8> " + map.EnDesc + ","+ensName+"," + map.PhysicsTable + " </th>";
            //html += "</tr>";

            html += "<tr>";
            html += "<th>#</th>";
            html += "<th>描述</th>";
            html += "<th>字段</th>";
            html += "<th>类型</th>";
            //   html += "<th>关系</th>";
            html += "<th>控件/外观/长度</th>";
            html += "<th>备注</th>";
            //      html += "<th>默认值</th>";
            html += "</tr>";

            int i = 0;
            foreach (Attr attr in map.Attrs)
            {
                if (attr.MyFieldType == FieldType.RefText)
                    continue;
                i++;
                html += "<tr>";
                html += "<td>" + i + "</td>";
                html += "<td>" + attr.Desc + "</td>";
                html += "<td>" + attr.Key + "</td>";
                //   html += "<td>" + attr.Field + "</td>";
                html += "<td>" + attr.MyDataTypeStr + "</td>";
                // html += "<td>" + attr.MyFieldType.ToString() + "</td>";
                string desc = "";
                if (attr.UIVisible == true)
                    desc += "可见,";
                else
                    desc += "不可见,";

                if (attr.UIIsReadonly == false)
                    desc += "可编辑";
                else
                    desc += "不可编辑";

                switch (attr.MyDataType)
                {
                    case DataType.AppBoolean:
                        html += "<td>选择框," + desc + "</td>";
                        break;
                    case DataType.AppDouble:
                    case DataType.AppFloat:
                    case DataType.AppInt:
                        if (attr.MyFieldType == FieldType.Enum)
                        {
                            html += "<td>下拉框," + desc + "</td>";
                            break;
                        }
                        else
                        {
                            html += "<td>数值文本框," + desc + "</td>";
                        }
                        break;
                    case DataType.AppMoney:
                        html += "<td>金额文本框," + desc + "</td>";
                        break;
                    case DataType.AppDate:
                        html += "<td>日期文本框," + desc + "</td>";
                        break;
                    case DataType.AppDateTime:
                        html += "<td>日期时间文本框," + desc + "</td>";
                        break;
                    default:
                        if (attr.MyFieldType == FieldType.FK)
                        {
                            html += "<td>下拉框(" + attr.MinLength + "/" + attr.MaxLength + ")," + desc + "</td>";
                        }
                        else
                        {
                            html += "<td>文本框(" + attr.MinLength + "/" + attr.MaxLength + ")," + desc + "</td>";
                        }
                        break;
                }

                string defVal = "";
                if (DataType.IsNullOrEmpty(attr.DefaultValOfReal) == false)
                    defVal += "默认值:" + attr.DefaultValOfReal + "";

                switch (attr.MyFieldType)
                {
                    case FieldType.Enum:
                    case FieldType.PKEnum:
                        try
                        {
                            SysEnums ses = new SysEnums(attr.UIBindKey);
                            string str = "";
                            foreach (SysEnum se in ses)
                            {
                                str += se.IntKey + "&nbsp;" + se.Lab + ",";
                            }
                            html += "<td>" + str + defVal + "</td>";
                        }
                        catch
                        {
                            html += "<td>" + defVal + "</td>";

                        }
                        break;
                    case FieldType.FK:
                    case FieldType.PKFK:
                        Entities myens = ClassFactory.GetEns(attr.UIBindKey);
                        html += "<td>表/视图:" + myens.GetNewEntity.EnMap.PhysicsTable + " 关联字段:" + attr.UIRefKeyValue + "," + attr.UIRefKeyText + defVal + "</td>";
                        break;
                    default:
                        html += "<td>" + defVal + "</td>";
                        break;
                }
                html += "</tr>";
            }
            html += "</table>";

            //  html += "<div style='text-align:center;' >(表:数据结构" + map.EnDesc + "," + ensName + "," + map.PhysicsTable + ")</div>";

            return html;
        }
        public string SystemClass_Fields()
        {
            return SystemClass_Fields_Ext(this.EnsName);
        }
        public string SystemClass_Fields_Ext(string ensName)
        {
            Entities ens = ClassFactory.GetEns(ensName);
            Entity en = ens.GetNewEntity;

            BP.En.Map map = en.EnMap;
            en.CheckPhysicsTable();

            string html = "";
            html += "<center>" + map.EnDesc + "," + map.PhysicsTable + "</center>";
            html += "<table>";
            html += "<tr>";
            html += "<th>#</th>";
            html += "<th>描述</th>";
            html += "<th>字段</th>";
            html += "<th>类型</th>";
            html += "<th>关系</th>";
            html += "<th>长度</th>";
            html += "<th>对应</th>";
            html += "<th>默认值</th>";
            html += "</tr>";

            int i = 0;
            foreach (Attr attr in map.Attrs)
            {
                if (attr.MyFieldType == FieldType.RefText)
                    continue;
                i++;
                html += "<tr>";
                html += "<td>" + i + "</td>";
                html += "<td>" + attr.Desc + "</td>";
                //   html += "<td>" + attr.Key + "</td>";
                html += "<td>" + attr.Field + "</td>";
                html += "<td>" + attr.MyDataTypeStr + "</td>";
                html += "<td>" + attr.MyFieldType.ToString() + "</td>";

                if (attr.MyDataType == DataType.AppBoolean
                    || attr.MyDataType == DataType.AppDouble
                    || attr.MyDataType == DataType.AppFloat
                    || attr.MyDataType == DataType.AppInt
                    || attr.MyDataType == DataType.AppMoney
                    )
                    html += "<td>无</td>";
                else
                    html += "<td>" + attr.MaxLength + "</td>";


                switch (attr.MyFieldType)
                {
                    case FieldType.Enum:
                    case FieldType.PKEnum:
                        try
                        {
                            SysEnums ses = new SysEnums(attr.UIBindKey);
                            string str = "";
                            foreach (SysEnum se in ses)
                            {
                                str += se.IntKey + "&nbsp;" + se.Lab + ",";
                            }
                            html += "<td>" + str + "</td>";
                        }
                        catch
                        {
                            html += "<td>未使用</td>";

                        }
                        break;
                    case FieldType.FK:
                    case FieldType.PKFK:
                        Entities myens = ClassFactory.GetEns(attr.UIBindKey);
                        html += "<td>表/视图:" + myens.GetNewEntity.EnMap.PhysicsTable + " 关联字段:" + attr.UIRefKeyValue + "," + attr.UIRefKeyText + "</td>";
                        break;
                    default:
                        html += "<td>无</td>";
                        break;
                }

                html += "<td>" + attr.DefaultVal.ToString() + "</td>";
                html += "</tr>";
            }
            html += "</table>";
            return html;
        }

        /// <summary>
        /// 系统日志
        /// </summary>
        /// <returns></returns>
        public string SystemLog_Init()
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("No");
            dt.Columns.Add("Name");
            dt.Columns.Add("LogType");

            string path = SystemConfig.PathOfDataUser + "\\Log\\info";
            string[] strs = System.IO.Directory.GetFiles(path);
            foreach (string str in strs)
            {
                DataRow dr = dt.NewRow();
                dr[0] = str.Substring(str.IndexOf("info") + 5);
                dr[1] = str.Substring(str.IndexOf("info") + 5);
                dr[2] = "信息";
                // dr[1] = str;
                dt.Rows.Add(dr);
            }

            path = SystemConfig.PathOfDataUser + "\\Log\\error";
            strs = System.IO.Directory.GetFiles(path);
            foreach (string str in strs)
            {
                DataRow dr = dt.NewRow();
                dr[0] = str.Substring(str.IndexOf("error") + 6);
                dr[1] = str.Substring(str.IndexOf("error") + 6);
                dr[2] = "错误";
                dt.Rows.Add(dr);
            }
            return BP.Tools.Json.ToJson(dt);
        }
        public string SystemLog_Open()
        {
            string logType = this.GetRequestVal("LogType");
            if (logType.Equals("信息") == true)
                logType = "info";
            else
                logType = "error";

            string path = SystemConfig.PathOfDataUser + "\\Log\\" + logType + "\\" + this.RefNo;
            string str = BP.DA.DataType.ReadTextFile2Html(path);
            return str;
        }

        public string SystemClass_Init()
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("No");
            dt.Columns.Add("EnsName");
            dt.Columns.Add("Name");
            dt.Columns.Add("PTable");

            ArrayList al = null;
            al = BP.En.ClassFactory.GetObjects("BP.En.Entity");
            foreach (Object obj in al)
            {
                Entity en = null;
                try
                {
                    en = obj as Entity;
                    if (en == null)
                        continue;
                    string className = en.ToString();
                    switch (className.ToUpper())
                    {
                        case "BP.WF.STARTWORK":
                        case "BP.WF.WORK":
                        case "BP.WF.GESTARTWORK":
                        case "BP.EN.GENONAME":
                        case "BP.EN.GETREE":
                        case "BP.WF.GERpt":
                        case "BP.WF.GEENTITY":
                        case "BP.WF.GEWORK":
                        case "BP.SYS.TSENTITYNONAME":
                            continue;
                        default:
                            break;
                    }
                    string s = en.EnDesc;
                    if (en == null)
                        continue;
                }
                catch
                {
                    continue;
                }

                if (en.ToString() == null || en.ToString().Equals(""))
                    continue;


                DataRow dr = dt.NewRow();

                dr["No"] = en.ToString();
                try
                {
                    dr["EnsName"] = en.GetNewEntities.ToString();
                }
                catch
                {
                    dr["EnsName"] = en.ToString() + "s";
                }
                dr["Name"] = en.EnMap.EnDesc;
                dr["PTable"] = en.EnMap.PhysicsTable;
                dt.Rows.Add(dr);
            }

            return BP.Tools.Json.ToJson(dt);
        }
        #endregion


        #region 执行父类的重写方法.
        /// <summary>
        /// 默认执行的方法
        /// </summary>
        /// <returns></returns>
        protected override string DoDefaultMethod()
        {
            string sfno = this.GetRequestVal("sfno");
            SFTable sftable = null;
            DataTable dt = null;
            StringBuilder s = null;

            switch (this.DoType)
            {
                case "DtlFieldUp": //字段上移
                    return "执行成功.";


                default:
                    break;
            }

            //找不不到标记就抛出异常.
            throw new Exception("@标记[" + this.DoType + "]，没有找到. @RowURL:" + HttpContextHelper.RequestRawUrl);
        }
        #endregion 执行父类的重写方法.

        #region 数据源管理
        public string SFDBSrcNewGuide_GetList()
        {
            //SysEnums enums = new SysEnums(SFDBSrcAttr.DBSrcType);
            SFDBSrcs srcs = new SFDBSrcs();
            srcs.RetrieveAll();

            return srcs.ToJson();
        }

        public string SFDBSrcNewGuide_LoadSrc()
        {
            DataSet ds = new DataSet();

            SFDBSrc src = new SFDBSrc();
            if (!string.IsNullOrWhiteSpace(this.GetRequestVal("No")))
                src = new SFDBSrc(No);
            ds.Tables.Add(src.ToDataTableField("SFDBSrc"));

            SysEnums enums = new SysEnums();
            enums.Retrieve(SysEnumAttr.EnumKey, SFDBSrcAttr.DBSrcType, SysEnumAttr.IntKey);
            ds.Tables.Add(enums.ToDataTableField("DBSrcType"));

            return BP.Tools.Json.ToJson(ds);
        }

        public string SFDBSrcNewGuide_DelSrc()
        {
            string no = this.GetRequestVal("No");

            //检验要删除的数据源是否有引用
            SFTables sfs = new SFTables();
            sfs.Retrieve(SFTableAttr.FK_SFDBSrc, no);

            if (sfs.Count > 0)
            {
                //Alert("当前数据源已经使用，不能删除！");
                return "当前数据源已经使用，不能删除！";
                //return;
            }
            SFDBSrc src = new SFDBSrc(no);
            src.Delete();
            return "删除成功..";
        }

        //javaScript 脚本上传
        public string javaScriptImp_Done()
        {
            var files = HttpContextHelper.RequestFiles();  //context.Request.Files;
            if (files.Count == 0)
                return "err@请选择要上传的流程模版。";
            string fileName = files[0].FileName;
            string savePath = BP.Difference.SystemConfig.PathOfDataUser + "JSLibData" + "/" + fileName;

            //存在文件则删除
            if (System.IO.Directory.Exists(savePath) == true)
                System.IO.Directory.Delete(savePath);

            //files[0].SaveAs(savePath);
            HttpContextHelper.UploadFile(files[0], savePath);
            return "脚本" + fileName + "导入成功";
        }

        public string RichUploadFile()
        {
            var files = HttpContextHelper.RequestFiles();
            if (files.Count == 0)
                return "err@请选择要上传的图片。";
            //获取文件存放目录
            string frmID = this.FrmID;
            if (DataType.IsNullOrEmpty(frmID) == true)
                frmID = this.EnName;
            string directory = frmID + "/" + this.WorkIDStr + "/";
            // 随便文件名
            string fileName = DBAccess.GenerGUID(4) + ".jpg";
            string savePath = BP.Difference.SystemConfig.PathOfDataUser + "UploadFile" + "/" + directory;

            if (System.IO.Directory.Exists(savePath) == false)
                System.IO.Directory.CreateDirectory(savePath);

            savePath = savePath + "/" + fileName;
            //存在文件则删除
            if (System.IO.Directory.Exists(savePath) == true)
                System.IO.Directory.Delete(savePath);

            HttpContextHelper.UploadFile(files[0], savePath);
            Hashtable ht = new Hashtable();
            ht.Add("code", 0);
            ht.Add("msg", "success");
            savePath = "DataUser/" + "UploadFile" + "/" + directory + fileName;
            ht.Add("data", savePath);
            return BP.Tools.Json.ToJson(ht);
        }

        /**
         * 获取已知目录下的文件列表
         * @return
         */
        public string javaScriptFiles()
        {
            String savePath = BP.Difference.SystemConfig.PathOfDataUser + "JSLibData";

            DirectoryInfo di = new DirectoryInfo(savePath);
            //找到该目录下的文件 
            FileInfo[] fileList = di.GetFiles();

            if (fileList == null || fileList.Length == 0)
                return "";
            DataTable dt = new DataTable();
            dt.Columns.Add("FileName");
            dt.Columns.Add("ChangeTime");
            foreach (FileInfo file in fileList)
            {
                DataRow dr = dt.NewRow();
                dr["FileName"] = file.Name;
                dr["ChangeTime"] = file.LastAccessTime.ToString();

                dt.Rows.Add(dr);
            }
            return BP.Tools.Json.ToJson(dt);

        }
        #endregion
    }



}