MES_Client/TGMES/Core.StlMes.Client.SaleOrder/Control/ctrlOrderHead.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using CoreFS.CA06;
using Core.Mes.Client.Comm.Server;
using System.IO;
using Core.Mes.Client.Comm.Tool;
using System.Diagnostics;
using Core.Mes.Client.Comm.Control;
using Infragistics.Win.UltraWinGrid;
using Core.StlMes.Client.SaleOrder.Dialog;

namespace Core.StlMes.Client.SaleOrder
{
    public partial class ctrlOrderHead : UserControl
    {
        public delegate void GetSaleOrgHander(string saleorg);
        public event GetSaleOrgHander saleorgHander;

        OpeBase ob = new OpeBase();
        string model_fl = "";
        DataSet order = new DataSet();//返回给主界面的集合：保存合同范本和付款要求
        DataTable order_head = new DataTable("SLM_ORDER_HEAD"); //合同头
        DataRow row = null;
        /// <summary>
        /// 销售组织
        /// </summary>
        string saleorg = "";//销售组织 
        string saleorgDip = "";//科室
        List<string> listDept = new List<string>();//科室权限
        string depId = "";
        public string SaleorgDip
        {
            get { return saleorgDip; }
            set { saleorgDip = value; }
        }

        /// <summary>
        /// 订货单位
        /// </summary>
        UltraGridRow customerRow = null;

        /// <summary>
        /// 结算单位
        /// </summary>
        UltraGridRow settleRow = null;

        public string Saleorg
        {
            get { return saleorg; }
            set { saleorg = value; }
        }
        public DataTable Order_head
        {
            get { return order_head; }
            set { order_head = value; }
        }
        string buyerType = "0";
        public DataSet Order
        {
            get { return order; }
            set { order = value; }
        }

        public void OrderNoIsEdit(bool b)
        {
            ultraOrderText.ReadOnly = b;
        }
        public DataSet ctrlValue
        {
            get
            {
                if (!IsDesignMode())
                {
                    ////判断order的数据约束  当客户单位和结算单位都不为空时 custOmerLoad()方法可以获取到正确的客户信息
                    //if (customerRow != null || settleRow != null)
                    //{
                    //    if (order.Tables["SLM_ORDER_HEAD"] == null || order.Tables["SLM_ORDER_HEAD"].Rows.Count == 0)
                    //    {
                    //        MessageUtil.ShowTips("合同头为空，请重新操作！");
                    //        return null;
                    //    }
                    //    row = order_head.NewRow();
                    //    row["PROTCL_NO"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["PROTCL_NO"];
                    //    row["SIGN_ADDRESS"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["SIGN_ADDRESS"];
                    //    row["MEMO"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["MEMO"];
                    //    row["ORDER_SCAN_NO"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["ORDER_SCAN_NO"];
                    //    row["MNY_ASK_TYP"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["MNY_ASK_TYP"];
                    //    row["CURRENCY"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["CURRENCY"];
                    //    row["PRICE_FL"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["PRICE_FL"];
                    //    row["FST_DRAWEE_UNIT"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["FST_DRAWEE_UNIT"];
                    //    row["SUPPLY_UNIT"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["SUPPLY_UNIT"];
                    //    row["SALE_AREA_DESC"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["SALE_AREA_DESC"];
                    //    row["SIGN_DATE"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["SIGN_DATE"];
                    //    row["SALE_AREA_NO"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["SALE_AREA_NO"];
                    //    row["SALE_AREA_DESC"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["SALE_AREA_DESC"];
                    //    row["ORDER_TYP"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["ORDER_TYP"];
                    //    row["ORDER_TYP_DESC"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["ORDER_TYP_DESC"];
                    //    row["CUSTM_ORDER_NO"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["CUSTM_ORDER_NO"];
                    //    row["ORDER_MODEL_NO"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["ORDER_MODEL_NO"];
                    //    row["ORDER_NO"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["ORDER_NO"];
                    //    row["MNY_ASK_DESC"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["MNY_ASK_DESC"];
                    //    row["ORDER_YEAR"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["ORDER_YEAR"];
                    //    row["CUSTOMER_NO"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["CUSTOMER_NO"];
                    //    row["CUSTOMER_NM"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["CUSTOMER_NM"];
                    //    row["LEGAL_PSN"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["LEGAL_PSN"];
                    //    row["AGENT"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["AGENT"];
                    //    row["ADDRESS"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["ADDRESS"];
                    //    row["ZIP_CODE"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["ZIP_CODE"];
                    //    row["PHONE"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["PHONE"];
                    //    row["FAX"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["FAX"];
                    //    row["STLMT_UNIT_NO"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["STLMT_UNIT_NO"];
                    //    row["STLMT_UNIT_NM"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["STLMT_UNIT_NM"];
                    //    row["BANK"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["BANK"];
                    //    row["ACCOUNT"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["ACCOUNT"];
                    //    row["TAX_ID"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["TAX_ID"];
                    //    row["CUSTOMER_MODEL_FL"] = model_fl;
                    //    row["ORDER_MODEL_DESC"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["ORDER_MODEL_DESC"];
                    //    row["CREATE_DEPT"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["CREATE_DEPT"];
                    //    row["MARKET_SYS"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["MARKET_SYS"];
                    //    row["MARKET_SYS_DESC"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["MARKET_SYS_DESC"];
                    //    row["ABRVITION"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["ABRVITION"];
                    //    row["PRINT_PRICE"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["PRINT_PRICE"];
                    //    row["PRICE_PLAN"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["PRICE_PLAN"];
                    //    row["CONTAIN_TAX"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["CONTAIN_TAX"];
                    //    row["TRADE_TYPE"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["TRADE_TYPE"];
                    //    row["ORDER_CLASSIFY"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["ORDER_CLASSIFY"];
                    //    row["BUSINESS_TYPE"] = order.Tables["SLM_ORDER_HEAD"].Rows[0]["BUSINESS_TYPE"];
                    //}
                    //order_head.Rows.Clear();
                    //贸易类型
                    if (cmbMYLX.SelectedItem == null)
                    {
                        MessageUtil.ShowTips("请选择贸易类型！");
                        return null;
                    }
                    if (cmbType.SelectedItem == null)
                    {
                        MessageUtil.ShowTips("请选择分类！");
                        return null;
                    }
                    if (saleorg.Equals("100102"))
                    {
                        if (cmbBusType.SelectedItem == null)
                        {
                            MessageUtil.ShowTips("请选择业务分类！");
                            return null;
                        }
                    }
                    if (ultraPricingCombo.Value.ToString().Equals("120301"))
                    {
                        //协议号
                        if (ultraComboPact.Text.Trim().Equals(""))
                        {
                            MessageUtil.ShowTips("协议号不允许为空！");
                            return null;
                        }
                        row["PROTCL_NO"] = ultraComboPact.Text;
                    }
                    //签约地点
                    if (signSiteCombo.Text.Trim().Equals(""))
                    {
                        MessageUtil.ShowTips("签约地点不允许为空！");
                        return null;
                    }
                    row["SIGN_ADDRESS"] = signSiteCombo.Text == "" ? "N/A" : signSiteCombo.Text;
                    //其他信息 
                    row["MEMO"] = ultraOrderMemo.Text;
                    //付款方式
                    if (ultraPaymentMethodCombo.Text.Trim().Equals(""))
                    {
                        MessageUtil.ShowTips("付款方式不允许为空！");
                        return null;
                    }
                    row["MNY_ASK_TYP"] = ultraPaymentMethodCombo.Value == null ? "N/A" : ultraPaymentMethodCombo.Value;
                    //币种
                    if (ultraCurrencyCombo.Text.Trim().Equals(""))
                    {
                        MessageUtil.ShowTips("币种不允许为空！");
                        return null;
                    }
                    row["CURRENCY"] = ultraCurrencyCombo.Value == null ? "N/A" : ultraCurrencyCombo.Value;
                    //定价方式(不计价;随行就市价;按合同价执行)
                    if (ultraPricingCombo.Text.Trim().Equals(""))
                    {
                        MessageUtil.ShowTips("定价方式不允许为空！");
                        return null;
                    }
                    row["PRICE_FL"] = ultraPricingCombo.Value == null ? "N/A" : ultraPricingCombo.Value;
                    //首次受票人(国贸/钢贸/集团/客户)
                    if (draweeUintCombo.Text.Trim().Equals(""))
                    {
                        MessageUtil.ShowTips("首次受票人不允许为空！");
                        return null;
                    }
                    row["FST_DRAWEE_UNIT"] = draweeUintCombo.SelectedItem == null ? "N/A" : draweeUintCombo.SelectedItem.DataValue;
                    //供货商
                    if (makersCombo.Text.Trim().Equals(""))
                    {
                        MessageUtil.ShowTips("制造商不允许为空！");
                        return null;
                    }
                    row["SUPPLY_UNIT"] = makersCombo.SelectedItem == null ? "N/A" : makersCombo.SelectedItem.DataValue;

                    row["SALE_AREA_DESC"] = signSiteCombo.SelectedItem == null ? "N/A" : signSiteCombo.SelectedItem.DataValue;
                    row["SIGN_DATE"] = signDateTime.Value == null ? "" : Convert.ToDateTime(signDateTime.Value).ToString("yyyy-MM-dd");

                    //销售区域ID，DESC
                    if (salesAreaCombo.Text.Trim().Equals(""))
                    {
                        MessageUtil.ShowTips("请选择销售片区！若没有，请先到'销售管理'-'基础数据'-'销售业务片区信息维护'界面，维护销售片区信息。");
                        return null;
                    }
                    row["SALE_AREA_NO"] = salesAreaCombo.SelectedItem.DataValue;
                    row["SALE_AREA_DESC"] = salesAreaCombo.SelectedItem.DisplayText;
                    //合同类型，合同描述
                    if (OrderTypeCombo.Text.Trim().Equals(""))
                    {
                        MessageUtil.ShowTips("合同类型不允许为空！");
                        return null;
                    }
                    row["ORDER_TYP"] = OrderTypeCombo.SelectedItem == null ? "N/A" : OrderTypeCombo.SelectedItem.DataValue;
                    row["ORDER_TYP_DESC"] = OrderTypeCombo.SelectedItem == null ? "N/A" : OrderTypeCombo.SelectedItem.DisplayText;
                    //合同年度
                    if (yearCombo.Text.Trim().Equals(""))
                    {
                        MessageUtil.ShowTips("合同年度不允许为空！");
                        return null;
                    }
                    row["ORDER_YEAR"] = yearCombo.Text;
                    //打印价格
                    if (cmbPrintPrice.SelectedItem == null)
                    {
                        MessageUtil.ShowWarning("请选择打印价格！");
                        return null;
                    }
                    row["PRINT_PRICE"] = cmbPrintPrice.Text == "" ? "/" : cmbPrintPrice.Text;
                    //是否含税
                    if (cmbTax.SelectedItem == null)
                    {
                        MessageUtil.ShowWarning("请选择是否含税！");
                        return null;
                    }

                    //罚则条款
                    if (penaltyRadioButton1.Checked && penaltyTextEditor.Text.Trim().Equals(""))
                    {
                        MessageUtil.ShowWarning("罚则条款不能为空！");
                        return null;
                    }
                    row["PENALTY_DESC"] = penaltyTextEditor.Text;

                    row["CONTAIN_TAX"] = cmbTax.Value.ToString();
                    row["TRADE_TYPE"] = cmbMYLX.Value.ToString();
                    row["ORDER_CLASSIFY"] = cmbType.Value.ToString();
                    row["BUSINESS_TYPE"] = cmbBusType.SelectedItem == null ? "" : cmbBusType.Value.ToString();

                    if (txtLocLaw.Text.Trim() == "")
                    {
                        MessageUtil.ShowWarning("请输入当地法律法规");
                        return null;
                    }
                    row["LOCAL_LAW"] = txtLocLaw.Text.Trim();

                    //优惠方案
                    //if (txtPricePlan.Text.Trim() == "")
                    //{
                    //    MessageUtil.ShowWarning("请输入优惠方案！");
                    //    return null;
                    //}
                    row["PRICE_PLAN"] = txtPricePlan.Text;
                    row["CUSTM_ORDER_NO"] = ultraOrderNo.Text == "" ? "N/A" : ultraOrderNo.Text;

                    row["ORDER_MODEL_NO"] = ultraTextBusiness.Tag == null ? "N/A" : ultraTextBusiness.Tag;
                    row["ORDER_MODEL_DESC"] = ultraTextBusiness.Text == "" ? "N/A" : ultraTextBusiness.Text;
                    row["CUSTOMER_MODEL_FL"] = model_fl == "" ? "/" : model_fl;
                    //合同号
                    row["ORDER_NO"] = ultraOrderText.Text.Trim();
                    if (ultraMoneyAsk.Text.Trim() == "")
                    {
                        MessageUtil.ShowWarning("付款要求不能为空！");
                        return null;
                    }
                    row["MNY_ASK_DESC"] = ultraMoneyAsk.Text;

                    //客户单位赋值
                    custOmerLoad();

                    // 跟单人
                    row["DOCUMENTARY_NAME"] = documentaryName.Text.Trim();
                    row["DOCUMENTARY_DEPT"] = documentaryDept.Text.Trim();

                    row["ORDER_REQUIRE_STATUS"] = orderRequireCombo.Value.ToString2();

                    // 目的港
                    row["PORT_OF_DESTINATION"] = txtPortOfDestination.Value.ToString2().Trim();

                    if (Saleorg.Equals("100102"))
                    {
                        if (row["DOCUMENTARY_NAME"].ToString() == null || row["DOCUMENTARY_NAME"].ToString() == "")
                        {
                            MessageUtil.ShowWarning("跟单人不能为空！");
                            return null;
                        }
                        if (row["ORDER_MODEL_NO"].ToString() == null || row["ORDER_MODEL_NO"].ToString() == "")
                        {
                            MessageUtil.ShowWarning("合同条款不能为空！");
                            return null;
                        }
                        if (row["MNY_ASK_DESC"].ToString() == null || row["MNY_ASK_DESC"].ToString() == "")
                        {
                            MessageUtil.ShowWarning("付款要求不能为空！");
                            return null;
                        }
                        if (row["PORT_OF_DESTINATION"].ToString() == null || row["PORT_OF_DESTINATION"].ToString() == "")
                        {
                            MessageUtil.ShowWarning("目的港不能为空！");
                            return null;
                        }
                    }

                    for (int i = 0; i < order.Tables.Count; i++)
                    {
                        if (order.Tables[i].TableName.Equals(order_head.TableName))
                        {
                            order.Tables.Remove(order_head.TableName);
                        }
                    }                    
                    if (!order_head.Rows.Cast<DataRow>().Contains(row))
                    {
                        order_head.Rows.Add(row);
                    }                    
                    order.Tables.Add(order_head.Copy());
                }
                return order;
            }
            set
            {
                if (!IsDesignMode())
                {
                    if (value == null)
                    {
                        //清空控件值
                        //ultraOrderText.Text = null;
                        //ultraOrderNo.Text = null;
                        //OrderTypeCombo.Text = null;
                        //salesAreaCombo.Text = null;
                        //yearCombo.Text = null;
                        //signSiteCombo.Text = null;
                        //makersCombo.Text = null;
                        //draweeUintCombo.Text = null;
                        //orderingBuyer.Text = null;
                        //receivingBuyer.Text = null;
                        //ultraTextBANK.Text = null;
                        //ultraTextACCOUNT.Text = null;
                        //ultraTextTAX.Text = null;
                        //ultraPricingCombo.Text = null;
                        //ultraCurrencyCombo.Text = null;
                        //ultraComboPact.Text = null;
                        //ultraPaymentMethodCombo.Text = null;
                        //ultraMoneyAsk.Text = null;
                        //ultraTextBusiness.Text = null;
                        //ultraOrderTemp.Text = null;
                        //ultraOrderMemo.Text = null;
                    }
                    else
                    {
                        order = value;
                        DataTable SLMORDERHEAD = new DataTable();
                        DataTable SLMORDERBALNCEMNY = new DataTable();
                        DataTable FRMORDERMODEL = new DataTable();
                        SLMORDERHEAD = order.Tables["SLM_ORDER_HEAD"];
                        SLMORDERBALNCEMNY = order.Tables["SLM_ORDER_BALNCE_MNY"];
                        FRMORDERMODEL = order.Tables["frmordermodel"];
                        if (order.Tables.Count <= 0)
                        {
                            return;
                        }

                        //清空客户单位 结算单位
                        customerRow = null;
                        settleRow = null;
                        order_head.Rows.Clear();

                        //控件付值
                        if (!SLMORDERHEAD.Rows[0]["PRICE_FL"].ToString().Equals(""))
                        {
                            //协议号 
                            ultraComboPact.Text = SLMORDERHEAD.Rows[0]["PROTCL_NO"].ToString();
                        }
                        //计价方式(不计价;随行就市价;按合同价执行) 
                        ultraPricingCombo.Text = SLMORDERHEAD.Rows[0]["PRICE_FL"].ToString();
                        //签约地点 
                        signSiteCombo.Text = SLMORDERHEAD.Rows[0]["SIGN_ADDRESS"].ToString();
                        //其他信息 
                        ultraOrderMemo.Text = SLMORDERHEAD.Rows[0]["MEMO"].ToString();
                        //合同材料 
                        // ultraOrderTemp.Value = SLMORDERHEAD.Rows[0]["ORDER_SCAN_NO"].ToString();
                        //付款方式 
                        ultraPaymentMethodCombo.Text = SLMORDERHEAD.Rows[0]["MNY_ASK_TYP"].ToString();
                        //币种 
                        if (SLMORDERHEAD.Rows[0]["CURRENCY"].ToString().Equals("N/A"))
                        {
                            ultraCurrencyCombo.Text = "N/A";
                        }
                        else
                        {
                            ultraCurrencyCombo.Value = SLMORDERHEAD.Rows[0]["CURRENCY"].ToString();
                        }
                        //首次受票人(国贸/钢贸/集团/客户) 
                        draweeUintCombo.Text = SLMORDERHEAD.Rows[0]["FST_DRAWEE_UNIT"].ToString();
                        //合同年度
                        yearCombo.Text = SLMORDERHEAD.Rows[0]["ORDER_YEAR"].ToString();
                        //供货商 
                        makersCombo.Text = SLMORDERHEAD.Rows[0]["SUPPLY_UNIT"].ToString();
                        //签约时间  
                        signDateTime.Value = SLMORDERHEAD.Rows[0]["SIGN_DATE"].ToString() == "" ? null : SLMORDERHEAD.Rows[0]["SIGN_DATE"].ToString();
                        //销售区域ID，DESC 
                        salesAreaCombo.Text = SLMORDERHEAD.Rows[0]["SALE_AREA_DESC"].ToString();
                        //salesAreaCombo.Value = SLMORDERHEAD.Rows[0]["SALE_AREA_DESC"].ToString();
                        //合同类型，合同描述 
                        string sOrdType = SLMORDERHEAD.Rows[0]["ORDER_TYP_DESC"].ToString();
                        if (sOrdType.Contains("研发"))
                        {
                            cmbOrdBigType.Value = "Y";
                        }
                        else if (sOrdType.Contains("来料加工"))
                        {
                            cmbOrdBigType.Value = "L";
                        }
                        else if (sOrdType.Contains("期货") || sOrdType.Contains("贸易") || sOrdType.Contains("加工"))
                        {
                            cmbOrdBigType.Value = "Q";
                        }
                        else if (sOrdType.Contains("现货"))
                        {
                            cmbOrdBigType.Value = "X";
                        }
                        else if (sOrdType.Contains("预排"))
                        {
                            cmbOrdBigType.Value = "P";
                        }
                        else if (sOrdType.Contains("双经销"))
                        {
                            cmbOrdBigType.Value = "S";
                        }
                        else if (sOrdType.Contains("定销订购"))
                        {
                            cmbOrdBigType.Value = "D";
                        }
                        OrderTypeCombo.Value = SLMORDERHEAD.Rows[0]["ORDER_TYP"].ToString();
                        //OrderTypeCombo.Value = SLMORDERHEAD.Rows[0]["ORDER_TYP_DESC"].ToString();
                        //客户合同单 
                        ultraOrderNo.Text = SLMORDERHEAD.Rows[0]["CUSTM_ORDER_NO"].ToString();
                        //商务条款 
                        if (SLMORDERHEAD.Rows[0]["ORDER_MODEL_NO"].ToString().Equals("N/A"))
                        {
                            ultraTextBusiness.Text = "N/A";
                        }
                        else
                        {
                            ultraTextBusiness.Tag = SLMORDERHEAD.Rows[0]["ORDER_MODEL_NO"].ToString();
                            ultraTextBusiness.Text = SLMORDERHEAD.Rows[0]["ORDER_MODEL_DESC"].ToString();
                        }
                        //合同号 
                        ultraOrderText.Text = SLMORDERHEAD.Rows[0]["ORDER_NO"].ToString();
                        //付款要求 
                        ultraMoneyAsk.Text = SLMORDERHEAD.Rows[0]["MNY_ASK_DESC"].ToString();

                        //客户详细信息 
                        orderingBuyer.Text = SLMORDERHEAD.Rows[0]["CUSTOMER_NM"].ToString();//订货单位名称 
                        orderingBuyer.Tag = SLMORDERHEAD.Rows[0]["CUSTOMER_NO"].ToString();//订货单位NO
                        receivingBuyer.Text = SLMORDERHEAD.Rows[0]["STLMT_UNIT_NM"].ToString();//结算单位名称 
                        receivingBuyer.Tag = SLMORDERHEAD.Rows[0]["STLMT_UNIT_NO"].ToString();//结算单位NO
                        ultraTextBANK.Text = SLMORDERHEAD.Rows[0]["BANK"].ToString();
                        ultraTextACCOUNT.Text = SLMORDERHEAD.Rows[0]["ACCOUNT"].ToString();
                        ultraTextTAX.Text = SLMORDERHEAD.Rows[0]["TAX_ID"].ToString();
                        row["CUSTOMER_NO"] = SLMORDERHEAD.Rows[0]["CUSTOMER_NO"];
                        row["CUSTOMER_NM"] = SLMORDERHEAD.Rows[0]["CUSTOMER_NM"];
                        row["LEGAL_PSN"] = SLMORDERHEAD.Rows[0]["LEGAL_PSN"];
                        row["AGENT"] = SLMORDERHEAD.Rows[0]["AGENT"];
                        row["ADDRESS"] = SLMORDERHEAD.Rows[0]["ADDRESS"];
                        row["ZIP_CODE"] = SLMORDERHEAD.Rows[0]["ZIP_CODE"];
                        row["BANK"] = SLMORDERHEAD.Rows[0]["BANK"];
                        row["ACCOUNT"] = SLMORDERHEAD.Rows[0]["ACCOUNT"];
                        row["TAX_ID"] = SLMORDERHEAD.Rows[0]["TAX_ID"];
                        row["PHONE"] = SLMORDERHEAD.Rows[0]["PHONE"];
                        row["FAX"] = SLMORDERHEAD.Rows[0]["FAX"];
                        row["STLMT_UNIT_NO"] = SLMORDERHEAD.Rows[0]["STLMT_UNIT_NO"];
                        row["STLMT_UNIT_NM"] = SLMORDERHEAD.Rows[0]["STLMT_UNIT_NM"];
                        row["CREATE_DEPT"] = SLMORDERHEAD.Rows[0]["CREATE_DEPT"];
                        row["MARKET_SYS"] = SLMORDERHEAD.Rows[0]["MARKET_SYS"];
                        row["MARKET_SYS_DESC"] = SLMORDERHEAD.Rows[0]["MARKET_SYS_DESC"];
                        row["ABRVITION"] = SLMORDERHEAD.Rows[0]["ABRVITION"];
                        //row["BIGAREANO"] = SLMORDERHEAD.Rows[0]["MARKET_SYS_DESC"];
                        //row["BIGAREA"] = SLMORDERHEAD.Rows[0]["BIGAREA"]; 
                        model_fl = SLMORDERHEAD.Rows[0]["CUSTOMER_MODEL_FL"].ToString(); //是否客户范本
                        //打印价格
                        cmbPrintPrice.Text = SLMORDERHEAD.Rows[0]["PRINT_PRICE"].ToString();
                        cmbTax.Value = SLMORDERHEAD.Rows[0]["CONTAIN_TAX"].ToString();
                        txtPricePlan.Text = SLMORDERHEAD.Rows[0]["PRICE_PLAN"].ToString();
                        //贸易类型 分类 业务分类
                        cmbMYLX.Text = SLMORDERHEAD.Rows[0]["TRADE_TYPE"].ToString();
                        cmbType.Text = SLMORDERHEAD.Rows[0]["ORDER_CLASSIFY"].ToString();
                        cmbBusType.Value = SLMORDERHEAD.Rows[0]["BUSINESS_TYPE"].ToString() == "" ? null : SLMORDERHEAD.Rows[0]["BUSINESS_TYPE"].ToString();
                        txtLocLaw.Text = SLMORDERHEAD.Rows[0]["LOCAL_LAW"].ToString();
                        documentaryDept.Text = SLMORDERHEAD.Rows[0]["DOCUMENTARY_DEPT"].ToString();
                        documentaryName.Text = SLMORDERHEAD.Rows[0]["DOCUMENTARY_NAME"].ToString();
                        orderRequireCombo.Value = SLMORDERHEAD.Rows[0]["ORDER_REQUIRE_STATUS"].ToString2();
                        txtPortOfDestination.Text = SLMORDERHEAD.Rows[0]["PORT_OF_DESTINATION"].ToString2();
                        penaltyTextEditor.Text = SLMORDERHEAD.Rows[0]["PENALTY_DESC"].ToString2();
                        penaltyRadioButton1.Checked = SLMORDERHEAD.Rows[0]["PENALTY_DESC"].ToString() == "" ? false : true;
                        penaltyRadioButton2.Checked = SLMORDERHEAD.Rows[0]["PENALTY_DESC"].ToString() == "" ? true : false;
                    }
                }
            }
        }

        private void custOmerLoad()
        {
            if (customerRow != null || settleRow != null)
            {
                if (customerRow != null)
                {
                    row["CUSTOMER_NO"] = orderingBuyer.Tag == null ? "N/A" : orderingBuyer.Tag.ToString();
                    row["CUSTOMER_NM"] = orderingBuyer.Text == "" ? "N/A" : orderingBuyer.Text;
                    row["ABRVITION"] = customerRow.Cells["ABRVITION"].Value.ToString();
                }

                row["STLMT_UNIT_NO"] = receivingBuyer.Tag == null ? "N/A" : receivingBuyer.Tag.ToString();
                row["STLMT_UNIT_NM"] = receivingBuyer.Text == "" ? "N/A" : receivingBuyer.Text.ToString();
                if (settleRow != null)
                {
                    row["LEGAL_PSN"] = settleRow.Cells["LEGAL_PSN"].Value.ToString();
                    row["AGENT"] = settleRow.Cells["AGENT"].Value.ToString();
                    row["ADDRESS"] = settleRow.Cells["ADDRESS"].Value.ToString();
                    row["ZIP_CODE"] = settleRow.Cells["ZIP_CODE"].Value.ToString();
                    row["PHONE"] = settleRow.Cells["PHONE"].Value.ToString();
                    row["FAX"] = settleRow.Cells["FAX"].Value.ToString();
                    row["BANK"] = settleRow.Cells["BANK"].Value.ToString();
                    row["ACCOUNT"] = settleRow.Cells["ACCOUNT"].Value.ToString();
                    row["TAX_ID"] = settleRow.Cells["TAX_ID"].Value.ToString();
                    row["CREATE_DEPT"] = "";
                    row["MARKET_SYS"] = settleRow.Cells["MARKET_SYS"].Value.ToString();
                    row["MARKET_SYS_DESC"] = settleRow.Cells["MARKET_SYS_DESC"].Value.ToString();
                    row["BIGAREANO"] = settleRow.Cells["BIGAREANO"].Value.ToString();
                    row["BIGAREA"] = settleRow.Cells["BIGAREA"].Value.ToString();
                }
            }
            else
            {
                if (order.Tables["SLM_ORDER_HEAD"] == null || order.Tables["SLM_ORDER_HEAD"].Rows.Count == 0)
                {
                    row["CUSTOMER_NO"] = "N/A";
                    row["CUSTOMER_NM"] = "N/A";
                    row["LEGAL_PSN"] = "N/A";
                    row["AGENT"] = "N/A";
                    row["ADDRESS"] = "N/A";
                    row["ZIP_CODE"] = "N/A";
                    row["PHONE"] = "N/A";
                    row["FAX"] = "N/A";
                    row["STLMT_UNIT_NO"] = "N/A";
                    row["STLMT_UNIT_NM"] = "N/A";
                    row["BANK"] = "N/A";
                    row["ACCOUNT"] = "N/A";
                    row["TAX_ID"] = "N/A";
                    row["CREATE_DEPT"] = "N/A";
                    row["MARKET_SYS"] = "N/A";
                    row["MARKET_SYS_DESC"] = "N/A";
                    row["ABRVITION"] = "N/A";
                    row["BIGAREANO"] = "N/A";
                    row["BIGAREA"] = "N/A";
                }
            }
        }
        public ctrlOrderHead()
        {
            InitializeComponent();
        }

        private void ultraTextEditor3_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            buyerType = "1";
            FrmOrderBuyer buyer = new FrmOrderBuyer(this.ob, saleorg, "100202");
            buyer.GetOrderBuyer += new FrmOrderBuyer.GetOrderBuyerHander(buyer_GetOrderBuyer);
            buyer.Text = "订货客户单位";
            buyer.ShowDialog();
        }

        private void ultraTextEditor4_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            buyerType = "2";
            FrmOrderBuyer buyer = new FrmOrderBuyer(this.ob, saleorg, "100202");
            buyer.GetOrderBuyer += new FrmOrderBuyer.GetOrderBuyerHander(buyer_GetOrderBuyer);
            buyer.Text = "结算客户单位";
            buyer.ShowDialog();
        }

        void buyer_GetOrderBuyer(UltraGridRow ugr)
        {
            if (ugr != null)
            {
                //订货单位
                if (buyerType.Equals("1"))
                {
                    customerRow = ugr;
                    orderingBuyer.Text = ugr.Cells["CUSTOMER_NM"].Value.ToString();
                    orderingBuyer.Tag = ugr.Cells["CUSTOMER_NO"].Value.ToString();
                    if (receivingBuyer.Text.Equals("N/A") || receivingBuyer.Text.Trim() == "")
                    {
                        settleRow = ugr;
                        receivingBuyer.Text = ugr.Cells["CUSTOMER_NM"].Value.ToString();
                        receivingBuyer.Tag = ugr.Cells["CUSTOMER_NO"].Value.ToString();
                        ultraTextBANK.Text = ugr.Cells["BANK"].Value.ToString();
                        ultraTextACCOUNT.Text = ugr.Cells["ACCOUNT"].Value.ToString();
                        ultraTextTAX.Text = ugr.Cells["TAX_ID"].Value.ToString();
                    }
                }
                //结算单位
                if (buyerType.Equals("2"))
                {
                    settleRow = ugr;
                    receivingBuyer.Text = ugr.Cells["CUSTOMER_NM"].Value.ToString();
                    receivingBuyer.Tag = ugr.Cells["CUSTOMER_NO"].Value.ToString();
                    ultraTextBANK.Text = ugr.Cells["BANK"].Value.ToString();
                    ultraTextACCOUNT.Text = ugr.Cells["ACCOUNT"].Value.ToString();
                    ultraTextTAX.Text = ugr.Cells["TAX_ID"].Value.ToString();
                }
            }
        }

        private void ultraTextEditor8_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            if (e.Button.Key.Equals("1"))
            {
                frmOrderModel frmModel = new frmOrderModel(this.ob);
                if (orderingBuyer.Tag == null || "".Equals(orderingBuyer.Tag.ToString()))
                {
                    MessageBox.Show("请先选择订货单位。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    return;
                }
                else
                {
                    frmModel.Use_unit = orderingBuyer.Tag == null ? "" : orderingBuyer.Tag.ToString();
                    frmModel.GetOrderModel += new frmOrderModel.GetOrderModelHander(frmModel_GetOrderModel);
                    frmModel.ShowDialog();
                }
            }
            else
            {
                //清除
                if (ultraTextBusiness.Text.Trim() == "" || ultraTextBusiness.Text == "N/A")
                    return;
                if (MessageBox.Show("是否清除合同条款？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No) return;
                ultraTextBusiness.Text = "N/A";
                ultraTextBusiness.Tag = "";
                model_fl = "";
            }

        }


        void frmModel_GetOrderModel(DataRow rows, DataTable dt)
        {
            //子项保存在DataSet
            dt.TableName = "frmOrderModel";
            DataTable rowsTable = new DataTable();
            //this.ultraTextBusiness.Text = row[1].ToString() + "," + row[4].ToString();
            this.ultraTextBusiness.Tag = rows[0].ToString();
            this.ultraTextBusiness.Text = rows[1].ToString();
            model_fl = rows["CUSTOMER_MODEL_FL"].ToString();
            for (int i = 0; i < order.Tables.Count; i++)
            {
                if (order.Tables[i].TableName.Equals(dt.TableName))
                {
                    order.Tables.Remove(dt.TableName);
                }
            }
            rowsTable = dt.Copy();
            order.Tables.Add(rowsTable);
        }

        private void ultraTextEditor11_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            DataTable tableAsk = new DataTable();

            if (order.Tables["SLM_ORDER_HEAD"] != null)
            {
                tableAsk = ServerHelper.GetData("com.steering.pss.sale.order.CoreCtrlOrderLine.BindSlmBalnceMny", new Object[] { order.Tables["SLM_ORDER_HEAD"].Rows[0]["ORD_PK"].ToString() }, ob);
            }
            FrmOrderMoneyAsk ask = new FrmOrderMoneyAsk("000000", ultraOrderText.Text);
            ask.Order_pk = tableAsk;
            ask.AskDesc = ultraMoneyAsk.Text.Trim();
            ask.GetOrderMoneyAsk += new FrmOrderMoneyAsk.GetOrderMoneyAskHander(ask_GetOrderMoneyAsk);
            ask.ShowDialog();
        }

        void ask_GetOrderMoneyAsk(string stAll, DataTable retunData)
        {
            this.ultraMoneyAsk.Text = stAll;
            for (int i = 0; i < order.Tables.Count; i++)
            {
                if (order.Tables[i].TableName.Equals(retunData.TableName))
                {
                    order.Tables.Remove(retunData.TableName);
                }
            }
            order.Tables.Add(retunData);
        }

        /// <summary>
        /// 加载贸易类型
        /// </summary>
        /// <param name="saleOrg"></param>
        private void LoadTradeType(string saleOrg)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.CopyCtrlOrderHead.queryTradeType", new object[] { saleOrg }, this.ob);
            cmbMYLX.DataSource = dt;
            cmbMYLX.DisplayMember = "BASENAME";
            cmbMYLX.ValueMember = "BASECODE";
        }

        /// <summary>
        /// 加载贸易类型
        /// </summary>
        /// <param name="saleOrg"></param>
        private void LoadSalesArea(string saleOrg, List<string> listDept)
        {
            //销售片区
            DataTable areaDt = ServerHelper.GetData("com.steering.pss.sale.order.CopyCtrlOrderHead.doQuerySalesArea", new Object[] { saleOrg, listDept.ToArray() }, ob);
            salesAreaCombo.DataSource = areaDt;
            salesAreaCombo.DisplayMember = "SALE_AREA_DESC";
            salesAreaCombo.ValueMember = "SALE_AREA_NO";
            salesAreaCombo.SelectedIndex = 0;
        }

        /// <summary>
        /// 加载合同类别
        /// </summary>
        private void LoadOrderClassify()
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.CopyCtrlOrderHead.queryOrderClassify", null, this.ob);
            cmbType.DataSource = dt;
            cmbType.DisplayMember = "BASENAME";
            cmbType.ValueMember = "BASECODE";
        }

        //初始化box
        /// <summary>
        /// 初始化合同头控件
        /// </summary>
        /// <param name="obx">OB</param>
        /// <param name="sale">销售组织</param>
        /// <param name="saleorgSX">科室名称</param>
        /// <param name="deptId">科室ID</param>
        /// <param name="arr">数据权限</param>
        public void loadBox(OpeBase obx, string sale, string saleorgSX, string deptId,string[] arr)
        {
            ob = obx;
            utSaleorg.ValueList = ClsBaseInfo.GetSaleOrgByValid(arr);
            //listDept.Add(deptId);
            listDept = arr.ToList();
            depId = deptId;
            utSaleorg.Value = sale;
            saleorgDip = saleorgSX;
            saleorg = utSaleorg.Value.ToString();           
            if (sale == "100102")
            {
                txtPricePlan.Text = "/";
            }
            else
            {
                cmbBusType.Enabled = false;
            }
            //贸易类型
            LoadTradeType(sale);
            //分类
            LoadOrderClassify();
            //业务分类写死在下拉框中 只有国贸可见

            //合同类型   这里注释掉 由合同大类型来决定加载相应的合同类型
            /*DataTable unLoad = ServerHelper.GetData("com.steering.pss.sale.order.CopyCtrlOrderHead.doQueryOrderType", new Object[] { }, ob);
            OrderTypeCombo.DataSource = unLoad;
            OrderTypeCombo.DisplayMember = "BASENAME";
            OrderTypeCombo.ValueMember = "BaseCODE";
            OrderTypeCombo.Text = "N/A"; */
            //销售片区
            LoadSalesArea(sale, listDept);

            //合同年份
            this.yearCombo.DataSource = null;
            DataTable unLoad = new DataTable();
            unLoad.Columns.Add("Name", typeof(System.String));
            unLoad.Columns.Add("Code", typeof(System.String));
            int timeyear = Convert.ToInt16(DateTime.Now.Date.Year.ToString());
            for (int i = 1; i < 3; i++)
            {
                int year = timeyear + i;
                unLoad.Rows.Add(year + "年", year.ToString());
            }
            for (int i = 0; i < 10; i++)
            {
                int year = timeyear - i;
                unLoad.Rows.Add(year + "年", year.ToString());
            }
            unLoad.Columns["Name"].Caption = "年份";
            unLoad.Columns["Code"].Caption = "年份代码";
            yearCombo.DataSource = unLoad;
            yearCombo.DisplayMember = "Name";
            yearCombo.ValueMember = "Code";

            //签约地点
            DataTable siteDt = ServerHelper.GetData("com.steering.pss.sale.order.CopyCtrlOrderHead.doQuerySignSite", new Object[] { }, ob);
            signSiteCombo.DataSource = siteDt;
            signSiteCombo.DisplayMember = "BASENAME";
            signSiteCombo.ValueMember = "BASECODE";
            signSiteCombo.Text = "天津市东丽区";

            //制造商
            DataTable makeDt = ServerHelper.GetData("com.steering.pss.sale.order.CopyCtrlOrderHead.doQueryMakers", new Object[] { }, ob);
            makersCombo.DataSource = makeDt;
            makersCombo.DisplayMember = "BASENAME";
            makersCombo.ValueMember = "BASECODE";
            makersCombo.Text = "天津钢管制造有限公司";

            //首次受票单位
            DataTable unitDt = ServerHelper.GetData("com.steering.pss.sale.order.CopyCtrlOrderHead.doQueryFirstDraweeUint", new Object[] { }, ob);
            draweeUintCombo.DataSource = unitDt;
            draweeUintCombo.DisplayMember = "BASENAME";
            draweeUintCombo.ValueMember = "BASECODE";

            if (saleorg.Equals("100101"))
            {
                draweeUintCombo.Text = "天津钢管集团股份有限公司";
            }
            if (saleorg.Equals("100102"))
            {
                draweeUintCombo.Text = "天津钢管国际贸易有限公司";
            }
            if (saleorg.Equals("100103"))
            {
                draweeUintCombo.Text = "天津钢管钢铁贸易有限公司";
            }
            if (saleorg.Equals("100105"))
            {
                draweeUintCombo.Text = "江苏天淮钢管有限公司";
            }
            //计价方式
            DataTable priceDt = ServerHelper.GetData("com.steering.pss.sale.order.CopyCtrlOrderHead.doQueryPricing", new Object[] { }, ob);
            ultraPricingCombo.DataSource = priceDt;
            ultraPricingCombo.DisplayMember = "BASENAME";
            ultraPricingCombo.ValueMember = "BASECODE";
            ultraPricingCombo.Text = "N/A";

            //计价方式
            DataTable orderRequireDt = ServerHelper.GetData("com.steering.pss.sale.order.CopyCtrlOrderHead.doQueryOrderRequire", new Object[] { }, ob);
            orderRequireCombo.DataSource = orderRequireDt;
            orderRequireCombo.DisplayMember = "BASENAME";
            orderRequireCombo.ValueMember = "BASECODE";
            orderRequireCombo.Text = "/";

            //币种
            DataTable moneyDt = ServerHelper.GetData("com.steering.pss.sale.order.CopyCtrlOrderHead.doQueryCurrency", new Object[] { }, ob);
            ultraCurrencyCombo.DataSource = moneyDt;
            ultraCurrencyCombo.DisplayMember = "BASENAME";
            ultraCurrencyCombo.ValueMember = "BASECODE";
            ultraCurrencyCombo.Text = "人民币";

            //付款方式
            DataTable payDt = ServerHelper.GetData("com.steering.pss.sale.order.CopyCtrlOrderHead.doQueryPaymentMethod", new Object[] { }, ob);
            ultraPaymentMethodCombo.DataSource = payDt;
            ultraPaymentMethodCombo.DisplayMember = "BASENAME";
            ultraPaymentMethodCombo.ValueMember = "BASECODE";
            if (this.saleorg == "100103")   //钢贸
            {
                ultraPaymentMethodCombo.Value = "121208";     //六个月承兑 
            }
            else
            {
                ultraPaymentMethodCombo.Text = "N/A";
            }

            yearCombo.Text = DateTime.Now.Date.Year.ToString() + "年";
            signDateTime.Value = DateTime.Now.Date;
            ultraTextBusiness.Text = "N/A";
            receivingBuyer.Text = "N/A";
            orderingBuyer.Text = "N/A";
            ultraTextBANK.Text = "N/A";
            ultraTextACCOUNT.Text = "N/A";
            ultraTextTAX.Text = "N/A";
            cmbPrintPrice.Text = "结算价";
            cmbTax.Text = "否";

            if (deptId == "002001042001011" || deptId == "002023020") 
            {
                cmbOrdBigType.Value = "Y";
                cmbOrdBigType.Enabled = false;
            }

            ClsBaseInfo.SetComboItemHeight(OrderTypeCombo);
            ClsBaseInfo.SetComboItemHeight(salesAreaCombo);
            ClsBaseInfo.SetComboItemHeight(yearCombo);
            ClsBaseInfo.SetComboItemHeight(signSiteCombo);
            ClsBaseInfo.SetComboItemHeight(makersCombo);
            ClsBaseInfo.SetComboItemHeight(draweeUintCombo);
            ClsBaseInfo.SetComboItemHeight(ultraPricingCombo);
            ClsBaseInfo.SetComboItemHeight(orderRequireCombo);
            ClsBaseInfo.SetComboItemHeight(ultraCurrencyCombo);
            ClsBaseInfo.SetComboItemHeight(ultraPaymentMethodCombo);
            ClsBaseInfo.SetComboItemHeight(cmbPrintPrice);
        }

        private void ctrlOrderHead_Load(object sender, EventArgs e)
        {
            order_head.Columns.Add("MANAG_NO", System.Type.GetType("System.String"));
            order_head.Columns.Add("ORDER_NO", System.Type.GetType("System.String"));
            order_head.Columns.Add("CUSTM_ORDER_NO", System.Type.GetType("System.String"));
            order_head.Columns.Add("ORDER_TYP", System.Type.GetType("System.String"));
            order_head.Columns.Add("ORDER_TYP_DESC", System.Type.GetType("System.String"));
            order_head.Columns.Add("ORDER_YEAR", System.Type.GetType("System.String"));
            order_head.Columns.Add("PROTCL_NO", System.Type.GetType("System.String"));
            order_head.Columns.Add("CUSTOMER_NO", System.Type.GetType("System.String"));
            order_head.Columns.Add("CUSTOMER_NM", System.Type.GetType("System.String"));
            order_head.Columns.Add("SUPPLY_UNIT", System.Type.GetType("System.String"));
            order_head.Columns.Add("PRICE_FL", System.Type.GetType("System.String"));
            order_head.Columns.Add("CURRENCY", System.Type.GetType("System.String"));
            order_head.Columns.Add("STLMT_UNIT_NO", System.Type.GetType("System.String"));
            order_head.Columns.Add("STLMT_UNIT_NM", System.Type.GetType("System.String"));
            order_head.Columns.Add("FST_DRAWEE_UNIT", System.Type.GetType("System.String"));
            order_head.Columns.Add("LEGAL_PSN", System.Type.GetType("System.String"));
            order_head.Columns.Add("AGENT", System.Type.GetType("System.String"));
            order_head.Columns.Add("ADDRESS", System.Type.GetType("System.String"));
            order_head.Columns.Add("ZIP_CODE", System.Type.GetType("System.String"));
            order_head.Columns.Add("BANK", System.Type.GetType("System.String"));
            order_head.Columns.Add("ACCOUNT", System.Type.GetType("System.String"));
            order_head.Columns.Add("TAX_ID", System.Type.GetType("System.String"));
            order_head.Columns.Add("PHONE", System.Type.GetType("System.String"));
            order_head.Columns.Add("FAX", System.Type.GetType("System.String"));
            order_head.Columns.Add("ORDER_WGT", System.Type.GetType("System.String"));
            order_head.Columns.Add("ORDER_MNY_TAX", System.Type.GetType("System.String"));
            order_head.Columns.Add("ORDER_MNY_NTAX", System.Type.GetType("System.String"));
            order_head.Columns.Add("MNY_ASK_TYP", System.Type.GetType("System.String"));
            order_head.Columns.Add("MNY_ASK_DESC", System.Type.GetType("System.String"));
            order_head.Columns.Add("SIGN_PERSON", System.Type.GetType("System.String"));
            order_head.Columns.Add("SIGN_DATE", System.Type.GetType("System.String"));
            order_head.Columns.Add("SIGN_ADDRESS", System.Type.GetType("System.String"));
            order_head.Columns.Add("ORDER_BDATE", System.Type.GetType("System.String"));
            order_head.Columns.Add("ORDER_EDATE", System.Type.GetType("System.String"));
            order_head.Columns.Add("ORDER_SCAN_NO", System.Type.GetType("System.String"));
            order_head.Columns.Add("CUSTOMER_MODEL_FL", System.Type.GetType("System.String"));
            order_head.Columns.Add("ORDER_MODEL_NO", System.Type.GetType("System.String"));
            order_head.Columns.Add("SALE_ORG", System.Type.GetType("System.String"));
            order_head.Columns.Add("SALE_ORG_DESC", System.Type.GetType("System.String"));
            order_head.Columns.Add("SALE_AREA_NO", System.Type.GetType("System.String"));
            order_head.Columns.Add("SALE_AREA_DESC", System.Type.GetType("System.String"));
            order_head.Columns.Add("MEMO", System.Type.GetType("System.String"));
            order_head.Columns.Add("ORDER_STS", System.Type.GetType("System.String"));
            order_head.Columns.Add("ORDER_STS_DESC", System.Type.GetType("System.String"));
            order_head.Columns.Add("PAYMENTMETHOD", System.Type.GetType("System.String"));
            order_head.Columns.Add("CUSTM_DATA", System.Type.GetType("System.String"));
            order_head.Columns.Add("PACT", System.Type.GetType("System.String"));
            order_head.Columns.Add("SIGNSITECOMBO", System.Type.GetType("System.String"));
            order_head.Columns.Add("ORDER_MODEL_DESC", System.Type.GetType("System.String"));
            order_head.Columns.Add("CREATE_DEPT", System.Type.GetType("System.String"));
            order_head.Columns.Add("MARKET_SYS", System.Type.GetType("System.String"));
            order_head.Columns.Add("MARKET_SYS_DESC", System.Type.GetType("System.String"));
            order_head.Columns.Add("ABRVITION", System.Type.GetType("System.String"));
            order_head.Columns.Add("BIGAREANO", System.Type.GetType("System.String"));
            order_head.Columns.Add("BIGAREA", System.Type.GetType("System.String"));
            order_head.Columns.Add("PRINT_PRICE", System.Type.GetType("System.String"));
            order_head.Columns.Add("PRICE_PLAN", System.Type.GetType("System.String"));
            order_head.Columns.Add("CONTAIN_TAX", System.Type.GetType("System.String"));
            order_head.Columns.Add("TRADE_TYPE", System.Type.GetType("System.String"));
            order_head.Columns.Add("ORDER_CLASSIFY", System.Type.GetType("System.String"));
            order_head.Columns.Add("BUSINESS_TYPE", System.Type.GetType("System.String"));
            order_head.Columns.Add("LOCAL_LAW", System.Type.GetType("System.String"));
            order_head.Columns.Add("DOCUMENTARY_NAME", System.Type.GetType("System.String"));
            order_head.Columns.Add("DOCUMENTARY_DEPT", System.Type.GetType("System.String"));
            order_head.Columns.Add("ORDER_REQUIRE_STATUS", System.Type.GetType("System.String"));
            order_head.Columns.Add("PORT_OF_DESTINATION", System.Type.GetType("System.String"));
            order_head.Columns.Add("PENALTY_DESC", System.Type.GetType("System.String"));
            row = order_head.NewRow();

        }

        public static bool IsDesignMode()
        {
            bool returnFlag = false;
            if (LicenseManager.UsageMode == LicenseUsageMode.Designtime)
            { returnFlag = true; }
            else if (Process.GetCurrentProcess().ProcessName == "devenv")
            { returnFlag = true; }
            return returnFlag;
        }

        private void ultraOrderText_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            if (ultraOrderText.Text.Trim() != "")
            {
                if (MessageUtil.ShowYesNoAndQuestion("是否清空合同号？") == DialogResult.No) return;
                ultraOrderText.Text = "";
                row["ORDER_NO"] = "";
                order.Tables["SLM_ORDER_HEAD"].Rows[0]["ORDER_NO"] = "";
            }
        }

        /// <summary>
        /// 根据合同大类型加载相应的合同类型
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void cmbOrdBigType_ValueChanged(object sender, EventArgs e)
        {
            if (cmbOrdBigType.SelectedItem != null)
            {
                string bigType = cmbOrdBigType.Value.ToString();
                DataTable unLoad = ServerHelper.GetData("com.steering.pss.sale.order.CopyCtrlOrderHead.doQueryOrderType", new Object[] { bigType }, ob);
                OrderTypeCombo.DataSource = unLoad;
                OrderTypeCombo.DisplayMember = "BASENAME";
                OrderTypeCombo.ValueMember = "BaseCODE";
                if (bigType == "Y")
                {
                    OrderTypeCombo.Value = "120103";
                }
                else if (bigType == "Q")
                {
                    OrderTypeCombo.Value = "120101";
                }
                else if (bigType == "X")
                {
                    OrderTypeCombo.Value = "120102";
                }
                else if (bigType == "P")
                {
                    OrderTypeCombo.Value = "120104";
                }
                else if (bigType == "S")
                {
                    OrderTypeCombo.Value = "120108";
                }
                else if (bigType == "D")
                {
                    OrderTypeCombo.Value = "120109";
                }
                else if (bigType == "L")
                {
                    OrderTypeCombo.Value = "120107";
                }
            }
        }

        /// <summary>
        /// 当地法律法规编辑
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void txtLocLaw_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            string str = txtLocLaw.Text.Trim();
            PopupTextBox ptb = new PopupTextBox(str);
            ptb.TxtInfo.ReadOnly = false;
            ptb.TxtInfo.Font = new Font("宋体", 11, FontStyle.Regular);
            ptb.Text = "当地法律法规要求";
            ptb.ShowDialog();

            if (ptb.DialogResult != DialogResult.OK)
                return;
            if (ptb.TextInfo.Trim() != "")
                this.txtLocLaw.Text = ptb.TextInfo.Trim();
        }

        private void utSaleorg_ValueChanged(object sender, EventArgs e)
        {
            if (utSaleorg.SelectedIndex == -1)
                utSaleorg.SelectedIndex = 0;
            saleorg = utSaleorg.Value.ToString();
            //贸易类型
            LoadTradeType(saleorg);
            //销售片区
            LoadSalesArea(saleorg, listDept);
            saleorgHander(saleorg);
        }

        private void documentaryNameEditor_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            dlgUserOnDept userOnDept = new dlgUserOnDept(ob);
            if (userOnDept.ShowDialog() == DialogResult.OK)
            {
                documentaryName.Text = userOnDept.SelectRow.Cells["username"].Value.ToString();
                documentaryDept.Text = userOnDept.SelectRow.Cells["deptid"].Value.ToString();
            }
        }
    }
}