using System;
using System.Collections;
using System.Data;
using BP.DA;
using BP.Sys;

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

        /// <summary>
        /// 获取隐藏字段
        /// </summary>
        /// <returns></returns>
        public string Hiddenfielddata()
        {
            return BP.Sys.CCFormAPI.DB_Hiddenfielddata(this.FrmID);
        }
        /// <summary>
        /// 
        /// </summary>
        /// <returns></returns>
        public string PublicNoName_InitFieldVal()
        {
            string sql = "";
            Hashtable ht = new Hashtable();

            string ctrlType = this.GetRequestVal("CtrlType");
            int num = 1;
            Paras ps = new Paras();
            switch (ctrlType)
            {
                case "Dtl":
                    ps.SQL = "SELECT COUNT(*) FROM Sys_MapDtl WHERE FK_MapData=" + BP.Difference.SystemConfig.AppCenterDBVarStr + "FK_MapData";
                    ps.Add("FK_MapData", this.FrmID);
                    //sql = "SELECT COUNT(*) FROM Sys_MapDtl WHERE FK_MapData='" + this.FrmID + "'";
                    num = DBAccess.RunSQLReturnValInt(ps) + 1;
                    ht.Add("No", this.FrmID + "Dtl" + num);
                    ht.Add("Name", "从表" + num);
                    break;
                case "AthMulti":
                    ps.SQL = "SELECT COUNT(*) FROM Sys_FrmAttachment WHERE FK_MapData=" + BP.Difference.SystemConfig.AppCenterDBVarStr + "FK_MapData";
                    ps.Add("FK_MapData", this.FrmID);
                    //sql = "SELECT COUNT(*) FROM Sys_FrmAttachment WHERE FK_MapData='" + this.FrmID + "'";
                    num = DBAccess.RunSQLReturnValInt(ps) + 1;
                    ht.Add("No", "AthMulti" + num);
                    ht.Add("Name", "多附件" + num);
                    break;
                case "ImgAth":
                    ps.SQL = "SELECT COUNT(*) FROM Sys_FrmImgAth WHERE FK_MapData=" + BP.Difference.SystemConfig.AppCenterDBVarStr + "FK_MapData";
                    ps.Add("FK_MapData", this.FrmID);
                    //sql = "SELECT COUNT(*) FROM Sys_FrmImgAth WHERE FK_MapData='" + this.FrmID + "'";
                    num = DBAccess.RunSQLReturnValInt(ps) + 1;
                    ht.Add("No", "ImgAth" + num);
                    ht.Add("Name", "图片附件" + num);
                    break;
                case "AthSingle":
                    ps.SQL = "SELECT COUNT(*) FROM Sys_FrmAttachment WHERE FK_MapData=" + BP.Difference.SystemConfig.AppCenterDBVarStr + "FK_MapData";
                    ps.Add("FK_MapData", this.FrmID);
                    //sql = "SELECT COUNT(*) FROM Sys_FrmAttachment WHERE FK_MapData='" + this.FrmID + "'";
                    num = DBAccess.RunSQLReturnValInt(ps) + 1;
                    ht.Add("No", "AthSingle" + num);
                    ht.Add("Name", "单附件" + num);
                    break;
                case "AthImg":
                    ps.SQL = "SELECT COUNT(*) FROM Sys_FrmImgAth WHERE FK_MapData=" + BP.Difference.SystemConfig.AppCenterDBVarStr + "FK_MapData";
                    ps.Add("FK_MapData", this.FrmID);
                    //sql = "SELECT COUNT(*) FROM Sys_FrmImgAth WHERE FK_MapData='" + this.FrmID + "'";
                    num = DBAccess.RunSQLReturnValInt(ps) + 1;
                    ht.Add("No", "AthImg" + num);
                    ht.Add("Name", "图片附件" + num);
                    break;
                case "HandSiganture": //手写板.
                    ps.SQL = "SELECT COUNT(*) FROM Sys_FrmEle WHERE FK_MapData=" + BP.Difference.SystemConfig.AppCenterDBVarStr + "FK_MapData" + " AND EleType=" + BP.Difference.SystemConfig.AppCenterDBVarStr + "EleType";
                    ps.Add("FK_MapData", this.FrmID);
                    ps.Add("EleType", ctrlType);
                    //sql = "SELECT COUNT(*) FROM Sys_FrmEle WHERE FK_MapData='" + this.FrmID + "' AND EleType='"+ctrlType+"'";
                    num = DBAccess.RunSQLReturnValInt(ps) + 1;
                    ht.Add("No", "HandSiganture" + num);
                    ht.Add("Name", "签字板" + num);
                    break;
                case "iFrame": //框架
                    ps.SQL = "SELECT COUNT(*) FROM Sys_FrmEle WHERE FK_MapData=" + BP.Difference.SystemConfig.AppCenterDBVarStr + "FK_MapData" + " AND EleType=" + BP.Difference.SystemConfig.AppCenterDBVarStr + "EleType";
                    ps.Add("FK_MapData", this.FrmID);
                    ps.Add("EleType", ctrlType);
                    //sql = "SELECT COUNT(*) FROM Sys_FrmEle WHERE FK_MapData='" + this.FrmID + "' AND EleType='" + ctrlType + "'";
                    num = DBAccess.RunSQLReturnValInt(ps) + 1;
                    ht.Add("No", "iFrame" + num);
                    ht.Add("Name", "框架" + num);
                    break;
                case "Fieldset": //分组
                    ps.SQL = "SELECT COUNT(*) FROM Sys_FrmEle WHERE FK_MapData=" + BP.Difference.SystemConfig.AppCenterDBVarStr + "FK_MapData" + " AND EleType=" + BP.Difference.SystemConfig.AppCenterDBVarStr + "EleType";
                    ps.Add("FK_MapData", this.FrmID);
                    ps.Add("EleType", ctrlType);
                    //sql = "SELECT COUNT(*) FROM Sys_FrmEle WHERE FK_MapData='" + this.FrmID + "' AND EleType='" + ctrlType + "'";
                    num = DBAccess.RunSQLReturnValInt(ps) + 1;
                    ht.Add("No", "Fieldset" + num);
                    ht.Add("Name", "分组" + num);
                    break;
                default:
                    ht.Add("No", ctrlType + 1);
                    ht.Add("Name", ctrlType + 1);
                    break;
            }

            return BP.Tools.Json.ToJsonEntityModel(ht);
        }

        #region 枚举界面.
        /// <summary>
        /// 获得外键列表.
        /// </summary>
        /// <returns></returns>
        public string FrmTable_GetSFTableList()
        {
            //WF_Admin_FoolFormDesigner wf = new WF_Admin_FoolFormDesigner(this.context);
            SFTables ens = new SFTables();
            ens.RetrieveAll();
            return ens.ToJson();
        }
        #endregion 枚举界面.

        #region 执行父类的重写方法.
        /// <summary>
        /// 默认执行的方法
        /// </summary>
        /// <returns></returns>
        protected override string DoDefaultMethod()
        {
            //找不不到标记就抛出异常.
            throw new Exception("@标记[" + this.DoType + "]，没有找到.");
        }
        #endregion 执行父类的重写方法.


        #region 功能界面 .
        /// <summary>
        /// 转化拼音 @李国文.
        /// </summary>
        /// <returns>返回转换后的拼音</returns>
        public string FrmTextBox_ParseStringToPinyin()
        {
            string name = GetRequestVal("name");

            string flag = this.GetRequestVal("flag");
            flag = DataType.IsNullOrEmpty(flag) == true ? "true" : flag.ToLower();

            //此处配置最大长度为20，edited by liuxc,2017-9-25
            return BP.Sys.CCFormAPI.ParseStringToPinyinField(name, Equals(flag, "true"), true, 20);
        }
        #endregion 功能界面方法.

        /// <summary>
        /// 获得表单对应的物理表特定的数据类型字段
        /// </summary>
        /// <returns></returns>
        public string FrmTextBoxChoseOneField_Init()
        {
            DataTable mydt = MapData.GetFieldsOfPTableMode2(this.FrmID);
            mydt.TableName = "dt";
            return BP.Tools.Json.ToJson(mydt);
        }
    }
}