/// <summary> /// 填充数据到表单文本控件,下拉框控件 /// </summary> /// <param name="IsFill"></param> private void FillDataToCtrl(bool IsFill) { DBManager db = DBManager.Instance(); this.ddlType.Items.Clear(); this.ddlType.Items.Add("---请选择---"); this.ddlType.Items.Add("系统公告"); this.ddlType.Items.Add("公司新闻"); this.ddlType.SelectedIndex = 0; this.ddlShow.Items.Clear(); this.ddlShow.Items.Add("是"); this.ddlShow.Items.Add("否"); this.ddlShow.SelectedIndex = 1; NewsOperateDB newsdb = new NewsOperateDB(); if (IsFill) { NewsOperate news = new NewsOperate(); newsdb = news.FindNews(Request.QueryString["NewsID"].ToString()); txtCount.Text = Common.CCToEmpty(newsdb.NewsContent); txtNewsName.Text = Common.CCToEmpty(newsdb.NewsName); ddlShow.SelectedIndex = Convert.ToInt32(newsdb.ShowOnSys); ddlType.SelectedValue = Common.CCToEmpty(newsdb.NewsType); } else { newsdb = new NewsOperateDB(); } }
protected void btnDelete_Click(object sender, EventArgs e) { //创建用户数据表操作类对象 NewsOperate news = new NewsOperate(); string NewsId = Request.QueryString["NewsID"]; //删除用户数据 if (news.DelNews(NewsId)) { Common.ShowMsg("删除成功!"); string newsname = this.txtNewsName.Text.Trim(); string subNewName = newsname; //记录操作员操作 if (newsname.Length > 16) { subNewName = newsname.Substring(0, 16) + "..."; } RecordOperate.SaveRecord(Session["UserID"].ToString(), "系统功能", "删除新闻信息:" + subNewName); ////重新在桌面加载新闻动态 //Response.Write("<script language=javascript>"); //Response.Write("window.top.reload();"); //Response.Write("</script>"); } else { return; } Server.Transfer("System_News_View.aspx"); }
protected void MyDataGrid_ItemCommand(object source, DataGridCommandEventArgs e) { if (e.CommandName == "Delete") { //创建用户数据表操作类对象 NewsOperate news = new NewsOperate(); string newsid = ((Label)e.Item.Cells[1].Controls[1]).Text; //删除用户数据 if (news.DelNews(newsid)) { Common.ShowMsg("删除成功!"); string newsname = ((Label)e.Item.Cells[2].Controls[1]).Text; string subNewName = newsname; //记录操作员操作 if (newsname.Length > 16) { subNewName = newsname.Substring(0, 16) + "..."; } RecordOperate.SaveRecord(Session["UserID"].ToString(), "系统功能", "删除新闻信息:" + subNewName); } Server.Transfer("System_News_View.aspx"); } else { string Url = "System_News_Edit.aspx?NewsID=" + ((Label)e.Item.Cells[1].Controls[1]).Text; Server.Transfer(Url); } }
/// <summary> /// 绑定数据到DataGrid控件MyDataGrid上 /// </summary> private void BindDataGrid() { //创建操作员记录数据表类实例 NewsOperate news = new NewsOperate(); //获取记录数据 DataTable dt = news.Bind(); DataView dv = new DataView(); dt.TableName = "News"; if (dt != null) { dv.Table = dt; dv.Sort = " SendTime DESC"; if (ViewState["Condition"] != null && ViewState["Condition"].ToString() != "") { dv.RowFilter = ViewState["Condition"].ToString(); } else { dv = dt.DefaultView; } //新增ID自增值列绑定 dt.Columns.Add(new DataColumn("idno", Type.GetType("System.Int32"))); int intCountRecNum = dv.Count; //获取数据表记录数 for (int i = 0; i < intCountRecNum; i++) { dv[i]["idno"] = i + 1; } MyDataGrid.DataSource = dv; int PageCount = 0; if (intCountRecNum % MyDataGrid.PageSize == 0) { PageCount = intCountRecNum / MyDataGrid.PageSize; } else { PageCount = intCountRecNum / MyDataGrid.PageSize + 1; } if (PageCount != 0 && MyDataGrid.CurrentPageIndex >= PageCount) { MyDataGrid.CurrentPageIndex = PageCount - 1; } MyDataGrid.DataBind(); lblRecNum.Text = intCountRecNum.ToString(); //显示总记录数 ShowStats(); //显示页数信息 } }
protected void btnSave_Click(object sender, EventArgs e) { if (Page.IsValid) { //创建用户数据表操作类对象 NewsOperate news = new NewsOperate(); if (ViewState["OperateStatus"].ToString() == "AddData") { string count = this.txtCount.Text.Trim(); string newsname = this.txtNewsName.Text.Trim(); string show = this.ddlShow.SelectedIndex.ToString(); string type = this.ddlType.SelectedIndex > 0 ? ddlType.SelectedItem.Value : ""; //增加用户数据 if (news.AddNews(newsname, count, type, show, Session["UserId"].ToString())) { Common.ShowMsg("添加成功!"); string subNewName = newsname; //记录操作员操作 if (newsname.Length > 16) { subNewName = newsname.Substring(0, 16) + "..."; } RecordOperate.SaveRecord(Session["UserID"].ToString(), "系统功能", "增加新闻信息:" + subNewName); ////重新在桌面加载新闻动态 //Response.Write("<script language=javascript>"); //Response.Write("window.top.reload();"); //Response.Write("</script>"); } else { return; } } if (ViewState["OperateStatus"].ToString() == "EditData") { string count = this.txtCount.Text.Trim(); string newsname = this.txtNewsName.Text.Trim(); string show = this.ddlShow.SelectedIndex.ToString(); string type = this.ddlType.SelectedIndex > 0 ? ddlType.SelectedItem.Value : ""; string newsid = Request.QueryString["NewsID"].ToString(); //更新用户数据 if (news.UpdateNews(newsid, newsname, count, type, show, Session["UserID"].ToString())) { Common.ShowMsg("更新成功!"); string subNewName = newsname; //记录操作员操作 if (newsname.Length > 16) { subNewName = newsname.Substring(0, 16) + "..."; } RecordOperate.SaveRecord(Session["UserID"].ToString(), "系统功能", "修改新闻信息:" + subNewName); ////重新在桌面加载新闻动态 //Response.Write("<script language=javascript>"); //Response.Write("window.top.reload();"); //Response.Write("</script>"); } else { return; } } } Server.Transfer("System_News_View.aspx"); }