using System;
using System.Data;
using BP.Sys;
using BP.DA;
using BP.En;
using BP.CCBill;
using BP.Difference;


namespace BP.WF.HttpHandler
{
    public class WF_Admin_FoolFormDesigner_ImpExp : BP.WF.HttpHandler.DirectoryPageBase
    {
        /// <summary>
        /// 构造函数
        /// </summary>
        public WF_Admin_FoolFormDesigner_ImpExp()
        {
        }

        #region 导出.
        /// <summary>
        ///下载
        /// </summary>
        /// <returns></returns>
        public string Exp_DownFormTemplete()
        {
            BP.WF.HttpHandler.WF_Admin_CCBPMDesigner en = new WF_Admin_CCBPMDesigner();
            return en.DownFormTemplete();
        }
        #endregion

        #region 导入
        /// <summary>
        /// 初始化 导入的界面 .
        /// </summary>
        /// <returns></returns>
        public string Imp_Init()
        {
            DataSet ds = new DataSet();

            string sql = "";
            DataTable dt;

            if (this.FK_Flow != null)
            {
                //加入节点表单. 如果没有流程参数.

                Paras ps = new Paras();
                ps.SQL = "SELECT NodeID, Name  FROM WF_Node WHERE FK_Flow=" + BP.Difference.SystemConfig.AppCenterDBVarStr + "FK_Flow ORDER BY NODEID ";
                ps.Add("FK_Flow", this.FK_Flow);
                dt = DBAccess.RunSQLReturnTable(ps);

                dt.TableName = "WF_Node";

                if (BP.Difference.SystemConfig.AppCenterDBFieldCaseModel == FieldCaseModel.UpperCase)
                {
                    dt.Columns["NODEID"].ColumnName = "NodeID";
                    dt.Columns["NAME"].ColumnName = "Name";
                }

                if (BP.Difference.SystemConfig.AppCenterDBFieldCaseModel == FieldCaseModel.Lowercase)
                {
                    dt.Columns["nodeid"].ColumnName = "NodeID";
                    dt.Columns["name"].ColumnName = "Name";
                }


                ds.Tables.Add(dt);
            }

            #region 加入表单库目录.
            if (BP.Difference.SystemConfig.AppCenterDBType == DBType.Oracle)
                sql = "SELECT NO as No ,Name,ParentNo FROM Sys_FormTree ORDER BY  PARENTNO, IDX ";
            else
                sql = "SELECT No,Name,ParentNo FROM Sys_FormTree ORDER BY  PARENTNO, IDX ";

            dt = DBAccess.RunSQLReturnTable(sql);
            dt.TableName = "Sys_FormTree";

            dt.Columns[0].ColumnName = "No";
            dt.Columns[1].ColumnName = "Name";
            dt.Columns[2].ColumnName = "ParentNo";
            ds.Tables.Add(dt);

            //加入表单
            sql = "SELECT A.No, A.Name, A.FK_FormTree  FROM Sys_MapData A, Sys_FormTree B WHERE A.FK_FormTree=B.No";
            dt = DBAccess.RunSQLReturnTable(sql);
            dt.TableName = "Sys_MapData";
            ds.Tables.Add(dt);
           
            dt.Columns[0].ColumnName = "No";
            dt.Columns[1].ColumnName = "Name";
            dt.Columns[2].ColumnName = "FK_FormTree";
           
            #endregion 加入表单库目录.

            #region 加入流程树目录.
            sql = "SELECT No,Name,ParentNo FROM WF_FlowSort ORDER BY  PARENTNO, IDX ";

            dt = DBAccess.RunSQLReturnTable(sql);
            dt.TableName = "WF_FlowSort";
            if (BP.Difference.SystemConfig.AppCenterDBFieldCaseModel == FieldCaseModel.UpperCase)
            {
                dt.Columns["NO"].ColumnName = "No";
                dt.Columns["NAME"].ColumnName = "Name";
                dt.Columns["PARENTNO"].ColumnName = "ParentNo";
            }

            if (BP.Difference.SystemConfig.AppCenterDBFieldCaseModel == FieldCaseModel.Lowercase)
            {
                dt.Columns["no"].ColumnName = "No";
                dt.Columns["name"].ColumnName = "Name";
                dt.Columns["parentno"].ColumnName = "ParentNo";
            }

            ds.Tables.Add(dt);

            //加入表单
            sql = "SELECT No, Name, FK_FlowSort  FROM WF_Flow ";
            dt = DBAccess.RunSQLReturnTable(sql);
            dt.TableName = "WF_Flow";
            ds.Tables.Add(dt);
            if (BP.Difference.SystemConfig.AppCenterDBFieldCaseModel == FieldCaseModel.UpperCase)
            {
                dt.Columns["NO"].ColumnName = "No";
                dt.Columns["NAME"].ColumnName = "Name";
                dt.Columns["FK_FLOWSORT"].ColumnName = "FK_FlowSort";
            }
            if (BP.Difference.SystemConfig.AppCenterDBFieldCaseModel == FieldCaseModel.Lowercase)
            {
                dt.Columns["no"].ColumnName = "No";
                dt.Columns["name"].ColumnName = "Name";
                dt.Columns["fk_flowsort"].ColumnName = "FK_FlowSort";
            }
            #endregion 加入流程树目录.

            #region 数据源
            BP.Sys.SFDBSrcs ens = new BP.Sys.SFDBSrcs();
            ens.RetrieveAll();
            ds.Tables.Add(ens.ToDataTableField("SFDBSrcs"));
            #endregion

            //加入系统表.
            return BP.Tools.Json.ToJson(ds);
        }
        #endregion 如果是单据.




        /// <summary>
        /// 从本机装载表单模版
        /// </summary>
        /// <param name="fileByte">文件流</param>
        /// <param name="fk_mapData">表单模版ID</param>
        /// <param name="isClear">是否清空？</param>
        /// <returns>执行结果</returns>
        public string Imp_LoadFrmTempleteFromLocalFile()
        {
            try
            {
                if (HttpContextHelper.RequestFilesCount == 0)
                    return "err@请上传导入的模板文件.";

                //创建临时文件.
                string temp =  BP.Difference.SystemConfig.PathOfTemp + Guid.NewGuid() + ".xml";
                HttpContextHelper.UploadFile(HttpContextHelper.RequestFiles(0), temp);
                string fk_mapData = this.FK_MapData;
                MapData mapData = new MapData(fk_mapData);
                DataSet ds = new DataSet();
                ds.ReadXml(temp);

                //执行装载.
                MapData.ImpMapData(fk_mapData, ds);
                if (this.FK_Node != 0)
                {
                    Node nd = new Node(this.FK_Node);
                    nd.RepareMap(nd.HisFlow);
                }
                //清空缓存
                MapData mymd = new MapData(fk_mapData);
                mymd.RepairMap();
                if (mymd.HisEntityType == (int)EntityType.FrmBill)
                {
                    BP.CCBill.FrmBill bill = new FrmBill(mymd.No);
                    bill.EntityType = EntityType.FrmBill;
                    bill.BillNoFormat = "ccbpm{yyyy}-{MM}-{dd}-{LSH4}";

                    //设置默认的查询条件.
                    bill.SetPara("IsSearchKey", 1);
                    bill.SetPara("DTSearchWay", 0);

                    bill.Update();
                    bill.CheckEnityTypeAttrsFor_Bill();
                }

                #region 如果是实体 EnityNoName .
                if (mymd.HisEntityType == (int)EntityType.FrmDict)
                {
                    BP.CCBill.FrmDict entityDict = new FrmDict(mymd.No);
                    entityDict.BillNoFormat = "3"; //编码格式.001,002,003.
                    entityDict.BtnNewModel = 0;

                    //设置默认的查询条件.
                    entityDict.SetPara("IsSearchKey", 1);
                    entityDict.SetPara("DTSearchWay", 0);

                    entityDict.EntityType = EntityType.FrmDict;

                    entityDict.Update();
                    entityDict.CheckEnityTypeAttrsFor_EntityNoName();
                }
                SystemConfig.DoClearCash();
                return "执行成功.";
            }
            catch (Exception ex)
            {
                //第一次导入，可能因为没有字段，导致报错，系统会刷新一次，并修复字段
                //所以再执行一次导入
                try
                {
                    string fk_mapData = this.FK_MapData;

                    //读取上传的XML 文件.
                    DataSet ds = new DataSet();
                    //ds.ReadXml(path);
                    ds.ReadXml(HttpContextHelper.RequestFileStream(0));//this.context.Request.Files[0].InputStream

                    //执行装载.
                    MapData.ImpMapData(fk_mapData, ds);

                    if (this.FK_Node != 0)
                    {
                        Node nd = new Node(this.FK_Node);
                        nd.RepareMap(nd.HisFlow);
                    }
                    //清空缓存
                    MapData mymd = new MapData(fk_mapData);
                    mymd.RepairMap();
                    if (mymd.HisEntityType == (int)EntityType.FrmBill)
                    {
                        BP.CCBill.FrmBill bill = new FrmBill(mymd.No);
                        bill.EntityType = EntityType.FrmBill;
                        bill.BillNoFormat = "ccbpm{yyyy}-{MM}-{dd}-{LSH4}";

                        //设置默认的查询条件.
                        bill.SetPara("IsSearchKey", 1);
                        bill.SetPara("DTSearchWay", 0);

                        bill.Update();
                        bill.CheckEnityTypeAttrsFor_Bill();
                    }
                    #endregion 如果是单据.

                    #region 如果是实体 EnityNoName .
                    if (mymd.HisEntityType == (int)EntityType.FrmDict)
                    {
                        BP.CCBill.FrmDict entityDict = new FrmDict(mymd.No);
                        entityDict.BillNoFormat = "3"; //编码格式.001,002,003.
                        entityDict.BtnNewModel = 0;

                        //设置默认的查询条件.
                        entityDict.SetPara("IsSearchKey", 1);
                        entityDict.SetPara("DTSearchWay", 0);

                        entityDict.EntityType = EntityType.FrmDict;

                        entityDict.Update();
                        entityDict.CheckEnityTypeAttrsFor_EntityNoName();
                    }
                    SystemConfig.DoClearCash();
                    return "执行成功.";
                }
                catch (Exception newex)
                {
                    return "err@导入失败:" + newex.Message;
                }
            }
        }

        /// <summary>
        /// 从流程上copy表单
        /// @徐彪来调用.
        /// </summary>
        /// <returns></returns>
        public string Imp_CopyFromFlow()
        {
            string ndfrm = "ND" + int.Parse(this.FK_Flow) + "01";
            return Imp_CopyFrm(null, ndfrm);
        }
        public string Imp_FrmEnsName()
        {

            MapData md = new MapData(this.FrmID);

            Entity en = BP.En.ClassFactory.GetEns(this.EnsName).GetNewEntity;

            Attrs attrs = en.EnMap.Attrs;
            foreach (Attr item in attrs)
            {
                if (item.IsPK == true)
                    continue;

                MapAttr mapAttr = item.ToMapAttr;
                mapAttr.setMyPK(this.FrmID + "_" + item.Key);
                mapAttr.setFK_MapData(this.FrmID);
                mapAttr.Save();
            }

            return this.EnsName+"的属性导入["+this.FrmID+"]成功.";
        }

        /// <summary>
        /// 从表单库导入
        /// 从节点导入
        /// </summary>
        /// <returns></returns>
        public string Imp_FromsCopyFrm()
        {
            return Imp_CopyFrm();
        }
        /// <summary>
        /// 从节点上Copy
        /// </summary>
        /// <param name="fromMapData">从表单ID</param>
        /// <param name="fk_mapdata">到表单ID</param>
        /// <param name="isClear">是否清楚现有的元素？</param>
        /// <param name="isSetReadonly">是否设置为只读？</param>
        /// <returns>执行结果</returns>
        public string Imp_CopyFrm(string toFrmID = null, string fromFrmID = null)
        {
            try
            {
                if (toFrmID == null)
                    toFrmID = this.FK_MapData;


                string fromMapData = fromFrmID;
                if (fromMapData == null)
                    fromMapData = this.GetRequestVal("FromFrmID");

                bool isClear = this.GetRequestValBoolen("IsClear");
                bool isSetReadonly = this.GetRequestValBoolen("IsSetReadonly");

                //首先初始化本部门的.
                MapData mymd = new MapData(toFrmID);
                string frmSort = mymd.FK_FormTree; //表单类别,防止表单类别冲掉,导致表单树看不到他.


                MapData mdFrom = new MapData(fromMapData);
                DataSet ds = BP.Sys.CCFormAPI.GenerHisDataSet_AllEleInfo(mdFrom.No);

                MapData.ImpMapData(toFrmID, ds);

                //设置为只读模式.
                if (isSetReadonly == true)
                    MapData.SetFrmIsReadonly(toFrmID);

                //清空缓存
                mymd = new MapData(toFrmID);

                // 如果是节点表单，就要执行一次修复，以免漏掉应该有的系统字段。
                if (toFrmID.Contains("ND") == true)
                {
                    string fk_node = toFrmID.Replace("ND", "");
                    Node nd = new Node(int.Parse(fk_node));
                    nd.RepareMap(nd.HisFlow);

                    //设置节点ID.
                    mymd.Name = nd.Name;
                    mymd.FK_FormTree = "";
                    mymd.Update();

                    //如果包含ND，就保持附件的从表一致.
                    if (fromMapData.IndexOf("ND") == 0)
                    {
                        MapDtls dtls = new MapDtls(fromMapData);

                    }


                }
                else
                {
                    mymd.FK_FormTree = frmSort;
                    mymd.Update();

                }

                mymd.RepairMap();
                if (mymd.HisEntityType == (int)EntityType.FrmBill)
                {
                    BP.CCBill.FrmBill bill = new FrmBill(mymd.No);
                    bill.EntityType = EntityType.FrmBill;
                    bill.BillNoFormat = "ccbpm{yyyy}-{MM}-{dd}-{LSH4}";

                    //设置默认的查询条件.
                    bill.SetPara("IsSearchKey", 1);
                    bill.SetPara("DTSearchWay", 0);

                    bill.Update();
                    bill.CheckEnityTypeAttrsFor_Bill();
                }
                #endregion 如果是单据.

                #region 如果是实体 EnityNoName .
                if (mymd.HisEntityType == (int)EntityType.FrmDict)
                {
                    BP.CCBill.FrmDict entityDict = new FrmDict(mymd.No);
                    entityDict.BillNoFormat = "3"; //编码格式.001,002,003.
                    entityDict.BtnNewModel = 0;

                    //设置默认的查询条件.
                    entityDict.SetPara("IsSearchKey", 1);
                    entityDict.SetPara("DTSearchWay", 0);

                    entityDict.EntityType = EntityType.FrmDict;

                    entityDict.Update();
                    entityDict.CheckEnityTypeAttrsFor_EntityNoName();
                }
                SystemConfig.DoClearCash();
                return "执行成功.";
                #endregion

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

        #region 04.从外部数据源导入
        /// <summary>
        /// 选择一个数据源，进入步骤2
        /// </summary>
        /// <returns></returns>
        public string Imp_Src_Step2_Init()
        {
            SFDBSrc src = new SFDBSrc(this.GetRequestVal("FK_SFDBSrc"));

            //获取所有的表/视图
            DataTable dtTables = src.GetTables();

            return BP.Tools.FormatToJson.ToJson(dtTables);
        }

        /// <summary>
        /// 获取表字段
        /// </summary>
        /// <returns></returns>
        public string Imp_Src_Step2_GetColumns()
        {
            DataSet ds = new DataSet();

            //01.当前节点表单已经存在的列
            MapAttrs attrs = new MapAttrs(this.FK_MapData);
            ds.Tables.Add(attrs.ToDataTableField("MapAttrs"));

            //02.数据源表中的列
            SFDBSrc src = new SFDBSrc(this.GetRequestVal("FK_SFDBSrc"));
            DataTable tableColumns = src.GetColumns(this.GetRequestVal("STable"));
            tableColumns.TableName = "TableColumns";
            ds.Tables.Add(tableColumns);

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

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

            string SColumns = this.GetRequestVal("SColumns");
            SFDBSrc src = new SFDBSrc(this.GetRequestVal("FK_SFDBSrc"));
            DataTable tableColumns = src.GetColumns(this.GetRequestVal("STable"));

            //01.添加列
            DataTable dt = tableColumns.Clone();
            foreach (DataRow dr in tableColumns.Rows)
            {
                if (SColumns.Contains(dr["no"].ToString()))
                    dt.ImportRow(dr);
            }
            dt.TableName = "Columns";
            ds.Tables.Add(dt);

            //02.添加枚举
            SysEnums ens = new SysEnums(MapAttrAttr.MyDataType);
            ds.Tables.Add(ens.ToDataTableField("EnumsDataType"));
            ens = new SysEnums(MapAttrAttr.LGType);
            ds.Tables.Add(ens.ToDataTableField("EnumsLGType"));

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

        }

        public string Imp_Src_Step3_Save()
        {

            string hidImpFields = this.GetRequestVal("hidImpFields");
            string[] fields = hidImpFields.TrimEnd(',').Split(',');

            MapData md = new MapData();
            md.No = this.FK_MapData;
            md.RetrieveFromDBSources();


            string msg = "导入字段信息:";
            bool isLeft = true;
            for (int i = 0; i < fields.Length; i++)
            {
                string colname = fields[i];

                MapAttr ma = new MapAttr();
                ma.setKeyOfEn(colname);
                ma.Name = this.GetRequestVal("TB_Desc_" + colname);
                ma.setFK_MapData(this.FK_MapData);
                ma.MyDataType = int.Parse(this.GetRequestVal("DDL_DBType_" + colname));
                ma.setMaxLen(int.Parse(this.GetRequestVal("TB_Len_" + colname)));
                ma.UIBindKey = this.GetRequestVal("TB_BindKey_" + colname);
                ma.setMyPK(this.FK_MapData + "_" + ma.KeyOfEn);
                ma.LGType = BP.En.FieldTypeS.Normal;

                if (ma.UIBindKey != "")
                {
                    SysEnums se = new SysEnums();
                    se.Retrieve(SysEnumAttr.EnumKey, ma.UIBindKey);
                    if (se.Count > 0)
                    {
                        ma.setMyDataType(DataType.AppInt);
                        ma.LGType = BP.En.FieldTypeS.Enum;
                        ma.setUIContralType(BP.En.UIContralType.DDL);
                    }

                    SFTable tb = new SFTable();
                    tb.No = ma.UIBindKey;
                    if (tb.IsExits == true)
                    {
                        ma.setMyDataType(DataType.AppString);
                        ma.LGType = BP.En.FieldTypeS.FK;
                        ma.setUIContralType(BP.En.UIContralType.DDL);
                    }
                }

                if (ma.MyDataType == DataType.AppBoolean)
                    ma.UIContralType = BP.En.UIContralType.CheckBok;
                if (ma.IsExits)
                    continue;
                ma.Insert();

                msg += "\t\n字段:" + ma.KeyOfEn + "" + ma.Name + "加入成功.";

                isLeft = !isLeft;
            }


            return msg;

        }
        #endregion


    }
}