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