Exemple #1
0
        public override bool PrintCurrent(BindingSource bs, string result_file)
        {
            DataRowView row = (DataRowView)bs.Current;
            List <Tuple <string, string> > lst = new List <Tuple <string, string> >();

            //Формируем поле LONG_ADDRESS
            string rks   = LookupList.LookupNewNum(Convert.ToString(row["SENDER_BIK"]), "RKC");
            string ind   = LookupList.LookupNewNum(rks, "IND");
            string nnp   = LookupList.LookupNewNum(rks, "NNP");
            string namen = LookupList.LookupNewNum(rks, "NAMEN");
            string tnp   = LookupList.LookupNewNum(rks, "TNP");

            tnp = LookupList.DecodeTNP(tnp);

            string long_addr = ind + ", " + tnp + " " + nnp + ", " + namen;

            lst.Add(new Tuple <string, string>("LONG_ADDRESS", long_addr));
            lst.Add(new Tuple <string, string>("BIK_B", rks));

            string receiver_ko = Convert.ToString(row["RECEIVER_KO"]);

            if (receiver_ko == string.Format("{0:D20}", 0))
            {
                receiver_ko = "";
            }

            /*else if (string.IsNullOrEmpty(receiver_ko))
             *  receiver_ko = string.Format("{0:D20}", 0);*/

            lst.Add(new Tuple <string, string>("RECEIVER_KO", receiver_ko));

            lst.Add(new Tuple <string, string>("RECEIVER_BIK", Convert.ToString(row["RECEIVER_BIK"])));
            string receiver_bill = Convert.ToString(row["RECEIVER_BILL"]);

            if (receiver_bill == string.Format("{0:D20}", 0))
            {
                receiver_bill = "";
            }

            lst.Add(new Tuple <string, string>("RECEIVER_BILL", receiver_bill));

            string summ;
            string summ_kop;

            CommonUtils.PrepareSum(row["RD_SUM"], out summ, out summ_kop);

            lst.Add(new Tuple <string, string>("SUMM", summ));
            lst.Add(new Tuple <string, string>("SUMM_KOP", summ_kop));
            lst.Add(new Tuple <string, string>("RD_NUM", Convert.ToString(row["RD_NUM"])));

            DateTime rd_date = Convert.ToDateTime(row["RD_DATE"]);

            lst.Add(new Tuple <string, string>("RD_DATE", CommonUtils.FormatDate(rd_date)));
            DateTime aviso_date = Convert.ToDateTime(row["CREATE_DATE"]);

            lst.Add(new Tuple <string, string>("AVISO_DATE", CommonUtils.FormatDate(aviso_date)));
            DateTime kpd_date = Convert.ToDateTime(row["KPD_DATE"]);

            lst.Add(new Tuple <string, string>("KPD_DATE", CommonUtils.FormatDate(kpd_date)));

            string sender_ko = Convert.ToString(row["sender_KO"]);

            if (sender_ko == string.Format("{0:D20}", 0))
            {
                sender_ko = "";
            }

            /*else if (string.IsNullOrEmpty(sender_ko))
             *  sender_ko = string.Format("{0:D20}", 0);*/
            lst.Add(new Tuple <string, string>("SENDER_KO", sender_ko));
            lst.Add(new Tuple <string, string>("SENDER_BIK", Convert.ToString(row["SENDER_BIK"])));
            string sender_bill = Convert.ToString(row["SENDER_BILL"]);

            if (sender_bill == string.Format("{0:D20}", 0))
            {
                sender_bill = "";
            }
            lst.Add(new Tuple <string, string>("SENDER_BILL", sender_bill));

            lst.Add(new Tuple <string, string>("NUM", Convert.ToString(row["NUM"])));
            lst.Add(new Tuple <string, string>("KPD", Convert.ToString(row["KPD"])));

            //Определяемся, какой из шаблонов нужен
            string template_name = "";
            string sender_bik    = Convert.ToString(row["SENDER_BIK"]);

            if (sender_bik.Substring(0, 4) == "0475")
            {
                template_name = CommonUtils.GetCurrentDir() + @"\Templates\credit_post_aviso.docx";
            }
            else
            {
                string receiver_bik = Convert.ToString(row["RECEIVER_BIK"]);
                if (receiver_bik.Substring(0, 4) == "0475")
                {
                    template_name = CommonUtils.GetCurrentDir() + @"\Templates\debit_post_aviso.docx";
                }
            }
            if (!string.IsNullOrEmpty(template_name))
            {
                return(ReportOutput.CreateReport(template_name, result_file, lst));
            }
            else
            {
                return(false);
            }
        }
Exemple #2
0
        public override bool PrintCurrent(BindingSource bs, string result_file)
        {
            DataRowView row = (DataRowView)bs.Current;
            List <Tuple <string, string> > lst = new List <Tuple <string, string> >();

            for (int idx = 0; idx < row.Row.Table.Columns.Count - 1; ++idx)
            {
                string val;

                DataColumn col = row.Row.Table.Columns[idx];
                if (col.DataType == typeof(System.DateTime))
                {
                    DateTime dt = Convert.ToDateTime(row[idx]);
                    val = CommonUtils.FormatDate(dt);
                }
                else
                {
                    val = Convert.ToString(row[idx]);
                }

                if (val == string.Format("{0:D20}", 0))
                {
                    val = "";
                }
                lst.Add(new Tuple <string, string>(row.Row.Table.Columns[idx].ColumnName,
                                                   val));
            }

            lst.Add(new Tuple <string, string>("RECEIVER_KO_NAME", Convert.ToString(row["RECEIVER_KO_NAME"])));

            //Формируем поле LONG_ADDRESS
            string rks   = LookupList.LookupNewNum(Convert.ToString(row["SENDER_BIK"]), "RKC");
            string ind   = LookupList.LookupNewNum(rks, "IND");
            string nnp   = LookupList.LookupNewNum(rks, "NNP");
            string namen = LookupList.LookupNewNum(rks, "NAMEN");
            string tnp   = LookupList.LookupNewNum(rks, "TNP");

            tnp = LookupList.DecodeTNP(tnp);

            string long_addr = ind + ", " + tnp + " " + nnp + ", " + namen;

            lst.Add(new Tuple <string, string>("LONG_ADDRESS", long_addr));
            lst.Add(new Tuple <string, string>("BIK_B", rks));

            /*string receiver_ko = Convert.ToString(row["RECEIVER_KO"]);
             * if (string.IsNullOrEmpty(receiver_ko))
             *  receiver_ko = string.Format("{0:D20}", 0);
             *
             * lst.Add(new Tuple<string, string>("RECEIVER_KO", receiver_ko));
             * lst.Add(new Tuple<string, string>("RECEIVER_BIK", Convert.ToString(row["RECEIVER_BIK"])));
             * lst.Add(new Tuple<string, string>("RECEIVER_BILL", Convert.ToString(row["RECEIVER_BILL"])));*/

            string summ;
            string summ_kop;

            CommonUtils.PrepareSum(row["RD_SUM"], out summ, out summ_kop);

            lst.Add(new Tuple <string, string>("SUMM", summ));
            lst.Add(new Tuple <string, string>("SUMM_KOP", summ_kop));
            lst.Add(new Tuple <string, string>("RD_NUM", Convert.ToString(row["RD_NUM"])));

            string is_inn_receiver = "";

            if (!string.IsNullOrEmpty(Convert.ToString(row["RECEIVER_INN"])))
            {
                is_inn_receiver = "ИНН";
            }
            lst.Add(new Tuple <string, string>("IS_INN_RECEIVER", is_inn_receiver));


            string is_kpp_receiver = "";

            if (!string.IsNullOrEmpty(Convert.ToString(row["RECEIVER_KPP"])))
            {
                is_kpp_receiver = "КПП";
            }
            lst.Add(new Tuple <string, string>("IS_KPP_RECEIVER", is_kpp_receiver));


            string is_inn_sender = "";

            if (!string.IsNullOrEmpty(Convert.ToString(row["SENDER_INN"])))
            {
                is_inn_sender = "ИНН";
            }
            lst.Add(new Tuple <string, string>("IS_INN_SENDER", is_inn_sender));


            string is_kpp_sender = "";

            if (!string.IsNullOrEmpty(Convert.ToString(row["SENDER_KPP"])))
            {
                is_kpp_sender = "КПП";
            }
            lst.Add(new Tuple <string, string>("IS_KPP_SENDER", is_kpp_sender));



            //Определяемся, какой из шаблонов нужен
            string template_name = "";
            string sender_bik    = Convert.ToString(row["SENDER_BIK"]);

            if (sender_bik.Substring(0, 4) == "0475")
            {
                template_name = CommonUtils.GetCurrentDir() + @"\Templates\credit_telegraph_aviso.docx";
            }
            else
            {
                string receiver_bik = Convert.ToString(row["RECEIVER_BIK"]);
                if (receiver_bik.Substring(0, 4) == "0475")
                {
                    template_name = CommonUtils.GetCurrentDir() + @"\Templates\debit_telegraph_aviso.docx";
                }
            }
            if (!string.IsNullOrEmpty(template_name))
            {
                return(ReportOutput.CreateReport(template_name, result_file, lst));
            }
            else
            {
                return(false);
            }
        }