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("exec proc_SearchAllNewsInfoListCount "));
Repeater1.DataSource = ADOHelp.QueryDataTable("exec proc_SearchAllNewsInfoList " + AspNetPager1.PageSize + "," + AspNetPager1.CurrentPageIndex + " ");
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();
}
/// <summary>
/// 临时方法
/// </summary>
/// <param name="CenterframeworkName"></param>
/// <param name="CenterframeworkContent"></param>
/// <returns></returns>
public static bool InsertCenterframeworkData(string CenterframeworkName, string CenterframeworkContent)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_InsertCenterframeworkData '" + CenterframeworkName + "' ,'" + CenterframeworkContent + "' ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加、修改或删除实验室类型
/// </summary>
/// <param name="LabTypeID"></param>
/// <param name="LabTypeName"></param>
/// <param name="Command"></param>
/// <returns></returns>
public static bool BackOpearLabType(int LabTypeID, string LabTypeName, string Command)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_BackOpearLabType " + LabTypeID + ",'" + LabTypeName + "' ,'" + Command + "' ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 管理员回复留言
/// </summary>
/// <param name="LeaveMessageID"></param>
/// <param name="ReplyContent"></param>
/// <returns></returns>
public static bool UpdateLeaveMessage(int LeaveMessageID, string ReplyContent)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_UpdateLeaveMessage " + LeaveMessageID + " ,'" + ReplyContent + "'") > 0)
{
return(true);
}
else
{
return(false);
}
}
public static bool InsertDrviceMaintenance(string DrviceMaintenanceTitle, string DrviceMaintenancePath)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_InsertDrviceMaintenance '" + DrviceMaintenanceTitle + "','" + DrviceMaintenancePath + "'") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 新增或修改制度或安全
/// </summary>
/// <param name="CreORUpd"></param>
/// <param name="command"></param>
/// <param name="MyID"></param>
/// <param name="Title"></param>
/// <param name="Content"></param>
/// <returns></returns>
public static bool UpdateSystemAndSafety(string CreORUpd, string command, int MyID, string Title, string Content)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_UpdateSystemAndSafety '" + CreORUpd + "','" + command + "'," + MyID + ",'" + Title + "','" + Content + "' ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 给管理员留言
/// </summary>
/// <param name="LeaveManName"></param>
/// <param name="IsTeacher"></param>
/// <param name="LeaveMessageContent"></param>
/// <returns></returns>
public static bool InsertLeaveMessage(string LeaveManName, int IsTeacher, string LeaveMessageContent)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_InsertLeaveMessage '" + LeaveManName + "' ," + IsTeacher + " ,'" + LeaveMessageContent + "' ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 后台 新增新闻公告
/// </summary>
/// <param name="NewsTitle"></param>
/// <param name="NewsContent"></param>
/// <param name="Admin"></param>
/// <returns></returns>
public static bool InsertNoticeNews(string NewsTitle, string NewsContent, int Admin)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_InsertNoticeNews '" + NewsTitle + "','" + NewsContent + "' ," + Admin + " ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 实验室预约
/// </summary>
/// <param name="LabID"></param>
/// <param name="TeacherID"></param>
/// <param name="TeacherLeaveMessage"></param>
/// <param name="AppointmentDate"></param>
/// <param name="DataSection"></param>
/// <returns></returns>
public static bool InsertLabAppointment(int LabID, int TeacherID, string TeacherLeaveMessage, string AppointmentDate, string DataSection)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_InsertLabAppointment " + LabID + " ," + TeacherID + " ,'" + TeacherLeaveMessage + "','" + AppointmentDate + "','" + DataSection + "' ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 上传资源文件
/// </summary>
/// <param name="FileTitle"></param>
/// <param name="FileTypeName"></param>
/// <param name="FileName"></param>
/// <returns></returns>
public static bool InsertResourceFile(string FileTitle, string FileTypeName, string FileName)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_InsertResourceFile '" + FileTitle + "','" + FileTypeName + "','" + FileName + "' ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新公共信息
/// </summary>
/// <param name="command"></param>
/// <param name="Content"></param>
/// <returns></returns>
public static bool UpdatePublicInfo(string command, string Content)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_UpdatePublicInfo '" + command + "','" + Content + "' ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 后台 删除新闻公告
/// </summary>
/// <param name="NewsID"></param>
/// <returns></returns>
public static bool DeleteNoticeNewsInfo(int NewsID)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_DeleteNoticeNewsInfo " + NewsID + " ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除制度或安全
/// </summary>
/// <param name="command"></param>
/// <param name="MyID"></param>
/// <returns></returns>
public static bool DeleteSystemAndSafety(string command, int MyID)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_DeleteSystemAndSafety '" + command + "'," + MyID + " ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 后台 修改新闻公告
/// </summary>
/// <param name="NewsID"></param>
/// <param name="NewsTitle"></param>
/// <param name="NewsContent"></param>
/// <returns></returns>
public static bool UpdateNewsInfo(int NewsID, string NewsTitle, string NewsContent)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_UpdateNewsInfo " + NewsID + ",'" + NewsTitle + "','" + NewsContent + "' ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
///
/// </summary>
/// <param name="DrviceMaintenanceID"></param>
/// <returns></returns>
public static bool DeleteDrviceMaintenance(int DrviceMaintenanceID)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_DeleteDrviceMaintenance " + DrviceMaintenanceID + " ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 管理员审批预约
/// </summary>
/// <param name="AppointmentID"></param>
/// <param name="AdminAllow"></param>
/// <param name="AdminReason"></param>
/// <returns></returns>
public static bool AccraditationAppointment(int AppointmentID, int AdminAllow, string AdminReason)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_AccraditationAppointment " + AppointmentID + "," + AdminAllow + ",'" + AdminReason + "' ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 后台删除留言
/// </summary>
/// <param name="LeaveMessageID"></param>
/// <returns></returns>
public static bool DeleteLeaveMessage(int LeaveMessageID)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_DeleteLeaveMessage " + LeaveMessageID + " ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 管理员删除预约
/// </summary>
/// <param name="AppointmentID"></param>
/// <returns></returns>
public static bool DeleteLabAppointment(int AppointmentID)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_DeleteLabAppointment " + AppointmentID + " ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 后台新增修改和删除实验室
/// </summary>
/// <param name="CUD"></param>
/// <param name="LabID"></param>
/// <param name="LabName"></param>
/// <param name="LabTypeID"></param>
/// <param name="MaxNO"></param>
/// <returns></returns>
public static bool BackCUDLabInfo(string CUD, int LabID, string LabName, int LabTypeID, int MaxNO)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_BackCUDLabInfo '" + CUD + "'," + LabID + " ,'" + LabName + "' ," + LabTypeID + " ," + MaxNO + " ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// /新建或修改教师
/// </summary>
/// <param name="TeacherID"></param>
/// <param name="TeacherName"></param>
/// <param name="TeacherPwd"></param>
/// <param name="CreateORUpdate"></param>
/// <returns></returns>
public static bool InsertOrUpdateTeacher(int TeacherID, string TeacherName, string TeacherPwd, string CreateORUpdate)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_InsertOrUpdateTeacher " + TeacherID + ",'" + TeacherName + "','" + TeacherPwd + "','" + CreateORUpdate + "' ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 注册时验证教师名称是否存在
/// </summary>
/// <param name="UserName"></param>
/// <returns></returns>
public static bool ValidateTeacherNameExist(string UserName)
{
if (ADOHelp.GetSingle("exec ValidateTeacherNameExist " + UserName + "").ToString() != "0")
{
return(true);//存在
}
else
{
return(false);//不存在
}
}
/// <summary>
/// 管理员删除教师
/// </summary>
/// <param name="AppointmentID"></param>
/// <returns></returns>
public static bool DeleteTeacherInfo(int TeacherID)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_DeleteTeacherInfo " + TeacherID + " ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 新增实验室制度
/// </summary>
/// <param name="LabManageSystemTitle"></param>
/// <param name="LabManageSystemContent"></param>
/// <returns></returns>
public static bool InsertLabManageSystemTitle(string LabManageSystemTitle, string LabManageSystemContent)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_InsertLabManageSystemTitle '" + LabManageSystemTitle + "' ,'" + LabManageSystemContent + "' ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除资源文件
/// </summary>
/// <param name="FileID"></param>
/// <returns></returns>
public static bool DeleteResourceFile(int FileID)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_DeleteResourceFile " + FileID + " ") > 0)
{
return(true);
}
else
{
return(false);
}
}