/// <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));
}