protected void BindList()
{
string userid = Utility.Common.GetStringOfUrl("userid");
if (userid.Length > 0 && Utility.Common.IsNumber(userid))
{
string where = " and UserID=" + userid + " ";
if (ddlNameID.SelectedValue != "-1")
{
where += " and GameNameID = " + ddlNameID.SelectedValue + " ";
}
if (!string.IsNullOrEmpty(txtBegin.Text))
{
where += " and EndTime >='" + txtBegin.Text.Trim() + " 00:00:00' ";// " 00:00:00' ";
}
if (!string.IsNullOrEmpty(txtEnd.Text))
{
where += " and EndTime <='" + txtEnd.Text.Trim() + " 23:59:59' ";// " 23:59:59' ";
}
//加上输赢金币不为0的约束 黄明森 2010-04-09
where += " and ChangeMoney<>0";
DataSet ds = DbSession.Default.FromProc("Web_pGetDataPager")
.AddInputParameter("@PageSize", DbType.Int32, anpPageIndex.PageSize)
.AddInputParameter("@CurrentPage", DbType.Int32, PageIndex)
.AddInputParameter("@Columns", DbType.String, "ID,RoomName,DeskIndex,GameTime,EndTime,Tax,UserID,ChangePoint,SrcMoney,ChangeMoney,ChangeTax,SrcPoint")
.AddInputParameter("@TableName", DbType.String, "Web_VChangeRecord")
.AddInputParameter("@Wheres", DbType.String, where)
.AddInputParameter("@KeyName", DbType.String, "ID")
.AddInputParameter("@OrderBy", DbType.String, "EndTime desc")
.ToDataSet();
if (ds.Tables.Count > 0 && ds.Tables[1].Rows.Count > 0)
{
anpPageIndex.RecordCount = (int)ds.Tables[0].Rows[0][0];
anpPageIndex.CurrentPageIndex = PageIndex;
GameSeachList.Visible = true;
GameSeachList.DataSource = ds.Tables[1];
GameSeachList.DataBind();
NoUserGame.Visible = false;
}
else
{
this.NoUserGame.Visible = true;
GameSeachList.Visible = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
AdminPopedom.IsHoldModel("09");
seachids = CommonManager.Web.Request("ids", ""); //Limit.editCharacter( Limit.getFormValue( "ids" ) ); //ID
usernames = CommonManager.Web.Request("users", ""); //Limit.editCharacter( Limit.getFormValue( "users" ) );//昵称
string sqltt = CommonManager.Web.Request("tt", ""); //Limit.editCharacter( Limit.getFormValue( "tt" ) ); //房间类型
if (sqltt == "")
{
sqltt = "0";
}
string sqlrr = CommonManager.Web.Request("rr", ""); //Limit.editCharacter( Limit.getFormValue( "rr" ) );//游戏类别
if (sqlrr == "")
{
sqlrr = "0";
}
string sqluu = CommonManager.Web.Request("uu", ""); //Limit.editCharacter( Limit.getFormValue( "uu" ) ); //用户注册名
string sqld1 = CommonManager.Web.Request("d1", ""); //Limit.editCharacter( Limit.getFormValue( "d1" ) ); //开始时间
if (sqld1 == "")
{
sqld1 = "0";
}
string sqld2 = CommonManager.Web.Request("d2", ""); //Limit.editCharacter( Limit.getFormValue( "d2" ) ); //结束时间
if (sqld2 == "")
{
sqld2 = "24";
}
if (sqltt != "0")
{
sqladd = sqladd + " and (RoomID in (select RoomID from TGameRoomInfo where GameTypeID=" + sqltt + "))";
}
//房间判断
if (sqlrr != "0")
{
sqladd = sqladd + " and RoomID='" + sqlrr + "'";
}
//判断时间
//if( !Limit.IsNumeric( sqld1 ) )
// Limit.outMsgBox( "温馨提示：\\n\\n 时间格式不正确！", true );
//if( !Limit.IsNumeric( sqld2 ) )
// Limit.outMsgBox( "温馨提示：\\n\\n 时间格式不正确！", true );
if (!CommonManager.String.IsInteger(sqld1) || !CommonManager.String.IsInteger(sqld2))
{
CommonManager.Web.RegJs(this, "alert('[结束时间]必须为数字！');history.back();", false);
return;
}
//比较时间
if (Convert.ToInt32(sqld1) > Convert.ToInt32(sqld2))
{
//Limit.outMsgBox( "温馨提示：\\n\\n 前面输入的数必须小于或等于后面输入的数！", true );
CommonManager.Web.RegJs(this, "alert('[结束时间]前面输入的数必须小于或等于后面输入的数！');history.back();", false);
return;
}
else
{
sqladd = sqladd + " and (datediff(hour,EndTime,getdate())>=" + sqld1 + " and datediff(hour,EndTime,getdate())<=" + sqld2 + ")";
}
//判断用户名
if (sqluu.ToString() != "")
{
DataTable sdtwo = new DataTable();
string two = "select UserID from TUsers where userName='******'";
sdtwo = DbSession.Default.FromSql(two).ToDataTable(); //sqlconn.sqlReader( two );
if (sdtwo.Rows.Count > 0)
{
UserID = sdtwo.Rows[0]["UserID"].ToString();
}
else
{
//Limit.outMsgBox( "温馨提示：\\n\\n没有此用户名！", true );
CommonManager.Web.RegJs(this, "alert('没有此用户名！');history.back();", false);
return;
}
sdtwo.Clear();
sqladd = sqladd + " and UserID=" + UserID;
}
//添加一个始终为真的条件来连接SQL
//Response.Write("查询条件"+sqladd);
// Response.End();
DataSet ds = DbSession.Default.FromProc("Web_pGetDataPager")
.AddInputParameter("@PageSize", DbType.Int32, anpPageIndex.PageSize)
.AddInputParameter("@CurrentPage", DbType.Int32, PageIndex)
.AddInputParameter("@Columns", DbType.String, "ID,RoomName,DeskIndex,GameTime,EndTime,Tax,UserID,ChangePoint,SrcMoney,ChangeMoney,ChangeTax,SrcPoint")
.AddInputParameter("@TableName", DbType.String, "Web_VChangeRecord")
.AddInputParameter("@Wheres", DbType.String, sqladd)
.AddInputParameter("@KeyName", DbType.String, "ID")
.AddInputParameter("@OrderBy", DbType.String, "EndTime desc")
.ToDataSet();
if (ds.Tables.Count > 0 && ds.Tables[1].Rows.Count > 0)
{
anpPageIndex.RecordCount = (int)ds.Tables[0].Rows[0][0];
anpPageIndex.CurrentPageIndex = PageIndex;
GameSeachList.Visible = true;
GameSeachList.DataSource = ds.Tables[1];
GameSeachList.DataBind();
NoUserGame.Visible = false;
}
else
{
this.NoUserGame.Visible = true;
GameSeachList.Visible = false;
}
}
