/// <summary> /// 关键词查询 /// </summary> /// <param name="key">关键词</param> /// <param name="part">是否取部分内容(加快查询和传输速度)</param> /// <param name="pos">起始位置</param> /// <param name="length">记录条数</param> /// <returns></returns> public static DataSet QueryGoodsKey(string key, bool part = false, int pos = 0, int length = 0) { try { if (part) { string sql = "select * from tb_goods where goodsName like ?key limit ?st, ?ed;"; MySqlParameter[] para = new MySqlParameter[3]; para[0] = new MySqlParameter("?key", "%" + key + "%"); para[1] = new MySqlParameter("?st", pos); para[2] = new MySqlParameter("?ed", length); DataSet ds = DAL_MysqlHelper.ExecuteDataSet(sql, para); return(ds); } else { string sql = "select * from tb_goods where goodsName like ?key;"; MySqlParameter para = new MySqlParameter("?key", "%" + key + "%"); DataSet ds = DAL_MysqlHelper.ExecuteDataSet(sql, para); return(ds); } } catch (Exception e) { throw e; } }
/// <summary> /// 添加订单 /// </summary> /// <param name="name"></param> /// <param name="goods"></param> /// <param name="gcnt"></param> /// <returns></returns> public static bool AddOrder(string name, List <Goods> goods, List <int> gcnt) { try { if (goods.Count != gcnt.Count) { return(false); } decimal totalPrice = 0.0M; for (int i = 0; i < goods.Count; i++) { totalPrice += goods.ElementAt(i).UnitPrice *gcnt.ElementAt(i); } string sql = "insert into tb_order(customerName,totalMoney,orderDate) values(?name,?money,now());"; MySqlParameter[] para = { new MySqlParameter("?name", name), new MySqlParameter("?money", totalPrice) }; int ret = DAL_MysqlHelper.ExecuteNonQuery(sql, para); if (ret == 1) { return(AddOrderDetail(name, goods, gcnt)); } else { return(false); } } catch (Exception e) { throw e; } }
/// <summary> /// 添加一个学生用户。 /// </summary> /// <param name="student">学生实体信息</param> /// <returns></returns> public static bool insertStudent(Student student) { try { string sql = "insert into users(username, password, sex, grade, age, major, IP, regtime) values(?0,?1,?2,?3,?4,?5,?6,?7);"; MySqlParameter[] para = new MySqlParameter[8]; para[0] = new MySqlParameter("?0", student.username); para[1] = new MySqlParameter("?1", student.password); para[2] = new MySqlParameter("?2", student.sex); para[3] = new MySqlParameter("?3", student.grade); para[4] = new MySqlParameter("?4", student.age); para[5] = new MySqlParameter("?5", student.major); para[6] = new MySqlParameter("?6", student.IP); para[7] = new MySqlParameter("?7", student.regtime); int res = DAL_MysqlHelper.ExecuteNonQuery(sql, para); if (res > 0) { return(true); } else { return(false); } } catch (Exception e) { LogWriter.writeLine(@"C:\WEB_ASP\logs\DAL.log", "insertStudent:" + e.Message); return(false); } }
/// <summary> /// 查询某级类别的所有类别 /// </summary> /// <param name="level">类别等级(1,2,3)</param> /// <returns></returns> public static List <GoodsType> QueryAlltypes(int level) { try { string tb_name = "tb_goodstype"; if (level == 2) { tb_name += "_second"; } else if (level == 3) { tb_name += "_third"; } string sql = "select * from " + tb_name + ";"; DataTable dt = DAL_MysqlHelper.ExecuteDataSet(sql).Tables[0]; List <GoodsType> list = new List <GoodsType>(); for (int i = 0; i < dt.Rows.Count; i++) { GoodsType type = new GoodsType(); type.TypeID = dt.Rows[i]["goodsTypeID"].ToString(); type.TypeLevel = level; type.TypeName = dt.Rows[i]["goodsTypeName"].ToString(); if (level != 1) { type.ParentTypeID = dt.Rows[i]["goodsParentTypeID"].ToString(); } list.Add(type); } return(list); } catch (Exception e) { throw e; } }
/// <summary> /// 查询某类别从pos开始length条商品记录 /// </summary> /// <param name="typeID"></param> /// <param name="pos"></param> /// <param name="length"></param> /// <returns></returns> public static List <Goods> QueryGoods(string typeID, int pos, int length) { try { string sql = "select * from tb_goods where goodsTypeID=?typeID limit ?st,?ed;"; MySqlParameter[] para = new MySqlParameter[3]; para[0] = new MySqlParameter("?typeID", typeID); para[1] = new MySqlParameter("?st", pos); para[2] = new MySqlParameter("?ed", length); List <Entitys.Goods> list = new List <Goods>(); DataSet ds = DAL_MysqlHelper.ExecuteDataSet(sql, para); for (int i = 0; i < length; i++) { Entitys.Goods good = new Goods(); good.Id = ds.Tables[0].Rows[i][0].ToString(); good.Name = ds.Tables[0].Rows[i][1].ToString(); good.TypeID = ds.Tables[0].Rows[i][2].ToString(); good.Desctipt = ds.Tables[0].Rows[i][3].ToString(); good.UnitPrice = decimal.Parse(ds.Tables[0].Rows[i][4].ToString()); good.ImageName = ds.Tables[0].Rows[i][5].ToString(); good.SellCount = ds.Tables[0].Rows[i][6].ToString(); good.Date = ds.Tables[0].Rows[i][7].ToString(); list.Add(good); } return(list); } catch (Exception e) { throw e; } }
public static bool joinTeam(string teamID, string stuID, bool update = false) { string AuditMode = queryTeamAuditMode(teamID); string status = AuditMode == "自动审核" ? "已加入" : "待审核"; string sql = ""; MySqlParameter[] para = new MySqlParameter[2]; try { if (!update) { sql = "insert into team_member values(?0,?1,'" + status + "')"; } else { sql = "update team_member set AuditStatus='" + status + "' where TeamID=?0 and StuID=?1"; } para[0] = new MySqlParameter("?0", teamID); para[1] = new MySqlParameter("?1", stuID); int ret = DAL_MysqlHelper.ExecuteNonQuery(sql, para); if (ret >= 1) { return(true); } else { return(false); } } catch { return(false); } }
/// <summary> /// 修改二/三级类别的父类 /// </summary> /// <param name="level">类别等级(2,3)</param> /// <param name="typeID">TypeID</param> /// <param name="parentTypeID">ParentTypeID</param> /// <returns>bool</returns> public static bool UpdateParentTypeID(int level, string typeID, string parentTypeID) { try { string tb_name = "tb_goodstype"; if (level == 2) { tb_name += "_second"; } else if (level == 3) { tb_name += "_third"; } string sql = "update " + tb_name + " set goodsParentTypeID=?parentTypeID where goodsTypeID=?typeID;"; MySqlParameter[] para = new MySqlParameter[2]; para[0] = new MySqlParameter("?parentTypeID", parentTypeID); para[1] = new MySqlParameter("?typeID", typeID); int ret = DAL_MysqlHelper.ExecuteNonQuery(sql, para); if (ret == 1) { return(true); } return(false); } catch (Exception e) { throw e; } }
/// <summary> /// 更新个人信息 /// </summary> /// <param name="name">Name</param> /// <param name="birthday">Birthday</param> /// <param name="phone">Phone</param> /// <param name="email">Email</param> /// <returns>bool</returns> public static bool UpdatePersonalInfo(string name, string birthday, string phone, string email) { try { string sql = "update tb_customer set " + (birthday == ""?"": "customerBirthday=?birthday,") + "customerPhone=?phone,customerEmail=?email where customerName=?name;"; List <MySqlParameter> paras = new List <MySqlParameter>(); if (birthday != "") { paras.Add(new MySqlParameter("?birthday", birthday)); } paras.Add(new MySqlParameter("?phone", phone)); paras.Add(new MySqlParameter("?email", email)); paras.Add(new MySqlParameter("?name", name)); int ret = DAL_MysqlHelper.ExecuteNonQuery(sql, paras.ToArray()); if (ret == 1) { return(true); } else { return(false); } } catch (Exception e) { throw e; } }
/// <summary> /// 添加订单详细信息 /// </summary> /// <param name="name"></param> /// <param name="goods"></param> /// <param name="gcnt"></param> /// <returns></returns> public static bool AddOrderDetail(string name, List <Goods> goods, List <int> gcnt) { try { string sql = "select orderID from tb_order where customerName=?name order by orderDate limit 0,1;"; MySqlParameter para = new MySqlParameter("?name", name); string id = DAL_MysqlHelper.ExecuteDataSet(sql, para).Tables[0].Rows[0][0].ToString(); List <string> sqls = new List <string>(); List <MySqlParameter[]> paras = new List <MySqlParameter[]>(); for (int i = 0; i < goods.Count; i++) { var _goods = goods.ElementAt(i); string _sql = "insert into tb_orderdetail values(?orderID,?goodsID,?count);"; MySqlParameter[] _para = { new MySqlParameter("?orderID", id), new MySqlParameter("?goodsID", _goods.Id), new MySqlParameter("?count", gcnt.ElementAt(i)) }; sqls.Add(_sql); paras.Add(_para); } bool ret = DAL_MysqlHelper.ExecuteNoQueryTran(sqls, paras); return(ret); } catch (Exception e) { throw e; } }
/// <summary> /// 添加用户 /// </summary> /// <param name="name">Name</param> /// <param name="pass">Pass</param> /// <param name="question">Question</param> /// <param name="answer">Answer</param> /// <returns>bool</returns> public static bool AddCustomer(string name, string pass, string question, string answer) { try { string sql = "insert into tb_customer(customerName,customerPass,customerRegDate,customerQuestion,customerAnswer) values(?name,?pass,now(),?question,?answer);"; MySqlParameter[] para = new MySqlParameter[4]; para[0] = new MySqlParameter("?name", name); para[1] = new MySqlParameter("?pass", DAL_Safety.GetMD5(pass)); para[2] = new MySqlParameter("?question", question); para[3] = new MySqlParameter("?answer", DAL_Safety.EncodeBase64(answer)); int ret = DAL_MysqlHelper.ExecuteNonQuery(sql, para); if (ret == 1) { return(true); } else { return(false); } } catch (Exception e) { throw e; } }
/// <summary> /// 根据学号查询学生。 /// </summary> /// <param name="number">要查询的学生学号</param> /// <returns>除密码、IP、注册时间外的所有学生信息</returns> public static Student queryStudent(string number) { try { string sql = "select username,sex,grade,age,major from users where username=?1;"; MySqlParameter[] para = new MySqlParameter[1]; para[0] = new MySqlParameter("?1", number); DataTable dataTable = DAL_MysqlHelper.ExecuteDataTable(sql, para).Tables[0]; Student student = new Student("", "", "", "", "", "", "", ""); if (dataTable != null) { student.username = dataTable.Rows[0]["username"].ToString(); student.sex = dataTable.Rows[0]["sex"].ToString(); student.age = dataTable.Rows[0]["age"].ToString(); student.grade = dataTable.Rows[0]["grade"].ToString(); student.major = dataTable.Rows[0]["major"].ToString(); } return(student); } catch (Exception e) { LogWriter.writeLine(@"C:\WEB_ASP\logs\DAL.log", "queryStudent:" + e.Message); return(null); } }
/// <summary> /// 更新收货信息 /// </summary> /// <param name="name">Name</param> /// <param name="trueName">TrueName</param> /// <param name="address">Address</param> /// <param name="postCode">PostCode</param> /// <returns>bool</returns> public static bool UpdatePostInfo(string name, string trueName, string address, string postCode) { try { string sql = "update tb_customer set customerTrueName=?trueName,customerAddress=?address,customerPostCode=?postCode where customerName=?name;"; MySqlParameter[] para = new MySqlParameter[4]; para[0] = new MySqlParameter("?trueName", trueName); para[1] = new MySqlParameter("?address", address); para[2] = new MySqlParameter("?postCode", postCode); para[3] = new MySqlParameter("?name", name); int ret = DAL_MysqlHelper.ExecuteNonQuery(sql, para); if (ret == 1) { return(true); } else { return(false); } } catch (Exception e) { throw e; } }
public static bool quitTeam(string teamID, string stuID) { string AuditMode = queryTeamAuditMode(teamID); string sql = ""; MySqlParameter[] para = new MySqlParameter[2]; try { sql = "update team_member set AuditStatus='未加入' where TeamID=?0 and StuID=?1"; para[0] = new MySqlParameter("?0", teamID); para[1] = new MySqlParameter("?1", stuID); int ret = DAL_MysqlHelper.ExecuteNonQuery(sql, para); if (ret >= 1) { return(true); } else { return(false); } } catch { return(false); } }
public static bool modifyTeam(Team team) { try { string sql = "update team set AuditMode=?0,ScoreType=?1,AnswerStatus=?3,CourceName=?4,CourceTerm=?5,StuClass=?6,ScoreType=?7,Introduce=?8 where TeamID=?9"; MySqlParameter[] para = new MySqlParameter[9]; para[0] = new MySqlParameter("?0", team.AuditMode); para[1] = new MySqlParameter("?1", team.ScoreType); para[2] = new MySqlParameter("?3", team.AnswerStatus); para[3] = new MySqlParameter("?4", team.CourceName); para[4] = new MySqlParameter("?5", team.CourceTerm); para[5] = new MySqlParameter("?6", team.StuClass); para[6] = new MySqlParameter("?7", team.ScoreType); para[7] = new MySqlParameter("?8", team.Introduce); para[8] = new MySqlParameter("?9", team.TeamID); int ret = DAL_MysqlHelper.ExecuteNonQuery(sql, para); if (ret >= 1) { return(true); } else { return(false); } } catch { return(false); } }
/// <summary> /// 添加一个商品 /// </summary> /// <param name="name">Name</param> /// <param name="typeID">TypeID</param> /// <param name="unitPrice">UnitPrice</param> /// <param name="descript">Descript</param> /// <param name="imageName">ImageName</param> /// <returns>bool</returns> public static bool AddGood(string name, string typeID, decimal unitPrice, string descript = "", string imageName = "") { try { string sql = "insert into tb_goods(goodsName,goodsTypeID,goodsUnitPrice,goodsDescript,goodsImageName,goodsDate) values(?name,?typeID,?unitPrice,?descript,?imageName,now());"; MySqlParameter[] para = new MySqlParameter[5]; para[0] = new MySqlParameter("?name", name); para[1] = new MySqlParameter("?typeID", typeID); para[2] = new MySqlParameter("?unitPrice", unitPrice); para[3] = new MySqlParameter("?descript", descript); para[4] = new MySqlParameter("?imageName", imageName); int ret = DAL_MysqlHelper.ExecuteNonQuery(sql, para); if (ret == 1) { return(true); } else { return(false); } } catch (Exception e) { throw e; } }
/// <summary> /// 根据TypeID查询某级类别详细信息 /// </summary> /// <param name="level">类别等级(1,2,3)</param> /// <param name="typeID">TypeID</param> /// <returns>GoodsType</returns> public static GoodsType QueryTypeName(int level, string typeID) { try { string tb_name = "tb_goodstype"; if (level == 2) { tb_name += "_second"; } else if (level == 3) { tb_name += "_third"; } string sql = "select * from " + tb_name + " where goodsTypeID=?typeID;"; MySqlParameter para = new MySqlParameter("?typeID", typeID); DataTable dt = DAL_MysqlHelper.ExecuteDataSet(sql, para).Tables[0]; GoodsType type = new GoodsType(); type.TypeID = typeID; type.TypeLevel = level; type.TypeName = dt.Rows[0]["goodsTypeName"].ToString(); if (level != 1) { type.ParentTypeID = dt.Rows[0]["goodsParentTypeID"].ToString(); } return(type); } catch (Exception e) { throw e; } }
/// <summary> /// 更新商品信息 /// </summary> /// <param name="goods"></param> /// <returns></returns> public static bool UpdateGood(Goods goods) { try { string sql = "update tb_goods set goodsName=?name,goodsTypeID=?typeID,goodsDescript=?descript,goodsUnitPrice=?unitPrice,goodsImageName=?imageName where goodsID=?id;"; MySqlParameter[] para = new MySqlParameter[6]; para[0] = new MySqlParameter("?name", goods.Name); para[1] = new MySqlParameter("?typeID", goods.TypeID); para[2] = new MySqlParameter("?descript", goods.Desctipt); para[3] = new MySqlParameter("?unitPrice", goods.UnitPrice); para[4] = new MySqlParameter("?imageName", goods.ImageName); para[5] = new MySqlParameter("?id", goods.Id); int ret = DAL_MysqlHelper.ExecuteNonQuery(sql, para); if (ret == 1) { return(true); } else { return(false); } } catch (Exception e) { throw e; } }
/// <summary> /// 查询某级类别的所有子类 /// </summary> /// <param name="level">类别等级(1,2)</param> /// <param name="typeID">TypeID</param> /// <returns>List<GoodsType></returns> public static List <GoodsType> QueryTypesChild(int level, string typeID) { try { level++; string tb_name = "tb_goodstype"; if (level == 2) { tb_name += "_second"; } else if (level == 3) { tb_name += "_third"; } string sql = "select * from " + tb_name + " where goodsParentTypeID=?typeID;"; MySqlParameter para = new MySqlParameter("?typeID", typeID); DataTable dt = DAL_MysqlHelper.ExecuteDataSet(sql, para).Tables[0]; List <GoodsType> list = new List <GoodsType>(); for (int i = 0; i < dt.Rows.Count; i++) { GoodsType type = new GoodsType(); type.TypeID = dt.Rows[i]["goodsTypeID"].ToString(); type.TypeLevel = level; type.TypeName = dt.Rows[i]["goodsTypeName"].ToString(); list.Add(type); } return(list); } catch (Exception e) { throw e; } }
/// <summary> /// 添加一个教师用户。 /// </summary> /// <param name="teacher">教师实体信息</param> /// <returns></returns> public static bool insertTeacher(Teacher teacher) { try { string sql = "insert into teacher(username, password, sex, age) values(?0,?1,?2,?3);"; MySqlParameter[] para = new MySqlParameter[4]; para[0] = new MySqlParameter("?0", teacher.username); para[1] = new MySqlParameter("?1", teacher.password); para[2] = new MySqlParameter("?2", teacher.sex); para[3] = new MySqlParameter("?3", teacher.age); int res = DAL_MysqlHelper.ExecuteNonQuery(sql, para); if (res > 0) { return(true); } else { return(false); } } catch (Exception e) { LogWriter.writeLine(@"C:\WEB_ASP\logs\DAL.log", "insertTeacher:" + e.Message); return(false); } }
/// <summary> /// 判断教师用户是否存在。 /// </summary> /// <param name="number">用户名</param> /// <param name="password">密码</param> /// <returns></returns> public static bool teacherExits(string number, string password) { password = DAL_Safety.getMD5(password); object obj = null; try { string sql = "select username from teacher where username=?1 and password=?2;"; MySqlParameter[] para = new MySqlParameter[2]; para[0] = new MySqlParameter("?1", number); para[1] = new MySqlParameter("?2", password); obj = DAL_MysqlHelper.ExecuteScalar(sql, para); } catch (Exception e) { LogWriter.writeLine(@"C:\WEB_ASP\logs\DAL.log", "studentExits:" + e.Message); return(false); } if (Equals(obj, null)) { return(false); } else { return(true); } }
/// <summary> /// 修改一个学生信息(包括密码、年龄、年纪、性别、专业)。 /// </summary> /// <param name="student">修改后的学生信息</param> /// <returns></returns> public static bool modifyStudent(Student student) { string username = student.username; string password = student.password; if (password.Length != 0) { password = DAL_Safety.getMD5(password); } string age = student.age; string grade = student.grade; string sex = student.sex; string major = student.major; try { string sql = ""; int res = 0; if (password.Length != 0) { sql = "update users set password=?1, grade=?2, age=?3, sex=?4, major=?5 where username=?6;"; MySqlParameter[] para = new MySqlParameter[6]; para[0] = new MySqlParameter("?1", password); para[1] = new MySqlParameter("?2", grade); para[2] = new MySqlParameter("?3", age); para[3] = new MySqlParameter("?4", sex); para[4] = new MySqlParameter("?5", major); para[5] = new MySqlParameter("?6", username); res = DAL_MysqlHelper.ExecuteNonQuery(sql, para); } else { sql = "update users set grade=?1, age=?2, sex=?3, major=?4 where username=?5;"; MySqlParameter[] para = new MySqlParameter[5]; para[0] = new MySqlParameter("?1", grade); para[1] = new MySqlParameter("?2", age); para[2] = new MySqlParameter("?3", sex); para[3] = new MySqlParameter("?4", major); para[4] = new MySqlParameter("?5", username); res = DAL_MysqlHelper.ExecuteNonQuery(sql, para); } if (res > 0) { return(true); } else { return(false); } } catch (Exception e) { LogWriter.writeLine("DAL.log", "modifyStudent:" + e.Message); return(false); } }
/// <summary> /// 查询所有用户收货信息与个人信息(管理功能) /// </summary> /// <returns>DataSet 或 null</returns> public static DataSet QueryAllCustomer() { try { string sql = "select customerName,customerTrueName,customerAddress,customerPostCode,customerBirthday,customerPhone,customerEmail from tb_customer;"; DataSet ds = DAL_MysqlHelper.ExecuteDataSet(sql); return(ds); } catch (Exception e) { throw e; } }
/// <summary> /// 查询商品总数 /// </summary> /// <returns></returns> public static int QueryGoodsCount() { try { string sql = "select count(*) from tb_goods;"; int ret = Int32.Parse(DAL_MysqlHelper.ExecuteScalar(sql).ToString()); return(ret); } catch (Exception e) { throw e; } }
/// <summary> /// 查询所有学生信息。 /// </summary> /// <returns>DataSet</returns> public static DataSet queryAllStudent() { DataSet ds = null; try { string sql = "select username,sex,grade,age,major,IP,regtime,id from users;"; ds = DAL_MysqlHelper.ExecuteDataTable(sql); } catch { } return(ds); }
/// <summary> /// 修改教师信息。 /// </summary> /// <param name="teacher">修改后的教师实体信息</param> /// <returns></returns> public static bool modifyTeacher(Teacher teacher) { string username = teacher.username; string password = teacher.password; if (password.Length != 0) { password = DAL_Safety.getMD5(password); } string age = teacher.age; string sex = teacher.sex; try { string sql = ""; int res = 0; if (password.Length != 0) { sql = "update teacher set password=?1, age=?2, sex=?3 where username=?4;"; MySqlParameter[] para = new MySqlParameter[4]; para[0] = new MySqlParameter("?1", password); para[1] = new MySqlParameter("?2", age); para[2] = new MySqlParameter("?3", username); para[3] = new MySqlParameter("?4", username); res = DAL_MysqlHelper.ExecuteNonQuery(sql, para); } else { sql = "update teacher set age=?1, sex=?2 where username=?3;"; MySqlParameter[] para = new MySqlParameter[3]; para[0] = new MySqlParameter("?1", age); para[1] = new MySqlParameter("?2", sex); para[2] = new MySqlParameter("?3", username); res = DAL_MysqlHelper.ExecuteNonQuery(sql, para); } if (res > 0) { return(true); } else { return(false); } } catch (Exception e) { LogWriter.writeLine("DAL.log", "modifyTeacher:" + e.Message); return(false); } }
public static DataSet queryMember(string TeamID) { string sql = "select b.username,b.major,a.AuditStatus from team_member a, users b where a.StuID=b.username and a.TeamID=?0"; MySqlParameter para = new MySqlParameter("?0", TeamID); try { return(DAL_MysqlHelper.ExecuteDataTable(sql, para)); } catch (Exception e) { return(null); } }
public static DataSet queryAllTeam() { DataSet ds = null; try { string sql = "select team.*,teacher.TeaName from teacher inner join team on teacher.username=team.TeaID"; ds = DAL_MysqlHelper.ExecuteDataTable(sql); } catch { } return(ds); }
/// <summary> /// 查询销量降序排列的第pos条记录开始的连续length条记录 /// </summary> /// <param name="pos"></param> /// <param name="length"></param> /// <returns></returns> public static DataSet QueryGoodsSellCountDesc(int pos, int length) { try { string sql = "select * from tb_goods order by sellCount limit ?st,?ed;"; MySqlParameter[] para = new MySqlParameter[2]; para[0] = new MySqlParameter("?st", pos); para[1] = new MySqlParameter("?ed", length); DataSet ds = DAL_MysqlHelper.ExecuteDataSet(sql, para); return(ds); } catch (Exception e) { throw e; } }
public static DataSet QueryManagers(int pos, int length) { try { string sql = "select managerName from tb_manage limit ?st,?ed;"; MySqlParameter[] para = new MySqlParameter[2]; para[0] = new MySqlParameter("?st", pos); para[1] = new MySqlParameter("?ed", length); var ret = DAL_MysqlHelper.ExecuteDataSet(sql, para); return(ret); } catch (Exception e) { throw e; } }
/// <summary> /// 根据ID删除一个学生。 /// </summary> /// <param name="ID">要删除的学生ID</param> /// <returns></returns> public static bool deleteStudentByID(string ID) { string sql = "delete from users where id=?1"; MySqlParameter[] para = new MySqlParameter[1]; para[0] = new MySqlParameter("?1", ID); int res = DAL_MysqlHelper.ExecuteNonQuery(sql, para); if (res > 0) { return(true); } else { return(false); } }