private void BindList(V_WEC_XX_MESSAGE condObj, int curPage) { valObj.Distinct = true; if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性,则用主键属性排序 { condObj.af_PageBy(V_WEC_XX_MESSAGE.Attribute.ID, Order.Desc); } /* * SELECT dbo.WEC_XX_MESSAGE.* * FROM dbo.WEC_XX_MESSAGE INNER JOIN * (SELECT *,OPENID AS id, MAX(ADDTIME) AS maxtime * FROM dbo.WEC_XX_MESSAGE AS WEC_XX_MESSAGE_1 * GROUP BY OPENID) AS aa ON dbo.WEC_XX_MESSAGE.ADDTIME = aa.maxtime AND dbo.WEC_XX_MESSAGE.OPENID = aa.id */ #region//数据权限条件 #endregion //condObj.PID = decimal.Parse(pid); if (!userBase2.Curraid.Equals("")) { condObj.AID = Convert.ToDecimal(userBase2.Curraid); } listObj = BLLTable <V_WEC_XX_MESSAGE> .SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount); repList.DataSource = listObj; repList.DataBind(); aspPager.RecordCount = recount; }
protected void aspPager_PageChanged(object sender, EventArgs e) { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson <V_WEC_XX_MESSAGE>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void aspPager_PageChanged(object sender, EventArgs e) { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson<V_WEC_XX_MESSAGE>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void btnSetPageSize_Click(object sender, EventArgs e) { aspPager.PageSize = int.Parse(txtPageSize.Value); if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson <V_WEC_XX_MESSAGE>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void btnFind_Click(object sender, EventArgs e) { condObj = new V_WEC_XX_MESSAGE(); if(txtID.Value !="" ) condObj.Like(V_WEC_XX_MESSAGE.Attribute.ID, Convert.ToDecimal(txtID.Value)); if(txtOPENID.Value !="" ) condObj.Like(V_WEC_XX_MESSAGE.Attribute.OPENID, Convert.ToString(txtOPENID.Value)); if(txtTYPE.Value !="" ) condObj.TYPE = Convert.ToInt32(txtTYPE.Value); if(txtS_CONTENT.Value !="" ) condObj.Like(V_WEC_XX_MESSAGE.Attribute.S_CONTENT, Convert.ToString(txtS_CONTENT.Value)); if(txtADDTIME.Value !="" ) condObj.Like(V_WEC_XX_MESSAGE.Attribute.ADDTIME, Convert.ToDateTime(txtADDTIME.Value)); if(txtISCOLLECT.Value !="" ) condObj.Like(V_WEC_XX_MESSAGE.Attribute.ISCOLLECT, Convert.ToString(txtISCOLLECT.Value)); if(txtLATITUDE.Value !="" ) condObj.Like(V_WEC_XX_MESSAGE.Attribute.LATITUDE, Convert.ToString(txtLATITUDE.Value)); if(txtLONGITUDE.Value !="" ) condObj.Like(V_WEC_XX_MESSAGE.Attribute.LONGITUDE, Convert.ToString(txtLONGITUDE.Value)); if(txtPRECISION.Value !="" ) condObj.Like(V_WEC_XX_MESSAGE.Attribute.PRECISION, Convert.ToString(txtPRECISION.Value)); if(txtCITY.Value !="" ) condObj.Like(V_WEC_XX_MESSAGE.Attribute.CITY, Convert.ToString(txtCITY.Value)); if(txtPROVINCE.Value !="" ) condObj.Like(V_WEC_XX_MESSAGE.Attribute.PROVINCE, Convert.ToString(txtPROVINCE.Value)); if(txtCOUNTRY.Value !="" ) condObj.Like(V_WEC_XX_MESSAGE.Attribute.COUNTRY, Convert.ToString(txtCOUNTRY.Value)); if(txtHEADIMGURL.Value !="" ) condObj.Like(V_WEC_XX_MESSAGE.Attribute.HEADIMGURL, Convert.ToString(txtHEADIMGURL.Value)); if(txtCHANNELID.Value !="" ) condObj.Like(V_WEC_XX_MESSAGE.Attribute.CHANNELID, Convert.ToDecimal(txtCHANNELID.Value)); if(txtAID.Value !="" ) condObj.Like(V_WEC_XX_MESSAGE.Attribute.AID, Convert.ToDecimal(txtAID.Value)); hidCondition.Value = condObj.ToJson(20); BindList(condObj, 1); }
protected void btnFind_Click(object sender, EventArgs e) { condObj = new V_WEC_XX_MESSAGE(); if (txtID.Value != "") { condObj.Like(V_WEC_XX_MESSAGE.Attribute.ID, Convert.ToDecimal(txtID.Value)); } if (txtOPENID.Value != "") { condObj.Like(V_WEC_XX_MESSAGE.Attribute.OPENID, Convert.ToString(txtOPENID.Value)); } if (txtTYPE.Value != "") { condObj.TYPE = Convert.ToInt32(txtTYPE.Value); } if (txtS_CONTENT.Value != "") { condObj.Like(V_WEC_XX_MESSAGE.Attribute.S_CONTENT, Convert.ToString(txtS_CONTENT.Value)); } if (txtADDTIME.Value != "") { condObj.Like(V_WEC_XX_MESSAGE.Attribute.ADDTIME, Convert.ToDateTime(txtADDTIME.Value)); } if (txtISCOLLECT.Value != "") { condObj.Like(V_WEC_XX_MESSAGE.Attribute.ISCOLLECT, Convert.ToString(txtISCOLLECT.Value)); } if (txtLATITUDE.Value != "") { condObj.Like(V_WEC_XX_MESSAGE.Attribute.LATITUDE, Convert.ToString(txtLATITUDE.Value)); } if (txtLONGITUDE.Value != "") { condObj.Like(V_WEC_XX_MESSAGE.Attribute.LONGITUDE, Convert.ToString(txtLONGITUDE.Value)); } if (txtPRECISION.Value != "") { condObj.Like(V_WEC_XX_MESSAGE.Attribute.PRECISION, Convert.ToString(txtPRECISION.Value)); } if (txtCITY.Value != "") { condObj.Like(V_WEC_XX_MESSAGE.Attribute.CITY, Convert.ToString(txtCITY.Value)); } if (txtPROVINCE.Value != "") { condObj.Like(V_WEC_XX_MESSAGE.Attribute.PROVINCE, Convert.ToString(txtPROVINCE.Value)); } if (txtCOUNTRY.Value != "") { condObj.Like(V_WEC_XX_MESSAGE.Attribute.COUNTRY, Convert.ToString(txtCOUNTRY.Value)); } if (txtHEADIMGURL.Value != "") { condObj.Like(V_WEC_XX_MESSAGE.Attribute.HEADIMGURL, Convert.ToString(txtHEADIMGURL.Value)); } if (txtCHANNELID.Value != "") { condObj.Like(V_WEC_XX_MESSAGE.Attribute.CHANNELID, Convert.ToDecimal(txtCHANNELID.Value)); } if (txtAID.Value != "") { condObj.Like(V_WEC_XX_MESSAGE.Attribute.AID, Convert.ToDecimal(txtAID.Value)); } hidCondition.Value = condObj.ToJson(20); BindList(condObj, 1); }
protected void btnSetPageSize_Click(object sender, EventArgs e) { aspPager.PageSize = int.Parse(txtPageSize.Value); if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson<V_WEC_XX_MESSAGE>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
private void BindList(V_WEC_XX_MESSAGE condObj, int curPage) { valObj.Distinct = true; if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ����������������� condObj.af_PageBy(V_WEC_XX_MESSAGE.Attribute.ID, Order.Desc); /* SELECT dbo.WEC_XX_MESSAGE.* FROM dbo.WEC_XX_MESSAGE INNER JOIN (SELECT *,OPENID AS id, MAX(ADDTIME) AS maxtime FROM dbo.WEC_XX_MESSAGE AS WEC_XX_MESSAGE_1 GROUP BY OPENID) AS aa ON dbo.WEC_XX_MESSAGE.ADDTIME = aa.maxtime AND dbo.WEC_XX_MESSAGE.OPENID = aa.id */ #region//����Ȩ������ #endregion //condObj.PID = decimal.Parse(pid); if (!userBase2.Curraid.Equals("")) { condObj.AID = Convert.ToDecimal(userBase2.Curraid); } listObj = BLLTable<V_WEC_XX_MESSAGE>.SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount); repList.DataSource = listObj; repList.DataBind(); aspPager.RecordCount = recount; }