MES_Client/TGMES/Core.StlMes.Client.Pms/pur_plan/FrmTaskReport.cs

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;
using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Tool;
using Pur.Entity;
using Pur.Entity.configureEntity;
using Pur.Entity.pur_planEntity;

namespace Pur.pur_plan
{
    public partial class FrmTaskReport : FrmPmsBase
    {
        public FrmTaskReport()
        {
            InitializeComponent();
            this.IsLoadUserView = true;
        }

        private void FrmTaskReport_Load(object sender, EventArgs e)
        {
            //初始化查询区域
            txt_createTimeStart.Value = DateTime.Now.AddMonths(-2);
            txt_createTimeEnd.Value = DateTime.Now.AddDays(1);
            txt_createTimeStart_chat.Value = DateTime.Now.AddMonths(-2);
            txt_createTimeEnd_chat.Value = DateTime.Now.AddDays(1);
            ck_ctime.Checked = true;
            ck_createtime_chat.Checked = true;
            txt_createTimeStart.Enabled = true;
            txt_createTimeEnd.Enabled = true;
            ck_isContain_nobid.Checked = false;
        }
        #region toolbar
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "doQuery":    // 查询
                    doQuery();
                    break;
                case "doExit":    // 退出
                    this.Close();
                    break;
                case "doExcel":    // 打印
                    doExcel();
                    break;
            }

        }
        /// <summary>
        /// 导出excel
        /// </summary>
        private void doExcel()
        {
            try
            {
                    this.Cursor = Cursors.WaitCursor;
                    if (ultraTabControl1.SelectedTab == ultraTabControl1.Tabs[0])
                    {
                        ArrayList alUltraGrid = new ArrayList();
                        alUltraGrid.Add(ultraGrid1);
                        ArrayList alSheeft = new ArrayList();
                        alSheeft.Add("招标结果报表");
                        if (ultraGrid1.Rows.Count > 0)
                        {
                            GridHelper.ulGridToExcel(alUltraGrid, alSheeft, "招标结果报表");//导出excel
                        }
                    }
                    else
                    {
                        ArrayList alUltraGrid = new ArrayList();
                        alUltraGrid.Add(ultraGrid2);
                        ArrayList alSheeft = new ArrayList();
                        alSheeft.Add("聊天记录");
                        if (ultraGrid2.Rows.Count > 0)
                        {
                            GridHelper.ulGridToExcel(alUltraGrid, alSheeft, "聊天记录");//导出excel
                        }
                    }
            }
            catch (Exception e)
            {
                MessageUtil.ShowTips("导出失败" + e.Message);
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }
        }
        /// <summary>
        /// 查询
        /// </summary>
        private void doQuery()
        {
            this.Cursor = Cursors.WaitCursor;
            try
            {
                if (ultraTabControl1.SelectedTab == ultraTabControl1.Tabs[0])
                {
                    bidDetail.Clear();
                    PurTaskOfferCEntity entity = new PurTaskOfferCEntity();
                    if (txt_taskId.Text.Trim() != "")
                    {
                        entity.TaskId = txt_taskId.Text.Trim();
                    }
                    if (txt_taskName.Text.Trim() != "")
                    {
                        entity.UpdateName = txt_taskName.Text.Trim();
                    }
                    if (txt_itemName.Text.Trim() != "")
                    {
                        entity.ItemName = txt_itemName.Text.Trim();
                    }
                    if (txt_itemCode.Text.Trim() != "")
                    {
                        entity.ItemCode = txt_itemCode.Text.Trim();
                    }
                    if (txt_suppCode.Text.Trim() != "")
                    {
                        entity.SuppCode = txt_suppCode.Text.Trim();
                    }
                    if (txt_suppName.Text.Trim() != "")
                    {
                        entity.SuppName = txt_suppName.Text.Trim();
                    }
                    entity.Validflag = "1";
                    if (ck_ctime.Checked)
                    {
                        if (txt_createTimeStart.Text != "")
                        {
                            entity.CreateTime = Convert.ToDateTime(txt_createTimeStart.Value);
                        }
                        if (txt_createTimeEnd.Text != "")
                        {
                            entity.UpdateTime = Convert.ToDateTime(txt_createTimeEnd.Value);
                        }
                    }
                    entity.DeleteName = "report";
                    if (ck_isContain_nobid.Checked == false)
                    {
                        entity.DeleteUserid = "1";
                    }
                    DataTable dt1 = this.execute<DataTable>("com.hnshituo.pur.purplan.service.TaskOfferCService", "findTaskOfferC", new object[] { entity });
                    GridHelper.CopyDataToDatatable(dt1, dataTable1, true);
                    GridHelper.RefreshAndAutoSize(ultraGrid1);
                }
                else
                {
                    bidChat.Clear();
                    Hashtable entity = new Hashtable();
                    if (txt_taskid_chat.Text.Trim() != "")
                    {
                        entity.Add("taskId", txt_taskid_chat.Text.Trim());
                    }
                    if (txt_taskname_chat.Text.Trim() != "")
                    {
                        entity.Add("taskName", txt_taskname_chat.Text.Trim());
                    }
                    if (ck_createtime_chat.Checked)
                    {
                        if (txt_createTimeStart_chat.Text != "")
                        {
                            entity.Add("createTimeBegin",Convert.ToDateTime(txt_createTimeStart_chat.Value));
                        }
                        if (txt_createTimeEnd_chat.Text != "")
                        {
                            entity.Add("createTimeEnd", Convert.ToDateTime(txt_createTimeEnd_chat.Value));
                        }
                    }
                    DataTable dt2 = this.execute<DataTable>("com.hnshituo.pur.purplan.service.TaskChatService", "getChatMessege", new object[] { entity });
                    GridHelper.CopyDataToDatatable(dt2, dataTable2, true);
                    GridHelper.RefreshAndAutoSize(ultraGrid2);
                }
            }
            catch (Exception ex)
            {
                MessageUtil.ShowTips("初始化加载数据失败：" + ex.Message);
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }
        }

        #endregion

        #region 界面事件
        private void ck_ctime_CheckedChanged(object sender, EventArgs e)
        {
            txt_createTimeEnd.Enabled = ck_ctime.Checked;
            txt_createTimeStart.Enabled = ck_ctime.Checked;
        }
        #endregion

        private void ck_createtime_chat_CheckedChanged(object sender, EventArgs e)
        {
            txt_createTimeEnd_chat.Enabled = ck_ctime.Checked;
            txt_createTimeStart_chat.Enabled = ck_ctime.Checked;
        }

    }
}