//リストビューをコピーするだけ
private void button_copy_Click(object sender, EventArgs e)
{
if (listView_output.Items.Count == 0) return;
StringBuilder sb = new StringBuilder();
//ヘッダー
var header = new CsvList<string>();
foreach(int i in Enumerable.Range(0, listView_output.Columns.Count))
{
header.Add(listView_output.Columns[i].Text);
};
sb.AppendLine(string.Join("\t", header));
//アイテム
foreach(int i in Enumerable.Range(0, listView_output.Items.Count))
{
var row = new CsvList<string>();
var item = listView_output.Items[i];
foreach(int j in Enumerable.Range(0, item.SubItems.Count))
{
row.Add(item.SubItems[j].Text);
}
sb.AppendLine(string.Join("\t", row));
}
//クリップボードにコピー
Clipboard.SetText(sb.ToString());
}
//コンバート用のテキストの作成
public static string MakeConvertText(IEnumerable<DropRecord> records, Dictionary<int, string> dropshipheader, Dictionary<int, string> dropitemheader)
{
StringBuilder sb = new StringBuilder();
CsvList<string> header = new CsvList<string>();
foreach (string x in DropRecord.LogConvertHeader)
{
header.Add(x);
}
sb.AppendLine(string.Join(",", header.ToArray()));
//個々のデータ
foreach (var x in records)
{
//--行の追加
sb.AppendLine(x.MakeLogConvertText(dropshipheader, dropitemheader));
}
//帰り値
return sb.ToString();
}
/// <summary>
/// CSVの行を作成
/// </summary>
/// <returns>CSVの行テキスト</returns>
public CsvList<string> ExportCSV()
{
var csv = new CsvList<string>();
csv.Add(this.api_id.ToString());
csv.Add(this.api_sortno.ToString());
csv.Add(this.api_name ?? ExCommon.NullString);
csv.Add(ExCommon.ListToCsvString(this.api_type));
csv.Add(this.api_taik.ToString());
csv.Add(this.api_souk.ToString());
csv.Add(this.api_houg.ToString());
csv.Add(this.api_raig.ToString());
csv.Add(this.api_soku.ToString());
csv.Add(this.api_baku.ToString());
csv.Add(this.api_tyku.ToString());
csv.Add(this.api_tais.ToString());
csv.Add(this.api_atap.ToString());
csv.Add(this.api_houm.ToString());
csv.Add(this.api_raim.ToString());
csv.Add(this.api_houk.ToString());
csv.Add(this.api_raik.ToString());
csv.Add(this.api_bakk.ToString());
csv.Add(this.api_saku.ToString());
csv.Add(this.api_sakb.ToString());
csv.Add(this.api_luck.ToString());
csv.Add(this.api_leng.ToString());
csv.Add(this.api_rare.ToString());
csv.Add(ExCommon.ListToCsvString(this.api_broken));
csv.Add(this.api_info ?? ExCommon.NullString);
csv.Add(this.api_usebull ?? ExCommon.NullString);
csv.Add(this.api_cost.ToString());
csv.Add(this.api_distance.ToString());
csv.Add(this.TaiBaku.ToString());
csv.Add(this.Geigeki.ToString());
return csv;
}