lyfz_repos/铂金版源码/LYFZ.Software.MainBusiness/StatisticalInquiry/FrmDayFinance.cs

using LYFZ.ComponentLibrary;
using LYFZ.Software.MainBusiness.DoorCityProcess;
using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace LYFZ.Software.MainBusiness.StatisticalInquiry
{

    public partial class FrmDayFinance : LYFZ.Software.UI.StatisticalInquiry.FrmDayFinance
    {
        private delegate void UpdateControl();
        public FrmDayFinance()
        {

        }
        LYFZ.BLL.BLL_ErpUser userbll = new BLL.BLL_ErpUser();
        LYFZ.BLL.BLL_ErpOrder orbll = new BLL.BLL_ErpOrder();
        LYFZ.BLL.BLL_ErpPayment ptbll = new BLL.BLL_ErpPayment();
        LYFZ.BLL.BLL_AllViewSet avstbll = new BLL.BLL_AllViewSet();
        LYFZ.BLL.BLL_ErpWagesSet wsbll = new BLL.BLL_ErpWagesSet();
        LYFZ.DAL.DAL_SMSTemplates SMSTdal = new DAL.DAL_SMSTemplates();
        LYFZ.BLL.BLL_ErpSystemCategory scbll = new BLL.BLL_ErpSystemCategory();
        LYFZ.BLL.BLL_ErpTwoSalesOrder tordbll = new BLL.BLL_ErpTwoSalesOrder();
        LYFZ.BLL.BLL_ErpDressRefundRecord drrbll = new BLL.BLL_ErpDressRefundRecord();
        LYFZ.BLL.BLL_ErpMemberCardPayment mcptbll = new BLL.BLL_ErpMemberCardPayment();
        LYFZ.BLL.BLL_ErpDressSaleRentalOrder dsrobll = new BLL.BLL_ErpDressSaleRentalOrder();
        LYFZ.BLL.BLL_ErpOtherIncomeAndExpenses oiebll = new BLL.BLL_ErpOtherIncomeAndExpenses();
        LYFZ.BLL.BLL_ErpMemberCardRechargeRecord mcrrbll = new BLL.BLL_ErpMemberCardRechargeRecord();
        public string DateTimeDay = "";
        private bool Isbl = false;
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void FrmDayFinance_Shown(object sender, EventArgs e)
        {
            try
            {
                if (!string.IsNullOrEmpty(this.DateTimeDay))
                {
                    this.numYear.Value = Convert.ToDateTime(DateTimeDay).Year;
                    this.numMonth.Value = Convert.ToDateTime(DateTimeDay).Month;
                    this.numDay.Value = Convert.ToDateTime(DateTimeDay).Day;
                }
                else
                {
                    this.numYear.Value = SDateTime.Now.Year;
                    this.numMonth.Value = SDateTime.Now.Month;
                    this.numDay.Value = SDateTime.Now.Day;
                }
                this.dgv.Rows.Clear();
                //获取财务短信
                this.GetFinancialSMS();
                // 获取订单收款/其它二销/礼服租售记录
                this.BindOrdersReceivables();
                // 获取会员充值
                this.GetMemberCardRechargeRecord();
                //获取服务卡消费充值
                this.GetMemberCardPayment();
                // 获取现金支出
                this.BindFinancialExpenses(-1);
                //获取支付方式
                LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_PaymentMethod(this.cmbPay_PaymentMethod, IsShowAll: true, IsFirstNodeNull: true);
                //获取文本框金额
                this.BindTotal();
                //总押金
                this.txtDeposit.Text = wsbll.GetDressDepositSum().ToString();
                //总欠款
                this.txtArrears.Text = ptbll.GetSumArrears().ToString();
                this.cmbProjectSearch.SelectedIndex = 0;

                #region 权限设置
                //  财务审核
                this.btnFinancialAudit.Enabled = LYFZ.BLL.BLL_ErpUser.GetRights(LYFZ.BLL.BLL_ErpUser.CurrentUserRights.DayFinanceCompetence, CustomAttributes.OperatingAuthority.FinancialAudit);
                //  导出
                this.btnExPort.Enabled = LYFZ.BLL.BLL_ErpUser.GetRights(LYFZ.BLL.BLL_ErpUser.CurrentUserRights.DayFinanceCompetence, CustomAttributes.OperatingAuthority.DataExport);
                //  打印
                this.btnPrint.Enabled = LYFZ.BLL.BLL_ErpUser.GetRights(LYFZ.BLL.BLL_ErpUser.CurrentUserRights.DayFinanceCompetence, CustomAttributes.OperatingAuthority.Print);
                //  财务支出
                if (!LYFZ.BLL.BLL_ErpUser.GetRights(LYFZ.BLL.BLL_ErpUser.CurrentUserRights.DayFinanceCompetence, CustomAttributes.OperatingAuthority.FinancialExpenses))
                { this.cmbProjectSearch.Items.RemoveAt(8); }
                #endregion
                this.Isbl = true;
            }
            catch (Exception ex)
            { MessageBoxCustom.Show(ex.Message); }
        }
        /// <summary>
        /// 统计财务短信
        /// </summary>
        public void GetFinancialSMS()
        {
            #region 滕工
            decimal XianJing = 0;
            decimal Sum = 0;
            string Sc_ClassCode = "";
            string Sc_ClassName = "";
            string smsContent = "";
            string smsContentPay = "";
            decimal DayExpenditure = 0;
            string time = Convert.ToDateTime(this.numYear.Value + "-" + this.numMonth.Value + "-" + this.numDay.Value).ToString("yyyy-MM-dd");
            string ExecuteSql = orbll.GetView_CustomReturnExecuteSql("tb_ErpOrder", StrWhere: PublicCodeClasses.GetDateTime("Ord_CreateDatetime", time, time, ConnectWord: ""), ShowColumnName: "Ord_Type,Ord_Class");
            ExecuteSql += ";" + orbll.GetView_CustomReturnExecuteSql("Vw_MonthlyReport", StrWhere: PublicCodeClasses.GetDateTime("convert(datetime,Pay_CreateDatetimes)", time, time, ConnectWord: ""), ShowColumnName: "*");
            DataSet dtSet = orbll.GetView_Custom(ExecuteSql);
            DataTable tbl = dtSet.Tables["ds"];
            DataRow[] dtRow = tbl.Select("Ord_Type = '0'");
            DataRow[] dtRow1 = tbl.Select("Ord_Type = '1'");
            DataRow[] dtRow2 = tbl.Select("Ord_Type = '2'");
            DataRow[] dtRow3 = tbl.Select("Ord_Type = '3'");
            DataRow[] dtRow4 = tbl.Select("Ord_Type = '4'");
            DataRow[] dtRow5 = tbl.Select("Ord_Class = '0'");
            this.lblCount.Text = "订单数：婚纱：" + dtRow.Length + "    儿童：" + dtRow1.Length + "    写真：" + dtRow2.Length + "    服务：" + dtRow3.Length + "    婚庆：" + dtRow4.Length + "    其中意向：" + dtRow5.Length;

            DataTable dt = dtSet.Tables["ds1"];
            if (dt.Rows.Count > 0)
            {
                #region 财务短信
                //日订单收入
                decimal DayOrdersIncome = dt.Rows[0]["DayOrdersIncome"].ToString() == "" ? 0 : Convert.ToDecimal(dt.Rows[0]["DayOrdersIncome"]);
                //日补款收入
                decimal DayReplenishmentIncome = dt.Rows[0]["DayReplenishmentIncome"].ToString() == "" ? 0 : Convert.ToDecimal(dt.Rows[0]["DayReplenishmentIncome"]);
                //日后期收入
                decimal DayLateStageIncome = dt.Rows[0]["DayLateStageIncome"].ToString() == "" ? 0 : Convert.ToDecimal(dt.Rows[0]["DayLateStageIncome"]);
                //日其它收入
                decimal DayOtherIncome = dt.Rows[0]["DayOtherIncome"].ToString() == "" ? 0 : Convert.ToDecimal(dt.Rows[0]["DayOtherIncome"]);
                //日会员充值
                decimal DayMemberIncome = dt.Rows[0]["DayMemberIncome"].ToString() == "" ? 0 : Convert.ToDecimal(dt.Rows[0]["DayMemberIncome"]);
                //日服务卡充值
                decimal DayMemberCardPaymentIncome = dt.Rows[0]["DayMemberCardPaymentIncome"].ToString() == "" ? 0 : Convert.ToDecimal(dt.Rows[0]["DayMemberCardPaymentIncome"]);
                //日前期业绩
                decimal DayEarlyPerformance = dt.Rows[0]["DayEarlyPerformance"].ToString() == "" ? 0 : Convert.ToDecimal(dt.Rows[0]["DayEarlyPerformance"]);
                //日后期业绩(加挑商品+其它消费)
                //加挑商品
                decimal DayPluslatepickPerformance = dt.Rows[0]["DayPluslatepickPerformance"].ToString() == "" ? 0 : Convert.ToDecimal(dt.Rows[0]["DayPluslatepickPerformance"]);
                decimal DayOtherPerformance = dt.Rows[0]["DayOtherPerformance"].ToString() == "" ? 0 : Convert.ToDecimal(dt.Rows[0]["DayOtherPerformance"]);
                //日店面支出
                DayExpenditure = dt.Rows[0]["DayExpenditure"].ToString() == "" ? 0 : Convert.ToDecimal(dt.Rows[0]["DayExpenditure"]);
                //日财务支出
                decimal DayExpenditure2 = dt.Rows[0]["DayExpenditure2"].ToString() == "" ? 0 : Convert.ToDecimal(dt.Rows[0]["DayExpenditure2"]);
                //摄友会收入
                decimal SYHSR = dt.Rows[0]["摄友会收入"].ToString() == "" ? 0 : Convert.ToDecimal(dt.Rows[0]["摄友会收入"]);
                smsContent = "财务统计：总业绩:" + (DayEarlyPerformance + DayPluslatepickPerformance + DayOtherPerformance).ToString("N2") +
                    "    实收：" + (DayOrdersIncome + DayReplenishmentIncome + DayLateStageIncome + DayOtherIncome + DayMemberIncome + DayMemberCardPaymentIncome).ToString("N2") +
                    "    其中（订单定金：" + DayOrdersIncome.ToString("N2") +
                    "    补款收入：" + DayReplenishmentIncome.ToString("N2") +
                    "    后期收入：" + DayLateStageIncome.ToString("N2") +
                    "    其它收入：" + DayOtherIncome.ToString("N2") +
                    "    会员充值：" + DayMemberIncome.ToString("N2") +
                    "    服务卡充值：" + DayMemberCardPaymentIncome.ToString("N2") +
                    "    支出：" + DayExpenditure.ToString("N2") + "）" +
                    "    摄友会收入：" + SYHSR.ToString("N2");
                #endregion

                #region 支付方式
                #region
                dt = scbll.GetList("Sc_ClassCode='BEBACCAFCCEAGAIHH'").Tables[0];
                if (dt.Rows.Count > 0)
                {
                    DataTable dt_S = scbll.GetList("Sc_ClassParentID=" + dt.Rows[0]["ID"] + "").Tables[0];
                    if (dt_S.Rows.Count > 0)
                    {
                        for (int i = 0; i < dt_S.Rows.Count; i++)
                        {
                            DataTable dt_n = scbll.GetList("Sc_ClassParentID=" + dt_S.Rows[i]["ID"] + "").Tables[0];
                            if (dt_n.Rows.Count > 0)
                            {
                                for (int t = 0; t < dt_n.Rows.Count; t++)
                                {
                                    Sc_ClassCode += dt_n.Rows[t]["Sc_ClassCode"].ToString() + ",";
                                    Sc_ClassName += dt_n.Rows[t]["Sc_ClassName"].ToString() + ",";
                                }
                            }
                            else
                            {
                                Sc_ClassCode += dt_S.Rows[i]["Sc_ClassCode"].ToString() + ",";
                                Sc_ClassName += dt_S.Rows[i]["Sc_ClassName"].ToString() + ",";
                            }
                        }
                    }
                }
                #endregion

                Sc_ClassCode = Sc_ClassCode.ToString().TrimEnd(',');
                Sc_ClassName = Sc_ClassName.ToString().TrimEnd(',');
                string[] strCode = Sc_ClassCode.Split(',');
                string[] strName = Sc_ClassName.Split(',');
                if (strCode.Length > 0)
                {
                    for (int t = 0; t < strCode.Length; t++)
                    {
                        Sum = Convert.ToDecimal(Convert.ToDecimal(SMSTdal.PayTotalRevenueSun(time, strCode[t])) + Convert.ToDecimal(SMSTdal.PayOtherIncomeSum(time, strCode[t])) + Convert.ToDecimal(SMSTdal.PayMembersRechargeSum(time, strCode[t])) + Convert.ToDecimal(SMSTdal.PayMemberCardPayment(time, strCode[t])));
                        if (strCode[t].ToString() == "BEBACCAFFHEAJICDF")
                        {
                            decimal XianJing_S = Convert.ToDecimal(Convert.ToDecimal(SMSTdal.PayTotalRevenueSun(time, strCode[t])) + Convert.ToDecimal(SMSTdal.PayOtherIncomeSum(time, strCode[t])) + Convert.ToDecimal(SMSTdal.PayMembersRechargeSum(time, strCode[t])) + Convert.ToDecimal(SMSTdal.PayMemberCardPayment(time, strCode[t])));
                            if (XianJing_S > 0)
                            { XianJing += XianJing_S; }
                        }
                        if (Sum > 0)
                        { smsContentPay += strName[t] + ":" + Sum + "" + "    "; }
                    }
                }
                #endregion
            }
            else
            {
                smsContent = "财务统计：总业绩：0    实收：0    其中（订单定金：0    补款收入：0    后期收入：0    其它收入：0    会员充值：0    服务卡充值：0    支出：0）    摄友会收入：0";
                lblPayBy.Text = "";
            }
            this.lblFinancialSMS.Text = smsContent;
            if (!string.IsNullOrEmpty(smsContentPay))
            { this.lblPayBy.Text = "支付方式：" + smsContentPay + "    柜台现金：" + Convert.ToDecimal(XianJing - SMSTdal.CashCounter(time, "BEBACCAFFHEAJICDF")).ToString("N2"); }
            #endregion
        }
        /// <summary>
        /// 获取订单收款/其它二销/礼服租售记录
        /// </summary>
        public void BindOrdersReceivables()
        {
            StringBuilder str = new StringBuilder();
            string time = Convert.ToDateTime(this.numYear.Value + "-" + this.numMonth.Value + "-" + this.numDay.Value).ToString("yyyy-MM-dd");
            str.Append(PublicCodeClasses.GetDateTime("Pay_CreateDatetime", time, time));
            if (!string.IsNullOrEmpty(this.cmbPay_PaymentMethod.Text) && this.cmbPay_PaymentMethod.Tag != null)
            { str.Append(" and Pay_PaymentMethod='" + this.cmbPay_PaymentMethod.Tag.ToString() + "'"); }
            #region 项目查询
            if (this.cmbProjectSearch.Text != "全部")
            {
                if (this.cmbProjectSearch.Text == "订单前期收入")
                {
                    if (string.IsNullOrEmpty(this.CtvTsorder_Name.Text))
                    { str.Append(" and Pay_Category!='后期收款'"); }
                    else
                    { str.Append(" and Pay_Category='" + this.CtvTsorder_Name.Text.ToString() + "'"); }
                }
                else if (this.cmbProjectSearch.Text == "订单后期收入")
                {
                    if (string.IsNullOrEmpty(this.CtvTsorder_Name.Text))
                    { str.Append(" and  Pay_Category='后期收款' and Pay_Type=0"); }
                    else
                    { str.Append("and  Pay_Category='后期收款' and Pay_Type=0 and Pay_TwoPinsCategory='" + this.CtvTsorder_Name.Tag.ToString() + "'"); }
                }
                else if (this.cmbProjectSearch.Text == "其它消费收入")
                {
                    if (string.IsNullOrEmpty(this.CtvTsorder_Name.Text))
                    { str.Append(" and  Pay_Category='后期收款' and Pay_Type=1"); }
                    else
                    { str.Append("and  Pay_Category='后期收款' and   Pay_Type=1 and Pay_TwoPinsCategory='" + this.CtvTsorder_Name.Tag.ToString() + "'"); }
                }
                else if (this.cmbProjectSearch.Text == "礼服租售收入")
                {
                    if (string.IsNullOrEmpty(this.CtvTsorder_Name.Text))
                    { str.Append(" and  Pay_Category='后期收款' and   Pay_Type=2"); }
                    else
                    { str.Append("and  Pay_Category='后期收款' and   Pay_Type=2 and Pay_ReceivableProject='" + this.CtvTsorder_Name.Text.ToString() + "'"); }
                }
            }
            #endregion

            #region 获取订单收款记录
            LYFZ.ComponentLibrary.FrmLoadHandling.LoadDoWorkMethod(delegate(object obj, BackgroundWorker backgroundWorker)
            {
                DataTable dt = avstbll.Vw_OrdersWagePaymentRecords(str.ToString()).Tables[0];
                if (dt.Rows.Count > 0)
                {
                    this.Invoke(new UpdateControl(delegate()
                    {
                        for (int t = 0; t < dt.Rows.Count; t++)
                        {
                            DataGridViewRow dgvr = new DataGridViewRow();
                            DataGridViewCell cell = null;
                            //编号
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["ID"].ToString();
                            dgvr.Cells.Add(cell);
                            //项目名称
                            cell = new DataGridViewTextBoxCell();
                            if (dt.Rows[t]["Pay_Type"].ToString() == "0")
                            {
                                if (!string.IsNullOrEmpty(dt.Rows[t]["Ord_SinceOrderNumber"].ToString()))
                                { cell.Value = dt.Rows[t]["Ord_SinceOrderNumber"].ToString().Trim(); }
                                else
                                { cell.Value = dt.Rows[t]["Pay_OrdNumber"].ToString().Trim(); }
                            }
                            else if (dt.Rows[t]["Pay_Type"].ToString() == "1")
                            { cell.Value = dt.Rows[t]["Tsorder_Name"].ToString().Trim(); }
                            else if (dt.Rows[t]["Pay_Type"].ToString() == "2")
                            { cell.Value = dt.Rows[t]["Pay_ReceivableProject"].ToString().Trim(); }
                            dgvr.Cells.Add(cell);
                            //开单人
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Pay_UserName"].ToString();
                            dgvr.Cells.Add(cell);
                            //客户
                            cell = new DataGridViewTextBoxCell();
                            if (dt.Rows[t]["Pay_Type"].ToString() == "0")
                            { cell.Value = dt.Rows[t]["Ord_CustomerName1"].ToString().Trim(); }
                            else if (dt.Rows[t]["Pay_Type"].ToString() == "1")
                            { cell.Value = dt.Rows[t]["Tsorder_CustomerName"].ToString().Trim(); }
                            else if (dt.Rows[t]["Pay_Type"].ToString() == "2")
                            { cell.Value = dt.Rows[t]["Cus_Name"].ToString().Trim(); }
                            dgvr.Cells.Add(cell);
                            //金额
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = Convert.ToDecimal(dt.Rows[t]["Pay_AmountOf"]).ToString();
                            dgvr.Cells.Add(cell);

                            //项目类别
                            cell = new DataGridViewTextBoxCell();
                            if (dt.Rows[t]["Pay_Category"].ToString() != "后期收款")
                            { cell.Value = dt.Rows[t]["Pay_Category"].ToString(); }
                            else
                            {
                                if (!string.IsNullOrEmpty(dt.Rows[t]["Cus_Name"].ToString()))
                                { cell.Value = dt.Rows[t]["Pay_ReceivableProject"].ToString(); }
                                else
                                { cell.Value = dt.Rows[t]["Pay_TwoPinsCategoryName"].ToString(); }
                            }
                            dgvr.Cells.Add(cell);
                            //收入/支出
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = "收入";
                            dgvr.Cells.Add(cell);
                            //日期
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt.Rows[t]["Pay_CreateDatetime"], "yyyy-MM-dd HH:mm");
                            dgvr.Cells.Add(cell);
                            //支付方式
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Pay_PaymentMethodName"].ToString().Trim();
                            dgvr.Cells.Add(cell);
                            //收银
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Pay_ThePayeeName"].ToString().Trim();
                            dgvr.Cells.Add(cell);
                            //财务审核
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Pay_FinancialAudit"].ToString().Trim() == "" ? "未审核/" : dt.Rows[t]["Pay_FinancialAudit"].ToString().Trim() + "/" + dt.Rows[t]["Pay_FinancialAuditdPeopleName"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            if (string.IsNullOrEmpty(dt.Rows[t]["Pay_FinancialAudit"].ToString().Trim()) || dt.Rows[t]["Pay_FinancialAudit"].ToString().Trim() == "审核不通过")
                            { dgvr.DefaultCellStyle.ForeColor = Color.Red; }
                            else
                            { dgvr.DefaultCellStyle.ForeColor = Color.Blue; }

                            this.dgv.Rows.Add(dgvr);
                        }
                        this.dgv.ClearSelection();
                    }));
                }
            });
            #endregion
        }
        /// <summary>
        /// 获取会员充值
        /// </summary>
        public void GetMemberCardRechargeRecord()
        {
            StringBuilder str = new StringBuilder();
            string time = Convert.ToDateTime(this.numYear.Value + "-" + this.numMonth.Value + "-" + this.numDay.Value).ToString("yyyy-MM-dd");
            str.Append(PublicCodeClasses.GetDateTime("Mcrr_CreateDatetime", time, time));
            if (!string.IsNullOrEmpty(this.cmbPay_PaymentMethod.Text) && this.cmbPay_PaymentMethod.Tag != null)
            { str.Append(" and Mcrr_PaymentMethod='" + this.cmbPay_PaymentMethod.Tag.ToString() + "'"); }
            #region 获取会员充值
            LYFZ.ComponentLibrary.FrmLoadHandling.LoadDoWorkMethod(delegate(object obj, BackgroundWorker backgroundWorker)
            {
                DataTable dt = mcrrbll.GetView_MemberCardRechargeRecord(str.ToString()).Tables[0];
                if (dt.Rows.Count > 0)
                {
                    this.Invoke(new UpdateControl(delegate()
                    {
                        for (int t = 0; t < dt.Rows.Count; t++)
                        {
                            DataGridViewRow dgvr = new DataGridViewRow();
                            DataGridViewCell cell = null;
                            //编号
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["ID"].ToString();
                            dgvr.Cells.Add(cell);
                            //项目名称
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Mcrr_RechargeName"].ToString().Trim();
                            dgvr.Cells.Add(cell);
                            //开单人
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = userbll.GetUserName(dt.Rows[t]["Mcrr_OrderPerson"].ToString().Trim());
                            dgvr.Cells.Add(cell);
                            //客户/备注
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Cus_Name"].ToString().Trim();
                            dgvr.Cells.Add(cell);
                            //金额
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = Convert.ToDecimal(dt.Rows[t]["Mcrr_RechargeAmount"]).ToString();
                            dgvr.Cells.Add(cell);
                            //项目类别
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = "会员充值";
                            dgvr.Cells.Add(cell);
                            //收入/支出
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = "收入";
                            dgvr.Cells.Add(cell);
                            //日期
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt.Rows[t]["Mcrr_CreateDatetime"], "yyyy-MM-dd HH:mm");
                            dgvr.Cells.Add(cell);
                            //支付方式
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Mcrr_PaymentMethodName"].ToString().Trim(); ;
                            dgvr.Cells.Add(cell);
                            //收银
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = userbll.GetUserName(dt.Rows[t]["Mcrr_CreateName"].ToString().Trim());
                            dgvr.Cells.Add(cell);
                            //财务审核
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Mcrr_FinancialAudit"].ToString().Trim() == "" ? "未审核/" : dt.Rows[t]["Mcrr_FinancialAudit"].ToString().Trim() + "/" + userbll.GetUserName(dt.Rows[t]["Mcrr_FinancialAuditName"].ToString().Trim());
                            dgvr.Cells.Add(cell);

                            if (string.IsNullOrEmpty(dt.Rows[t]["Mcrr_FinancialAudit"].ToString().Trim()) || dt.Rows[t]["Mcrr_FinancialAudit"].ToString().Trim() == "审核不通过")
                            { dgvr.DefaultCellStyle.ForeColor = Color.Red; }
                            else
                            { dgvr.DefaultCellStyle.ForeColor = Color.Blue; }

                            this.dgv.Rows.Add(dgvr);
                        }
                        this.dgv.ClearSelection();
                    }));
                }
            });
            #endregion
        }
        /// <summary>
        /// 获取服务卡消费充值
        /// </summary>
        public void GetMemberCardPayment()
        {
            StringBuilder str = new StringBuilder();
            string time = Convert.ToDateTime(this.numYear.Value + "-" + this.numMonth.Value + "-" + this.numDay.Value).ToString("yyyy-MM-dd");
            str.Append(PublicCodeClasses.GetDateTime("创建日期", time, time));
            if (!string.IsNullOrEmpty(this.cmbPay_PaymentMethod.Text) && this.cmbPay_PaymentMethod.Tag != null)
            { str.Append(" and 付款方式编号='" + this.cmbPay_PaymentMethod.Tag.ToString() + "'"); }
            #region 获取服务卡消费充值
            LYFZ.ComponentLibrary.FrmLoadHandling.LoadDoWorkMethod(delegate(object obj, BackgroundWorker backgroundWorker)
            {
                DataTable dt = avstbll.Vw_ErpMemberCardPayment(str.ToString()).Tables[0];
                if (dt.Rows.Count > 0)
                {
                    this.Invoke(new UpdateControl(delegate()
                    {
                        for (int t = 0; t < dt.Rows.Count; t++)
                        {
                            DataGridViewRow dgvr = new DataGridViewRow();
                            DataGridViewCell cell = null;
                            //编号
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["ID"].ToString();
                            dgvr.Cells.Add(cell);
                            //项目名称
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["服务套系类别名称"].ToString().Trim();
                            dgvr.Cells.Add(cell);
                            //开单人
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["接单人名称"].ToString().Trim();
                            dgvr.Cells.Add(cell);
                            //客户/备注
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["客户姓名"].ToString().Trim();
                            dgvr.Cells.Add(cell);
                            //金额
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = Convert.ToDecimal(dt.Rows[t]["收款金额"]).ToString();
                            dgvr.Cells.Add(cell);
                            //项目类别
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["收款类型"].ToString();
                            dgvr.Cells.Add(cell);
                            //收入/支出
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = "收入";
                            dgvr.Cells.Add(cell);
                            //日期
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt.Rows[t]["创建日期"], "yyyy-MM-dd HH:mm");
                            dgvr.Cells.Add(cell);
                            //支付方式
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["支付方式名称"].ToString().Trim(); ;
                            dgvr.Cells.Add(cell);
                            //收银
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["创建人名称"].ToString().Trim();
                            dgvr.Cells.Add(cell);
                            //财务审核
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["财务审核状态"].ToString().Trim() == "" ? "未审核/" : dt.Rows[t]["财务审核状态"].ToString().Trim() + "/" + userbll.GetUserName(dt.Rows[t]["账务审核人"].ToString().Trim());
                            dgvr.Cells.Add(cell);

                            if (string.IsNullOrEmpty(dt.Rows[t]["财务审核状态"].ToString().Trim()) || dt.Rows[t]["财务审核状态"].ToString().Trim() == "审核不通过")
                            { dgvr.DefaultCellStyle.ForeColor = Color.Red; }
                            else
                            { dgvr.DefaultCellStyle.ForeColor = Color.Blue; }

                            this.dgv.Rows.Add(dgvr);
                        }
                        this.dgv.ClearSelection();
                    }));
                }
            });
            #endregion
        }
        /// <summary>
        /// 财务支出
        /// </summary>
        /// <param name="StrPaymentType">其他收款类型:  -1:全部，0:财务支出，1:店面支出，2:其它收入</param>
        public void BindFinancialExpenses(int StrPaymentType)
        {
            StringBuilder str = new StringBuilder();
            string time = Convert.ToDateTime(this.numYear.Value + "-" + this.numMonth.Value + "-" + this.numDay.Value).ToString("yyyy-MM-dd");
            str.Append(PublicCodeClasses.GetDateTime("Oiae_IEDatetime", time, time, ConnectWord: ""));
            if (StrPaymentType == 0)
            { str.Append(" and Oiae_Type='财务支出'"); }
            else if (StrPaymentType == 1)
            { str.Append(" and Oiae_Type='支出'"); }
            else if (StrPaymentType == 2)
            { str.Append(" and Oiae_Type='收入'"); }
            if (!string.IsNullOrEmpty(this.cmbPay_PaymentMethod.Text) && this.cmbPay_PaymentMethod.Tag != null)
            { str.Append(" and Oiae_PaymentMethod='" + this.cmbPay_PaymentMethod.Tag.ToString() + "'"); }
            if (this.cmbProjectSearch.Text == "财务支出" || this.cmbProjectSearch.Text == "店面支出")
            {
                if (!string.IsNullOrEmpty(this.CtvTsorder_Name.Text))
                { str.Append(" and Oiae_ProjectName='" + this.CtvTsorder_Name.Text.ToString() + "'"); }
            }
            #region 获取财务支出
            LYFZ.ComponentLibrary.FrmLoadHandling.LoadDoWorkMethod(delegate(object obj, BackgroundWorker backgroundWorker)
            {
                DataTable dt = oiebll.View_ErpOtherIncomeAndExpenses(str.ToString()).Tables[0];
                if (dt.Rows.Count > 0)
                {
                    this.Invoke(new UpdateControl(delegate()
                    {
                        for (int t = 0; t < dt.Rows.Count; t++)
                        {
                            DataGridViewRow dgvr = new DataGridViewRow();
                            DataGridViewCell cell = null;
                            //编号
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["ID"].ToString();
                            dgvr.Cells.Add(cell);
                            //项目名称
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Oiae_ProjectName"].ToString().Trim();
                            dgvr.Cells.Add(cell);
                            //开单人
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Oiae_PersonHandlingName"].ToString().Trim();
                            dgvr.Cells.Add(cell);
                            //客户/备注
                            cell = new DataGridViewTextBoxCell();
                            if (dt.Rows[t]["Oiae_Type"].ToString().Trim() == "收入")
                            { cell.Value = dt.Rows[t]["Oiae_ThePayer"].ToString().Trim(); }
                            else
                            { cell.Value = dt.Rows[t]["User_Name"].ToString().Trim() + "/" + dt.Rows[t]["Oiae_Remark"].ToString(); }
                            dgvr.Cells.Add(cell);
                            //金额
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = Convert.ToDecimal(dt.Rows[t]["Oiae_Money"]).ToString();
                            dgvr.Cells.Add(cell);
                            //项目类别
                            cell = new DataGridViewTextBoxCell();
                            if (dt.Rows[t]["Oiae_Type"].ToString().Trim() == "财务支出")
                            { cell.Value = "固定费用"; }
                            else if (dt.Rows[t]["Oiae_Type"].ToString().Trim() == "支出")
                            { cell.Value = "固定费用"; }
                            else if (dt.Rows[t]["Oiae_Type"].ToString().Trim() == "收入")
                            { cell.Value = "其它收入"; }
                            dgvr.Cells.Add(cell);
                            //收入/支出
                            cell = new DataGridViewTextBoxCell();
                            if (dt.Rows[t]["Oiae_Type"].ToString().Trim() == "财务支出")
                            { cell.Value = "财务支出"; }
                            else if (dt.Rows[t]["Oiae_Type"].ToString().Trim() == "支出")
                            { cell.Value = "店面支出"; }
                            else if (dt.Rows[t]["Oiae_Type"].ToString().Trim() == "收入")
                            { cell.Value = "收入"; }
                            dgvr.Cells.Add(cell);
                            //日期
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt.Rows[t]["Oiae_IEDatetime"], "yyyy-MM-dd HH:mm");
                            dgvr.Cells.Add(cell);
                            //支付方式
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Oiae_PaymentMethodName"].ToString();
                            dgvr.Cells.Add(cell);
                            //收银
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Oiae_PersonHandlingName"].ToString().Trim();
                            dgvr.Cells.Add(cell);
                            //财务审核
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Oiae_FinancialAuditState"].ToString().Trim() + "/" + dt.Rows[t]["Oiae_FinancialAuditPeopleName"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            if (dt.Rows[t]["Oiae_FinancialAuditState"].ToString().Trim() == "未审核" || dt.Rows[t]["Oiae_FinancialAuditState"].ToString().Trim() == "审核不通过")
                            { dgvr.DefaultCellStyle.ForeColor = Color.Red; }
                            else
                            { dgvr.DefaultCellStyle.ForeColor = Color.Blue; }

                            this.dgv.Rows.Add(dgvr);
                        }
                        this.dgv.ClearSelection();
                    }));
                }
            });
            #endregion
        }
        /// <summary>
        /// 获取押金
        /// </summary>
        public void BindDeposit()
        {
            decimal Sum = 0;
            LYFZ.ComponentLibrary.FrmLoadHandling.LoadDoWorkMethod(delegate(object obj, BackgroundWorker backgroundWorker)
            {
                DataTable dt = dsrobll.View_DressSaleRentalOrder(" and Dsro_Type='0'").Tables[0];
                this.Invoke(new UpdateControl(delegate()
                {
                    #region
                    for (int t = 0; t < dt.Rows.Count; t++)
                    {
                        decimal deAmount = 0;
                        DataTable dt_DressRefundRecord = drrbll.GetSun(" and DRR_Number='" + dt.Rows[t]["Dsro_Number"].ToString().Trim() + "'").Tables[0];
                        if (!string.IsNullOrEmpty(dt_DressRefundRecord.Rows[0]["DRR_Money"].ToString()))
                        { deAmount = Convert.ToDecimal(dt.Rows[t]["Dsro_MortgageAmount"].ToString().Trim()) - Convert.ToDecimal(dt_DressRefundRecord.Rows[0]["DRR_Money"].ToString()); }
                        else
                        { deAmount = Convert.ToDecimal(dt.Rows[t]["Dsro_MortgageAmount"].ToString().Trim()); }
                        Sum += deAmount;
                        if (deAmount <= 0)
                        { continue; }

                        DataGridViewRow dgvr = new DataGridViewRow();
                        DataGridViewCell cell = null;
                        //编号
                        cell = new DataGridViewTextBoxCell();
                        cell.Value = dt.Rows[t]["ID"].ToString();
                        dgvr.Cells.Add(cell);
                        //项目名称
                        cell = new DataGridViewTextBoxCell();
                        cell.Value = dt.Rows[t]["Dsro_Number"].ToString().Trim();
                        dgvr.Cells.Add(cell);
                        //开单人
                        cell = new DataGridViewTextBoxCell();
                        cell.Value = userbll.GetUserName(dt.Rows[t]["Dsro_CreateName"].ToString());
                        dgvr.Cells.Add(cell);
                        //客户
                        cell = new DataGridViewTextBoxCell();
                        cell.Value = dt.Rows[t]["Cus_Name"].ToString().Trim();
                        dgvr.Cells.Add(cell);
                        //押金  
                        cell = new DataGridViewTextBoxCell();
                        cell.Value = deAmount;
                        dgvr.Cells.Add(cell);
                        //项目类别
                        cell = new DataGridViewTextBoxCell();
                        cell.Value = "礼服出租押金";
                        dgvr.Cells.Add(cell);
                        //收入/支出
                        cell = new DataGridViewTextBoxCell();
                        cell.Value = "押金";
                        dgvr.Cells.Add(cell);
                        //日期
                        cell = new DataGridViewTextBoxCell();
                        cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt.Rows[t]["Dsro_CreateDateTime"], "yyyy-MM-dd HH:mm");
                        dgvr.Cells.Add(cell);
                        //支付方式
                        cell = new DataGridViewTextBoxCell();
                        cell.Value = "现金";
                        dgvr.Cells.Add(cell);
                        //收银
                        cell = new DataGridViewTextBoxCell();
                        cell.Value = "";
                        dgvr.Cells.Add(cell);
                        //财务审核
                        cell = new DataGridViewTextBoxCell();
                        cell.Value = "";
                        dgvr.Cells.Add(cell);

                        this.dgv.Rows.Add(dgvr);
                    }
                    #endregion
                    this.dgv.ClearSelection();
                    this.txtDeposit.Text = Sum.ToString();
                }));
            });
        }
        /// <summary>
        /// 所以查询事件绑定
        /// </summary>
        public void BindSelect()
        {
            this.dgv.Rows.Clear();
            if (this.cmbProjectSearch.Text == "全部")
            {
                // 获取订单收款/其它二销/礼服租售记录
                this.BindOrdersReceivables();
                // 获取会员充值
                this.GetMemberCardRechargeRecord();
                // 获取现金支出
                this.BindFinancialExpenses(-1);
                // 服务卡消费收入
                this.GetMemberCardPayment();
            }
            else if (this.cmbProjectSearch.Text == "订单前期收入")// 获取订单收款/其它二销/礼服租售记录
            { this.BindOrdersReceivables(); }
            else if (this.cmbProjectSearch.Text == "订单后期收入") // 获取订单收款/其它二销/礼服租售记录
            { this.BindOrdersReceivables(); }
            else if (this.cmbProjectSearch.Text == "其它消费收入") // 获取订单收款/其它二销/礼服租售记录
            { this.BindOrdersReceivables(); }
            else if (this.cmbProjectSearch.Text == "其它收入")
            { this.BindFinancialExpenses(2); }
            else if (this.cmbProjectSearch.Text == "会员充值收入")
            { this.GetMemberCardRechargeRecord(); }
            else if (this.cmbProjectSearch.Text == "服务卡消费收入")
            { this.GetMemberCardPayment(); }
            else if (this.cmbProjectSearch.Text == "礼服租售收入")// 获取订单收款/其它二销/礼服租售记录
            { this.BindOrdersReceivables(); }
            else if (this.cmbProjectSearch.Text == "店面支出")
            { this.BindFinancialExpenses(1); }
            else if (this.cmbProjectSearch.Text == "财务支出")
            { this.BindFinancialExpenses(0); }
            else if (this.cmbProjectSearch.Text == "押金")
            { this.BindDeposit(); }
            //获取文本框金额
            this.BindTotal();
        }
        /// <summary>
        /// 获取订单收款
        /// </summary>
        /// <param name="time"></param>
        /// <param name="IsPaymentType">True:前期,False:后期</param>
        /// <returns></returns>
        decimal GetOrderPayment(string time, bool IsPaymentType)
        {
            decimal sum = 0;
            string StrWhere = PublicCodeClasses.GetDateTime("Pay_CreateDatetime", time, time, ConnectWord: "") + " and Pay_PaymentMethod!='BEBCABAJBDFBBJGID'";
            //string StrWhere = PublicCodeClasses.GetDateTime("Pay_CreateDatetime", time, time, ConnectWord: "") + " and (Pay_PaymentMethod!='BEBACCAFEGECFBJFD' and Pay_PaymentMethod!='BEBCABAJBDFBBJGID')";
            if (IsPaymentType)
            { StrWhere += " and Pay_Category!='后期收款'"; }
            else
            { StrWhere += " and Pay_Category='后期收款' and Pay_Type in (0,1)"; }
            DataTable dt = wsbll.GetTwoPieSum(StrWhere).Tables[0];
            if (!string.IsNullOrEmpty(dt.Rows[0]["Pay_AmountOf"].ToString()))
            { sum = Convert.ToDecimal(dt.Rows[0]["Pay_AmountOf"]); }
            return sum;
        }
        /// <summary>
        /// 获取收款记录金额
        /// </summary>
        /// <param name="time"></param>
        /// <param name="Symbol"></param>
        /// <returns></returns>
        decimal TotalRevenueSun(string time, string Symbol)
        {
            decimal sum = 0;
            StringBuilder str = new StringBuilder();
            str.Append("" + Symbol + " " + PublicCodeClasses.GetDateTime("Pay_CreateDatetime", time, time, ConnectWord: ""));
            if (!string.IsNullOrEmpty(this.cmbPay_PaymentMethod.Text) && this.cmbPay_PaymentMethod.Tag != null)
            { str.Append(" and Pay_PaymentMethod='" + this.cmbPay_PaymentMethod.Tag.ToString() + "'"); }
            #region 项目查询
            if (this.cmbProjectSearch.Text != "全部")
            {
                if (this.cmbProjectSearch.Text == "订单前期收入")
                {
                    if (string.IsNullOrEmpty(this.CtvTsorder_Name.Text))
                    { str.Append(" and Pay_Category!='后期收款'"); }
                    else
                    { str.Append(" and Pay_Category='" + this.CtvTsorder_Name.Text.ToString() + "'"); }
                }
                else if (this.cmbProjectSearch.Text == "订单后期收入")
                {
                    if (string.IsNullOrEmpty(this.CtvTsorder_Name.Text))
                    { str.Append(" and  Pay_Category='后期收款' and Pay_Type=0"); }
                    else
                    { str.Append("and  Pay_Category='后期收款' and Pay_Type=0 and Pay_TwoPinsCategory='" + this.CtvTsorder_Name.Tag.ToString() + "'"); }
                }
                else if (this.cmbProjectSearch.Text == "其它消费收入")
                {
                    if (string.IsNullOrEmpty(this.CtvTsorder_Name.Text))
                    { str.Append(" and  Pay_Category='后期收款' and  Pay_Type=1"); }
                    else
                    { str.Append("and  Pay_Category='后期收款' and  Pay_Type=1 and Pay_TwoPinsCategory='" + this.CtvTsorder_Name.Tag.ToString() + "'"); }
                }
                else if (this.cmbProjectSearch.Text == "礼服租售收入")
                {
                    if (string.IsNullOrEmpty(this.CtvTsorder_Name.Text))
                    { str.Append(" and  Pay_Category='后期收款' and  Pay_Type=2"); }
                    else
                    { str.Append("and  Pay_Category='后期收款' and  Pay_Type=2 and Pay_ReceivableProject='" + this.CtvTsorder_Name.Text.ToString() + "'"); }
                }
            }
            #endregion
            DataTable dt = wsbll.GetTwoPieSum(str.ToString()).Tables[0];
            if (!string.IsNullOrEmpty(dt.Rows[0]["Pay_AmountOf"].ToString()))
            { sum = Convert.ToDecimal(dt.Rows[0]["Pay_AmountOf"]); }
            return sum;
        }
        /// <summary>
        /// 获取会员充值金额
        /// </summary>
        /// <param name="Time"></param>
        /// <returns></returns>
        decimal MembersRechargeSum(string time)
        {
            decimal sum = 0;
            StringBuilder str = new StringBuilder();
            str.Append(PublicCodeClasses.GetDateTime("Mcrr_CreateDatetime", time, time, ConnectWord: ""));
            if (!string.IsNullOrEmpty(cmbPay_PaymentMethod.Text) && cmbPay_PaymentMethod.Tag != null)
            { str.Append(" and Mcrr_PaymentMethod='" + cmbPay_PaymentMethod.Tag.ToString() + "'"); }
            DataTable dt = wsbll.GetMembersRechargeSum(str.ToString()).Tables[0];
            if (!string.IsNullOrEmpty(dt.Rows[0]["Mcrr_RechargeAmount"].ToString()))
            { sum = Convert.ToDecimal(dt.Rows[0]["Mcrr_RechargeAmount"]); }
            return sum;
        }
        /// <summary>
        /// 获取服务卡消费充值金额
        /// </summary>
        /// <param name="Time"></param>
        /// <returns></returns>
        decimal MemberCardPayment(string time)
        {
            decimal sum = 0;
            StringBuilder str = new StringBuilder();
            str.Append(PublicCodeClasses.GetDateTime("创建日期", time, time));
            if (!string.IsNullOrEmpty(cmbPay_PaymentMethod.Text) && cmbPay_PaymentMethod.Tag != null)
            { str.Append(" and 付款方式编号='" + cmbPay_PaymentMethod.Tag.ToString() + "'"); }
            DataTable dt = avstbll.GetMemberCardPaymentSum(str.ToString()).Tables[0];
            if (!string.IsNullOrEmpty(dt.Rows[0]["收款金额"].ToString()))
            { sum = Convert.ToDecimal(dt.Rows[0]["收款金额"]); }
            return sum;
        }
        /// <summary>
        /// 财务支出金额
        /// </summary>
        /// <param name="Time"></param>
        /// <returns></returns>
        decimal FinancialExpensesSum(string StrLoadType)
        {
            string time = Convert.ToDateTime(this.numYear.Value + "-" + this.numMonth.Value + "-" + this.numDay.Value).ToString("yyyy-MM-dd");
            decimal sum = 0;
            StringBuilder str = new StringBuilder();
            string StrType = "";
            if (StrLoadType.Trim() == "财务支出")
            { StrType = "财务支出"; }
            else if (StrLoadType.Trim() == "店面支出")
            { StrType = "支出"; }
            else if (StrLoadType.Trim() == "其它收入")
            { StrType = "收入"; }
            //else if(this.cmbProjectSearch.Text.Trim() == "全部")
            //{}
            str.Append(PublicCodeClasses.GetDateTime("Oiae_IEDatetime", time, time, ConnectWord: ""));
            if (!string.IsNullOrEmpty(StrType))
            { str.Append(" and Oiae_Type='" + StrType + "' "); }
            if (!string.IsNullOrEmpty(this.cmbPay_PaymentMethod.Text) && this.cmbPay_PaymentMethod.Tag != null)
            { str.Append("and Oiae_PaymentMethod='" + this.cmbPay_PaymentMethod.Tag.ToString() + "'"); }
            if (this.CtvTsorder_Name.Visible)
            {
                if (!string.IsNullOrEmpty(this.CtvTsorder_Name.Text) && this.CtvTsorder_Name.Text != "全部")
                { str.Append("and Oiae_ProjectName='" + this.CtvTsorder_Name.Text.ToString() + "'"); }
            }
            DataTable dt = wsbll.GetOtherIncomeSum(str.ToString()).Tables[0];
            if (!string.IsNullOrEmpty(dt.Rows[0]["Oiae_Money"].ToString()))
            { sum = Convert.ToDecimal(dt.Rows[0]["Oiae_Money"]); }
            return sum;
        }
        /// <summary>
        /// 文本框合计获取值
        /// </summary>
        public void BindTotal()
        {
            string time = Convert.ToDateTime(this.numYear.Value + "-" + this.numMonth.Value + "-" + this.numDay.Value).ToString("yyyy-MM-dd");
            if (this.cmbProjectSearch.Text == "全部")
            {
                //收入
                this.txtTotalRevenue.Text = (this.TotalRevenueSun(time, "(Pay_PaymentMethod!='BEBACCAFEGECFBJFD' and Pay_PaymentMethod!='BEBCABAJBDFBBJGID') and ") + this.MembersRechargeSum(time) + this.MemberCardPayment(time)).ToString();
                //营业收入
                this.txtOperatingIncome.Text = (this.TotalRevenueSun(time, "") + this.FinancialExpensesSum("其它收入")).ToString();
                ////收入
                //this.txtTotalRevenue.Text = (this.TotalRevenueSun(time, "") + this.FinancialExpensesSum()).ToString();
                ////营业收入
                //this.txtOperatingIncome.Text = (this.TotalRevenueSun(time, "(Pay_PaymentMethod!='BEBACCAFEGECFBJFD' and Pay_PaymentMethod!='BEBCABAJBDFBBJGID') and ") + this.MembersRechargeSum(time) + this.MemberCardPayment(time)).ToString();
                //总支出
                this.txtTotalExpenditure.Text = this.FinancialExpensesSum("店面支出").ToString();
                //净收入
                this.txtNetIncome.Text = (Convert.ToDecimal(this.txtTotalRevenue.Text) - Convert.ToDecimal(this.txtTotalExpenditure.Text)).ToString();
            }
            else if (this.cmbProjectSearch.Text == "订单前期收入")
            {
                //收入
                this.txtTotalRevenue.Text = this.TotalRevenueSun(time, "(Pay_PaymentMethod!='BEBACCAFEGECFBJFD' and Pay_PaymentMethod!='BEBCABAJBDFBBJGID') and ").ToString();
                //营业收入
                this.txtOperatingIncome.Text = this.TotalRevenueSun(time, "").ToString();
                //总支出
                this.txtTotalExpenditure.Text = "0";
                //净收入
                this.txtNetIncome.Text = (Convert.ToDecimal(this.txtTotalRevenue.Text) - Convert.ToDecimal(this.txtTotalExpenditure.Text)).ToString();
            }
            else if (this.cmbProjectSearch.Text == "订单后期收入")
            {
                //收入
                this.txtTotalRevenue.Text = this.TotalRevenueSun(time, "(Pay_PaymentMethod!='BEBACCAFEGECFBJFD' and Pay_PaymentMethod!='BEBCABAJBDFBBJGID') and ").ToString();
                //营业收入
                this.txtOperatingIncome.Text = this.TotalRevenueSun(time, "").ToString();
                //总支出
                this.txtTotalExpenditure.Text = "0";
                //净收入
                this.txtNetIncome.Text = (Convert.ToDecimal(this.txtTotalRevenue.Text) - Convert.ToDecimal(this.txtTotalExpenditure.Text)).ToString();
            }
            else if (this.cmbProjectSearch.Text == "其它消费收入")
            {
                //收入
                this.txtTotalRevenue.Text = this.TotalRevenueSun(time, "(Pay_PaymentMethod!='BEBACCAFEGECFBJFD' and Pay_PaymentMethod!='BEBCABAJBDFBBJGID') and ").ToString();
                //营业收入
                this.txtOperatingIncome.Text = this.TotalRevenueSun(time, "  ").ToString();
                //总支出
                this.txtTotalExpenditure.Text = "0";
                //净收入
                this.txtNetIncome.Text = (Convert.ToDecimal(this.txtTotalRevenue.Text) - Convert.ToDecimal(this.txtTotalExpenditure.Text)).ToString();
            }
            else if (this.cmbProjectSearch.Text == "其它收入")
            {
                //收入
                this.txtTotalRevenue.Text = this.FinancialExpensesSum("其它收入").ToString();
                //营业收入
                this.txtOperatingIncome.Text = "0";
                //总支出
                this.txtTotalExpenditure.Text = "0";
                //净收入
                this.txtNetIncome.Text = (Convert.ToDecimal(this.txtTotalRevenue.Text) - Convert.ToDecimal(this.txtTotalExpenditure.Text)).ToString();
            }
            else if (this.cmbProjectSearch.Text == "会员充值收入")
            {
                //收入
                this.txtTotalRevenue.Text = "0";
                //营业收入
                this.txtOperatingIncome.Text = this.MembersRechargeSum(time).ToString();
                //总支出
                this.txtTotalExpenditure.Text = "0";
                //净收入
                this.txtNetIncome.Text = (Convert.ToDecimal(this.txtTotalRevenue.Text) - Convert.ToDecimal(this.txtTotalExpenditure.Text)).ToString();
            }
            else if (this.cmbProjectSearch.Text == "服务卡消费收入")
            {
                //收入
                this.txtTotalRevenue.Text = "0";
                //营业收入
                this.txtOperatingIncome.Text = this.MemberCardPayment(time).ToString();
                //总支出
                this.txtTotalExpenditure.Text = "0";
                //净收入
                this.txtNetIncome.Text = (Convert.ToDecimal(this.txtTotalRevenue.Text) - Convert.ToDecimal(this.txtTotalExpenditure.Text)).ToString();
            }
            else if (this.cmbProjectSearch.Text == "礼服租售收入")
            {
                //收入
                this.txtTotalRevenue.Text = this.TotalRevenueSun(time, "(Pay_PaymentMethod!='BEBACCAFEGECFBJFD' and Pay_PaymentMethod!='BEBCABAJBDFBBJGID') and ").ToString();
                //营业收入
                this.txtOperatingIncome.Text = this.TotalRevenueSun(time, "  ").ToString();
                //总支出
                this.txtTotalExpenditure.Text = "0";
                //净收入
                this.txtNetIncome.Text = (Convert.ToDecimal(this.txtTotalRevenue.Text) - Convert.ToDecimal(this.txtTotalExpenditure.Text)).ToString();
            }
            else if (this.cmbProjectSearch.Text == "店面支出")
            {
                //收入
                this.txtTotalRevenue.Text = "0";
                //营业收入
                this.txtOperatingIncome.Text = "0";
                //总支出
                this.txtTotalExpenditure.Text = this.FinancialExpensesSum("店面支出").ToString();
                //净收入
                this.txtNetIncome.Text = (Convert.ToDecimal(this.txtTotalRevenue.Text) - Convert.ToDecimal(this.txtTotalExpenditure.Text)).ToString();
            }
            else if (this.cmbProjectSearch.Text == "财务支出")
            {
                //收入
                this.txtTotalRevenue.Text = "0";
                //营业收入
                this.txtOperatingIncome.Text = "0";
                //总支出
                this.txtTotalExpenditure.Text = this.FinancialExpensesSum("财务支出").ToString();
                //净收入
                this.txtNetIncome.Text = (Convert.ToDecimal(this.txtTotalRevenue.Text) - Convert.ToDecimal(this.txtTotalExpenditure.Text)).ToString();
            }
            else if (this.cmbProjectSearch.Text == "押金")
            {
                //收入
                this.txtTotalRevenue.Text = "0";
                //营业收入
                this.txtOperatingIncome.Text = "0";
                //总支出
                this.txtTotalExpenditure.Text = "0";
                //净收入
                this.txtNetIncome.Text = "0";
            }
            //订单前期
            this.txtPreliminaryResults.Text = this.GetOrderPayment(time, true).ToString();
            //订单后期
            this.txtLateResults.Text = this.GetOrderPayment(time, false).ToString();
        }
        /// <summary>
        /// 项目查询选择事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void cmbProjectSearch_SelectedValueChanged(object sender, EventArgs e)
        {
            try
            {
                this.CtvTsorder_Name.Text = "";
                this.dgv.Rows.Clear();
                if (this.cmbProjectSearch.Text == "全部")
                {
                    this.CtvTsorder_Name.Visible = false;
                    // 获取订单收款/其它二销/礼服租售记录
                    this.BindOrdersReceivables();
                    // 获取会员充值
                    this.GetMemberCardRechargeRecord();
                    // 获取现金支出
                    this.BindFinancialExpenses(-1);
                    // 服务卡消费收入
                    this.GetMemberCardPayment();
                }
                else if (this.cmbProjectSearch.Text == "订单前期收入")
                {
                    this.CtvTsorder_Name.Visible = true;
                    this.CtvTsorder_Name.TreeView.Nodes.Clear();
                    this.CtvTsorder_Name.Nodes.Add("          ");
                    this.CtvTsorder_Name.Nodes.Add("预约收款");
                    this.CtvTsorder_Name.Nodes.Add("预约补款");
                    this.CtvTsorder_Name.Nodes.Add("全款");
                    // 获取订单收款/其它二销/礼服租售记录
                    this.BindOrdersReceivables();
                }
                else if (this.cmbProjectSearch.Text == "订单后期收入" || this.cmbProjectSearch.Text == "其它消费收入")
                {
                    this.CtvTsorder_Name.Visible = true;
                    LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_SystemCategory("BEBACDAJDFDDEACGJ", this.CtvTsorder_Name, true);
                    // 获取订单收款/其它二销/礼服租售记录
                    this.BindOrdersReceivables();
                }
                else if (this.cmbProjectSearch.Text == "其它收入")
                {
                    this.CtvTsorder_Name.Visible = false;
                    // 获取现金支出
                    this.BindFinancialExpenses(2);
                }
                else if (this.cmbProjectSearch.Text == "会员充值收入")
                {
                    this.CtvTsorder_Name.Visible = false;
                    // 获取会员充值
                    this.GetMemberCardRechargeRecord();
                }
                else if (this.cmbProjectSearch.Text == "服务卡消费收入")
                {
                    this.CtvTsorder_Name.Visible = false;
                    // 服务卡消费收入
                    this.GetMemberCardPayment();
                }
                else if (this.cmbProjectSearch.Text == "礼服租售收入")
                {
                    this.CtvTsorder_Name.Visible = true;
                    this.CtvTsorder_Name.TreeView.Nodes.Clear();
                    this.CtvTsorder_Name.Nodes.Add("          ");
                    this.CtvTsorder_Name.Nodes.Add("礼服出租");
                    this.CtvTsorder_Name.Nodes.Add("礼服出售");
                    // 获取订单收款/其它二销/礼服租售记录
                    this.BindOrdersReceivables();
                }
                else if (this.cmbProjectSearch.Text == "店面支出" || this.cmbProjectSearch.Text == "财务支出")
                {
                    this.CtvTsorder_Name.Visible = true;
                    if (this.cmbProjectSearch.Text == "店面支出")
                    {
                        LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_SystemCategory("BEBACIAFBEDIGJJFE", this.CtvTsorder_Name, true);
                        this.BindFinancialExpenses(1);
                    }
                    else if (this.cmbProjectSearch.Text == "财务支出")
                    {
                        LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_SystemCategory("BFAGBGBAEJBACEEHJ", this.CtvTsorder_Name, true);
                        this.BindFinancialExpenses(0);
                    }
                }
                else if (this.cmbProjectSearch.Text == "押金")
                {
                    this.CtvTsorder_Name.Visible = false;
                    // 获取押金
                    this.BindDeposit();
                }
                //获取文本框金额
                this.BindTotal();
            }
            catch (Exception ex)
            { MessageBoxCustom.Show(ex.Message); }
        }
        /// <summary>
        /// 项目名称选择事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void CtvTsorder_Name_ComboBoxTreeViewEx_TextChanged(object sender, TreeViewEventArgs e)
        { this.BindSelect(); }
        /// <summary>
        /// 选择支付方式
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void cmbPay_PaymentMethod_ComboBoxTreeViewEx_TextChanged(object sender, TreeViewEventArgs e)
        { this.BindSelect(); }
        /// <summary>
        /// 日变更事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void numDay_ValueChanged(object sender, EventArgs e)
        {
            if (this.Isbl == true)
            {
                //获取财务短信
                this.GetFinancialSMS();
                this.BindSelect();
            }
        }
        /// <summary>
        /// 月变更事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void numMonth_ValueChanged(object sender, EventArgs e)
        {
            if (this.Isbl == true)
            {
                this.numDay.Maximum = System.Threading.Thread.CurrentThread.CurrentUICulture.Calendar.GetDaysInMonth(Convert.ToInt32(this.numYear.Value), Convert.ToInt32(this.numMonth.Value));
                //获取财务短信
                this.GetFinancialSMS();
                this.BindSelect();
            }
        }
        /// <summary>
        /// 年变更事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void numYear_ValueChanged(object sender, EventArgs e)
        {
            if (this.Isbl == true)
            {
                //获取财务短信
                this.GetFinancialSMS();
                this.BindSelect();
            }
        }
        /// <summary>
        /// 打印
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void btnPrint_Click(object sender, EventArgs e)
        {
            try
            {
                string time = Convert.ToDateTime(this.numYear.Value + "-" + this.numMonth.Value + "-" + this.numDay.Value).ToString("yyyy-MM-dd");
                string StrDateWeek = time + "(" + LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.CaculateWeekDay(Convert.ToDateTime(time).DayOfWeek.ToString()) + ")";
                object StrText = this.lblFinancialSMS.Text.Trim() + "\r\n" + this.lblPayBy.Text.Trim() + "\r\n" + this.lblCount.Text.Trim();
                Hashtable htData = new Hashtable();
                htData["dgvData"] = this.dgv;
                htData["StrText"] = StrText;
                htData["StrDateWeek"] = StrDateWeek;
                LYFZ.Software.MainBusiness.ReportPrint.ReportFixedFormat.PrintFixedFormat(EnumPublic.PrintTypeEnum.财务报表日, htData);
            }
            catch (Exception ex)
            { MessageBoxCustom.Show(ex.Message); }
        }
        /// <summary>
        /// 财务审核
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void btnFinancialAudit_Click(object sender, EventArgs e)
        {
            try
            {
                if (this.dgv.SelectedRows.Count == 0)
                { MessageBoxCustom.Show("请选择你要审核的数据！"); return; }
                if (this.cmbProjectSearch.Text == "押金")
                { MessageBoxCustom.Show("此订单无需审核！"); return; }
                if (this.dgv.SelectedRows.Count > 10)
                { MessageBoxCustom.Show("最多只能选择10条审核！"); return; }
                string StrAuditText = "审核不通过";
                if (MessageBoxCustom.Show("此单审核是否通过？", "审核提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
                { StrAuditText = "已审核"; }
                #region 审核
                for (int i = 0; i < dgv.SelectedRows.Count; i++)
                {
                    string ItemCategory = this.dgv.SelectedRows[i].Cells["ItemCategory"].Value.ToString();
                    string ID = this.dgv.SelectedRows[i].Cells["ID"].Value.ToString();
                    if (ItemCategory == "固定费用" || ItemCategory == "其它收入")
                    {
                        LYFZ.Model.Model_ErpOtherIncomeAndExpenses mode = oiebll.GetModel(Convert.ToInt32(ID));
                        mode.Oiae_FinancialAuditPeople = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID;
                        mode.Oiae_FinancialAuditState = StrAuditText;
                        oiebll.Update(mode);
                    }
                    else if (ItemCategory == "会员充值")
                    {
                        LYFZ.Model.Model_ErpMemberCardRechargeRecord mode = mcrrbll.GetModel(Convert.ToInt32(ID));
                        mode.Mcrr_FinancialAuditName = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID;
                        mode.Mcrr_FinancialAudit = StrAuditText;
                        mcrrbll.Update(mode);
                    }
                    else if (ItemCategory == "服务消费")
                    {
                        LYFZ.Model.Model_ErpMemberCardPayment mode = mcptbll.GetModel(Convert.ToInt32(ID));
                        mode.Mcpt_FinancialAuditName = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID;
                        mode.Mcpt_FinancialAudit = StrAuditText;
                        mode.Mcpt_FinancialAuditDateTime = DateTime.Now;
                        mcptbll.Update(mode);
                    }
                    else if (ItemCategory != "固定费用" && ItemCategory != "其它收入" && ItemCategory != "会员充值" && ItemCategory != "服务消费")
                    {
                        LYFZ.Model.Model_ErpPayment model = ptbll.GetModel(Convert.ToInt32(ID));
                        model.Pay_FinancialAudit = StrAuditText;
                        model.Pay_FinancialAuditdPeople = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID;
                        ptbll.Update(model);
                    }
                }
                #endregion
                this.BindSelect();
            }
            catch (Exception ex)
            { MessageBoxCustom.Show(ex.Message); }
        }
        /// <summary>
        /// 导出
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void btnExPort_Click(object sender, EventArgs e)
        { this.dgv.ExportDataTable(); }
        /// <summary>
        /// 关闭
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void btnClose_Click(object sender, EventArgs e)
        { this.Close(); }
    }
}