/// <summary> /// 删除指定编号的报表 /// </summary> /// <param name="ID">编号</param> /// <returns></returns> public bool DeleteReport(int ID) { try { string sql = "delete Report_Config where ID=" + ID; return(SQLDataServer.OperationSQL(sql, conn)); } catch { return(false); } }
/// <summary> /// 删除指定的表 /// </summary> /// <param name="tablename">表名</param> /// <returns></returns> public bool DeleteReportTable(string tablename) { try { string sql = "drop table " + tablename; return(SQLDataServer.OperationSQL(sql, conn)); } catch { return(false); } }
/// <summary> /// 增加报表 /// </summary> /// <param name="reportname">报表名称</param> /// <param name="tablename">报表对应的表名</param> /// <param name="systemtype">报表所属系统类型</param> /// <param name="remark">报表备注</param> /// <returns></returns> public bool InsertReport(string reportname, string tablename, int systemtype, string remark) { try { string sql = "insert into Report_Config(ReportName,DispName,SystemType,Remark) values('" + reportname + "','" + tablename + "'," + systemtype + ",'" + remark + "')"; return(SQLDataServer.OperationSQL(sql, conn)); } catch { return(false); } }
public bool ExcuteSql(string sql) { return(SQLDataServer.OperationSQL(sql, conn)); }