コード例 #1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            string        key    = Request.QueryString["key"];
            StringBuilder strStr = new StringBuilder();

            string D_Id       = string.Empty;
            string D_Name     = string.Empty;
            string D_Type     = string.Empty;
            string strIsClick = string.Empty;
            string strTemp    = string.Empty;
            int    PageIndex  = 0;
            int    PageSize   = 0;
            int    rCount     = 0;
            int    pCount     = 0;
            string strJson    = string.Empty;
            string strIds     = string.Empty;
            string strWhere   = string.Empty;
            string DocColJson = string.Empty;

            strPageName = Request["strPageName"];
            string IsPY = "1";

            if (string.IsNullOrEmpty(key))
            {
                key = Request["key"];
            }
            switch (key)
            {
                #region 分页面获取通用字典项
            case "AjaxAutoCompletePaged":
                strJson = string.Empty;
                string strCondition = string.Empty;

                if (!String.IsNullOrEmpty(Request["PageIndex"]))
                {
                    int.TryParse(Request["PageIndex"].ToString(), out PageIndex);
                }
                if (!String.IsNullOrEmpty(Request["PageSize"]))
                {
                    int.TryParse(Request["PageSize"].ToString(), out PageSize);
                }
                if (!String.IsNullOrEmpty(Request["D_Name"]))
                {
                    D_Name = Request["D_Name"].ToString();
                }
                if (!String.IsNullOrEmpty(Request["D_Type"]))
                {
                    D_Type = Request["D_Type"].ToString();
                }
                if (!String.IsNullOrEmpty(Request["IsPY"]))
                {
                    IsPY = Request["IsPY"].ToString();
                }
                if (!String.IsNullOrEmpty(Request["isClick"]))
                {
                    strIsClick = Request["isClick"].ToString();
                }

                if (!string.IsNullOrWhiteSpace(Request["ConditionIn"]))
                {
                    string[] arr = Request["ConditionIn"].Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries);
                    strWhere += " and " + arr[0] + " in(" + arr[1] + ")";
                }
                if (!string.IsNullOrWhiteSpace(Request["ConditionNotIn"]))
                {
                    string[] arr = Request["ConditionNotIn"].Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries);
                    strWhere += " and " + arr[0] + " not in(" + arr[1] + ")";
                }
                //TextColumn: TextColumn         , ValueColumn: ValueColumn
                //查询字段
                string Like = string.IsNullOrWhiteSpace(Request["Like"]) ? "0" : Request["Like"].ToString().Trim();
                string IsJP = string.IsNullOrWhiteSpace(Request["IsJP"]) ? "1" : Request["IsJP"].ToString().Trim();
                if (!string.IsNullOrWhiteSpace(Request["WhereColumn"]))
                {
                    string[] arr = Request["WhereColumn"].Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
                    if (D_Name != "")
                    {
                        strWhere += " and ( 1<>1 ";
                        for (int i = 0; i < arr.Length; i++)
                        {
                            strWhere += " or " + arr[i] + " like '" + getLikeStr(D_Name, Like) + "'";

                            if (IsJP == "1")
                            {
                                strWhere += " or dbo.f_GetPy(" + arr[i] + ") like '" + getLikeStr(D_Name, Like) + "'";
                            }
                        }
                        strWhere += ") ";
                    }
                }
                else
                {
                    strWhere += " and (";
                    strWhere += " D_Name like '" + getLikeStr(D_Name, Like) + "'";
                    if (IsJP == "1")
                    {
                        strWhere += " or dbo.f_GetPy(d_name) like '" + getLikeStr(D_Name, Like) + "'";
                    }
                    strWhere += ")";
                }


                //显示字段: 排序字段, 显示文本, 隐藏值。
                string select = string.Empty;
                //排序字段
                if (!string.IsNullOrWhiteSpace(Request["Order"]))
                {
                    select = " row_number() over(order by " + Request["Order"] + ") AS r_n,";
                }
                else
                {
                    select = " row_number() over(order by D_Order,D_Name) AS r_n,";
                }
                //显示文本
                if (!string.IsNullOrWhiteSpace(Request["TextColumn"]))
                {
                    select += "(" + getSelectRegex(Request["TextColumn"]) + ") as D_name,";
                }
                else
                {
                    select += "D_name,";
                }
                //隐藏值
                if (!string.IsNullOrWhiteSpace(Request["ValueColumn"]))
                {
                    select += "(" + getSelectRegex(Request["ValueColumn"]) + ") as Common_Dict_ID,";
                }
                else
                {
                    select += "Common_Dict_ID, ";
                }
                //其他显示列
                select += "D_Value,D_Code,D_Level,D_Order,D_Type,D_Remark,D_CreateUser,D_CreateTime,D_ModifyUser,D_ModifyTime ";

                #region 分页得到通用字典项
                try
                {
                    strStr = new StringBuilder();
                    var varData = new BLL_PublicClass().GetIntelligentAssociationList(D_Type, select, strWhere, PageIndex, PageSize, out rCount, out pCount);
                    if (varData.Count == 0)
                    {
                        strJson = "2";
                    }
                    else
                    {
                        System.Web.Script.Serialization.JavaScriptSerializer objJson = new System.Web.Script.Serialization.JavaScriptSerializer();
                        strJson = objJson.Serialize(varData);
                        strJson = strJson + "~" + GetHtmlPage(rCount, PageIndex, PageSize, pCount, strIsClick);
                    }
                }
                catch
                {
                    //strJson = ex.Message.ToString();
                    strJson = "0";
                }

                Response.Write(strJson.ToString());
                Response.End();
                break;
                #endregion
                #endregion
            }
        }
コード例 #2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            string        key    = Request.QueryString["key"];
            StringBuilder strStr = new StringBuilder();
            //string HospitalID = string.Empty;
            string userControlID = string.Empty;
            string D_Id          = string.Empty;
            string D_Name        = string.Empty;
            string D_Type        = string.Empty;
            string strTemp       = string.Empty;
            int    PageIndex     = 0;
            int    PageSize      = 0;
            int    rCount        = 0;
            int    pCount        = 0;
            string IsPY          = "0";
            string strJson       = string.Empty;
            string strIds        = string.Empty;
            string strWhere      = string.Empty;
            string DocColJson    = string.Empty;

            strPageName = Request["strPageName"];

            if (string.IsNullOrEmpty(key))
            {
                key = Request["key"];
            }
            switch (key)
            {
                #region 获取通用视图字典 NOW
                #region 获取已选取通用视图字典项 NOW
            case "CommonCtrlMultiple":

                strJson = "2";
                try
                {
                    if (!String.IsNullOrEmpty(Request["Ids"]))
                    {
                        strIds = Request["Ids"].ToString();
                        for (int i = 0; i < strIds.Split(',').Length; i++)
                        {
                            strTemp += "'" + strIds.Split(',')[i] + "',";
                        }
                        strTemp  = strTemp.TrimEnd(',');
                        strWhere = String.Format(" Common_Dict_ID in({0})", strTemp);
                        if (!String.IsNullOrWhiteSpace(Request["D_Type"]))
                        {
                            strWhere += String.Format(" AND D_Type ='{0}'", Request["D_Type"].ToString());
                        }
                        strStr = new StringBuilder();
                        var varData = new BLL_PublicClass().GetCommon_Dict_List(strWhere, Request["D_Type"].Trim());
                        if (varData.Count == 0)
                        {
                            strJson = "2";
                        }
                        else
                        {
                            System.Web.Script.Serialization.JavaScriptSerializer objJson = new System.Web.Script.Serialization.JavaScriptSerializer();
                            strJson = objJson.Serialize(varData);
                        }
                    }
                }
                catch
                {
                    //strJson = ex.Message.ToString();
                    strJson = "0";
                }
                Response.Write(strJson);
                Response.End();
                break;

                #endregion
                #region 分页面获取通用字典项
            case "CommonCtrlMultiplePaged":
                strJson = string.Empty;
                string strCondition = string.Empty;
                strWhere = string.Empty;
                if (!String.IsNullOrEmpty(Request["userControlID"]))
                {
                    userControlID = Request["userControlID"].ToString();
                }
                if (!String.IsNullOrEmpty(Request["PageIndex"]))
                {
                    int.TryParse(Request["PageIndex"].ToString(), out PageIndex);
                }
                if (!String.IsNullOrEmpty(Request["PageSize"]))
                {
                    int.TryParse(Request["PageSize"].ToString(), out PageSize);
                }
                if (!String.IsNullOrEmpty(Request["D_Name"]))
                {
                    D_Name = Request["D_Name"].ToString();
                }
                if (!String.IsNullOrEmpty(Request["D_Type"]))
                {
                    D_Type = Request["D_Type"].ToString();
                }
                if (!String.IsNullOrEmpty(Request["Condition"]))
                {
                    //字段名1,字段名2|值1,值2
                    strCondition = Request["Condition"].ToString();
                    strTemp      = string.Empty;

                    strTemp = clsUtility.Decrypt(strCondition);
                    string strT1 = strTemp.Split('|')[0];
                    string strT2 = strTemp.Split('|')[1];

                    if (strT1.Split(',').Count() == strT2.Split(',').Count())
                    {
                        for (int i = 0; i < strT1.Split(',').Count(); i++)
                        {
                            strWhere += " and " + strT1.Split(',')[i] + " = '" + strT2.Split(',')[i] + "'";
                        }
                    }
                    else
                    {
                        strWhere = string.Empty;
                    }
                }
                #region 分页得到通用字典项
                try
                {
                    strStr = new StringBuilder();
                    var varData = new BLL_PublicClass().GetCommonMultiselect(IsPY, D_Name, D_Type, strWhere, PageIndex, PageSize, out rCount, out pCount);
                    if (varData.Count == 0)
                    {
                        strJson = "2";
                    }
                    else
                    {
                        System.Web.Script.Serialization.JavaScriptSerializer objJson = new System.Web.Script.Serialization.JavaScriptSerializer();
                        strJson = objJson.Serialize(varData);
                        strJson = strJson + "~" + GetHtmlPage(rCount, PageIndex, PageSize);
                    }
                }
                catch
                {
                    //strJson = ex.Message.ToString();
                    strJson = "0";
                }
                Response.Write(strJson.ToString());
                Response.End();
                break;
                #endregion
                #endregion
                #endregion
            }
        }