protected void btnDeleteSelect_Click(object sender, EventArgs e)
 {
     if (Session["ZT_ADMIN"] == null)
     {
         Response.Redirect("Login.aspx");
     }
     else
     {
         if (!Communal.CheckQx("LiuYanDelete.aspx"))
         {
             Response.Redirect("RightsWarn.aspx");
         }
         else
         {
             string DeleteTitle = "";
             foreach (GridViewRow gr in this.GridView1.Rows)
             {
                 CheckBox cb = (CheckBox)gr.Cells[1].FindControl("Select");
                 if (cb.Checked)
                 {
                     //删除数据库信息
                     Label ll = (Label)gr.Cells[1].FindControl("lblLiuYanID");
                     int LiuYanID = Convert.ToInt32(ll.Text);
                     WebProject.BLL.BaseData.ZT_COM_LiuYan bll_LiuYan = new WebProject.BLL.BaseData.ZT_COM_LiuYan();
                     DeleteTitle += bll_LiuYan.GetModel(LiuYanID).MainInfo + ",";
                     bll_LiuYan.Delete(LiuYanID);
                 }
             }
             LogManage.WriteLog(Request.UserHostAddress, "留言管理", "删除留言", "成功", "留言主题:" + DeleteTitle.TrimEnd(',') + ", 操作人:" + SessionUtil.GetAdminSession().AdminNo);
             ShowData();
         }
     }
 }
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        if (Session["ZT_ADMIN"] == null)
        {
            Response.Redirect("Login.aspx");
        }
        else
        {
            if (Request["LiuYanID"] + "" == "")
            {
                Response.Redirect("RightsWarn.aspx");
            }
            else
            {
                try
                {
                    WebProject.BLL.BaseData.ZT_COM_LiuYan bll_LiuYan = new WebProject.BLL.BaseData.ZT_COM_LiuYan();
                    WebProject.Model.BaseData.ZT_COM_LiuYan model_LiuYan = bll_LiuYan.GetModel(Int32.Parse(Request["LiuYanID"].ToString()));
                    model_LiuYan.Reply = this.txtReply.Text.Trim();
                    model_LiuYan.ReplyTime = DateTime.Now;
                    model_LiuYan.LastUpdateBy = SessionUtil.GetAdminSession().AdminNo;
                    model_LiuYan.LastUpdateDate = DateTime.Now;
                    bll_LiuYan.Update(model_LiuYan);
                    LogManage.WriteLog(Request.UserHostAddress, "留言管理", "回复留言", "成功", "回复主题:" + model_LiuYan.MainInfo + ", 操作人:" + SessionUtil.GetAdminSession().AdminNo);

                    MessageBox.ShowAndRedirect(this, "回复留言成功!", "LiuYanList.aspx");
                }
                catch
                {
                    Response.Redirect("RightsWarn.aspx");
                }
            }
        }
    }
    public void ShowLiuYanInfo()
    {
        int currentPage = Convert.ToInt32(this.dang.Text);  //当前页
        WebProject.BLL.BaseData.ZT_COM_LiuYan bll_LiuYan = new WebProject.BLL.BaseData.ZT_COM_LiuYan();
        DataSet ds = bll_LiuYan.GetList(" 1=1 ");

        this.count.Text = ds.Tables[0].Rows.Count.ToString();
        if (ds.Tables[0].Rows.Count >= 0)
        {
            System.Web.UI.WebControls.PagedDataSource pds = new PagedDataSource();
            pds.DataSource = ds.Tables[0].DefaultView;
            pds.AllowPaging = true;
            pds.PageSize = 5; //设置页面显示的数目
            pds.CurrentPageIndex = currentPage - 1; //当前页面索引,索引号从0开始
            this.countpage.Text = pds.PageCount.ToString();//总页数

            if (currentPage == 1)
            {
                this.shou.Enabled = false;
                this.shang.Enabled = false;
            }
            else
            {
                this.shou.Enabled = true;
                this.shang.Enabled = true;
            }

            if (currentPage == pds.PageCount)
            {
                this.xia.Enabled = false;
                this.last.Enabled = false;
            }
            else
            {
                this.xia.Enabled = true;
                this.last.Enabled = true;
            }

            this.Repeater1.DataSource = pds;
            this.Repeater1.DataBind();
        }
        else
        {
            this.lblMessage.Visible = true;
            this.countpage.Text = this.dang.Text;
            this.shou.Enabled = false;
            this.shang.Enabled = false;
            this.xia.Enabled = false;
            this.last.Enabled = false;
        }
    }
 public void ShowData()
 {
     if (Request["LiuYanID"] + "" == "")
     {
         Response.Redirect("RightsWarn.aspx");
     }
     else
     {
         try
         {
             WebProject.BLL.BaseData.ZT_COM_LiuYan bll_LiuYan = new WebProject.BLL.BaseData.ZT_COM_LiuYan();
             WebProject.Model.BaseData.ZT_COM_LiuYan model_LiuYan = bll_LiuYan.GetModel(Int32.Parse(Request["LiuYanID"].ToString()));
             this.lblAddress.Text = model_LiuYan.Address.ToString();
             this.lblBody.Text = model_LiuYan.Body.ToString();
             this.lblCompanyName.Text = model_LiuYan.CompanyName.ToString();
             this.lblEmail.Text = model_LiuYan.Email.ToString();
             this.lblFax.Text = model_LiuYan.Fax.ToString();
             if (model_LiuYan.IsIndex.ToString() == "1")
             {
                 this.lblIsIndex.Text = "已审核";
             }
             else
             {
                 this.lblIsIndex.Text = "未审核";
             }
             this.lblMailNum.Text = model_LiuYan.MailNum.ToString();
             this.lblMainInfo.Text = model_LiuYan.MainInfo.ToString();
             this.lblMobile.Text = model_LiuYan.Mobile.ToString();
             this.lblName.Text = model_LiuYan.Name.ToString();
             this.lblReply.Text = model_LiuYan.Reply.ToString();
             this.lblReplyTime.Text = model_LiuYan.ReplyTime.ToString();
             if (model_LiuYan.Sex.ToString() == "1")
             {
                 this.lblSex.Text = "男";
             }
             else
             {
                 this.lblSex.Text = "女";
             }
             this.lblTelephone.Text = model_LiuYan.Telephone.ToString();
         }
         catch
         {
             Response.Redirect("RightsWarn.aspx");
         }
     }
 }
 public void ShowData()
 {
     WebProject.BLL.BaseData.ZT_COM_LiuYan bll_LiuYan = new WebProject.BLL.BaseData.ZT_COM_LiuYan();
     DataSet ds = bll_LiuYan.GetList("");
     if (ds.Tables[0].Rows.Count > 0)
     {
         this.lblMessage.Visible = false;
         this.btnDeleteSelect.Visible = true;
         this.GridView1.Visible = true;
         this.GridView1.DataSource = ds;
         this.GridView1.DataBind();
     }
     else
     {
         this.lblMessage.Visible = true;
         this.btnDeleteSelect.Visible = false;
         this.GridView1.Visible = false;
     }
 }
 protected void btnIsIndex_Click(object sender, EventArgs e)
 {
     if (Session["ZT_ADMIN"] == null)
     {
         Response.Redirect("Login.aspx");
     }
     else
     {
         try
         {
             WebProject.BLL.BaseData.ZT_COM_LiuYan bll_LiuYan = new WebProject.BLL.BaseData.ZT_COM_LiuYan();
             WebProject.Model.BaseData.ZT_COM_LiuYan model_LiuYan = bll_LiuYan.GetModel(Int32.Parse(Request["LiuYanID"].ToString()));
             model_LiuYan.IsIndex = "1";
             model_LiuYan.LastUpdateBy = SessionUtil.GetAdminSession().AdminNo;
             model_LiuYan.LastUpdateDate = DateTime.Now;
             bll_LiuYan.Update(model_LiuYan);
             MessageBox.ShowAndRedirect(this, "设为审核通过成功!", "LiuYanList.aspx");
         }
         catch
         {
             Response.Redirect("RightsWarn.aspx");
         }
     }
 }
示例#7
0
 protected void btnSubmit_Click(object sender, EventArgs e)
 {
     if (this.txtMainInfo.Text.Trim() == "")
     {
         MessageBox.Show(this, "请填写留言主题");
         return;
     }
     else
     {
         if (this.txtName.Text.Trim() == "")
         {
             MessageBox.Show(this, "请填写您的姓名");
             return;
         }
         else
         {
             string sex = "1";
             if (this.sex1.Checked == false && this.sex2.Checked == false)
             {
                 MessageBox.Show(this, "请选择性别");
                 return;
             }
             if (this.sex2.Checked)
             {
                 sex = "0";
             }
             else
             {
                 if (this.txtMobile.Text.Trim() == "")
                 {
                     MessageBox.Show(this, "请填写您的手机号码");
                     return;
                 }
                 else
                 {
                     double u;
                     if (!double.TryParse(this.txtMobile.Text, out u))
                     {
                         MessageBox.Show(this, "手机号码必须为数字!");
                         return;
                     }
                     if (u <= 13000000000 || u >= 19000000000)
                     {
                         MessageBox.Show(this, "请填写正确的手机号码!");//判断输入框中的值是否为数字和是否溢出
                         return;
                     }
                     else
                     {
                         if (this.txtCompanyName.Text.Trim() == "")
                         {
                             MessageBox.Show(this, "请填写您的单位名称");
                             return;
                         }
                         else
                         {
                             if (this.txtAddress.Text.Trim().ToLower().IndexOf("script") > 0 || this.txtBody.Text.Trim().ToLower().IndexOf("script") > 0 || this.txtCompanyName.Text.Trim().ToLower().IndexOf("script") > 0 || this.txtEmail.Text.Trim().ToLower().IndexOf("script") > 0 || this.txtFax.Text.Trim().ToLower().IndexOf("script") > 0 || this.txtMailNum.Text.Trim().ToLower().IndexOf("script") > 0 || this.txtMainInfo.Text.Trim().ToLower().IndexOf("script") > 0 || this.txtMobile.Text.Trim().ToLower().IndexOf("script") > 0 || this.txtName.Text.Trim().ToLower().IndexOf("script") > 0 || this.txtTelephone.Text.Trim().ToLower().IndexOf("script") > 0)
                             {
                                 MessageBox.Show(this, "留言信息内请不要包含非法字符!");
                                 return;
                             }
                             if (CheckString.CheckSqlKeyWord(this.txtAddress.Text)==true || CheckString.CheckSqlKeyWord(this.txtBody.Text)==true || CheckString.CheckSqlKeyWord(this.txtCompanyName.Text)==true || CheckString.CheckSqlKeyWord(this.txtEmail.Text)==true || CheckString.CheckSqlKeyWord(this.txtFax.Text)==true || CheckString.CheckSqlKeyWord(this.txtMailNum.Text)==true || CheckString.CheckSqlKeyWord(this.txtMainInfo.Text)==true || CheckString.CheckSqlKeyWord(this.txtMobile.Text)==true || CheckString.CheckSqlKeyWord(this.txtName.Text)==true || CheckString.CheckSqlKeyWord(this.txtTelephone.Text)==true)
                             {
                                 MessageBox.Show(this, "留言信息内请不要包含非法字符!");
                                 return;
                             }
                             WebProject.BLL.BaseData.ZT_COM_LiuYan bll_LiuYan = new WebProject.BLL.BaseData.ZT_COM_LiuYan();
                             WebProject.Model.BaseData.ZT_COM_LiuYan model_LiuYan = new WebProject.Model.BaseData.ZT_COM_LiuYan();
                             model_LiuYan.Address = this.txtAddress.Text.Trim();
                             model_LiuYan.Body = this.txtBody.Text.Trim();
                             model_LiuYan.CompanyName = this.txtCompanyName.Text.Trim();
                             model_LiuYan.Email = this.txtEmail.Text.Trim();
                             model_LiuYan.Fax = this.txtFax.Text.Trim();
                             model_LiuYan.MailNum = this.txtMailNum.Text.Trim();
                             model_LiuYan.MainInfo = this.txtMainInfo.Text.Trim();
                             model_LiuYan.Mobile = this.txtMobile.Text.Trim();
                             model_LiuYan.Name = this.txtName.Text.Trim();
                             model_LiuYan.Telephone = this.txtTelephone.Text.Trim();
                             model_LiuYan.Sex = sex.ToString();
                             bll_LiuYan.Add(model_LiuYan);
                             MessageBox.ShowAndRedirect(this, "留言填写成功!", "Index.aspx");
                         }
                     }
                 }
             }
         }
     }
 }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        if (Session["ZT_ADMIN"] == null)
        {
            Response.Redirect("Login.aspx");
        }
        else
        {
            if (!Communal.CheckQx("LiuYanDelete.aspx"))
            {
                Response.Redirect("RightsWarn.aspx");
            }
            else
            {
                //删除数据库的信息
                Label ll = (Label)this.GridView1.Rows[e.RowIndex].Cells[1].FindControl("lblLiuYanID");
                int LiuYanID = Convert.ToInt32(ll.Text);
                WebProject.BLL.BaseData.ZT_COM_LiuYan bll_LiuYan = new WebProject.BLL.BaseData.ZT_COM_LiuYan();
                LogManage.WriteLog(Request.UserHostAddress, "留言管理", "删除留言", "成功", "留言主题:" + bll_LiuYan.GetModel(LiuYanID).MainInfo + ", 操作人:" + SessionUtil.GetAdminSession().AdminNo);

                bll_LiuYan.Delete(LiuYanID);
                //重新加载信息
                ShowData();
            }
        }
    }