override public void LoadCSV(string filename)
{
OwnerDB.BeginTransaction();
using (var reader = new System.IO.StreamReader(filename, System.Text.Encoding.GetEncoding("shift_jis"))) {
string line;
Row row = new Row(this);
while ((line = reader.ReadLine()) != null)
{
string[] token = line.Split('\t');
row.Set("meisai_id", CSVParser.ReadInt(token[1]));
row.Set("kaikei_tanni", CSVParser.ReadInt(token[2]));
row.Set("keiri_kubun", CSVParser.ReadInt(token[3]));
row.Set("torihiki_kubun", CSVParser.ReadInt(token[4]));
row.Set("kihyoubi", CSVParser.ReadDate(token[5]));
row.Set("karikata_kamoku_id", CSVParser.ReadInt(token[6]));
row.Set("karikata_hojo_id", CSVParser.ReadInt(token[7]));
row.Set("karikata_hojo_seiri", CSVParser.ReadInt(token[8]));
row.Set("karikata_kingaku", CSVParser.ReadAmount(token[9]));
row.Set("kashikata_kamoku_id", CSVParser.ReadInt(token[10]));
row.Set("kashikata_hojo_id", CSVParser.ReadInt(token[11]));
row.Set("kashikata_hojo_seiri", CSVParser.ReadInt(token[12]));
row.Set("kashikata_kingaku", CSVParser.ReadAmount(token[13]));
row.Set("tekiyou_id", CSVParser.ReadInt(token[14]));
row.Set("comment", CSVParser.ReadString(token[15]));
row.Set("denpyou_kakunin", CSVParser.ReadBool(token[16]));
row.Set("kihyoubi_gengou", CSVParser.ReadString(token[17]));
row.Set("kihyoubi_year", CSVParser.ReadInt(token[18]));
row.Set("kihyoubi_month", CSVParser.ReadInt(token[19]));
row.Set("kihyoubi_day", CSVParser.ReadInt(token[20]));
row.Set("karikata_kamoku_code", CSVParser.ReadString(token[21]));
row.Set("kashikata_kamoku_code", CSVParser.ReadString(token[22]));
row.Set("kessan_syuuryou", CSVParser.ReadBool(token[23]));
row.Set("denpyou_bangou", CSVParser.ReadString(token[25]));
row.Set("denpyou_renban", CSVParser.ReadInt(token[26]));
row.Set("hojo_kamoku_touroku", CSVParser.ReadString(token[28]));
row.Set("created_at", CSVParser.ReadDate(token[24]));
row.Set("updated_at", CSVParser.ReadDate(token[27]));
row.Set("denpyou_bangou_cache", CSVParser.ReadString(token[25]));
row.Set("editing", false);
this.Insert(row);
}
}
OwnerDB.CommitTransaction();
}
virtual public void LoadCSV(string filename)
{
OwnerDB.BeginTransaction();
using (var reader = new System.IO.StreamReader(filename, System.Text.Encoding.GetEncoding("shift_jis"))) {
string line;
Row row = new Row(this);
while ((line = reader.ReadLine()) != null)
{
string[] token = line.Split('\t');
for (int col = 0; col < this.ColumnList.Count; col++)
{
row.Set(this.ColumnList[col].Name, CSVParser.ReadColumn(token[col], this.ColumnList[col].Type));
}
this.Insert(row);
}
}
OwnerDB.CommitTransaction();
}
override public void LoadCSV(string filename)
{
OwnerDB.BeginTransaction();
using (var reader = new System.IO.StreamReader(filename, System.Text.Encoding.GetEncoding("shift_jis"))) {
string line;
Row row = new Row(this);
while ((line = reader.ReadLine()) != null)
{
string[] token = line.Split('\t');
row.Set("keiri_kubun", CSVParser.ReadInt(token[1]));
row.Set("nenndo", CSVParser.ReadDate(token[2]));
row.Set("hojo_id", CSVParser.ReadInt(token[3]));
row.Set("zenki_kurikoshi_gaku", CSVParser.ReadAmount(token[4]));
row.Set("taisyaku_kubun", CSVParser.ReadString(token[5]));
this.Insert(row);
}
}
OwnerDB.CommitTransaction();
}
// 指定月の伝票番号を設定しなおす
public void RenumberDenpyouBangou(DateTime targetMonth, bool sortWithKaikeiTanni)
{
OwnerDB.BeginTransaction();
string kaikeiKubun = sortWithKaikeiTanni ? "kaikei_kubun, " : "";
string select_sql = string.Format("where kihyoubi_gengou='{0}' and kihyoubi_year={1} and kihyoubi_month={2} " +
"order by {3} kihyoubi, denpyou_renban, id",
helper.Converter.DateTimeToWarekiGengou(targetMonth),
helper.Converter.DateTimeToWarekiYear(targetMonth),
targetMonth.Month,
kaikeiKubun);
int renban = 0;
string prevOriginalDenpyouBangou = null;
foreach (var row in this.Select(select_sql))
{
if (row.IsNull("kihyoubi"))
{
continue;
}
string originalDenpyouBangou = row.GetStr("denpyou_bangou", "");
if (prevOriginalDenpyouBangou != originalDenpyouBangou)
{
renban++;
}
this.SetColumnValue(row, "denpyou_renban", renban);
string bangou = this.FormatDenpyouBangou(row.GetDate("kihyoubi").Value, renban);
row.Set("denpyou_bangou_cache", bangou);
row.Set("denpyou_bangou", bangou);
this.Update(row);
prevOriginalDenpyouBangou = originalDenpyouBangou;
}
OwnerDB.CommitTransaction();
}
