Exemplo n.º 1
0
        //插入
        public bool InsertClassInfo(ClassInfoData data)
        {
            string sql = "insert into classinfo(classid,specialtyid,"
                         + "studentnumber,remark) values('"
                         + data.Classid + "','" + data.Specialtyid + "','" + data.Studentnumber + "','"
                         + data.Remark + "')";
            DataAccess da = new DataAccess();

            return(da.ExecuteSQL(sql));
        }
Exemplo n.º 2
0
        //修改
        public bool UpdateClass(ClassInfoData data)
        {
            string sql = "update classinfo set classid='"
                         + data.Classid + "',Specialtyid='" + data.Specialtyid
                         + "',studentnumber='" + data.Studentnumber
                         + "',remark='" + data.Remark + "'"
                         + " where Classid='" + data.Classid + "'";
            DataAccess da = new DataAccess();

            return(da.ExecuteSQL(sql));
        }
Exemplo n.º 3
0
        //查询
        public System.Data.DataSet GetClassInfo(ClassInfoData data)
        {
            string sql = "select * from classinfo where 1=1";
            string s   = "";

            if (data.Classid != "" && data.Classid != null)
            {
                s += " and classid ='" + data.Classid + "'";
            }
            if (data.Specialtyid != "" && data.Specialtyid != null)
            {
                s += " and specialtyid='" + data.Specialtyid + "'";
            }
            sql += s;
            DataAccess da = new DataAccess();

            return(da.GetDataSet(sql, "classinfo"));
        }