fapiao.cs

.net 开发的基础框架

using System;
using System.Collections.Generic;
using System.Text;
using SPRFrame;
using Sybase.DataWindow;

namespace HPIResource.ShouFei
{
    public class FaPiao
    {
        public Invoice invHead;
        public InvDetail invDetail;

        public FaPiao()
        {
            invHead = new Invoice();
            invDetail = new InvDetail();
        }

        public void Init(int id)
        {
            invHead.SetDataById(id);
            invHead.Retrieve();

            invDetail.SetDataById(id);
            invDetail.Retrieve();
        }

        public void Init()
        {
            invHead.Retrieve();
            invDetail.Retrieve();
        }

        // 保存发票
        public int Save()
        {
            int itemID;

            if (invHead.ID <= 0)
            {
                itemID = SPRF.MaxId("HPIR_Invoice");
                if (itemID <= 0)
                {
                    SPRF.ErrText = "取最大值出错！";
                    return -1;
                }
                invHead.ID = itemID;
            }
            else
            {
                itemID = invHead.ID;
            }

            for (int i = 1; i <= invDetail.RowCount; i++)
            {
                invDetail.SetRow(i);
                if (invDetail.ID == 0)
                {
                    invDetail.ID = itemID;
                }
            }

            //保存
            try
            {
                invHead.UpdateData();
            }
            catch (DbErrorException e)
            {
                SPRF.ErrText = e.SqlErrorText;
                return -1;
            }
            try
            {
                invDetail.UpdateData();
            }
            catch (DbErrorException e)
            {
                SPRF.ErrText = e.SqlErrorText;
                return -1;
            }
            return 0;
        }

        public int GetInvoiceMaxId()
        {//取invHead的最大值
            int itemID;
            itemID = SPRF.MaxId("HPIR_Invoice");
            if (itemID <= 0)
            {
                SPRF.ErrText = "取最大值出错！";
                return -1;
            }
            return itemID;
        }

        public void AddInvJE(double Amt, string Inv_Code)
        {//增加金额
            bool bFound = false;
            for (int i = 1; i <= invDetail.RowCount; i++)
            {
                invDetail.SetRow(i);
                if (invDetail.Inv_Code == Inv_Code)
                {
                    bFound = true;
                    break;
                }
            }
            if (bFound)
            {
                invDetail.SUM_YS = invDetail.SUM_YS + Amt;
            }
            else
            {
                int j = invDetail.InsertRow(0);
                invDetail.SetRow(j);
                invDetail.ID = 0;
                invDetail.Inv_Code = Inv_Code;
                invDetail.SUM_YS = Amt;
            }

            invHead.SUM_YS = invHead.SUM_YS + Amt;

            //计算实收金额
            invHead.SUM_SL = invHead.SUM_YS - invHead.SUM_JZ;

            //计算抹零金额 
            int temp_ml;
            temp_ml = Convert.ToInt32((invHead.SUM_SL * 10)); 
            invHead.SUM_ML = Convert.ToDouble(((invHead.SUM_SL * 10) - Convert.ToDouble(temp_ml)) / 10);           
        }
        /// <summary>
        /// 增加记帐金额(保险等)
        /// </summary>
        /// <param name="Amt">金额</param>
        public void AddInvJZJE(double Amt)
        {
            invHead.SUM_JZ += Amt;
        }


        #region 属性
        public int ID
        {
            get { return invHead.ID; }
            set { invHead.ID = value; }
        }
        public int AccID
        {
            get { return invHead.AccID; }
            set { invHead.AccID = value; }
        }
        public string STS_ZF
        {
            get { return invHead.STS_ZF; }
            set { invHead.STS_ZF = value; }
        }
        public string PayerID
        {
            get { return invHead.PayerID; }
            set { invHead.PayerID = value; }
        }
        public string PayerName
        {
            get { return invHead.PayerName; }
            set { invHead.PayerName = value; }
        }
        public string InvNo
        {
            get { return invHead.InvNo; }
            set { invHead.InvNo = value; }
        }
        //public double SUM_YS
        //{
        //    get { return invDetail.SUM_YS; }
        //    set { invDetail.SUM_YS = value; }
        //}
        #endregion

    }
}