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

using System;
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.MonthFinance
{
    public partial class FinanceDayDetails : LYFZ.Software.UI.StatisticalInquiry.MonthFinance.FinanceDayDetails
    {
        LYFZ.BLL.BLL_ErpOrder orbll = new BLL.BLL_ErpOrder();

        public FinanceDayDetails()
        {
            this.Load += FinanceDayDetails_Load;
            this.btnClosed.Click += btnClosed_Click;
        }
        public string StrID;
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void FinanceDayDetails_Load(object sender, EventArgs e)
        {
            DataTable dt = orbll.GetView_Custom("tb_ErpPayment", StrWhere: "tb_ErpPayment.ID = '" + StrID + "'", ShowColumnName: "Pay_Category,Pay_OrdNumber,Pay_AmountOf,Pay_Type,Pay_PlusPickNumber").Tables[0];
            if (dt.Rows.Count > 0)
            {
                string OrdNumber=dt.Rows[0]["Pay_OrdNumber"].ToString().Trim();//2017-03-30 刘工修改
                string Pay_PlusPickNumber = dt.Rows[0]["Pay_PlusPickNumber"].ToString().Trim();
               // decimal Pay_AmountOf = Convert.ToDecimal(dt.Rows[0]["Pay_AmountOf"].ToString().Trim());//本次收款金


                DataSet dtSet = new DataSet();
                DataTable dtOrder = new DataTable();
                DataTable dtArrears = new DataTable();
                string StrTableName = "select (套系金额 + isnull(加挑金额,0) -isnull(收款金额,0)) AS 欠款 from BView_OrderAmount where Order_Number = '" + OrdNumber + "';";
                switch (dt.Rows[0]["Pay_Category"].ToString().Trim())
                {
                    case "预约收款":
                    case "预约补款":
                    case "全款":
                        StrTableName += "select Ord_SinceOrderNumber,Ord_OrderClass,Ord_SeriesName,Ord_SeriesPrice,Cus_Name,Ord_Remark,Cus_Telephone from tb_ErpOrder Left Join tempTB_AggregationCustomer on GP_OrderNumber = Ord_Number Where Ord_Number = '" + OrdNumber + "'";
                        dtSet = orbll.GetView_Custom(StrTableName);
                        dtArrears = dtSet.Tables["ds"];
                        dtOrder = dtSet.Tables["ds1"];
                        this.txtClientArrears.Text = dtArrears.Rows[0]["欠款"].ToString().Trim();
                        if (dtOrder.Rows.Count > 0)
                        {
                            this.txtClientName.Text = dtOrder.Rows[0]["Cus_Name"].ToString().Trim();
                            this.txtOrderClass.Text = dtOrder.Rows[0]["Ord_OrderClass"].ToString().Trim();
                            this.txtOrderNumber.Text = dtOrder.Rows[0]["Ord_SinceOrderNumber"].ToString().Trim();
                            this.txtRemark.Text = dtOrder.Rows[0]["Ord_Remark"].ToString().Trim();
                            this.txtTaoXiAmount.Text = dtOrder.Rows[0]["Ord_SeriesPrice"].ToString().Trim();
                            this.txtTaoXiName.Text = dtOrder.Rows[0]["Ord_SeriesName"].ToString().Trim();
                            this.tb_ClientPhoneCall.Text = dtOrder.Rows[0]["Cus_Telephone"].ToString().Trim();
                        }
                        break;
                    case "后期收款":
                        switch (dt.Rows[0]["Pay_Type"].ToString().Trim())
                        {
                            case "0":
                                //StrTableName += "select Ord_SinceOrderNumber,Ord_OrderClass,Plu_Goods AS Ord_SeriesName,Plu_Amount AS Ord_SeriesPrice,Cus_Name,Ord_Remark " +
                                // "from tb_ErpPlusPickItems Left Join tb_ErpOrder on Ord_Number = Plu_OrdNumber " +
                                // "Left Join tempTB_AggregationCustomer on GP_OrderNumber = Plu_OrdNumber";
                                
                                //2017-03-30 刘工修改
                                StrTableName = "select sum([Pay_AmountOf]) as sumAomuntof from [dbo].[tb_ErpPayment] where Pay_PlusPickNumber='" + Pay_PlusPickNumber + "';";
                                StrTableName += "select Ord_SinceOrderNumber,Ord_OrderClass,Plu_Goods AS Ord_SeriesName,Plu_Amount AS Ord_SeriesPrice,Cus_Name,Ord_Remark,Plu_Number,Cus_Telephone " +
                                 "from tb_ErpPlusPickItems Left Join tb_ErpOrder on Ord_Number = Plu_OrdNumber " +
                                 "Left Join tempTB_AggregationCustomer on GP_OrderNumber = Plu_OrdNumber where Ord_SinceOrderNumber='" + OrdNumber + "' and Plu_Number='" + Pay_PlusPickNumber + "'";

                                 dtSet = orbll.GetView_Custom(StrTableName);
                                dtArrears = dtSet.Tables["ds"]; 
                                dtOrder = dtSet.Tables["ds1"];

                                decimal Ord_SeriesPrice = 0;
                                decimal sumAomuntof = 0;
                                try
                                {
                                    Ord_SeriesPrice = Convert.ToDecimal(dtOrder.Rows[0]["Ord_SeriesPrice"].ToString());
                                }
                                catch { }
                                try
                                {
                                    sumAomuntof = Convert.ToDecimal(dtArrears.Rows[0]["sumAomuntof"].ToString());
                                }
                                catch { }

                                this.txtClientArrears.Text =( Ord_SeriesPrice-sumAomuntof).ToString("n2"); //dtArrears.Rows[0]["欠款"].ToString().Trim();
                                if (dtOrder.Rows.Count > 0)
                                {
                                    this.txtClientName.Text = dtOrder.Rows[0]["Cus_Name"].ToString().Trim();
                                    this.txtOrderClass.Text = dtOrder.Rows[0]["Ord_OrderClass"].ToString().Trim();
                                    this.txtOrderNumber.Text = dtOrder.Rows[0]["Ord_SinceOrderNumber"].ToString().Trim();
                                    this.txtRemark.Text = dtOrder.Rows[0]["Ord_Remark"].ToString().Trim();
                                    this.txtTaoXiAmount.Text = Ord_SeriesPrice.ToString().Trim();
                                    this.txtTaoXiName.Text = dtOrder.Rows[0]["Ord_SeriesName"].ToString().Trim();
                                    this.tb_ClientPhoneCall.Text = dtOrder.Rows[0]["Cus_Telephone"].ToString().Trim();
                                }
                                this.labelEx2.Text = "加挑商品：";
                                this.labelEx4.Text = "加挑金额：";
                                break;
                            case "1":
                                StrTableName = "select sum([Pay_AmountOf]) as sumAomuntof from [dbo].[tb_ErpPayment] where Pay_OrdNumber='" + OrdNumber + "';";
                                StrTableName += "select Tsorder_Number,Sc_ClassName,Tsorder_Name,Tsorder_Money,Cus_Name,Tsorder_Remark ,Cus_Telephone" +
                                "from tb_ErpTwoSalesOrder " +
                                "Left Join tb_ErpSystemCategory on Sc_ClassCode = Tsorder_Category " +
                                "Left Join tb_ErpCustomer on Cus_CustomerNumber = Tsorder_CustomerNumber where Tsorder_Number='" + OrdNumber + "'";
                                dtSet = orbll.GetView_Custom(StrTableName);
                                dtArrears = dtSet.Tables["ds"];
                                dtOrder = dtSet.Tables["ds1"];
                                decimal Ord_SeriesPrice2 = 0;
                                decimal sumAomuntof2 = 0;
                                try
                                {
                                    Ord_SeriesPrice2 = Convert.ToDecimal(dtOrder.Rows[0]["Tsorder_Money"].ToString().Trim());
                                }
                                catch { }
                                try
                                {
                                    sumAomuntof2 = Convert.ToDecimal(dtArrears.Rows[0]["sumAomuntof"].ToString());
                                }
                                catch { }
                                //this.txtClientArrears.Text = dtArrears.Rows[0]["欠款"].ToString().Trim();
                                 this.txtClientArrears.Text =( Ord_SeriesPrice2-sumAomuntof2).ToString("n2"); //
                                if (dtOrder.Rows.Count > 0)
                                {
                                    this.txtClientName.Text = dtOrder.Rows[0]["Cus_Name"].ToString().Trim();
                                    this.txtOrderClass.Text = dtOrder.Rows[0]["Sc_ClassName"].ToString().Trim();
                                    this.txtOrderNumber.Text = dtOrder.Rows[0]["Tsorder_Number"].ToString().Trim();
                                    this.txtRemark.Text = dtOrder.Rows[0]["Tsorder_Remark"].ToString().Trim();
                                    this.txtTaoXiAmount.Text = Ord_SeriesPrice2.ToString().Trim();
                                    this.txtTaoXiName.Text = dtOrder.Rows[0]["Tsorder_Name"].ToString().Trim();
                                    this.tb_ClientPhoneCall.Text = dtOrder.Rows[0]["Cus_Telephone"].ToString().Trim();
                                }
                                this.labelEx3.Text = "三销类别：";
                                this.labelEx2.Text = "项目名称：";
                                this.labelEx4.Text = "项目金额：";
                                break;
                        }
                        break;
                }

            }
        }
        /// <summary>
        /// 关闭
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnClosed_Click(object sender, EventArgs e)
        {
            this.Close();
        }
    }
}