예제 #1
0
    /// <summary>
    /// 获取WEC_REQUEST对象
    /// 找不到或找到但是状态为禁止,都返回null
    /// //ygh 2014/3/7
    /// </summary>
    /// <param name="text"></param>
    /// <returns></returns>
    public WEC_REQUEST getWECREQUEST(string content_str)
    {
        WEC_REQUEST cond = new WEC_REQUEST();

        cond.KEYWORD = content_str;
        cond.OrderBy("TID desc");
        WEC_REQUEST objVal = BLLTable <WEC_REQUEST> .GetRowData(cond);

        if (objVal == null || objVal.STATUS == 1)
        {
            WEC_REQUEST cond1 = new WEC_REQUEST();
            cond1.MATCH_TYPE  = 1;//1为包含匹配
            cond1.af_WhereSQL = "AND CHARINDEX(KEYWORD,'" + content_str + "') >0";
            cond1.OrderBy("TID desc");
            WEC_REQUEST objVal1 = BLLTable <WEC_REQUEST> .GetRowData(cond1);

            if (objVal1 == null || objVal1.STATUS == 1)
            {
                return(null);
            }
            return(objVal1);
        }
        //List<WEC_REQUEST> lst = BLLTable<WEC_REQUEST>.Select(new WEC_REQUEST(), cond);
        //cond1.Like(WEC_REQUEST.Attribute.KEYWORD, content_str);
        return(objVal);
    }
예제 #2
0
    protected void Page_Load(object sender, EventArgs e)
    {
        #region//默认隐藏的列
        //hideTableColumnList = new List<AttributeItem>();
        //hideTableColumnList.Add(WEC_REQUEST.Attribute.EXP1);
        //hideTableColumnList.Add(WEC_REQUEST.Attribute.EXP2);
        //hideTableColumnList.Add(WEC_REQUEST.Attribute.EXP3);
        //valObj.LoadAllAttributes(true);//暂时加此代码,以后框架更新将不需要
        //valObj.Remove(hideTableColumnList);

        //hideFindColumnList = new List<AttributeItem>();
        //hideFindColumnList.Add(WEC_REQUEST.Attribute.EXP1);
        //hideFindColumnList.Add(WEC_REQUEST.Attribute.EXP2);
        //hideFindColumnList.Add(WEC_REQUEST.Attribute.EXP3);
        #endregion
        condObj.OrderBy(WEC_REQUEST.Attribute.TID, Order.Desc);

        if (!IsPostBack)
        {
            btnFind.Text              = LanguageService.GetLanguageString("btnFind", "查询");
            aspPager.PageSize         = 10;
            aspPager.CurrentPageIndex = 1;

            if (!string.IsNullOrEmpty(Request["ids"]))
            {
                WEC_REQUEST roleOld = new WEC_REQUEST();
                roleOld.Where(WEC_REQUEST.Attribute.TID, Request["ids"].ToString());
                listObj = BLLTable <WEC_REQUEST> .Select(valObj, roleOld);

                for (int i = 0; i < listObj.Count; i++)
                {
                    if (i > 0)
                    {
                        hidOld.Value     += ",";
                        hidInitIDS.Value += ",";
                    }
                    hidOld.Value     += "{ID:'" + listObj[i].TID + "',Name:'" + listObj[i].TID + "'}";//这里的Name用于显示在列表中,请自行重定义。
                    hidInitIDS.Value += listObj[i].TID;
                }
            }
            try
            {
                listObj = BLLTable <WEC_REQUEST> .SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount);

                repList.DataSource = listObj;
                repList.DataBind();
                aspPager.RecordCount = recount;
            }
            catch (Exception ex)
            {
                litWarn.Text = ex.Message;
            }
        }
    }