1using System;
  2using System.Data;
  3using System.Configuration;
  4using System.Collections;
  5using System.Web;
  6using System.Web.Security;
  7using System.Web.UI;
  8using System.Web.UI.WebControls;
  9using System.Web.UI.WebControls.WebParts;
 10using System.Web.UI.HtmlControls;
 11
 12public partial class admin_notice : System.Web.UI.Page
 13...{
 14    BaseClass bc = new BaseClass();
 15    protected void Page_Load(object sender, EventArgs e)
 16    ...{
 17        if (Convert.ToString(Session["UID"]) == "")
 18        ...{
 19            Response.Redirect("login.aspx");
 20
 21        }
 22        else
 23        ...{
 24            DataSet ds = null;
 25            int p_int_newCode = 0;
 26            string P_string_newcode = "";
 27            ds = bc.ExecDS("select * from notice order by ID");
 28            if (ds.Tables[0].Rows.Count == 0)
 29            ...{
 30                ID.Text = DateTime.Now.ToString("yyyy-MM-dd") + "GG100001";
 31            }
 32            else
 33            ...{
 34                //   Response.Write(ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1]["fixID"]) ;
 35                // Response.End();
 36
 37
 38                P_string_newcode = Convert.ToString(ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1]["ID"]);
 39                //  Response.Write(P_string_newcode);
 40                //Response.End();
 41                p_int_newCode = Convert.ToInt32(P_string_newcode.Substring(12, 6)) + 1;
 42
 43                P_string_newcode = DateTime.Now.ToString("yyyy-MM-dd") + "GG" + p_int_newCode.ToString();
 44                ID.Text = P_string_newcode;
 45            }
 46
 47            if (!IsPostBack)
 48            ...{
 49
 50                addname.Text = Session["UID"].ToString();
 51                addname.ReadOnly = true;
 52
 53
 54            }
 55        }
 56
 57        
 58        
 59    }
 60
 61
 62
 63    protected void Button1_Click(object sender, EventArgs e)
 64    ...{
 65        string noticeID = ID.Text;
 66        string noticetitle = title.Text;//公告标题
 67        string date = selectdate.Text;//发布日期
 68       // Response.Write(date);
 69       // Response.End();
 70        string content = FreeTextBox1.Text;//内容
 71        string addperson = Session["UID"].ToString();
 72        string valsql = "select count(*) from notice where title='" + noticetitle +"' and noticeDate='" + date + "'";
 73        int count = (int)bc.ExecCscalar(valsql);
 74        if(count>0)
 75        ...{
 76             Response.Write("<script>alert('今天您添加过此公告！');</script>");
 77            return;
 78 
 79        }
 80
 81        string sql = "insert into notice(ID,title,noticeDate,notiContent,noticePerson)values('" + noticeID + "','" + noticetitle + "','" + date + "','" + content + "','" + addperson + "')";
 82        //   Response.Write(sql);
 83        // Response.End();
 84
 85
 86
 87        if (bc.ExecSql(sql))
 88        ...{
 89
 90            Response.Write("<script language=javascript>alert('添加物业公告成功！');location='notice.aspx'</script>");
 91        }
 92        else
 93        ...{
 94            Response.Write("<script>alert('添加物业公告失败，请重试！');</script>");
 95        }
 96
 97    } 
 98    
 99}
100