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!="請輸入關鍵字"?(" 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" ? ("生產型") : (idCoMode == "2" ? ("貿易型") : (idCoMode == "3" ? ("服務型") : (idCoMode == "4" ? ("政府或其他機構") : (""))))) + "%'") : ("");
                      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 閱讀(77) 評論(0)  編輯  收藏

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


          網站導航:
           

          常用鏈接

          留言簿(5)

          隨筆分類

          隨筆檔案

          搜索

          •  

          最新評論

          閱讀排行榜

          評論排行榜

          主站蜘蛛池模板: 达州市| 石棉县| 博湖县| 辽源市| 桦川县| 陕西省| 临桂县| 宝鸡市| 昌乐县| 晴隆县| 普兰县| 香港| 奉新县| 德庆县| 灵宝市| 和平县| 新龙县| 都匀市| 邓州市| 商城县| 四子王旗| 河北省| 浪卡子县| 河南省| 凌源市| 萨嘎县| 东至县| 札达县| 景德镇市| 贡觉县| 木兰县| 武穴市| 尼勒克县| 南通市| 恩平市| 赤城县| 林西县| 遂川县| 临沂市| 赤壁市| 高密市|