MES_Client/TGMES/Core.StlMes.Client.Pms/require_plan/FrmPurOilTradeReport.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 com.hnshituo.pur.vo;
using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Tool;
using Infragistics.Win.UltraWinGrid;
using Pur.Entity;
using Pur.PublicTools;

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

        private void FrmPurOilTradeReport_Load(object sender, EventArgs e)
        {
            //绑定年份数据
            DataTable dt1 = new DataTable();
            dt1.Columns.Add("YEAR", Type.GetType("System.Int32"));
            for (int i = DateTime.Now.AddYears(-3).Year; i <= DateTime.Now.AddYears(3).Year; i++)
                dt1.Rows.Add(new object[] { i });
            Qyear.DataSource = dt1;
            Qyear.ValueMember = "YEAR";
            Qyear.DisplayMember = "YEAR";
            Qyear.Value = DateTime.Now.Year.ToString();

            Qyear2.DataSource = dt1;
            Qyear2.ValueMember = "YEAR";
            Qyear2.DisplayMember = "YEAR";
            Qyear2.Value = DateTime.Now.Year.ToString();

            GridHelper.SetExcludeColumnsActive(ultraGrid1.DisplayLayout.Bands[0], new string[] { });
            GridHelper.SetExcludeColumnsActive(ultraGrid2.DisplayLayout.Bands[0], new string[] { });

            PublicPur.SetupSummaryHeade(new String[] { "Count", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum" }, new String[] { "共{0}条", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}" }, new string[] { "CARDDID", "M1ADD", "M2ADD", "M3ADD", "M4ADD", "M5ADD", "M6ADD", "M7ADD", "M8ADD", "M9ADD", "M10ADD", "M11ADD", "M12ADD", "M1USE", "M2USE", "M3USE", "M4USE", "M5USE", "M6USE", "M7USE", "M8USE", "M9USE", "M10USE", "M11USE", "M12USE" }, this.ultraGrid2.DisplayLayout.Bands[0], SummaryDisplayAreas.TopFixed);
            PublicPur.SetupSummaryHeade(new String[] { "Count", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum" }, new String[] { "共{0}条", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}" }, new string[] { "CARDDID", "M1ADD", "M2ADD", "M3ADD", "M4ADD", "M5ADD", "M6ADD", "M7ADD", "M8ADD", "M9ADD", "M10ADD", "M11ADD", "M12ADD", "M1USE", "M2USE", "M3USE", "M4USE", "M5USE", "M6USE", "M7USE", "M8USE", "M9USE", "M10USE", "M11USE", "M12USE", "M1b", "M2b", "M3b", "M4b", "M5b", "M6b", "M7b", "M8b", "M9b", "M10b", "M11b", "M12b" }, this.ultraGrid1.DisplayLayout.Bands[0], SummaryDisplayAreas.TopFixed);


            Qstatus.SelectedIndex = 0;
            txt_cardM_type.SelectedIndex = 0;
            txt_M_type.SelectedIndex = 0;
            txt_D_type.SelectedIndex = 0;
        }
        /// <summary>
        /// toolbar
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    Query();
                    break;
                case "Close":
                    this.Close();
                    break;
                case "doExcel":
                    doExcel();
                    break;
            }
        }

        private void doExcel()
        {
            try
            {
                this.Cursor = Cursors.Default;
                if (ultraTabControl1.SelectedTab == ultraTabControl1.Tabs[0])
                {
                    if (ultraGrid2.Rows.Count <= 0)
                    {
                        MessageUtil.ShowTips("无可导出的消耗充值汇总明细！");
                        return;
                    }
                    ArrayList alUltraGrid = new ArrayList();
                    alUltraGrid.Add(ultraGrid2);
                    ArrayList alSheeft = new ArrayList();
                    alSheeft.Add("消耗充值汇总明细");
                    GridHelper.ulGridToExcel(alUltraGrid, alSheeft, "油卡消耗充值交易汇总明细");
                }
                else
                {
                    if (ultraGrid1.Rows.Count <= 0)
                    {
                        MessageUtil.ShowTips("无可导出的消耗充值明细！");
                        return;
                    }
                    ArrayList alUltraGrid = new ArrayList();
                    alUltraGrid.Add(ultraGrid1);
                    ArrayList alSheeft = new ArrayList();
                    alSheeft.Add("消耗充值明细");
                    GridHelper.ulGridToExcel(alUltraGrid, alSheeft, "油卡消耗充值交易明细");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowTips("导出失败" + e.Message);
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }
        }

        private void Query()
        {

            try
            {
                this.Cursor = Cursors.WaitCursor;
                if (ultraTabControl1.SelectedTab == ultraTabControl1.Tabs[0])
                {
                    tradeSum.Clear();
                    OilTrade trade1 = new OilTrade();
                    trade1.CardMId = txtMcardNO.Text.Trim();
                    trade1.UserOrgName = txt_orgName.Text.Trim();
                    trade1.DeleteName = Qyear2.Text.ToString().Trim();
                    if (txt_cardM_type.SelectedIndex != -1)
                    {
                        trade1.Type1 = txt_cardM_type.Value.ToString().Trim();
                    }
                    DataTable dt = this.execute<DataTable>("com.hnshituo.pur.requireplan.service.OilTradeService", "find_Trade_Sum", new object[] { trade1 });
                    if (dt != null)
                    {
                        GridHelper.CopyDataToDatatable(ref  dt, ref dataTable2, true);
                        GridHelper.RefreshAndAutoSize(ultraGrid2);

                    }
                }
                else
                {
                    trade.Clear();
                    OilTrade trade1 = new OilTrade();
                    trade1.CardMId = txt_Card_No_M.Text.Trim();
                    trade1.UserOrgName = txt_org_name.Text.Trim();
                    trade1.UserName = QUse_Name.Text.Trim();
                    trade1.CardDId = Qcard_d_no.Text.Trim();
                    trade1.DeleteName = Qyear.Text.ToString().Trim();
                    if (Qstatus.SelectedIndex != -1)
                    {
                        trade1.Status = Qstatus.Value.ToString().Trim();
                    }
                    if (txt_D_type.SelectedIndex != -1)
                    {
                        trade1.Type1 = txt_M_type.Value.ToString().Trim();
                    }
                    if (txt_M_type.SelectedIndex != -1)
                    {
                        trade1.Type2 = txt_D_type.Value.ToString().Trim();
                    }
                    DataTable dt = this.execute<DataTable>("com.hnshituo.pur.requireplan.service.OilTradeService", "find_Trade", new object[] { trade1 });
                    if (dt != null)
                    {
                        GridHelper.CopyDataToDatatable(ref dt, ref dataTable1, true);
                        GridHelper.RefreshAndAutoSize(ultraGrid1);

                    }
                }
            }
            catch (Exception ex)
            {
                MessageUtil.ShowTips("加载数据异常：" + ex);
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }
        }

        private void ultraGrid2_InitializeRow(object sender, Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)
        {
            if (e.Row.Cells["type1"].Value.ToString().Equals("骨干油卡"))
            {
                e.Row.Appearance.ForeColor = Color.Blue;
            }
        }

        private void ultraGrid1_InitializeRow(object sender, Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)
        {
            if (e.Row.Cells["status"].Value.ToString().Equals("暂停"))
            {
                e.Row.Appearance.ForeColor = Color.Red;
            }
            else if (e.Row.Cells["status"].Value.ToString().Equals("注销"))
            {
                e.Row.Appearance.ForeColor = Color.Gray;
            }
            else
            {
                e.Row.Appearance.ForeColor = Color.Black;
            }
        }

    }

}