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, "修改成功!"); } }