private void RptBind(int _category_id, string _strWhere, string _orderby) { this.page = MXRequest.GetQueryInt("page", 1); if (this.category_id > 0) { this.ddlCategoryId.SelectedValue = _category_id.ToString(); } this.ddlProperty.SelectedValue = this.property; this.txtKeywords.Text = this.keywords; //图表或列表显示 BLL.article bll = new BLL.article(); DataSet artDs = bll.GetWCodeList(_category_id, this.pageSize, this.page, _strWhere, _orderby, out this.totalCount); //url链接地址处理 if (artDs != null && artDs.Tables.Count > 0 && artDs.Tables[0].Rows.Count > 0) { DataRow dr; int count = artDs.Tables[0].Rows.Count; for (int i = 0; i < count; i++) { dr = artDs.Tables[0].Rows[i]; string linkUrl = MyCommFun.ObjToStr(dr["link_url"]); if (linkUrl.Length > 0) { //外链地址 dr["link_url"] = "<span class=\"lianjie_wai\">[外]</span>" + " <a href=\"javascript:;\">" + linkUrl + "</a>"; } else { dr["link_url"] = "<span class=\"lianjie_ben\">[本]</span>" + " <a href=\"javascript:;\">" + MyCommFun.getWebSite() + "/detail.aspx?wid=" + MyCommFun.ObjToStr(dr["wid"]) + "&aid=" + dr["id"] + "</a>"; } } artDs.AcceptChanges(); } switch (this.prolistview) { case "Img": this.rptList1.Visible = false; this.rptList2.DataSource = artDs; this.rptList2.DataBind(); Utils.WriteCookie(pageLevelName + "_view", "Img", 14400); break; default: this.rptList2.Visible = false; this.rptList1.DataSource = artDs; this.rptList1.DataBind(); Utils.WriteCookie(pageLevelName + "_view", "Txt", 14400); break; } //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt(thisPage, "category_id={0}&keywords={1}&property={2}&page={3}&levelName={4}", _category_id.ToString(), this.keywords, this.property, "__id__", pageLevelName); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
protected void Page_Load(object sender, EventArgs e) { fid = MXRequest.GetQueryInt("fid"); if (!IsPostBack) { showInfo(); } }
protected void Page_Load(object sender, EventArgs e) { hotelid = MXRequest.GetQueryInt("hotelid", GetHotelId()); if (!IsPostBack) { RptBind(); } }
protected void Page_Load(object sender, EventArgs e) { wid = MXRequest.GetQueryInt("wid"); openid = MXRequest.GetQueryString("openid"); if (!IsPostBack) { showInfo(); } }
protected void Page_Load(object sender, EventArgs e) { PageSize = GetPageSize(10); ScenicId = MXRequest.GetQueryInt("scenicId"); if (!Page.IsPostBack) { RptBind(string.Format("id>0 And scenicId={0}", ScenicId), "Id Desc"); } }
protected void Page_Load(object sender, EventArgs e) { wid = MXRequest.GetQueryInt("wid"); fid = MXRequest.GetQueryInt("fid"); if (!IsPostBack) { BLL.wx_fc_aboutWe awBll = new BLL.wx_fc_aboutWe(); aw = awBll.GetModelList(" fid=" + fid + " and wid=" + wid)[0]; } }
protected void Page_Load(object sender, EventArgs e) { mzid = MXRequest.GetQueryInt("mzid"); this.pageSize = GetPageSize(10); //每页数量 if (!Page.IsPostBack) { ChkAdminLevel("magazine", MXEnums.ActionEnum.View.ToString()); //检查权限 RptBind("id>0 and mid=" + mzid, "sort_id asc,id desc"); } }
protected void Page_Load(object sender, EventArgs e) { wid = MXRequest.GetQueryInt("wid"); fid = MXRequest.GetQueryInt("fid"); openid = MyCommFun.RequestOpenid(); if (!IsPostBack) { showInfo(); } }
protected void Page_Load(object sender, EventArgs e) { this.keywords = MXRequest.GetQueryString("keywords"); type = MXRequest.GetQueryInt("type"); this.pageSize = GetPageSize(10); //每页数量 if (!Page.IsPostBack) { RptBind(CombSqlTxt(keywords), "sort_id asc,id asc"); } }
protected void Page_Load(object sender, EventArgs e) { wid = MXRequest.GetQueryInt("wid"); openid = MXRequest.GetQueryString("openid"); if (!IsPostBack) { BLL.wx_wq_czgh ghBll = new BLL.wx_wq_czgh(); ghModel = ghBll.GetModelList("wid=" + wid)[0]; } }
/// <summary> /// 获取数据 /// </summary> /// <returns></returns> private IList <OrderDetailDTO> GetData() { int shopid = MXRequest.GetQueryInt("hotelid") == 0 ? this.GetHotelId() : MXRequest.GetQueryInt("hotelid"); string condition = ""; var moduleName = "hotel"; if (!String.IsNullOrEmpty(startDate.Text.Trim())) { condition += " modifytime>='" + startDate.Text.Trim() + "' "; } if (!String.IsNullOrEmpty(endDate.Text.Trim())) { if (!String.IsNullOrEmpty(condition)) { condition += " and "; } condition += " modifytime<='" + endDate.Text.Trim() + "' "; } if (!String.IsNullOrEmpty(dingdanId.Text.Trim())) { if (!String.IsNullOrEmpty(condition)) { condition += " and "; } condition += " orderNumber LIKE '%" + dingdanId.Text.Trim() + "%' "; } if (!String.IsNullOrEmpty(paidmin.Text.Trim())) { if (!String.IsNullOrEmpty(condition)) { condition += " and "; } condition += " payAmount>" + paidmin.Text.Trim() + " "; } if (!String.IsNullOrEmpty(paidmax.Text.Trim())) { if (!String.IsNullOrEmpty(condition)) { condition += " and "; } condition += " payAmount<" + paidmax.Text.Trim() + " "; } if (!String.IsNullOrEmpty(orderperson.Text.Trim())) { if (!String.IsNullOrEmpty(condition)) { condition += " and "; } condition += " customerName LIKE '%" + orderperson.Text.Trim() + "%' "; } var detail = IdentifyingCodeService.GetOrderDetail(shopid, moduleName, condition); return(detail); }
private IList <OrderDetailDTO> SearchData() { int shopid = MXRequest.GetQueryInt("shopid") == 0 ? GetShopId() : MXRequest.GetQueryInt("shopid"); string condition = ""; var moduleName = "restaurant"; if (!String.IsNullOrEmpty(startDate.Text.Trim())) { condition += " FinishTime>='" + startDate.Text.Trim() + "' "; } if (!String.IsNullOrEmpty(endDate.Text.Trim())) { if (!String.IsNullOrEmpty(condition)) { condition += " and "; } condition += " FinishTime<='" + endDate.Text.Trim() + "' "; } if (!String.IsNullOrEmpty(dingdanId.Text.Trim())) { if (!String.IsNullOrEmpty(condition)) { condition += " and "; } condition += " orderNumber LIKE '%" + dingdanId.Text.Trim() + "%' "; } if (!String.IsNullOrEmpty(paidmin.Text.Trim())) { if (!String.IsNullOrEmpty(condition)) { condition += " and "; } condition += " payAmount>" + paidmin.Text.Trim() + " "; } if (!String.IsNullOrEmpty(paidmax.Text.Trim())) { if (!String.IsNullOrEmpty(condition)) { condition += " and "; } condition += " payAmount<" + paidmax.Text.Trim() + " "; } if (!String.IsNullOrEmpty(orderperson.Text.Trim())) { if (!String.IsNullOrEmpty(condition)) { condition += " and "; } condition += " customerName LIKE '%" + orderperson.Text.Trim() + "%' "; } var result = IdentifyingCodeService.GetOrderDetail(shopid, moduleName, condition); return(result); }
protected void Page_Load(object sender, EventArgs e) { this.keywords = MXRequest.GetQueryString("keywords"); this.typeId = MXRequest.GetQueryInt("typeId"); this.pageSize = GetPageSize(10); //每页数量 if (!Page.IsPostBack) { TypeBind(); RptBind(typeId, CombSqlTxt(keywords), "seq asc,id desc"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { id = MXRequest.GetQueryInt("id"); wid = MXRequest.GetQueryInt("wid"); BLL.wx_my_tijian tjBll = new BLL.wx_my_tijian(); this.rptList.DataSource = tjBll.GetList(" userid=" + id + " and wid=" + wid + " order by tijiandate desc"); this.rptList.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BLL.wx_mz_img bll = new BLL.wx_mz_img(); mid = MXRequest.GetQueryInt("mid"); showInfo(); this.rptList.DataSource = bll.GetModelList(" mid=" + mid); this.rptList.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { ScenicId = MXRequest.GetQueryInt("scenicId"); DetailId = MyCommFun.RequestInt("detailId"); this.PageSize = GetPageSize(10); //每页数量 if (!Page.IsPostBack) { RptBind(string.Empty, "OrderNo asc,CreateDate desc"); } }
protected void Page_Load(object sender, EventArgs e) { this.keywords = MXRequest.GetQueryString("keywords"); this.pageSize = GetPageSize(10); //每页数量 if (!Page.IsPostBack) { id = MXRequest.GetQueryInt("id"); RptBind(" attrid=" + id + "", "min_attrid desc"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { wid = MXRequest.GetQueryInt("wid"); openid = MXRequest.GetQueryString("openid"); BLL.wx_wq_panorama pBll = new BLL.wx_wq_panorama(); this.rptView.DataSource = pBll.GetList("wid=" + wid); this.rptView.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { wid = MXRequest.GetQueryInt("wid"); openid = MyCommFun.RequestOpenid(); if (!IsPostBack) { BLL.wx_wsite_setting ws = new BLL.wx_wsite_setting(); wsModel = ws.GetModelByWid(wid); } }
protected void Page_Load(object sender, EventArgs e) { wid = MXRequest.GetQueryInt("wid"); openid = MXRequest.GetQueryString("openid"); if (!IsPostBack) { BLL.wx_wq_pinpai ppBll = new BLL.wx_wq_pinpai(); this.rptList.DataSource = ppBll.GetList(" wid=" + wid + " order by sort_id asc,id asc"); this.rptList.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { ChkAdminLevel("moyingtijian", MXEnums.ActionEnum.View.ToString()); //检查权限 this.keywords = MXRequest.GetQueryString("keywords"); uid = MXRequest.GetQueryInt("uid"); this.pageSize = GetPageSize(10); //每页数量 if (!Page.IsPostBack) { RptBind(CombSqlTxt(keywords), "id desc"); } }
private void RptBind(string _strWhere, string _orderby) { Model.wx_userweixin weixin = GetWeiXinCode(); //判断是否已经设置了微留言基本信息 BLL.wx_sjb_bisai sbll = new BLL.wx_sjb_bisai(); BLL.wx_sjb_qiudui qdBll = new BLL.wx_sjb_qiudui(); string qdName = ""; _strWhere = "rcId=" + richengid + " " + _strWhere; this.page = MXRequest.GetQueryInt("page", 1); txtKeywords.Text = this.keywords; DataSet ds = gbll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount); // DataSet ds = gbll.GetList( _strWhere); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { DataRow dr; DateTime begin = new DateTime(); DateTime end = new DateTime(); int count = ds.Tables[0].Rows.Count; for (int i = 0; i < count; i++) { dr = ds.Tables[0].Rows[i]; dr["qd1Name"] = qdBll.GetQuiDuiName(MyCommFun.Obj2Int(dr["qd1Id"])); dr["qd2Name"] = qdBll.GetQuiDuiName(MyCommFun.Obj2Int(dr["qd2Id"])); begin = MyCommFun.Obj2DateTime(dr["beginDate"]); end = MyCommFun.Obj2DateTime(dr["endDate"]); if (begin > DateTime.Now) { dr["status_s"] = "<span class=\"act_before\">未开始</span>"; } else if (end <= DateTime.Now) { dr["status_s"] = "<span class=\"act_end\">已结束</span>"; } else { dr["status_s"] = "<span class=\"act_in\">进行中</span>"; } } ds.AcceptChanges(); } this.rptList.DataSource = ds; this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("bisai_list.aspx", "keywords={0}&page={1}", this.keywords, "__id__"); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
protected void Page_Load(object sender, EventArgs e) { wid = MXRequest.GetQueryInt("wid"); openid = MXRequest.GetQueryString("openid"); if (!IsPostBack) { BLL.wx_wq_sygj gjBll = new BLL.wx_wq_sygj(); this.rptList.DataSource = gjBll.GetList("wid=" + wid + " and gjstatus=1"); this.rptList.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { action = MXRequest.GetQueryString("action"); id = MXRequest.GetQueryInt("id"); if (!IsPostBack) { if (action == MXEnums.ActionEnum.Edit.ToString() && id > 0)//修改 { showInfo(id); } } }
protected void Page_Load(object sender, EventArgs e) { id = MXRequest.GetQueryInt("id"); this.pageSize = GetPageSize(10); //每页数量 if (!Page.IsPostBack) { ChkAdminLevel(LevelName, MXEnums.ActionEnum.View.ToString()); //检查权限 TreeBind(); //绑定类别 SearchBind(); RptBind(); } }
protected void Page_Load(object sender, EventArgs e) { wid = MXRequest.GetQueryInt("wid"); openid = MyCommFun.RequestOpenid(); if (!IsPostBack) { BLL.wx_wq_xiaoshou xsBll = new BLL.wx_wq_xiaoshou(); this.rptList.DataSource = xsBll.GetList(" wid=" + wid + " order by sort_id asc,id asc"); this.rptList.DataBind(); } }
/// <summary> /// 前台数据绑定 /// </summary> /// <param name="strWhere">查询的内容</param> private void RptBind(string strWhere) { if (strWhere == null) { strWhere = ""; } this.page = MXRequest.GetQueryInt("page", 1); //获取第一页内容 txtKeywords.Text = this.keywords; //保留查询条件值 DataTable dt_Miss = bll_Miss.GetList("").Tables[0]; DataTable dt_Student = bll_Student.GetList("").Tables[0]; DataTable dt_Teacher = bll_Teacher.GetList("").Tables[0]; DataTable dt_Diagnosis = bll_Diagnosis.GetList("").Tables[0]; DataTable dt_Epidemic = bll_Epidemic.GetList("").Tables[0]; DataTable dt_Symptom = bll_Symptom.GetList("").Tables[0]; //用Linq语句实现对缺课表的模糊查询 var result = from m in dt_Miss.AsEnumerable() join st in dt_Student.AsEnumerable() on m.Field <string>("Student_Sno") equals st.Field <string>("Student_Sno") join sy in dt_Symptom.AsEnumerable() on m.Field <string>("Symptom_Number") equals sy.Field <string>("Symptom_Number") join d in dt_Diagnosis.AsEnumerable() on m.Field <string>("Diagnosis_Number") equals d.Field <string>("Diagnosis_Number") join e in dt_Epidemic.AsEnumerable() on m.Field <string>("Epidemic_Number") equals e.Field <string>("Epidemic_Number") join t in dt_Teacher.AsEnumerable() on m.Field <string>("Teacher_Tno") equals t.Field <string>("Teacher_Tno") where st.Field <string>("Student_Name").Contains(strWhere) || t.Field <string>("Teacher_Name").Contains(strWhere) select new { Miss_ID = m.Field <string>("Miss_ID"), Student_Name = st.Field <string>("Student_Name"), Miss_Fever = m.Field <string>("Miss_Fever"), Symptom_Name = sy.Field <string>("Symptom_Name"), Diagnosis_Name = d.Field <string>("Diagnosis_Name"), Miss_MState = m.Field <string>("Miss_MState"), Miss_MHospital = m.Field <string>("Miss_MHospital"), Miss_Days = m.Field <dynamic>("Miss_Days"), Miss_ClassHour = m.Field <dynamic>("Miss_ClassHour"), Miss_Type = m.Field <string>("Miss_Type"), Epidemic_Name = e.Field <string>("Epidemic_Name"), Teacher_Name = t.Field <string>("Teacher_Name"), Miss_RDateTime = m.Field <DateTime>("Miss_RDateTime") }; this.totalCount = result.AsQueryable().Count();//符合条件的用户总数 //分页获取数据 this.rptList.DataSource = result.AsQueryable().Skip((page - 1) * pageSize).Take(pageSize).ToList(); this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("AbsencesStatistics.aspx", "keywords={0}&page={1}", this.keywords, "__id__"); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
protected void Page_Load(object sender, EventArgs e) { this.type_id = MXRequest.GetQueryInt("type_id"); this.keywords = MXRequest.GetQueryString("keywords"); this.pageSize = GetPageSize(10); //每页数量 if (!Page.IsPostBack) { ChkAdminLevel("user_message", MXEnums.ActionEnum.View.ToString()); //检查权限 RptBind("id>0" + CombSqlTxt(this.type_id, this.keywords), "post_time desc,id desc"); } }
protected void Page_Load(object sender, EventArgs e) { _action = MXRequest.GetQueryString("action"); _id = MXRequest.GetQueryInt("Id"); if (!IsPostBack) { if (_action == MXEnums.ActionEnum.Edit.ToString() && _id > 0) { ShowInfo(_id); } } }
protected void Page_Load(object sender, EventArgs e) { this.keywords = MXRequest.GetQueryString("keywords"); this.category_id = MXRequest.GetQueryInt("category_id"); this.pageSize = GetPageSize(10); //每页数量 if (!Page.IsPostBack) { TreeBind(); RptBind(this.category_id, CombSqlTxt(keywords), "sort_id asc,id desc"); } }