コード例 #1
0
        /// <summary>
        /// 获取优惠部分
        /// </summary>
        /// <param name="tbAllInvoiceList"></param>
        /// <returns></returns>
        private static FundPart GetFavorPart(DataTable tbAllInvoiceList)
        {
            FundPart favorPart = new FundPart( );
            object   objSum    = tbAllInvoiceList.Compute("Sum(favor_fee)", "");

            favorPart.TotalMoney = Convert.IsDBNull(objSum) ? 0 : Convert.ToDecimal(objSum);

            return(favorPart);
        }
コード例 #2
0
        /// <summary>
        /// 获取实收现金部分
        /// </summary>
        /// <param name="tbAllInvoiceList"></param>
        /// <returns></returns>
        private static FundPart GetCashPart(DataTable tbAllInvoiceList, DataTable tbAllInvoiceDetailList)
        {
            FundPart cashPart = new FundPart( );
            object   objSum   = null;

            //实收现金
            objSum = tbAllInvoiceList.Compute("SUM(money_fee)", "");
            cashPart.TotalMoney = Convert.IsDBNull(objSum) ? 0 : Convert.ToDecimal(objSum);

            DataTable tbChargeInvoiceDetaiList   = tbAllInvoiceDetailList.Clone( );
            DataTable tbRegisterInvoiceDetaiList = tbAllInvoiceDetailList.Clone( );

            //分开挂号和收费的明细
            for (int i = 0; i < tbAllInvoiceDetailList.Rows.Count; i++)
            {
                int flag = Convert.ToInt32(tbAllInvoiceDetailList.Rows[i]["hang_flag"]);
                if (flag == 0)
                {
                    tbRegisterInvoiceDetaiList.Rows.Add(tbAllInvoiceDetailList.Rows[i].ItemArray);
                }
                else
                {
                    tbChargeInvoiceDetaiList.Rows.Add(tbAllInvoiceDetailList.Rows[i].ItemArray);
                }
            }
            //处方收费
            FundInfo fundCharge = new FundInfo( );

            fundCharge.PayName = "处方收费";
            objSum             = tbAllInvoiceList.Compute("Sum(money_fee)", "hang_flag = 1");
            fundCharge.Money   = Convert.IsDBNull(objSum) ? 0 : Convert.ToDecimal(objSum);
            //挂号收费
            FundInfo fundRegFee = new FundInfo( );

            fundRegFee.PayName = "挂号费";
            objSum             = tbRegisterInvoiceDetaiList.Compute("sum(total_fee)", "stat_item_code='05' and hang_flag=0 and money_fee<>0");
            fundRegFee.Money   = Convert.IsDBNull(objSum) ? 0 : Convert.ToDecimal(objSum);
            //挂号诊金
            FundInfo fundExamine = new FundInfo( );

            fundExamine.PayName = "诊查费";
            objSum            = tbRegisterInvoiceDetaiList.Compute("sum(total_fee)", "stat_item_code='06' and hang_flag=0 and money_fee<>0");
            fundExamine.Money = Convert.IsDBNull(objSum) ? 0 : Convert.ToDecimal(objSum);

            cashPart.Details    = new FundInfo[3];
            cashPart.Details[0] = fundCharge;
            cashPart.Details[1] = fundRegFee;
            cashPart.Details[2] = fundExamine;

            return(cashPart);
        }
コード例 #3
0
        /// <summary>
        /// 获取记账部分
        /// </summary>
        /// <param name="tbAllInvoiceList"></param>
        /// <returns></returns>
        private static FundPart GetTallyPart(DataTable tbAllInvoiceList)
        {
            List <FundInfo> lstFundInfo = new List <FundInfo>( );
            decimal         totalTally  = 0;
            //按病人类型获取记账
            DataTable PatientTypeList = BaseDataController.BaseDataSet[BaseDataCatalog.病人类型列表];

            FundInfo[] fundPatType = new FundInfo[PatientTypeList.Rows.Count];
            for (int i = 0; i < PatientTypeList.Rows.Count; i++)
            {
                fundPatType[i].PayCode = PatientTypeList.Rows[i]["PATTYPECODE"].ToString( ).Trim( );
                fundPatType[i].PayName = PatientTypeList.Rows[i]["NAME"].ToString( ).Trim( ) + "_记账";
            }
            for (int i = 0; i < fundPatType.Length; i++)
            {
                DataRow[] drsInvoice = tbAllInvoiceList.Select("meditype='" + fundPatType[i].PayCode + "'");
                for (int j = 0; j < drsInvoice.Length; j++)
                {
                    decimal tallyMoney = Convert.ToDecimal(drsInvoice[j]["village_fee"]);
                    if (tallyMoney != 0)
                    {
                        fundPatType[i].BillCount = fundPatType[i].BillCount + 1;
                        fundPatType[i].Money     = fundPatType[i].Money + tallyMoney;
                        totalTally = totalTally + tallyMoney;
                    }
                }
            }
            lstFundInfo = fundPatType.ToList( );

            //POS记账
            FundInfo fundPos = new FundInfo( );

            fundPos.BillCount = 0;
            fundPos.PayName   = "POS金额";
            //个人记账
            FundInfo fundSelfTally = new FundInfo( );

            fundSelfTally.PayName = "单位记账";

            for (int i = 0; i < tbAllInvoiceList.Rows.Count; i++)
            {
                decimal posMoney       = Convert.ToDecimal(tbAllInvoiceList.Rows[i]["pos_fee"]);
                decimal selfTallyMoney = Convert.ToDecimal(tbAllInvoiceList.Rows[i]["self_tally"]);
                if (posMoney != 0)
                {
                    fundPos.BillCount = fundPos.BillCount + 1;
                    fundPos.Money     = fundPos.Money + posMoney;
                    totalTally        = totalTally + posMoney;
                }
                if (selfTallyMoney != 0)
                {
                    fundSelfTally.BillCount = fundSelfTally.BillCount + 1;
                    fundSelfTally.Money     = fundSelfTally.Money + selfTallyMoney;
                    totalTally = totalTally + selfTallyMoney;
                }
            }
            lstFundInfo.Add(fundPos);
            lstFundInfo.Add(fundSelfTally);

            FundPart tallyPart = new FundPart( );

            tallyPart.TotalMoney = totalTally;
            tallyPart.Details    = lstFundInfo.ToArray( );

            return(tallyPart);
        }
コード例 #4
0
        /// <summary>
        /// 汇总所有人账单
        /// </summary>
        /// <param name="Books"></param>
        /// <returns></returns>
        public static CollectAccountBook CollectAllAccountBook(List <PrivyAccountBook> Books)
        {
            CollectAccountBook     totalBook        = new CollectAccountBook( );
            List <AccountBillInfo> chargeBillinfo   = new List <AccountBillInfo>( );
            List <AccountBillInfo> registerBillinfo = new List <AccountBillInfo>( );
            FundPart  cashPart      = new FundPart( );
            FundPart  favorPart     = new FundPart( );
            FundPart  tallyPart     = new FundPart( );
            Hashtable htInvoiceItem = new Hashtable( );

            foreach (PrivyAccountBook book in Books)
            {
                #region 合并发票科目部分
                if (book == null || book.InvoiceItem == null)
                {
                    continue;
                }
                totalBook.InvoiceItemSumTotal += book.InvoiceItemSumTotal;

                #region 合并收费票据部分
                chargeBillinfo.Add(book.ChargeInvoiceInfo);
                //chargeBillinfo.Count += book.ChargeInvoiceInfo.Count;

                //chargeBillinfo.RefundCount += book.ChargeInvoiceInfo.RefundCount;
                //chargeBillinfo.RefundMoney += book.ChargeInvoiceInfo.RefundMoney;
                //List<Invoice> lstChargeInvoice = new List<Invoice>( );
                //if ( chargeBillinfo.InvoiceList != null )
                //    lstChargeInvoice = chargeBillinfo.InvoiceList.ToList( );
                //if ( book.ChargeInvoiceInfo.InvoiceList != null )
                //{
                //    for ( int i = 0 ; i < book.ChargeInvoiceInfo.InvoiceList.Length ; i++ )
                //        lstChargeInvoice.Add( book.ChargeInvoiceInfo.InvoiceList[i] );
                //}
                //chargeBillinfo.InvoiceList = lstChargeInvoice.ToArray( );
                #endregion

                #region 合并挂号票据部分
                //registerBillinfo.Count += book.RegisterInvoiceInfo.Count;
                ////if ( ( registerBillinfo.StartNumber == "" || registerBillinfo.StartNumber == null ) && book.RegisterInvoiceInfo.StartNumber != "" )
                ////    registerBillinfo.StartNumber = book.RegisterInvoiceInfo.StartNumber;
                ////if ( book.RegisterInvoiceInfo.EndNumber != "" )
                ////    registerBillinfo.EndNumber = book.RegisterInvoiceInfo.EndNumber;

                //registerBillinfo.RefundCount += book.RegisterInvoiceInfo.RefundCount;
                //registerBillinfo.RefundMoney += book.RegisterInvoiceInfo.RefundMoney;
                //List<Invoice> lstRegInvoice = new List<Invoice>( );
                //if ( registerBillinfo.InvoiceList != null )
                //    lstRegInvoice = registerBillinfo.InvoiceList.ToList( );
                //if ( book.RegisterInvoiceInfo.InvoiceList != null )
                //{
                //    for ( int i = 0 ; i < book.RegisterInvoiceInfo.InvoiceList.Length ; i++ )
                //        lstRegInvoice.Add( book.RegisterInvoiceInfo.InvoiceList[i] );
                //}
                //registerBillinfo.InvoiceList = lstRegInvoice.ToArray( );
                registerBillinfo.Add(book.RegisterInvoiceInfo);
                #endregion


                for (int i = 0; i < book.InvoiceItem.Length; i++)
                {
                    if (htInvoiceItem.ContainsKey(book.InvoiceItem[i].ItemCode))
                    {
                        InvoiceItem invoiceItem = (InvoiceItem)htInvoiceItem[book.InvoiceItem[i].ItemCode];
                        invoiceItem.Cost += book.InvoiceItem[i].Cost;
                        htInvoiceItem.Remove(book.InvoiceItem[i].ItemCode);
                        htInvoiceItem.Add(invoiceItem.ItemCode, invoiceItem);
                    }
                    else
                    {
                        htInvoiceItem.Add(book.InvoiceItem[i].ItemCode, book.InvoiceItem[i]);
                    }
                }
                #endregion

                #region 合并现金部分
                cashPart.TotalMoney += book.CashPart.TotalMoney;
                if (cashPart.Details == null)
                {
                    cashPart.Details = new FundInfo[3];
                }
                for (int i = 0; i < book.CashPart.Details.Length; i++)
                {
                    cashPart.Details[i].BillCount += book.CashPart.Details[i].BillCount;
                    cashPart.Details[i].Money     += book.CashPart.Details[i].Money;
                    cashPart.Details[i].PayCode    = book.CashPart.Details[i].PayCode;
                    cashPart.Details[i].PayName    = book.CashPart.Details[i].PayName;
                }
                #endregion

                #region 合并记账部分
                tallyPart.TotalMoney += book.TallyPart.TotalMoney;
                if (tallyPart.Details == null)
                {
                    tallyPart.Details = new FundInfo[book.TallyPart.Details.Length];
                }

                for (int i = 0; i < book.TallyPart.Details.Length; i++)
                {
                    tallyPart.Details[i].BillCount += book.TallyPart.Details[i].BillCount;
                    tallyPart.Details[i].Money     += book.TallyPart.Details[i].Money;
                    tallyPart.Details[i].PayCode    = book.TallyPart.Details[i].PayCode;
                    tallyPart.Details[i].PayName    = book.TallyPart.Details[i].PayName;
                }
                #endregion

                //合并优惠部分
                favorPart.TotalMoney += book.FavorPart.TotalMoney;
            }

            totalBook.ChargeInvoiceInfo   = chargeBillinfo.ToArray();
            totalBook.RegisterInvoiceInfo = registerBillinfo.ToArray();
            totalBook.CashPart            = cashPart;
            totalBook.TallyPart           = tallyPart;
            totalBook.FavorPart           = favorPart;

            totalBook.InvoiceItem = new InvoiceItem[htInvoiceItem.Count];
            int count = 0;
            foreach (object obj in htInvoiceItem)
            {
                totalBook.InvoiceItem[count] = (InvoiceItem)((DictionaryEntry)obj).Value;
                count++;
            }

            return(totalBook);
        }