MES_Client/TGMES/Core.StlMes.Client.BuyBillet/FrmIndvProd.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 Infragistics.Win.UltraWinGrid;
using CoreFS.CA06;
using Infragistics.Win;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Tool;
namespace Core.StlMes.Client.BuyBillet
{
    public partial class FrmIndvProd : FrmBase
    {
        private DataTable dt = new DataTable();
        public FrmIndvProd()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {

           
           Query();
          ultraGrid1_bind();
        }
     
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            base.ToolBar_Click(sender, ToolbarKey);
            switch (ToolbarKey)
            {
             
                case "doQuery":
                    Query();
                   break;
                
            }
        }
        private void Query()
        {
            
          
           // GridHelper.CopyDataToDatatable(ref dtqry, ref dt, true);
            //SetStaticsInfo();
            ultraGrid1_bind();
           // CommonMethod.SetGridSumArea(this.ultraGrid1);
        }
        private void ultraGrid1_bind()
        {
             DataTable dt = new DataTable();
             DataTable dtclone = new DataTable();
             dtclone = dataTable1.Clone();
            DateTime dtime = ultraDateTimeEditor1.DateTime;
            //本月第一天时间    
            DateTime dt_First = dtime.AddDays(-(dtime.Day) + 1);
           
            //将本月月数+1  
            DateTime dtime2 = dtime.AddMonths(1);
            //本月最后一天时间  
            DateTime dt_Last = dtime2.AddDays(-(dtime.Day));

            string year1 = dt_First.ToString("yyyy-MM-dd hh:mm:ss");


            string year2 = dt_Last.ToString("yyyy-MM-dd")+" 23:59:59";

            dt = ServerHelper.GetData("com.steering.pss.buybillet.Buybillet.get_FrmIndvProd_All", new object[] { year1, year2 }, this.ob);
            // dt = ServerHelper.GetData("com.steering.pss.indvprod.IndvProd.get_FrmIndvProd_All", new object[] { year1, year2 }, this.ob);
            //生成列

            GridHelper.CopyDataToDatatable(ref dt, ref dtclone, true);
            foreach (DataRow drid in dtclone.Rows)
        {
            if (drid["换工具"].ToString() == "")
            {
                drid["换工具"] = "0";
            }
            if (drid["应用代金券"].ToString() == "")
            {
                drid["应用代金券"] = "0";
            }
            if (drid["实用代金券"].ToString() == "")
            {
                drid["实用代金券"] = "0";
            }
            drid["产量合计"] = (Int32.Parse(drid["产量"].ToString()) + Int32.Parse(drid["换工具"].ToString())).ToString();
            drid["代金券盈亏"] = (Int32.Parse(drid["应用代金券"].ToString()) - Int32.Parse(drid["实用代金券"].ToString())).ToString();


        }

            GridHelper.CopyDataToDatatable(ref dtclone, ref dataTable1, true);
         
            



           //DataTable dt = new DataTable();
           // string year1 = dateTimePicker1.Value.ToString("yyyy-MM-dd hh:mm:ss");
           // string year2 = dateTimePicker2.Value.ToString("yyyy-MM-dd hh:mm:ss");
           // dt = ServerHelper.GetData("com.steering.pss.indvprod.IndvProd.get_FrmIndvProd_All", new object[] { year1, year2 }, this.ob);
           // dt = ServerHelper.GetData("com.steering.pss.indvprod.IndvProd.get_FrmIndvProd_All", new object[] { year1, year2 }, this.ob);
           //生成列
           // DataColumn colum;
          // string[] myArray = new string[5] { "应用代金券", "换工具", "实用代金券", "产量合计", "代金券盈亏" };
          // for (int i = 0; i < myArray.Length; i++)
          // {
            //  colum = new DataColumn();
           //     colum.DataType = System.Type.GetType("System.String");
           ///    colum.ColumnName = myArray[i].ToString();
           //    dt.Columns.Add(colum);
         //  }
//            //生成行
//            DataRow dr;
//            dr=dt1.NewRow();
//            dr["班次"] = "甲班";
//            dr["机床"] = "车丝";
//            dr["姓名"] = "陈晨";
//            dr["产量"] = "1970";
//            dr["应用代金券"] = "7313";
//            dr["换工具"] = "75";
//            dr["实用代金券"] = "15640";
//            dr["产量合计"] = "";
//            dr["代金券盈亏"] = "";
//            dr["班产"] = "";
//            dr["车丝机"] = "25#车丝机";
//            dt1.Rows.Add(dr);

//            dr = dt1.NewRow();
//            dr["班次"] = "甲班";
//            dr["机床"] = "磷化";
//            dr["姓名"] = "李国旺";
//            dr["产量"] = "28534";
//            dr["应用代金券"] = "16877";
//            dr["换工具"] = "285";
//            dr["实用代金券"] = "60890";
//            dr["产量合计"] = "";
//            dr["代金券盈亏"] = "";
//            dr["班产"] = "";
//            dr["车丝机"] = "";
//            dt1.Rows.Add(dr);

//            dr = dt1.NewRow();
//            dr["班次"] = "甲班";
//            dr["机床"] = "切管";
//            dr["姓名"] = "丁军";
//            dr["产量"] = "3988";
//            dr["应用代金券"] = "3047";
//            dr["换工具"] = "900";
//            dr["实用代金券"] = "6300";
//            dr["产量合计"] = "";
//            dr["代金券盈亏"] = "";
//            dr["班产"] = "";
//            dr["车丝机"] = "";
//            dt1.Rows.Add(dr);

//            dr = dt1.NewRow();
//            dr["班次"] = "乙班";
//            dr["机床"] = "车丝";
//            dr["姓名"] = "柴恭平";
//            dr["产量"] = "2778";
//            dr["应用代金券"] = "7191";
//            dr["换工具"] = "90";
//            dr["实用代金券"] = "18990";
//            dr["产量合计"] = "";
//            dr["代金券盈亏"] = "";
//            dr["班产"] = "";
//            dr["车丝机"] = "19#车丝机/20#车丝机/21#车丝机/22#车丝机/32#车丝机";
//            dt1.Rows.Add(dr);

//            dr = dt1.NewRow();
//            dr["班次"] = "乙班";
//            dr["机床"] = "磷化";
//            dr["姓名"] = "陈治";
//            dr["产量"] = "32169";
//            dr["应用代金券"] = "18012";
//            dr["换工具"] = "2038";
//            dr["实用代金券"] = "37844";
//            dr["产量合计"] = "";
//            dr["代金券盈亏"] = "";
//            dr["班产"] = "";
//            dr["车丝机"] = "";
//            dt1.Rows.Add(dr);

//            dr = dt1.NewRow();
//            dr["班次"] = "乙班";
//            dr["机床"] = "切管";
//            dr["姓名"] = "黄凤伟";
//            dr["产量"] = "4710";
//            dr["应用代金券"] = "3381";
//            dr["换工具"] = "";
//            dr["实用代金券"] = "6800";
//            dr["产量合计"] = "";
//            dr["代金券盈亏"] = "";
//            dr["班产"] = "";
//            dr["车丝机"] = "";
//            dt1.Rows.Add(dr);

//            dr = dt1.NewRow();
//            dr["班次"] = "丙班";
//            dr["机床"] = "车丝";
//            dr["姓名"] = "崔伟";
//            dr["产量"] = "2048";
//            dr["应用代金券"] = "4332";
//            dr["换工具"] = "230";
//            dr["实用代金券"] = "10730";
//            dr["产量合计"] = "";
//            dr["代金券盈亏"] = "";
//            dr["班产"] = "";
//            dr["车丝机"] = "22#车丝机/25#车丝机/29#车丝机/31#车丝机";
//            dt1.Rows.Add(dr);

//            dr = dt1.NewRow();
//            dr["班次"] = "丙班";
//            dr["机床"] = "磷化";
//            dr["姓名"] = "邵奎";
//            dr["产量"] = "37249";
//            dr["应用代金券"] = "20663";
//            dr["换工具"] = "3270";
//            dr["实用代金券"] = "76316";
//            dr["产量合计"] = "";
//            dr["代金券盈亏"] = "";
//            dr["班产"] = "";
//            dr["车丝机"] = "";
//            dt1.Rows.Add(dr);

//            dr = dt1.NewRow();
//            dr["班次"] = "丙班";
//            dr["机床"] = "切管";
//            dr["姓名"] = "何同艺";
//            dr["产量"] = "3106";
//            dr["应用代金券"] = "1840";
//            dr["换工具"] = "";
//            dr["实用代金券"] = "3030";
//            dr["产量合计"] = "";
//            dr["代金券盈亏"] = "";
//            dr["班产"] = "";
//            dr["车丝机"] = "";
//            dt1.Rows.Add(dr);

//            dr = dt1.NewRow();
//            dr["班次"] = "丁班";
//            dr["机床"] = "车丝";
//            dr["姓名"] = "崔凯";
//            dr["产量"] = "489";
//            dr["应用代金券"] = "1213";
//            dr["换工具"] = "100";
//            dr["实用代金券"] = "12480";
//            dr["产量合计"] = "";
//            dr["代金券盈亏"] = "";
//            dr["班产"] = "";
//            dr["车丝机"] = "19#车丝机/27#车丝机";
//            dt1.Rows.Add(dr);

//            dr = dt1.NewRow();
//            dr["班次"] = "丁班";
//            dr["机床"] = "磷化";
//            dr["姓名"] = "杨成文";
//            dr["产量"] = "28694";
//            dr["应用代金券"] = "16701";
//            dr["换工具"] = "1500";
//            dr["实用代金券"] = "54019";
//            dr["产量合计"] = "";
//            dr["代金券盈亏"] = "";
//            dr["班产"] = "";
//            dr["车丝机"] = "";
//            dt1.Rows.Add(dr);

//            dr = dt1.NewRow();
//            dr["班次"] = "丁班";
//            dr["机床"] = "切管";
//            dr["姓名"] = "孟令保";
//            dr["产量"] = "5050";
//            dr["应用代金券"] = "3640";
//            dr["换工具"] = "300";
//            dr["实用代金券"] = "";
//            dr["产量合计"] = "";
//            dr["代金券盈亏"] = "";
//            dr["班产"] = "";
//            dr["车丝机"] = "";
//            dt1.Rows.Add(dr);
//            dt1.Columns.Add("id", typeof(string));
            
//             foreach( DataRow drid in dt1.Rows)         
//{

   
//    switch (drid["班次"].ToString())
//    {
//        case "甲班":
//            drid["id"] = "1";
//            break;
//        case "乙班":
//            drid["id"] = "2";
//            break;
//        case "丙班":
//            drid["id"] = "3";
//            break;
//        case "丁班":
//            drid["id"] = "4";
//            break;
//    }

//}
             //求代金券盈亏数  //求产量合计
           
          


 
            //this.ultraGrid1.DataSource = dt;
           // RefreshAndAutoSize(ultraGrid1);
               ForbidSort(ultraGrid1);
            //this.ultraGrid1.DisplayLayout.Bands[0].HeaderVisible = false;
            
            this.ultraGrid1.DisplayLayout.Bands[0].Columns[0].MergedCellEvaluationType =

MergedCellEvaluationType.MergeSameText;
          // this.ultraGrid1.DisplayLayout.Bands[0].Columns["班次"].SortIndicator = SortIndicator.Ascending;
           // this.ultraGrid1.DisplayLayout.Bands[0].Columns["id"].SortIndicator = SortIndicator.Ascending;
        }
        //刷新调整列宽度方法
        public static void RefreshAndAutoSize(Infragistics.Win.UltraWinGrid.UltraGrid ultraGrid)
        {
            try
            {
                ultraGrid.DataBind();

                foreach (Infragistics.Win.UltraWinGrid.UltraGridBand band in ultraGrid.DisplayLayout.Bands)
                {
                    foreach (Infragistics.Win.UltraWinGrid.UltraGridColumn column in band.Columns)
                    {
                        column.PerformAutoResize(Infragistics.Win.UltraWinGrid.PerformAutoSizeType.AllRowsInBand);
                    }
                }

                ultraGrid.Refresh();

            }
            catch { }
        }
        /// <summary>
        /// 禁止排序
        /// </summary>
        /// <param name="ugr"></param>
        public void ForbidSort(UltraGrid ugr)
        {
            foreach (UltraGridColumn ugc in ugr.DisplayLayout.Bands[0].Columns)
            {
               
                ugc.SortIndicator = SortIndicator.Disabled;
                ugc.AllowRowFiltering = DefaultableBoolean.False;
            }
        }

        //private void ultraButton1_Click(object sender, EventArgs e)
        //{
        //    Query();
        //}

       // private void button1_Click(object sender, EventArgs e)
        //{
        //    Query();
       // }

       
       /// public void SubCoupon(int i, int j)
       /// {
            
       /// }
    }
}