App_Code/component/lybb.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections ;

namespace Hr.component
{
	public class lybb:DatabaseOperation
	{
        public lybb()
		{
			//空的构造函数
		}
        public  DataSet GetLyb()
        {
            strSQL = "SELECT * FROM lyb";
            try
            {
                return ExecuteReturnDS(strSQL);
            }
            catch
            {
                throw new Exception("获取所有留言信息失败!");
            }
        }

        public void AddLyb(string title, string nr, string Lyr)
        {

            strSQL = "Insert into lyb (title,nr,Lyr) Values("
                + "'" + title + "',"

                + "'" + nr + "','" + Lyr + "')";

            try
            {
                ExecuteNonQuery(strSQL);
            }
            catch
            {
                throw new Exception("留言失败！");
            }


        }
        public  void Delete(int id)
        {
            strSQL = "Delete From lyb Where id=" + id;

            try
            {
                ExecuteNonQuery(strSQL);
            }
            catch
            {
                throw new Exception("删除失败！");
            }
        }
		public static DataSet GetPersonApplyInfo()
		{