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();
}
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();
}
}
}
private void BindData()
{
if (Request.Cookies["CookieUserID"] != null)
{
Repeater1.DataSource = ADOHelp.QueryDataTable("exec proc_SearchMyAppointment " + Convert.ToInt32(Request.Cookies["CookieUserID"].Value) + "");
Repeater1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Repeater1.DataSource = ADOHelp.QueryDataTable("proc_BackSearchDrviceMaintenanceList");
Repeater1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Repeater1.DataSource = ADOHelp.QueryDataTable("exec proc_SearchNewsInfoList");
Repeater1.DataBind();
}
}
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();
}
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();
}
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 { }
}
//绑定实验室类型
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();
}
}
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;
}
}
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();
}
}
}
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();
}
}
}
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 { }
}
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");
}
}
}
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();
}
}
private void BindData()
{
AspNetPager1.RecordCount = Convert.ToInt32(ADOHelp.GetSingle("proc_BackSearchResourceFileCount "));
Repeater1.DataSource = ADOHelp.QueryDataTable("exec proc_BackSearchResourceFile " + AspNetPager1.PageSize + "," + AspNetPager1.CurrentPageIndex + "");
Repeater1.DataBind();
}
/// <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 + ""));
}
/// <summary>
/// 提起公共数据
/// </summary>
/// <param name="command"></param>
/// <returns></returns>
public static DataTable SearchPublicInfo(string command)
{
return(ADOHelp.QueryDataTable("exec proc_SearchPublicInfo '" + command + "'"));
}
/// <summary>
/// 提取公告新闻
/// </summary>
/// <param name="NewsID"></param>
/// <returns></returns>
public static DataTable SearchNewsInfo_ToNewsID(int NewsID)
{
return(ADOHelp.QueryDataTable("exec proc_SearchNewsInfo_ToNewsID " + NewsID + ""));
}
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();
}
protected void Page_Load(object sender, EventArgs e)
{
Repeater1.DataSource = ADOHelp.QueryDataTable("SELECT LabManageSystemID,LabManageSystemTitle FROM LabManageSystem");
Repeater1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Repeater1.DataSource = ADOHelp.QueryDataTable("SELECT LabSafetyID,LabSafetyTitle FROM LabSafetyInfo");
Repeater1.DataBind();
}
private void BindData(int LabTypeID, int MaxNO)
{
Repeater1.DataSource = ADOHelp.QueryDataTable("exec proc_SearchLabInfo " + LabTypeID + "," + MaxNO + "");
Repeater1.DataBind();
}
private void BindData()
{
Repeater1.DataSource = ADOHelp.QueryDataTable("SELECT LabTypeID,LabTypeName FROM LabInfo_LabType ");
Repeater1.DataBind();
}