/// <summary>
/// 更新账表分户账和账表明细账
/// </summary>
private void UpdateZbInfo(bool execPermission, string[] lineArray)
{
if (execPermission)
{
ZbfhzModel zbfhz = new ZbfhzModel();
ZbmxzModel zbmxz = new ZbmxzModel();
zbmxz.Zh = lineArray[5];
int iBs = db2Operation.GetCountByZh(zbmxz);
zbmxz.Bc = (iBs + 1).ToString();
zbmxz.Fse = lineArray[3];
Random radom = new Random();
zbmxz.Yhls = BasicOperation.GenerateLongBankSerialNum(radom.Next(99));
zbmxz.Yhls = model.Pch;
zbmxz.Pjhm = lineArray[10];
zbmxz.Jdbz = "2";
zbmxz.Ywlx = "1";
zbmxz.Dfzh = lineArray[2];
zbmxz.Dfhm = lineArray[3];
zbmxz.Zxjsh = lineArray[1];
zbmxz.Rqrq = db2Operation.GetDjrqrq();
zbfhz.Yhzh = zbmxz.Zh;
zbfhz.Bs = zbmxz.Bc;
zbfhz.Hm = lineArray[6];
db2Operation.UpateZbfhzAndZbmxz(zbmxz, zbfhz);
}
}
/// <summary>
/// 更新账表分户账和账表明细账
/// </summary>
private void UpdateZbInfo(bool execPermission)
{
if (execPermission)
{
ZbfhzModel zbfhz = new ZbfhzModel();
ZbmxzModel zbmxz = new ZbmxzModel();
zbmxz.Zh = model.Skrzh;
int iBs = db2Operation.GetCountByZh(zbmxz);
zbmxz.Bc = (iBs + 1).ToString();
zbmxz.Fse = model.Je;
zbmxz.Yhls = Encoding.Default.GetString(bhsszfMsg.Yhls);
zbmxz.Pjhm = model.Pch;
zbmxz.Jdbz = "2";
zbmxz.Ywlx = "1";
zbmxz.Dfzh = model.Fkrzh;
zbmxz.Dfhm = model.Fkrmc;
zbmxz.Zxjsh = model.Fkrzh;
zbmxz.Rqrq = db2Operation.GetDjrqrq();
zbfhz.Yhzh = zbmxz.Zh;
zbfhz.Bs = zbmxz.Bc;
zbfhz.Hm = model.Skrmc;
db2Operation.UpateZbfhzAndZbmxz(zbmxz, zbfhz);
}
}
/// <summary>
/// 产生对账明细
/// </summary>
private void GenerateDuiZhangDetail(string hb, out string outFileName)
{
string fileName = "";
fileName += model.Jgm;
fileName += "G50";
fileName += "_W";
DateTime dt = new DateTime();
string strDate = dt.ToString("yyyyMMdd");
fileName += strDate;
fileName += ".";
fileName += "380910";//6位银行代号
outFileName = fileName;
List <ZbmxzModel> list = db2Operation.GetZbmxzByRqrq(db2Operation.GetDjrqrq());
string filePath = BasicOperation.GetFilePath(hb) + fileName;//文件的完整路径
FileStream fs = new FileStream(filePath, FileMode.OpenOrCreate, FileAccess.Write);
using (StreamWriter sw = new StreamWriter(fs, Encoding.GetEncoding("gb2312")))
{
//汇总行：机构码,交易日期,总金额,总笔数
string summaryLine = string.Empty;
summaryLine += model.Jgm;
summaryLine += ",";
summaryLine += strDate;
summaryLine += ",";
summaryLine += model.Zje;
summaryLine += ",";
summaryLine += model.Zbs;
summaryLine += ",";
sw.WriteLine(summaryLine);
}
//明细行
for (int i = 1; i <= list.Count; i++)
{
string detailLine = string.Empty;
detailLine += i.ToString();
detailLine += ",";
detailLine += list[i].Jyrq;
detailLine += ",";
detailLine += list[i].Jysj;
detailLine += ",";
detailLine += BasicOperation.GenerateBatchCode("110000000", i);//批次号
detailLine += ",";
detailLine += BasicOperation.GenerateName("李", i);
detailLine += ",";
detailLine += list[i].Zh;
detailLine += ",";
detailLine += list[i].Fse;
detailLine += ",";
detailLine += list[i].Yhls; //银行流水
detailLine += ",";
detailLine += list[i].Jdbz; //记账标志
detailLine += ",";
detailLine += list[i].Yhls; //备注中添写银行流水号
detailLine += ",";
using (StreamWriter sw = new StreamWriter(filePath, true, Encoding.GetEncoding("gb2312")))
{
sw.WriteLine(detailLine);
}
}
}
