/// <summary>
/// 更新快捷报表。
/// </summary>
/// <param name="quickReport">快捷报表实体。</param>
/// <returns>-1失败；1成功。</returns>
public int UpdateQuickReportByID(Objects.QuickReportObject quickReport, string id)
{
string sql = "";
if (Managers.Sql.GetSql("QuickReportCore.UpdateQuickReportByID", ref sql) == -1)
{
Err = "获得SQL语句：QuickReportCore.UpdateQuickReportByID失败。";
return(-1);
}
sql = string.Format(sql, quickReport.ID, quickReport.Name, quickReport.Type, quickReport.Version, quickReport.IsValid, id);
try
{
byte[] content = Encoding.Default.GetBytes(quickReport.Content);
return(InputBlob(sql, content));
}
catch (Exception e)
{
Err = "插入快捷报表失败。" + e.Message;
return(-1);
}
finally
{
Reader.Close();
}
}
/// <summary>
/// 插入快捷报表。
/// </summary>
/// <param name="quickReport">快捷报表实体。</param>
/// <returns>-1失败；1成功。</returns>
public int InsertQuickReport(Objects.QuickReportObject quickReport)
{
int i = InsertQuickReportBaseInfo(quickReport);
if (i < 0)
{
return(i);
}
byte[] content = Encoding.Default.GetBytes(quickReport.Content);
return(UpdateQuickReportContentByID(quickReport.ID, content));
}
/// <summary>
/// 插入快捷报表的基础信息。
/// </summary>
/// <param name="quickReport">快捷报表。</param>
/// <returns>-1失败；1成功。</returns>
private int InsertQuickReportBaseInfo(Objects.QuickReportObject quickReport)
{
string sql = "";
if (Managers.Sql.GetSql("QuickReportCore.InsertQuickReportBaseInfo", ref sql) == -1)
{
Err = "获得SQL语句：QuickReportCore.InsertQuickReportBaseInfo失败。";
return(-1);
}
sql = string.Format(sql, quickReport.ID, quickReport.Name, quickReport.Type, quickReport.Version, quickReport.IsValid);
try
{
return(ExecNoQuery(sql));
}
catch (Exception e)
{
Err = "插入快捷报表失败。" + e.Message;
return(-1);
}
finally
{
Reader.Close();
}
}
/// <summary>
/// 根据ID获取快捷报表。
/// </summary>
/// <param name="id">快捷报表的ID。</param>
/// <returns>快捷报表。</returns>
public Objects.QuickReportObject QueryReportByID(string id)
{
Objects.QuickReportObject quickReport;
string sql = "";
if (Managers.Sql.GetSql("QuickReportCore.QueryReportByID", ref sql) == -1)
{
Err = "获得SQL语句：QuickReportCore.QueryReportByID失败。";
return(null);
}
sql = string.Format(sql, id);
try
{
ExecQuery(sql);
quickReport = new Objects.QuickReportObject();
while (Reader.Read())
{
quickReport.ID = Reader[0].ToString();
quickReport.Name = Reader[1].ToString();
quickReport.Type = Reader[2].ToString();
quickReport.Version = Convert.ToDecimal(Reader[3].ToString());
quickReport.Content = Encoding.Default.GetString((byte[])Reader[4]);
quickReport.IsValid = Reader[5].ToString();
}
}
catch (Exception e)
{
Err = "根据ID获取快捷报表失败。" + e.Message;
return(null);
}
finally
{
Reader.Close();
}
return(quickReport);
}
/// <summary>
/// 获取所有快捷报表的基本信息。
/// </summary>
/// <returns>快捷报表集合。只包含基本信息，未包含Sql与Content。</returns>
public List <Objects.QuickReportObject> QueryAllQuickReports()
{
List <Objects.QuickReportObject> list;
string sql = "";
if (Managers.Sql.GetSql("QuickReportCore.QueryAllReports", ref sql) == -1)
{
Err = "获得SQL语句：QuickReportCore.QueryAllReports失败。";
return(null);
}
try
{
ExecQuery(sql);
list = new List <Objects.QuickReportObject>();
while (Reader.Read())
{
Objects.QuickReportObject quickReport = new Objects.QuickReportObject();
quickReport.ID = Reader[0].ToString();
quickReport.Name = Reader[1].ToString();
quickReport.Type = Reader[2].ToString();
quickReport.Version = Convert.ToDecimal(Reader[3].ToString());
quickReport.IsValid = Reader[4].ToString();
list.Add(quickReport);
}
}
catch (Exception e)
{
Err = "获取所有快捷报表失败。" + e.Message;
return(null);
}
finally
{
Reader.Close();
}
return(list);
}
