1using System;
  2using System.Collections;
  3using System.ComponentModel;
  4using System.Data;
  5using System.Drawing;
  6using System.Web;
  7using System.Web.SessionState;
  8using System.Web.UI;
  9using System.Web.UI.WebControls;
 10using System.Data.SqlClient;
 11namespace CRMS
 12...{
 13    /**//// <summary>
 14    /// LogList 的摘要说明。
 15    /// </summary>
 16    public partial class LogList : System.Web.UI.Page
 17    ...{
 18
 19        protected System.Web.UI.WebControls.Label Label1;
 20        protected System.Web.UI.WebControls.Label Label2;
 21        data hsjdata=new data();
 22        protected System.Web.UI.WebControls.Label Label3;
 23        protected System.Web.UI.WebControls.Label Label4;
 24        string sql="";
 25        //protected System.Web.UI.WebControls.Calendar SelectTime;
 26        string SQL;
 27
 28        /**//*
 29        public String FormatReplyText(String sReplyText)
 30        {
 31            
 32            return(sReplyText.Replace("\n","<br>"));    
 33        }
 34        */
 35        protected void Page_Load(object sender, System.EventArgs e)
 36        ...{
 37            // 在此处放置用户代码以初始化页面
 38            
 39            if (Session["managerin"]!=null)
 40            ...{
 41            
 42                if(Session["MemberState"].ToString()=="关闭")
 43                ...{
 44                    Response.Redirect("ErrorPage.aspx?ErrMms=对不起，您的帐号已经被停止使用！");
 45                }
 46                if(Session["MemberAuthority"].ToString()!="系统管理员")
 47                ...{
 48                    Response.Redirect("ErrorPage.aspx?ErrMms=对不起，您无权管理该项！");
 49                }
 50            
 51                if(!Page.IsPostBack)
 52                ...{
 53                    
 54                    //读取日志内容
 55                    int MyLogID=Convert.ToInt16(Request.QueryString["MyLogID"]);
 56                    string action=Request.QueryString["action"];
 57                    if (MyLogID!=0)
 58                    ...{
 59                         
 60                        SQL="SELECT Title,Content,AddTime,RealName FROM VIEW_Log WHERE MyLogID="+MyLogID+" order by MyLogId desc";
 61                    }
 62                    else
 63                    ...{
 64                        SQL="SELECT Title,Content,AddTime,RealName FROM VIEW_Log order by MyLogID desc";    
 65
 66                    }
 67                    try
 68                    ...{
 69                        SqlDataReader dr=hsjdata.readrow(SQL);
 70                        L2.Text=dr.GetValue(0).ToString();
 71                        L3.Text=dr.GetValue(2).ToString();
 72                        L4.Text=dr.GetValue(1).ToString();
 73                        L5.Text=dr.GetValue(3).ToString();
 74                    }
 75                    catch
 76                    ...{
 77                        Response.Redirect("ErrorPage.aspx?ErrMms=出现错误，请查证！");
 78                    }
 79                    //删除日志
 80                    
 81                    if (action=="DEL")
 82                    ...{
 83                        string sqlDel="Delete MyLog WHERE MyLogID="+MyLogID+"";
 84                        try
 85                        ...{
 86                            hsjdata.moddata(sqlDel);
 87                            Response.Write("<script>alert('日志删除成功！');window.location.href='Javascript:history.go(-1)'</script>");
 88                            return;
 89                        }
 90                        catch 
 91                        ...{
 92                            Response.Redirect("ErrorPage.aspx?ErrMms=客户资料删除时发生错误！");
 93                        }
 94                    }
 95
 96                    bind();
 97
 98                    
 99                }
100            }
101            else
102            ...{
103                Response.Redirect("login.aspx");
104            }
105        }
106
107        public void binddata(string sql)
108        ...{
109            //string time1=SelectTime.SelectedDate.ToShortDateString();
110            //DateTime MyDateTime=DateTime.Parse(time1);
111            //Response.Write(MyDateTime);
112            //Response.End();
113            //if (MyDateTime=)
114            //{
115            //    sql="SELECT *,datediff(day,MyDateTime,addtime) as DayCount FROM VIEW_Log order by MyLogId desc";
116            //}
117            //else
118            //{
119                sql="SELECT * FROM VIEW_Log order by MyLogId desc";
120            //}
121            //Response.Write (sql);
122            //Response.End();
123            DataSet ds=hsjdata.dbbind(sql);
124            dg1.DataSource=ds.Tables["mytable"].DefaultView;
125            dg1.DataBind();            
126        }
127    
128        public void bind()
129        ...{
130            binddata(sql);
131        }
132
133        Web 窗体设计器生成的代码#region Web 窗体设计器生成的代码
134        override protected void OnInit(EventArgs e)
135        ...{
136            //
137            // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
138            //
139            InitializeComponent();
140            base.OnInit(e);
141        }
142        
143        /**//// <summary>
144        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
145        /// 此方法的内容。
146        /// </summary>
147        private void InitializeComponent()
148        ...{    
149            this.dg1.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.dg1_PageIndexChanged);
150
151        }
152        #endregion
153        private void dg1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
154        ...{
155            try
156            ...{
157                this.dg1.CurrentPageIndex = e.NewPageIndex;
158            }
159            catch
160            ...{
161                this.dg1.CurrentPageIndex = 0;
162            }
163            bind();
164        }
165    }
166}
167