- using System;
- using System.Collections;
- using System.ComponentModel;
- using System.Data;
- using System.Data.SqlClient;
- using System.Drawing;
- using System.Web;
- using System.Web.SessionState;
- using System.Web.UI;
- using System.Web.UI.WebControls;
- using System.Web.UI.HtmlControls;
- using qminoa.DA.Schedule;
- namespace qminoa.Webs.Schedule
- {
- public class NoteAddUp : qminoa.Webs.PageBase
- {
- private int id = 0;
- protected System.Web.UI.WebControls.TextBox txtContent;
- protected System.Web.UI.WebControls.Label lblCDate;
- protected System.Web.UI.WebControls.Label lblCDateV;
- protected System.Web.UI.WebControls.ImageButton cmdSaveExi;
- protected System.Web.UI.WebControls.ImageButton cmdDel;
- protected System.Web.UI.WebControls.ImageButton cmdExit;
- protected System.Web.UI.WebControls.Label lblID;
- private NoteDA objnote = new NoteDA();
- private void Page_Load(object sender, System.EventArgs e)
- {
- this.PageBegin("我的便笺",false);
- if(!IsPostBack)
- {
- if(Request.QueryString["id"] != null)
- {
- id =Int32.Parse(Request.QueryString["id"]);
- cmdDel.Visible = true;
- NoteDataBind();
- }
- else
- {
- cmdDel.Visible = false;
- }
- }
- else
- {
- if(!(Request.QueryString["id"] == null))
- {
- id =Int32.Parse(Request.QueryString["id"]);
- }
- }
- }
- private void NoteDataBind()
- {
- string txt;
- string cdate;
- SqlCommand objcommand=new SqlCommand();
- SqlDataReader objdatareader;
- objcommand = objnote.notefill(id);
- objcommand.Connection.Open();
- objdatareader = objcommand.ExecuteReader();
- objdatareader.Read();
- txt = objdatareader.GetValue(0).ToString();
- cdate = objdatareader.GetValue(1).ToString();
- objdatareader.Close();
- objcommand.Connection.Close();
- txtContent.Text = txt;
- lblCDate.Visible = true;
- lblCDateV.Text = cdate;
- }
- #region Web Form Designer generated code
- override protected void OnInit(EventArgs e)
- {
- //
- // CODEGEN:该调用是 ASP.NET Web 窗体设计器所必需的。
- //
- InitializeComponent();
- base.OnInit(e);
- }
- /// <summary>
- /// 设计器支持所需的方法 - 不要使用代码编辑器修改
- /// 此方法的内容。
- /// </summary>
- private void InitializeComponent()
- {
- this.cmdSaveExi.Click += new System.Web.UI.ImageClickEventHandler(this.cmdSaveExi_Click);
- this.cmdDel.Click += new System.Web.UI.ImageClickEventHandler(this.cmdDel_Click);
- this.cmdExit.Click += new System.Web.UI.ImageClickEventHandler(this.cmdExit_Click);
- this.Load += new System.EventHandler(this.Page_Load);
- }
- #endregion
- private void cmdSaveExi_Click(object sender, System.Web.UI.ImageClickEventArgs e)
- {
- string content = txtContent.Text;
- DateTime cdate = new DateTime();
- cdate = DateTime.Now;
- objnote.noteaddup(id,Convert.ToInt16(this.Empid),content,cdate);
- Response.Redirect("Note.aspx");
- }
- private void cmdDel_Click(object sender, System.Web.UI.ImageClickEventArgs e)
- {
- objnote.notedelete(id);
- Response.Redirect("Note.aspx");
- }
- private void cmdExit_Click(object sender, System.Web.UI.ImageClickEventArgs e)
- {
- Response.Redirect("Note.aspx");
- }
- }
- }