public bool update <T>(T a) { try { str = DBOperate.sqlUpdtae(a); return(sql.ExecSql(str)); } catch (Exception) { return(false); } }
public bool delete(CourseDetail c) { try { str = DBOperate.sqlDelete(c); return(sql.ExecSql(str)); } catch (Exception) { return(false); } }
public bool function(Functions f) { str = "select * from Functions where no='" + f.no + "' and [type]='" + f.type + "'"; DataTable dd = sql.FillDt(str); if (dd != null) { if (dd.Rows.Count > 0) { return(sql.ExecSql("delete from Functions where no='" + f.no + "' and [type]='" + f.type + "'")); } } return(c.insert(f)); }
public bool delete(string _classroom_id)//(string _build, string _name, string _people, string _manager, string _descride) { string str = "delete from classroom where classroom_id='" + _classroom_id + "'"; SqlDB db = new SqlDB(); db.ExecSql(str); return(true); }
public void delete(string whole) { string[] Sum = whole.Split('|'); string sql = "delete from CourseBuild where Building_Id='" + Sum[1] + "' AND Department='" + Sum[0] + "' AND Garde='" + Sum[6] + "' AND Name='" + Sum[2] + "' AND Week='" + Sum[5] + "' AND Weekday='" + Sum[8] + "' AND Section='" + Sum[9] + "' AND Teacher='" + Sum[4] + "' AND Course='" + Sum[3] + "' AND Class='" + Sum[7] + "' AND Year='" + Sum[10] + "' AND Term='" + Sum[11] + "'"; SqlDB db = new SqlDB(); db.ExecSql(sql); }
public bool modify(string _build, string _name, string _classroom_id, string _people, string _manager, string _descride) { string str = "update Classroom set Building_id='" + _build + "',Name='" + _name + "',classroom_id='" + _classroom_id + "',People='" + _people + "',Manager='" + _manager + "',Descride='" + _descride + "'where classroom_id='" + _classroom_id + "'"; SqlDB db = new SqlDB(); db.ExecSql(str); return(true); }
public bool add(string build, string name, string classroom_id, string people, string manager, string descride) { string str = "insert into classroom(classroom_id,building_id,name,people,manager,descride)values(" + "'" + classroom_id + "','" + build + "','" + name + "','" + people + "','" + manager + "','" + descride + "')"; SqlDB db = new SqlDB(); db.ExecSql(str); return(true); }
public bool Addteacher(string id, string name, string department, string major) { SqlDB db = new SqlDB(); if (db.ExecSql("insert into teacher(id,TeacherName,Department,Major) values('" + id + "','" + name + "','" + department + "','" + major + "')")) { return(true); } return(false); }
public bool ChangeTea(int id, string Teachername, string department, string major) { SqlDB db = new SqlDB(); string strsql = "update Teacher set TeacherName = '" + Teachername + "',Department = '" + department + "', Major ='" + major + "' where id = '" + id + "'"; if (db.ExecSql(strsql)) { return(true); } return(false); }
public bool Deleteteacher(string id) { SqlDB db = new SqlDB(); string strsql = "delete from teacher where id='" + id + "'"; if (db.ExecSql(strsql)) { return(true); } return(false); }
public bool Deleteadmin(string name) { SqlDB db = new SqlDB(); string strsql = "delete from Users where UsersName='" + name + "'"; if (db.ExecSql(strsql)) { return(true); } return(false); }
public bool Addadmin(string id, string name, string pwd, string role) { SqlDB db = new SqlDB(); string Md5str = GetMd5Hash(pwd); string str = "insert into Users(id,UsersName,PassWord,role) values('" + id + "','" + name + "','" + Md5str + "','" + role + "')"; if (db.ExecSql(str)) { return(true); } return(false); }
public bool ChangeAdmin(int id, string name, string pwd) { SqlDB db = new SqlDB(); string Md5str = GetMd5Hash(pwd); string strsql = "update Users set UsersName = '" + name + "',PassWord = '******' where id = '" + id + "'"; if (db.ExecSql(strsql)) { return(true); } return(false); }
public bool AddClass(Basic_Information basic) { string sql = "insert into Basic_Information(Garde,ClassId,Class,Department) values(" + basic.Garde + ",'" + Convert.ToInt32(basic.ClassId) + "','" + basic.Class + "','" + basic.Department + "')"; return(db.ExecSql(sql)); }
public bool Insert(string s1, string s2, string s3, string s4, string s5, string s6, string s7, string s8, string s9, string s10, string s11, string s12) { string sql = "INSERT INTO CourseBuild(Building_Id,Department,Garde,Name,Week,Weekday,Section,Teacher,Course,Class,Year,Term,reason) values ('" + s1 + "','" + s2 + "','" + s3 + "','" + s4 + "','" + s5 + "','" + s6 + "','" + s7 + "','" + s8 + "','" + s9 + "','" + s10 + "','" + s11 + "','" + s12 + "' ,'" + " ')"; SqlDB db = new SqlDB(); if (db.ExecSql(sql)) { return(true); } else { return(false); } }
//重置任务完成情况 public bool reset() { try { str = "update Users set remark1='未完成'"; return(sql.ExecSql(str)); } catch (Exception) { return(false); } }
/// <summary> /// 将课表数据插入数据库 /// </summary> /// <param name="course"></param> /// <returns></returns> public bool Insert(List <CourseBuild> course) { string sql = "INSERT INTO CourseBuild(Building_Id,Department,Garde,Name,Week,Weekday,Section,Teacher,Course,Class,Year,Term,reason)"; for (int i = 0; i < course.Count - 1; i++) { sql += "select " + course[i].Building_Id + ",'" + course[i].Department + "'," + "'" + course[i].Garde + "'," + "'" + course[i].Name + "'," + "'" + course[i].Week + "'," + "'" + course[i].Weekday + "'," + "'" + course[i].Section + "'," + "'" + course[i].Teacher + "'," + "'" + course[i].Course + "'," + "'" + course[i].Class + "'," + "'" + course[i].Year + "'," + "'" + course[i].Term + "'," + "'" + course[i].reason + "' union all "; } sql += "select " + course[course.Count - 1].Building_Id + ",'" + course[course.Count - 1].Department + "'," + "'" + course[course.Count - 1].Garde + "'," + "'" + course[course.Count - 1].Name + "'," + "'" + course[course.Count - 1].Week + "'," + "'" + course[course.Count - 1].Weekday + "'," + "'" + course[course.Count - 1].Section + "'," + "'" + course[course.Count - 1].Teacher + "'," + "'" + course[course.Count - 1].Course + "'," + "'" + course[course.Count - 1].Class + "'," + "'" + course[course.Count - 1].Year + "'," + "'" + course[course.Count - 1].Term + "'," + "'" + course[course.Count - 1].reason + "'"; SqlDB db = new SqlDB(); if (db.ExecSql(sql)) { return(true); } else { return(false); } }
public bool InsertApply() { //插入活动 try { string sqlit = "INSERT INTO CourseBuild(Building_Id,Department,Garde,Name,Week,Weekday,Section,Teacher,Course,Class,Year,Term,reason) Values ('" + B_ID + "','" + Department + "','" + Garde + "','" + CM + "','" + WK + "','" + WY + "','" + Section + "','" + Teacher + "','" + Course + "','" + Class + "','" + Year + "','" + Term + "','" + Reason + "')"; if (db.ExecSql(sqlit)) { return(true); } else { return(false); } } catch { return(false); } }
/// <summary> /// 设置是否可用 /// </summary> /// <param name="id"></param> /// <returns></returns> public bool state(string id) { try { str = "select remark1 from LabInfo where id=" + id + ""; DataTable dt = sql.FillDt(str); if (dt.Rows[0][0].ToString() == "1") { str = "update LabInfo set remark1='0' where id=" + id + ""; } else { str = "update LabInfo set remark1='1' where id=" + id + ""; } return(sql.ExecSql(str)); } catch (Exception) { return(false); } }
public bool BackPwd(UsersModel user)//修改密码 后更新 { string sql = "update Users set PassWord='******' where id='" + user.id + "' and UsersName='" + user.UsersName + "'"; return(sqlDB.ExecSql(sql)); }