MES_Client/TGMES/Core.StlMes.Client.Pms/Report/FrmTransceiver1.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;
using CoreFS.CA06;
using Pur.Entity;
using System.Collections;
using Infragistics.Win.UltraWinGrid;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Tool;
using System.Text.RegularExpressions;
using System.Drawing;
using Pur.Entity.ck;
using com.hnshituo.pur.ck.vo;
using Pur.Entity.configureEntity;
using com.hnshituo.pur.purplan.vo;
using NPOI.SS.Util;


namespace Pur.FrmTransceiver1
{
    public partial class FrmTransceiver1 : FrmPmsBase
    {
        public FrmTransceiver1()
        {
            InitializeComponent();
        }
        /// <summary>
        /// 树节点选中事件触发时，存储父节点id，防止当父节点选中项转移到其他焦点时，无法获取数据。
        /// </summary>
        private static string parentCode = "";
        private static string time1 = "";
        private static string time2 = "";
        private static string shift = ""; //物料名称
        private static string group = "";  //物料编码


        //菜单按钮
        public override void ToolBar_Click(object sender, string ToolbarKey)//菜单按钮
        {
            switch (ToolbarKey)
            {
                case "Query"://刷新数据
                    doQuery();
                    break;
                case "doReport"://导出Excel
                    ReportPUR_REQUIRE_PLAND();
                    break;
                case "getReportReview"://打印收发存报表
                    getReportHTReview();
                    break;
                case "doClose"://关闭
                    this.Close();
                    break;
            }
        }

        /// <summary>
        /// 打印收发存报表
        /// </summary>
        private void getReportHTReview()
        {
            try
            {
                String createTime = this.RegStartTime.Text.ToString();
                String updateTime = this.RegEndTime.Text.ToString();
                this.Cursor = Cursors.WaitCursor;
                UltraGridRow ugr = ultraGrid3.ActiveRow;
                if (ugr == null)
                {
                    MessageUtil.ShowWarning("请选择您要查看的信息！");
                    return;
                }

                // string itemName = ugr.Cells["itemCode"].Value.ToString();

                string strurl = "";
                DataTable dt = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1223" }, this.ob);
                DataRow[] drArr = dt.Select("validflag='1'");
                if (drArr.Length != 1)
                {
                    MessageUtil.ShowTips("基础数据维护错误：报表系统需维护有效的Ip且只能维护一个有效ip！");
                    return;
                }
                String TipsEnv = drArr[0]["baseName"].ToString();
                String strUrlPort = "http://localhost:8075";//报表系统IP
                String[] str = strUrlPort.Split(':');
                String strUrl = str[0] + ":" + str[1];

                if (ob.MainUrl.StartsWith(strUrl))
                {
                    //测试环境
                    if (TipsEnv == "2")
                    {
                        strurl = strUrlPort + "/webroot/decision/view/report?viewlet=CkStorageGangtie.cpt&op=view" + "&createTime=" + createTime + "&updateTime=" + updateTime;
                    }
                    else
                    {
                        strurl = strUrlPort + "/webroot/decision/view/report?viewlet=CkStorageGangtie.cpt&op=view" + "&createTime=" + createTime + "&updateTime=" + updateTime;
                    }

                }
                else
                {
                    //测试环境
                    if (TipsEnv == "2")
                    {
                        strurl = strUrlPort + "/webroot/decision/view/report?viewlet=CkStorageGangtie.cpt&op=view" + "&createTime=" + createTime + "&updateTime=" + updateTime;
                    }
                    else
                    {
                        if (ultraComboEditor1.SelectedIndex == 0)
                        {
                            strurl = strUrlPort + "/webroot/decision/view/report?viewlet=CkStorageGangtie.cpt&op=view" + "&createTime=" + createTime + "&updateTime=" + updateTime;
                        }
                        else
                        {
                            strurl = strUrlPort + "/webroot/decision/view/report?viewlet=CkStorageCailiao.cpt&op=view" + "&createTime=" + createTime + "&updateTime=" + updateTime;
                        }
                    }
                }

                //if (ob.MainUrl.StartsWith("http://127.0.0.1"))
                //{
                //    strurl = "http://localhost:8075/webroot/decision/view/report?viewlet=RepPurOrderReviewDev.cpt&__bypagesize__=false" + "&cmbOrder=" + orderNo;

                //}
                //else
                //{
                //    strurl = "http://localhost:8075/webroot/decision/view/report?viewlet=RepPurOrderReview.cpt&__bypagesize__=false" + "&cmbOrder=" + orderNo;
                //}
                FrmRepExcel fBug = new FrmRepExcel(ob, strurl);
                fBug.AutoSize = true;
                fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
                fBug.WindowState = FormWindowState.Maximized;
                fBug.Text = "TPCO收发存报表查询";
                fBug.Show();
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }
        }

        /// <summary>
        ///// 导出Excel
        ///// </summary>
        private void ReportPUR_REQUIRE_PLAND()
        {
            try
            {
                DataRow drNew = dataTable3.NewRow();
                this.Cursor = Cursors.WaitCursor;
                UltraGridRow uRow = this.ultraGrid3.ActiveRow;
                string unit = uRow.Cells["unIt"].Value.ToString();
                //获取导出的采购计划行表
                ArrayList alUltraGrid = new ArrayList();
                //(ultraGrid1.DataSource as DataTable).Rows.InsertAt(myRow, 0);//这样写就插入到第一行
                if (unit == "钢铁料科")
                {
                    DataRow rows = dataTable1.NewRow();
                    rows[0] = dataTable3.Rows[2][0];
                    foreach (DataColumn dc in dataTable3.Columns)
                    {
                        drNew[dc.ColumnName] = dataTable3.Rows[2][dc.ColumnName];
                    }
                    dataTable1.AcceptChanges();
                    dataTable1.Rows.Add(drNew.ItemArray);

                    foreach (UltraGridRow urg in ultraGrid1.Rows)
                    {
                        if (urg.Cells["arcmidCode"].Value.ToString() == "钢铁料科")
                        {
                            urg.Cells["arcmidName"].Value = unit;
                        }
                    }
                    alUltraGrid.Add(ultraGrid1);

                    ArrayList alSheeft = new ArrayList();
                    alSheeft.Add("收发存报表" + unit);
                    if (ultraGrid1.Rows.Count > 0)
                    {
                        GridHelper.ulGridToExcel(alUltraGrid, alSheeft, "收发存报表" + unit);//导出excel
                    }
                    foreach (UltraGridRow urg in ultraGrid1.Rows)
                    {
                        if (urg.Cells["arcmidCode"].Value.ToString() == "钢铁料科")
                        {
                            urg.Delete();
                            return;
                        }
                    }
                }
                else if (unit == "铁合金科")
                {
                    DataRow rows = dataTable1.NewRow();
                    rows[0] = dataTable3.Rows[0][0];
                    foreach (DataColumn dc in dataTable3.Columns)
                    {
                        drNew[dc.ColumnName] = dataTable3.Rows[0][dc.ColumnName];
                    }
                    dataTable1.AcceptChanges();
                    dataTable1.Rows.Add(drNew.ItemArray);
                    //dataTable1.Rows.InsertAt(drNew.ItemArray,0);
                    foreach (UltraGridRow urg in ultraGrid1.Rows)
                    {
                        if (urg.Cells["arcmidCode"].Value.ToString() == "铁合金科")
                        {
                            urg.Cells["arcmidName"].Value = unit;
                        }
                    }
                    alUltraGrid.Add(ultraGrid1);

                    ArrayList alSheeft = new ArrayList();
                    alSheeft.Add("收发存报表" + unit);
                    if (ultraGrid1.Rows.Count > 0)
                    {
                        GridHelper.ulGridToExcel(alUltraGrid, alSheeft, "收发存报表" + unit);//导出excel
                    }
                    foreach (UltraGridRow urg in ultraGrid1.Rows)
                    {
                        if (urg.Cells["arcmidCode"].Value.ToString() == "铁合金科")
                        {
                            urg.Delete();
                            return;
                        }
                    }
                    //dataTable1.Rows.Remove(drNew);
                }
                else if (unit == "耐火材料科")
                {
                    DataRow rows = dataTable1.NewRow();
                    rows[0] = dataTable3.Rows[1][0];
                    foreach (DataColumn dc in dataTable3.Columns)
                    {
                        drNew[dc.ColumnName] = dataTable3.Rows[1][dc.ColumnName];
                    }
                    dataTable1.AcceptChanges();

                    dataTable1.Rows.Add(drNew.ItemArray);
                    string item = "";
                    for (int i = 0; i < dataTable2.Rows.Count - 1; i++)
                    {
                        if (dataTable2.Rows[i]["arcmidCode"].ToString() == "W07")
                        {
                            if (item == "") item = dataTable2.Rows[i]["itemUom"].ToString();
                            else
                            {
                                if (item != dataTable2.Rows[i]["itemUom"].ToString())
                                {
                                    foreach (UltraGridRow gru in ultraGrid1.Rows)
                                    {
                                        if (gru.Cells["arcmidCode"].Value.ToString() == "耐火材料科")
                                        {
                                            gru.Cells["qichuCount"].Hidden = true;
                                            gru.Cells["qichuPrice"].Hidden = true;
                                            gru.Cells["qichuPrice1"].Hidden = true;
                                            gru.Cells["rukuCount"].Hidden = true;
                                            gru.Cells["rukuPrice"].Hidden = true;
                                            gru.Cells["rukuPrice1"].Hidden = true;
                                            gru.Cells["chukuCount"].Hidden = true;
                                            gru.Cells["chukuPrice"].Hidden = true;
                                            gru.Cells["chukuPrice1"].Hidden = true;
                                            gru.Cells["qimoCount"].Hidden = true;
                                            gru.Cells["qimoPrice"].Hidden = true;
                                            gru.Cells["qimoPrice1"].Hidden = true;
                                        }
                                    }
                                    break;
                                }
                            }
                        }
                    }
                    foreach (UltraGridRow urg in ultraGrid1.Rows)
                    {
                        if (urg.Cells["arcmidCode"].Value.ToString() == "耐火材料科")
                        {
                            urg.Cells["arcmidName"].Value = unit;
                        }
                    }
                    alUltraGrid.Add(ultraGrid1);

                    ArrayList alSheeft = new ArrayList();
                    alSheeft.Add("收发存报表" + unit);
                    if (ultraGrid1.Rows.Count > 0)
                    {
                        GridHelper.ulGridToExcel(alUltraGrid, alSheeft, "收发存报表" + unit);//导出excel
                    }
                    foreach (UltraGridRow urg in ultraGrid1.Rows)
                    {
                        if (urg.Cells["arcmidCode"].Value.ToString() == "耐火材料科")
                        {
                            urg.Delete();
                            return;
                        }
                    }
                    //dataTable1.Rows.Remove(drNew);
                }
                else if (unit == "矿石燃料科")
                {
                    DataRow rows = dataTable1.NewRow();
                    rows[0] = dataTable3.Rows[3][0];
                    foreach (DataColumn dc in dataTable3.Columns)
                    {
                        drNew[dc.ColumnName] = dataTable3.Rows[3][dc.ColumnName];
                    }
                    dataTable1.AcceptChanges();
                    dataTable1.Rows.Add(drNew.ItemArray);
                    string item1 = "";
                    string item2 = "";
                    for (int i = 0; i < dataTable2.Rows.Count - 1; i++)
                    {
                        if (dataTable2.Rows[i]["arcmidCode"].ToString() == "W06")
                        {
                            if (item1 == "") item1 = dataTable2.Rows[i]["itemUom"].ToString();
                            else
                            {
                                if (item1 != dataTable2.Rows[i]["itemUom"].ToString())
                                {
                                    foreach (UltraGridRow gru in ultraGrid1.Rows)
                                    {
                                        if (gru.Cells["arcmidCode"].Value.ToString() == "矿石燃料科")
                                        {
                                            gru.Cells["qichuCount"].Hidden = true;
                                            gru.Cells["qichuPrice"].Hidden = true;
                                            gru.Cells["qichuPrice1"].Hidden = true;
                                            gru.Cells["rukuCount"].Hidden = true;
                                            gru.Cells["rukuPrice"].Hidden = true;
                                            gru.Cells["rukuPrice1"].Hidden = true;
                                            gru.Cells["chukuCount"].Hidden = true;
                                            gru.Cells["chukuPrice"].Hidden = true;
                                            gru.Cells["chukuPrice1"].Hidden = true;
                                            gru.Cells["qimoCount"].Hidden = true;
                                            gru.Cells["qimoPrice"].Hidden = true;
                                            gru.Cells["qimoPrice1"].Hidden = true;
                                        }
                                    }
                                    break;
                                }
                            }
                        }
                    }
                    for (int i = 0; i < dataTable2.Rows.Count - 1; i++)
                    {
                        if (dataTable2.Rows[i]["arcmidCode"].ToString() == "W05")
                        {
                            if (item2 == "") item2 = dataTable2.Rows[i]["itemUom"].ToString();
                            else
                            {
                                if (item2 != dataTable2.Rows[i]["itemUom"].ToString())
                                {
                                    foreach (UltraGridRow gru in ultraGrid1.Rows)
                                    {
                                        if (gru.Cells["unit"].Text.ToString() == "矿石燃料科")
                                        {
                                            gru.Cells["qichuCount"].Hidden = true;
                                            gru.Cells["qichuPrice"].Hidden = true;
                                            gru.Cells["qichuPrice1"].Hidden = true;
                                            gru.Cells["rukuCount"].Hidden = true;
                                            gru.Cells["rukuPrice"].Hidden = true;
                                            gru.Cells["rukuPrice1"].Hidden = true;
                                            gru.Cells["chukuCount"].Hidden = true;
                                            gru.Cells["chukuPrice"].Hidden = true;
                                            gru.Cells["chukuPrice1"].Hidden = true;
                                            gru.Cells["qimoCount"].Hidden = true;
                                            gru.Cells["qimoPrice"].Hidden = true;
                                            gru.Cells["qimoPrice1"].Hidden = true;
                                        }
                                    }
                                    break;
                                }
                            }
                        }
                    }
                    foreach (UltraGridRow urg in ultraGrid1.Rows)
                    {
                        if (urg.Cells["arcmidCode"].Value.ToString() == "矿石燃料科")
                        {
                            urg.Cells["arcmidName"].Value = unit;
                        }
                    }
                    alUltraGrid.Add(ultraGrid1);

                    ArrayList alSheeft = new ArrayList();
                    alSheeft.Add("收发存报表" + unit);
                    if (ultraGrid1.Rows.Count > 0)
                    {
                        GridHelper.ulGridToExcel(alUltraGrid, alSheeft, "收发存报表" + unit);//导出excel
                    }
                    foreach (UltraGridRow urg in ultraGrid1.Rows)
                    {
                        if (urg.Cells["arcmidCode"].Value.ToString() == "矿石燃料科")
                        {
                            urg.Delete();
                            return;
                        }
                    }
                }
                else if (unit == "材料科")
                {
                    DataRow rows = dataTable1.NewRow();
                    rows[0] = dataTable3.Rows[4][0];
                    foreach (DataColumn dc in dataTable3.Columns)
                    {
                        drNew[dc.ColumnName] = dataTable3.Rows[4][dc.ColumnName];
                    }
                    dataTable1.AcceptChanges();
                    dataTable1.Rows.Add(drNew.ItemArray);
                    string item = "";
                    for (int i = 0; i < dataTable2.Rows.Count - 1; i++)
                    {
                        if (dataTable2.Rows[i]["arcmidCode"].ToString() != "Y01" && dataTable2.Rows[i]["arcmidCode"].ToString() != "Y04" && dataTable2.Rows[i]["arcmidCode"].ToString() != "Y02"
                        && dataTable2.Rows[i]["arcmidCode"].ToString() != "Y03" && dataTable2.Rows[i]["arcmidCode"].ToString() != "W01" && dataTable2.Rows[i]["arcmidCode"].ToString() != "W04"
                        && dataTable2.Rows[i]["arcmidCode"].ToString() != "W07" && dataTable2.Rows[i]["arcmidCode"].ToString() != "W05" && dataTable2.Rows[i]["arcmidCode"].ToString() != "W06")
                        {
                            if (item == "") item = dataTable2.Rows[i]["itemUom"].ToString();
                            else
                            {
                                if (item != dataTable2.Rows[i]["itemUom"].ToString())
                                {
                                    foreach (UltraGridRow gru in ultraGrid1.Rows)
                                    {
                                        if (gru.Cells["arcmidCode"].Value.ToString() == "材料科")
                                        {
                                            gru.Cells["qichuCount"].Hidden = true;
                                            gru.Cells["qichuPrice"].Hidden = true;
                                            gru.Cells["qichuPrice1"].Hidden = true;
                                            gru.Cells["rukuCount"].Hidden = true;
                                            gru.Cells["rukuPrice"].Hidden = true;
                                            gru.Cells["rukuPrice1"].Hidden = true;
                                            gru.Cells["chukuCount"].Hidden = true;
                                            gru.Cells["chukuPrice"].Hidden = true;
                                            gru.Cells["chukuPrice1"].Hidden = true;
                                            gru.Cells["qimoCount"].Hidden = true;
                                            gru.Cells["qimoPrice"].Hidden = true;
                                            gru.Cells["qimoPrice1"].Hidden = true;
                                        }
                                    }
                                    break;
                                }
                            }
                        }
                    }
                    foreach (UltraGridRow urg in ultraGrid1.Rows)
                    {
                        if (urg.Cells["arcmidCode"].Value.ToString() == "材料科")
                        {
                            urg.Cells["arcmidName"].Value = unit;
                        }
                    }
                    alUltraGrid.Add(ultraGrid1);

                    ArrayList alSheeft = new ArrayList();
                    alSheeft.Add("收发存报表" + unit);
                    if (ultraGrid1.Rows.Count > 0)
                    {
                        GridHelper.ulGridToExcel(alUltraGrid, alSheeft, "收发存报表" + unit);//导出excel
                    }
                    foreach (UltraGridRow urg in ultraGrid1.Rows)
                    {
                        if (urg.Cells["arcmidCode"].Value.ToString() == "材料科")
                        {
                            urg.Delete();
                            return;
                        }
                    }
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowTips("导出失败" + e.Message);
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }
        }

        /// <summary>
        /// 查询采购计划主表
        /// </summary>
        /// <param name="PurPlanMEntity"></param>
        public void doQuery()
        {

            #region
            //物料名称
            if (this.txt_itemName.Text.Trim() != "")
            {
                shift = this.txt_itemName.Value.ToString();
            }
            if (DateTime.Parse(RegStartTime.Value.ToString()) > DateTime.Parse(RegEndTime.Value.ToString()))
            {
                MessageUtil.ShowTips("选择时间区间错误,请重新选择!");
                return;
            }
            else
            {
                time1 = Convert.ToDateTime(RegStartTime.Value).ToString("yyyy-MM-dd");
                time2 = Convert.ToDateTime(RegEndTime.Value).ToString("yyyy-MM-dd");
            }
            //物料编码
            if (this.txt_itemCode.Text.Trim() != "")
            {
                group = this.txt_itemCode.Value.ToString();
            }
            #endregion
            CkStorageEntity plan1 = new CkStorageEntity();
            plan1.ItemName = shift;//物料名称
            plan1.ItemCode = group;//物料编码
            plan1.CreateTime = time1;
            plan1.UpdateTime = time2;
            DataTable dt = this.execute<DataTable>("com.hnshituo.pur.ck.service.CkStorageService", "getPurPlanMkeshi", new object[] { plan1 });
            GridHelper.CopyDataToDatatable(ref dt, ref dataTable3, true);
        }


        private void ultraGrid3_AfterRowActivate(object sender, EventArgs e)
        {
            //this.Cursor = Cursors.WaitCursor;
            //ultraGrid1.Update();
            dataTable2.Clear();
            dataTable1.Clear();

            if (this.txt_itemName.Text.Trim() != "")
            {
                shift = this.txt_itemName.Value.ToString();
            }
            //入库时间
            if (DateTime.Parse(RegStartTime.Value.ToString()) > DateTime.Parse(RegEndTime.Value.ToString()))
            {
                MessageUtil.ShowTips("选择时间区间错误,请重新选择!");
                return;
            }
            else
            {
                time1 = Convert.ToDateTime(RegStartTime.Value).ToString("yyyy-MM-dd");
                time2 = Convert.ToDateTime(RegEndTime.Value).ToString("yyyy-MM-dd");
            }
            //物料编码
            if (this.txt_itemCode.Text.Trim() != "")
            {
                group = this.txt_itemCode.Value.ToString();
            }
            CkStorageEntity plan1 = new CkStorageEntity();
            plan1.ItemName = shift;//物料名称
            plan1.ItemCode = group;//物料编码
            plan1.CreateTime = time1;
            plan1.UpdateTime = time2;
            UltraGridRow uRow = this.ultraGrid3.ActiveRow;
            if (uRow.Cells["unIt"].Value.ToString() == "钢铁料科")
            {
                DataTable dt2 = this.execute<DataTable>("com.hnshituo.pur.ck.service.CkStorageService", "getPurPlanMshoufa", new object[] { plan1 });
                GridHelper.CopyDataToDatatable(ref dt2, ref dataTable1, true);
                foreach (UltraGridRow urg in ultraGrid1.Rows)
                {
                    if (urg.Cells["arcmidName"].Value.ToString() == "废钢")
                    {
                        urg.Hidden = false;
                    }
                    else if (urg.Cells["arcmidName"].Value.ToString() == "生铁")
                    {
                        urg.Hidden = false;
                    }
                    else if (urg.Cells["arcmidName"].Value.ToString() == "海绵铁")
                    {
                        urg.Hidden = false;
                    }
                    else if (urg.Cells["arcmidName"].Value.ToString() == "厂回")
                    {
                        urg.Hidden = false;
                    }
                    else
                    {
                        urg.Hidden = true;
                    }
                }
                DataTable dt8 = this.execute<DataTable>("com.hnshituo.pur.ck.service.CkStorageService", "doQuery", new object[] { plan1 });//子类表
                if (dt2 != null && dt2.Rows.Count > 0)
                {
                    //将汇总头信息按下列排序
                    DataTable dt_Copy = dt2.Clone();
                    dt_Copy.PrimaryKey = new DataColumn[] { dt_Copy.Columns["arcmidName"] };
                    for (int i = 0; i < dt2.Rows.Count; i++)
                    {
                        switch (dt2.Rows[i]["arcmidName"].ToString())
                        {
                            case "钢铁料":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                            case "铁合金":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                            case "电极":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                            case "添加剂":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                            case "矿石燃料":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                            case "耐火材料":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                            case "辅助材料":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                        }
                    }
                    for (int i = 0; i < dt2.Rows.Count; i++)
                    {
                        if (dt2.Rows[i]["arcmidName"].ToString().Trim() != "")
                        {
                            if (!dt_Copy.Rows.Contains(dt2.Rows[i]["arcmidName"].ToString()))
                            {
                                dt_Copy.ImportRow(dt2.Rows[i]);
                            }
                        }
                    }
                    dt2 = dt_Copy.Copy();
                    dt2.PrimaryKey = null;
                    GridHelper.CopyDataToDatatable(ref dt8, ref dataTable2, true);
                }
            }
            else if (uRow.Cells["unIt"].Value.ToString() == "铁合金科")
            {
                DataTable dt2 = this.execute<DataTable>("com.hnshituo.pur.ck.service.CkStorageService", "getPurPlanMhejin", new object[] { plan1 });
                GridHelper.CopyDataToDatatable(ref dt2, ref dataTable1, true);//父类表
                foreach (UltraGridRow urg in ultraGrid1.Rows)
                {
                    if (urg.Cells["arcmidName"].Value.ToString() == "铁合金")
                    {
                        urg.Hidden = false;
                    }
                    else if (urg.Cells["arcmidName"].Value.ToString() == "有色金属")
                    {
                        urg.Hidden = false;
                    }
                    else if (urg.Cells["arcmidName"].Value.ToString() == "添加剂")
                    {
                        urg.Hidden = false;
                    }
                    else if (urg.Cells["arcmidName"].Value.ToString() == "石墨制品")
                    {
                        urg.Hidden = false;
                    }
                    else
                    {
                        urg.Hidden = true;
                    }
                }
                DataTable dt8 = this.execute<DataTable>("com.hnshituo.pur.ck.service.CkStorageService", "doQuery", new object[] { plan1 });//子类表
                if (dt2 != null && dt2.Rows.Count > 0)
                {
                    //将汇总头信息按下列排序
                    DataTable dt_Copy = dt2.Clone();
                    dt_Copy.PrimaryKey = new DataColumn[] { dt_Copy.Columns["arcmidName"] };
                    for (int i = 0; i < dt2.Rows.Count; i++)
                    {
                        switch (dt2.Rows[i]["arcmidName"].ToString())
                        {
                            case "钢铁料":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                            case "铁合金":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                            case "电极":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                            case "添加剂":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                            case "矿石燃料":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                            case "耐火材料":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                            case "辅助材料":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                        }
                    }
                    for (int i = 0; i < dt2.Rows.Count; i++)
                    {
                        if (dt2.Rows[i]["arcmidName"].ToString().Trim() != "")
                        {
                            if (!dt_Copy.Rows.Contains(dt2.Rows[i]["arcmidName"].ToString()))
                            {
                                dt_Copy.ImportRow(dt2.Rows[i]);
                            }
                        }
                        dt2 = dt_Copy.Copy();
                        dt2.PrimaryKey = null;
                        GridHelper.CopyDataToDatatable(ref dt8, ref dataTable2, true);
                    }
                }
            }
            else if (uRow.Cells["unIt"].Value.ToString() == "耐火材料科")
            {
                DataTable dt2 = this.execute<DataTable>("com.hnshituo.pur.ck.service.CkStorageService", "getPurPlanMnaihuo", new object[] { plan1 });
                GridHelper.CopyDataToDatatable(ref dt2, ref dataTable1, true);
                foreach (UltraGridRow urg in ultraGrid1.Rows)
                {
                    if (urg.Cells["arcmidName"].Value.ToString() == "耐火材料")
                    {
                        urg.Hidden = false;
                    }
                    else
                    {
                        urg.Hidden = true;
                    }
                }
                DataTable dt8 = this.execute<DataTable>("com.hnshituo.pur.ck.service.CkStorageService", "doQuery", new object[] { plan1 });//子类表
                string item = "";
                for (int i = 0; i < dt8.Rows.Count - 1; i++)
                {
                    if (dt8.Rows[i]["arcmidCode"].ToString() == "W07")
                    {
                        if (item == "") item = dt8.Rows[i]["itemUom"].ToString();
                        else
                        {
                            if (item != dt8.Rows[i]["itemUom"].ToString())
                            {
                                foreach (UltraGridRow urg in ultraGrid1.Rows)
                                {
                                    urg.Cells["qichuCount"].Hidden = true;
                                    urg.Cells["qichuPrice"].Hidden = true;
                                    urg.Cells["qichuPrice1"].Hidden = true;
                                    urg.Cells["rukuCount"].Hidden = true;
                                    urg.Cells["rukuPrice"].Hidden = true;
                                    urg.Cells["rukuPrice1"].Hidden = true;
                                    urg.Cells["chukuCount"].Hidden = true;
                                    urg.Cells["chukuPrice"].Hidden = true;
                                    urg.Cells["chukuPrice1"].Hidden = true;
                                    urg.Cells["qimoCount"].Hidden = true;
                                    urg.Cells["qimoPrice"].Hidden = true;
                                    urg.Cells["qimoPrice1"].Hidden = true;
                                }
                                break;
                            }
                        }
                    }
                }
                if (dt2 != null && dt2.Rows.Count > 0)
                {
                    //将汇总头信息按下列排序
                    DataTable dt_Copy = dt2.Clone();
                    dt_Copy.PrimaryKey = new DataColumn[] { dt_Copy.Columns["arcmidName"] };
                    for (int i = 0; i < dt2.Rows.Count; i++)
                    {
                        switch (dt2.Rows[i]["arcmidName"].ToString())
                        {
                            case "钢铁料":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                            case "铁合金":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                            case "电极":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                            case "添加剂":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                            case "矿石燃料":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                            case "耐火材料":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                            case "辅助材料":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                        }
                    }
                    for (int i = 0; i < dt2.Rows.Count; i++)
                    {
                        if (dt2.Rows[i]["arcmidName"].ToString().Trim() != "")
                        {
                            if (!dt_Copy.Rows.Contains(dt2.Rows[i]["arcmidName"].ToString()))
                            {
                                dt_Copy.ImportRow(dt2.Rows[i]);
                            }
                        }
                        dt2 = dt_Copy.Copy();
                        dt2.PrimaryKey = null;
                        GridHelper.CopyDataToDatatable(ref dt8, ref dataTable2, true);
                    }
                }
            }
            else if (uRow.Cells["unIt"].Value.ToString() == "矿石燃料科")
            {
                DataTable dt2 = this.execute<DataTable>("com.hnshituo.pur.ck.service.CkStorageService", "getPurPlanMkuangshi", new object[] { plan1 });
                GridHelper.CopyDataToDatatable(ref dt2, ref dataTable1, true);
                foreach (UltraGridRow urg in ultraGrid1.Rows)
                {
                    if (urg.Cells["arcmidName"].Value.ToString() == "矿石")
                    {
                        urg.Hidden = false;
                    }
                    else if (urg.Cells["arcmidName"].Value.ToString() == "燃料")
                    {
                        urg.Hidden = false;
                    }
                    else
                    {
                        urg.Hidden = true;
                    }
                }
                DataTable dt8 = this.execute<DataTable>("com.hnshituo.pur.ck.service.CkStorageService", "doQuery", new object[] { plan1 });//子类表
                string item1 = "";
                for (int i = 0; i < dt8.Rows.Count - 1; i++)
                {
                    if (dt8.Rows[i]["arcmidCode"].ToString() == "W06")
                    {
                        if (item1 == "") item1 = dt8.Rows[i]["itemUom"].ToString();
                        else
                        {
                            if (item1 != dt8.Rows[i]["itemUom"].ToString())
                            {
                                foreach (UltraGridRow urg in ultraGrid1.Rows)
                                {
                                    urg.Cells["qichuCount"].Hidden = true;
                                    urg.Cells["qichuPrice"].Hidden = true;
                                    urg.Cells["qichuPrice1"].Hidden = true;
                                    urg.Cells["rukuCount"].Hidden = true;
                                    urg.Cells["rukuPrice"].Hidden = true;
                                    urg.Cells["rukuPrice1"].Hidden = true;
                                    urg.Cells["chukuCount"].Hidden = true;
                                    urg.Cells["chukuPrice"].Hidden = true;
                                    urg.Cells["chukuPrice1"].Hidden = true;
                                    urg.Cells["qimoCount"].Hidden = true;
                                    urg.Cells["qimoPrice"].Hidden = true;
                                    urg.Cells["qimoPrice1"].Hidden = true;
                                }
                                break;
                            }
                        }
                    }
                }
                string item = "";
                for (int i = 0; i < dt8.Rows.Count - 1; i++)
                {
                    if (dt8.Rows[i]["arcmidCode"].ToString() == "W05")
                    {
                        if (item == "") item = dt8.Rows[i]["itemUom"].ToString();
                        else
                        {
                            if (item != dt8.Rows[i]["itemUom"].ToString())
                            {
                                foreach (UltraGridRow urg in ultraGrid1.Rows)
                                {
                                    urg.Cells["qichuCount"].Hidden = true;
                                    urg.Cells["qichuPrice"].Hidden = true;
                                    urg.Cells["qichuPrice1"].Hidden = true;
                                    urg.Cells["rukuCount"].Hidden = true;
                                    urg.Cells["rukuPrice"].Hidden = true;
                                    urg.Cells["rukuPrice1"].Hidden = true;
                                    urg.Cells["chukuCount"].Hidden = true;
                                    urg.Cells["chukuPrice"].Hidden = true;
                                    urg.Cells["chukuPrice1"].Hidden = true;
                                    urg.Cells["qimoCount"].Hidden = true;
                                    urg.Cells["qimoPrice"].Hidden = true;
                                    urg.Cells["qimoPrice1"].Hidden = true;
                                }
                                break;
                            }
                        }
                    }
                }
                if (dt2 != null && dt2.Rows.Count > 0)
                {
                    //将汇总头信息按下列排序
                    DataTable dt_Copy = dt2.Clone();
                    dt_Copy.PrimaryKey = new DataColumn[] { dt_Copy.Columns["arcmidName"] };
                    for (int i = 0; i < dt2.Rows.Count; i++)
                    {
                        switch (dt2.Rows[i]["arcmidName"].ToString())
                        {
                            case "钢铁料":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                            case "铁合金":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                            case "电极":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                            case "添加剂":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                            case "矿石燃料":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                            case "耐火材料":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                            case "辅助材料":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                        }
                    }
                    for (int i = 0; i < dt2.Rows.Count; i++)
                    {
                        if (dt2.Rows[i]["arcmidName"].ToString().Trim() != "")
                        {
                            if (!dt_Copy.Rows.Contains(dt2.Rows[i]["arcmidName"].ToString()))
                            {
                                dt_Copy.ImportRow(dt2.Rows[i]);
                            }
                        }
                    }
                    dt2 = dt_Copy.Copy();
                    dt2.PrimaryKey = null;
                    GridHelper.CopyDataToDatatable(ref dt8, ref dataTable2, true);
                }
            }
            else if (uRow.Cells["unIt"].Value.ToString() == "材料科")
            {
                DataTable dt2 = this.execute<DataTable>("com.hnshituo.pur.ck.service.CkStorageService", "getPurPlanMcailiao", new object[] { plan1 });
                GridHelper.CopyDataToDatatable(ref dt2, ref dataTable1, true);
                foreach (UltraGridRow urg in ultraGrid1.Rows)
                {
                    if (urg.Cells["arcmidName"].Value.ToString() == "矿石")
                    {
                        urg.Hidden = true;
                    }
                    else if (urg.Cells["arcmidName"].Value.ToString() == "燃料")
                    {
                        urg.Hidden = true;
                    }
                    else if (urg.Cells["arcmidName"].Value.ToString() == "耐火材料")
                    {
                        urg.Hidden = true;
                    }
                    else if (urg.Cells["arcmidName"].Value.ToString() == "石墨制品")
                    {
                        urg.Hidden = true;
                    }
                    else if (urg.Cells["arcmidName"].Value.ToString() == "添加剂")
                    {
                        urg.Hidden = true;
                    }
                    else if (urg.Cells["arcmidName"].Value.ToString() == "铁合金")
                    {
                        urg.Hidden = true;
                    }
                    else if (urg.Cells["arcmidName"].Value.ToString() == "有色金属")
                    {
                        urg.Hidden = true;
                    }
                    else if (urg.Cells["arcmidName"].Value.ToString() == "废钢")
                    {
                        urg.Hidden = true;
                    }
                    else if (urg.Cells["arcmidName"].Value.ToString() == "生铁")
                    {
                        urg.Hidden = true;
                    }
                    else if (urg.Cells["arcmidName"].Value.ToString() == "海绵铁")
                    {
                        urg.Hidden = true;
                    }
                    else if (urg.Cells["arcmidName"].Value.ToString() == "厂回")
                    {
                        urg.Hidden = true;
                    }
                    else if (urg.Cells["arcmidName"].Value.ToString() == "测试中类1")
                    {
                        urg.Hidden = true;
                    }
                    else if (urg.Cells["arcmidName"].Value.ToString() == "测试中类")
                    {
                        urg.Hidden = true;
                    }
                    else if (urg.Cells["arcmidName"].Value.ToString() == "")
                    {
                        urg.Hidden = true;
                    }
                    else
                    {
                        urg.Hidden = false;
                    }
                }
                DataTable dt8 = this.execute<DataTable>("com.hnshituo.pur.ck.service.CkStorageService", "doQuery", new object[] { plan1 });//子类表
                string item = "";
                for (int i = 0; i < dt8.Rows.Count - 1; i++)
                {
                    if (dt8.Rows[i]["arcmidCode"].ToString() != "Y01" && dt8.Rows[i]["arcmidCode"].ToString() != "Y04" && dt8.Rows[i]["arcmidCode"].ToString() != "Y02"
                         && dt8.Rows[i]["arcmidCode"].ToString() != "Y03" && dt8.Rows[i]["arcmidCode"].ToString() != "W01" && dt8.Rows[i]["arcmidCode"].ToString() != "W04"
                         && dt8.Rows[i]["arcmidCode"].ToString() != "W07" && dt8.Rows[i]["arcmidCode"].ToString() != "W05" && dt8.Rows[i]["arcmidCode"].ToString() != "W06")
                    {

                        if (item == "") item = dt8.Rows[i]["itemUom"].ToString();
                        else
                        {
                            if (item != dt8.Rows[i]["itemUom"].ToString())
                            {
                                foreach (UltraGridRow urg in ultraGrid1.Rows)
                                {
                                    urg.Cells["qichuCount"].Hidden = true;
                                    urg.Cells["qichuPrice"].Hidden = true;
                                    urg.Cells["qichuPrice1"].Hidden = true;
                                    urg.Cells["rukuCount"].Hidden = true;
                                    urg.Cells["rukuPrice"].Hidden = true;
                                    urg.Cells["rukuPrice1"].Hidden = true;
                                    urg.Cells["chukuCount"].Hidden = true;
                                    urg.Cells["chukuPrice"].Hidden = true;
                                    urg.Cells["chukuPrice1"].Hidden = true;
                                    urg.Cells["qimoCount"].Hidden = true;
                                    urg.Cells["qimoPrice"].Hidden = true;
                                    urg.Cells["qimoPrice1"].Hidden = true;
                                }
                                break;
                            }
                        }
                    }
                }
                if (dt2 != null && dt2.Rows.Count > 0)
                {
                    //将汇总头信息按下列排序
                    DataTable dt_Copy = dt2.Clone();
                    dt_Copy.PrimaryKey = new DataColumn[] { dt_Copy.Columns["arcmidName"] };
                    for (int i = 0; i < dt2.Rows.Count; i++)
                    {
                        switch (dt2.Rows[i]["arcmidName"].ToString())
                        {
                            case "钢铁料":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                            case "铁合金":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                            case "电极":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                            case "添加剂":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                            case "矿石燃料":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                            case "耐火材料":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                            case "辅助材料":
                                dt_Copy.ImportRow(dt2.Rows[i]);
                                break;
                        }
                    }
                    for (int i = 0; i < dt2.Rows.Count; i++)
                    {
                        if (dt2.Rows[i]["arcmidName"].ToString().Trim() != "")
                        {
                            if (!dt_Copy.Rows.Contains(dt2.Rows[i]["arcmidName"].ToString()))
                            {
                                dt_Copy.ImportRow(dt2.Rows[i]);
                            }
                        }
                        dt2 = dt_Copy.Copy();
                        dt2.PrimaryKey = null;
                        GridHelper.CopyDataToDatatable(ref dt8, ref dataTable2, true);
                    }
                }
            }
            Querykeshi();
        }
        private void Querykeshi()
        {
            string item = "";
            string item1 = "";
            string item2 = "";
            string item3 = "";
            for (int i = 0; i < dataTable2.Rows.Count - 1; i++)
            {
                if (dataTable2.Rows[i]["arcmidCode"].ToString() == "W07")
                {
                    if (item == "") item = dataTable2.Rows[i]["itemUom"].ToString();
                    else
                    {
                        if (item != dataTable2.Rows[i]["itemUom"].ToString())
                        {
                            foreach (UltraGridRow gru in ultraGrid3.Rows)
                            {
                                if (gru.Cells["unit"].Text.ToString() == "耐火材料科")
                                {
                                    gru.Cells["qichuCount"].Hidden = true;
                                    gru.Cells["qichuPrice"].Hidden = true;
                                    gru.Cells["qichuPrice1"].Hidden = true;
                                    gru.Cells["rukuCount"].Hidden = true;
                                    gru.Cells["rukuPrice"].Hidden = true;
                                    gru.Cells["rukuPrice1"].Hidden = true;
                                    gru.Cells["chukuCount"].Hidden = true;
                                    gru.Cells["chukuPrice"].Hidden = true;
                                    gru.Cells["chukuPrice1"].Hidden = true;
                                    gru.Cells["qimoCount"].Hidden = true;
                                    gru.Cells["qimoPrice"].Hidden = true;
                                    gru.Cells["qimoPrice1"].Hidden = true;
                                }
                            }
                            break;
                        }
                    }
                }
            }
            for (int i = 0; i < dataTable2.Rows.Count - 1; i++)
            {
                if (dataTable2.Rows[i]["arcmidCode"].ToString() == "W06")
                {
                    if (item1 == "") item1 = dataTable2.Rows[i]["itemUom"].ToString();
                    else
                    {
                        if (item1 != dataTable2.Rows[i]["itemUom"].ToString())
                        {
                            foreach (UltraGridRow gru in ultraGrid3.Rows)
                            {
                                if (gru.Cells["unit"].Text.ToString() == "矿石燃料科")
                                {
                                    gru.Cells["qichuCount"].Hidden = true;
                                    gru.Cells["qichuPrice"].Hidden = true;
                                    gru.Cells["qichuPrice1"].Hidden = true;
                                    gru.Cells["rukuCount"].Hidden = true;
                                    gru.Cells["rukuPrice"].Hidden = true;
                                    gru.Cells["rukuPrice1"].Hidden = true;
                                    gru.Cells["chukuCount"].Hidden = true;
                                    gru.Cells["chukuPrice"].Hidden = true;
                                    gru.Cells["chukuPrice1"].Hidden = true;
                                    gru.Cells["qimoCount"].Hidden = true;
                                    gru.Cells["qimoPrice"].Hidden = true;
                                    gru.Cells["qimoPrice1"].Hidden = true;
                                }
                            }
                            break;
                        }
                    }
                }
            }
            for (int i = 0; i < dataTable2.Rows.Count - 1; i++)
            {
                if (dataTable2.Rows[i]["arcmidCode"].ToString() == "W05")
                {
                    if (item2 == "") item2 = dataTable2.Rows[i]["itemUom"].ToString();
                    else
                    {
                        if (item2 != dataTable2.Rows[i]["itemUom"].ToString())
                        {
                            foreach (UltraGridRow gru in ultraGrid3.Rows)
                            {
                                if (gru.Cells["unit"].Text.ToString() == "矿石燃料科")
                                {
                                    gru.Cells["qichuCount"].Hidden = true;
                                    gru.Cells["qichuPrice"].Hidden = true;
                                    gru.Cells["qichuPrice1"].Hidden = true;
                                    gru.Cells["rukuCount"].Hidden = true;
                                    gru.Cells["rukuPrice"].Hidden = true;
                                    gru.Cells["rukuPrice1"].Hidden = true;
                                    gru.Cells["chukuCount"].Hidden = true;
                                    gru.Cells["chukuPrice"].Hidden = true;
                                    gru.Cells["chukuPrice1"].Hidden = true;
                                    gru.Cells["qimoCount"].Hidden = true;
                                    gru.Cells["qimoPrice"].Hidden = true;
                                    gru.Cells["qimoPrice1"].Hidden = true;
                                }
                            }
                            break;
                        }
                    }
                }
            }
            for (int i = 0; i < dataTable2.Rows.Count - 1; i++)
            {
                if (dataTable2.Rows[i]["arcmidCode"].ToString() != "Y01" && dataTable2.Rows[i]["arcmidCode"].ToString() != "Y04" && dataTable2.Rows[i]["arcmidCode"].ToString() != "Y02"
                        && dataTable2.Rows[i]["arcmidCode"].ToString() != "Y03" && dataTable2.Rows[i]["arcmidCode"].ToString() != "W01" && dataTable2.Rows[i]["arcmidCode"].ToString() != "W04"
                        && dataTable2.Rows[i]["arcmidCode"].ToString() != "W07" && dataTable2.Rows[i]["arcmidCode"].ToString() != "W05" && dataTable2.Rows[i]["arcmidCode"].ToString() != "W06")
                {
                    if (item3 == "") item3 = dataTable2.Rows[i]["itemUom"].ToString();
                    else
                    {
                        if (item3 != dataTable2.Rows[i]["itemUom"].ToString())
                        {
                            foreach (UltraGridRow gru in ultraGrid3.Rows)
                            {
                                if (gru.Cells["unit"].Text.ToString() == "材料科")
                                {
                                    gru.Cells["qichuCount"].Hidden = true;
                                    gru.Cells["qichuPrice"].Hidden = true;
                                    gru.Cells["qichuPrice1"].Hidden = true;
                                    gru.Cells["rukuCount"].Hidden = true;
                                    gru.Cells["rukuPrice"].Hidden = true;
                                    gru.Cells["rukuPrice1"].Hidden = true;
                                    gru.Cells["chukuCount"].Hidden = true;
                                    gru.Cells["chukuPrice"].Hidden = true;
                                    gru.Cells["chukuPrice1"].Hidden = true;
                                    gru.Cells["qimoCount"].Hidden = true;
                                    gru.Cells["qimoPrice"].Hidden = true;
                                    gru.Cells["qimoPrice1"].Hidden = true;
                                }
                            }
                            break;
                        }
                    }
                }
            }
        }

        private void FrmTransceiver1_Load(object sender, EventArgs e)
        {
            DateTime now = DateTime.Now;
            DateTime d1 = new DateTime(now.Year, now.Month, 1);
            //Convert.ToDateTime(RegStartTime.Value).ToString("yyyy-MM-dd");
            RegStartTime.Value = d1.ToString("yyyy-MM-dd");
            RegEndTime.Value = now.ToString("yyyy-MM-dd");
            ultraComboEditor1.SelectedIndex = 0;
        }
        //根据条件列隐藏
        private void ultraComboEditor1_ValueChanged(object sender, EventArgs e)
        {
            if (ultraComboEditor1.SelectedIndex == 0)
            {
                ultraGrid3.DisplayLayout.Bands[0].Columns["qichuPrice1"].Hidden = true;
                ultraGrid3.DisplayLayout.Bands[0].Columns["qichuMoney1"].Hidden = true;
                ultraGrid3.DisplayLayout.Bands[0].Columns["chukuPrice1"].Hidden = true;
                ultraGrid3.DisplayLayout.Bands[0].Columns["chukuMoney1"].Hidden = true;
                ultraGrid3.DisplayLayout.Bands[0].Columns["rukuPrice1"].Hidden = true;
                ultraGrid3.DisplayLayout.Bands[0].Columns["rukuMoney1"].Hidden = true;
                ultraGrid3.DisplayLayout.Bands[0].Columns["qimoPrice1"].Hidden = true;
                ultraGrid3.DisplayLayout.Bands[0].Columns["qimoMoney1"].Hidden = true;

                ultraGrid3.DisplayLayout.Bands[0].Columns["qichuPrice"].Hidden = false;
                ultraGrid3.DisplayLayout.Bands[0].Columns["qichuMoney"].Hidden = false;
                ultraGrid3.DisplayLayout.Bands[0].Columns["chukuPrice"].Hidden = false;
                ultraGrid3.DisplayLayout.Bands[0].Columns["chukuMoney"].Hidden = false;
                ultraGrid3.DisplayLayout.Bands[0].Columns["rukuPrice"].Hidden = false;
                ultraGrid3.DisplayLayout.Bands[0].Columns["rukuMoney"].Hidden = false;
                ultraGrid3.DisplayLayout.Bands[0].Columns["qimoPrice"].Hidden = false;
                ultraGrid3.DisplayLayout.Bands[0].Columns["qimoMoney"].Hidden = false;

                ultraGrid1.DisplayLayout.Bands[0].Columns["qichuPrice1"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["qichuMoney1"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["chukuPrice1"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["chukuMoney1"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["rukuPrice1"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["rukuMoney1"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["qimoPrice1"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["qimoMoney1"].Hidden = true;

                ultraGrid1.DisplayLayout.Bands[0].Columns["qichuPrice"].Hidden = false;
                ultraGrid1.DisplayLayout.Bands[0].Columns["qichuMoney"].Hidden = false;
                ultraGrid1.DisplayLayout.Bands[0].Columns["chukuPrice"].Hidden = false;
                ultraGrid1.DisplayLayout.Bands[0].Columns["chukuMoney"].Hidden = false;
                ultraGrid1.DisplayLayout.Bands[0].Columns["rukuPrice"].Hidden = false;
                ultraGrid1.DisplayLayout.Bands[0].Columns["rukuMoney"].Hidden = false;
                ultraGrid1.DisplayLayout.Bands[0].Columns["qimoPrice"].Hidden = false;
                ultraGrid1.DisplayLayout.Bands[0].Columns["qimoMoney"].Hidden = false;

                ultraGrid1.DisplayLayout.Bands[1].Columns["qichuPrice1"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[1].Columns["qichuMoney1"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[1].Columns["chukuPrice1"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[1].Columns["chukuMoney1"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[1].Columns["rukuPrice1"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[1].Columns["rukuMoney1"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[1].Columns["qimoPrice1"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[1].Columns["qimoMoney1"].Hidden = true;

                ultraGrid1.DisplayLayout.Bands[1].Columns["qichuPrice"].Hidden = false;
                ultraGrid1.DisplayLayout.Bands[1].Columns["qichuMoney"].Hidden = false;
                ultraGrid1.DisplayLayout.Bands[1].Columns["chukuPrice"].Hidden = false;
                ultraGrid1.DisplayLayout.Bands[1].Columns["chukuMoney"].Hidden = false;
                ultraGrid1.DisplayLayout.Bands[1].Columns["rukuPrice"].Hidden = false;
                ultraGrid1.DisplayLayout.Bands[1].Columns["rukuMoney"].Hidden = false;
                ultraGrid1.DisplayLayout.Bands[1].Columns["qimoPrice"].Hidden = false;
                ultraGrid1.DisplayLayout.Bands[1].Columns["qimoMoney"].Hidden = false;
            }
            else
            {
                ultraGrid3.DisplayLayout.Bands[0].Columns["qichuPrice"].Hidden = true;
                ultraGrid3.DisplayLayout.Bands[0].Columns["qichuMoney"].Hidden = true;
                ultraGrid3.DisplayLayout.Bands[0].Columns["chukuPrice"].Hidden = true;
                ultraGrid3.DisplayLayout.Bands[0].Columns["chukuMoney"].Hidden = true;
                ultraGrid3.DisplayLayout.Bands[0].Columns["rukuPrice"].Hidden = true;
                ultraGrid3.DisplayLayout.Bands[0].Columns["rukuMoney"].Hidden = true;
                ultraGrid3.DisplayLayout.Bands[0].Columns["qimoPrice"].Hidden = true;
                ultraGrid3.DisplayLayout.Bands[0].Columns["qimoMoney"].Hidden = true;

                ultraGrid3.DisplayLayout.Bands[0].Columns["qichuPrice1"].Hidden = false;
                ultraGrid3.DisplayLayout.Bands[0].Columns["qichuMoney1"].Hidden = false;
                ultraGrid3.DisplayLayout.Bands[0].Columns["chukuPrice1"].Hidden = false;
                ultraGrid3.DisplayLayout.Bands[0].Columns["chukuMoney1"].Hidden = false;
                ultraGrid3.DisplayLayout.Bands[0].Columns["rukuPrice1"].Hidden = false;
                ultraGrid3.DisplayLayout.Bands[0].Columns["rukuMoney1"].Hidden = false;
                ultraGrid3.DisplayLayout.Bands[0].Columns["qimoPrice1"].Hidden = false;
                ultraGrid3.DisplayLayout.Bands[0].Columns["qimoMoney1"].Hidden = false;

                ultraGrid1.DisplayLayout.Bands[0].Columns["qichuPrice"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["qichuMoney"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["chukuPrice"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["chukuMoney"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["rukuPrice"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["rukuMoney"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["qimoPrice"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["qimoMoney"].Hidden = true;

                ultraGrid1.DisplayLayout.Bands[0].Columns["qichuPrice1"].Hidden = false;
                ultraGrid1.DisplayLayout.Bands[0].Columns["qichuMoney1"].Hidden = false;
                ultraGrid1.DisplayLayout.Bands[0].Columns["chukuPrice1"].Hidden = false;
                ultraGrid1.DisplayLayout.Bands[0].Columns["chukuMoney1"].Hidden = false;
                ultraGrid1.DisplayLayout.Bands[0].Columns["rukuPrice1"].Hidden = false;
                ultraGrid1.DisplayLayout.Bands[0].Columns["rukuMoney1"].Hidden = false;
                ultraGrid1.DisplayLayout.Bands[0].Columns["qimoPrice1"].Hidden = false;
                ultraGrid1.DisplayLayout.Bands[0].Columns["qimoMoney1"].Hidden = false;

                ultraGrid1.DisplayLayout.Bands[1].Columns["qichuPrice"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[1].Columns["qichuMoney"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[1].Columns["chukuPrice"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[1].Columns["chukuMoney"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[1].Columns["rukuPrice"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[1].Columns["rukuMoney"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[1].Columns["qimoPrice"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[1].Columns["qimoMoney"].Hidden = true;

                ultraGrid1.DisplayLayout.Bands[1].Columns["qichuPrice1"].Hidden = false;
                ultraGrid1.DisplayLayout.Bands[1].Columns["qichuMoney1"].Hidden = false;
                ultraGrid1.DisplayLayout.Bands[1].Columns["chukuPrice1"].Hidden = false;
                ultraGrid1.DisplayLayout.Bands[1].Columns["chukuMoney1"].Hidden = false;
                ultraGrid1.DisplayLayout.Bands[1].Columns["rukuPrice1"].Hidden = false;
                ultraGrid1.DisplayLayout.Bands[1].Columns["rukuMoney1"].Hidden = false;
                ultraGrid1.DisplayLayout.Bands[1].Columns["qimoPrice1"].Hidden = false;
                ultraGrid1.DisplayLayout.Bands[1].Columns["qimoMoney1"].Hidden = false;
            }
        }

    }
}