/// <summary> /// Bind Pager CustomInfoHtml /// </summary> /// Copyright (c) /// 创 建 人：王好([email protected]) /// 创建日期：2012年2月1日 /// 修 改 人：王好 /// 修改日期： /// 版 本: /// <param name="aspNetPager"></param> public new void BindPagerCustomInfoHTML(Wuqi.Webdiyer.AspNetPager aspNetPager) { base.BindPagerCustomInfoHTML(aspNetPager); // aspNetPager.CustomInfoHTML += "记录总数：<font color=\"blue\"><b>" + aspNetPager.RecordCount.ToString() + "</b></font>"; // aspNetPager.CustomInfoHTML += " 总页数：<font color=\"blue\"><b>" + aspNetPager.PageCount.ToString() + "</b></font>"; // aspNetPager.CustomInfoHTML += " 当前页：<font color=\"red\"><b>" + aspNetPager.CurrentPageIndex.ToString() + "</b></font>"; }
public static void BindPager(Wuqi.Webdiyer.AspNetPager pager, int allCount)
{
pager.RecordCount = allCount;
pager.CustomInfoHTML = " 记录总数：<font color=\"blue\"><b>" + pager.RecordCount.ToString() + "</b></font>";
pager.CustomInfoHTML += " 总页数：<font color=\"blue\"><b>" + pager.PageCount.ToString() + "</b></font>";
pager.CustomInfoHTML += " 当前页：<font color=\"red\"><b>" + pager.CurrentPageIndex.ToString() + "</b></font>";
}
public static void pagerbind(Wuqi.Webdiyer.AspNetPager AspNetPager1, int allcount, int pagecount)
{
AspNetPager1.RecordCount = allcount;
AspNetPager1.CustomInfoHTML = "记录总数：<font color=\"blue\"><b>" + AspNetPager1.RecordCount.ToString() + "</b></font>";
AspNetPager1.CustomInfoHTML += " 总页数：<font color=\"blue\"><b>" + AspNetPager1.PageCount.ToString() + "</b></font>";
AspNetPager1.CustomInfoHTML += " 当前页：<font color=\"red\"><b>" + AspNetPager1.CurrentPageIndex.ToString() + "</b></font>";
}
//#region Repeater�ؼ���ҳ�ﶨ
///// <summary #region GridView�ؼ���ҳ�ﶨ
/// <summary>
/// GridView�ؼ���ҳ�ﶨ
/// </summary>
/// <param name="anpager">AspNetPager��ҳ�ؼ�</param>
/// <param name="strQuaryCondition">��ѯWhere����������Where</param>
/// <param name="strOrderCondition">��Ҫ������ֶ���</param>
/// <param name="rptControl">GridView�ؼ�</param>
public void GridViewPagerBindbyRowNumber(Wuqi.Webdiyer.AspNetPager anpager, string strWhere, string strOrderCondition, System.Web.UI.WebControls.GridView grvControl, int startyear, int endyear)
{
StringBuilder sbReceiveTable = new StringBuilder();
DataSet dstTemp = new DataSet();
#region ����ʱ���ȡҪ��ѯ�Ķ��ű�
for (int i = startyear; i <= endyear; i++)
{
sbReceiveTable.Append("'Sys_ReceiveMessage" + i + "',");
}
sbReceiveTable.Remove(sbReceiveTable.Length - 1, 1);
string strselectTable = "select name from sysobjects where type='u' and name in(" + sbReceiveTable + ")";
DataSet dsReceiveTable = DbHelperSQL.DQuery(strselectTable);
StringBuilder sbsql = new StringBuilder();
sbsql.Append("select RMID,PhoneNumber,MContent,ReceiveDate from (");
for (int i = 0; i < dsReceiveTable.Tables[0].Rows.Count; i++)
{
sbsql.Append("select * from " + dsReceiveTable.Tables[0].Rows[i][0].ToString() + " union");
}
sbsql.Remove(sbsql.Length - 6, 6);
sbsql.Append(") as RM");
#endregion
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from (select row_number() over (order by " + strOrderCondition + ") as rowno,* from (" + sbsql.ToString() + ") as VT_ReceiveMessage");
strSql.Append(strWhere);
strSql.Append(" ) as result Where (rowno Between " + ((anpager.CurrentPageIndex - 1) * anpager.PageSize + 1) + " and " + anpager.CurrentPageIndex * anpager.PageSize + ")");
StringBuilder strb = new StringBuilder();
strb.Append("Select Count(*) From (" + sbsql.ToString() + ") as VT_ReceiveMessage");
strb.Append(strWhere);
anpager.RecordCount = Convert.ToInt32(DbHelperSQL.GetSingle(strb.ToString()));
dstTemp = DbHelperSQL.Query(strSql.ToString());
if (dstTemp.Tables[0].Rows.Count == 0)
{
grvControl.DataSource = null;
grvControl.DataBind();
}
else
{
grvControl.DataSource = dstTemp.Tables[0];
grvControl.DataBind();
}
//��̬�����û��Զ����ı�����
anpager.CustomInfoHTML = "����<font color=\"blue\"><b>" + anpager.RecordCount.ToString() + "</b></font>����¼";
anpager.CustomInfoHTML += " ��ҳ����<font color=\"blue\"><b>" + anpager.PageCount.ToString() + "</b></font>ҳ";
anpager.CustomInfoHTML += " ��ǰҳ����<font color=\"red\"><b>" + anpager.CurrentPageIndex.ToString() + "</b></font>ҳ";
}
/// <summary>
/// 分页处理
/// </summary>
/// <param name="src"></param>
/// <param name="e"></param>
protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
{
AspNetPager1.CurrentPageIndex = e.NewPageIndex;
string FeedBackTypeId = "0";
if (hfFeedBackTypeId.Value != "")
FeedBackTypeId = hfFeedBackTypeId.Value;
bind(Convert.ToInt32(FeedBackTypeId), hfBeginTime.Value, hfEndTime.Value, false);
}
/// <summary>
/// 分页处理
/// </summary>
/// <param name="src"></param>
/// <param name="e"></param>
protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
{
AspNetPager1.CurrentPageIndex = e.NewPageIndex;
Core.Business.Group group = (Core.Business.Group)ViewState["Group"];
bind(group, HFCreatorId.Value, "", "", HFMaxMenberNum.Value, HFStartTime.Value, HFEndTime.Value, HFSort.Value, false);
}
/// <summary>
/// 分页控件事件
/// </summary>
/// <param name="src"></param>
/// <param name="e"></param>
protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
{
AspNetPager1.CurrentPageIndex = e.NewPageIndex;
//if (ViewState["sql"] != null && ViewState["sql"].ToString().Length != 0)
//{
// bll.Getsetdates(AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, ViewState["sql"].ToString(), GridView1);
//}
Bind();
}
/// <summary>
/// 分页处理
/// </summary>
/// <param name="src"></param>
/// <param name="e"></param>
protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
{
AspNetPager1.CurrentPageIndex = e.NewPageIndex;
CY.UME.Core.Business.Album album = new CY.UME.Core.Business.Album();
album.AccountName = HFAccountName.Value;
album.Name = HFAlbumName.Value;
Bind(album, HFSort.Value, false);
}
protected void PagerAddedIntegrals_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
{
PagerAddedIntegrals.CurrentPageIndex = e.NewPageIndex;
AddedIntegralsBind();
if (lastPageOfAddedIntegrals != e.NewPageIndex.ToString())
{
GoToAnchorAddedIntegrals();
}
lastPageOfAddedIntegrals = e.NewPageIndex.ToString();
}
/// <summary>
/// 分页处理
/// </summary>
/// <param name="src"></param>
/// <param name="e"></param>
protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
{
AspNetPager1.CurrentPageIndex = e.NewPageIndex;
// 防止没有查询条件的时候，但又点了查询按钮
if (hfColIdSearch.Value == "")//学院ID
hfColIdSearch.Value = "0";
bind(Convert.ToInt32(hfColIdSearch.Value), hfName.Value, hfDes.Value, false);
}
protected void PageBonusesThisMonth_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
{
PageBonusesThisMonth.CurrentPageIndex = e.NewPageIndex;
BonusesThisMonthBind();
if (lastPageOfBonusesThisMonth != e.NewPageIndex.ToString())
{
GoToAnchorBonusesThisMonth();
}
lastPageOfBonusesThisMonth = e.NewPageIndex.ToString();
}
//解析物品信息
void ParseItemJson()
{
itemList = new List <Item>();
//文本在Unity里面是TextAsset类型
TextAsset itemText = Resources.Load <TextAsset>("Items");
string itemsJson = itemText.text;//物品信息的Json格式
JSONObject j = new JSONObject(itemsJson);
foreach (JSONObject temp in j.list)
{
string typeStr = temp["type"].str;
Item.ItemType type = (Item.ItemType)System.Enum.Parse(typeof(Item.ItemType), typeStr);
//下面的是解析这个对象里面的公有属性
int id = (int)(temp["id"].n);
string name = temp["name"].str;
Item.ItemQuality quality = (Item.ItemQuality)System.Enum.Parse(typeof(Item.ItemQuality), temp["quality"].str);
string des = temp["des"].str;
int capacity = (int)(temp["capacity"].n);
int buyPrice = (int)(temp["buyPrice"].n);
int sellPrice = (int)(temp["sellPrice"].n);
string sprite = temp["sprite"].str;
Item item = null;
switch (type)
{
case Item.ItemType.Xiaohaopin:
int hp = (int)(temp["hp"].n);
int mp = (int)(temp["mp"].n);
item = new Xiaohaopin(id, name, type, quality, des, capacity, buyPrice, sellPrice, sprite, hp, mp);
break;
case Item.ItemType.Zhuangbei:
int strength = (int)temp["strength"].n;
int intellect = (int)temp["intellect"].n;
int agility = (int)temp["agility"].n;
int stamina = (int)temp["stamina"].n;
Zhuangbei.ZhuangbeiType zbType = (Zhuangbei.ZhuangbeiType)System.Enum.Parse(typeof(Zhuangbei.ZhuangbeiType), temp["zbType"].str);
item = new Zhuangbei(id, name, type, quality, des, capacity, buyPrice, sellPrice, sprite, strength, intellect, agility, stamina, zbType);
break;
case Item.ItemType.Wuqi:
int damage = (int)temp["damage"].n;
Wuqi.WuqiType wqType = (Wuqi.WuqiType)System.Enum.Parse(typeof(Wuqi.WuqiType), temp["wqType"].str);
item = new Wuqi(id, name, type, quality, des, capacity, buyPrice, sellPrice, sprite, damage, wqType);
break;
case Item.ItemType.Cailiao:
item = new Cailiao(id, name, type, quality, des, capacity, buyPrice, sellPrice, sprite);
break;
}
itemList.Add(item);
Debug.Log(item);
}
}
protected void Pager(GridView dl,Wuqi.Webdiyer.AspNetPager anp,System.Data.DataSet dst)
{
PagedDataSource pds = new PagedDataSource();
pds.DataSource = dst.Tables[0].DefaultView;
pds.AllowPaging = true;
anp.RecordCount = dst.Tables[0].DefaultView.Count;
pds.CurrentPageIndex = anp.CurrentPageIndex - 1;
pds.PageSize = anp.PageSize;
dl.DataSource = pds;
dl.DataBind();
}
protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
{
if (check)
{
binddata(e.NewPageIndex, pageSize);
}
else
{
bindlikedata(e.NewPageIndex, pageSize, cus);
}
}
protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
{
this.AspNetPager1.CurrentPageIndex = e.NewPageIndex;
if (flag == 0)
{
BindData();
}
else
{
BindDataByDate(Tbox_Start.Text, Tbox_End.Text);
}
}
/// <summary>
/// 分页处理
/// </summary>
/// <param name="src"></param>
/// <param name="e"></param>
protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
{
AspNetPager1.CurrentPageIndex = e.NewPageIndex;
string uniId = null;
if (hfuniId.Value == "" || hfuniId.Value == null)
uniId = "0";
else
uniId = hfuniId.Value;
bind(uniId, hfName.Value, false);
}
protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
{
this.AspNetPager1.CurrentPageIndex = e.NewPageIndex;
if (flag==0)
{
BindData();
}
else
{
BindDataByDate(Tbox_Start.Text, Tbox_End.Text, ddl_PrintCondition.SelectedValue.ToString());
}
}
protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
{
AspNetPager1.CurrentPageIndex = e.NewPageIndex;
if ( ordernum .Text == "")
{
LoadDataInfo();
}
else
{
LoadDataInfo1();
}
}
/// <summary>
/// 分页处理
/// </summary>
/// <param name="src"></param>
/// <param name="e"></param>
protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
{
AspNetPager1.CurrentPageIndex = e.NewPageIndex;
int ProID = 0;
if (hfProID.Value != "")
ProID = Convert.ToInt32(hfProID.Value);
hfProvinceId.Value = ucProvinceCity.ProvinceId.ToString();//分页前将省份ID保存下来。
bind(ProID, hfName.Value, false);
ucProvinceCity.ProvinceId = Convert.ToInt32(hfProvinceId.Value);//执行完分页后又重新将省份选中。
}
protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
{
this.AspNetPager1.CurrentPageIndex = e.NewPageIndex;
initCondition();
if (rdlSort.SelectedValue != "4")
{
BinddtgData(string.Empty);
}
else
{
BinddtgData("4");
}
}
/// <summary>
/// 分页处理
/// </summary>
/// <param name="src"></param>
/// <param name="e"></param>
protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
{
AspNetPager1.CurrentPageIndex = e.NewPageIndex;
CY.UME.Core.Business.AccountOperation ao = new CY.UME.Core.Business.AccountOperation();
ao.AccountName = HFAccountName.Value;
ao.Email = HFEmail.Value;
ao.Remark = HFRemark.Value;
ao.IsSuccess = CY.Utility.Common.ConvertUtility.ConvertToInt(HFIsSuccess.Value, -1);
Bind(ao, HFStartTime.Value, HFEndTime.Value, HFSort.Value, true);
}
/// <summary>
/// 分页处理
/// </summary>
/// <param name="src"></param>
/// <param name="e"></param>
protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
{
AspNetPager1.CurrentPageIndex = e.NewPageIndex;
string majorId = null;
string gradeId = null;
if (hfMajorId.Value == null || hfMajorId.Value == "")
majorId = "0";
else
majorId = hfMajorId.Value;
if (hfGradeId.Value == null || hfGradeId.Value == "")
gradeId = "0";
else
gradeId = hfGradeId.Value;
bind(majorId, gradeId, hfName.Value, false);
}
protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
{
this.AspNetPager1.CurrentPageIndex = e.NewPageIndex;
if (flag==0)
{
BindData();
}
else if (flag==1)
{
BindDataBySort(ddl_Sort.SelectedValue);
}
else if (flag==2)
{
BindDataByDate(Tbox_Start.Text, Tbox_End.Text);
}
else if (flag==3)
{
BindDataByName(Tbox_Name.Text.Trim());
}
}
/// <summary>
/// DataList控件分页帮定
/// </summary>
/// <param name="anpager">AspNetPager分页控件</param>
/// <param name="strTableName">表名</param>
/// <param name="strPrimaryKey">表的唯一主建名</param>
/// <param name="strQuaryCondition">查询Where条件，不含Where</param>
/// <param name="strOrderCondition">需要排序的字段名</param>
/// <param name="rptControl">DataList控件</param>
public static void DataListPagerBind(Wuqi.Webdiyer.AspNetPager anpager, string strTableName, string strPrimaryKey, string strQuaryCondition, string strOrderCondition, System.Web.UI.WebControls.DataList dlstControl)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@pageindex",SqlDbType.Int),
new SqlParameter("@pagesize",SqlDbType.Int),
new SqlParameter("@docount",SqlDbType.Bit),
new SqlParameter("@strwhere",SqlDbType.NVarChar,1000),
new SqlParameter("@tablenm",SqlDbType.NVarChar,100),
new SqlParameter("@tbmainid",SqlDbType.NVarChar,100),
new SqlParameter("@strorder",SqlDbType.NVarChar,100),
};
parameters[0].Value = anpager.CurrentPageIndex;
parameters[1].Value = anpager.PageSize;
parameters[2].Value = false;
parameters[3].Value = strQuaryCondition;
parameters[4].Value = strTableName;
parameters[5].Value = strPrimaryKey;
parameters[6].Value = strOrderCondition;
if (strQuaryCondition == "")
{
anpager.RecordCount = Convert.ToInt32(DbHelperSQLOld.GetSingle("Select Count(*) From " + strTableName));
}
else
{
anpager.RecordCount = Convert.ToInt32(DbHelperSQLOld.GetSingle("Select Count(*) From " + strTableName + " Where " + strQuaryCondition));
}
DataSet dstTemp = DbHelperSQLOld.RunProcedure("P_ControlPager", parameters, "NewTableName");
dlstControl.DataSource = dstTemp.Tables["NewTableName"];
dlstControl.DataBind();
//动态设置用户自定义文本内容
anpager.CustomInfoHTML = "共有<font color=\"blue\"><b>" + anpager.RecordCount.ToString() + "</b></font>条记录";
anpager.CustomInfoHTML += " 总页数：<font color=\"blue\"><b>" + anpager.PageCount.ToString() + "</b></font>页";
anpager.CustomInfoHTML += " 当前页：第<font color=\"red\"><b>" + anpager.CurrentPageIndex.ToString() + "</b></font>页";
}
protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
{
saveCurrentData();
}
protected void anpList_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
{
this.anpList.CurrentPageIndex = e.NewPageIndex;
DBind();
}
//#region Repeater控件分页帮定
///// <summary #region GridView控件分页帮定
/// <summary>
/// GridView控件分页帮定
/// </summary>
/// <param name="anpager">AspNetPager分页控件</param>
/// <param name="strRoomCode">磅房编号</param>
/// <param name="strCollCode" >煤矿编号</param>
/// <param name="strOnOff">网络状态</param>
/// <param name="strOrderCondition">需要排序的字段名</param>
/// <param name="rptControl">GridView控件</param>
public void GridViewPagerBindbyRowNumber(Wuqi.Webdiyer.AspNetPager anpager, string strRoomCode, string strCollCode, string strOnOff, string strOrderCondition, System.Web.UI.WebControls.GridView grvControl)
{
StringBuilder strSql = new StringBuilder();
DataSet dstTemp = new DataSet();
strSql.Append("select * from (select row_number() over (order by " + strOrderCondition + ") as rowno,room.*,case room.IsForbid when 0 then '否' else '是'end as Forbid ,case room.OnOff when 0 then '正常' else '断开' end as OnOffname,coll.CollName from ");
strSql.Append( " TT_Room as room left join sys_Colliery as coll on room.CollCode=coll.CollCode where room.RoomCode like @RoomCode ");
if(strCollCode != "-1")
{
strSql.Append(" and room.CollCode like '%"+strCollCode+"%' ");
}
if (strOnOff != "-1")
{
strSql.Append(" and room.OnOff like '%"+strOnOff+"%'");
}
strSql.Append(" ) as result Where (rowno Between " + (anpager.CurrentPageIndex - 1) * anpager.PageSize + " and " + anpager.CurrentPageIndex * anpager.PageSize + ")");
strRoomCode = "%" + strRoomCode + "%";
SqlParameter[] parameters = { new SqlParameter("@RoomCode", strRoomCode)};
parameters[0].Value = strRoomCode;
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("Select Count(*) From TT_ROOM as room left join sys_Colliery as coll on room.CollCode=coll.CollCode where room.RoomCode like @RoomCode ");
if (strCollCode != "-1")
{
strSql2.Append(" and room.CollCode like '%"+strCollCode+"%'");
}
if (strOnOff != "-1")
{
strSql2.Append(" and room.OnOff like '%" + strOnOff + "%'");
}
anpager.RecordCount = Convert.ToInt32(DbHelperSQL.GetSingle(strSql2.ToString(), parameters));
dstTemp = DbHelperSQL.Query(strSql.ToString(), parameters);
if (dstTemp.Tables[0].Rows.Count == 0)
{
grvControl.DataSource = null;
grvControl.DataBind();
}
else
{
grvControl.DataSource = dstTemp.Tables[0];
grvControl.DataBind();
}
//动态设置用户自定义文本内容
anpager.CustomInfoHTML = "共有<font color=\"blue\"><b>" + anpager.RecordCount.ToString() + "</b></font>条记录";
anpager.CustomInfoHTML += " 总页数：<font color=\"blue\"><b>" + anpager.PageCount.ToString() + "</b></font>页";
anpager.CustomInfoHTML += " 当前页：第<font color=\"red\"><b>" + anpager.CurrentPageIndex.ToString() + "</b></font>页";
}
protected void Pager_PageChanged(object src, Wuqi.Webdiyer.PageChangedEventArgs e)
{
Pager.CurrentPageIndex = e.NewPageIndex;
this.RefreshGrid();
}
protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
{
Session["010101AspNetPageCurPage"] = e.NewPageIndex;
}
protected void anp_WeightBangOld_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
{
this.anp_WeightBangOld.CurrentPageIndex = e.NewPageIndex;
GridBind();
}
protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
{
AspNetPager1.CurrentPageIndex = e.NewPageIndex;
info();
}