using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using CY.BLL.OA;
using System.Data;
using System.Data.SqlClient;
using CY.Infrastructure.Common;
using CY.Model;
using CY.BLL.Sys;
using CY.BLL;
using System.Transactions;

namespace CY.WebForm.Pages.financial
{
    //吴辉
    //采购付款选择账户
    public partial class CaigouPayEdit : BasePage
    {

        OA_WarehouseInfoBLL _OA_WarehouseInfoBLL = null;
        OA_CargoSpaceBLL _OA_CargoSpaceBLL = null;
        OA_OutOfStorageBLL bll_OA_OutOfStorageBLL = null;
        OA_SubjectSetBLL bll_OA_SubjectSetBLL = null;
        Sys_DictionaryBLL bll_Sys_DictionaryBLL = null;
        OA_ProcurementBLL bll_OA_ProcurementBLL = null;
        OA_FirmAccountBLL bll_OA_FirmAccountBLL = null;
        OA_SuppliersBLL bll_OA_SuppliersBLL = null;
        OA_FukuanshenqingBLL _fukuanshenqingBLL = null;
        OA_SubjectSetBLL _OA_SubjectSetBLL = null;
        Sys_DictionaryBLL _Sys_DictionaryBLL = null;
        OA_StaffBLL staffBLL = null;
        OA_BaozhengjinBLL oA_BaozhengjinBLL = null;
        decimal? AllMoney = 0;
        decimal? ReceiveMoney = 0;
        //初始化
        public CaigouPayEdit()
        {
            bll_OA_OutOfStorageBLL = new OA_OutOfStorageBLL();
            _OA_WarehouseInfoBLL = new OA_WarehouseInfoBLL();
            _OA_CargoSpaceBLL = new OA_CargoSpaceBLL();
            bll_OA_SubjectSetBLL = new OA_SubjectSetBLL();
            bll_Sys_DictionaryBLL = new Sys_DictionaryBLL();
            bll_OA_ProcurementBLL = new OA_ProcurementBLL();
            bll_OA_FirmAccountBLL = new OA_FirmAccountBLL();
            bll_OA_SuppliersBLL = new OA_SuppliersBLL();
            _fukuanshenqingBLL = new OA_FukuanshenqingBLL();
            _Sys_DictionaryBLL = new Sys_DictionaryBLL();
            staffBLL = new OA_StaffBLL();
            oA_BaozhengjinBLL = new OA_BaozhengjinBLL();
            _OA_SubjectSetBLL = new OA_SubjectSetBLL();
        }

        //页面加载
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                InitialData();
            }

        }

        //加载数据
        protected void InitialData()
        {
            //科目名称
            this.selSubject.DataSource = bll_OA_SubjectSetBLL.getAllSubject(CurrentUser.MemberId, "贷");
            this.selSubject.DataBind();
            this.selSubject.Items.Insert(0, new ListItem("请选择", ""));

            //账户类型
            this.selAcoountTypeOut.DataSource = bll_Sys_DictionaryBLL.GetDataByType("账户类型");
            this.selAcoountTypeOut.DataBind();

            var id = Request["id"];
            var fukuanshenqing = _fukuanshenqingBLL.GetModelByKeyid(id.ToInt32().Value);
            if (fukuanshenqing != null)
            {
                this.Keyid.Value = id;
                this.txtYouwufapiao.Value = fukuanshenqing.YouwufapiaoName;
                string[] Keys = fukuanshenqing.DindanId.Trim(',').Split(',');
                foreach (var item in Keys)
                {
                    if (!string.IsNullOrEmpty(item))
                    {
                        OA_Procurement m_OA_Procurement = bll_OA_ProcurementBLL.SelectSingleModel(item);
                        if (m_OA_Procurement != null)
                        {
                            AllMoney += m_OA_Procurement.AllMoney;
                            ReceiveMoney += (m_OA_Procurement.AllMoney - m_OA_Procurement.ReceiveMoney);
                        }
                    }
                }
                this.spanAllMoney.InnerHtml = "￥" + (AllMoney ?? 0).ToString("0.00");
                this.spanReceiveMoney.InnerHtml = "￥" + ReceiveMoney.Value.ToString("0.00");
                this.hidReceiveMoney.Value =  ReceiveMoney.Value.ToString();
                this.spanCountRe.InnerHtml = Keys.Count().ToString2() + " 单";

               
                this.txtReciveMoney.Value = (ReceiveMoney ?? 0).ToString("0.00");
                this.txtReciveMoney.Attributes.Add("max", (ReceiveMoney ?? 0).ToString("0.00"));
            }
               

            
              
            
        }

        //提交事件
        protected void btn_Submit_form(object sender, EventArgs e)
        {
            try
            {
                if (string.IsNullOrEmpty(Request["selAccountNameOut"]))
                {
                    JavaScript.MessageBox("请选择账户", this);
                    return;
                }
                var werwerwerwerwe = Request["txtReciveMoney"];
                ReceiveMoney = this.txtReciveMoney.Value.ToDecimal2();
                int? SubjectId = this.selSubject.Value.ToInt32();
                var molingmoney = this.txtMolingMoney.Value.ToDecimal2();
                decimal? money = ReceiveMoney;


                int? AccountIdOut = Request["selAccountNameOut"].ToInt32();

                if (SubjectId == null || money == null || AccountIdOut == null)
                    JavaScript.MessageBox("操作失败", this);
                else
                {
                    DateTime nowTime = DateTime.Now;
                    OA_SubjectSet m_OA_SubjectSet = bll_OA_SubjectSetBLL.getSingleSubject(SubjectId);
                    OA_FirmAccount m_OA_FirmAccountOut = bll_OA_FirmAccountBLL.getSingleSubject(AccountIdOut);

                    if (m_OA_FirmAccountOut.Balance < money)
                    {
                        JavaScript.MessageBox("账户余额不足", this);
                    }
                    else
                    {
                        var id = this.Keyid.Value.ToInt32().Value;
                        var fukuanshenqing = _fukuanshenqingBLL.GetModelByKeyid(id);

                        if (fukuanshenqing.FukuanStatus == 2 && money>0)
                        {
                            JavaScript.MessageBox("该申请已经付款结束！", this);
                            return;
                        }

                        if (money > (fukuanshenqing.Fukuanmoney - fukuanshenqing.Yishoumoney))
                        {
                            JavaScript.MessageBox("操作金额大于剩余应付金额！", this);
                            return;
                        }

                        var Youwufapiao = Request["rdoReceiveQuannbu"];
                        if (fukuanshenqing.Youwufapiao == 2 && Youwufapiao == "1")
                        {
                            JavaScript.MessageBox("已经保存为有发票，无法修改为无发票！", this);
                            return;
                        }

                        if (molingmoney.HasValue)
                        {
                            if ((money + molingmoney.Value) != (fukuanshenqing.Fukuanmoney - fukuanshenqing.Yishoumoney))
                            {
                                JavaScript.MessageBox("操作金额加抹零金额必须等于剩余应付金额！", this);
                                return;
                            }
                        }

                        string[] Keys = fukuanshenqing.DindanId.Trim(',').Split(',');
                        var ssss = false;
                        using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required,
                new TransactionOptions
                {
                    IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted,
                    Timeout = TransactionManager.MaximumTimeout
                }
                ))
                        {
                            try
                            {
                                var yishoumoney = fukuanshenqing.Yishoumoney.HasValue ? fukuanshenqing.Yishoumoney.Value : 0;
                                if (money >= (fukuanshenqing.Fukuanmoney - fukuanshenqing.Yishoumoney))
                                {
                                    fukuanshenqing.FukuanStatus = 2;
                                }
                                if (molingmoney.HasValue)
                                {
                                    if ((money + molingmoney.Value) >= (fukuanshenqing.Fukuanmoney - fukuanshenqing.Yishoumoney))
                                    {
                                        fukuanshenqing.FukuanStatus = 2;
                                    }
                                }
                                fukuanshenqing.Yishoumoney = yishoumoney + money;
                                fukuanshenqing.Updater = CurrentUser.ShortName;
                                fukuanshenqing.LastUpdateTime = DateTime.Now;
                                fukuanshenqing.Youwufapiao = Youwufapiao.ToInt32();
                                ssss = _fukuanshenqingBLL.UpdateModel(fukuanshenqing);
                                if (this.txtReciveMoney.Value.ToDecimal2() > 0)
                                {
                                    List<OA_Procurement> m_OA_ProcurementList = new List<OA_Procurement>();
                                    List<OA_FirmAccountRecord> m_OA_FirmAccountRecordList = new List<OA_FirmAccountRecord>();
                                    m_OA_FirmAccountOut.Balance -= money;
                                    m_OA_FirmAccountOut.AllExpenses += money;
                                    decimal molingmoneyvalue = 0;
                                    if (molingmoney.HasValue)
                                    {
                                        molingmoneyvalue = molingmoney.Value;
                                    }
                                    foreach (var item in Keys)
                                    {
                                        OA_Procurement m_OA_Procurement = bll_OA_ProcurementBLL.SelectSingleModel(item);
                                        if (m_OA_Procurement != null)
                                        {
                                           


                                            OA_Suppliers m_OA_Suppliers = bll_OA_SuppliersBLL.getSingleSupplier(m_OA_Procurement.SuppliersId.ToString2());
                                            OA_FirmAccountRecord m_OA_FirmAccountRecordOut = new OA_FirmAccountRecord();
                                            m_OA_FirmAccountRecordOut.AccountId = m_OA_FirmAccountOut.Keyid;
                                            m_OA_FirmAccountRecordOut.RecordTypeId = 2;//支出

                                            m_OA_FirmAccountRecordOut.Money = m_OA_Procurement.AllMoney.Value;
                                            m_OA_Procurement.ReceiveMoney = m_OA_Procurement.AllMoney.Value ;
                                            if (molingmoneyvalue > 0)
                                            {
                                                if (m_OA_Procurement.AllMoney.Value >= molingmoneyvalue)
                                                {
                                                    m_OA_Procurement.ReceiveMoney = m_OA_Procurement.AllMoney.Value  - molingmoneyvalue;
                                                    m_OA_FirmAccountRecordOut.Money = m_OA_Procurement.AllMoney.Value  - molingmoneyvalue;
                                                    molingmoneyvalue = 0;
                                                }
                                                else
                                                {
                                                    m_OA_Procurement.ReceiveMoney = 0;
                                                    m_OA_FirmAccountRecordOut.Money = 0;
                                                    molingmoneyvalue = molingmoneyvalue - m_OA_Procurement.AllMoney.Value;
                                                }

                                            }

                                            m_OA_FirmAccountRecordOut.SubjectId = m_OA_SubjectSet.Keyid;
                                            m_OA_FirmAccountRecordOut.OperationalMatters = "采购付款";
                                            m_OA_FirmAccountRecordOut.PaymentUnit = m_OA_Suppliers.Name;
                                            m_OA_FirmAccountRecordOut.LastUpdateTime = nowTime;
                                            m_OA_FirmAccountRecordOut.Operator = CurrentUser.ShortName.ToString2();
                                            m_OA_FirmAccountRecordOut.Remark = "";
                                            m_OA_FirmAccountRecordOut.ResidualAmount = m_OA_FirmAccountOut.Balance;
                                            m_OA_FirmAccountRecordList.Add(m_OA_FirmAccountRecordOut);
                                            m_OA_ProcurementList.Add(m_OA_Procurement);

                                            




                                            if (m_OA_Procurement.ReceiveMoney == m_OA_Procurement.AllMoney)
                                                m_OA_Procurement.ClearingStatusId = bll_Sys_DictionaryBLL.GetKeyIdByKeyid(1, "结账状态");

                                            if (fukuanshenqing.FukuanStatus == 2)
                                                m_OA_Procurement.ClearingStatusId = bll_Sys_DictionaryBLL.GetKeyIdByKeyid(1, "结账状态");

                                            m_OA_Procurement.Operator = CurrentUser.ShortName;
                                            m_OA_Procurement.LastUpdateTime = DateTime.Now;

                                        }
                                    }


                                    if (m_OA_ProcurementList.Count > 0)
                                    {
                                        ssss = bll_OA_FirmAccountBLL.PurchasePayList(m_OA_FirmAccountRecordList, m_OA_ProcurementList, m_OA_FirmAccountOut);
                                        if (!string.IsNullOrEmpty(this.selSubject.Value))
                                        {
                                            var oA_SubjectSet = _OA_SubjectSetBLL.getSingleSubject(m_OA_FirmAccountRecordList[0].SubjectId);
                                            if (oA_SubjectSet.SubjectName.IndexOf("投标保证金") >= 0 || oA_SubjectSet.SubjectName.IndexOf("履约保证金") >= 0)
                                            {
                                                //如果选择科目是保证金，插入以条保证金数据
                                                OA_Baozhengjin oA_Baozhengjin = new OA_Baozhengjin();
                                                oA_Baozhengjin.FirmId = CurrentUser.MemberId;
                                                oA_Baozhengjin.FukuanTime = DateTime.Now;

                                                oA_Baozhengjin.Zhanghuleixing = this.selAcoountTypeOut.Value;

                                                var ss = _Sys_DictionaryBLL.GetDataByType("账户类型").FirstOrDefault(x => x.Name == oA_Baozhengjin.Zhanghuleixing);
                                                if (ss != null)
                                                {
                                                    oA_Baozhengjin.ReceiveWay = ss.Keyid;
                                                }

                                                oA_Baozhengjin.Account = Request["selAccountName"].ToInt32();
                                                oA_Baozhengjin.Fukuanzhanghu = m_OA_FirmAccountOut.AccountName + "-" + m_OA_FirmAccountOut.UserName;
                                                oA_Baozhengjin.Subject = m_OA_FirmAccountRecordList[0].SubjectId;
                                                oA_Baozhengjin.Fukuankemu = oA_SubjectSet.SubjectName;
                                                oA_Baozhengjin.Fukuanmoney = money;
                                                oA_Baozhengjin.Shoukuandanwei = m_OA_FirmAccountRecordList[0].PaymentUnit;
                                                oA_Baozhengjin.remark = m_OA_FirmAccountRecordList[0].OperationalMatters;
                                                oA_Baozhengjin.TuikuanTime = null;

                                                oA_Baozhengjin.TuikuanStatus = 1;
                                                oA_Baozhengjin.Creater = CurrentUser.ShortName;
                                                oA_Baozhengjin.CreateTime = oA_Baozhengjin.FukuanTime;
                                                oA_Baozhengjin.Updater = CurrentUser.ShortName;
                                                oA_Baozhengjin.LastUpdateTime = oA_Baozhengjin.FukuanTime;
                                                oA_Baozhengjin.MemberName = fukuanshenqing.Creater;

                                                var oA_Staff = staffBLL.SelectListByFirmId(CurrentUser.MemberId, false, false).Where(x => x.Name == oA_Baozhengjin.MemberName).FirstOrDefault();
                                                oA_Baozhengjin.MemberId = oA_Staff.Keyid;

                                                var sss = oA_BaozhengjinBLL.InsertModel(oA_Baozhengjin);

                                            }
                                        }
                                    }
                                }

                                  

                                if (ssss)
                                {

                                    scope.Complete();
                                    JavaScript.MessageBox("付款成功", this, "top.frmright.ReLoad();top.Dialog.close();");
                                }
                                else
                                    JavaScript.MessageBox("添加失败", this);
                            }
                            catch (Exception ex)
                            {
                                PAGEHandleException(ex);
                                JavaScript.MessageBox("添加失败", this);
                            }
                            finally
                            {
                                scope.Dispose();
                            }

                        }


                       
                      
                    }
                }

            }
            catch (Exception ex)
            {
                PAGEHandleException(ex);
                JavaScript.MessageBox("操作失败", this);
            }
        }

    }
}