Exemple #1
0
        private void SetRepeaterDataSource()
        {
            AspNetPager1.RecordCount = Convert.ToInt32(ADOHelp.GetSingle("exec proc_BackSearchProjectInfoCount '" + State + "','" + SetUpUser + "'"));

            Repeater1.DataSource = ADOHelp.QueryDataTable("exec proc_BackSearchProjectInfo " + AspNetPager1.PageSize + "," + AspNetPager1.CurrentPageIndex + ",'" + State + "','" + SetUpUser + "'");
            Repeater1.DataBind();
        }
Exemple #2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            int AppointmentID = 0;

            try
            {
                AppointmentID = Convert.ToInt32(Request.QueryString["AppointmentID"]);
            }
            catch { }
            if (!IsPostBack)
            {
                //提取改预约的详细信息
                DataTable dt = ADOHelp.QueryDataTable("exec proc_SearchLabAppointment_ToAppointmentID " + AppointmentID + "");
                if (dt.Rows.Count > 0)
                {
                    Label1.Text = dt.Rows[0]["TeacherName"].ToString();
                    Label2.Text = dt.Rows[0]["AppointmentDate"].ToString();
                    Label3.Text = dt.Rows[0]["LabName"].ToString();
                    Label4.Text = dt.Rows[0]["LabTypeName"].ToString();
                    Label5.Text = dt.Rows[0]["TeacherLeaveMessage"].ToString();
                    Label6.Text = dt.Rows[0]["AdminAllow"].ToString();
                    Label7.Text = dt.Rows[0]["AdminReason"].ToString();
                }
            }
        }
Exemple #3
0
 private void BindData()
 {
     if (Request.Cookies["CookieUserID"] != null)
     {
         Repeater1.DataSource = ADOHelp.QueryDataTable("exec proc_SearchMyAppointment " + Convert.ToInt32(Request.Cookies["CookieUserID"].Value) + "");
         Repeater1.DataBind();
     }
 }
Exemple #4
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         Repeater1.DataSource = ADOHelp.QueryDataTable("proc_BackSearchDrviceMaintenanceList");
         Repeater1.DataBind();
     }
 }
Exemple #5
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         Repeater1.DataSource = ADOHelp.QueryDataTable("exec proc_SearchNewsInfoList");
         Repeater1.DataBind();
     }
 }
Exemple #6
0
        private void BindData()
        {
            //

            AspNetPager1.RecordCount = Convert.ToInt32(ADOHelp.GetSingle("select count(DCID) from DemonstrationCenter"));

            Repeater1.DataSource = ADOHelp.QueryDataTable("exec proc_SearchAllDCList " + AspNetPager1.PageSize + "," + AspNetPager1.CurrentPageIndex + " ");
            Repeater1.DataBind();
        }
Exemple #7
0
        private void BindData()
        {
            //

            AspNetPager1.RecordCount = Convert.ToInt32(ADOHelp.GetSingle("exec proc_SearchAllNewsInfoListCount "));

            Repeater1.DataSource = ADOHelp.QueryDataTable("exec proc_SearchAllNewsInfoList " + AspNetPager1.PageSize + "," + AspNetPager1.CurrentPageIndex + " ");
            Repeater1.DataBind();
        }
Exemple #8
0
 protected void Page_Load(object sender, EventArgs e)
 {
     try
     {
         LabManageSystemID = Convert.ToInt32(Request.QueryString["LabManageSystemID"]);
         DataTable dt = ADOHelp.QueryDataTable("exec proc_SearchLabManageSystem " + LabManageSystemID + "");
         Label1.Text = dt.Rows[0]["LabManageSystemTitle"].ToString();
         Label2.Text = dt.Rows[0]["LabManageSystemContent"].ToString();
     }
     catch { }
 }
Exemple #9
0
        //绑定实验室类型
        private void BindLabType()
        {
            DataTable dt_type = ADOHelp.QueryDataTable("SELECT LabTypeID,LabTypeName FROM LabInfo_LabType");

            foreach (DataRow dr in dt_type.Rows)
            {
                DropDownList1.DataSource     = dt_type;
                DropDownList1.DataTextField  = "LabTypeName";
                DropDownList1.DataValueField = "LabTypeID";
                DropDownList1.DataBind();
            }
        }
Exemple #10
0
 protected void Page_Load(object sender, EventArgs e)
 {
     try
     {
         TypeName = Request.QueryString["TypeName"].Trim();
     }
     catch { }
     if (!IsPostBack)
     {
         Repeater1.DataSource = ADOHelp.QueryDataTable("exec proc_SearchResourceFile '" + TypeName + "'");
         Repeater1.DataBind();
         Select1.Value = TypeName;
     }
 }
Exemple #11
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         int       NewsID = Convert.ToInt32(Request.QueryString["NewsID"]);
         DataTable dt     = ADOHelp.QueryDataTable("exec proc_SearchNewsInfo_ToNewsID " + NewsID + "");
         if (dt.Rows.Count > 0)
         {
             Label1.Text = dt.Rows[0]["NewsTitle"].ToString();
             Label2.Text = dt.Rows[0]["PublicTime"].ToString();
             Label3.Text = dt.Rows[0]["NewsContent"].ToString();
         }
     }
 }
Exemple #12
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         int       DCID = Convert.ToInt32(Request.QueryString["DCID"]);
         DataTable dt   = ADOHelp.QueryDataTable("select Top 1 * from DemonstrationCenter where DCID=" + DCID);
         if (dt.Rows.Count > 0)
         {
             Label1.Text = dt.Rows[0]["DCTitle"].ToString();
             Label2.Text = dt.Rows[0]["PublicTime"].ToString();
             Label3.Text = dt.Rows[0]["DCContent"].ToString();
         }
     }
 }
Exemple #13
0
 protected void Page_Load(object sender, EventArgs e)
 {
     try
     {
         if (Request.QueryString["CenterframeworkID"] == null)
         {
             CenterframeworkID = 1;
         }
         CenterframeworkID = Convert.ToInt32(Request.QueryString["CenterframeworkID"]);
         DataTable dt = ADOHelp.QueryDataTable("exec procSearchCenterframeworkData " + CenterframeworkID + "");
         Label1.Text = dt.Rows[0]["CenterframeworkName"].ToString();
         Label2.Text = dt.Rows[0]["CenterframeworkContent"].ToString();
     }
     catch { }
 }
Exemple #14
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         try
         {
             string Commmand = Request.QueryString["Command"].Trim();
             Repeater1.DataSource = ADOHelp.QueryDataTable("exec proc_BackSearchSystemAndSafety  '" + Commmand + "'");
             Repeater1.DataBind();
         }
         catch
         {
             Server.Transfer("404error.htm");
         }
     }
 }
Exemple #15
0
        protected void Page_Load(object sender, EventArgs e)
        {
            //存储过程  proc_LabLabAppointmentInfo
            int LabID = 0;

            try
            {
                LabID       = Convert.ToInt32(Request.QueryString["LabID"]);
                Label1.Text = Request.QueryString["LabName"];
            }
            catch { }
            if (!IsPostBack)
            {
                Repeater1.DataSource = ADOHelp.QueryDataTable("exec proc_LabLabAppointmentInfo " + LabID + "");
                Repeater1.DataBind();
            }
        }
Exemple #16
0
 private void BindData()
 {
     AspNetPager1.RecordCount = Convert.ToInt32(ADOHelp.GetSingle("proc_BackSearchResourceFileCount  "));
     Repeater1.DataSource     = ADOHelp.QueryDataTable("exec proc_BackSearchResourceFile " + AspNetPager1.PageSize + "," + AspNetPager1.CurrentPageIndex + "");
     Repeater1.DataBind();
 }
Exemple #17
0
 /// <summary>
 /// 提取制度或安全的内容
 /// </summary>
 /// <param name="command"></param>
 /// <param name="myid"></param>
 /// <returns></returns>
 public static DataTable SearchSystemAndSafetyContent(string command, int myid)
 {
     return(ADOHelp.QueryDataTable("exec proc_SearchSystemAndSafetyContent '" + command + "'," + myid + ""));
 }
Exemple #18
0
 /// <summary>
 /// 提起公共数据
 /// </summary>
 /// <param name="command"></param>
 /// <returns></returns>
 public static DataTable SearchPublicInfo(string command)
 {
     return(ADOHelp.QueryDataTable("exec proc_SearchPublicInfo '" + command + "'"));
 }
Exemple #19
0
 /// <summary>
 /// 提取公告新闻
 /// </summary>
 /// <param name="NewsID"></param>
 /// <returns></returns>
 public static DataTable SearchNewsInfo_ToNewsID(int NewsID)
 {
     return(ADOHelp.QueryDataTable("exec proc_SearchNewsInfo_ToNewsID " + NewsID + ""));
 }
Exemple #20
0
 private void BindData()
 {
     AspNetPager1.RecordCount = Convert.ToInt32(ADOHelp.GetSingle("proc_BackSearchTeacherInfoCount '" + TextBox1.Text + "' "));
     Repeater1.DataSource     = ADOHelp.QueryDataTable("exec proc_BackSearchTeacherInfo " + AspNetPager1.PageSize + "," + AspNetPager1.CurrentPageIndex + ",'" + TextBox1.Text + "'");
     Repeater1.DataBind();
 }
Exemple #21
0
 protected void Page_Load(object sender, EventArgs e)
 {
     Repeater1.DataSource = ADOHelp.QueryDataTable("SELECT LabManageSystemID,LabManageSystemTitle FROM LabManageSystem");
     Repeater1.DataBind();
 }
Exemple #22
0
 protected void Page_Load(object sender, EventArgs e)
 {
     Repeater1.DataSource = ADOHelp.QueryDataTable("SELECT LabSafetyID,LabSafetyTitle FROM LabSafetyInfo");
     Repeater1.DataBind();
 }
Exemple #23
0
 private void BindData(int LabTypeID, int MaxNO)
 {
     Repeater1.DataSource = ADOHelp.QueryDataTable("exec proc_SearchLabInfo " + LabTypeID + "," + MaxNO + "");
     Repeater1.DataBind();
 }
Exemple #24
0
 private void BindData()
 {
     Repeater1.DataSource = ADOHelp.QueryDataTable("SELECT LabTypeID,LabTypeName FROM LabInfo_LabType ");
     Repeater1.DataBind();
 }