Meeting/Meeting.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace WebApplication
{
    public partial class Meeting : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!this.IsPostBack)
            {
                if (Request["d"] != null && Request["roomid"] != null) 
                {
                    ydrq.InnerHtml = Request["d"].ToString();
                    SqlParameter[] param = new SqlParameter[]{
                        new SqlParameter("@infoid",SqlDbType.VarChar)
                    };
                    param[0].Value = Request["roomid"].ToString();
                    meetingroom.InnerHtml = new BLL.Models.GZXX_Model().GetModelTitle("GZXX_U_MeetingRoom", param);
                    bind();
                    DateTime dtime = DateTime.Parse(DateTime.Parse(DBUtility.DbHelperSQL.GetSingle("select getdate()").ToString()).ToString("yyyy-MM-dd"));
                    DateTime dp = DateTime.Parse(Request["d"].ToString());
                    if (dtime <= dp) { HiddenField1.Value = "true"; }
                    else { HiddenField1.Value = "false"; }
                }
            }
        }
        void bind()
        {
            SqlParameter[] param = new SqlParameter[] {
                    new SqlParameter("@d",SqlDbType.VarChar),
                    new SqlParameter("@roomid",SqlDbType.VarChar)
                };
            param[0].Value = Request["d"].ToString();
            param[1].Value = Request["roomid"].ToString();
            Repeater1.DataSource = DBUtility.DbHelperSQL.Query("select *,(select Title from GZXX_U_UserTable where GZXX_U_UserTable.InfoID = GZXX_U_Order.UserInfoID) as UserName from GZXX_U_Order where verify = 1 and MeetingInfoID = @roomid and CONVERT(varchar(10), StartDate, 23) = @d order by  CONVERT(datetime,StartDate, 120) ", param).Tables[0];
            Repeater1.DataBind();
        }
    }
}