/// <summary>
/// 数据绑定
/// </summary>
private void AccountsDataBind()
{
PagerSet pagerSet = FacadeManage.aideAccountsFacade.GetList(AccountsInfo.Tablename, anpPage.CurrentPageIndex, anpPage.PageSize, SearchItems, Orderby);
anpPage.RecordCount = pagerSet.RecordCount;
litNoData.Visible = pagerSet.PageSet.Tables[0].Rows.Count > 0 ? false : true;
rptDataList.DataSource = pagerSet.PageSet;
rptDataList.DataBind();
}
/// <summary>
/// 数据绑定
/// </summary>
private void BindData()
{
PagerSet pagerSet = FacadeManage.aideTreasureFacade.GetList(CurrencyExchConfig.Tablename, SearchItems, Orderby, anpNews.CurrentPageIndex, anpNews.PageSize);
anpNews.RecordCount = pagerSet.RecordCount;
litNoData.Visible = pagerSet.PageSet.Tables[0].Rows.Count > 0 ? false : true;
rptDataList.DataSource = pagerSet.PageSet;
rptDataList.DataBind();
}
/// <summary>
/// 绑定数据库地址
/// </summary>
private void BindDataBaseAddr()
{
PagerSet pagerSet = FacadeManage.aidePlatformFacade.GetList(DataBaseInfo.Tablename, "", "ORDER BY DBInfoID ASC", 1, 100);
ddlDataBaseAddr.DataSource = pagerSet.PageSet;
ddlDataBaseAddr.DataTextField = "Information";
ddlDataBaseAddr.DataValueField = "DBAddr";
ddlDataBaseAddr.DataBind();
}
/// <summary>
/// 数据绑定
/// </summary>
private void BindData()
{
PagerSet pagerSet = FacadeManage.aideTreasureFacade.GetList(SpreadConfig.Tablename, anpNews.CurrentPageIndex, anpNews.PageSize, "", " ORDER BY SpreadNum ASC");
anpNews.RecordCount = pagerSet.RecordCount;
litNoData.Visible = pagerSet.PageSet.Tables[0].Rows.Count > 0 ? false : true;
rptDataList.DataSource = pagerSet.PageSet;
rptDataList.DataBind();
}
private void BindData()
{
PagerSet pagerSet = FacadeManage.aideTreasureFacade.GetList(OnlinePayConfig.Tablename, "WHERE 1=1", "ORDER BY ID DESC", anpNews.CurrentPageIndex, anpNews.PageSize);
anpNews.RecordCount = pagerSet.RecordCount;
litNoData.Visible = pagerSet.PageSet.Tables[0].Rows.Count <= 0;
rptDataList.DataSource = pagerSet.PageSet;
rptDataList.DataBind();
}
/// <summary>
/// 数据绑定
/// </summary>
private void RPDataBind()
{
PagerSet pagerSet = FacadeManage.aideNativeWebFacade.GetList(GameRule.Tablename, anpNews.CurrentPageIndex, anpNews.PageSize, SearchItems, Orderby);
anpNews.RecordCount = pagerSet.RecordCount;
litNoData.Visible = pagerSet.PageSet.Tables[0].Rows.Count > 0 ? false : true;
rptIssue.DataSource = pagerSet.PageSet;
rptIssue.DataBind();
}
/// <summary>
/// 下拉列表数据
/// </summary>
private void DataBindKindList()
{
PagerSet ps = FacadeManage.aidePlatformFacade.GetList(GameGameItem.Tablename, "", "ORDER BY GameID DESC", 1, 1000);
ddlKind.DataSource = ps.PageSet;
ddlKind.DataTextField = "GameName";
ddlKind.DataValueField = "GameID";
ddlKind.DataBind();
}
/// <summary>
/// 数据绑定
/// </summary>
private void BindData()
{
PagerSet pagerSet = FacadeManage.aidePlatformFacade.GetList(GameProperty.Tablename, anpNews.CurrentPageIndex, anpNews.PageSize, "", " ORDER BY Kind ASC,SortID ASC");
anpNews.RecordCount = pagerSet.RecordCount;
litNoData.Visible = pagerSet.PageSet.Tables[0].Rows.Count <= 0;
rptDataList.DataSource = pagerSet.PageSet;
rptDataList.DataBind();
}
private void BindTask()
{
//控件绑定
PagerSet pagerSet = FacadeManage.aidePlatformFacade.GetList(Game.Entity.Platform.TaskInfo.Tablename, anpPage.CurrentPageIndex, anpPage.PageSize, "", "ORDER BY TaskID ASC");
litNoData.Visible = pagerSet.PageSet.Tables[0].Rows.Count > 0 ? false : true;
rpData.DataSource = pagerSet.PageSet;
rpData.DataBind();
anpPage.RecordCount = pagerSet.RecordCount;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
NativeWebFacade aideNativeWebFacade = new NativeWebFacade();
PagerSet pagerSet = aideNativeWebFacade.GetList(ConfigInfo.Tablename, 1, 10000, "", " ORDER BY ConfigID ASC");
rptDataList.DataSource = pagerSet.PageSet;
rptDataList.DataBind();
}
}
/// <summary>
/// 绑定数据
/// </summary>
private void DataMallInfo()
{
//控件绑定
PagerSet pagerSet = FacadeManage.aideNativeWebFacade.GetList(AwardInfo.Tablename, GetWhere(), "ORDER BY SortID DESC", anpPage.CurrentPageIndex, anpPage.PageSize);
litNoData.Visible = pagerSet.PageSet.Tables[0].Rows.Count > 0 ? false : true;
rpData.DataSource = pagerSet.PageSet;
rpData.DataBind();
anpPage.RecordCount = pagerSet.RecordCount;
}
/// <summary>
/// 绑定游戏列表
/// </summary>
protected void BindGame()
{
PagerSet ps = FacadeManage.aidePlatformFacade.GetList(GameGameItem.Tablename, "", "ORDER BY GameID DESC", 1, 1000);
ddlGame.DataSource = ps.PageSet;
ddlGame.DataTextField = "GameName";
ddlGame.DataValueField = "GameID";
ddlGame.DataBind();
ddlGame.Items.Insert(0, new ListItem("选择游戏", "0"));
}
private void BindGameProperty()
{
//使用范围
PagerSet pagerSet = FacadeManage.aidePlatformFacade.GetGamePropertyList(1, int.MaxValue, string.Format("WHERE Kind<>{0}", (int)GamePropertyKind.KIND11), "ORDER BY ID ASC");
ddlGameProperty.DataSource = pagerSet.PageSet;
ddlGameProperty.DataValueField = "ID";
ddlGameProperty.DataTextField = "Name";
ddlGameProperty.DataBind();
}
private void BindActivity()
{
//控件绑定
PagerSet pagerSet = FacadeManage.aideNativeWebFacade.GetList(Activity.Tablename, PageIndex, anpPage.PageSize, "", "ORDER BY ActivityID ASC");
litNoData.Visible = pagerSet.PageSet.Tables[0].Rows.Count > 0 ? false : true;
rpData.DataSource = pagerSet.PageSet;
rpData.DataBind();
anpPage.RecordCount = pagerSet.RecordCount;
}
/// <summary>
/// 数据绑定
/// </summary>
private void BindData()
{
PagerSet pagerSet = FacadeManage.aideRecordFacade.GetList(RecordSpreadReturnReceive.Tablename,
anpNews.CurrentPageIndex, anpNews.PageSize, SearchItems, Orderby);
anpNews.RecordCount = pagerSet.RecordCount;
litNoData.Visible = pagerSet.PageSet.Tables[0].Rows.Count <= 0;
rptDataList.DataSource = pagerSet.PageSet;
rptDataList.DataBind();
}
/// <summary>
/// 数据绑定
/// </summary>
private void BindData()
{
PagerSet pagerSet = FacadeManage.aideRecordFacade.GetList(RecordGameDiamond.Tablename, anpNews.CurrentPageIndex, anpNews.PageSize, SearchItems, Orderby);
anpNews.RecordCount = pagerSet.RecordCount;
litNoData.Visible = pagerSet.PageSet.Tables[0].Rows.Count > 0 ? false : true;
rptDataList.DataSource = pagerSet.PageSet;
rptDataList.DataBind();
lbDiamond.Text = FacadeManage.aideRecordFacade.GetTotalAaGameDiamond(SearchItems).ToString();
}
/// <summary>
/// 数据绑定
/// </summary>
private void GameKindItemDataBind()
{
PagerSet pagerSet = FacadeManage.aidePlatformFacade.GetList(MobileKindItem.Tablename,
anpNews.CurrentPageIndex, anpNews.PageSize, SearchItems, Orderby);
anpNews.RecordCount = pagerSet.RecordCount;
litNoData.Visible = pagerSet.PageSet.Tables[0].Rows.Count <= 0;
rptMobileKindItem.DataSource = pagerSet.PageSet;
rptMobileKindItem.DataBind();
}
private void BindIssueData()
{
PagerSet pagerSet = FacadeManage.aideNativeWebFacade.GetIssueList(1, 20);
if (pagerSet.PageSet.Tables[0].Rows.Count > 0)
{
this.rptIssueList.DataSource = pagerSet.PageSet;
this.rptIssueList.DataBind();
}
}
/// <summary>
/// 数据绑定
/// </summary>
private void DataBaseDataBind()
{
PagerSet pagerSet = FacadeManage.aidePlatformFacade.GetList(DataBaseInfo.Tablename,
SearchItems, Orderby, anpNews.CurrentPageIndex, anpNews.PageSize);
anpNews.RecordCount = pagerSet.RecordCount;
litNoData.Visible = pagerSet.PageSet.Tables[0].Rows.Count > 0 ? false : true;
rptDataBase.DataSource = pagerSet.PageSet;
rptDataBase.DataBind();
}
//商品列表
public string GoodsList(HttpRequest req)
{
try
{
var GoodID = req["GoodID"];
Dictionary <string, object> conditions2 = new Dictionary <string, object>();
DataTable dt = null;
string json = "";
if (!string.IsNullOrEmpty(GoodID))
{
conditions2.Add("GoodID", GoodID);//商品名称
DataSet ds = aidePlatformManagerFacade.GoodsListByID(conditions2);
DataSet dsimg = aidePlatformManagerFacade.GoodsImagesByID(conditions2);
dt = ds.Tables[0];
DataTable dtimg = dsimg.Tables[0];
string json1 = GetJsonByDataTable(dtimg);
dt.Columns.Add("images", typeof(string));
dt.Rows[0]["images"] = json1;
}
else
{
var CategoryID = req["CategoryID"];
var GoodName = req["GoodName"];
conditions2.Add("CategoryID", CategoryID); //商品分类 0 全部
conditions2.Add("GoodName", GoodName); //商品名称
PagerSet pagerSet2 = aidePlatformManagerFacade.GoodsList(1, 1000, conditions2, "ORDER BY ID DESC");
dt = pagerSet2.PageSet.Tables[1];
DataTable dtimg = pagerSet2.PageSet.Tables[2];
dt.Columns.Add("images", typeof(string));
foreach (DataRow dr in dt.Rows)
{
DataTable dtimg2 = dtimg.Clone();
var drsimg = dtimg.Select("GoodID=" + dr["ID"].ToString());
foreach (DataRow dr2 in drsimg)
{
DataRow newRow2 = dtimg2.NewRow();
foreach (DataColumn dc2 in dtimg2.Columns)
{
newRow2[dc2.ColumnName] = dr2[dc2.ColumnName];
}
dtimg2.Rows.Add(newRow2);
}
string json1 = GetJsonByDataTable(dtimg2);
dr["images"] = json1;
}
}
json = GetJsonByDataTable(dt);
json = json.Replace("\"[", "[").Replace("]\"", "]");
return(JsonResultHelper.GetSuccessJsonByArray(json));
}
catch (Exception ex)
{
return(JsonResultHelper.GetErrorJson(ex.Message));;
}
}
/// <summary>
/// 数据绑定
/// </summary>
private void ShareInfoDataBind()
{
PagerSet pagerSet = FacadeManage.aideTreasureFacade.GetList(OnLinePayOrder.Tablename,
anpNews.CurrentPageIndex, anpNews.PageSize, SearchItems, Orderby);
anpNews.RecordCount = pagerSet.RecordCount;
litNoData.Visible = pagerSet.PageSet.Tables[0].Rows.Count <= 0;
ltTotal.Text = $"已支付金额：{FacadeManage.aideTreasureFacade.GetTotalPayAmount(SearchItems)}元 已支付订单数：{FacadeManage.aideTreasureFacade.GetTotalPayOrderCount(SearchItems)} (当前条件统计)";
rptShareInfo.DataSource = pagerSet.PageSet;
rptShareInfo.DataBind();
}
/// <summary>
/// 数据绑定
/// </summary>
private void UserInoutDataBind()
{
PagerSet pagerSet = FacadeManage.aideTreasureFacade.GetList(RecordUserInout.Tablename,
anpNews.CurrentPageIndex, anpNews.PageSize, SearchItems, Orderby);
anpNews.RecordCount = pagerSet.RecordCount;
litNoData.Visible = pagerSet.PageSet.Tables[0].Rows.Count > 0 ? false : true;
litTip.Visible = false;
rptUserInout.DataSource = pagerSet.PageSet;
rptUserInout.DataBind();
}
private void OrderDataBind()
{
PagerSet pagerSet = FacadeManage.aideTreasureFacade.GetList(DrawalOrder.Tablename,
SearchItems, Orderby, anpNews.CurrentPageIndex, anpNews.PageSize);
anpNews.RecordCount = pagerSet.RecordCount;
litNoData.Visible = pagerSet.PageSet.Tables[0].Rows.Count <= 0;
ltTotal.Text = $"已出款金额：{FacadeManage.ConversionMoneyToShow(FacadeManage.aideTreasureFacade.GetTotleDrawalMoney(SearchItems).ToString())}元 ";
rptShareInfo.DataSource = pagerSet.PageSet;
rptShareInfo.DataBind();
}
/// <summary>
/// 页面加载
/// </summary>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
PagerSet pagerSet = FacadeManage.aideRecordFacade.GetList(Entity.Record.RecordGrantGameID.Tablename,
1, 100, string.Format("WHERE UserID={0}", IntParam), "ORDER BY RecordID DESC");
litNoData.Visible = pagerSet.PageSet.Tables[0].Rows.Count > 0 ? false : true;
rptDataList.DataSource = pagerSet.PageSet;
rptDataList.DataBind();
}
}
public override string Index(HttpRequest req)
{
int pageIndex = Convert.ToInt32(req["pageIndex"] ?? "1");
int pageSize = Convert.ToInt32(req["pageSize"] ?? "20");
PagerSet pageSet = aidePlatformManagerFacade.GetUserList(pageIndex, pageSize, GetCondition(req), "ORDER BY UserID DESC");
DataTable dtUsers = pageSet.PageSet.Tables[0];
string json = GetResponse(GetModuleName((int)ModuleType.AgentInfo), "vw_Log", dtUsers, pageSize, pageSet.RecordCount);
return(json);
}
public override string Index(HttpRequest req)
{
int pageIndex = Convert.ToInt32(req["pageIndex"] ?? "1");
int pageSize = Convert.ToInt32(req["pageSize"] ?? "20");
PagerSet pageSet = aidePlatformManagerFacade.GetRoleList(pageIndex, pageSize, GetCondition(req), " ORDER BY RoleID ASC");
DataTable dtRoles = pageSet.PageSet.Tables[0];
string json = GetResponse(GetModuleName((int)ModuleType.Roles), View, dtRoles, pageSize, pageSet.RecordCount);
return(json);
}
/// <summary>
/// 数据绑定
/// </summary>
private void BindData()
{
PagerSet pagerSet = FacadeManage.aideRecordFacade.GetList(RecordTreasureSerial.Tablename, anpNews.CurrentPageIndex, anpNews.PageSize, SearchItems, Orderby);
anpNews.RecordCount = pagerSet.RecordCount;
litNoData.Visible = pagerSet.PageSet.Tables[0].Rows.Count <= 0;
rptDataList.DataSource = pagerSet.PageSet;
rptDataList.DataBind();
//绑定统计
lbChange.Text = FacadeManage.aideRecordFacade.GetTotalTreasureChange(SearchItems).ToString();
}
/// <summary>
/// 绑定商品
/// </summary>
protected void BindShop()
{
//查询条件
string where = " WHERE Nullity=0";
if (IntParam != 0)
{
where += string.Format(" AND ( TypeID IN (SELECT TypeID FROM AwardType WHERE ParentID={0}) OR TypeID={0} ) ", IntParam);
AwardType awardType = FacadeManage.aideNativeWebFacade.GetAwardType(IntParam);
if (awardType != null)
{
pageName = awardType.TypeName;
if (awardType.ParentID != 0)
{
awardType = FacadeManage.aideNativeWebFacade.GetAwardType(awardType.ParentID);
pageName = awardType.TypeName + " -> " + pageName;
}
}
}
//登录用户查能兑换商品
int range = GameRequest.GetQueryInt("range", 0);
if (range == 1)
{
if (!Fetch.IsUserOnline())
{
string url = string.Format("/login.aspx?url={0}", Utility.UrlEncode(Utils.GameRequest.GetUrl()));
Response.Redirect(url);
Response.End();
}
else
{
Message msg = FacadeManage.aideAccountsFacade.GetUserGlobalInfo(Fetch.GetUserCookie().UserID, 0, "");
UserInfo user = msg.EntityList[0] as UserInfo;
where = string.Format(" WHERE Price<={1} AND Nullity=0", IntParam, user.UserMedal);
pageName = "我能兑换的商品";
}
}
//排序方法
string orderBy = GetOrderBy();
//绑定数据
PagerSet pagerSet = FacadeManage.aideNativeWebFacade.GetList(AwardInfo.Tablename, PageIndex, anpPage.PageSize, orderBy, where);
anpPage.RecordCount = pagerSet.RecordCount;
if (pagerSet.PageSet.Tables[0].Rows.Count > 0)
{
rptShop.DataSource = pagerSet.PageSet;
rptShop.DataBind();
}
}
//绑定游戏
private void BindGameKindList( )
{
PagerSet pagerSet = FacadeManage.aidePlatformFacade.GetGameKindItemList(1, Int32.MaxValue, "", "ORDER BY KindID ASC");
if (pagerSet.PageSet.Tables[0].Rows.Count > 0)
{
ddlGameKind.DataSource = pagerSet.PageSet;
ddlGameKind.DataTextField = "KindName";
ddlGameKind.DataValueField = "KindID";
ddlGameKind.DataBind( );
}
}
//实卡类型
private void BindCardType( )
{
PagerSet pagerSet = aideTreasureFacade.GetGlobalLivcardList(1, 1000, "", "ORDER BY CardTypeID ASC");
if (pagerSet.PageSet.Tables[0].Rows.Count > 0)
{
ddlCardType.DataSource = pagerSet.PageSet;
ddlCardType.DataTextField = "CardName";
ddlCardType.DataValueField = "CardTypeID";
ddlCardType.DataBind( );
}
}
