MES_Client/TGMES/Core.StlMes.Client.SaleOrder/ReviewForm/frmOrderSaleAreaUpdate.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 Core.StlMes.Client.SaleOrder;
using System.Collections;
using Core.Mes.Client.Comm.Control;
using Core.StlMes.Client.SaleComm;
using Infragistics.Win.UltraWinGrid;
using Core.Mes.Client.Comm.Tool;
using Core.Mes.Client.Comm.Server;
using Core.StlMes.Client.SaleOrder.ReviewForm;
using Core.StlMes.Client.SaleOrder.Dialog;
using Infragistics.Win;
using Core.Mes.Client.Comm;

namespace Core.StlMes.Client.SaleOrder
{
    public partial class frmOrderSaleAreaUpdate : FrmBase
    {
        public frmOrderSaleAreaUpdate()
        {
            InitializeComponent();
            this.IsLoadUserView = true;
        }

        private void frmOrderEffect_Load(object sender, EventArgs e)
        {
            DateTime Today = DateTime.Now;
            this.date_starte.DateTime = Today.Date.AddMonths(-1);
            this.date_end.DateTime = DateTime.Today;
            this.utDate1.DateTime = Today.Date.AddMonths(-1);
            this.utDate2.DateTime = DateTime.Today;
            getAreaInfo("100101");
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "doQuery":
                    this.Query();
                    break;
                case "queryInfo":
                    queryInfo();
                    break;
                case "doUpdate":
                    this.doUpdate();
                    break;
                case "doClose":
                    this.Close();
                    break;
            }
        }



        public void Query()
        {
            string orderNo = "";      //合同号
            string orderStart = "";
            string orderEnd = "";

            if (ord_no.Checked)
            {
                orderNo = orde_cho.Text.Trim();
            }
            if (che_date.Checked)
            {
                orderStart = date_starte.DateTime.ToString("yyyy-MM-dd") + " 00:00:01";
                orderEnd = date_end.DateTime.ToString("yyyy-MM-dd") + " 23:59:59";
            }
            else
            {
                orderStart = "1000-01-01 00:00:01";
                orderEnd = "9999-12-31 23:59:59";
            }
            String saleOrg = "";
            if (radioXs.Checked)
                saleOrg = "100101";
            if (radioGm.Checked)
                saleOrg = "100102";
            DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderManager.doQueryForUpdate", new Object[] { orderNo, orderStart, orderEnd, saleOrg }, this.ob);
            GridHelper.CopyDataToDatatable(ref dt, ref this.orderHeadDt, true);
            //列自适应
            GridHelper.RefreshAndAutoSizeExceptColumns(gridOrder, new UltraGridColumn[] { });
            GridHelper.SetColumnsActivateAndColor(gridOrder.Rows.Band, "SALE_AREA_NO", "CREATE_NAME","Choose");

        }

        public void queryInfo()
        {
            string orderNo = "";      //合同号
            string orderStart = "";
            string orderEnd = "";

            if (ckOrderNo.Checked)
            {
                orderNo = utOrderNo.Text.Trim();
            }
            if (ckDate.Checked)
            {
                orderStart = utDate1.DateTime.ToString("yyyy-MM-dd") + " 00:00:01";
                orderEnd = utDate2.DateTime.ToString("yyyy-MM-dd") + " 23:59:59";
            }
            else
            {
                orderStart = "1000-01-01 00:00:01";
                orderEnd = "9999-12-31 23:59:59";
            }
            DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderManager.doQueryAreaInfo", new Object[] { orderNo, orderStart, orderEnd }, this.ob);
            GridHelper.CopyDataToDatatable(ref dt, ref this.areaInfo, true);
            //列自适应
            GridHelper.RefreshAndAutoSizeExceptColumns(ulareaInfo, new UltraGridColumn[] { });
            GridHelper.SetAllColumnsActive(ulareaInfo);

        }

        /// <summary>
        /// 修改
        /// </summary>
        private void doUpdate()
        {
            gridOrder.UpdateData();
            if (gridOrder.ActiveRow == null)
                return;
            List<UltraGridRow> listRow = ComHelper.UltraGridGetOtherRows(gridOrder, "Choose");
            if (listRow.Count <= 0)
            {
                MessageUtil.ShowTips("请选择需要保存的记录");
                return;
            }
            if (MessageUtil.ShowQuestion("是否确认调整销售片区？").ToString().ToLower().Equals("no"))
            {
                return;
            }
            
            ArrayList parm = new ArrayList();
            foreach (UltraGridRow row in listRow)
            {
                if (row.Cells["SALE_AREA_NO"].Value.ToString() == row.Cells["SALE_AREA_NO"].Text)
                {
                    MessageUtil.ShowTips("请选择正确的销售片区");
                    return;
                }
                if (row.Cells["CREATE_NAME"].Value.ToString() == row.Cells["CREATE_NAME"].Text)
                {
                    MessageUtil.ShowTips("请选择正确的创建人");
                    return;
                }
                ArrayList list = new ArrayList();
                list.Add(row.Cells["ORD_PK"].Value.ToString());
                list.Add(row.Cells["SALE_AREA_NO"].Value.ToString());
                list.Add(row.Cells["SALE_AREA_NO"].Text);
                list.Add(row.Cells["CREATE_NAME"].Text);
                list.Add(row.Cells["CREATE_NAME"].Value.ToString());
                parm.Add(list);
            }

            CoreClientParam ccp = new CoreClientParam();
            ccp.IfShowErrMsg = false;
            ccp.ServerName = "com.steering.pss.sale.order.CoreOrderManager";
            ccp.MethodName = "updateOrderAreaDesc";
            ccp.ServerParams = new object[] { parm, UserInfo.GetUserName() };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp == null)
                return;
            else
            {
                if (ccp.ReturnCode == -1)
                {
                    MessageUtil.ShowWarning(ccp.ReturnObject.ToString());
                    return;
                }
            }
            MessageBox.Show("修改成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            Query();
        }



        private void che_date_CheckedChanged(object sender, EventArgs e)
        {
            date_starte.Enabled = che_date.Checked;
            date_end.Enabled = che_date.Checked;
        }

        private void ord_no_CheckedChanged(object sender, EventArgs e)
        {
            orde_cho.Enabled = ord_no.Checked;
        }

        private void orde_cho_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (e.KeyChar == 13)
                Query();
        }

        private void getAreaInfo(String saleOrg)
        {
            //销售片区
            DataTable areaDt = ServerHelper.GetData("com.steering.pss.sale.order.CopyCtrlOrderHead.doQuerySalesAreaNoDept", new Object[] { saleOrg }, ob);

            ValueList list = new ValueList();
            Infragistics.Win.ValueListItem[] items = new Infragistics.Win.ValueListItem[areaDt.Rows.Count];
            for (int i = 0; i < areaDt.Rows.Count; i++)
            {
                items[i] = new Infragistics.Win.ValueListItem(areaDt.Rows[i]["SALE_AREA_NO"].ToString(), areaDt.Rows[i]["SALE_AREA_DESC"].ToString());
            }
            list.ValueListItems.AddRange(items);
            gridOrder.DisplayLayout.Bands[0].Columns["SALE_AREA_NO"].ValueList = list;
        }

        private void radioXs_CheckedChanged(object sender, EventArgs e)
        {
            if (radioXs.Checked)
            {
                radioGm.Checked = false;
                getAreaInfo("100101");
                Query();
            }
            
        }

        private void radioGm_CheckedChanged(object sender, EventArgs e)
        {
            if (radioGm.Checked)
            {
                radioXs.Checked = false;
                getAreaInfo("100102");
                Query();
            }
        }

        private void gridOrder_CellChange(object sender, CellEventArgs e)
        {
            gridOrder.UpdateData();
            if (e.Cell.Column.Key.Equals("SALE_AREA_NO"))
            {
                DataTable userDt = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderManager.getUserByDept", new Object[] { e.Cell.Value.ToString() }, ob);

                ValueList list = new ValueList();
                Infragistics.Win.ValueListItem[] items = new Infragistics.Win.ValueListItem[userDt.Rows.Count];
                for (int i = 0; i < userDt.Rows.Count; i++)
                {
                    items[i] = new Infragistics.Win.ValueListItem(userDt.Rows[i]["deptid"].ToString(), userDt.Rows[i]["USERNAME"].ToString());
                }
                list.ValueListItems.AddRange(items);
                gridOrder.DisplayLayout.Bands[0].Columns["CREATE_NAME"].ValueList = list;

            }
            if (e.Cell.Column.Key.Equals("CREATE_NAME"))
            {
                UltraGridRow row = gridOrder.ActiveRow;
                String depId = row.Cells["CREATE_NAME"].Value.ToString();
                row.Cells["DEPID"].Value = depId;
            }
        }


        private void ultraTabControl4_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (toolMenu == null)
                return;
            if (UtControl.SelectedTab == UtControl.Tabs[0])
            {
                if (toolMenu.Toolbars[0].Tools.Exists("doQuery")) { toolMenu.Toolbars[0].Tools["doQuery"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("doUpdate")) { toolMenu.Toolbars[0].Tools["doUpdate"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("queryInfo")) { toolMenu.Toolbars[0].Tools["queryInfo"].InstanceProps.Visible = DefaultableBoolean.False; }

            }
            else
            {
                if (toolMenu.Toolbars[0].Tools.Exists("doQuery")) { toolMenu.Toolbars[0].Tools["doQuery"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("doUpdate")) { toolMenu.Toolbars[0].Tools["doUpdate"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("queryInfo")) { toolMenu.Toolbars[0].Tools["queryInfo"].InstanceProps.Visible = DefaultableBoolean.True; }

            }
        }

        private void frmOrderSaleAreaUpdate_Shown(object sender, EventArgs e)
        {
            if (toolMenu == null)
                return;
            if (UtControl.SelectedTab == UtControl.Tabs[0])
            {
                if (toolMenu.Toolbars[0].Tools.Exists("doQuery")) { toolMenu.Toolbars[0].Tools["doQuery"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("doUpdate")) { toolMenu.Toolbars[0].Tools["doUpdate"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("queryInfo")) { toolMenu.Toolbars[0].Tools["queryInfo"].InstanceProps.Visible = DefaultableBoolean.False; }

            }
            else
            {
                if (toolMenu.Toolbars[0].Tools.Exists("doQuery")) { toolMenu.Toolbars[0].Tools["doQuery"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("doUpdate")) { toolMenu.Toolbars[0].Tools["doUpdate"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("queryInfo")) { toolMenu.Toolbars[0].Tools["queryInfo"].InstanceProps.Visible = DefaultableBoolean.True; }

            }
        }

        private void ckOrderNo_CheckedChanged(object sender, EventArgs e)
        {
            utOrderNo.Enabled = ckOrderNo.Checked;
        }

        private void ckDate_CheckedChanged(object sender, EventArgs e)
        {
            utDate1.Enabled = ckDate.Checked;
            utDate2.Enabled = ckDate.Checked;
        }

    }
}