コード例 #1
0
        /// <summary>
        /// 产生对账明细
        /// </summary>
        /// <param name="hb">行别</param>
        /// <param name="model">请求报文</param>
        /// <param name="outFileName">产生的对账文件</param>
        private void GenerateDuiZhangDetail(string hb, WtwyzzjcdzModel model, out string outFileName)
        {
            string fileName = "";

            fileName += "11";//机构码
            fileName += "G501";
            fileName += "_W";

            DateTime dt      = new DateTime();
            string   strDate = dt.ToString("yyyyMMdd");

            fileName += strDate;
            fileName += ".";
            fileName += "380910";//6位银行代号

            outFileName = fileName;

            string filePath = BasicOperation.GetFilePath(hb) + fileName;//文件的完整路径


            List <ZbmxzModel> list = db2Operation.GetZbmxzByJyrq(model.Qsrq, model.Zzrq);

            FileStream fs = new FileStream(filePath, FileMode.OpenOrCreate, FileAccess.Write);

            using (StreamWriter sw = new StreamWriter(fs, Encoding.GetEncoding("gb2312")))
            {
                string summaryLine = string.Empty;
                summaryLine += model.Yhzh;
                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);
                }
            }
        }
コード例 #2
0
        /// <summary>
        /// 业务处理详情
        /// </summary>
        /// <param name="hb">行别</param>
        /// <param name="model">请求报文</param>
        private void ExecuteDetail(string hb, XezfdkModel model)
        {
            //具体处理过程;
            //从ftp服务器取文件,本程序中是从本机读取;
            string        fileFromPath = BasicOperation.GetFilePath(hb);
            string        inputLine    = "";
            StringBuilder outputLine;

            DateTime dt       = DateTime.Now;
            string   strDate  = dt.ToString("yyyyMMdd");
            string   tail     = model.Wjmc.Substring(4);
            string   outFile  = "HRB_" + tail;//返回文件的名称 ;
            string   filePath = fileFromPath + outFile;

            using (StreamReader sr = new StreamReader(fileFromPath + model.Wjmc, Encoding.GetEncoding("gb2312")))
            {
                inputLine = sr.ReadLine();//读取第一行汇总数据;
                FileStream fs = new FileStream(filePath, FileMode.OpenOrCreate, FileAccess.Write);
                using (StreamWriter sw = new StreamWriter(fs, Encoding.GetEncoding("gb2312")))
                {
                    sw.WriteLine(inputLine);
                }
                for (int i = 1; i <= Convert.ToInt32(model.Zbs); i++)
                {
                    inputLine = sr.ReadLine();

                    string[] inputArray = inputLine.Split(new char[] { '~' });
                    string   kkzt       = BatchWithHolding(1); //扣款状态,全部返回成功;
                    string   kkxx       = "0" + kkzt;          //扣款信息;
                    //生成银行流水号;
                    string yhlsh = "";
                    yhlsh += strDate;
                    if (i < 10)
                    {
                        yhlsh += "0";
                    }
                    yhlsh += i.ToString();

                    outputLine = new StringBuilder();
                    outputLine.Append("M~");
                    outputLine.Append(inputArray[1]);
                    outputLine.Append("~");
                    outputLine.Append(inputArray[2]);
                    outputLine.Append("~");
                    outputLine.Append(inputArray[3]);
                    outputLine.Append("~");
                    outputLine.Append(inputArray[4]);
                    outputLine.Append("~");
                    outputLine.Append(inputArray[5]);
                    outputLine.Append("~");
                    outputLine.Append(inputArray[6]);
                    outputLine.Append("~");
                    outputLine.Append(inputArray[7]);
                    outputLine.Append("~");
                    outputLine.Append(inputArray[8]);
                    outputLine.Append("~");
                    outputLine.Append(kkzt);
                    outputLine.Append("~");
                    outputLine.Append(kkxx);
                    outputLine.Append("~");
                    outputLine.Append(i.ToString());//汇划报文顺序号
                    outputLine.Append("~");
                    outputLine.Append(yhlsh);
                    outputLine.Append("~");
                    outputLine.Append(strDate);
                    outputLine.Append("~");
                    outputLine.Append(inputArray[9]);
                    outputLine.Append("~");
                    outputLine.Append(inputArray[10]);
                    outputLine.Append("~");
                    outputLine.Append(inputArray[11]);
                    outputLine.Append("~");

                    using (StreamWriter sw = new StreamWriter(filePath, true, Encoding.GetEncoding("gb2312")))
                    {
                        sw.WriteLine(outputLine.ToString());
                    }

                    //更新账表分户账和账表明细账
                    UpdateZbInfo(BasicOperation.GetExecutePermission(), inputArray);
                }
            }

            //模拟前置机动作:更新djplzxzf的zt字段;
            string command = "update djplzxzf set zt='3' where djhm='" + model.Pch + "'";

            db2Operation.ExecuteDB2Update(command);
        }
コード例 #3
0
        /// <summary>
        /// 生成贷款批量处理文件
        /// </summary>
        /// <param name="hb">行别</param>
        /// <param name="model">请求报文</param>
        private void LoanBatchWithDrawDetail(string hb, DkplshfqModel model)
        {
            //从ftp服务器取文件,本程序中是从本机读取;
            string        fileFromPath = BasicOperation.GetFilePath(hb);;
            string        inputLine    = "";
            StringBuilder outputLine;

            DateTime dt       = DateTime.Now;
            string   strDate  = dt.ToString("yyyyMMdd");
            string   tail     = model.Wjmc.Substring(3);
            string   outFile  = "DKR" + tail;//返回文件的名称 ;
            string   filePath = fileFromPath + outFile;

            using (StreamReader sr = new StreamReader(fileFromPath + model.Wjmc, Encoding.GetEncoding("gb2312")))
            {
                inputLine = sr.ReadLine();//读取第一行汇总数据;
                string[] s = inputLine.Split(new char[] { '~' });
                s[3]       = s[2];
                inputLine  = s[0] + "~";
                inputLine += s[1];
                inputLine += "~";
                inputLine += s[2];
                inputLine += "~";
                inputLine += s[3];
                inputLine += "~";
                FileStream fs = new FileStream(filePath, FileMode.OpenOrCreate, FileAccess.Write);
                using (StreamWriter sw = new StreamWriter(fs, Encoding.GetEncoding("gb2312")))
                {
                    sw.WriteLine(inputLine);
                }

                for (int i = 1; i <= Convert.ToInt32(model.Zjls); i++)
                {
                    inputLine = sr.ReadLine();

                    string[] inputArray = inputLine.Split(new char[] { '~' });

                    outputLine = new StringBuilder();
                    outputLine.Append("M~");
                    outputLine.Append(inputArray[1]);
                    outputLine.Append("~");
                    outputLine.Append(inputArray[2]);
                    outputLine.Append("~");
                    outputLine.Append(inputArray[3]);
                    outputLine.Append("~");
                    outputLine.Append(inputArray[3]);
                    outputLine.Append("~");
                    outputLine.Append(inputArray[5]);
                    outputLine.Append("~");
                    outputLine.Append(inputArray[6]);
                    outputLine.Append("~");
                    outputLine.Append("0000");//银行扣款的状态标志;
                    outputLine.Append("~");

                    outputLine.Append(inputArray[8]);
                    outputLine.Append("~");
                    outputLine.Append(inputArray[9]);
                    outputLine.Append("~");
                    outputLine.Append(inputArray[10]);
                    outputLine.Append("~");
                    outputLine.Append(inputArray[11]);
                    outputLine.Append("~");
                    outputLine.Append(inputArray[12]);
                    outputLine.Append("~");
                    outputLine.Append(inputArray[13]);
                    outputLine.Append("~");


                    using (StreamWriter sw = new StreamWriter(filePath, true, Encoding.GetEncoding("gb2312")))
                    {
                        sw.WriteLine(outputLine.ToString());
                    }
                }
            }
            Console.WriteLine("文件处理成功");

            //模拟前置机动作:更新djplzxzf的zt字段;
            string command = "update djplzxzf set zt='3' where djhm='" + model.Pch + "'";

            db2Operation.ExecuteDB2Update(command);
        }
コード例 #4
0
        /// <summary>
        /// 产生对账明细
        /// </summary>
        private void GenerateDuiZhangDetail(string hb, out string outFileName)
        {
            string strDate  = DateTime.Now.ToShortDateString();
            string fileName = "";

            fileName   += model.Jgm;
            fileName   += "Z";//支取
            fileName   += "_W";
            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);
                }
            }
        }
コード例 #5
0
        /// <summary>
        /// 银行日记账对账--生成对账明细
        /// </summary>
        /// <param name="whichBank">行别</param>
        /// <param name="transcationCode">交易码</param>
        /// <param name="bankCount">银行账号</param>
        /// <param name="qsrq">起始日期</param>
        /// <param name="zzrq">终止日期</param>
        /// <returns>对账文件名称</returns>
        private string GenetrateCountCheckingFile(string whichBank, string transcationCode, string bankCount, string qsrq, string zzrq)
        {
            string fileName = string.Empty;

            fileName += "YHDZ";
            fileName += bankCount;
            fileName += "_";
            fileName += qsrq;
            fileName += "_";
            fileName += zzrq;

            //详细文件内容
            List <ZbmxzModel> list     = db2Operation.GetZbmxzByJyrq(model.Qsrq, model.Zzrq);
            string            filePath = BasicOperation.GetFilePath(whichBank) + fileName;//文件的完整路径

            FileStream fs = new FileStream(filePath, FileMode.OpenOrCreate, FileAccess.Write);

            //明细行
            for (int i = 1; i <= list.Count; i++)
            {
                string detailLine = string.Empty;
                detailLine += "M";
                detailLine += "~";
                detailLine += "杭州住房公积金管理中心萧山分中心";//账户名称,需要修改
                detailLine += "~";
                detailLine += list[i].Zh;
                detailLine += "~";
                detailLine += list[i].Yhls;
                detailLine += "~";
                detailLine += list[i].Pjhm;
                detailLine += "~";
                detailLine += list[i].Jyrq;
                detailLine += "~";
                detailLine += list[i].Jysj;
                detailLine += "~";
                detailLine += "划款";//摘要
                detailLine += "~";
                detailLine += list[i].Jdbz;
                detailLine += "~";
                detailLine += list[i].Fse;
                detailLine += "~";
                detailLine += list[i].Ye;
                detailLine += "~";
                detailLine += list[i].Dfhm;
                detailLine += "~";
                detailLine += list[i].Dfzh;
                detailLine += "~";

                using (StreamWriter sw = new StreamWriter(filePath, true, Encoding.GetEncoding("gb2312")))
                {
                    sw.WriteLine(detailLine);
                }

                //汇总行
                using (StreamWriter sw = new StreamWriter(fs, Encoding.GetEncoding("gb2312")))
                {
                    string summaryLine = string.Empty;
                    summaryLine += "H";
                    summaryLine += "~";
                    summaryLine += Encoding.Default.GetString(modelMsg.Hzjfbs);  //借方笔数
                    summaryLine += "~";
                    summaryLine += Encoding.Default.GetString(modelMsg.Hzjffsz); //借方发生额
                    summaryLine += "~";
                    summaryLine += Encoding.Default.GetString(modelMsg.Hzdfbs);  //贷方笔数
                    summaryLine += "~";
                    summaryLine += Encoding.Default.GetString(modelMsg.Hzdffse); //贷方发生额
                    summaryLine += "~";
                    summaryLine += "435654";                                     //余额
                    summaryLine += "~";
                    sw.WriteLine(summaryLine);                                   //汇总行
                }
            }

            return(fileName);
        }