using System.Data;
using BP.DA;
using BP.Sys;
using BP.Web;
using BP.En;
using BP.WF.Template;

namespace BP.WF.HttpHandler
{
    /// <summary>
    /// 页面功能实体
    /// </summary>
    public class WF_Admin_AttrNode_FrmSln : BP.WF.HttpHandler.DirectoryPageBase
    {
        /// <summary>
        /// 构造函数
        /// </summary>
        public WF_Admin_AttrNode_FrmSln()
        {

        }
        /// <summary>
        /// 设置该流程的所有节点都是用该方案。
        /// </summary>
        /// <returns></returns>
        public string RefOneFrmTree_SetAllNodeFrmUseThisSln()
        {
            string nodeID = GetRequestVal("FK_Node");
            Node currNode = new Node(nodeID);
            string flowNo = currNode.FK_Flow;
            Nodes nds = new Nodes();
            nds.Retrieve("FK_Flow", flowNo);

            //求出来组件s.
            MapAttrs attrOfCommpents = new MapAttrs();
            QueryObject qo = new QueryObject(attrOfCommpents);
            qo.AddWhere(MapAttrAttr.FK_MapData, currNode.NodeFrmID);
            qo.addAnd();
            qo.AddWhere(MapAttrAttr.UIContralType, ">=", 6);
            qo.DoQuery();

         //   attrOfCommpents.Retrieve(MapAttrAttr.FK_MapData,
           // currNode.)

            for (var i = 0; i < nds.Count; i++)
            {

                Node jsNode = nds[i] as Node;
                if (jsNode.NodeID == currNode.NodeID)
                    continue;

                //修改表单属性
                jsNode.FormType = currNode.FormType;
               
                jsNode.NodeFrmID = currNode.NodeFrmID;
                jsNode.Update();

                //节点表单属性
                //先删除掉已有的，避免换绑时出现垃圾数据.
                FrmNodes ens = new FrmNodes();
                ens.Retrieve("FK_Node", jsNode.NodeID);

                //是不是该frmNode已经存在？
                var isHave = false;
                for (var idx = 0; idx < ens.Count; idx++)
                {
                    FrmNode en = ens[idx] as FrmNode;
                    if (en.FK_Frm != currNode.NodeFrmID)
                    {
                        FrmNode Frm = new FrmNode(en.MyPK);
                        Frm.Delete();
                        continue;
                    }
                    isHave = true;
                }
                if (isHave == true)
                    continue; //已经存在就不处理.

                FrmNode frmNode = new FrmNode();
                frmNode.setMyPK(jsNode.NodeFrmID + "_" + jsNode.NodeID + "_" + jsNode.FK_Flow);
                frmNode.FK_Node = jsNode.NodeID;
                frmNode.FK_Flow = jsNode.FK_Flow;
                frmNode.FK_Frm = jsNode.NodeFrmID;

                //判断是否为开始节点
                string nodeID1 = jsNode.NodeID.ToString();
                if (nodeID1.Substring(nodeID1.Length - 2) == "01")
                {
                    frmNode.FrmSln = FrmSln.Default; //默认方案
                }
                else
                {
                    frmNode.FrmSln = FrmSln.Readonly; //只读方案
                }
                frmNode.Insert();

                //设置组件都是可用的.
                BP.WF.Template.FrmField ff = new FrmField();
                foreach (MapAttr attr in attrOfCommpents)
                {
                    ff.setUIVisible(true);
                    ff.setKeyOfEn(attr.KeyOfEn);
                    ff.FK_Flow = currNode.FK_Flow;
                    ff.FK_Node = jsNode.NodeID;
                    ff.setFK_MapData(jsNode.NodeFrmID); //表单ID.
                    ff.setMyPK(ff.FK_MapData + "_" + ff.FK_Node + "_" + ff.KeyOfEn);
                    if (ff.IsExits == false)
                        ff.Insert();
                }
            }

            return "执行成功.";
        }
        /// <summary>
        /// 获得下拉框的值.
        /// </summary>
        /// <returns></returns>
        public string BatchEditSln_InitDDLData()
        {
            DataSet ds = new DataSet();

            SysEnums ses = new SysEnums("FrmSln");
            ds.Tables.Add(ses.ToDataTableField("FrmSln"));

            SysEnums se1s = new SysEnums("FWCSta");
            ds.Tables.Add(se1s.ToDataTableField("FWCSta"));

            //签字类型.
            SysEnums myses = new SysEnums("SigantureEnabel");
            ds.Tables.Add(myses.ToDataTableField("SigantureEnabel"));

            string sql = Glo.SQLOfCheckField.Replace("@FK_Frm", this.FrmID);
            DataTable dt = DBAccess.RunSQLReturnTable(sql);
            if (BP.Difference.SystemConfig.AppCenterDBFieldCaseModel != FieldCaseModel.None)
            {
                dt.Columns[0].ColumnName = "No";
                dt.Columns[1].ColumnName = "Name";
            }
                
            dt.TableName = "CheckFields";
            ds.Tables.Add(dt);
            return BP.Tools.Json.ToJson(ds);
        }

        /// <summary>
        /// 返回
        /// </summary>
        /// <returns></returns>
        public string RefOneFrmTreeFrms_Init()
        {
            string sql = "";
            string key = GetRequestVal("KeyWord");//查询的关键字
            //单机模式下
            if (Glo.CCBPMRunModel == CCBPMRunModel.Single)
            {
                sql += "SELECT  b.NAME AS SortName, a.no AS \"No\", A.name AS \"Name\",";
                sql += "A.PTable,";
                sql += "A.OrgNo ";
                sql += "FROM ";
                sql += "Sys_MapData A, ";
                sql += "Sys_FormTree B ";
                sql += " WHERE ";
                sql += " A.FK_FormTree = B.NO ";
                //sql += " AND B.OrgNo = '" + WebUser.OrgNo + "'";
                if (DataType.IsNullOrEmpty(key) == false)
                    sql += " AND A.Name like '%" + key + "%'";
                sql += "ORDER BY B.IDX,A.IDX";

            }

            // 云服务器环境下
            if (Glo.CCBPMRunModel == CCBPMRunModel.SAAS)
            {
                sql += "SELECT  b.NAME AS SortName, a.no AS \"No\", A.name AS \"Name\", ";
                sql += "A.PTable, ";
                sql += "A.OrgNo ";
                sql += "FROM ";
                sql += "Sys_MapData A, ";
                sql += "Sys_FormTree B ";
                sql += " WHERE ";
                sql += " A.FK_FormTree = B.NO ";
                sql += " AND B.OrgNo = '" + WebUser.OrgNo + "' ";
                if (DataType.IsNullOrEmpty(key) == false)
                    sql += " AND A.Name like '%" + key + "%'";
                sql += "ORDER BY B.IDX,A.IDX";
            }

            //集团模式下
            if (Glo.CCBPMRunModel == CCBPMRunModel.GroupInc)
            {
                sql += " SELECT  b.NAME AS SortName, a.no AS \"No\", A.name AS \"Name\",";
                sql += "A.PTable,";
                sql += "A.OrgNo, '"+BP.Web.WebUser.OrgName+"' as OrgName ";
                sql += "FROM ";
                sql += "Sys_MapData A, ";
                sql += "Sys_FormTree B, ";
                sql += "Port_Org C ";
                sql += " WHERE ";
                sql += " A.FK_FormTree = B.NO ";
                sql += " AND B.OrgNo = '" + WebUser.OrgNo + "' ";
                sql += " AND C.No =B.OrgNo ";
                if (DataType.IsNullOrEmpty(key) == false)
                    sql += " AND A.Name like '%" + key + "%'";

                sql += " UNION  ";

                sql += " SELECT  '- 共享 -' AS SortName, a.no AS \"No\", A.name AS \"Name\", ";
                sql += " A.PTable, A.OrgNo, '其他组织' as OrgName ";
                sql += " FROM ";
                sql += " Sys_MapData A,  WF_FrmOrg B, Port_Org C ";
                sql += " WHERE ";
                sql += "  A.No = B.FrmID  AND B.OrgNo=C.No ";
                sql += "  AND B.OrgNo = '" + WebUser.OrgNo + "' ";
                if (DataType.IsNullOrEmpty(key) == false)
                    sql += " AND A.Name like '%" + key + "%'";
            }

            DataTable dt = DBAccess.RunSQLReturnTable(sql);

            #warning 需要判断不同的数据库类型
            if (BP.Difference.SystemConfig.AppCenterDBFieldCaseModel == FieldCaseModel.UpperCase)
            {
                dt.Columns["SORTNAME"].ColumnName = "SortName";
                dt.Columns["NO"].ColumnName = "No";
                dt.Columns["NAME"].ColumnName = "Name";
                dt.Columns["PTABLE"].ColumnName = "PTable";
                dt.Columns["ORGNO"].ColumnName = "OrgNo";
            }
            if (BP.Difference.SystemConfig.AppCenterDBFieldCaseModel == FieldCaseModel.Lowercase)
            {
                dt.Columns["sortname"].ColumnName = "SortName";
                dt.Columns["no"].ColumnName = "No";
                dt.Columns["name"].ColumnName = "Name";
                dt.Columns["ptable"].ColumnName = "PTable";
                dt.Columns["orgno"].ColumnName = "OrgNo";
            }

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

    }
}