private void BindNewsPaper()
{
string key = "Home_Room_NewsPaper_BindNewsPaper_" + this.ddlIsusesID.SelectedValue;
DataTable cacheAsDataTable = Shove._Web.Cache.GetCacheAsDataTable(key);
cacheAsDataTable = null;
if (cacheAsDataTable == null)
{
cacheAsDataTable = new Tables.T_NewsPaperIsuses().Open("", "ID = " + this.ddlIsusesID.SelectedValue, "[ID]");
if (cacheAsDataTable == null)
{
PF.GoError(4, "数据库繁忙，请重试", base.GetType().BaseType.FullName);
return;
}
if (cacheAsDataTable.Rows.Count > 0)
{
Shove._Web.Cache.SetCache(key, cacheAsDataTable, 0xe10);
}
}
if (cacheAsDataTable.Rows.Count > 0)
{
this.LoadOpenDay(cacheAsDataTable.Rows[0]["Name"].ToString());
this.tdIsuseOpenInfo.InnerHtml = cacheAsDataTable.Rows[0]["NPMessage"].ToString().Replace("<$Content>", this.BindWinNumber(cacheAsDataTable.Rows[0]["Name"].ToString()));
}
string text = this.ddlIsusesID.SelectedItem.Text;
this.lbTime.Text = "今天是：" + DateTime.Now.ToString("yyyy年MM月dd日") + "  彩友报<span class='red14_2'>" + text.Substring(0, text.Length - 1) + "</span>期";
}
private void BindddlIsuses(int IsuseId)
{
string key = "Home_Room_NewsPaper";
if (Shove._Web.Cache.GetCacheAsDataTable(key) == null)
{
DataTable dt = new Tables.T_NewsPaperIsuses().Open("", "", " ID desc");
if (dt == null)
{
PF.GoError(4, "数据库繁忙，请重试！", base.GetType().BaseType.FullName);
}
else
{
foreach (DataRow row in dt.Rows)
{
row["Name"] = row["Name"].ToString() + "期";
}
ControlExt.FillDropDownList(this.ddlIsusesID, dt, "Name", "ID");
ListItem item = this.ddlIsusesID.Items.FindByValue(IsuseId.ToString());
if (item != null)
{
this.ddlIsusesID.SelectedIndex = -1;
item.Selected = true;
}
}
}
}
private void BindDataForNewsPaperTypes()
{
DataTable dt = new Tables.T_NewsPaperIsuses().Open("", "", "[ID]");
if (dt == null)
{
PF.GoError(4, "数据库繁忙，请重试", base.GetType().BaseType.FullName);
}
else
{
ControlExt.FillDropDownList(this.ddlNewsTypes, dt, "Name", "ID");
}
}
private void BindddlIsuses()
{
string key = "Home_Room_NewsPaper";
if (Shove._Web.Cache.GetCacheAsDataTable(key) == null)
{
DataTable dt = new Tables.T_NewsPaperIsuses().Open("", "", " ID desc");
if (dt == null)
{
PF.GoError(4, "数据库繁忙，请重试！", base.GetType().BaseType.FullName);
}
else
{
foreach (DataRow row in dt.Rows)
{
row["Name"] = row["Name"].ToString() + "期";
}
ControlExt.FillDropDownList(this.ddlIsusesID, dt, "Name", "ID");
}
}
}
private void BindddlIsuses()
{
string key = "NewsPapers_NewsPaperList";
if (Shove._Web.Cache.GetCacheAsDataTable(key) == null)
{
DataTable dt = new Tables.T_NewsPaperIsuses().Open("", "", " ID desc");
if (dt == null)
{
PF.GoError(4, "数据库繁忙，请重试！", base.GetType().BaseType.FullName);
}
else
{
foreach (DataRow row in dt.Rows)
{
row["Name"] = row["Name"].ToString() + "期";
}
ControlExt.FillDropDownList(this.ddlIsusesID, dt, "Name", "ID");
this.ddlIsusesID.Items.Insert(0, new ListItem("--------", "0"));
this.ddlIsusesID.SelectedIndex = 0;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
this.HidID.Value = Utility.GetRequest("ID");
if (!string.IsNullOrEmpty(this.HidID.Value))
{
DataTable table = new Tables.T_NewsPaperIsuses().Open("", "ID=" + this.HidID.Value, "");
if ((table == null) || (table.Rows.Count == 0))
{
PF.GoError(4, "期号不存在！", base.GetType().BaseType.FullName);
}
else
{
DataRow row = table.Rows[0];
this.tbStartTime.Text = row["StartTime"].ToString();
this.tbEndTime.Text = row["EndTime"].ToString();
this.tbIsuse.Text = row["Name"].ToString();
this.tbContent.Value = row["NPMessage"].ToString();
this.btnAdd.Text = "修改";
}
}
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
int num = 0;
try
{
num = _Convert.StrToInt(this.tbIsuse.Text.Trim(), 0);
}
catch
{
}
if (num == 0)
{
JavaScript.Alert(this.Page, "彩友报期号只能是整数！");
}
else
{
DateTime time;
DateTime time2;
try
{
time = Convert.ToDateTime(this.tbStartTime.Text);
}
catch
{
JavaScript.Alert(this.Page, "开始时间格式输入错误！");
return;
}
try
{
time2 = Convert.ToDateTime(this.tbEndTime.Text);
}
catch
{
JavaScript.Alert(this.Page, "截止时间格式输入错误！");
return;
}
if (time2 >= time)
{
string str = _Convert.ToTextCode(this.tbContent.Value.Trim());
if (str == "")
{
JavaScript.Alert(this.Page, "请输入开奖信息！");
}
else if (this.HidID.Value == "")
{
DataTable table = new Tables.T_NewsPaperIsuses().Open("[ID]", "[Name] = '" + num.ToString().PadLeft(this.tbIsuse.Text.Length, '0') + "'", "");
if (table == null)
{
PF.GoError(4, "数据库繁忙，请重试", "Admin_Admin_NPIsusesAdd");
}
else if (table.Rows.Count > 0)
{
JavaScript.Alert(this.Page, "期号已经存在，请不要输入重名期号！");
}
else if (new Tables.T_NewsPaperIsuses {
Name = { Value = num.ToString().PadLeft(this.tbIsuse.Text.Length, '0') }, StartTime = { Value = time.ToString("yyyy-MM-dd") }, EndTime = { Value = time2.ToString("yyyy-MM-dd") }, NPMessage = { Value = str }
}.Insert() < 0L)
{
JavaScript.Alert(this.Page, "添加彩友报期号失败！");
}
else
{
Shove._Web.Cache.ClearCache("Home_Room_NewsPaper_BindNewsPaper_" + this.HidID.Value);
JavaScript.Alert(this.Page, "添加期号成功！");
}
}
else
{
DataTable table2 = new Tables.T_NewsPaperIsuses().Open("[ID]", "[Name] = '" + num.ToString().PadLeft(this.tbIsuse.Text.Length, '0') + "' and ID<>" + this.HidID.Value, "");
if (table2 == null)
{
PF.GoError(4, "数据库繁忙，请重试", "Admin_IsuseAdd");
}
else if (table2.Rows.Count > 0)
{
JavaScript.Alert(this.Page, "期号已经存在，请不要输入重名期号！");
}
else if (new Tables.T_NewsPaperIsuses {
Name = { Value = num.ToString().PadLeft(this.tbIsuse.Text.Length, '0') }, StartTime = { Value = time }, EndTime = { Value = time2 }, NPMessage = { Value = str }
}.Update("ID=" + this.HidID.Value) < 0L)
{
JavaScript.Alert(this.Page, "修改失败！");
}
else
{
Shove._Web.Cache.ClearCache("Home_Room_NewsPaper_BindNewsPaper_" + this.HidID.Value);
JavaScript.Alert(this.Page, "修改成功！");
}
}
}
else
{
JavaScript.Alert(this.Page, "截止时间应该在开始时间之后！");
}
}
}
