lyfz_repos/铂金版源码/LYFZ.Software.MainBusiness/StatisticalInquiry/SatisfactionReport/FrmSatisfactionSeeDetails.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.SatisfactionReport
{
    public partial class FrmSatisfactionSeeDetails : LYFZ.Software.UI.StatisticalInquiry.SatisfactionReport.FrmSatisfactionSeeDetails
    {
        LYFZ.BLL.BLL_ErpOrder orbll = new LYFZ.BLL.BLL_ErpOrder();
        LYFZ.BLL.BLL_ErpSatisfactionSurvey Surveybll = new BLL.BLL_ErpSatisfactionSurvey();
        LYFZ.BLL.BLL_ErpSatisfactionRatingSet srsbll = new BLL.BLL_ErpSatisfactionRatingSet();
        LYFZ.BLL.BLL_ErpSatisfactionSurveySet setbll = new BLL.BLL_ErpSatisfactionSurveySet();
        LYFZ.BLL.BLL_ErpSatisfactionReturningMattersSet sfrmbll = new BLL.BLL_ErpSatisfactionReturningMattersSet();
        public FrmSatisfactionSeeDetails()
        {
            this.Load += FrmSatisfactionSeeDetails_Load;
            this.Shown += FrmSatisfactionSeeDetails_Shown;
            this.btnSelect.Click += btnSelect_Click;
            this.btnClose.Click += btnClose_Click;
        }
        public string TimeStar;
        public string TimeEnd;
        public string PersonnelNumber;
        public string PersonnelName;
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void FrmSatisfactionSeeDetails_Load(object sender, EventArgs e)
        {
            this.Location = new Point(LYFZ.EnumPublic.FormLocation_X, LYFZ.EnumPublic.FormLocation_Y);
            this.Size = new Size(LYFZ.EnumPublic.FormSize_Width, LYFZ.EnumPublic.FormSize_Height);
        }
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void FrmSatisfactionSeeDetails_Shown(object sender, EventArgs e)
        {
            DataTable dt = orbll.GetView_Custom("tb_ErpSatisfactionRatingSet", StrWhere: "", ShowColumnName: "Sfrs_Name", filedOrder: "ID").Tables[0];
            string StrColumnName = "人员ID,服务人员";
            for (int i = 0; i < dt.Rows.Count; i++)
            { StrColumnName += "," + dt.Rows[i]["Sfrs_Name"].ToString().Trim(); }
            StrColumnName += ",总满意程度分值,总满意程度";
            this.dgvData2.DataColumns(StrColumnName, strHideField: "人员ID");

            this.BindReturningItems();
            this.BindScores();
            this.PublicFunctionRows();
            this.PublicFunctionRows2();
        }
        /// <summary>
        /// 查询
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnSelect_Click(object sender, EventArgs e)
        {
            this.PublicFunctionRows2();
            this.PublicFunctionRows();
        }
        /// <summary>
        /// 关闭
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        /// <summary>
        /// 获取回访事项
        /// </summary>
        void BindReturningItems()
        {
            DataTable tbl = orbll.GetView_Custom("tb_ErpSatisfactionSurveySet", StrWhere: "", ShowColumnName: "ID,Sfss_Name", filedOrder: "ID").Tables[0];
            if (tbl.Rows.Count > 0)
            {
                TreeNode root = null;
                for (int i = 0; i < tbl.Rows.Count; i++)
                {
                    if (i == 0)
                    {
                        root = new TreeNode();
                        root.Text = "全部";
                        root.Tag = "0";
                        root.Tag = "All";
                        this.cmbReturningItems.TreeView.Nodes.Add(root);
                    }
                    root = new TreeNode();
                    root.Text = tbl.Rows[i]["Sfss_Name"].ToString().Trim();
                    root.Tag = tbl.Rows[i]["ID"].ToString().Trim();
                    root.Name = "Max";
                    this.CreateTreeReturningItems(root.Nodes, tbl.Rows[i]["ID"].ToString().Trim());
                    this.cmbReturningItems.TreeView.Nodes.Add(root);
                }
            }
        }
        /// <summary>
        /// 绑定第二级人员
        /// </summary>
        /// <param name="nodes">TreeView的节点集合</param>
        /// <param name="dataSource">数据源</param>
        /// <param name="parentid"></param>
        void CreateTreeReturningItems(TreeNodeCollection nodes, string ClassCode)
        {
            if (ClassCode != "")
            {
                DataTable tbl = sfrmbll.GetList("Sfrms_EnableStatus = 0 and Sfrms_SurveySetID = " + ClassCode + "").Tables[0];
                if (tbl.Rows.Count > 0)
                {
                    TreeNode node;
                    for (int i = 0; i < tbl.Rows.Count; i++)
                    {
                        node = new TreeNode();
                        node.Text = tbl.Rows[i]["Sfrms_Contents"].ToString().Trim();
                        node.Tag = tbl.Rows[i]["ID"].ToString().Trim();
                        node.Name = "Min";
                        nodes.Add(node);
                    }
                }
            }
        }
        /// <summary>
        /// 获取单项满意度
        /// </summary>
        void BindScores()
        {
            DataTable dt = orbll.GetView_Custom("tb_ErpSatisfactionRatingSet", StrWhere: "", ShowColumnName: "ID,Sfrs_Name", filedOrder: "ID").Tables[0];
            cmbScores.DataSource = dt;
            cmbScores.ValueMember = "ID";
            cmbScores.DisplayMember = "Sfrs_Name";
            DataRow dr = dt.NewRow();
            dr["ID"] = "-1";
            dr["Sfrs_Name"] = "";
            dt.Rows.InsertAt(dr, 0);
            cmbScores.SelectedIndex = -1;
        }
        /// <summary>
        /// 画分页
        /// </summary>
        /// <param name="e"></param>
        /// <returns></returns>
        void PublicFunctionRows()
        {
            this.dgvData.Rows.Clear();
            string StrWhere = " Where Sfs_EmployeeID='" + this.PersonnelNumber + "'";
            if (!string.IsNullOrEmpty(this.TimeStar) && !string.IsNullOrEmpty(this.TimeEnd))
            { StrWhere += LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetDateTime("Sfs_CreateTime", this.TimeStar, this.TimeEnd); }
            if (this.cmbReturningItems.Tag != null && this.cmbReturningItems.Text.Trim().Length > 0 && this.cmbReturningItems.Text.Trim() != "全部")
            {
                switch (this.cmbReturningItems.StrGetName.Trim())
                {
                    case "Max":
                        StrWhere += " And Sfs_SurveySetID = " + this.cmbReturningItems.Tag.ToString().Trim();
                        break;
                    case "Min":
                        StrWhere += " And Sfs_ReturningMattersSetID = " + this.cmbReturningItems.Tag.ToString().Trim();
                        break;
                }
            }
            if (this.cmbScores.Text.Trim().Length > 0)
            { StrWhere += " And Sfs_RatingSetID = " + this.cmbScores.SelectedValue.ToString(); }
            DataTable newTable = new DataTable();
            LYFZ.ComponentLibrary.FrmLoadHandling.LoadDoWorkMethod(delegate(object obj, BackgroundWorker backgroundWorker)
            {
                string StrTableName = "SELECT Sfs_OrderNumber AS 订单号," +
                "Cus_Name AS 客户姓名," +
                "Cus_Telephone AS 客户电话," +
                "Ords_PhotographMaxTime as 拍照时间," +
                "Sfs_EmployeeID AS 调查对象," +
                "Sfss_Name AS 回访对象," +
                "Sfrms_Contents AS 回访事项," +
                "Sfrs_Name AS 满意度," +
                "isnull(Sfrs_Scores, 0) AS 满意分值," +
                "Sfs_Remark AS 备注," +
                "Sfs_CreateName AS 回访人," +
                "Sfs_CreateTime AS 回访时间 " +
                "FROM tb_ErpSatisfactionSurvey " +
                "left join tb_ErpSatisfactionSurveySet on Sfs_SurveySetID = tb_ErpSatisfactionSurveySet.ID " +
                "left join tb_ErpSatisfactionReturningMattersSet on tb_ErpSatisfactionReturningMattersSet.ID = Sfs_ReturningMattersSetID " +
                "left join tb_ErpSatisfactionRatingSet on Sfs_RatingSetID = tb_ErpSatisfactionRatingSet.ID " +
                "Left Join tempTB_AggregationCustomer on GP_OrderNumber = Sfs_OrderNumber " +
                "left join tb_ErpOrderDigitalStatus on tempTB_AggregationCustomer.GP_OrderNumber = tb_ErpOrderDigitalStatus.Ords_OrdNumber and "+
	            " tb_ErpSatisfactionSurvey.Sfs_OrderNumberDeputy=tb_ErpOrderDigitalStatus.Ords_ViceNumber" + 
                StrWhere+
                " order by Sfs_CreateTime asc ";
                newTable = orbll.GetView_Custom(StrTableName).Tables[0];
            });
            #region
            this.dgvData.DataColumns(newTable.Columns, strHideField: "");
            this.dgvData.Columns["客户姓名"].Width = 150;
            this.dgvData.Columns["客户电话"].Width = 180;
            this.dgvData.Columns["回访时间"].Width = 120;
            this.dgvData.Columns["回访事项"].Width = 350;
            this.dgvData.FillLastColumn();
            for (int t = 0; t < newTable.Rows.Count; t++)
            {
                DataGridViewRow dgvr = new DataGridViewRow();
                DataGridViewCell cell = null;

                cell = new DataGridViewTextBoxCell();
                cell.Value = newTable.Rows[t]["订单号"].ToString().Trim();
                dgvr.Cells.Add(cell);

                cell = new DataGridViewTextBoxCell();
                cell.Value = newTable.Rows[t]["客户姓名"].ToString().Trim();
                dgvr.Cells.Add(cell);

                cell = new DataGridViewTextBoxCell();
                cell.Value = newTable.Rows[t]["客户电话"].ToString().Trim();
                dgvr.Cells.Add(cell);

                cell = new DataGridViewTextBoxCell();
                cell.Value = newTable.Rows[t]["拍照时间"].ToString().Trim();
                dgvr.Cells.Add(cell);

                cell = new DataGridViewTextBoxCell();
                cell.Value = LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetUserName(newTable.Rows[t]["调查对象"]);
                dgvr.Cells.Add(cell);

                cell = new DataGridViewTextBoxCell();
                cell.Value = newTable.Rows[t]["回访对象"].ToString().Trim();
                dgvr.Cells.Add(cell);

                cell = new DataGridViewTextBoxCell();
                cell.Value = newTable.Rows[t]["回访事项"].ToString().Trim();
                dgvr.Cells.Add(cell);

                cell = new DataGridViewTextBoxCell();
                cell.Value = newTable.Rows[t]["满意度"].ToString().Trim();
                dgvr.Cells.Add(cell);

                cell = new DataGridViewTextBoxCell();
                cell.Value = newTable.Rows[t]["满意分值"].ToString();
                dgvr.Cells.Add(cell);

                cell = new DataGridViewTextBoxCell();
                cell.Value = newTable.Rows[t]["备注"].ToString().Trim();
                dgvr.Cells.Add(cell);

                cell = new DataGridViewTextBoxCell();
                cell.Value = LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetUserName(newTable.Rows[t]["回访人"]);
                dgvr.Cells.Add(cell);

                cell = new DataGridViewTextBoxCell();
                cell.Value = LYFZ.BLL.OtherCommonModel.DateTimeToString(newTable.Rows[t]["回访时间"]);
                dgvr.Cells.Add(cell);

                this.dgvData.Rows.Add(dgvr);
            }
            this.dgvData.ClearSelection();
            #endregion

        }
        /// <summary>
        /// 获取人员查询满意度
        /// </summary>
        void PublicFunctionRows2()
        {
            dgvData2.Rows.Clear();
            DataTable dt = new DataTable();
            string StrWhere = " Sfs_EmployeeID='" + PersonnelNumber + "'" + LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetDateTime("Sfs_CreateTime", this.TimeStar, this.TimeEnd);
            if (this.cmbReturningItems.Tag != null && this.cmbReturningItems.Text.Trim().Length > 0 && this.cmbReturningItems.Text.Trim() != "全部")
            {
                switch (this.cmbReturningItems.StrGetName.Trim())
                {
                    case "Max":
                        StrWhere += " And Sfs_SurveySetID = " + this.cmbReturningItems.Tag.ToString().Trim();
                        break;
                    case "Min":
                        StrWhere += " And Sfs_ReturningMattersSetID = " + this.cmbReturningItems.Tag.ToString().Trim();
                        break;
                }
            }
            if (this.cmbScores.Text.Trim().Length > 0)
            { StrWhere += " And Sfs_RatingSetID = " + this.cmbScores.SelectedValue.ToString(); }
            DataTable newTable2 = orbll.GetView_Custom("select Sfs_RatingSetID,Count(Sfs_EmployeeID) AS CountID,Sum(Sfrs_Scores) AS Sfrs_Scores from tb_ErpSatisfactionSurvey Left Join tb_ErpSatisfactionRatingSet on Sfs_RatingSetID=tb_ErpSatisfactionRatingSet.ID Where " + StrWhere + " Group By Sfs_RatingSetID").Tables[0];
            newTable2.PrimaryKey = new DataColumn[] { newTable2.Columns["Sfs_RatingSetID"] };
            #region
            DataGridViewRow dgvr = new DataGridViewRow();
            DataGridViewCell cell = null;

            cell = new DataGridViewTextBoxCell();
            cell.Value = PersonnelNumber;
            dgvr.Cells.Add(cell);

            cell = new DataGridViewTextBoxCell();
            cell.Value = PersonnelName;
            dgvr.Cells.Add(cell);

            cell = new DataGridViewTextBoxCell();
            decimal decScores = 0;
            int intScores = 0;
            DataRow dtRow1 = newTable2.Rows.Find("1");
            if (dtRow1 != null)
            {
                cell.Value = dtRow1["CountID"].ToString().Trim();
                intScores += Convert.ToInt32(dtRow1["CountID"]);
                decScores += Convert.ToDecimal(dtRow1["Sfrs_Scores"]);
            }
            else
            { cell.Value = 0; }
            dgvr.Cells.Add(cell);

            cell = new DataGridViewTextBoxCell();
            DataRow dtRow2 = newTable2.Rows.Find("2");
            if (dtRow2 != null)
            {
                cell.Value = dtRow2["CountID"].ToString().Trim();
                intScores += Convert.ToInt32(dtRow2["CountID"]);
                decScores += Convert.ToDecimal(dtRow2["Sfrs_Scores"]);
            }
            else
            { cell.Value = 0; }
            dgvr.Cells.Add(cell);

            cell = new DataGridViewTextBoxCell();
            DataRow dtRow3 = newTable2.Rows.Find("3");
            if (dtRow3 != null)
            {
                cell.Value = dtRow3["CountID"].ToString().Trim();
                intScores += Convert.ToInt32(dtRow3["CountID"]);
                decScores += Convert.ToDecimal(dtRow3["Sfrs_Scores"]);
            }
            else
            { cell.Value = 0; }
            dgvr.Cells.Add(cell);

            cell = new DataGridViewTextBoxCell();
            DataRow dtRow4 = newTable2.Rows.Find("4");
            if (dtRow4 != null)
            {
                cell.Value = dtRow4["CountID"].ToString().Trim();
                intScores += Convert.ToInt32(dtRow4["CountID"]);
                decScores += Convert.ToDecimal(dtRow4["Sfrs_Scores"]);
            }
            else
            { cell.Value = 0; }
            dgvr.Cells.Add(cell);

            cell = new DataGridViewTextBoxCell();
            DataRow dtRow5 = newTable2.Rows.Find("5");
            if (dtRow5 != null)
            {
                cell.Value = dtRow5["CountID"].ToString().Trim();
                intScores += Convert.ToInt32(dtRow5["CountID"]);
                decScores += Convert.ToDecimal(dtRow5["Sfrs_Scores"]);
            }
            else
            { cell.Value = 0; }
            dgvr.Cells.Add(cell);

            //总满意程度分值
            string Sfrs_Scores = "0";
            cell = new DataGridViewTextBoxCell();
            if (intScores > 0)
            { Sfrs_Scores = LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(decScores / intScores); }
            cell.Value = Sfrs_Scores;
            dgvr.Cells.Add(cell);

            //总满意程度
            cell = new DataGridViewTextBoxCell();
            cell.Value = "";
            string[] StrValue = Sfrs_Scores.Split('.');
            int intValue = Convert.ToInt32(StrValue[0]);
            if (intValue > 0)
            {
                DataTable dt2 = orbll.GetView_Custom("tb_ErpSatisfactionRatingSet", "Sfrs_Scores <= '" + intValue + "'", ShowColumnName: "Sfrs_Name", filedOrder: "Sfrs_Scores DESC", TopCount: 1).Tables[0];
                if (dt2.Rows.Count > 0)
                { cell.Value = dt2.Rows[0]["Sfrs_Name"].ToString().Trim(); }
            }
            dgvr.Cells.Add(cell);

            this.dgvData2.Rows.Add(dgvr);
            this.dgvData2.ClearSelection();
            #endregion
        }
    }
}