MES_Client/TGMES/Core.StlMes.Client.Mcp.Treatment/Report/FrmEntrustBal.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Windows.Forms;
using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.Mcp.Treatment.Entity;
using CoreFS.CA06;
using Infragistics.Win;
using Infragistics.Win.UltraWinGrid;

namespace Core.StlMes.Client.Mcp.Treatment.Report
{
    public partial class FrmEntrustBal : FrmBase
    {
        private string[] items = { };

        public FrmEntrustBal()
        {
            InitializeComponent();
            this.IsLoadUserView = true;
        }


        private string[] plineCodes = new string[] { };

        protected override void OnLoad(EventArgs e)
        {
            base.OnLoad(e);

            DataTable dt = ServerHelper.GetData(
"com.steering.mes.mcp.common.PlanService.getBaseInfo",
new object[] { "7029" },
ob);

            DataRow dr = dt.NewRow();
            dt.Rows.InsertAt(dr, 0);

            ucePayDepartment.DataSource = dt;
            ucePayDepartment.ValueMember = "BASECODE";
            ucePayDepartment.DisplayMember = "BASENAME";

            comm.RefreshAndAutoSizeWithHeader(ultraGrid1);

            dtBathYear.Value = DateTime.Now;

            plineCodes = comm.InitDropPlinePowerW(cboPline, this.ValidDataPurviewIds, ob);
            plineCodes = comm.InitDropPlinePowerW(cboPline1, this.ValidDataPurviewIds, ob);

            items =  this.CustomInfo.ToString2().Split(',');
        }


        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    Query();
                    break;
                case "Update":
                    Update();
                    break;
                case "Settle":
                    Settle();
                    break;
                case "CancelSettle":
                    CancelSettle();
                    break;
                case "Export":
                    Export();
                    break;
                case "Close":
                    this.Close();
                    break;

            }
        }


        private void Update()
        {

            ultraGrid1.UpdateData();
            List<string> updateData=  dataTable1.AsEnumerable().Where(p => (bool) p["CHK"]).Select(p => 
                                                                              p["SUBCONTRACT_NO"].ToString2() + ","  +
                                                                              p["SUBCONTRACT_NO_SEQ"].ToString2() + "," +
                                                                              p["PROJECT_CODE"].ToString2() + "," +
                                                                              p["PROJECT_TYPE"].ToString2() + "," +
                                                                                 p["PAY_DEPARTMENT_CODE"].ToString2() + "," +
                                                                              p["BAL_PRICE"].ToString2() + "," +
                                                                              p["BAL_PRICE_TOTAL"].ToString2() )
                .ToList();

            if (!updateData.Any())
            {
                MessageBox.Show("请勾选需要修改的数据");
                return;
            }

            var ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.common.frmEntrust";
            ccp.MethodName = "doUpdateSettle";
            ccp.ServerParams = new object[]
                    {
                     updateData
                    };
            ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("修改成功！"))
                {
                    Query();
                }
            }
        }

        private void Settle()
        {
            ultraGrid1.UpdateData();
            List<string> updateData = dataTable1.AsEnumerable().Where(p => (bool)p["CHK"]).Select(p =>
                                                                              p["SUBCONTRACT_NO"].ToString2() + "," +
                                                                              p["SUBCONTRACT_NO_SEQ"].ToString2() + "," +
                                                                              p["PROJECT_CODE"].ToString2() + "," +
                                                                              p["PROJECT_TYPE"].ToString2() + "," +
                                                                                 p["PAY_DEPARTMENT_CODE"].ToString2() + "," +
                                                                              p["BAL_PRICE"].ToString2() + "," +
                                                                              p["BAL_PRICE_TOTAL"].ToString2() + "," +
                                                                                p["PRO_NUM"].ToString2() + "," +
                                                                                p["PRO_WT"].ToString2() + "," +
                                                                                p["INCISION_NUM"].ToString2() + "," +
                                                                                p["BUNDLING_NUM"].ToString2() 
                                                                              )
                .ToList();

            if (!updateData.Any())
            {
                MessageBox.Show("请勾选需要结算的数据");
                return;
            }

            var ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.common.frmEntrust";
            ccp.MethodName = "Settle";
            ccp.ServerParams = new object[]
                    {
                     updateData
                    };
            ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("结算成功！"))
                {
                    Query();
                }
            }
        }


        private void CancelSettle()
        {
            ultraGrid2.UpdateData();
            List<string> updateData = dataTable2.AsEnumerable().Select(p =>
                                                                              p["SUBCONTRACT_NO"].ToString2() + "," +
                                                                              p["SUBCONTRACT_NO_SEQ"].ToString2() + "," +
                                                                              p["PROJECT_CODE"].ToString2() + "," +
                                                                              p["PROJECT_TYPE"].ToString2() + "," +
                                                                                 p["PAY_DEPARTMENT_CODE"].ToString2() + "," +
                                                                              p["BAL_PRICE"].ToString2() + "," +
                                                                              p["BAL_PRICE_TOTAL"].ToString2())
                .ToList();

            if (!updateData.Any())
            {
                MessageBox.Show("请勾选需要撤销结算的数据");
                return;
            }

            var ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.common.frmEntrust";
            ccp.MethodName = "CancelSettle";
            ccp.ServerParams = new object[]
                    {
                     updateData
                    };
            ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("撤销结算成功！"))
                {
                    Query();
                }
            }
        }

        private void Export()
        {
            string title = "";


            title += "外委加工明细" + dtBathYear.Value.ToString("yyyyMM");


            GridHelper.ulGridToExcel(tbcMain.SelectedTab.Index==0? ultraGrid1: ultraGrid2, title);
           
        }

        private void Query()
        {
            WaitingForm2 wf = new WaitingForm2("正在查询，请稍候....");
            try
            {
                this.Cursor = Cursors.WaitCursor;

                if (tbcMain.SelectedTab.Index == 0)
                {

                    DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.frmEntrust.doQuerUnBal",
                        new object[]
                        {
                            ucePlineCode.Checked && cboPline.CheckedItems.Count > 0 ? cboPline.CheckedItems.Select(p => p.DataValue.ToString()).ToArray() : plineCodes 
                            ,items
                        }, this.ob);
                    GridHelper.CopyDataToDatatable(ref dt, ref dataTable1, true);
                    comm.RefreshAndAutoSizeWithHeader(ultraGrid1, new string[] { "" });
                }
                else
                {

                    DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.common.frmEntrust.doQuerBal",
                        new object[]
                        {
                            dtBathYear.Value.ToString("yyyyMM"), ucePlineCode1.Checked && cboPline1.CheckedItems.Count > 0 ? cboPline1.CheckedItems.Select(p => p.DataValue.ToString()).ToArray() : plineCodes,
                             items
                        }, this.ob);
                    GridHelper.CopyDataToDatatable(ref dt2, ref dataTable2, true);

                    comm.RefreshAndAutoSizeWithHeader(ultraGrid2, new string[] {""});
                }
            }
            catch (Exception)
            {
                
            }
            finally
            {
                wf.Close();
                this.Cursor = Cursors.Default;
            }

 
        }

        private void ultraGrid1_InitializeRow(object sender, Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)
        {
            bool CanEdit = e.Row.Cells["PROJECT_STATUS"].Value.ToString2() == "00";
             EnableEdit(CanEdit, e.Row.Cells["PROJECT_TYPE"]);
             EnableEdit(CanEdit, e.Row.Cells["PAY_DEPARTMENT_CODE"]);
             EnableEdit(CanEdit, e.Row.Cells["BAL_PRICE"]);
             EnableEdit(CanEdit, e.Row.Cells["BAL_PRICE_TOTAL"]);

        }


        private void EnableEdit(bool CanEdit,UltraGridCell cell)
        {
            if (CanEdit)
            {
                cell.Activation = Activation.AllowEdit;
                cell.Appearance.BackColor = Color.FromArgb(255, 224, 192);
                cell.IgnoreRowColActivation = true;
            }
            else
            {
                cell.Activation = Activation.ActivateOnly;
                cell.Appearance.ResetBackColor();
                cell.IgnoreRowColActivation = true;
            }
        }

        private void ultraGrid1_InitializeLayout(object sender, InitializeLayoutEventArgs e)
        {

        }

        private void tbcMain_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (toolMenu == null) return;

            if (toolMenu.Toolbars[0].Tools.Exists("Update"))
                toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = tbcMain.SelectedTab.Index == 0
                    ? DefaultableBoolean.True
                    : DefaultableBoolean.False;

            if (toolMenu.Toolbars[0].Tools.Exists("Settle"))
                toolMenu.Toolbars[0].Tools["Settle"].InstanceProps.Visible = tbcMain.SelectedTab.Index == 0
                    ? DefaultableBoolean.True
                    : DefaultableBoolean.False;

                   if (toolMenu.Toolbars[0].Tools.Exists("CancelSettle"))
                toolMenu.Toolbars[0].Tools["CancelSettle"].InstanceProps.Visible = tbcMain.SelectedTab.Index == 1
                    ? DefaultableBoolean.True
                    : DefaultableBoolean.False;

        }

        private void FrmEntrustBal_Load(object sender, EventArgs e)
        {
            tbcMain_SelectedTabChanged(null, null);
        }

        private void ultraGrid1_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
        {
            foreach (UltraGridRow uRow in ultraGrid1.Selected.Rows)
            {
                if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow))
                {
                    uRow.Cells["CHK"].Value = true;
                }
            }
        }



  

    }
}