studentinfo.cs

水晶报表详细资料水晶报表详细资料水晶报表详细资料

namespace Stu.Student
{
    using System;
    using System.Data;
    using System.Configuration;
    using System.Web;
    using System.Web.Security;
    using System.Web.UI;
    using System.Web.UI.WebControls;
    using System.Web.UI.WebControls.WebParts;
    using System.Web.UI.HtmlControls;
    using System.ComponentModel;
    using System.Data.SqlClient;
    using System.Security.Permissions;

    [AspNetHostingPermission(SecurityAction.Demand,
  Level = AspNetHostingPermissionLevel.Minimal)]
    [AspNetHostingPermission(SecurityAction.InheritanceDemand,
      Level = AspNetHostingPermissionLevel.Minimal)]

    // 创建IStuInfo接口，其中定义属性stuId 
    public interface IStuInfo
    {
        int stuId { get; set;}
    }

    public class StudentInfo : WebPart, IStuInfo
    {
        // 定义构造函数
        public StudentInfo()
        {
            this.Title = "通信提供者";
        }
        //    // 定义私有成员
        private int _stuID = 1;
        private TextBox txtid = new TextBox();
        private Button btnOk;
        private Label lelinfo;

        private SqlDataSource stusql;//提供数据源
        private DetailsView dvInfo;//用于显示信息
        // 实现IStuInfo接口成员stuId 
        [Personalizable(true), WebBrowsable(true)]
        public int stuId
        {
            get { return _stuID; }
            set { _stuID = value; }
        }
        // 定义ProvideEmployeeInfo方法，传送连接数据
        [ConnectionProvider("StudentIDProvider", "StudentIDProvider")]
        public IStuInfo StudentIDProvider()
        {
            return this;
        }
        // 重写OnLoad方法，向主控件中添加部分子控件
        protected override void OnLoad(EventArgs e)
        {

            txtid.Width = Unit.Pixel(30);
            txtid.Text = stuId.ToString();
            Controls.Add(txtid);
            btnOk = new Button();
            btnOk.Text = "搜索";
            btnOk.Click += new EventHandler(OnFindStudent);
            Controls.Add(btnOk);
            lelinfo = new Label();
            lelinfo.Text = "学生编号1-16";
            Controls.Add(lelinfo);
        }
        // 呈现控件用户界面
        protected override void RenderContents(HtmlTextWriter writer)
        {
            if (_stuID < 1)
            {
                writer.Write("<span style='color:gray'>请在文本框中输入大于等于1的值.</span>");
                return;
            }
            else
            {
                writer.Write("输入学生编号： ");
                txtid.RenderControl(writer);
                btnOk.RenderControl(writer);
                writer.Write("<hr size=1>");
                stusql = new SqlDataSource();
                stusql.ID = "SqlDataSource1";
                stusql.ConnectionString = "Data Source=a\\mr;Initial Catalog=aspnetdb;Integrated Security=True";
                stusql.SelectCommand = "select stuName as 学生姓名 ,stuSex as 学生性别 ,stuAge as  学生年龄 ,stuclass as 学生班级 ,stuAddress as 家庭住址 ,stutel as 联系电话 from tb_02 where 学生编号=" + _stuID.ToString();
                Controls.Add(stusql);//执行数据源
                dvInfo = new DetailsView();
                dvInfo.DataSourceID = "SqlDataSource1";
                dvInfo.GridLines = GridLines.None;
                dvInfo.CellPadding = 3;
                dvInfo.FieldHeaderStyle.Font.Bold = true;
                Controls.Add(dvInfo);
                dvInfo.RenderControl(writer);
            }
        }
        // 实现按钮的事件处理程序
        private void OnFindStudent(Object sender, EventArgs e)
        {
            if (txtid.Text != "")
            {
                _stuID = Convert.ToInt32(txtid.Text);
            }
            else
            {
                return;
            }
        }
    }
}