/// <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");
}
