public MemoryStream ExportCSV(DataTable dt)
{
MemoryStream stream = new MemoryStream();
stream = OutPutCSV.ExportCSV(dt, "ファイルNO");
return(stream);
}
public MemoryStream ExportCSVCR(DataTable dt)
{
MemoryStream stream = new MemoryStream();
stream = OutPutCSV.ExportCSV(dt, "車台番号,書類ステータス,仕入DN出品番号,売上DN出品番号,出品店情報(店舗コード),出品店情報(店舗名),落札店情報(店舗コード),落札店情報(店舗名),仕入AA会場,売上AA会場,AA開催日,AA番号,DN成約日,仕入番号,年式,メーカー,車名,グレード,型式,車両区分,登録ナンバー,車検満了日,書類有効期限,自社名区分,書類区分,書類入庫日,書類出庫日,自社名依頼日,自社名完了日,抹消依頼日,抹消完了日,ファイル番号,メモ");
return(stream);
}
public MemoryStream ExportCsvRC002()
{
MemoryStream stream = new MemoryStream();
DataTable dataResult = new DataTable();
using (DBManager dbManager = new DBManager(ConstantsStpReports.RC002))
{
dataResult = dbManager.GetDataTable();
}
stream = OutPutCSV.ExportCSV(dataResult, "ファイルNO,車台番号,タグID");
return(stream);
}
/// <summary>
/// Get file CSV ヘッダレベル出力
/// </summary>
/// <param name="listOrder"></param>
/// <param name="isCheck">false:簡易;true:全て</param>
/// <param name="error"></param>
/// <returns></returns>
public MemoryStream ExportCSVRH9086(DataTable listOrder, bool isCheck, ref string error)
{
DataSet result = new DataSet();
MemoryStream streamReportsCSV = new MemoryStream();
ReportServices reportService = new ReportServices();
if (isCheck)
{
result = GetDataReports(listOrder, ConstantsStpReports.RH9086_header_all, "@ListOrderNo", ref error);
}
else
{
result = GetDataReports(listOrder, ConstantsStpReports.RH9086_header_part, "@ListOrderNo", ref error);
}
try
{
if (string.IsNullOrEmpty(error))
{
if (result.Tables.Count <= 0)
{
error = "I0007";
}
else if (result.Tables[0].Rows.Count <= 0)
{
error = "I0007";
}
else
{
streamReportsCSV = OutPutCSV.ExportCSV(result.Tables[0], "");
}
}
}
catch (Exception)
{
error = "E0002";
}
return(streamReportsCSV);
}
/// <summary>
/// Get file CSV 検索データ出力
/// </summary>
/// <param name="listData"></param>
/// <param name="error"></param>
/// <returns></returns>
public MemoryStream ExportCSVRH9080(DataTable listData, ref string error)
{
MemoryStream streamReportsCSV = new MemoryStream();
try
{
if (listData != null)
{
if (listData.Rows.Count <= 0)
{
error = "I0007";
}
else
{
streamReportsCSV = OutPutCSV.ExportCSV(listData, "");
}
}
}
catch (Exception)
{
error = "E0002";
}
return(streamReportsCSV);
}
public MemoryStream ExportPDF(string reportID, System.Data.DataSet dataSource)
{
MemoryStream stream = new MemoryStream();
MemoryStream streamDenpyo = new MemoryStream();
MemoryStream streamDenpyoKihonMeisai = new MemoryStream();
MemoryStream streamDenpyoBuhinMeisai = new MemoryStream();
dsRS3016 = new DataSet();
dsRS3016 = dataSource;
if (this.listStreamCSV == null)
{
this.listStreamCSV = new List <MemoryStream>();
}
streamDenpyo = OutPutCSV.ExportCSV(dsRS3016.Tables[0], "");
this.listStreamCSV.Add(streamDenpyo);
streamDenpyoKihonMeisai = OutPutCSV.ExportCSV(dsRS3016.Tables[1], "");
this.listStreamCSV.Add(streamDenpyoKihonMeisai);
streamDenpyoBuhinMeisai = OutPutCSV.ExportCSV(dsRS3016.Tables[2], "");
this.listStreamCSV.Add(streamDenpyoBuhinMeisai);
stream = ExportCSVZip(new string[] { "Denpyo", "Denpyo_Kihon_Meisai", "Denpyo_Buhin_Meisai" });
return(stream);
}