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");
}
}
