/// <summary> /// 清空第一次导入数据库数据 /// </summary> /// <returns></returns> public static bool ClearExcel() { bool clearTabTeachers, clearTabOtherTeachers, clearTabCalendar, clearTabAllCourses;//记录删除成果 clearTabTeachers = ConnHelper.ExecuteNoneQueryOperation("truncate table TabAllCourses"); clearTabOtherTeachers = ConnHelper.ExecuteNoneQueryOperation("truncate table TabTeachers"); clearTabCalendar = ConnHelper.ExecuteNoneQueryOperation("truncate table TabCalendar"); clearTabAllCourses = ConnHelper.ExecuteNoneQueryOperation("truncate table TabOtherTeachers"); ConnHelper.ExecuteNoneQueryOperation("delete from TabAllCourses");//可找回但速度慢 return(clearTabTeachers && clearTabOtherTeachers && clearTabCalendar && clearTabAllCourses); }
public static bool UpdateTabTeachers(string TableName, string UserPWD, string UserID) { string strSQL = BuildSQLUpdateString(TableName, UserPWD, UserID); return(ConnHelper.ExecuteNoneQueryOperation(strSQL)); }
/// <summary> /// 删除表内的数据,有一个约束条件 /// </summary> /// <param name="v1">表名</param> /// <param name="v2">约束字段</param> /// <param name="v3">约束值</param> public static bool DeleteRows(string v1, string v2, string v3) { string strSQL = SQLFactory.BuildSQLDeleteString(v1, v2, v3); return(ConnHelper.ExecuteNoneQueryOperation(strSQL)); }
/// <summary> /// 发布通知 /// </summary> /// <param name="text">数据</param> /// <param name="v2">权限</param> public static bool InsertMsgRow(string text, string v2) { string strSQL = "insert into TabMessage(message,role) values('" + text + "','" + v2 + "')"; return(ConnHelper.ExecuteNoneQueryOperation(strSQL)); }
/// <summary> /// 更新数据表 /// 更新一个字段,有一个条件 /// </summary> /// <param name="v1">表名</param> /// <param name="v2">更新的字段</param> /// <param name="v3">更新后的值</param> /// <param name="v4">约束名1</param> /// <param name="v5">约束名2</param> /// <param name="v6">约束名3</param> /// <param name="v7">约束名4</param> /// <param name="v8">约束名5</param> /// <param name="c4">约束值1</param> /// <param name="c5">约束值2</param> /// <param name="c6">约束值3</param> /// <param name="c7">约束值4</param> /// <param name="c8">约束值5</param> public static bool UpdateRows(string v1, string v2, string v3, string v4, string v5, string v6, string v7, string v8, string c4, string c5, string c6, string c7, string c8) { string strSQL = "update " + v1 + " set " + v2 + "='" + v3 + "' where " + v4 + "='" + c4 + "' and " + v5 + "='" + c5 + "' and " + v6 + "='" + c6 + "' and " + v7 + "='" + c7 + "' and " + v8 + "='" + c8 + "'"; return(ConnHelper.ExecuteNoneQueryOperation(strSQL)); }
public static bool DeleteTab(string TName) { string strSQL = SQLFactory.BuildSQLDeleteString(TName); return(ConnHelper.ExecuteNoneQueryOperation(strSQL)); }
/// <summary> /// 更新数据表 /// 更新一个字段,有一个条件 /// </summary> /// <param name="v1">表名</param> /// <param name="v2">更新的字段</param> /// <param name="v3">更新后的值</param> /// <param name="v4">约束名</param> /// <param name="v5">约束值</param> /// <returns></returns> public static bool UpdateRows(string v1, string v2, string v3, string v4, string v5) { string strSQL = SQLFactory.BuildSQLUpdate(v1, v2, v3, v4, v5); return(ConnHelper.ExecuteNoneQueryOperation(strSQL)); }
/// <summary> /// 执行插入命令 /// </summary> /// <param name="strSql">insert into 语句</param> /// <returns></returns> public static bool InsertData(string strSql) { return(ConnHelper.ExecuteNoneQueryOperation(strSql)); }
public static bool DeleteTabTeachers(string tableName) { string strSql = "DELETE FROM " + tableName + " WHERE 1=1"; return(ConnHelper.ExecuteNoneQueryOperation(strSql)); }