lyfz_repos/铂金版源码/LYFZ.Software.MainBusiness/DecisionAssistant/SetSmallForm/AnalyzedOrderSourceReferralDetailSmallForm.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.DecisionAssistant.SetSmallForm
{
    public partial class AnalyzedOrderSourceReferralDetailSmallForm : LYFZ.Software.UI.DecisionAssistant.SetSmallForm.AnalyzedOrderSourceReferralDetailSmallForm
    {
        LYFZ.BLL.BLL_ErpOrder orbll = new BLL.BLL_ErpOrder();
        public AnalyzedOrderSourceReferralDetailSmallForm()
        {
            this.Load += AnalyzedOrderSourceReferralDetailSmallForm_Load;
            this.Shown += AnalyzedOrderSourceReferralDetailSmallForm_Shown;
            this.Resize += AnalyzedOrderSourceReferralDetailSmallForm_Resize;
            this.btnClose.Click += btnClose_Click;
        }
        /// <summary>
        /// 客户编号
        /// </summary>
        public string StrClientNumber = "";
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void AnalyzedOrderSourceReferralDetailSmallForm_Load(object sender, EventArgs e)
        {
            this.listViewData.View = View.Details;
            this.listViewData.GridLines = true;
            ImageList imgList = new ImageList();
            imgList.ImageSize = new Size(1, 25);
            this.listViewData.SmallImageList = imgList;
            string[] StrColumns = "订单号,订单类型,客户姓名,客户性别,客户电话,套系名称,套系价格,接单人,欠款".Split(',');
            for (int i = 0; i < StrColumns.Length; i++)
            {
                ColumnHeader ch = new ColumnHeader();
                ch.Text = StrColumns[i].Trim();
                ch.Width = (this.listViewData.Width - 23) / 9;
                switch (StrColumns[i].Trim())
                {
                    case "套系价格":
                    case "欠款": ch.TextAlign = HorizontalAlignment.Right; break;
                    case "客户性别":
                    case "接单人":
                    case "订单类型":
                        ch.TextAlign = HorizontalAlignment.Center; break;
                    default: ch.TextAlign = HorizontalAlignment.Left; break;
                }
                this.listViewData.Columns.Add(ch);
            }
        }
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void AnalyzedOrderSourceReferralDetailSmallForm_Shown(object sender, EventArgs e)
        {
            string ExecuteSql = "SELECT CASE Ord_SinceOrderNumber WHEN '' THEN Ord_Number ELSE Ord_SinceOrderNumber END AS 订单号,dbo.fn_CheckOrderType(Ord_Type) AS 订单类型," +
                "Cus_Name AS 客户姓名,Cus_Sex_cs AS 客户性别,Cus_Telephone AS 客户电话,Ord_SeriesName AS 套系名称, Ord_SeriesPrice AS 套系价格," +
                "(select stuff((select ',' + dbo.fn_CheckUserIDGetUserName(OrdPe_OrdersPerson) from tb_ErpOrdersPerson where OrdPe_OrderNumber = Ord_Number for xml path('')),1,1,'')) as 接单人," +
                "(套系金额 + (case when 加挑金额 is not null then 加挑金额 else 0 end) - (case when 收款金额 is not null then 收款金额 else 0 end)) AS 欠款 " +
                "FROM dbo.tb_ErpOrder Left Join tempTB_AggregationCustomer on Ord_Number = GP_OrderNumber Left Join dbo.BView_OrderAmount on Order_Number = Ord_Number " +
                "WHERE Ord_Class = '1' And GP_IntroducerCustomerID = '" + this.StrClientNumber + "';" +
                "select Cus_Name,(case when Cus_Sex = 0 then '男' else '女' end) AS Cus_Sex,Cus_Telephone from tb_ErpCustomer Where Cus_CustomerNumber = '" + this.StrClientNumber + "'";
            DataSet dsData = orbll.GetView_Custom(ExecuteSql);
            DataTable tbl = dsData.Tables["ds"];
            DataTable dt = dsData.Tables["ds1"];
            if (dt.Rows.Count > 0)
            {
                this.txtName.Text = dt.Rows[0]["Cus_Name"].ToString().Trim();
                this.txtSex.Text = dt.Rows[0]["Cus_Sex"].ToString().Trim();
                this.txtPhone.Text = dt.Rows[0]["Cus_Telephone"].ToString().Trim();
            }
            this.TopMost = true;
            for (int i = 0; i < tbl.Rows.Count; i++)
            {
                ListViewItem lvItem = new ListViewItem();
                lvItem.Tag = tbl.Rows[i]["订单号"].ToString().Trim();
                lvItem.Text = tbl.Rows[i]["订单号"].ToString().Trim();

                ListViewItem.ListViewSubItem ListSubItem = new ListViewItem.ListViewSubItem();
                ListSubItem.Name = "订单类型";
                ListSubItem.Text = tbl.Rows[i]["订单类型"].ToString().Trim();
                lvItem.SubItems.Add(ListSubItem);

                ListSubItem = new ListViewItem.ListViewSubItem();
                ListSubItem.Name = "客户姓名";
                ListSubItem.Text = tbl.Rows[i]["客户姓名"].ToString().Trim();
                lvItem.SubItems.Add(ListSubItem);

                ListSubItem = new ListViewItem.ListViewSubItem();
                ListSubItem.Name = "客户性别";
                ListSubItem.Text = tbl.Rows[i]["客户性别"].ToString().Trim();
                lvItem.SubItems.Add(ListSubItem);

                ListSubItem = new ListViewItem.ListViewSubItem();
                ListSubItem.Name = "客户电话";
                ListSubItem.Text = tbl.Rows[i]["客户电话"].ToString().Trim();
                lvItem.SubItems.Add(ListSubItem);

                ListSubItem = new ListViewItem.ListViewSubItem();
                ListSubItem.Name = "套系名称";
                ListSubItem.Text = tbl.Rows[i]["套系名称"].ToString().Trim();
                lvItem.SubItems.Add(ListSubItem);

                ListSubItem = new ListViewItem.ListViewSubItem();
                ListSubItem.Name = "套系价格";
                ListSubItem.Text = tbl.Rows[i]["套系价格"].ToString().Trim();
                lvItem.SubItems.Add(ListSubItem);

                ListSubItem = new ListViewItem.ListViewSubItem();
                ListSubItem.Name = "接单人";
                ListSubItem.Text = tbl.Rows[i]["接单人"].ToString().Trim();
                lvItem.SubItems.Add(ListSubItem);

                ListSubItem = new ListViewItem.ListViewSubItem();
                ListSubItem.Name = "欠款";
                ListSubItem.Text = tbl.Rows[i]["欠款"].ToString().Trim();
                lvItem.SubItems.Add(ListSubItem);

                if ((this.listViewData.Items.Count % 2) > 0)
                { lvItem.BackColor = System.Drawing.Color.PapayaWhip; }
                else
                { lvItem.BackColor = System.Drawing.Color.PowderBlue; }

                this.listViewData.Items.Add(lvItem);
            }
            this.TopMost = false;
        }
        /// <summary>
        /// 窗体大小 发生发化
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void AnalyzedOrderSourceReferralDetailSmallForm_Resize(object sender, EventArgs e)
        {
            for (int i = 0; i < this.listViewData.Columns.Count; i++)
            {
                this.listViewData.Columns[i].Width = (this.listViewData.Width - 23) / 9;
            }
        }
        /// <summary>
        /// 关闭
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }
    }
}