DAL/Class1.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using Moodels;

namespace DAL
{
    public class Class1
    {
        public static DataTable Xcxdl(string XID,string Xpsw,string XName)
        {
            string sql = string.Format("SELECT * FROM Student_Table where XID={0} and Xpsw={1} and XName='{2}'", XID, Xpsw, XName);
            return DBHelper.Select(sql);
        }
        public static bool tjxs(user u)
        {
            string sql = string.Format("INSERT INTO Student_Table(XID,XName,Xpsw)VALUES('{0}','{1}','{2}')",u.XID, u.XName, u.Xpsw);
            return DBHelper.Zsg(sql);
        }
        public static DataTable kxzx(int XID)
        {
            string sql = string.Format("SELECT Ystudent1,Ystudent2,Ystudent3,Ystudent4,Ystudent5 FROM Student_Table where XID={0}", XID);
            return DBHelper.Select(sql);
        }
        public static DataTable Tcxdl(string TID, string Tpws, string TName)
        {
            string sql = string.Format("SELECT * FROM Teacher_Table where TID={0} and Tpws={1} and TName='{2}'", TID, Tpws,TName);
            return DBHelper.Select(sql);
        }
        public static DataTable SelectID(int XID)
        {
            string sql = string.Format("SELECT * FROM Student_Table where XID={0}", XID);
            return DBHelper.Select(sql);
        }
        public static bool yyyyy(user u)
        {
            string sql = string.Format("UPDATE Student_Table  SET Ystudent1 ='{0}', Ystudent2 ='{1}',Ystudent3 ='{2}',Ystudent4 = '{3}',Ystudent5 = '{4}' WHERE XID={5}",u.Ystudent1, u.Ystudent2,u.Ystudent3, u.Ystudent4, u.Ystudent5, u.XID);
            return DBHelper.Zsg(sql);
        }
        public static DataTable cxqpp()
        {
            string sql = string.Format("SELECT * FROM Student_Table");
            return DBHelper.Select(sql);
        }
        public static bool ggxx(user u)
        {
            string sql = string.Format("UPDATE Student_Table  SET XName ='{0}', XSxe ='{1}',XAge ='{2}',XSpecialty = '{3}',XFaculty = '{4}' WHERE XID={5}", u.XName, u.XSxe, u.XAge, u.XSpecialty, u.XFaculty, u.XID);
            return DBHelper.Zsg(sql);
        }
        public static DataTable cxmzmh(string XName)
        {
            string sql = string.Format("SELECT * FROM Student_Table WHERE XName LIKE '%{0}%'", XName);
            return DBHelper.Select(sql);
        }
        public static bool DeleteByName(int ID)
        {
            string sql = string.Format("DELETE FROM  Student_Table WHERE XID={0}", ID);