private void BindData() { hlAdd.NavigateUrl = "PersonagesAdd.aspx?LotteryID=" + ddlLotteries.SelectedValue; string Key = "Admin_Personages"; DataTable dt = Shove._Web.Cache.GetCacheAsDataTable(Key); if (dt == null) { dt = new DAL.Tables.T_Personages().Open("", "", "[Order]"); if (dt == null) { PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试", this.GetType().BaseType.FullName + "(59)"); return; } Shove._Web.Cache.SetCache(Key, dt, 6000); } DataRow[] drs = dt.Select("LotteryID=" + ddlLotteries.SelectedValue + ""); DataTable dtData = dt.Clone(); foreach (DataRow dr in drs) { dtData.Rows.Add(dr.ItemArray); } g.DataSource = dtData; g.DataBind(); }
private void BindPersonages() { string Key = "Admin_Personages"; DataTable dt = Shove._Web.Cache.GetCacheAsDataTable(Key); if (dt == null) { dt = new DAL.Tables.T_Personages().Open("", "", "[Order]"); if (dt == null || dt.Rows.Count == 0) { return; } Shove._Web.Cache.SetCache(Key, dt, 6000); } DataRow[] drs = dt.Select("IsShow=1 and LotteryID=" + HidLotteryID.Value + "", "[Order]"); Personages.InnerHtml = "合买名人:"; int i = 0; foreach (DataRow dr in drs) { Personages.InnerHtml += "<a href='FollowFriendSchemeAdd.aspx?LotteryID=" + HidLotteryID.Value + "&FollowUserID=" + dr["ID"] + "&FollowUserName="******"UserName"].ToString()) + "' style=' text-decoration:none;padding-left:15px;color:#FF0065'>" + dr["UserName"].ToString() + "</a>"; i++; if (i == 6) { break; } } }
protected void btnAdd_Click(object sender, EventArgs e) { string UserName = Shove._Web.Utility.FilteSqlInfusion(tbName.Text.Trim()); if (UserName == "") { Shove._Web.JavaScript.Alert(this.Page, "请输入名人用户名!"); return; } int order = Shove._Convert.StrToInt(tbOrder.Text.Trim(), -1); if (order < 0) { Shove._Web.JavaScript.Alert(this.Page, "顺序输入非法!"); return; } DataTable dt = new DAL.Tables.T_Users().Open("ID", "Name='" + UserName + "'", ""); if (dt == null || dt.Rows.Count == 0) { Shove._Web.JavaScript.Alert(this.Page, "不存在" + UserName + "用户!"); return; } dt = new DAL.Tables.T_Personages().Open("ID", "UserName='******' and LotteryID=" + Shove._Web.Utility.FilteSqlInfusion(ddlLotteries.SelectedValue) + " and ID<>" + Shove._Web.Utility.FilteSqlInfusion(hidID.Value) + "", ""); if (dt != null && dt.Rows.Count > 0) { Shove._Web.JavaScript.Alert(this.Page, UserName + "已经是" + ddlLotteries.SelectedItem.Text + "的名人了!"); return; } DAL.Tables.T_Personages p = new DAL.Tables.T_Personages(); p.Order.Value = order; p.UserName.Value = UserName; p.LotteryID.Value = ddlLotteries.SelectedValue; p.IsShow.Value = cbisShow.Checked; long l = p.Update("ID =" + Shove._Web.Utility.FilteSqlInfusion(hidID.Value)); if (l > 0) { Shove._Web.Cache.ClearCache("Admin_Personages"); Shove._Web.JavaScript.Alert(this, "修改成功", "Personages.aspx?LotteryID=" + ddlLotteries.SelectedValue); } else { Shove._Web.JavaScript.Alert(this, "修改失败"); } }
private void BindPersonages() { string Key = "Admin_Personages"; DataTable dt = Shove._Web.Cache.GetCacheAsDataTable(Key); if (dt == null) { dt = new DAL.Tables.T_Personages().Open("", "", "[Order]"); if (dt == null || dt.Rows.Count == 0) { return; } Shove._Web.Cache.SetCache(Key, dt, 6000); } DataRow[] drs = dt.Select("IsShow=1 and LotteryID=" + HidLotteryID.Value + "", "[Order]"); int i = 0; System.Text.StringBuilder sb = new StringBuilder(); //sb.AppendLine("合买: "); sb.AppendLine("<table border=\"0\" height=\"28\">"); foreach (DataRow dr in drs) { if (i == 0) { sb.AppendLine("<tr>"); sb.AppendLine("<td rowspan=\"2\">合买名人:</td>"); } sb.AppendLine("<td>"); string html = "<a href='FollowFriendSchemeAdd.aspx?LotteryID=" + HidLotteryID.Value + "&FollowUserID=" + dr["UserID"].ToString() + "&FollowUserName="******"UserName"].ToString()) + "' style=' text-decoration:none;padding-left:15px;color:#FF0065'>" + dr["UserName"].ToString() + "</a>"; sb.AppendLine(html); sb.AppendLine("</td>"); i++; if (i == 6) { break; } if (i == 3) { sb.AppendLine("</tr>"); sb.AppendLine("<tr>"); } } sb.AppendLine("</tr></table>"); Personages.InnerHtml = sb.ToString(); }
private void BindLotteryType() { string CacheKey = "dtLotteriesUseLotteryList"; DataTable dtLotteries = Shove._Web.Cache.GetCacheAsDataTable(CacheKey); if (dtLotteries == null) { dtLotteries = new DAL.Tables.T_Lotteries().Open("[ID], [Name], [Code]", "[ID] in(" + (_Site.UseLotteryList == "" ? "-1" : _Site.UseLotteryList) + ")", "[ID]"); if (dtLotteries == null) { PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试", this.GetType().BaseType.FullName + "(-46)"); return; } Shove._Web.Cache.SetCache(CacheKey, dtLotteries, 6000); } ddlLotteries.DataSource = dtLotteries; ddlLotteries.DataTextField = "Name"; ddlLotteries.DataValueField = "ID"; ddlLotteries.DataBind(); hidID.Value = Shove._Web.Utility.GetRequest("ID"); DataTable dt = new DAL.Tables.T_Personages().Open("", "ID=" + Shove._Web.Utility.FilteSqlInfusion(hidID.Value) + "", ""); if (dt == null || dt.Rows.Count == 0) { Shove._Web.JavaScript.Alert(this.Page, "记录不存在!"); return; } if (ddlLotteries.Items.FindByValue(dt.Rows[0]["LotteryID"].ToString()) != null) { ddlLotteries.SelectedValue = dt.Rows[0]["LotteryID"].ToString(); } tbOrder.Text = dt.Rows[0]["Order"].ToString(); cbisShow.Checked = Shove._Convert.StrToBool(dt.Rows[0]["IsShow"].ToString(), true); tbName.Text = dt.Rows[0]["UserName"].ToString(); }
protected void g_ItemCommand(object source, DataGridCommandEventArgs e) { if (e.CommandName == "Edit") { this.Response.Redirect("PersonagesEdit.aspx?ID=" + e.Item.Cells[5].Text + "", true); } if (e.CommandName == "Deletes") { string id = e.Item.Cells[5].Text; DAL.Tables.T_Personages p = new DAL.Tables.T_Personages(); p.Delete("ID=" + id); Shove._Web.Cache.ClearCache("Admin_Personages"); BindData(); } }
protected void btnAdd_Click(object sender, EventArgs e) { string UserName = tbName.Text.Trim(); if (UserName == "") { Shove._Web.JavaScript.Alert(this.Page, "请输入名人用户名!"); return; } int order = Shove._Convert.StrToInt(tbOrder.Text.Trim(), -1); if (order < 0) { Shove._Web.JavaScript.Alert(this.Page, "顺序输入非法!"); return; } DataTable dt = new DAL.Tables.T_Users().Open("ID", "Name='" + UserName + "'", ""); if (dt == null || dt.Rows.Count == 0) { Shove._Web.JavaScript.Alert(this.Page, "不存在" + UserName + "用户!"); return; } int UserID = 0; // 获取用户ID try { UserID = Shove._Convert.StrToInt(dt.Rows[0]["ID"].ToString(), 0); } catch { UserID = 0; } dt = new DAL.Tables.T_Personages().Open("ID", "UserName='******' and LotteryID=" + Shove._Web.Utility.FilteSqlInfusion(ddlLotteries.SelectedValue) + "", ""); if (dt != null && dt.Rows.Count > 0) { Shove._Web.JavaScript.Alert(this.Page, UserName + "已经是" + ddlLotteries.SelectedItem.Text + "的名人了!"); return; } DAL.Tables.T_Personages p = new DAL.Tables.T_Personages(); p.UserID.Value = UserID; p.Order.Value = order; p.UserName.Value = UserName; p.LotteryID.Value = ddlLotteries.SelectedValue; p.IsShow.Value = cbisShow.Checked; p.IsRecommend.Value = cbIsRecommend.Checked; if (cbIsRecommend.Checked) { Shove.Database.MSSQL.ExecuteNonQuery("update T_Personages set IsRecommend = 0"); // 清楚缓存 Shove._Web.Cache.ClearCache("DataCache_CelebrityHall_Recommends"); } long l = p.Insert(); if (l >= 0) { Shove._Web.Cache.ClearCache("Admin_Personages"); Shove._Web.Cache.ClearCache("DataCache_CelebrityHall_Collects"); Shove._Web.Cache.ClearCache("DataCache_CelebrityHall_Star"); Shove._Web.Cache.ClearCache("DataCache_CelebrityHall_Recommends"); Shove._Web.JavaScript.Alert(this, "添加成功", "Personages.aspx?LotteryID=" + ddlLotteries.SelectedValue); } else { Shove._Web.JavaScript.Alert(this, "添加失败"); } }