- 论坛徽章:
- 0
|
这个意思是:
这是一个银行员工记任务的一个东东,文件(aaa)是记账号的文件,分别是,账号,储户名,员工名, ,,,,,,我要做一个记录员工每次吸储金资的东东,并把它生成一个表格,如(bbb),
首先我有一些今天发生的账号(不知道是不是吸储的)得去aaa中查询,有没有这个账号,要是有的话就输入金额,(有可能是存入有可能是支取),
还有一些是当天发生的吸储账号,得打"账号,储户名,员工名" 加入到aaa中.并且把"账号,储户名,员工名,金额:加入到生成的bbb中.
最后计算出存入合计,支取合计,存支款差额,
数据文件:名为:wys
- ┃ 账号 ┃储户名┃吸储名┃
- ┃000000000000180┃徐云霞┃王志权┃
- ┃000000000000206┃ ┃包庆国┃
- ┃000000000000313┃ ┃王林森┃
- ┃000000000000511┃ ┃刘冬梅┃
- ┃000000000000578┃ ┃陈 军┃
- ┃000000000000651┃ ┃王瑰琦┃
- ┃000000000000727┃ ┃王志权┃
- ┃000000000000784┃谢亚臣┃陈锦旗┃
- ┃000000000000792┃刘占忠┃何淑清┃
- ┃000000000000875┃卢 晶┃于 勇┃
- ┃000000000000883┃王秀娟┃刘 北┃
- ┃000000000000990┃ ┃张野怀┃
- ┃000000000001253┃ ┃刘占忠┃
- ┃000000000001634┃徐云霞┃王志权┃
- ┃000000000001675┃ ┃王志权┃
- ┃000000000001923┃付 会┃陈 军┃
- ┃000000000002095┃ ┃宁宝南┃
- ┃000000000002111┃ ┃李 岩┃
- ┃000000000002137┃王玉民┃李海龙┃
- ┃000000000002673┃肖 坤┃董建海┃
- ┃000000000002749┃ ┃李海龙┃
- ┃000000000002947┃李雪峰┃杨书慧┃
- ┃000000000003135┃ ┃李文波┃
- ┃000000000003150┃ ┃佟国权┃
- ┃000000000003168┃ ┃林雪冰┃
- ┃000000000003382┃ ┃王东风┃
- ┃000000000003580┃ ┃吕国香┃
- ┃000000000003622┃ ┃李 祥┃
- ┃000000000003950┃ ┃肖 臻┃
- ┃000000000004091┃ ┃杨 光┃
- ┃000000000004257┃金桂玲┃刘春珍┃
复制代码
查询文件:名为:add
- setcolor hi_white
- clear
- echo "[1;20H 万 元 赛 管 理 程 序
- ┏━━━━━━━━┳━━━━━━━━━┓
- ┃ 账户名 ┃ 0000000 ________ ┃ 不
- ┣━━━━━┳━━╋━━━━━┳━━━┫ 要
- ┃是否新录入┃是 0/否 1/退出 2┃ ┃ 按
- ┣━━━┳━┻━━━━━━━┳┻━━━┫ 上
- ┃储户名┃三字3 二字2 空0: ┃ ┃ 下
- ┣━━━╋━━━━━━━━━╋━━━━┫ 左
- ┃吸储名┃三字3 二字2 空0: ┃ ┃ 右
- ┣━━━┻━━━━┳━━━━╋━━━━┫ 键
- ┃ 账号 ┃ 储户名 ┃ 吸储名 ┃
- ┣━━━━━━━━╋━━━━╋━━━━┫ 如
- ┃ ┃ ┃ ┃ 按
- ┣━━━━━━━━╋━━━━┻━━━━┫ 则
- ┃ 是否提交数据 ┃ (是 0/否 1): ┃ 退
- ┣━━━━━━━━╋━━━━━━━━━┫ 出
- ┃ 是否录入 ┃ (是 0/否 1): ┃ 从
- ┣━━━━━━━━╋━━━━━━━━━┫ 进
- ┃ 存入金额 ┃ ┃ !
- ┣━━━━━━━━╋━━━━━━━━━┫
- ┃ 支取金额 ┃ ┃
- ┗━━━━━━━━┻━━━━━━━━━┛
- 要输入账号为00000123的不要输入前面的0输123,如是:30000123的八位全须输入 "
- echo "[3;45H\c"
- read asd
- aaa=0000000$asd
- sed -n "/${aaa}/p" wys >whta1
- sed 's/^/ /g' whta1>whta2
- sed 's/$/ @_@ /g' whta2>whta3
- echo
- echo
- echo
- echo
- echo
- echo
- echo
- echo
- echo
- cat whta3
- echo "[22;61H
- 如在上面查询到账号姓名,选1.无记录 选0 进行添加 如输入错误选2. "
- echo "[5;51H\c"
- read ynlr
- if [ $ynlr = 0 ]
- then
- a1="┃"
- a2=" "
- a3=" "
- a4=" "
- echo "[22;61H
- 如 储户名为三个字则选3,二个字选2,没有储户名的选0 "
- echo "[7;43H\c"
- read zs
- if [ $zs = 3 ]
- then
- echo "[7;46H\c"
- read chm
- elif [ $zs = 2 ]
- then
- echo "[7;46H\c"
- read chm
- chm=$chm$a3
- elif [ $zs = 0 ]
- then
- chm=$a4
- fi
- echo "[22;61H
- 如 吸储名为三个字则选3,二个字选2,没有储户名的选0 "
- echo "[9;43H\c"
- read zs1
- if [ $zs1 = 3 ]
- then
- echo "[9;46H\c"
- read xcm
- elif [ $zs1 = 2 ]
- then
- echo "[9;46H\c"
- read xcm
- xcm=$xcm$a3
- elif [ $zs1 = 0 ]
- then
- xcm=$a4
- fi
- echo "$a1$aaa$a2$a1$a2$chm$a2$a1$a2$xcm$a2$a1" >>wysls1
- sed 's/.\[A//g' wysls1 > wysls2
- sed 's/.\[B//g' wysls2 > wysls3
- sed 's/.\[C//g' wysls3 > wysls4
- sed 's/.\[D//g' wysls4 > wysls
- rm wysls1
- rm wysls2
- rm wysls3
- rm wysls4
- echo
- echo
- echo
- sed -n "/${aaa}/p" wysls >wht1
- sed 's/^/ /g' wht1>wht2
- sed 's/$/ @_@ /g' wht2>wht3
- sed -n /4371/p wht3
- echo "[22;61H
- 如上面显示的输入无误,按0提交数据库.错误则选 1 取消输入 "
- echo "[15;51H\c"
- read wystj
- if [ $wystj = 0 ]
- then
- cat wysls >> wys
- elif [ $ywstj = 1 ]
- then
- quit
- fi
- echo "[22;61H
- 选 0 则进行存取款录入. 1 则取消录入 "
- echo "[17;51H\c"
- read yonn
- if [ $yonn = 0 ]
- then
- echo "[22;61H
- 输入储户存入金额, 如无存入输入 0 "
- echo "[19;36H\c"
- read cr
- echo "$cr" >>cr
- if [ $cr = 0 ]
- then
- cr=" ┃"
- fi
- sed -n "/${aaa}/p" wys >ls1
- sed 's/$/ /g' ls1 >ls2
- sed "s/$/${cr}/g" ls2 >ls3
- sed 's/ //g' ls3 > ls4
- echo "[22;61H
- 输入储户支取金额, 如无存入输入 0 "
- echo "[21;36H\c"
- read zq
- echo "$zq" >>zq
- if [ $zq = 0 ]
- then
- zq=" "
- fi
- sed 's/$/ /g' ls4 >ls5
- sed "s/$/${zq}/g" ls5 >ls6
- sed 's/ //g' ls6 > cca
- cat wyzhong >> wydy
- cat cca >> wydy
- rm ls*
- else
- rm wysls*
- rm ls*
- rm wht*
- quit
- fi
- rm ls*
- rm wht*
- elif [ $ynlr = 1 ]
- then
- echo "[22;61H
- 输入储户存入金额, 如无存入输入 0 "
- echo "[19;36H\c"
- read cr
- echo "$cr" >>cr
- if [ $cr = 0 ]
- then
- cr=" ┃"
- fi
- sed -n "/${aaa}/p" wys >ls1
- sed 's/$/ /g' ls1 >ls2
- sed "s/$/${cr}/g" ls2 >ls3
- sed 's/ //g' ls3 > ls4
- echo "[22;61H
- 输入储户支取金额, 如无存入输入 0 "
- echo "[21;36H\c"
- read zq
- echo "$zq" >>zq
- if [ $zq = 0 ]
- then
- zq=" "
- fi
- sed 's/$/ /g' ls4 >ls5
- sed "s/$/${zq}/g" ls5 >ls6
- sed 's/ //g' ls6 > cca
- cat wyzhong >> wydy
- cat cca >> wydy
- rm ls*
- rm wht*
- elif [ $ynlr = 2 ]
- then
- quit
- fi
- echo "[9;20H
- ┏━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┓
- ┃ 你输入的是: ┃
- ┣━━━━━━━━┳━━━━┳━━━━┳━━━━━━━┳━━━━━━━━┫
- ┃ 账号 ┃ 储户名 ┃ 吸储名 ┃ 存入 ┃ 支取 ┃
- ┣━━━━━━━━╋━━━━╋━━━━╋━━━━━━━╋━━━━━━━━┫
- ┃ ┃ ┃ ┃ ┃ ┃
- ┗━━━━━━━━┻━━━━┻━━━━┻━━━━━━━┻━━━━━━━━┛"
- echo "[14;20H"
- cat cca
- rm cca
- read wwjjkk
复制代码
计算组件:名为:jj
- sed 's/.\[A//g' cr > csab1
- sed 's/.\[B//g' csab1 > csab2
- sed 's/.\[C//g' csab2 > csab3
- sed 's/.\[D//g' csab3 > csab4
- sed '/^$/d' cr csad4> jsab5
- sed 's/,//' csab5 > csab6
- sed 's/\.//' csab6 > csa
- sed 's/.\[A//g' zq > csb1
- sed 's/.\[B//g' csb1 > csb2
- sed 's/.\[C//g' csb2 > csb3
- sed 's/.\[D//g' csb3 > csb4
- sed 's/\.//' csb4 > csb5
- sed 's/,//' csb5 > cs
- ha=`awk 'BEGIN {sum=0} {sum+=$1} END {print sum}' csa`
- hb=`awk 'BEGIN {sum=0} {sum+=$1} END {print sum}' cs`
- aa=$ha
- a8=`echo "$aa"|cut -c1`
- if [ $a8 = - ]
- then
- a9=`echo "$aa"|cut -c2`
- a0=`echo "$aa"|sed 's/^..//'`
- a1=`echo "$a0"|sed 's/\(..\)$/.\1/g'`
- a2=`echo "$a1"|sed 's/\(......\)$/,\1/g'`
- a3=`echo "$a2"|sed 's/\(..........\)$/,\1/g'`
- a4=`echo "$a3"|sed 's/\(..............\)$/,\1/g'`
- a5=`echo "$a4"|sed 's/\(..................\)$/,\1/g'`
- a6=`echo "$a5"|sed 's/\(......................\)$/,\1/g'`
- a7=`echo "$a6"|sed 's/\(..........................\)$/,\1/g'`
- ha=$a8$a9$a7
- else
- a0=`echo "$aa"|sed 's/^.//'`
- a1=`echo "$a0"|sed 's/\(..\)$/.\1/g'`
- a2=`echo "$a1"|sed 's/\(......\)$/,\1/g'`
- a3=`echo "$a2"|sed 's/\(..........\)$/,\1/g'`
- a4=`echo "$a3"|sed 's/\(..............\)$/,\1/g'`
- a5=`echo "$a4"|sed 's/\(..................\)$/,\1/g'`
- a6=`echo "$a5"|sed 's/\(......................\)$/,\1/g'`
- a7=`echo "$a6"|sed 's/\(..........................\)$/,\1/g'`
- ha=$a8$a7
- fi
- aa=$hb
- a8=`echo "$aa"|cut -c1`
- if [ $a8 = - ]
- then
- a9=`echo "$aa"|cut -c2`
- a0=`echo "$aa"|sed 's/^..//'`
- a1=`echo "$a0"|sed 's/\(..\)$/.\1/g'`
- a2=`echo "$a1"|sed 's/\(......\)$/,\1/g'`
- a3=`echo "$a2"|sed 's/\(..........\)$/,\1/g'`
- a4=`echo "$a3"|sed 's/\(..............\)$/,\1/g'`
- a5=`echo "$a4"|sed 's/\(..................\)$/,\1/g'`
- a6=`echo "$a5"|sed 's/\(......................\)$/,\1/g'`
- a7=`echo "$a6"|sed 's/\(..........................\)$/,\1/g'`
- hb=$a8$a9$a7
- else
- a0=`echo "$aa"|sed 's/^.//'`
- a1=`echo "$a0"|sed 's/\(..\)$/.\1/g'`
- a2=`echo "$a1"|sed 's/\(......\)$/,\1/g'`
- a3=`echo "$a2"|sed 's/\(..........\)$/,\1/g'`
- a4=`echo "$a3"|sed 's/\(..............\)$/,\1/g'`
- a5=`echo "$a4"|sed 's/\(..................\)$/,\1/g'`
- a6=`echo "$a5"|sed 's/\(......................\)$/,\1/g'`
- a7=`echo "$a6"|sed 's/\(..........................\)$/,\1/g'`
- hb=$a8$a7
- fi
- echo "┣━━━━━━━━╋━━━━╋━━━━╋━━━━━━━╋━━━━━━━━┫" >>wydy
- echo "┃ 存款合计 ┃ ┃ ┃ $ha" >>wydy
- echo "┣━━━━━━━━╋━━━━╋━━━━╋━━━━━━━╋━━━━━━━━┫" >>wydy
- echo "┃ 支款合计 ┃ ┃ ┃ ┃ $hb" >>wydy
- ce="`expr $ha - $hb"
- aa=$ce
- a8=`echo "$aa"|cut -c1`
- if [ $a8 = - ]
- then
- a9=`echo "$aa"|cut -c2`
- a0=`echo "$aa"|sed 's/^..//'`
- a1=`echo "$a0"|sed 's/\(..\)$/.\1/g'`
- a2=`echo "$a1"|sed 's/\(......\)$/,\1/g'`
- a3=`echo "$a2"|sed 's/\(..........\)$/,\1/g'`
- a4=`echo "$a3"|sed 's/\(..............\)$/,\1/g'`
- a5=`echo "$a4"|sed 's/\(..................\)$/,\1/g'`
- a6=`echo "$a5"|sed 's/\(......................\)$/,\1/g'`
- a7=`echo "$a6"|sed 's/\(..........................\)$/,\1/g'`
- ce=$a8$a9$a7
- else
- a0=`echo "$aa"|sed 's/^.//'`
- a1=`echo "$a0"|sed 's/\(..\)$/.\1/g'`
- a2=`echo "$a1"|sed 's/\(......\)$/,\1/g'`
- a3=`echo "$a2"|sed 's/\(..........\)$/,\1/g'`
- a4=`echo "$a3"|sed 's/\(..............\)$/,\1/g'`
- a5=`echo "$a4"|sed 's/\(..................\)$/,\1/g'`
- a6=`echo "$a5"|sed 's/\(......................\)$/,\1/g'`
- a7=`echo "$a6"|sed 's/\(..........................\)$/,\1/g'`
- ce=$a8$a7
- fi
- echo "┣━━━━━━━━╋━━━━╋━━━━╋━━━━━━━┻━━━━━━━━┫" >>wydy
- echo "┃ 存支款差额 ┃ ┃ ┃ $ce" >>wydy
- echo "┗━━━━━━━━┻━━━━┻━━━━┻━━━━━━━━━━━━━━━━┛" >>wydy
- echo " " >>wydy
- echo " 负责人: 填表人:" >>wydy
- rm cs*
复制代码
生成的文件
- 市行职工全员吸储核对表
- 2005年01月12日
- ┏━━━━━━━━┳━━━━┳━━━━┳━━━━━━━┳━━━━━━━━┓
- ┃ 账号 ┃ 储户名 ┃ 吸储名 ┃ 储入 ┃ 支取 ┃
- ┣━━━━━━━━╋━━━━╋━━━━╋━━━━━━━╋━━━━━━━━┫
- ┃000000000000883 ┃ 王秀娟 ┃ 刘 北 ┃ 6,000.00
- ┣━━━━━━━━╋━━━━╋━━━━╋━━━━━━━╋━━━━━━━━┫
- ┃000000000088391 ┃ 郭凤芝 ┃ 周 虹 ┃ ┃ 9,990.00
- ┣━━━━━━━━╋━━━━╋━━━━╋━━━━━━━╋━━━━━━━━┫
- ┃ 存款合计 ┃ ┃ ┃ 6,000.00
- ┣━━━━━━━━╋━━━━╋━━━━╋━━━━━━━╋━━━━━━━━┫
- ┃ 支款合计 ┃ ┃ ┃ ┃ 9,990.00
- ┣━━━━━━━━╋━━━━╋━━━━╋━━━━━━━┻━━━━━━━━┫" >>wydy
- ┃ 存支款差额 ┃ ┃ ┃ -3,990.00
- ┗━━━━━━━━┻━━━━┻━━━━┻━━━━━━━━━━━━━━━━┛
复制代码
以上是要sco unix 5.05中的文件考贝!在这里格式不正确对不整!!!
可不可以生成这样的啊!
- 某某某某某某某某某某某某收支对应表
- "当前的日期"如: 2005年2月2日
- ┏━━━━━━━━━━━┳━━━┳━━━┳━━━━━━━┳━━━━━┓
- ┃_____用户编号_____.┃用户一┃用户二┃_____收入__.┃__支出__.┃
- ┣━━━━━━━━━━━╋━━━╋━━━╋━━━━━━━╋━━━━━┫
- ┃ 2004010100000002┃小甜甜┃大甜甜┃10,000.00__.┃_______.┃
- ┣━━━━━━━━━━━╋━━━╋━━━╋━━━━━━━╋━━━━━┫
- ┃ 2004010100000002┃小甜甜┃大甜甜┃__________.┃1,000.00.┃
- ┅┅┅┅┅┅┅
- ┃ _____收支合计_____┃____┃_____┃10,000.00__.┃1,000.00.┃
- ┣━━━━━━━━━━━━━━━━━━━╋━━━━━━━━━━━━━┫
- ┃ _____收支差额_________________┃9,000.00____________.┃
- ┗━━━━━━━━━━━━━━━━━━━┻━━━━━━━━━━━━━┛
- 上边的"_"下划线和有的"."是占位用!
- 且表中不可以出现Tab键,出现会有很大的问题!
复制代码 |
|