xyk

Documentation

Index

• Variables
• func Atoi(s string) (result int)
• func CheckErr(err error)
• func CreateDB() (err error)
• func DateAdd(date string, days int) (result string)
• func Exec(e Execer, sql string, args ...interface{})
• func ExecMany(e Execer, sql string, scanner Scanner)
• func Export()
• func Load()
• func NextDay(date string) string
• func Open() (db sqlite3.DB)
• func PrevDay(date string) string
• func Query(sql string)
• func ReadAll(file *zip.File, isGbk bool) (data []byte, err error)
• func Split(bytes []byte, list []int) (result []string)
• func SplitData(bytes []byte, offsets []int, columns []int) (result []string)
• type Execer
• type Reader
  • func OpenReader(path string) (reader *Reader, err error)
  • func (r *Reader) CheckFileList() (result bool)
  • func (r *Reader) ChongZheng(tx Execer)
  • func (r *Reader) Close() error
  • func (r *Reader) LoadACOMA(path *zip.File, tx Execer)
  • func (r *Reader) LoadAFCP(path *zip.File, tx Execer)
  • func (r *Reader) LoadEve(tx Execer)
  • func (r *Reader) LoadICOMN(path *zip.File, tx Execer)
  • func (r *Reader) LoadIERR(path *zip.File, tx Execer)
  • func (r *Reader) LoadITFL(path *zip.File, tx Execer)
  • func (r *Reader) LoadInds(tx Execer)
  • func (r *Reader) LoadJorj(tx Execer)
  • func (r *Reader) LoadRd1002(tx Execer)
  • func (r *Reader) LoadTrac(tx Execer)
• type Scanner

Variables

var COMA = []int{0, 11, 23, 30, 41, 61, 74, 88, 100, 105, 112, 117, 126, 142, 155, 158,
	165, 177, 184, 187, 191, 204, 217, 230, 232, 236, 238, 240, 251, 263, 265,
	268, 272, 285, 299, 311, 327, 332, 335, 376, 381, 390, 413, 422, 434, 457,
	479, 488, 500, 523, 545, 567, 589, 611, 621, 631, 641, 650, 673, 714}

COMA coma 文件分割

var COMAR = []int{2, 3, 57, 5, 8, 9, 17, 27}

COMAR coma

var CreateSQL string = `` /* 1787-byte string literal not displayed */

CreateSQL 创建数据库语句

var Home string

Home 本程序的家目录

Functions

func Atoi

func Atoi(s string) (result int)

Atoi 字符串转换成整数

func CheckErr

func CheckErr(err error)

CheckErr 检查错误，如有错误直接 panic

func CreateDB

func CreateDB() (err error)

CreateDB 创建数据库

func DateAdd

func DateAdd(date string, days int) (result string)

DateAdd 增加日期

func Exec

func Exec(e Execer, sql string, args ...interface{})

Exec 执行一条 SQL 语句

func ExecMany

func ExecMany(e Execer, sql string, scanner Scanner)

ExecMany 执行多条语句

func Export

func Export()

Export 导出报表

func Load

func Load()

Load 导入文件

func NextDay

func NextDay(date string) string

NextDay 下一天

func Open

func Open() (db sqlite3.DB)

Open 打开数据库连接

func PrevDay

func PrevDay(date string) string

PrevDay 上一天

func Query

func Query(sql string)

Query 执行SQL查询，并输出

func ReadAll

func ReadAll(file *zip.File, isGbk bool) (data []byte, err error)

ReadAll 读取压缩包内文件

func Split

func Split(bytes []byte, list []int) (result []string)

Split 拆分数据

func SplitData

func SplitData(bytes []byte, offsets []int, columns []int) (result []string)

SplitData 拆分数据

Types

type Execer

type Execer interface {
	Exec(string, ...interface{}) (sql.Result, error)
	Prepare(string) (*sql.Stmt, error)
	Query(string, ...interface{}) (*sql.Rows, error)
}

Execer 可以执行语句

type Reader

type Reader struct {
	// contains filtered or unexported fields
}

Reader zip 文件读取

func OpenReader

func OpenReader(path string) (reader *Reader, err error)

OpenReader 打开压缩包

func (*Reader) CheckFileList

func (r *Reader) CheckFileList() (result bool)

CheckFileList 检查文件列表是否齐全

func (*Reader) ChongZheng

func (r *Reader) ChongZheng(tx Execer)

ChongZheng 处理冲正的报文

func (*Reader) Close

func (r *Reader) Close() error

Close 关闭压缩包

func (*Reader) LoadACOMA

func (r *Reader) LoadACOMA(path *zip.File, tx Execer)

LoadACOMA 读取 ACOMA 文件

func (*Reader) LoadAFCP

func (r *Reader) LoadAFCP(path *zip.File, tx Execer)

LoadAFCP 导入 AFCP 文件

func (*Reader) LoadEve

func (r *Reader) LoadEve(tx Execer)

LoadEve 读取 EVE 文件

func (*Reader) LoadICOMN

func (r *Reader) LoadICOMN(path *zip.File, tx Execer)

LoadICOMN 读取 ICOMN 文件

func (*Reader) LoadIERR

func (r *Reader) LoadIERR(path *zip.File, tx Execer)

LoadIERR 读取 IERR 文件

func (*Reader) LoadITFL

func (r *Reader) LoadITFL(path *zip.File, tx Execer)

LoadITFL 导入 ITFL 文件

func (*Reader) LoadInds

func (r *Reader) LoadInds(tx Execer)

LoadInds 读取银联明细数据

func (*Reader) LoadJorj

func (r *Reader) LoadJorj(tx Execer)

LoadJorj 读取 JORJ文件

func (*Reader) LoadRd1002

func (r *Reader) LoadRd1002(tx Execer)

LoadRd1002 读取 RD1002 文件

func (*Reader) LoadTrac

func (r *Reader) LoadTrac(tx Execer)

LoadTrac 读取 TRAC 文件

type Scanner

type Scanner interface {
	Scan() bool
	Read() []interface{}
}

Scanner 扫描器