protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
HidID.Value = Shove._Web.Utility.GetRequest("ID");
if (!string.IsNullOrEmpty(HidID.Value))
{
DataTable dt = new DAL.Tables.T_NewsPaperIsuses().Open("", "ID=" + HidID.Value, "");
if (dt == null || dt.Rows.Count == 0)
{
PF.GoError(ErrorNumber.DataReadWrite, "期号不存在！", this.GetType().BaseType.FullName);
return;
}
DataRow dr = dt.Rows[0];
tbStartTime.Text = dr["StartTime"].ToString();
tbEndTime.Text = dr["EndTime"].ToString();
tbIsuse.Text = dr["Name"].ToString();
tbContent.Value = dr["NPMessage"].ToString();
btnAdd.Text = "修改";
}
}
}
private void BindddlIsuses(int IsuseId)
{
string Key = "Home_Room_NewsPaper";
DataTable dt = Shove._Web.Cache.GetCacheAsDataTable(Key);
if (dt == null)
{
//dt = new DAL.Tables.T_NewsPaperIsuses().Open("", "convert(datetime,StartTime) <= getdate()", " ID desc");
dt = new DAL.Tables.T_NewsPaperIsuses().Open("", "", " ID desc");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试！", this.GetType().BaseType.FullName);
return;
}
foreach (DataRow dr in dt.Rows)
{
dr["Name"] = dr["Name"].ToString() + "期";
}
Shove.ControlExt.FillDropDownList(ddlIsusesID, dt, "Name", "ID");
ListItem item = ddlIsusesID.Items.FindByValue(IsuseId.ToString());
if (item != null)
{
ddlIsusesID.SelectedIndex = -1;
item.Selected = true;
}
}
}
private void BindddlIsuses()
{
string Key = "NewsPapers_NewsPaperList";
DataTable dt = Shove._Web.Cache.GetCacheAsDataTable(Key);
if (dt == null)
{
dt = new DAL.Tables.T_NewsPaperIsuses().Open("", "", " ID desc");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试！", this.GetType().BaseType.FullName);
return;
}
foreach (DataRow dr in dt.Rows)
{
dr["Name"] = dr["Name"].ToString() + "期";
}
Shove.ControlExt.FillDropDownList(ddlIsusesID, dt, "Name", "ID");
ddlIsusesID.Items.Insert(0, (new ListItem("--------", "0")));
ddlIsusesID.SelectedIndex = 0;
}
}
private void BindDataForNewsPaperTypes()
{
DataTable dt = new DAL.Tables.T_NewsPaperIsuses().Open("", "", "[ID]");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", this.GetType().BaseType.FullName);
return;
}
Shove.ControlExt.FillDropDownList(ddlNewsTypes, dt, "Name", "ID");
}
private void BindNewsPaper()
{
if (ddlIsusesID.SelectedIndex != -1)
{
string Key = "Home_Room_NewsPaper_BindNewsPaper_" + ddlIsusesID.SelectedValue;
DataTable dt = Shove._Web.Cache.GetCacheAsDataTable(Key);
dt = null;
if (dt == null)
{
dt = new DAL.Tables.T_NewsPaperIsuses().Open("", "ID = " + Shove._Convert.StrToInt(ddlIsusesID.SelectedValue, 0).ToString() + "", "[ID]");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", this.GetType().BaseType.FullName);
return;
}
if (dt.Rows.Count > 0)
{
Shove._Web.Cache.SetCache(Key, dt, 3600);
}
}
if (dt.Rows.Count > 0)
{
LoadOpenDay(dt.Rows[0]["Name"].ToString());
tdIsuseOpenInfo.InnerHtml = dt.Rows[0]["NPMessage"].ToString().Replace("<$Content>", BindWinNumber(dt.Rows[0]["Name"].ToString()));
}
string isuseName = ddlIsusesID.SelectedItem.Text;
lbTime.Text = "今天是：" + DateTime.Now.ToString("yyyy年MM月dd日") + "  " + "彩友报" + "<span class='red14_2'>" + isuseName.Substring(0, isuseName.Length - 1) + "</span>" + "期";
//标题和关键字
this.Page.Title = "彩友报 " + isuseName + " －" + _Site.Name + "主办－买彩票，就上" + _Site.Name;
this.key.Content = "彩友报" + isuseName;
this.des.Content = "彩友报" + isuseName + " 是" + _Site.Name + "为广大彩民定期提供的一份彩票咨询电子期刊。";
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
int Isuse = 0;
try
{
Isuse = Shove._Convert.StrToInt(tbIsuse.Text.Trim(), 0);
}
catch { }
if (Isuse == 0)
{
Shove._Web.JavaScript.Alert(this.Page, "彩友报期号只能是整数！");
return;
}
System.DateTime StartTime, EndTime;
try
{
StartTime = Convert.ToDateTime(tbStartTime.Text);
}
catch
{
Shove._Web.JavaScript.Alert(this.Page, "开始时间格式输入错误！");
return;
}
try
{
EndTime = Convert.ToDateTime(tbEndTime.Text);
}
catch
{
Shove._Web.JavaScript.Alert(this.Page, "截止时间格式输入错误！");
return;
}
if (EndTime < StartTime)
{
Shove._Web.JavaScript.Alert(this.Page, "截止时间应该在开始时间之后！");
return;
}
string Message = Shove._Convert.ToTextCode(tbContent.Value.Trim());
if (Message == "")
{
Shove._Web.JavaScript.Alert(this.Page, "请输入开奖信息！");
return;
}
if (HidID.Value == "")
{
DataTable dt = new DAL.Tables.T_NewsPaperIsuses().Open("[ID]", "[Name] = '" + Isuse.ToString().PadLeft(tbIsuse.Text.Length, '0') + "'", "");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", "Admin_Admin_NPIsusesAdd");
return;
}
if (dt.Rows.Count > 0)
{
Shove._Web.JavaScript.Alert(this.Page, "期号已经存在，请不要输入重名期号！");
return;
}
DAL.Tables.T_NewsPaperIsuses dt1 = new DAL.Tables.T_NewsPaperIsuses();
dt1.Name.Value = Isuse.ToString().PadLeft(tbIsuse.Text.Length, '0');
dt1.StartTime.Value = StartTime.ToString("yyyy-MM-dd");
dt1.EndTime.Value = EndTime.ToString("yyyy-MM-dd");
dt1.NPMessage.Value = Message;
if (dt1.Insert() < 0)
{
Shove._Web.JavaScript.Alert(this.Page, "添加彩友报期号失败！");
return;
}
else
{
Shove._Web.Cache.ClearCache("Home_Room_NewsPaper_BindNewsPaper_" + this.HidID.Value);
Shove._Web.JavaScript.Alert(this.Page, "添加期号成功！");
}
}
else
{
DataTable dt = new DAL.Tables.T_NewsPaperIsuses().Open("[ID]", "[Name] = '" + Isuse.ToString().PadLeft(tbIsuse.Text.Length, '0') + "' and ID<>" + HidID.Value + "", "");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", "Admin_IsuseAdd");
return;
}
if (dt.Rows.Count > 0)
{
Shove._Web.JavaScript.Alert(this.Page, "期号已经存在，请不要输入重名期号！");
return;
}
DAL.Tables.T_NewsPaperIsuses dt1 = new DAL.Tables.T_NewsPaperIsuses();
dt1.Name.Value = Isuse.ToString().PadLeft(tbIsuse.Text.Length, '0');
dt1.StartTime.Value = StartTime;
dt1.EndTime.Value = EndTime;
dt1.NPMessage.Value = Message;
if (dt1.Update("ID=" + HidID.Value) < 0)
{
Shove._Web.JavaScript.Alert(this.Page, "修改失败！");
return;
}
Shove._Web.Cache.ClearCache("Home_Room_NewsPaper_BindNewsPaper_" + this.HidID.Value);
Shove._Web.JavaScript.Alert(this.Page, "修改成功！");
}
}
