using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Microsoft.Internal.Performance;

namespace EquipmentMS.Equipment
{
    public partial class frmEquimentSum : Form
    {
        EquipmentMS.BaseClass.Operation oper = new EquipmentMS.BaseClass.Operation();
        public frmEquimentSum()
        {
            InitializeComponent();
        }

        private void btnCalc_Click(object sender, EventArgs e)
        {
            System.Diagnostics.Process.Start("calc.exe");
        }

        private void btnExcel_Click(object sender, EventArgs e)
        {
            if (!oper.ExportDataGridview(dgvEquiment, true))
                MessageBox.Show("表格中沒有數據，無法導出數據！", "系統提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
        }

        private void frmEquimentSum_Load(object sender, EventArgs e)
        {
            this.SumZC();
        }

        private void btnExit_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void frmEquimentSum_Resize(object sender, EventArgs e)
        {
            dgvEquiment.Height = this.Height - 80;
        }

        private void btnSum_Click(object sender, EventArgs e)
        {
            this.SumZC();
        }

        private void SumZC()
        {
            DataSet ds = oper.GetDataSetZcMainSum();
            dgvEquiment.DataSource = ds.Tables[0].DefaultView;
            DateTime rzrq = DateTime.Now;
            float zcyz = 0;
            float jczl = 0;
            int synx = 0;
            float yzjl = 0;
            TimeSpan ts = new TimeSpan();
            for (int i = 0; i < dgvEquiment.Rows.Count - 1; i++)
            {
                //凈殘值率
                jczl = Convert.ToSingle(Convert.ToSingle(dgvEquiment[7, i].Value) * 0.01);
                //資產原值
                zcyz = Convert.ToSingle(dgvEquiment[6, i].Value);
                //使用年限
                synx = Convert.ToInt32(dgvEquiment[8, i].Value.ToString());
                //入賬日期
                rzrq = Convert.ToDateTime(dgvEquiment[4, i].Value);
                yzjl = ((1 - jczl) / synx) / 12;
                //計算月折舊額
                dgvEquiment[9, i].Value = Convert.ToSingle(zcyz * yzjl);
                ts = dtpZjrq.Value - rzrq;
                //計算累計折舊
                dgvEquiment[10, i].Value = Convert.ToSingle(zcyz * yzjl) * (ts.Days / 30);
                //計算凈值
                try
                {
                    dgvEquiment[6, i].Value = Convert.ToSingle(dgvEquiment[5, i].Value) - Convert.ToSingle(dgvEquiment[10, i].Value);
                }
                catch { }
            }
        }
    }
}