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 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 btnAdd_Click(object sender, EventArgs e)
{
string str = Utility.FilteSqlInfusion(this.tbName.Text.Trim());
if (str == "")
{
JavaScript.Alert(this.Page, "请输入名人用户名！");
}
else
{
int num = _Convert.StrToInt(this.tbOrder.Text.Trim(), -1);
if (num < 0)
{
JavaScript.Alert(this.Page, "顺序输入非法！");
}
else
{
DataTable table = new Tables.T_Users().Open("ID", "Name='" + str + "'", "");
if ((table == null) || (table.Rows.Count == 0))
{
JavaScript.Alert(this.Page, "不存在" + str + "用户！");
}
else
{
table = new Tables.T_Personages().Open("ID", "UserName='******' and LotteryID=" + Utility.FilteSqlInfusion(this.ddlLotteries.SelectedValue) + " and ID<>" + Utility.FilteSqlInfusion(this.hidID.Value), "");
if ((table != null) && (table.Rows.Count > 0))
{
JavaScript.Alert(this.Page, str + "已经是" + this.ddlLotteries.SelectedItem.Text + "的名人了！");
}
else if (new Tables.T_Personages { Order = { Value = num }, UserName = { Value = str }, LotteryID = { Value = this.ddlLotteries.SelectedValue }, IsShow = { Value = this.cbisShow.Checked } }.Update("ID =" + Utility.FilteSqlInfusion(this.hidID.Value)) > 0L)
{
Shove._Web.Cache.ClearCache("Admin_Personages");
JavaScript.Alert(this, "修改成功", "Personages.aspx?LotteryID=" + this.ddlLotteries.SelectedValue);
}
else
{
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();
}
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, "添加失败");
}
}
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");
Shove._Web.Cache.ClearCache("DataCache_CelebrityHall_Collects");
Shove._Web.Cache.ClearCache("DataCache_CelebrityHall_Star");
Shove._Web.Cache.ClearCache("DataCache_CelebrityHall_Recommends");
BindData();
}
}
private void BindLotteryType()
{
string key = "dtLotteriesUseLotteryList";
DataTable cacheAsDataTable = Shove._Web.Cache.GetCacheAsDataTable(key);
if (cacheAsDataTable == null)
{
cacheAsDataTable = new Tables.T_Lotteries().Open("[ID], [Name], [Code]", "[ID] in(" + ((base._Site.UseLotteryList == "") ? "-1" : base._Site.UseLotteryList) + ")", "[ID]");
if (cacheAsDataTable == null)
{
PF.GoError(4, "数据库繁忙，请重试", base.GetType().BaseType.FullName + "(-46)");
return;
}
Shove._Web.Cache.SetCache(key, cacheAsDataTable, 0x1770);
}
this.ddlLotteries.DataSource = cacheAsDataTable;
this.ddlLotteries.DataTextField = "Name";
this.ddlLotteries.DataValueField = "ID";
this.ddlLotteries.DataBind();
this.hidID.Value = Utility.GetRequest("ID");
DataTable table2 = new Tables.T_Personages().Open("", "ID=" + Utility.FilteSqlInfusion(this.hidID.Value), "");
if ((table2 == null) || (table2.Rows.Count == 0))
{
JavaScript.Alert(this.Page, "记录不存在！");
}
else
{
if (this.ddlLotteries.Items.FindByValue(table2.Rows[0]["LotteryID"].ToString()) != null)
{
this.ddlLotteries.SelectedValue = table2.Rows[0]["LotteryID"].ToString();
}
this.tbOrder.Text = table2.Rows[0]["Order"].ToString();
this.cbisShow.Checked = _Convert.StrToBool(table2.Rows[0]["IsShow"].ToString(), true);
this.tbName.Text = table2.Rows[0]["UserName"].ToString();
}
}
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.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, "修改失败");
}
}
