Exemplo n.º 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();
        }
Exemplo n.º 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();
                }
            }
        }
Exemplo n.º 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();
     }
 }
Exemplo n.º 4
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         Repeater1.DataSource = ADOHelp.QueryDataTable("proc_BackSearchDrviceMaintenanceList");
         Repeater1.DataBind();
     }
 }
Exemplo n.º 5
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         Repeater1.DataSource = ADOHelp.QueryDataTable("exec proc_SearchNewsInfoList");
         Repeater1.DataBind();
     }
 }
Exemplo n.º 6
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();
        }
Exemplo n.º 7
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();
        }
Exemplo n.º 8
0
 /// <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);
     }
 }
Exemplo n.º 9
0
 /// <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);
     }
 }
Exemplo n.º 10
0
 /// <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);
     }
 }
Exemplo n.º 11
0
 public static bool InsertDrviceMaintenance(string DrviceMaintenanceTitle, string DrviceMaintenancePath)
 {
     if (ADOHelp.ExecuteSql_ReturnRow("exec proc_InsertDrviceMaintenance '" + DrviceMaintenanceTitle + "','" + DrviceMaintenancePath + "'") > 0)
     {
         return(true);
     }
     else
     {
         return(false);
     }
 }
Exemplo n.º 12
0
 /// <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);
     }
 }
Exemplo n.º 13
0
 /// <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);
     }
 }
Exemplo n.º 14
0
 /// <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);
     }
 }
Exemplo n.º 15
0
 /// <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);
     }
 }
Exemplo n.º 16
0
 /// <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);
     }
 }
Exemplo n.º 17
0
 /// <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);
     }
 }
Exemplo n.º 18
0
 /// <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);
     }
 }
Exemplo n.º 19
0
 /// <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);
     }
 }
Exemplo n.º 20
0
 /// <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);
     }
 }
Exemplo n.º 21
0
 /// <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);
     }
 }
Exemplo n.º 22
0
 /// <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);
     }
 }
Exemplo n.º 23
0
 /// <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);
     }
 }
Exemplo n.º 24
0
 /// <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);
     }
 }
Exemplo n.º 25
0
 /// <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);
     }
 }
Exemplo n.º 26
0
 /// <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);
     }
 }
Exemplo n.º 27
0
 /// <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);//不存在
     }
 }
Exemplo n.º 28
0
 /// <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);
     }
 }
Exemplo n.º 29
0
 /// <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);
     }
 }
Exemplo n.º 30
0
 /// <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);
     }
 }