protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DalOperationAboutGameCategory dal = new DalOperationAboutGameCategory(); DataTable dt = dal.GetList().Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { ddlGameCategory.Items.Add(new ListItem(dt.Rows[i]["gameTitle"].ToString().Trim(), dt.Rows[i]["gameCategoryId"].ToString().Trim())); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DalOperationAboutGameCategory dalGC = new DalOperationAboutGameCategory(); DataTable dtGC = dalGC.GetList().Tables[0]; for (int i = 0; i < dtGC.Rows.Count; i++) { ddlGameCategory.Items.Add(new ListItem(dtGC.Rows[i]["gameTitle"].ToString().Trim(), dtGC.Rows[i]["gameCategoryId"].ToString().Trim())); } DalOperationAboutGameType dal = new DalOperationAboutGameType(); DataTable dt = dal.Get(gameTypeId).Tables[0]; if (dt.Rows.Count > 0) { txtGameTypeTitle.Text = dt.Rows[0]["gameTypeTitle"].ToString().Trim(); string _allowSexType = dt.Rows[0]["allowSexType"].ToString().Trim(); txtGroupCapability.Text = dt.Rows[0]["groupCapability"].ToString().Trim(); hidGroupCapability.Value = dt.Rows[0]["groupCapability"].ToString().Trim(); for (int i = 0; i < ddlGameCategory.Items.Count; i++) { if (ddlGameCategory.Items[i].Value == dt.Rows[0]["gameCategoryId"].ToString().Trim()) { ddlGameCategory.SelectedIndex = i; break; } } foreach (ListItem rbt in rblTeacher.Items) { if (rbt.Value == _allowSexType) { rbt.Selected = true; } } } } }
public void DataBindGameCategoryAndType(DropDownList ddlGameCategory, DropDownList ddlGameType) { UserCookiesInfo user = BllOperationAboutUser.GetUserCookiesInfo(); DalOperationAboutGameCategory dalGameCategory = new DalOperationAboutGameCategory(); DataTable dtGameCategory = dalGameCategory.GetList().Tables[0]; for (int i = 0; i < dtGameCategory.Rows.Count; i++) { ddlGameCategory.Items.Add(new ListItem(dtGameCategory.Rows[i]["gameTitle"].ToString().Trim(), dtGameCategory.Rows[i]["gameCategoryId"].ToString().Trim())); } DalOperationAboutGameType dalGameType = new DalOperationAboutGameType(); DataTable dtGameType = dalGameType.GetGameTypeByGameCategoryId(int.Parse(ddlGameCategory.SelectedValue)).Tables[0]; for (int i = 0; i < dtGameType.Rows.Count; i++) { ddlGameType.Items.Add(new ListItem(dtGameType.Rows[i]["gameTypeTitle"].ToString().Trim(), dtGameType.Rows[i]["gameTypeId"].ToString().Trim())); } }
//绑定信息 public void DataListBindGameCategory() { DalOperationAboutGameCategory doan = new DalOperationAboutGameCategory(); DataTable dt = doan.GetList().Tables[0]; this.AspNetPager1.RecordCount = dt.Rows.Count; AspNetPager1.PageSize = CommonUtility.pageSize; PagedDataSource pds = new PagedDataSource(); //定义一个PagedDataSource类来执行分页功 pds.DataSource = dt.DefaultView; pds.AllowPaging = true; pds.CurrentPageIndex = pageIndex - 1; pds.PageSize = AspNetPager1.PageSize; this.dlGameCategory.DataSource = pds; this.dlGameCategory.DataBind(); if (pds.Count == 0) { this.dlGameCategory.ShowFooter = true; } else { this.dlGameCategory.ShowFooter = false; } }
protected void Page_Load(object sender, EventArgs e) { if (Request["fragment"] != null) { fragmentFlag = Request["fragment"]; } CommonUtility.ShowLiControl(fragmentFlag, liFragment1, liFragment2, liFragment3, liFragment4, liFragment5, divFragment1, divFragment2, divFragment3, divFragment4, divFragment5); if (fragmentFlag.Equals("1")) { if (!IsPostBack) { DataListBindGameCategory(); } } if (fragmentFlag.Equals("2")) { if (!IsPostBack) { DalOperationAboutGameCategory dal = new DalOperationAboutGameCategory(); DataTable dt = dal.GetList().Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { ddlGameCategoryAboutGameType.Items.Add(new ListItem(dt.Rows[i]["gameTitle"].ToString().Trim(), dt.Rows[i]["gameCategoryId"].ToString().Trim())); } DataListBindGameType(); } } if (fragmentFlag.Equals("3")) { if (!IsPostBack) { DataBindGameCategoryAndType(ddlGameCategory, ddlGameType); DataListBindEnrollList(); } } if (fragmentFlag.Equals("4")) { if (!IsPostBack) { DataBindGameCategoryAndType(ddlDrawGameCategory, ddlDrawGameType); DataListBindGroupNum(); } } }
public void DataBindGameCategoryAndType(DropDownList ddlGameCategory, DropDownList ddlGameType) { UserCookiesInfo user = BllOperationAboutUser.GetUserCookiesInfo(); DalOperationAboutGameCategory dalGameCategory = new DalOperationAboutGameCategory(); DataTable dtGameCategory = (ddlGameCategory.ID == "ddlEnrollGameCategory" ? dalGameCategory.GetGameCategoryIng(DateTime.Now).Tables[0] : dalGameCategory.GetList().Tables[0]); for (int i = 0; i < dtGameCategory.Rows.Count; i++) { ddlGameCategory.Items.Add(new ListItem(dtGameCategory.Rows[i]["gameTitle"].ToString().Trim(), dtGameCategory.Rows[i]["gameCategoryId"].ToString().Trim())); } //检查是否有活动届次数据 if (ddlGameCategory.Items.Count == 0) { Javascript.AlertAndRedirect("当前暂无需要报名的活动届次信息:(", "/Administrator/EnrollManage.aspx?fragment=2", Page); return; } if (CommonUtility.SafeCheckByParams<String>(gameCategoryId, ref _gameCategoryId)) { for (int i = 0; i < ddlGameCategory.Items.Count; i++) { if (ddlGameCategory.Items[i].Value == gameCategoryId) { ddlGameCategory.SelectedIndex = i; break; } } } DalOperationAboutGameType dalGameType = new DalOperationAboutGameType(); DataTable dtGameType = (ddlGameType.ID == "ddlEnrollGameType" || ddlGameType.ID == "ddlGameType" ? dalGameType.GetListByGameCategoryIdAndSex(int.Parse(ddlGameCategory.SelectedValue), user.Sex == "男" ? "1" : "2").Tables[0] : dalGameType.GetGameTypeByGameCategoryId(int.Parse(ddlGameCategory.SelectedValue)).Tables[0]); for (int i = 0; i < dtGameType.Rows.Count; i++) { ddlGameType.Items.Add(new ListItem(dtGameType.Rows[i]["gameTypeTitle"].ToString().Trim(), dtGameType.Rows[i]["gameTypeId"].ToString().Trim())); } if (CommonUtility.SafeCheckByParams<String>(gameTypeId, ref _gameCategoryId)) { for (int i = 0; i < ddlGameType.Items.Count; i++) { if (ddlGameType.Items[i].Value == gameTypeId) { ddlGameType.SelectedIndex = i; break; } } } //检查是否有活动届次和活动类型数据 if (!(ddlGameCategory.Items.Count > 0 && ddlGameType.Items.Count > 0)) { Javascript.AlertAndRedirect("当前暂无需要报名的活动届次信息:(", "/Administrator/EnrollManage.aspx?fragment=2", Page); return; } }