<rt id="bn8ez"></rt>
<label id="bn8ez"></label>

  • <span id="bn8ez"></span>

    <label id="bn8ez"><meter id="bn8ez"></meter></label>

         public void BindData()
            {
                string FidTemp = Fid.Length < 1 ? ("") : (" and FirstSort='" + Fid + "'");
                string SidTemp = Sid.Length < 1 ? ("") : (" and SecSort='" + Sid + "'");
                string TidTemp = Tid.Length < 1 ? ("") : (" and [Sort]='" + Tid + "'");
                string idKeyWord =  this.GetRequest("idKeyWord").Trim();
                idKeyWord = idKeyWord.Length>0&&idKeyWord!="請輸入關(guān)鍵字"?(" and [CompanyName] like '%"+idKeyWord+"%'"):("");
                string idProvince = HttpUtility.UrlDecode(this.GetRequest("idProvince"));
                idProvince = idProvince.Length > 0&&idProvince!="不限" ? (" and [Province] = '" + idProvince + "'") : ("");
                string idCity = this.GetRequest("idCity");
                idCity = idCity.Length > 0 &&idCity!="不限"? (" and [City] = '" + idCity + "'") : ("");
                string idArea = this.GetRequest("idArea");
                idArea = idArea.Length > 0 &&idArea!="不限"? (" and [Area] ='" + idArea + "'") : ("");
                string idCoMode = this.GetRequest("idCoMode");
                idCoMode = idCoMode.Length > 0 && idCoMode != "0" ? (" and [DealType] like '%" + (idCoMode == "1" ? ("生產(chǎn)型") : (idCoMode == "2" ? ("貿(mào)易型") : (idCoMode == "3" ? ("服務(wù)型") : (idCoMode == "4" ? ("政府或其他機(jī)構(gòu)") : (""))))) + "%'") : ("");
                string idIsGender = this.GetRequest("idIsGender");
                idIsGender = idIsGender == "true" ? (" and [Genderid]=1") : ("");

                this.PageSize = 20;
                this.Columns = "  [domain],[C_ID],[CompanyName],[Introduce],[DealType],[MainProduct],[Province],[City],[Area],case  [Genderid] when 0 then '/img/mfree.jpg' when 1 then '/img/mvip.jpg' when 2 then '/img/mvip.jpg' end as Genderid,[Scores],[regTime],[regMoney],[PQQ],[PMSN]";
                this.TableName = "V_CompanysList";
                this.Where = string.Format(" 1=1{0}{1}{2}{3}{4}{5}{6}{7}{8}", idKeyWord, idProvince, idCity, idArea, idCoMode, idIsGender, FidTemp, SidTemp, TidTemp);
                this.Order = "Genderid desc,AddTime desc,C_ID desc";
                this.Pid = "C_ID";
                this.ResultCount = this.CurrentPage>25?(""):"500";
                this.Distinct = "distinct";

                this.Pages1.NumCount= Convert.ToInt32(this.Db.GetOne(string.Format("select count(C_ID) from V_CompanysList where {0}", Where)));
                this.Pages1.PageSize = this.PageSize;
                this.Pages1.CurrentPage = this.CurrentPage;

                this.RRpList.DataSource = this.PageData;
                this.RRpList.DataBind();
            }

    posted on 2009-06-22 14:55 sanmao 閱讀(76) 評論(0)  編輯  收藏

    只有注冊用戶登錄后才能發(fā)表評論。


    網(wǎng)站導(dǎo)航:
     

    常用鏈接

    留言簿(5)

    隨筆分類

    隨筆檔案

    搜索

    •  

    最新評論

    閱讀排行榜

    評論排行榜

    主站蜘蛛池模板: 精品国产亚洲一区二区在线观看| 国产精品无码永久免费888| 亚洲精品午夜国产VA久久成人| 成在人线AV无码免费| 高清一区二区三区免费视频| 免费国产黄网站在线看| 中国亚洲呦女专区| 亚洲一区二区在线免费观看| 亚洲中文字幕久久精品无码APP| 四只虎免费永久观看| 成年女人免费v片| 97在线视频免费| 人人揉揉香蕉大免费不卡| 高清永久免费观看 | 污视频在线免费观看| 亚欧国产一级在线免费| 国产AV日韩A∨亚洲AV电影 | 大学生a级毛片免费观看| 91久久成人免费| 最近中文字幕完整免费视频ww| 国产午夜免费高清久久影院| 男女拍拍拍免费视频网站| 日本黄页网址在线看免费不卡| 日本系列1页亚洲系列| 亚洲国产精品久久久久秋霞小| 亚洲偷偷自拍高清| 亚洲午夜国产精品| 亚洲一卡2卡4卡5卡6卡残暴在线| 亚洲精品mv在线观看| 亚洲美女激情视频| 日韩精品亚洲人成在线观看| 亚洲AV乱码久久精品蜜桃 | 亚欧免费一级毛片| 久久爰www免费人成| 亚在线观看免费视频入口| 久久精品视频免费播放| 最近免费中文字幕大全免费| 久久午夜夜伦鲁鲁片免费无码影视| 日韩精品无码一区二区三区免费 | 国产中文在线亚洲精品官网| 中文字幕第一页亚洲|