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