MES_Client/TGMES/Core.StlMes.Client.Plan.Order/FrmOrderCraftInfo.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 com.steering.pss.plan.order.model;
using Core.Mes.Client.Comm.Tool;
using Core.Mes.Client.Comm.Server;
using System.Collections;
using Infragistics.Win.UltraWinGrid;
using Infragistics.Win.UltraWinEditors;
using Core.StlMes.Client.SaleComm;
using Core.Mes.Client.Comm;

namespace Core.StlMes.Client.Plan.Order
{
    public partial class FrmOrderCraftInfo : FrmBase
    {
        UltraComboEditor uceA = new UltraComboEditor();
        UltraComboEditor uceB = new UltraComboEditor();

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

        /// <summary>
        /// 重写基类toolBar方法
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    DoQuery();
                    break;
                case "Export":
                    DoExport();
                    break;
                case "Import":
                    DoImport();
                    break;
                //case "Audit":
                //    DoAudit();
                //    break;
                //case "Enable":
                //    DoEnable();
                //    break;
                case "Delete":
                    doDelete();
                    break;
                case "Refresh":
                    DoRefresh();
                    break;
                case "Close":
                    this.Close();
                    break;

            }
        }

        private void frmOrderInfomation_Load(object sender, EventArgs e)
        {
            EntityHelper.ShowGridCaption<PlnOrdCraftFileEntity>(ultraGridCraftfile.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<SlmOrderLineNextEntity>(ultraGridOrderLine.DisplayLayout.Bands[0]);
            InitDate();
            InitCombo();
        }

        /// <summary>
        /// 初始时间
        /// </summary>
        private void InitDate()
        {
            ultraCheckEditorOrderNo.Checked = true;
            ultraDateTimeEditorBegin.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")).AddMonths(-1);
            ultraDateTimeEditorEnd.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")).AddDays(1).AddSeconds(-1);
            DoRefresh();
        }

        /// <summary>
        /// 刷新
        /// </summary>
        private void DoRefresh()
        {
            if (ultraDateTimeEditorBegin.Value == null || ultraDateTimeEditorEnd.Value == null)
            {
                MessageUtil.ShowWarning("请选择正确的时间");
                return;
            }
            ultraComboEditorOrderNo.DataSource = null;
            String beginTime = ultraDateTimeEditorBegin.DateTime.ToString("yyyy-MM-dd");
            String endTime = ultraDateTimeEditorEnd.DateTime.ToString("yyyy-MM-dd");
            DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CoreOrderCraftInfo.getCraftfileByTime",
                new Object[] { beginTime, endTime }, this.ob);
            ultraComboEditorOrderNo.DataSource = dt;
            //InitEdit();
        }

        private void InitCombo()
        {
            this.Controls.Add(uceA);
            this.Controls.Add(uceB);
            uceA.Visible = false;
            uceB.Visible = false;
            DataTable dtA = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderColligateInfomation.getBaseInfo2002", new object[] { }, this.ob);
            //DataTable dtB = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderColligateInfomation.getBaseInfo2003", new object[] { }, this.ob);
            uceA.DataSource = dtA;
            uceA.DisplayMember = "BASENAME";
            uceA.ValueMember = "BASECODE";
            //uceB.DataSource = dtB;
            //uceB.DisplayMember = "BASENAME";
            //uceB.ValueMember = "BASECODE";

            ultraGridCraftfile.DisplayLayout.Bands[0].Columns["CraftFileTypeCode"].EditorComponent = uceA;
            ultraGridCraftfile.DisplayLayout.Bands[0].Columns["CraftFileTypeCode"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            //ultraGridCraftfile.DisplayLayout.Bands[0].Columns["CraftFileFlagCode"].EditorComponent = uceB;
            //ultraGridCraftfile.DisplayLayout.Bands[0].Columns["CraftFileFlagCode"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            ultraGridCraftfile.DisplayLayout.Bands[0].Columns["FilePath"].EditorComponent = askItemImg;
        }

        /// <summary>
        /// 编辑区初始化
        /// </summary>
        private void InitEdit()
        {
            DataTable dtProduct = ServerHelper.GetData("com.steering.pss.plan.order.CoreOrderCraftInfo.getBaseProduct", new object[] { }, this.ob);
            DataTable dtSteel = ServerHelper.GetData("com.steering.pss.plan.order.CoreOrderCraftInfo.getBaseSteel", new object[] { }, this.ob);
            DataTable dtBaseModel = ServerHelper.GetData("com.steering.pss.plan.order.CoreOrderCraftInfo.getBaseModel", new object[] { }, this.ob);
            DataTable dtBjType = ServerHelper.GetData("com.steering.pss.plan.order.CoreOrderCraftInfo.getBjProcessC", new object[] { }, this.ob);
            DataTable dtA = ServerHelper.GetData("com.steering.pss.plan.order.CoreOrderCraftInfo.getBaseInfo2002", new object[] { }, this.ob);
            DataTable dtB = ServerHelper.GetData("com.steering.pss.plan.order.CoreOrderCraftInfo.getBaseInfo2003", new object[] { }, this.ob);

            ultraComboCRAFT_FILE_TYPE.DataSource = dtA;
            ultraComboCRAFT_FILE_TYPE.DisplayMember = "BASENAME";
            ultraComboCRAFT_FILE_TYPE.ValueMember = "BASECODE";

            ultraComboCRAFT_FILE_FLAG.DataSource = dtB;
            ultraComboCRAFT_FILE_FLAG.DisplayMember = "BASENAME";
            ultraComboCRAFT_FILE_FLAG.ValueMember = "BASECODE";

            ultraComboSTEELCODE.DataSource = dtSteel;
            ultraComboSTEELCODE.DisplayMember = "STEELNAME";
            ultraComboSTEELCODE.ValueMember = "STEELCODE";

            ultraComboMODEL_CODE.DataSource = dtBaseModel;
            ultraComboMODEL_CODE.DisplayMember = "MODEL_DESC";
            ultraComboMODEL_CODE.ValueMember = "MODEL_CODE";

            ultraComboPRODUC_JX.DataSource = dtProduct;
            ultraComboPRODUC_JX.DisplayMember = "PRODUC_JX";
            ultraComboPRODUC_JX.ValueMember = "PRODUCCODE";

            ultraComboBJ_TYPE.DataSource = dtBjType;
            ultraComboBJ_TYPE.DisplayMember = "PROCESS_DESC_C";
            ultraComboBJ_TYPE.ValueMember = "PROCESS_CDOE_C";
        }

        private void DoQuery()
        {
            ArrayList param = new ArrayList();
            if (ultraCheckEditorOrderNo.Checked)
            {
                param.Add(ultraComboEditorOrderNo.Text.Trim());
            }
            else
            {
                param.Add("");
            }

            if (this.ultraCheckOrderLine.Checked)
            {
                param.Add(this.ultraTextOrderLine.Text.Trim());
            }
            else
            {
                param.Add("");
            }

            if (ultraDateTimeEditorBegin.Value == null || ultraDateTimeEditorEnd.Value == null)
            {
                MessageUtil.ShowWarning("请选择正确的时间");
                return;
            }
            param.Add(ultraDateTimeEditorBegin.DateTime.ToString("yyyy-MM-dd"));
            param.Add(ultraDateTimeEditorEnd.DateTime.ToString("yyyy-MM-dd"));
            List<PlnOrdCraftFileEntity> listSorce = EntityHelper.GetData<PlnOrdCraftFileEntity>(
                "com.steering.pss.plan.order.CoreOrderCraftInfo.getCraftfileInfo", new object[] { param }, this.ob);
            this.slmPlnOrdCraftFileEntityBindingSource.DataSource = listSorce;

            SetColumnReadOnly();
            PlanComm.setGridActivation(ultraGridCraftfile.DisplayLayout.Bands[0], "CHC", "CraftFileTypeCode", "FilePath");

            List<SlmOrderLineNextEntity> listLineSorce = EntityHelper.GetData<SlmOrderLineNextEntity>(
                "com.steering.pss.plan.order.CoreOrderCraftInfo.getOrderLineInfo", new object[] { param }, this.ob);
            this.slmOrderLineNextEntityBindingSource.DataSource = listLineSorce;
            PlanComm.setGridActivation(ultraGridOrderLine.DisplayLayout.Bands[0]);
        }

        /// <summary>
        /// 导入
        /// </summary>
        private void DoImport()
        {
            try
            {
                OpenFileDialog dialog = new OpenFileDialog();
                if (dialog.ShowDialog() == DialogResult.OK)
                {
                    FrmOrderCraftImport import = new FrmOrderCraftImport(this.ob);
                    import.ModelPatch = dialog.FileName;
                    import.ShowDialog();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            DoQuery();
        }

        /// <summary>
        /// 审核
        /// </summary>
        private void DoAudit()
        {
            ultraGridCraftfile.UpdateData();
            ArrayList list = new ArrayList();
            IQueryable<UltraGridRow> checkRows = ultraGridCraftfile.Rows.AsQueryable().Where("CHC = 'True'");
            if (checkRows.Count() == 0)
            {
                MessageUtil.ShowTips("请选择要审核的工艺文件！");
                return;
            }
            foreach (UltraGridRow uRow in checkRows)
            {
                List<PlnOrdCraftFileEntity> listCraftfile = EntityHelper.GetData<PlnOrdCraftFileEntity>(
                "com.steering.pss.plan.order.CoreOrderCraftInfo.getCraftByOrderno",
                new object[] { uRow.GetCellValue("OrderNo"), uRow.GetCellValue("OrderSeq") }, this.ob);
                if (listCraftfile[0].CraftFileFlagCode.Equals("200301"))
                {
                    ArrayList param = new ArrayList();
                    param.Add("200302");
                    param.Add("审核");
                    param.Add(uRow.GetCellValue("CraftFileTypeCode"));
                    param.Add(uRow.Cells["CraftFileTypeCode"].Text.Trim());
                    param.Add(uRow.Cells["CraftFilePath"].Value.ToString());
                    param.Add(listCraftfile[0].OrderNo);
                    param.Add(listCraftfile[0].OrderSeq);
                    list.Add(param);
                }
                else
                {
                    MessageUtil.ShowTips("工艺文件" + listCraftfile[0].CraftFileNo + "已经审核过了");
                    return;
                }
            }
            int succed = ServerHelper.SetData("com.steering.pss.plan.order.CoreOrderCraftInfo.setCraftFileFlag",
                new object[] { list }, this.ob);
            if (succed > 0)
            {
                MessageUtil.ShowTips("审核成功！");
            }
            else
            {
                MessageUtil.ShowTips("审核失败！");
            }
            DoQuery();
        }

        /// <summary>
        /// 启用
        /// </summary>
        private void DoEnable()
        {
            ultraGridCraftfile.UpdateData();
            ArrayList list = new ArrayList();
            IQueryable<UltraGridRow> checkRows = ultraGridCraftfile.Rows.AsQueryable().Where("CHC = 'True'");
            if (checkRows.Count() == 0)
            {
                MessageUtil.ShowTips("请选择要启用的工艺文件！");
                return;
            }
            foreach (UltraGridRow uRow in checkRows)
            {
                List<PlnOrdCraftFileEntity> listCraftfile = EntityHelper.GetData<PlnOrdCraftFileEntity>(
                "com.steering.pss.plan.order.CoreOrderCraftInfo.getCraftByOrderno",
                new object[] { uRow.GetCellValue("OrderNo"), uRow.GetCellValue("OrderSeq") }, this.ob);
                if (listCraftfile[0].CraftFileFlagCode.Equals("200302"))
                {
                    PlnOrdCraftFileEntity entity = new PlnOrdCraftFileEntity();
                    entity.CraftFileTypeCode = uRow.GetCellValue("CraftFileTypeCode");
                    entity.CraftFileTypeNm = uRow.Cells["CraftFileTypeCode"].Text.Trim();
                    entity.CraftFilePath = uRow.Cells["CraftFilePath"].Value.ToString();
                    entity.CraftFileFlagCode = "200303";
                    entity.CraftFileFlagNm = "启用";
                    entity.CraftFileNo = listCraftfile[0].CraftFileNo.ToString();
                    entity.CraftFileMan = listCraftfile[0].CraftFileMan.ToString();
                    entity.OrderNo = listCraftfile[0].OrderNo.ToString();
                    entity.OrderSeq = listCraftfile[0].OrderSeq.ToString();
                    list.Add(entity);
                }
                else if (listCraftfile[0].CraftFileFlagCode.ToString().CompareTo("200302") > 0)
                {
                    MessageUtil.ShowTips("工艺文件" + listCraftfile[0].CraftFileNo + "已经启用过了。");
                    return;
                }
                else
                {
                    MessageUtil.ShowTips("工艺文件" + listCraftfile[0].CraftFileNo + "未审核。");
                    return;
                }
            }

            int succed = ServerHelper.SetData("com.steering.pss.plan.order.CoreOrderCraftInfo.setCraftFileEnable",
                new object[] { list }, this.ob);
            if (succed > 0)
            {
                MessageUtil.ShowTips("启用成功！");
            }
            else
            {
                MessageUtil.ShowTips("启用失败！");
            }
            DoQuery();
        }

        /// <summary>
        /// 计划下发导出
        /// </summary>
        private void DoExport()
        {
            string url = "http://172.16.2.130:8085/WebReport/ReportServer?reportlet=RepPlnSaleOrder.cpt";
            //string url = "http://localhost:8075/WebReport/ReportServer?reportlet=RepPlnSaleOrder.cpt";
            FrmOutExcel outPut = new FrmOutExcel(url);
            outPut.ShowDialog();
        }

        private void DoSave()
        {
            UltraGridRow ugr = ultraGridCraftfile.ActiveRow;
            if (ugr == null)
            {
                MessageUtil.ShowWarning("请选择工艺信息");
                return;
            }

            ArrayList list = new ArrayList();
            String orderSeq = "";
            if (ultraTextCRAFT_FILE_NO.Value == null || ultraTextCRAFT_FILE_NO.Value.ToString().Equals(""))
            {
                MessageUtil.ShowTips("合同行工艺文件号不能为空！");
                return;
            }

            PlnOrdCraftFileEntity fileEntity = new PlnOrdCraftFileEntity();
            fileEntity.CraftFileNo = ultraTextCRAFT_FILE_NO.Value.ToString();
            fileEntity.CraftFileMan = ultraTextCRAFT_FILE_MAN.Text.Trim();
            fileEntity.ProducJx = ultraComboPRODUC_JX.Text.Trim();
            fileEntity.StdLgNo = ultraTextSTD_LG_NO.Text.Trim();
            fileEntity.StdZgNo = ultraTextSTD_ZG_NO.Text.Trim();
            fileEntity.StdGjgNo = ultraTextSTD_GJG_NO.Text.Trim();

            if (ultraComboSTEELCODE.Value != null)
            {
                fileEntity.Steelcode = ultraComboSTEELCODE.Value.ToString();
                fileEntity.Steelname = ultraComboSTEELCODE.Text.Trim();
            }

            fileEntity.Gradecode = ultraTextGRADECODE.Text.Trim();
            fileEntity.Outdiameter = ultraNumericOUTDIAMETER.Value.ToString();
            fileEntity.Wallthick = ultraNumericWALLTHICK.Value.ToString();

            if (ultraComboMODEL_CODE.Value != null)
            {
                fileEntity.ModelCode = ultraComboMODEL_CODE.Value.ToString();
                fileEntity.ModelDesc = ultraComboMODEL_CODE.Text.Trim();
            }
            fileEntity.HeightNkMin = ultraNumericHEIGHT_NK_MIN.Value.ToString();
            fileEntity.HeightNkMax = ultraNumericHEIGHT_NK_MAX.Value.ToString();
            fileEntity.LengthExtent = ultraTextLENGTH.Text.Trim();
            fileEntity.BjType = ultraComboBJ_TYPE.Text.Trim();

            if (Convert.ToDouble(ultraNumericOUTDIAMETER.Value) != 0)
            {
                double sdivd = Math.Round(Convert.ToDouble(ultraNumericWALLTHICK.Value)
                    / Convert.ToDouble(ultraNumericOUTDIAMETER.Value), 9);
                fileEntity.SDivD = sdivd.ToString();
            }
            else
            {
                fileEntity.SDivD = "0";
            }

            fileEntity.CraftPath = ultraTextCRAFT_PATH.Text.Trim();
            fileEntity.RclInfo = ultraTextRCL_INFO.Text.Trim();
            fileEntity.PaydownDpt = ultraTextPAYDOWN_DPT.Text.Trim();
            fileEntity.MonitorInfo = ultraTextMONITOR_INFO.Text.Trim();
            fileEntity.HoleModalInfo = ultraTextHOLE_MODAL_INFO.Text.Trim();

            if (ultraComboCRAFT_FILE_FLAG.Value != null)
            {
                fileEntity.CraftFileFlagCode = ultraComboCRAFT_FILE_FLAG.Value.ToString();
                fileEntity.CraftFileFlagNm = ultraComboCRAFT_FILE_FLAG.Text.Trim();
            }
            fileEntity.CraftFilePath = ultraTextCRAFT_FILE_PATH.Text.Trim();

            if (ultraComboCRAFT_FILE_TYPE.Value != null)
            {
                fileEntity.CraftFileTypeCode = ultraComboCRAFT_FILE_TYPE.Value.ToString();
                fileEntity.CraftFileTypeNm = ultraComboCRAFT_FILE_TYPE.Text.Trim();
            }
            fileEntity.OrderSeq = ugr.Cells["OrderSeq"].Value.ToString().Trim();
            fileEntity.OrderNo = ugr.Cells["OrderNo"].Value.ToString();
            fileEntity.CreateName = this.UserInfo.GetUserName();
            list.Add(fileEntity);
            orderSeq = fileEntity.OrderSeq.ToString();

            if (MessageUtil.ShowYesNoAndQuestion("是否保存?") == DialogResult.No)
            {
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plan.order.CoreOrderCraftInfo";
            ccp.MethodName = "saveCraftInfo";
            ccp.ServerParams = new object[] { list };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                DoQuery();
                foreach (UltraGridRow ugrline in ultraGridCraftfile.Rows)
                {
                    if (ugrline.GetCellValue("orderNo").ToString().Equals(fileEntity.OrderNo)
                        && ugrline.GetCellValue("orderSeq").ToString().Equals(fileEntity.OrderSeq))
                    {
                        ugrline.Activate();
                    }
                }
            }
        }

        /// <summary>
        /// 删除
        /// </summary>
        private void doDelete()
        {
            try
            {
                ArrayList list = new ArrayList();
                bool isChecked = false;
                foreach (UltraGridRow ugr in ultraGridCraftfile.Rows)
                {
                    if (Convert.ToBoolean(ugr.Cells["CHC"].Text))
                    {
                        ArrayList param = new ArrayList();
                        param.Add(ugr.GetCellValue("orderNo"));
                        param.Add(ugr.GetCellValue("OrderSeq"));
                        list.Add(param);
                        isChecked = true;
                    }
                }

                if (!isChecked)
                {
                    MessageUtil.ShowWarning("请选择工艺文件行！");
                    return;
                }

                if (MessageUtil.ShowYesNoAndQuestion("是否删除所选合同行的工艺文件?") == DialogResult.No)
                {
                    return;
                }
                int succed = ServerHelper.SetData("com.steering.pss.plan.order.CoreOrderCraftInfo.deleteCraftInfo",
                    new object[] { list }, this.ob);
                if (succed > 0)
                {
                    MessageUtil.ShowTips("删除成功！");
                }
                else
                {
                    MessageUtil.ShowTips("删除失败！");
                }
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            DoQuery();
        }

        /// <summary>
        /// 工艺文件信息查询
        /// </summary>
        private void QueryCraftFile(string orderNo, string orderSeq)
        {
            List<PlnOrdCraftFileEntity> listCraftfile = EntityHelper.GetData<PlnOrdCraftFileEntity>(
                "com.steering.pss.plan.order.CoreOrderCraftInfo.getCraftByOrderno", 
                new object[] { orderNo, orderSeq }, this.ob);
            if (listCraftfile != null && listCraftfile.Count > 0)
            {
                ultraTextCRAFT_FILE_NO.Value = listCraftfile[0].CraftFileNo;
                ultraTextCRAFT_FILE_MAN.Value = listCraftfile[0].CraftFileMan;
                ultraComboPRODUC_JX.Text = listCraftfile[0].ProducJx.ToString();
                ultraTextSTD_LG_NO.Value = listCraftfile[0].StdLgNo.ToString();
                ultraTextSTD_ZG_NO.Value = listCraftfile[0].StdZgNo;
                ultraTextSTD_GJG_NO.Value = listCraftfile[0].StdGjgNo;
                ultraComboSTEELCODE.Text = listCraftfile[0].Steelname.ToString();
                ultraTextGRADECODE.Value = listCraftfile[0].Gradecode.ToString();
                ultraNumericOUTDIAMETER.Value = listCraftfile[0].Outdiameter;
                ultraNumericWALLTHICK.Value = listCraftfile[0].Wallthick;
                ultraComboMODEL_CODE.Text = listCraftfile[0].ModelDesc.ToString();
                ultraNumericHEIGHT_NK_MIN.Value = listCraftfile[0].HeightNkMin;
                ultraNumericHEIGHT_NK_MAX.Value = listCraftfile[0].HeightNkMax;
                ultraTextLENGTH.Value = listCraftfile[0].LengthExtent;
                ultraComboBJ_TYPE.Text = listCraftfile[0].BjType.ToString();
                ultraTextCRAFT_PATH.Value = listCraftfile[0].CraftPath;
                ultraTextRCL_INFO.Value = listCraftfile[0].RclInfo;
                ultraTextPAYDOWN_DPT.Value = listCraftfile[0].PaydownDpt;
                ultraTextMONITOR_INFO.Value = listCraftfile[0].MonitorInfo;
                ultraTextHOLE_MODAL_INFO.Value = listCraftfile[0].HoleModalInfo;
                ultraComboCRAFT_FILE_TYPE.Text = listCraftfile[0].CraftFileTypeNm.ToString();
                ultraComboCRAFT_FILE_FLAG.Text = listCraftfile[0].CraftFileFlagNm.ToString();
                ultraTextCRAFT_FILE_PATH.Value = listCraftfile[0].CraftFilePath;
            }
            else
            {
                ultraTextCRAFT_FILE_NO.Value = "";
                ultraTextCRAFT_FILE_MAN.Value = "";
                ultraComboPRODUC_JX.Text = "";
                ultraTextSTD_LG_NO.Value = "";
                ultraTextSTD_ZG_NO.Value = "";
                ultraTextSTD_GJG_NO.Value = "";
                ultraComboSTEELCODE.Value = "";
                ultraTextGRADECODE.Value = "";
                ultraNumericOUTDIAMETER.Value = 0;
                ultraNumericWALLTHICK.Value = 0;
                ultraComboMODEL_CODE.Value = "";
                ultraNumericHEIGHT_NK_MIN.Value = 0;
                ultraNumericHEIGHT_NK_MAX.Value = 0;
                ultraTextLENGTH.Value = "";
                ultraComboBJ_TYPE.Value = "";
                ultraTextCRAFT_PATH.Value = "";
                ultraTextRCL_INFO.Value = "";
                ultraTextPAYDOWN_DPT.Value = "";
                ultraTextMONITOR_INFO.Value = "";
                ultraTextHOLE_MODAL_INFO.Value = "";
                ultraComboCRAFT_FILE_TYPE.Value = "";
                ultraComboCRAFT_FILE_FLAG.Value = "";
                ultraTextCRAFT_FILE_PATH.Value = "";
            }
        }

        /// <summary>
        /// 设置列只可读
        /// </summary>
        /// <param name="ugr">UltraGrid</param>
        /// <param name="columns">列数组</param>
        private void SetColumnReadOnly()
        {
            for (int i = 0; i < ultraGridCraftfile.Rows.Count; i++)
            {
                UltraGridRow ugr = ultraGridCraftfile.Rows[i];
                //for (int j = 0; j < ugr.Cells.Count; j++)
                //{
                //    if (!ugr.Cells[j].Column.Key.Equals("CHC"))
                //    {
                //        ugr.Cells[j].Activation = Activation.ActivateOnly;
                //    }
                //}
                if (ugr.Cells["CraftFilePath"].Value.ToString().Length > 0)
                {
                    ugr.Cells["FilePath"].Value = "已上传";
                }

            }
        }

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

        private void ultraTextCRAFT_FILE_PATH_EditorButtonClick(object sender, EditorButtonEventArgs e)
        {
            UltraGridRow ugr = this.ultraGridOrderLine.ActiveRow;
            if (ugr == null)
            {
                return;
            }
            string ordLnPk = ugr.GetValue("OrdLnPk");
            string filePath = "saleOrder/ReviewForm/frmOrderColligateInfomation/" + ordLnPk;

            if (e.Button.Key.ToLower().Equals("select"))
            {
                dlgOrderAskDown down = new dlgOrderAskDown(this.ob, filePath);
                down.ShowDialog();
            }

            if (e.Button.Key.ToLower().Equals("choice"))
            {

                bool isUpload = FlileUploadcomm.FlileUpload(filePath);
                if (isUpload)
                {
                    dlgOrderAskDown down = new dlgOrderAskDown(this.ob, filePath);
                    down.ShowDialog();

                }
            }
            ultraTextCRAFT_FILE_PATH.Value = filePath;
        }

        private void ultraGridCraftfile_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow ugr = this.ultraGridCraftfile.ActiveRow;
            if (ugr == null)
            {
                return;
            }

            //QueryCraftFile(ugr.GetCellValue("orderNo").ToString(),
            //    ugr.GetCellValue("orderSeq").ToString());

            foreach (UltraGridRow uRow in ultraGridOrderLine.Rows)
            {
                if (uRow.GetCellValue("orderNo").ToString().Equals(ugr.GetCellValue("orderNo").ToString())
                    && uRow.GetCellValue("orderSeq").ToString().Equals(ugr.GetCellValue("orderSeq").ToString()))
                {
                    ultraGridOrderLine.ActiveRow = uRow;
                }
            }
        }

        private void ultraCheckOrderLine_CheckedChanged(object sender, EventArgs e)
        {
            if (ultraCheckOrderLine.Checked)
            {
                ultraTextOrderLine.Enabled = true;
            }
            else
            {
                ultraTextOrderLine.Enabled = false;
            }
        }

        private void ultraCheckEditorOrderNo_CheckedChanged(object sender, EventArgs e)
        {
            if (ultraCheckEditorOrderNo.Checked)
            {
                ultraComboEditorOrderNo.Enabled = true;
            }
            else
            {
                ultraComboEditorOrderNo.Enabled = false;
            }
        }

        private void askItemImg_EditorButtonClick(object sender, EditorButtonEventArgs e)
        {
            UltraGridRow ugrCraFile = this.ultraGridCraftfile.ActiveRow;
            if (ugrCraFile == null)
            {
                return;
            }
            UltraGridRow ugr = this.ultraGridOrderLine.ActiveRow;
            if (ugr == null)
            {
                return;
            }
            string ordLnPk = ugr.GetValue("OrdLnPk");
            string filePath = "saleOrder/ReviewForm/frmOrderColligateInfomation/" + ordLnPk;

            if (e.Button.Key.ToLower().Equals("select"))
            {
                dlgOrderAskDown down = new dlgOrderAskDown(this.ob, filePath);
                down.ShowDialog();
            }

            if (e.Button.Key.ToLower().Equals("choice"))
            {

                bool isUpload = FlileUploadcomm.FlileUpload(filePath);
                if (isUpload)
                {
                    dlgOrderAskDown down = new dlgOrderAskDown(this.ob, filePath);
                    down.ShowDialog();

                }
            }
            ugrCraFile.Cells["CraftFilePath"].Value = filePath;
        }

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

    }
}