MES_Client/TGMES/Core.StlMes.Client.SaleOrder/Dialog/dlgOrderAskAdd.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.Mes.Client.Comm.Server;
using Infragistics.Win.UltraWinTree;
using System.Collections;
using Infragistics.Win.UltraWinGrid;
using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Format;
using Infragistics.Win.UltraWinEditors;
using Core.StlMes.Client.SaleComm;
using Core.Mes.Client.Comm.Tool;
using Newtonsoft.Json;

namespace Core.StlMes.Client.SaleOrder
{
    public delegate void dlgOrderAddAskHand(object sender, ReturnMessage e);
    public partial class dlgOrderAddAsk : FrmBase
    {
        public event dlgOrderAddAskHand dlgOrderAddAskHandEvent;
        private string finalCusterCode = "0101010102";
        private string finalCusterDesc = "";
        private string drAddAskNo = "";
        private string MSC = "MSC0000001001";
        private string errMessage = "";
        private string _addAskNo = "";
        private string std_code = "";
        private string addAskNos = "";
        private string ordLnPk = "";

        public string AddAskNos
        {
            get { return addAskNos; }
            set { addAskNos = value; }
        }
        int indexTree = 0;
        /// <summary>
        /// 附加要求分项
        /// </summary>
        private Dictionary<string, UltraComboEditor> itemSub = null;
        /// <summary>
        /// 标准说明
        /// </summary>
        private Dictionary<string, UltraComboEditor> askSubItme = null;
        /// <summary>
        /// 传入行（合同从数据信息）
        /// </summary>
        private DataRow dr;
        /// <summary>
        /// 下拉框
        /// </summary>
        private UltraComboEditor[] ultras = new UltraComboEditor[1];

        private bool isQueryStd = true;

        /// <summary>
        /// 是否查询标准信息
        /// </summary>
        public bool IsQueryStd
        {
            get { return isQueryStd; }
            set { isQueryStd = value; }
        }

        public DataRow Dr
        {
            get { return dr; }
            set { dr = value; }
        }

        //是否是技术评审弹窗。
        private bool isPopup = false;

        public bool IsPopup
        {
            get { return isPopup; }
            set { isPopup = value; }
        }
        /// <summary>
        /// OB对象
        /// </summary>
        private OpeBase _ob = null;

        public OpeBase Ob
        {
            get { return _ob; }
            set { _ob = value; }
        }

        private ArrayList _addAskData;

        public dlgOrderAddAsk()
        {
            InitializeComponent();
            ExceptionHelper.RegistException();
        }

        private string _str = "";
        public dlgOrderAddAsk(string addKey, string str)
        {
            InitializeComponent();
            _addAskNo = addKey;
            _str = str;
        }

        /// <summary>
        /// 弹窗引用时调用。
        /// </summary>
        public void PopupLoad(OpeBase ob)
        {
            this._ob = ob;
            base.OnLoad(EventArgs.Empty);
        }

        public delegate void HUpdateAskAdd(bool b);
        public event HUpdateAskAdd UpdateAskAdd;



        private void dlgOrderAddAsk_Load(object sender, EventArgs e)
        {
            _addAskNo = this.addAskNos;
            CheckDr();
            //_ob = this.ob;
            InitDrop();
            CreateItemSub();
            if (_str.Equals("1"))
            {
                ultraToolbarsManager1.Visible = false;
                //string user = dr["FINAL_USER"].ToString();
                QueryAskAdd(MSC, _addAskNo);

                for (int i = 0; i < ultraGrid1.Rows.Count; i++)
                {
                    for (int j = 0; j < ultraGrid1.Rows[i].Cells.Count; j++)
                    {
                        ultraGrid1.Rows[i].Cells[j].Activation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                    }
                }
            }
            DoQuery();

            if (isPopup)
            {
                ultraGrid1.DisplayLayout.Override.AllowDelete = Infragistics.Win.DefaultableBoolean.False;
                ultraGrid1.DisplayLayout.Override.AllowUpdate = Infragistics.Win.DefaultableBoolean.False;
                ultraGrid1.DisplayLayout.Override.AllowAddNew = AllowAddNew.No;
            }
        }
        /// <summary>
        /// 判断传入的行数据是否符合要要求
        /// </summary>
        private void CheckDr()
        {
            if (dr == null)
            { return; }
            //if (dr["MSC"].ToString().Equals(""))
            //{ return; }
            if (dr["FINAL_USER"].ToString().Equals(""))
            { return; }
            //MSC = dr["MSC"].ToString();
            finalCusterCode = dr["FINAL_USER"].ToString();
            finalCusterDesc = dr["FINAL_USER_DESC"].ToString();
            if (dr.Table.Columns.Contains("ADD_ASK_NO"))
            {
                drAddAskNo = dr["ADD_ASK_NO"].ToString();
            }
            TextCuster.Text = finalCusterDesc;
            std_code = dr["STD_CODE"].ToString();
            if (dr.Table.Columns.Contains("ORD_LN_PK"))
            {
                ordLnPk = dr["ORD_LN_PK"].ToString();
            }
        }

        private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
        {
            switch (e.Tool.Key)
            {
                case "doQuery":
                    DoQuerys();
                    break;
                case "新增":
                    DoSave();
                    break;
                case "doConfrim":
                    DoComfirm();
                    break;
                case "作废":
                    DoDelete();
                    break;
                case "doClose":
                    ((Form)ultraToolbarsManager1.DockWithinContainer.TopLevelControl).Close();
                    break;
                default:
                    break;
            }
        }

        private void DoDelete()
        {
            string key = ultraTree.ActiveNode.Key;
            if (key == "CUSTADDKEY")
            {
                MessageUtil.ShowWarning("请选择需要作废的附加要求码！");
            }
            else
            {
                if (key.Substring(0, 3).ToUpper().Equals("STD"))
                {
                    MessageUtil.ShowWarning("请选择需要作废的附加要求码！");
                }
                else
                {
                    DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderAddAsk.getSlmOrdLineCntByAskNo",
                        new object[] { key }, _ob);
                    if (dt.Rows.Count > 0)
                    {
                        MessageUtil.ShowWarning(string.Format("该附加要求已被合同[{0}]-合同行[{1}]引用，不能作废！",
                            dt.Rows[0]["ORDER_NO"].ToString2(), dt.Rows[0]["ORDER_SEQ"].ToString2()));
                        return;
                    }
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认作废选中的附加要求码？") == DialogResult.No)
                    {
                        return;
                    }
                    ServerHelper.SetData("com.steering.pss.sale.order.CoreOrderAddAsk.deleteSlmOrdAddAsk",
                        new object[] { key, UserInfo.GetUserName() }, _ob);
                    MessageUtil.ShowTips("作废成功！");
                    DoQuery();
                }
            }
        }

        private void DoQuerys()
        {
            addAskNos = "";
            ultraTree.Nodes["CUSTADDKEY"].Nodes.Clear();
            if (isQueryStd)
            {
                DataTable dtAskAdds = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderAddAsk.queryBaseAskAddCode",
                    new Object[] { std_code }, this._ob);
                CreateTree(dtAskAdds, "CUSTADDKEY", "STD_CODE", "STD_NAME");
            }
            DataTable dtAskAdd = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderAddAsk.queryAddAskCode",
                new Object[] { finalCusterCode, drAddAskNo }, this._ob);
            CreateTree(dtAskAdd, "CUSTADDKEY", "ADD_ASK_NO", "CUSTOMER_NM");
            ultraTree.ExpandAll();
            dataTable1.Rows.Clear();

            if (ultraTree.Nodes["CUSTADDKEY"].Nodes.Count > 0)
            {
                ultraTree.ActiveNode = ultraTree.Nodes["CUSTADDKEY"].Nodes[0];
                _addAskNo = ultraTree.Nodes["CUSTADDKEY"].Nodes[0].Key;
            }
        }

        private void DoQuery()
        {
            //ultraTree.Nodes["CUSTADDKEY"].Nodes.Clear();
            //DataTable dtAskAdds = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderAddAsk.queryBaseAskAddCode", new Object[] { std_code }, this._ob);
            //CreateTree(dtAskAdds, "CUSTADDKEY", "STD_CODE", "STD_NAME"); 
            //DataTable dtAskAdd = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderAddAsk.queryAddAskCode", new Object[] { finalCusterCode }, this._ob);
            //CreateTree(dtAskAdd, "CUSTADDKEY", "ADD_ASK_NO", "ADD_ASK_NO");
            //ultraTree.ExpandAll();
            //dataTable1.Rows.Clear();
            //if (!_addAskNo.Equals(""))
            //{
            //    ultraTree.Nodes["CUSTADDKEY"].Nodes[_addAskNo].CheckedState = CheckState.Checked; 
            //}

            ultraTree.Nodes["CUSTADDKEY"].Nodes.Clear();
            if (isQueryStd == true)
            {
                DataTable dtAskAdds = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderAddAsk.queryBaseAskAddCode", new Object[] { std_code }, this._ob);
                CreateTree(dtAskAdds, "CUSTADDKEY", "STD_CODE", "STD_NAME");
            }
            DataTable dtAskAdd = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderAddAsk.queryAddAskCode", new Object[] { finalCusterCode, drAddAskNo }, this._ob);
            CreateTree(dtAskAdd, "CUSTADDKEY", "ADD_ASK_NO", "CUSTOMER_NM");
            ultraTree.ExpandAll();
            dataTable1.Rows.Clear();
            if (!_addAskNo.Equals(""))
            {

                for (int i = 0; i < ultraTree.Nodes["CUSTADDKEY"].Nodes.Count; i++)
                {
                    if (ultraTree.Nodes["CUSTADDKEY"].Nodes[i].Key.Equals(_addAskNo))
                    {
                        ultraTree.ActiveNode = ultraTree.Nodes["CUSTADDKEY"].Nodes[i];
                        ultraTree.ActiveNode.Selected = true;
                    }
                }
            }
            else
            {
                if (ultraTree.Nodes["CUSTADDKEY"].Nodes.Count > 0)
                {
                    ultraTree.ActiveNode = ultraTree.Nodes["CUSTADDKEY"].Nodes[0];
                    ultraTree.ActiveNode.Selected = true;
                    _addAskNo = ultraTree.Nodes["CUSTADDKEY"].Nodes[0].Key;
                }
            }

        }

        /// <summary>
        /// 生成树
        /// </summary>
        /// <param name="dt">DataTable</param>
        /// <param name="key">key</param>
        /// <param name="showValue">显示值</param>
        private void CreateTree(DataTable dt, string key, string hideValue, string showValue)
        {
            if (dt == null || dt.Rows.Count == 0)
            {
                return;
            }
            UltraTreeNode utn = null;
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                utn = new UltraTreeNode(dt.Rows[i][hideValue].ToString(), dt.Rows[i][showValue].ToString());
                ultraTree.Nodes[key].Nodes.Add(utn);
            }

        }

        /// <summary>
        /// 保存
        /// </summary>
        private void DoSave()
        {
            string stdCode = "";
            if (ultraTree.ActiveNode.Parent != null)
            {
                if (ultraTree.ActiveNode.Parent.Nodes[0].Key.Substring(0, 3).ToUpper().Equals("STD"))
                {
                    stdCode = ultraTree.ActiveNode.Parent.Nodes[0].Key;
                }
            }

            int count = 0;
            if (CheckData(false) == false) return;
            if (MessageUtil.ShowYesNoAndQuestion("是否保存记录？") == DialogResult.No)
            {
                return;
            }
            string askID = "";

            askID = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderAddAsk.getADDASK", 
                new Object[] { finalCusterCode }, this._ob).Rows[0][0].ToString();
            

            count = ServerHelper.SetData("com.steering.pss.sale.order.CoreOrderAddAsk.addAskAdd",
                new Object[] { _addAskData, askID, _addAskNo, stdCode}, this._ob);
                _addAskNo = askID;
            if (count > 0)
            {
                MessageUtil.ShowTips("保存成功！");
                CreateItemSub();
                DoQuery();
            }

        }

        private bool CheckData(bool isDoConfirm)
        {
            ultraGrid1.UpdateData();
            if (finalCusterCode.Equals("") || MSC.Equals("") || addAskNos == "")
            {
                return false;
            }

            //if (isDoConfirm == false)
            //{
            //    if (addAskNos.Substring(0, 3).ToUpper().Equals("STD") == false)
            //    {
            //        string addAskState = getAskAddState(addAskNos).Rows[0]["ADD_ASK_STATUS"].ToString();
            //        int ordLnRefAddAskCnt = GetOrdLnRefAddAskCnt(addAskNos, ordLnPk);
            //        if (isInsert == false)
            //        {
            //            if (addAskState == "S")
            //            {
            //                MessageUtil.ShowWarning("该附加要求为评审通过状态，不能修改！");
            //                return false;
            //            }
            //            else if ((addAskState == "W" || addAskState == "F") && ordLnRefAddAskCnt >= 1)
            //            {
            //                MessageUtil.ShowWarning("该附加要求已被其他的合同行使用，不能修改！");
            //                return false;
            //            }
            //        }
            //    }
            //}

            _addAskData = new ArrayList();
            int chkCount = ultraGrid1.Rows.AsQueryable().Where("CHC = 'True'").Count();
            if (chkCount == 0)
            {
                MessageUtil.ShowWarning("请选择一条记录，然后再进行操作！");
                return false;
            }
            int askSubItemCount = ultraGrid1.Rows.AsQueryable().Where("CHC = 'True'").GroupBy(a => a.GetValue("ASK_SUB_ITME")).Count();
            if (chkCount > askSubItemCount)
            {
                MessageUtil.ShowWarning("不能保存两条相同的附加要求项！");
                return false;
            }

            foreach (UltraGridRow ugr in ultraGrid1.Rows)
            {
                if (Convert.ToBoolean(ugr.Cells["CHC"].Value))
                {
                    SlmOrderAddAskObject com = GetObjectData.GetSlmOrderAddAskData(ugr);
                    com.CustomerNm = finalCusterDesc;
                    com.CustomerNo = finalCusterCode;
                    if (ultraTree.ActiveNode.Key == "CUSTADDKEY"
                        || ultraTree.ActiveNode.Key.Substring(0, 3).ToUpper().Equals("STD") == false)
                    {
                        //com.AskSubItmeVal = ugr.GetValue("ASK_SUB_ITME_VAL");
                        //com.AskSubItmeValDesc = ugr.GetValue("ASK_SUB_ITME_VAL_DESC");
                        //slmOrderAddAsk.AskItmeOld = slmOrderAddAsk.AskItme;
                        //slmOrderAddAsk.AskSubItmeOld = slmOrderAddAsk.AskSubItme;
                        //slmOrderAddAsk.AddAskStatus = "S";
                    }
                    else
                    {
                        com.AskSubItmeVal = com.AskSubItmeVal == ""
                            ? ugr.GetValue("ASK_SUB_ITME_VAL") : com.AskSubItmeVal;
                        com.AskSubItmeValDesc = com.AskSubItmeValDesc == ""
                            ? ugr.GetValue("ASK_SUB_ITME_VAL_DESC") : com.AskSubItmeValDesc;
                    }
                    if (!CheckAddAsk(com))
                    {
                        MessageBox.Show(errMessage, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        return false;
                    }
                    _addAskData.Add(JsonConvert.SerializeObject(com));

                }
            }

            object[] isSameData = checkIsSameData(_addAskData);
            if (isDoConfirm == false && isSameData[0].ToString() == "True")
            {
                MessageUtil.ShowWarning("系统已存在相同的一套附加要求[" + isSameData[1].ToString() + "]！");
                foreach (UltraTreeNode node in ultraTree.Nodes["CUSTADDKEY"].Nodes)
                {
                    if (node.Key == isSameData[1].ToString())
                    {
                        dataTable1.AcceptChanges();
                        ultraTree.ActiveNode = node;
                        break;
                    }
                }
                return false;
            }

            return true;
        }

        private DataTable getAskAddState(string askAddNo)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderAddAsk.getAddAskState",
                new object[] { askAddNo }, _ob);
            return dt;
        }

        private int GetOrdLnRefAddAskCnt(string askAddNo, string ordLnPk)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderAddAsk.getOrdLnRefAddAskCnt",
                new object[] { askAddNo, ordLnPk }, _ob);

            return int.Parse(dt.Rows[0][0].ToString());
        }

        private bool isExistAddAsk(string addAskNo, string askItem, string askSubItem)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderAddAsk.isExistAddAsk",
                new object[] { addAskNo, askItem, askSubItem }, _ob);
            if (dt.Rows[0][0].ToString() != "0")
            {
                return true;
            }

            return false;
        }

        /// <summary>
        /// 查询附加要求
        /// </summary>
        /// <param name="msc"></param>
        /// <param name="stdCode"></param>
        private void QueryAskAdd(string stdCode, string askAddNo)
        {
            DataTable dt = null;
            if (askAddNo.Substring(0, 3).ToUpper().Equals("STD"))
            {
                dt = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderAddAsk.queryAddAsk", 
                    new Object[] { stdCode, askAddNo }, this._ob);
            }
            else 
            {
                dt = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderAddAsk.queryAddOrderAsk",
                    new Object[] { stdCode, askAddNo }, this._ob);
            }
            if (dt != null && dt.Rows.Count > 0)
            {
                GridHelper.CopyDataToDatatable(ref dt, ref this.dataTable1, true);
                //OrderSpecialInfoTool.SetUltraGridNoEdit(ultraGrid1);

            }
            else
            {
                dataTable1.Rows.Clear();
            }
            foreach (UltraGridRow row in ultraGrid1.Rows)
            {
                row.Cells["CHC"].Value = true;
                SetIsAllowEdit(row);
            }
            dataTable1.AcceptChanges();
            ultraGrid1.UpdateData();
        }

        private void DoComfirm()
        {
            if (ultraTree.ActiveNode.Parent == null) return;

            string stdCode = "";
            if (ultraTree.ActiveNode.Parent.Nodes[0].Key.Substring(0, 3).ToUpper().Equals("STD"))
            {
                stdCode = ultraTree.ActiveNode.Parent.Nodes[0].Key;
            }

            //if (addAskNos.Substring(0, 3).ToUpper().Equals("STD"))
            //{
            //    isInsert = true;
            //}
            //else
            //{
            //    string addAskState = getAskAddState(addAskNos).Rows[0]["REVIEW_F_RS"].ToString();
            //    int ordLnRefAddAskCnt = GetOrdLnRefAddAskCnt(addAskNos, ordLnPk);
            //    if (addAskState == "S" || ordLnRefAddAskCnt >= 1)
            //    {
            //        isInsert = true;
            //    }
            //    else
            //    {
            //        isInsert = false;
            //    }
            //}

            if (!CheckData(true)) return;
            if (MessageUtil.ShowQuestion("是否确认?") == DialogResult.No)
            {
                return;
            }
            ReturnMessage e = new ReturnMessage();
            e.Message = GetSpecialInfo();
            object[] isSameData = checkIsSameData(_addAskData);
            if (isSameData[0].ToString() == "False")
            {
                string askID = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderAddAsk.getADDASK", 
                    new Object[] { finalCusterCode }, this._ob).Rows[0][0].ToString();
                int count = ServerHelper.SetData("com.steering.pss.sale.order.CoreOrderAddAsk.addAskAdd",
                    new Object[] { _addAskData, askID, _addAskNo, stdCode}, this._ob);
                if (count == 0) return;
                e.AddAskNo = askID;
            }
            else
            {
                e.AddAskNo = isSameData[1].ToString();
            }

            dlgOrderAddAskHandEvent.Invoke(this, e);
            this.DialogResult = DialogResult.OK;
        }

        private string GetSpecialInfo()
        {
            string value = "";
            UltraGridRow[] rows = ultraGrid1.Rows.AsQueryable().Where("CHC = 'True'").OrderBy(
                a => a.GetText("ASK_ITME")).ThenBy(a => a.GetText("ASK_SUB_ITME")).ToArray();
            foreach (UltraGridRow row in rows)
            {
                if (value != "")
                {
                    value += "\r\n";
                }
                string askSubItemValDesc = row.GetText("ASK_SUB_ITME_VAL_DESC1").Trim() == ""
                    ? row.GetText("ASK_SUB_ITME_VAL_DESC") : row.GetText("ASK_SUB_ITME_VAL_DESC1").Trim();
                value += row.GetText("ASK_SUB_ITME") + ":" + askSubItemValDesc;
            }

            return value;
        }

        private object[] checkIsSameData(ArrayList addAskData)
        {
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.sale.order.CoreOrderAddAsk";
            ccp.MethodName = "checkIsSameData";
            ccp.ServerParams = new object[] { addAskData, finalCusterCode};
            ccp = Ob.ExecuteQuery(ccp, CoreInvokeType.Internal);
            return (object[])ccp.ReturnObject;
        }

        private bool CheckAddAsk(SlmOrderAddAskObject com)
        {
            if (com.AskItme.Equals(""))
            {
                errMessage = "附加要求：请选择附加要求项";
                return false;
            }
            if (com.AskSubItme.Equals(""))
            {
                errMessage = "附加要求：请选择附加要求分项";
                return false;
            }
            if (ultraTree.ActiveNode.Key == "CUSTADDKEY"
                        || ultraTree.ActiveNode.Key.Substring(0, 3).ToUpper().Equals("STD") == false)
            {
                if (com.AskSubItmeVal.Equals(""))
                {
                    errMessage = "附加要求：请选择客户标准说明";
                    return false;
                }
            }
            //string askAddState = getAskAddState(com.AddAskNo);
            //if (com.AddAskNo != "" && com.AskItmeOld != "" && askAddState != "W" && askAddState != "F")
            //{
            //    errMessage = "只能操作待评审和评审失败的附加要求！";
            //    return false;
            //}

            //if (com.AskItmeOld != com.AskItme || com.AskSubItmeOld != com.AskSubItme)
            //{
            //    if (isExistAddAsk(com.AddAskNo, com.AskItme, com.AskSubItme) == true)
            //    {
            //        errMessage = "附加要求码：" + com.AddAskNo + " 已存在相同的附加要求项和附加要求分项！";
            //        return false;
            //    }
            //}
            return true;
        }

        /// <summary>
        /// 初始化下拉框
        /// </summary>
        private void InitDrop()
        {

            for (int i = 0; i < ultras.Length; i++)
            {
                ultras[i] = new UltraComboEditor();
                Controls.Add(ultras[i]);
                ultras[i].Visible = false;
            }

            //附加项
            OrderSpecialInfoTool.NitializeAskIime(ultras[0], false, this._ob);
            OrderSpecialInfoTool.BindColumn(ultras[0], "ASK_ITME", ultraGrid1.DisplayLayout.Bands[0]);

        }


        /// <summary>
        /// 生成附加要求下拉框
        /// </summary>
        private void CreateItemSub()
        {
            int count = ultras[0].Items.Count;
            itemSub = new Dictionary<string, UltraComboEditor>();
            askSubItme = new Dictionary<string, UltraComboEditor>();
            for (int i = 0; i < count; i++)
            {
                string itemCode = ultras[0].Items[i].DataValue.ToString();
                if (itemSub.ContainsKey(itemCode) == false)
                {
                    DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreProductManage.getSubItem", 
                        new Object[] { itemCode, ""}, this._ob);
                    UltraComboEditor uce = new UltraComboEditor();
                    uce.DataSource = dt;
                    uce.DisplayMember = "ASK_ITEM_DESC";
                    uce.ValueMember = "ASK_ITEM_NO";
                    Controls.Add(uce);
                    uce.Visible = false;
                    itemSub.Add(itemCode, uce);
                }
                for (int j = 0; j < itemSub[itemCode].Items.Count; j++)
                {
                    string subCode = itemSub[itemCode].Items[j].DataValue.ToString();
                    if (askSubItme.ContainsKey(subCode) == false)
                    {
                        DataTable dtSub = ServerHelper.GetData("com.steering.pss.qcm.CoreProductManage.getSubItem",
                            new Object[] { subCode, "1"}, this._ob);
                        UltraComboEditor uceSub = new UltraComboEditor();
                        uceSub.DataSource = dtSub;
                        uceSub.DisplayMember = "ASK_ITEM_DESC";
                        uceSub.ValueMember = "ASK_ITEM_NO";
                        uceSub.DropDownListWidth = -1;
                        EditorButton button = new EditorButton();
                        button.Text = "编辑";
                        uceSub.EditorButtonClick += new EditorButtonEventHandler(uceSub_EditorButtonClick);
                        uceSub.ButtonsRight.Add(button);
                        Controls.Add(uceSub);
                        uceSub.Visible = false;
                        askSubItme.Add(subCode, uceSub);
                    }
                }
            }

            foreach (UltraGridRow row in ultraGrid1.Rows)
            {
                BandItemSub(row);
            }
        }

        private void uceSub_EditorButtonClick(object sender, EditorButtonEventArgs e)
        {
            UltraGridRow row = ultraGrid1.ActiveRow;
            if (row == null) return;
            PopupTextBox popupTextBox = new PopupTextBox(row.GetText("ASK_SUB_ITME_VAL1").Trim());
            if (row.Cells["ASK_SUB_ITME_VAL1"].Style == Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList)
            {
                popupTextBox.TxtInfo.ReadOnly = true;
            }
            if (popupTextBox.ShowDialog() == DialogResult.OK)
            {
                row.Cells["ASK_SUB_ITME_VAL1"].Value = popupTextBox.TextInfo;//
                row.Cells["ASK_SUB_ITME_VAL_DESC1"].Value = popupTextBox.TextInfo;
            }
        }

        /// <summary>
        /// 绑定附加要求下拉框
        /// </summary>
        /// <param name="e"></param>
        private void BandItemSub(UltraGridRow row)
        {
            string itemCode = row.Cells["ASK_ITME"].Value.ToString();
            if (itemSub.ContainsKey(itemCode))
            {
                row.Cells["ASK_SUB_ITME"].EditorComponent = itemSub[itemCode];

            }
            string subCode = row.Cells["ASK_SUB_ITME"].Value.ToString();
            if (askSubItme.ContainsKey(subCode))
            {
                row.Cells["ASK_SUB_ITME_VAL1"].EditorComponent = askSubItme[subCode];

            }
            
            row.Cells["ASK_SUB_ITME"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
        }

        private void SetIsAllowEdit(UltraGridRow row)
        {
            string subCode = row.Cells["ASK_SUB_ITME"].Value.ToString();
            DataRow drBaseAddAsk = GetSlmBaseAddaskByPk(subCode);
            if (drBaseAddAsk != null && drBaseAddAsk["IS_ALLOW_EDIT"].ToString() == "1")
            {
                row.Cells["ASK_SUB_ITME_VAL1"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDown;
            }
            else
            {
                row.Cells["ASK_SUB_ITME_VAL1"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            }
        }

        /// <summary>
        /// 通过主键查询附加要求
        /// </summary>
        /// <param name="askItemNo"></param>
        /// <returns></returns>
        private DataRow GetSlmBaseAddaskByPk(string askItemNo)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreBaseAddAsk.getSlmBaseAddaskByPk",
                new object[] { askItemNo }, _ob);
            if (dt.Rows.Count > 0)
            {
                return dt.Rows[0];
            }
            else
            {
                return null;
            }
        }

        private void ultraGrid1_InitializeRow(object sender, InitializeRowEventArgs e)
        {
            BandItemSub(e.Row);
            ControlGridEdit(e.Row);
            if (e.Row.Cells["IS_OTHER"].Value.ToString() == "True")
            {
                e.Row.Appearance.BackColor = Color.FromArgb(67, 205, 128);
                e.Row.Cells["ASK_SUB_ITME_VAL1"].Appearance.BackColor = e.Row.Appearance.BackColor;
                e.Row.Cells["ASK_SUB_ITME"].Appearance.BackColor = e.Row.Appearance.BackColor;
                e.Row.Cells["ASK_ITME"].Appearance.BackColor = e.Row.Appearance.BackColor;
            }
        }

        private void ControlGridEdit(UltraGridRow row)
        {
            if (row.GetValue("CHC") == "True")
            {
                for (int i = 0; i < row.Cells.Count; i++)
                {
                    row.Cells[i].Activation = Activation.AllowEdit;
                }
            }
            else
            {
                for (int i = 0; i < row.Cells.Count; i++)
                {
                    if (row.Cells[i].Column.Key == "CHC") continue;
                    row.Cells[i].Activation = Activation.ActivateOnly;
                }
            }
        }

        private void ultraGrid1_CellChange(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e)
        {
            if (e.Cell.Column.Key == "PIC1")
            {
                foreach (DataRow dr in dataTable1.Rows)
                {
                    if (dr.RowState == DataRowState.Added || dr.RowState == DataRowState.Modified) continue;
                    ultraGrid1.UpdateData();
                    dataTable1.AcceptChanges();
                }
            }

            ultraGrid1.UpdateData();
            //if(dataTable1.Rows.Count>0)
            //{
            //    if (dataTable1.Rows[0]["ADD_ASK_STATUS"].ToString().ToUpper().Equals("S")) 
            //    {
            //        ultraGrid1.BeginUpdate();
            //        e.Cell.Row.Cells["CHC"].Value = false;
            //        MessageBox.Show("评审通过不允许修改！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            //        ultraGrid1.EndUpdate();
            //        return;
            //    }
            //}
            if (e.Cell.Column.Key.Equals("ASK_ITME"))
            {
                e.Cell.Row.Cells["ASK_SUB_ITME"].Activation = Activation.AllowEdit;
                e.Cell.Row.Cells["ASK_ITME_DESC"].Value = e.Cell.Text;
                e.Cell.Row.Cells["ASK_SUB_ITME"].Value = "";
                e.Cell.Row.Cells["ASK_SUB_ITME_DESC"].Value = "";
                e.Cell.Row.Cells["ASK_SUB_ITME_VAL1"].Value = "";
                e.Cell.Row.Cells["ASK_SUB_ITME_VAL_DESC1"].Value = "";
            }
            if (e.Cell.Column.Key.Equals("ASK_SUB_ITME"))
            {
                e.Cell.Row.Cells["ASK_SUB_ITME_VAL1"].Activation = Activation.AllowEdit;
                e.Cell.Row.Cells["ASK_SUB_ITME_DESC"].Value = e.Cell.Text;
                e.Cell.Row.Cells["ASK_SUB_ITME_VAL1"].Value = "";
                e.Cell.Row.Cells["ASK_SUB_ITME_VAL_DESC1"].Value = "";

                SetIsAllowEdit(e.Cell.Row);
            }
            if (e.Cell.Column.Key.Equals("ASK_SUB_ITME_VAL1"))
            {
                if (e.Cell.Row.Cells["ASK_ITME"].Value.ToString() == "")
                {
                    MessageUtil.ShowWarning("请先选择附加要求项");
                    e.Cell.Value = "";
                    e.Cell.Row.Cells["ASK_ITME"].Activate();
                    return;
                }
                if (e.Cell.Row.Cells["ASK_SUB_ITME"].Value.ToString() == "")
                {
                    MessageUtil.ShowWarning("请先选择附加要求分项");
                    e.Cell.Value = "";
                    e.Cell.Row.Cells["ASK_SUB_ITME"].Activate();
                    return;
                }
                e.Cell.Row.Cells["ASK_SUB_ITME_VAL1"].Activation = Activation.AllowEdit;
                e.Cell.Row.Cells["ASK_SUB_ITME_VAL_DESC1"].Value = e.Cell.Text;
            }
        }

        private void ultraGrid1_AfterRowInsert(object sender, RowEventArgs e)
        {
            if ("1".Equals(_str))
            {
                for (int j = 0; j < e.Row.Cells.Count; j++)
                {
                    e.Row.Cells[j].Activation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                }
            }
            else
            {
                OrderSpecialInfoTool.SetInsertRowUnEdit(ultraGrid1, e);
            }
        }

        private void ultraToolbarsManager2_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
        {
            switch (e.Tool.Key)
            {
                case "doReviewPass":
                    doReviewPass();
                    break;
                case "doReviewFailure":
                    doReviewFailure();
                    break;
                case "doClose":
                    this.Close();
                    break;
                default:
                    break;
            }

        }

        /// <summary>
        /// 评审不通过
        /// </summary>
        private void doReviewFailure()
        {
            if (ultraGrid1.ActiveRow == null)
            {
                MessageBox.Show("当前无选中附加要求。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                return;
            }
            int i = ServerHelper.SetData("com.steering.pss.sale.order.CoreOrderAddAsk.UpdateAskAddStatus",
                new Object[] { _addAskNo, false }, this.Ob);
            if (i > 0)
            {
                UpdateAskAdd(false);
                this.Close();
            }

        }

        /// <summary>
        /// 评审通过
        /// </summary>
        private void doReviewPass()
        {
            if (ultraGrid1.ActiveRow == null)
            {
                MessageBox.Show("当前无选中附加要求。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                return;
            }
            int i = ServerHelper.SetData("com.steering.pss.sale.order.CoreOrderAddAsk.UpdateAskAddStatus",
                new Object[] { _addAskNo, true }, this.Ob);
            if (i > 0)
            {
                UpdateAskAdd(true);
                this.Close();
            }
        }

        private void CheckProduct_CheckedChanged(object sender, EventArgs e)
        {
        }

        private void CheckPscDesc_CheckedChanged(object sender, EventArgs e)
        {
        }

        private void CheckCustomer_CheckedChanged(object sender, EventArgs e)
        {
            if (CheckCustomer.Checked)
            {
                TextCuster.ReadOnly = false;
            }
            else 
            {
                TextCuster.ReadOnly = true;
            }
        }

        private void askItemImg_EditorButtonClick(object sender, EditorButtonEventArgs e)
        {
            if (string.IsNullOrEmpty(_addAskNo) && ultraGrid1.ActiveRow != null)
            {
                return;
            }
            bool isModify = false;
            foreach (DataRow dr in dataTable1.Rows)
            {
                if (dr.RowState == DataRowState.Added || dr.RowState == DataRowState.Modified)
                {
                    isModify = true;
                    break;
                }
            }
            UltraGridRow row = ultraGrid1.ActiveRow;
            string askSubItem = row.GetValue("ASK_SUB_ITME");
            string filePath = "sale/ordAsk/" + _addAskNo + "/" + askSubItem;
           
            if (e.Button.Key.ToLower().Equals("select"))
            {
                dlgOrderAskDown down = new dlgOrderAskDown(this.ob, filePath);
                if (isPopup)
                {
                    down.DeleteButton.Visible = false;
                }
                down.ShowDialog();
                if (down.CtrlFileDown1.List.Count == 0)
                {
                    UpdatePic("", _addAskNo, askSubItem);
                    row.Cells["PIC1"].Value = "";
                }
                else
                {
                    UpdatePic(filePath, _addAskNo, askSubItem);
                    row.Cells["PIC1"].Value = "存在附加要求文件";
                }
            }
            if (e.Button.Key.ToLower().Equals("choice") && isPopup == false)
            {
                if (_addAskNo.Substring(0, 3).ToUpper().Equals("STD"))
                {
                    MessageUtil.ShowWarning("标准的附加要求，不能上传图片！");
                    return;
                }
                bool isUpload = false;
                List<FileBean> list = new List<FileBean>();
                FileBean bean = new FileBean();
                OpenFileDialog file = new OpenFileDialog();
                file.Multiselect = true;
                file.Title = "选择需要上传的图片";
                file.Filter = "图片文件(*.jpg);(*.gif);(*.png);(*.bmp)|*.jpg;*.gif;*.png;*.bmp";
                DialogResult drStat;                        //LX 修改
                drStat = file.ShowDialog();                 //LX 修改

                if (drStat == DialogResult.OK)  //|| file.ShowDialog() == DialogResult.Yes ---LX 修改 
                {
                    foreach (string fileName in file.FileNames)
                    {
                        bean = new FileBean();
                        string filena = System.IO.Path.GetFileName(fileName);
                        if (filena.Contains(" "))
                        {
                            MessageUtil.ShowWarning("上传的图片名称不能包含空格！");
                            return;
                        }
                        bean.setFileName(filena);
                        bean.setPathName(filePath);
                        bean.setFile(FileHelper.FileToArray(fileName));
                        list.Add(bean);
                    }
                    bool isSuccess = Core.Mes.Client.Comm.Server.FileHelper.Upload(list);
                    if (isSuccess)
                    {
                        MessageBox.Show("上传成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Question);
                        isUpload = true;
                    }
                    else
                    {
                        isUpload = false;
                    }
                }
                else 
                {
                    isUpload = false;
                }
                if (isUpload)
                {
                    dlgOrderAskDown down = new dlgOrderAskDown(this.ob, filePath);
                    down.ShowDialog();
                    if (down.CtrlFileDown1.List.Count == 0)
                    {
                        UpdatePic("", _addAskNo, askSubItem);
                        row.Cells["PIC1"].Value = "";
                    }
                    else
                    {
                        UpdatePic(filePath, _addAskNo, askSubItem);
                        row.Cells["PIC1"].Value = "存在附加要求文件";
                    }
                }
            }
            if (isModify == false) dataTable1.AcceptChanges();
        }

        private void UpdatePic(string filePath, string addAskNo, string askSubItem)
        {
            ServerHelper.SetData("com.steering.pss.sale.order.CoreOrderAddAsk.setPic",
                    new object[] { filePath, addAskNo, askSubItem }, Ob);
        }

        private void ultraTree_AfterActivate(object sender, NodeEventArgs e)
        {
            this.Cursor = Cursors.WaitCursor;
            try
            {
                if (e.TreeNode.Parent != null && e.TreeNode.Parent.Key.Equals("CUSTADDKEY"))
                {
                    string addAskNo = e.TreeNode.Key.ToString();
                    //string user = dr["FINAL_USER"].ToString();
                    
                    if (addAskNo.Substring(0, 3).ToUpper().Equals("STD"))
                    {
                        if (isPopup == false)
                        {
                            ultraToolbarsManager1.Toolbars[0].Tools["新增"].SharedProps.Visible = true;
                        }
                    }
                    else
                    {
                        if (isPopup == false)
                        {
                            DataTable dt = getAskAddState(addAskNo);
                            string addAskState = dt.Rows[0]["ADD_ASK_STATUS"].ToString();
                            string reviewRs = dt.Rows[0]["REVIEW_F_RS"].ToString();
                            this.toolTip1.SetToolTip(ultraGrid1, reviewRs);
                            this.toolTip1.ToolTipTitle = "["+ addAskNo +"]附加要求失败原因：";
                            toolTip1.ShowAlways = true;
                            int ordLnRefAddAskCnt = GetOrdLnRefAddAskCnt(addAskNo, ordLnPk);
                            if (addAskState == "S" || ((addAskState == "W" || addAskState == "F") && ordLnRefAddAskCnt >= 1))
                            {
                                ultraToolbarsManager1.Toolbars[0].Tools["新增"].SharedProps.Visible = true;
                            }
                            else
                            {
                                ultraToolbarsManager1.Toolbars[0].Tools["新增"].SharedProps.Visible = true;
                            }
                        }
                    }
                    addAskNos = addAskNo;
                    QueryAskAdd(std_code, addAskNo);
                    _addAskNo = addAskNo;
                    ultraTree.Nodes["CUSTADDKEY"].Nodes[_addAskNo].CheckedState = CheckState.Checked;

                    //评审弹窗添加标准附加要求显示
                    if (isPopup)
                    {
                        DataTable dtOtherStdAddAsk = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderAddAsk.queryOtherStdAsk",
                            new object[] { std_code, addAskNo }, _ob);
                        GridHelper.CopyDataToDatatable(dtOtherStdAddAsk, dataTable1, false);
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally 
            {
                this.Cursor = Cursors.Default;
            }
        }

        private void ultraTree_BeforeActivate(object sender, CancelableNodeEventArgs e)
        {
            ultraGrid1.UpdateData();
            int dtChg1 = dataTable1.Rows.Cast<DataRow>().Where(a => a.RowState == DataRowState.Added
                || a.RowState == DataRowState.Modified).Count();
            if (dtChg1 > 0)
            {
                if (MessageUtil.ShowYesNoAndQuestion("附加要求有数据修改，是否放弃编辑？") == DialogResult.No)
                {
                    e.Cancel = true;
                    return;
                }
            }
        }

        private void dlgOrderAddAsk_FormClosing(object sender, FormClosingEventArgs e)
        {
            if (this.DialogResult != DialogResult.OK)
            {
                ultraGrid1.UpdateData();
                int dtChg1 = dataTable1.Rows.Cast<DataRow>().Where(a => a.RowState == DataRowState.Added
                    || a.RowState == DataRowState.Modified).Count();
                if (dtChg1 > 0)
                {
                    if (MessageUtil.ShowYesNoAndQuestion("附加要求有数据修改，是否退出？") == DialogResult.No)
                    {
                        e.Cancel = true;
                        return;
                    }
                }
            }
        }
    }

    public class ReturnMessage : EventArgs {
        private string addAskNo = "";

        public string AddAskNo
        {
            get { return addAskNo; }
            set { addAskNo = value; }
        }
        private string message = "";

        public string Message
        {
            get { return message; }
            set { message = value; }
        }
    }
}