lyfz_repos/铂金版源码/LYFZ.Software.MainBusiness/StatisticalEmployeeWork/WorkStatisticalBootDivision.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.StatisticalEmployeeWork
{
    public partial class WorkStatisticalBootDivision : LYFZ.Software.UI.StatisticalEmployeeWork.WorkStatisticalBootDivision
    {
        LYFZ.BLL.BLL_ErpOrder orbll = new BLL.BLL_ErpOrder();
        public WorkStatisticalBootDivision()
        {
            this.Load += WorkStatisticalBootDivision_Load;
            this.Shown += WorkStatisticalBootDivision_Shown;
            this.dtDataTimeStart.Leave += dtDataTimeStart_Leave;
            this.btnQuery.Click += btnQuery_Click;
            this.btnExport.Click += btnExport_Click;
            this.btnClose.Click += btnClose_Click;
        }
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void WorkStatisticalBootDivision_Load(object sender, EventArgs e)
        {
            this.dtDataTimeStart.DateValue = SDateTime.Now.ToString("yyyy-MM") + "-01";
            this.dtDataTimeEnd.DateValue = Convert.ToDateTime(this.dtDataTimeStart.DateValue).AddMonths(1).AddSeconds(-1).ToString("yyyy-MM-dd");
        }
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void WorkStatisticalBootDivision_Shown(object sender, EventArgs e)
        {
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_DepartmentAndEmployee(this.cmbtreevperson, true, IsFirstNodeName: "全部", IsShowResign: false);
            cmbtreevperson.IsNodeMouseClick = true;
            cmbtreevperson.IsSelectParentNode = true;
            this.cmbtreevperson.TextFindTag("全部");
            this.btnQuery_Click(this, null);
            bool b = LYFZ.Software.MainBusiness.VersionControl.StaticVersion.UIFunctionVersion(VersionControl.VersionFunctionEnum.工作统计);
            if (!b)
            {
                this.Close();
            }
        }
        /// <summary>
        /// 开始日期离开事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void dtDataTimeStart_Leave(object sender, EventArgs e)
        {
            this.dtDataTimeEnd.DateValue = Convert.ToDateTime(this.dtDataTimeStart.DateValue).AddMonths(1).AddSeconds(-1).ToString("yyyy-MM-dd");
        }

        /// <summary>
        /// 获取员工编号
        /// </summary>
        /// <returns></returns>
        string GetEmployeeDataInfo()
        {
            string strWhere = "";
            TreeNode tBode = this.cmbtreevperson.SelectedNode;
            if (tBode.Name == "StoreName")
            {
                if (tBode.Nodes.Count > 0)
                {
                    foreach (TreeNode node in tBode.Nodes)
                    {
                        if (node.Nodes.Count > 0)
                        {
                            foreach (TreeNode userNode in node.Nodes)
                            {

                                if (strWhere != "")
                                {
                                    strWhere += " or ";
                                }
                                strWhere += " Ords_BootDivision like '%" + userNode.Tag + "%'";
                            }
                        }
                    }
                }
            }
            else if (tBode.Name == "Department")
            {
                if (tBode.Nodes.Count > 0)
                {
                    foreach (TreeNode userNode in tBode.Nodes)
                    {

                        if (strWhere != "")
                        {
                            strWhere += " or ";
                        }
                        strWhere += " Ords_BootDivision like '%" + userNode.Tag + "%'";
                    }
                }
            }
            else if (tBode.Name == "User")
            {

                if (strWhere != "")
                {
                    strWhere += " or ";
                }
                strWhere += " Ords_BootDivision like '%" + tBode.Tag + "%'";
                //strWhere +=  tBode.Tag ;
            }
            if (string.IsNullOrEmpty(strWhere))
            {
                strWhere = " Ords_BootDivision = '-1'";
            }
            //strDepartment = "'" + string.Join("','", department.ToArray()) + "'";
            return strWhere;
        }
        /// <summary>
        /// 查询
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnQuery_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(this.dtDataTimeStart.DateValue.Trim()) && string.IsNullOrEmpty(this.dtDataTimeEnd.DateValue.Trim()))
            {
                MessageBoxCustom.Show("日期段不能为空"); return;
            }
            if (Convert.ToDateTime(this.dtDataTimeEnd.DateValue) < Convert.ToDateTime(this.dtDataTimeStart.DateValue))
            {
                MessageBoxCustom.Show("开始日期不能大于结束日期"); return;
            }
            if (string.IsNullOrEmpty(this.cmbtreevperson.Text.Trim()))
            {
                MessageBoxCustom.Show("引导师不能为空！"); return;
            }
            string StrWhere = "Ords_PhotographStatus = '1'";
            StrWhere += LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetDateTime("Ords_PhotographMaxTime", this.dtDataTimeStart.DateValue.Trim(), this.dtDataTimeEnd.DateValue.Trim());
            if (this.cmbtreevperson.Text.Trim() != "全部")
            {
                StrWhere += " And ("+ GetEmployeeDataInfo() + ") ";
            }
            else
            {
                StrWhere += " And Ords_BootDivision != ''";
            }
            DAL.DAL_ErpOrdersPhotography bLLErpOrdersPhotography = new DAL.DAL_ErpOrdersPhotography();
            DataTable dt = bLLErpOrdersPhotography.GetStatisticalPhotographerData(StrWhere, " Ords_BootDivision as 引导师 ");
            DataTable useDt = new BLL.BLL_ErpUser().GetAllList().Tables[0];
            foreach (DataRow dr in dt.Rows)
            {
                List<DataRow> useDr = useDt.AsEnumerable().Where(p => p.Field<string>("User_EmployeeID") == dr["引导师"].ToString_s()).ToList();
                if (useDr.Count > 0)
                {
                    dr["引导师"] = useDr[0]["User_Name"];
                }
            }
            if (dt.Rows.Count > 0)
            {
                dt = dt.AsEnumerable().OrderByDescending(p => p.Field<string>("拍摄日期")).CopyToDataTable();
            }
            /*string StrTableName = "tb_ErpOrderDigital Left Join dbo.tb_ErpOrder on Ord_Number = Ordv_Number Left Join tempTB_AggregationCustomer on Ord_Number = GP_OrderNumber " +
                                  "Left Join dbo.BView_OrderAmount on Order_Number = Ord_Number Left Join tb_ErpOrderDigitalStatus on Ords_ViceNumber = Ordv_ViceNumber";
            string StrColumnName = "Ord_SinceOrderNumber AS 订单号," +
            "dbo.fn_CheckOrderType(Ord_Type) AS 订单类型," +
            "Cus_Name AS 客户姓名," +
            "Cus_Sex_cs AS 客户性别," +
            "Cus_Telephone AS 客户电话," +
            "Ord_OrderPersonName AS 接单人," +
            "Ord_SeriesName AS 套系名称," +
            "Ord_SeriesPrice AS 套系价格," +
            "Ords_BootDivision AS 引导师," +
            "dbo.fn_CheckDateTime(Ords_PhotographMaxTime) AS 拍摄日期," +
            "Ords_SightsName AS 拍摄名称," +
            "Ords_PhotographStatus AS 拍照状态," +
            "(套系金额 + isnull(加挑金额,0) - isnull(收款金额,0)) AS 欠款 ";

            DataTable dt = orbll.GetView_Custom(StrTableName, StrWhere: StrWhere, ShowColumnName: StrColumnName).Tables[0];*/
            this.dgvData.DataSource(dt, strHideField: "");
            this.dgvData.Columns["客户电话"].Width = 180;
            this.dgvData.Columns["拍摄名称"].Width = 200;
            this.dgvData.Columns["拍摄日期"].Width = 110;
            this.dgvData.FillLastColumn(isAddNullColumns: true);

            string StrStatisticalText = "总数量：" + dt.Rows.Count;
            DataRow[] dtRow1 = dt.Select("订单类型 = '婚纱订单'");
            if (dtRow1.Length > 0)
            {
                StrStatisticalText += "    婚纱订单：" + dtRow1.Length;
            }
            DataRow[] dtRow2 = dt.Select("订单类型 = '儿童订单'");
            if (dtRow2.Length > 0)
            {
                StrStatisticalText += "    儿童订单：" + dtRow2.Length;
            }
            DataRow[] dtRow3 = dt.Select("订单类型 = '写真订单'");
            if (dtRow3.Length > 0)
            {
                StrStatisticalText += "    写真订单：" + dtRow3.Length;
            }

            // 套系价格列求和;
            try
            {
                double sumObject = Convert.ToDouble(dt.Compute("sum(套系价格)", "true"));
                StrStatisticalText += string.Format("   套系总价:{0:N2},   套系平均价:{1:N2}", sumObject, sumObject / dt.Rows.Count);
            }
            catch { }

            this.txtStatisticalText.Text = StrStatisticalText;
        }
        /// <summary>
        /// 导出
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnExport_Click(object sender, EventArgs e)
        {
            this.dgvData.ExportDataTable(this.UcNavigationTool.LabTitle);
        }
        /// <summary>
        /// 关闭
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }
    }
}