using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using com.hnshituo.pur.vo;
using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
using CoreFS.CA06;using Pur.Entity;
using Infragistics.Win;
using Infragistics.Win.UltraWinEditors;
using Infragistics.Win.UltraWinGrid;
using CoreFS.SF01;
using Pur.Pop_upWindow;

namespace Pur.configure
{
    public partial class FrmOrgBudget : FrmPmsBase
    {
        public FrmOrgBudget()
        {
            InitializeComponent();
        }
        private void FrmOrgBudget_Load(object sender, EventArgs e)
        {
            Init();
            Query(true);
        }
        string errMsg = "";
        public List<CoreAppDepartment> _dtOrg = new List<CoreAppDepartment>();
        DataTable dt1;//部门信息
        #region toolbar工具栏
        /// <summary>
        /// toolbar
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    Query(true);
                    break;
                case "Query1":
                    Query(false);
                    break;
                case "Save":
                    DoSave();
                    break;
                case "Delete":
                    DeleteOrResume(true);
                    break;
                case "Resume":
                    DeleteOrResume(false);
                    break;
                case "Refresh":
                    Init();
                    break;
                case "Export":
                    GridHelper.ulGridToExcel(ultraGrid1, "部门预算管理数据");
                    break;
                case "Close":
                    this.Close();
                    break;
                case "Copy":
                    CopyData();
                    break;
            }
        }
        #endregion

        #region toolbar事件
        /// <summary>
        /// 查询
        /// </summary>
        /// <param name="Tips"></param>
        private void Query(bool Tips)
        {
            try
            {
                this.Cursor = Cursors.WaitCursor;
                String strDept = QdepartName.Text.ToString().Trim();
                String strYear = Qyear.Text.ToString().Trim();
                ConfigureOrgBudget bdg = new ConfigureOrgBudget();
                bdg.Departname = strDept;
                bdg.Year = strYear;
                bdg.Validflag = "1";
                if (Tips.Equals(false))
                {
                    bdg.Validflag = "";
                }
                DataTable dt = this.execute<DataTable>("com.hnshituo.pur.configure.service.ConfigureOrgBudgetService", "doQuery", new object[] { bdg });
                if (dt != null)
                {
                    GridHelper.CopyDataToDatatable(ref dt, ref dataTable1, true);
                }
                foreach (UltraGridRow rows in ultraGrid1.Rows)
                {
                    if (rows.GetCellValue("validflag").ToString() == "无效")
                    {
                        rows.Appearance.ForeColor = Color.Red;
                    }
                }
            }
            catch (Exception ex)
            {
                MessageUtil.ShowError("加载数据失败;" + ex);
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }

        }

        /// <summary>
        /// 作废和恢复
        /// </summary>
        /// <param name="tips"></param>
        private void DeleteOrResume(bool tips)
        {
            ultraGrid1.UpdateData();
            int i = 0;
            ArrayList list = new ArrayList();
            //作废
            if(tips==true)
            {
                foreach (UltraGridRow row in ultraGrid1.Rows)
                {
                    if (Convert.ToBoolean(row.Cells["CHK"].Value))
                    {
                        i++;
                        ConfigureOrgBudget res = new ConfigureOrgBudget();
                        String strId=row.Cells["ID"].Value.ToString().Trim();
                        String strValidFlag = "0";
                        res.Id = strId;
                        res.Validflag = strValidFlag;
                        res.DeleteName = UserInfo.GetUserName();
                        res.DeleteTime = new DateTime();
                        res.DeleteUserid = UserInfo.GetUserID();
                        list.Add(res);
                    }
                }
                if (i == 0)
                {
                    MessageUtil.ShowWarning("请选择需要操作的记录！");
                    return;
                }

                if (MessageBox.Show("是否确认作废数据？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
                    return;
                CoreResult re = this.execute<CoreResult>("com.hnshituo.pur.configure.service.ConfigureOrgBudgetService", "doDeleteOrResume", new object[] { list, 0, 0 });
                if (re.Resultcode == 0)
                {
                    MessageUtil.ShowTips("操作成功！");
                    Query(true);
                    ConfigureOrgBudget strbdg = (ConfigureOrgBudget)list[0];
                    string stroldId = strbdg.Id;
                    ConfigureClassCommon.doActiveSelRow(ultraGrid1, "ID", stroldId);
                }
                else
                {
                    MessageUtil.ShowTips("操作失败：" + re.Resultmsg);
                }
            }
            //恢复
            if(tips==false)
            {
                foreach (UltraGridRow row in ultraGrid1.Rows)
                {
                    if (Convert.ToBoolean(row.Cells["CHK"].Value))
                    {
                        i++;
                        ConfigureOrgBudget res = new ConfigureOrgBudget();
                        String strId = row.Cells["ID"].Value.ToString().Trim();
                        String strValidFlag = "1";
                        res.Id = strId;
                        res.Validflag = strValidFlag;
                        res.UpdateName = UserInfo.GetUserName();
                        res.UpdateTime = new DateTime();
                        res.UpdateUserid = UserInfo.GetUserID();
                        list.Add(res);
                    }
                }
                if (i == 0)
                {
                    MessageUtil.ShowWarning("请选择需要操作的记录！");
                    return;
                }

                if (MessageBox.Show("是否确认恢复数据？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
                    return;
                CoreResult re = this.execute<CoreResult>("com.hnshituo.pur.configure.service.ConfigureOrgBudgetService", "doDeleteOrResume", new object[] { list, 0, 0 });
                if (re.Resultcode == 0)
                {
                    MessageUtil.ShowTips("操作成功！");
                    Query(true);
                    ConfigureOrgBudget strbdg = (ConfigureOrgBudget)list[0];
                    string stroldId = strbdg.Id;
                    ConfigureClassCommon.doActiveSelRow(ultraGrid1, "ID", stroldId);
                }
                else
                {
                    MessageUtil.ShowTips("操作失败：" + re.Resultmsg);
                }
            }
        }

        /// <summary>
        /// 保存
        /// </summary>
        private void DoSave()
        {
            try
            {
                ultraGrid1.UpdateData();
                int i = 0;
                ArrayList list = new ArrayList();
                foreach (UltraGridRow row in ultraGrid1.Rows)
                {
                    if (Convert.ToBoolean(row.Cells["CHK"].Value))
                    {
                        i++;
                        ConfigureOrgBudget res = new ConfigureOrgBudget();
                        String strId=row.Cells["ID"].Value.ToString().Trim();
                        String strDEPARTID = row.Cells["DEPARTID"].Value.ToString().Trim();
                        String strDEPARTNAME = row.Cells["DEPARTNAME"].Value.ToString().Trim();
                        String strYEAR = row.Cells["YEAR"].Value.ToString().Trim();
                        String strM1 = row.Cells["M1"].Value.ToString().Trim() == "" ? "0" : row.Cells["M1"].Value.ToString().Trim();
                        String strM2 = row.Cells["M2"].Value.ToString().Trim() == "" ? "0" : row.Cells["M2"].Value.ToString().Trim();
                        String strM3 = row.Cells["M3"].Value.ToString().Trim() == "" ? "0" : row.Cells["M3"].Value.ToString().Trim();
                        String strM4 = row.Cells["M4"].Value.ToString().Trim() == "" ? "0" : row.Cells["M4"].Value.ToString().Trim();
                        String strM5 = row.Cells["M5"].Value.ToString().Trim() == "" ? "0" : row.Cells["M5"].Value.ToString().Trim();
                        String strM6 = row.Cells["M6"].Value.ToString().Trim() == "" ? "0" : row.Cells["M6"].Value.ToString().Trim();
                        String strM7 = row.Cells["M7"].Value.ToString().Trim() == "" ? "0" : row.Cells["M7"].Value.ToString().Trim();
                        String strM8 = row.Cells["M8"].Value.ToString().Trim() == "" ? "0" : row.Cells["M8"].Value.ToString().Trim();
                        String strM9 = row.Cells["M9"].Value.ToString().Trim() == "" ? "0" : row.Cells["M9"].Value.ToString().Trim();
                        String strM10 = row.Cells["M10"].Value.ToString().Trim() == "" ? "0" : row.Cells["M10"].Value.ToString().Trim();
                        String strM11 = row.Cells["M11"].Value.ToString().Trim() == "" ? "0" : row.Cells["M11"].Value.ToString().Trim();
                        String strM12 = row.Cells["M12"].Value.ToString().Trim() == "" ? "0" : row.Cells["M12"].Value.ToString().Trim();
                        String strREMARK = row.Cells["REMARK"].Value.ToString().Trim();
                        String strValidFlag = row.Cells["VALIDFLAG"].Value.ToString().Trim();
                        res.Id = strId;
                        res.Departid = strDEPARTID;
                        res.Departname = strDEPARTNAME;
                        res.Year = strYEAR;
                        res.M1 = Convert.ToDouble(strM1);
                        res.M2 = Convert.ToDouble(strM2);
                        res.M3 = Convert.ToDouble(strM3);
                        res.M4 = Convert.ToDouble(strM4);
                        res.M5 = Convert.ToDouble(strM5);
                        res.M6 = Convert.ToDouble(strM6);
                        res.M7 = Convert.ToDouble(strM7);
                        res.M8 = Convert.ToDouble(strM8);
                        res.M9 = Convert.ToDouble(strM9);
                        res.M10 = Convert.ToDouble(strM10);
                        res.M11 = Convert.ToDouble(strM11);
                        res.M12 = Convert.ToDouble(strM12);
                        res.Remark = strREMARK;
                        res.Validflag = strValidFlag;
                        if (res == null)
                            return;
                        if (!TestData(res))
                        {
                            MessageUtil.ShowWarning(errMsg);
                            return;
                        }
                        if (res.Validflag.Equals("") || res.Id.Equals(""))
                        {
                            res.CreateName = UserInfo.GetUserName();
                            res.CreateTime = DateTime.Now;
                            res.CreateUserid = UserInfo.GetUserID();
                        }
                        else
                        {
                            res.UpdateName = UserInfo.GetUserName();
                            res.UpdateTime = DateTime.Now;
                            res.UpdateUserid = UserInfo.GetUserID();
                        }
                        list.Add(res);
                    }
                }

                if (i == 0)
                {
                    MessageUtil.ShowWarning("请选择需要操作的记录！");
                    return;
                }

                if (MessageBox.Show("是否确认保存选择的："+list.Count+"条数据？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
                    return;
                CoreResult re = this.execute<CoreResult>("com.hnshituo.pur.configure.service.ConfigureOrgBudgetService", "doSave", new object[] { list, 0, 0 });
                if (re.Resultcode == 0)
                {
                    MessageUtil.ShowTips("数据保存成功！");
                    Query(true);
                    ConfigureOrgBudget strbdg = (ConfigureOrgBudget)list[0];
                    string stroldId = strbdg.Id;
                    ConfigureClassCommon.doActiveSelRow(ultraGrid1, "ID", stroldId);
                }
                else
                {
                    MessageUtil.ShowTips("保存失败：" + re.Resultmsg);
                }

            }
            catch (Exception ex)
            {
                MessageUtil.ShowError("保存失败："+ex);
            }
        }

        /// <summary>
        /// 复制旧数据到指定年份
        /// </summary>
        private void CopyData()//复制旧数据
        {
            try
            {
                //不能有重复的部门
                //不能有指定年份的数据
                ultraGrid1.UpdateData();
                int i = 0;
                ArrayList list = new ArrayList();
                foreach (UltraGridRow row in ultraGrid1.Rows)
                {
                    if (Convert.ToBoolean(row.Cells["CHK"].Value))
                    {
                        i++;
                        ConfigureOrgBudget res = new ConfigureOrgBudget();
                        String strId = row.Cells["ID"].Value.ToString().Trim();
                        String strYEAR = row.Cells["YEAR"].Value.ToString().Trim();
                        if (String.IsNullOrEmpty(strId) || String.IsNullOrEmpty(strYEAR))
                        {
                            continue;
                        }
                        res.Id = strId;
                        res.Year = strYEAR;
                        if (res == null)
                            return;
                        if (res.Year.Equals("") || res.Id.Equals(""))
                        {
                            continue;
                        }
                        else
                        {
                            res.UpdateName = UserInfo.GetUserName();
                            res.UpdateTime = DateTime.Now;
                            res.UpdateUserid = UserInfo.GetUserID();
                        }
                        list.Add(res);
                    }
                }

                if (i == 0)
                {
                    MessageUtil.ShowWarning("请选择需要操作的记录！");
                    return;
                }
                FrmPopCopyBudgetData frm = new FrmPopCopyBudgetData(this.ob, list,"1");
                frm.ShowDialog();
                if (frm.Tips == "1")
                {
                    Query(true);
                }
                //CoreResult re = this.execute<CoreResult>("com.hnshituo.pur.configure.service.ConfigureOrgBudgetService", "doSave", new object[] { list, 0, 0 });
                //if (re.Resultcode == 0)
                //{
                //    MessageUtil.ShowTips("数据保存成功！");
                //    Query(true);
                //    ConfigureOrgBudget strbdg = (ConfigureOrgBudget)list[0];
                //    string stroldId = strbdg.Id;
                //    ConfigureClassCommon.doActiveSelRow(ultraGrid1, "ID", stroldId);
                //}
                //else
                //{
                //    MessageUtil.ShowTips("保存失败：" + re.Resultmsg);
                //}

            }
            catch (Exception ex)
            {
                MessageUtil.ShowError("保存失败：" + ex);
            }
        }
        #endregion
        
        #region 界面初始化
        /// <summary>
        /// 初始化控件数据
        /// </summary>
        private void Init()
        {
            //绑定年份数据
            DataTable dt1 = new DataTable();
            dt1.Columns.Add("YEAR", Type.GetType("System.Int32"));
            for (int i = DateTime.Now.AddYears(-3).Year; i <= DateTime.Now.AddYears(3).Year; i++)
                dt1.Rows.Add(new object[] { i });
            Qyear.DataSource = dt1;
            Qyear.ValueMember = "YEAR";
            Qyear.DisplayMember = "YEAR";

            Qyear.Value = DateTime.Now.Year.ToString();




            UltraComboEditor uce = new UltraComboEditor();
            DataTable dt = new DataTable();
            dt.Columns.Add("YEAR", Type.GetType("System.Int32"));
            for (int i = DateTime.Now.AddYears(-3).Year; i <= DateTime.Now.AddYears(10).Year; i++)
                dt.Rows.Add(new object[] { i });
            uce.DataSource = dt;
            uce.ValueMember = "YEAR";
            uce.DisplayMember = "YEAR";
            this.Controls.Add(uce);
            uce.Visible = false;
            ultraGrid1.DisplayLayout.Bands[0].Columns["YEAR"].EditorComponent = uce;
            ultraGrid1.DisplayLayout.Bands[0].Columns["YEAR"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            //ultraGrid1.DisplayLayout.Bands[0].Columns["YEAR"].AutoCompleteMode = Infragistics.Win.AutoCompleteMode.Suggest;
            //绑定部门数据
            //this._dtOrg = this.execute<List<CoreAppDepartment>>("com.hnshituo.core.service.AppDepartmentService", "findAll", new object[] { });
            //FillTreeData(this._dtOrg);
            //this.cmbDept.DataSource = this._dtOrg;
            //this.cmbDept.DisplayMember = "Departname";
            //this.cmbDept.ValueMember = "Departid";
            //List<CoreAppDepartment> list1 = UserInfo.DataPurview;
            ////string[] str = UserInfo.DataPurviewIds;

            //this.cmbDept.AddControl(this.treeView4Combo1);
            //this.cmbDept.LoadChildControl1();

            //UltraComboEditor org = new UltraComboEditor();
            //dt1 = this.execute<DataTable>("com.hnshituo.core.service.AppDepartmentService", "findAll", new object[] { });
            ////QcmBaseCommon.InitDrop(uceSale, "com.steering.pss.qcm.CoreResBaseResourceAllocation.getSaleOrg", "BASENAME", "BASECODE", true, this.ob);
            //FillComboxItems(org, dt1, "DEPARTID", "DEPARTNAME", "");
            //this.Controls.Add(org);
            //org.Visible = false;
            //ClsBaseInfo.SetComboItemHeight(org);
            txt_selectDept.Visible = false;
            ultraGrid1.DisplayLayout.Bands[0].Columns["DEPARTNAME"].EditorComponent = txt_selectDept;
            //ultraGrid1.DisplayLayout.Bands[0].Columns["DEPARTID"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            //ultraGrid1.DisplayLayout.Bands[0].Columns["DEPARTID"].AutoCompleteMode = Infragistics.Win.AutoCompleteMode.Suggest;

            //设置界面不可编辑列
            SetColumnsActive(ultraGrid1.DisplayLayout.Bands[0], new string[] {"DEPARTID","ID", "VALIDFLAG", "CREATENAME", "CREATETIME", "CREATEUSERID" });

        }
        #endregion

        #region 公共函数
        /// <summary>
        /// 校验保存填写数据是否满足要求
        /// </summary>
        /// <param name="res"></param>
        /// <returns></returns>
        private bool TestData(ConfigureOrgBudget res)
        {
            try
            {
                if (res.Validflag.ToString() != "" && res.Validflag.ToString() != "有效")
                {
                    errMsg = "无效数据无法保存！";
                    return false;
                }

                if (res.Departid.ToString().Trim() == "")
                {
                    errMsg = "请选择部门信息，未获取到有效的部门ID！";
                    return false;
                }
                if (res.Departname.ToString().Trim() == "")
                {
                    errMsg = "请选择部门信息，部门名称不能为空！";
                    return false;
                }
                if (res.Year.ToString() == "")
                {
                    errMsg = "请选择年份！";
                    return false;
                }

                if (!IsNum(res.M1.ToString()))
                {
                    errMsg = "1月预算请输入数字！";
                    return false;
                }
                if(isrightRange(res.M1.ToString())==false)
                {
                    errMsg = "1月" + errMsg;
                    return false;
                }
                if (!IsNum(res.M2.ToString()))
                {
                    errMsg = "2月预算请输入数字！";
                    return false;
                }
                if (isrightRange(res.M2.ToString()) == false)
                {
                    errMsg = "2月" + errMsg;
                    return false;
                }
                if (!IsNum(res.M3.ToString()))
                {
                    errMsg = "3月预算请输入数字！";
                    return false;
                }
                if (isrightRange(res.M3.ToString()) == false)
                {
                    errMsg = "3月" + errMsg;
                    return false;
                }
                if (!IsNum(res.M4.ToString()))
                {
                    errMsg = "4月预算请输入数字！";
                    return false;
                }
                if (isrightRange(res.M4.ToString()) == false)
                {
                    errMsg = "4月" + errMsg;
                    return false;
                }
                if (!IsNum(res.M5.ToString()))
                {
                    errMsg = "5月预算请输入数字！";
                    return false;
                }
                if (isrightRange(res.M5.ToString()) == false)
                {
                    errMsg = "5月" + errMsg;
                    return false;
                }
                if (!IsNum(res.M6.ToString()))
                {
                    errMsg = "6月预算请输入数字！";
                    return false;
                }
                if (isrightRange(res.M6.ToString()) == false)
                {
                    errMsg = "6月" + errMsg;
                    return false;
                }
                if (!IsNum(res.M7.ToString()))
                {
                    errMsg = "7月预算请输入数字！";
                    return false;
                }
                if (isrightRange(res.M7.ToString()) == false)
                {
                    errMsg = "7月" + errMsg;
                    return false;
                }
                if (!IsNum(res.M8.ToString()))
                {
                    errMsg = "8月预算请输入数字！";
                    return false;
                }
                if (isrightRange(res.M8.ToString()) == false)
                {
                    errMsg = "8月" + errMsg;
                    return false;
                }
                if (!IsNum(res.M9.ToString()))
                {
                    errMsg = "9月预算请输入数字！";
                    return false;
                }
                if (isrightRange(res.M9.ToString()) == false)
                {
                    errMsg = "9月" + errMsg;
                    return false;
                }
                if (!IsNum(res.M10.ToString()))
                {
                    errMsg = "10月预算请输入数字！";
                    return false;
                }
                if (isrightRange(res.M10.ToString()) == false)
                {
                    errMsg = "10月" + errMsg;
                    return false;
                }
                if (!IsNum(res.M11.ToString()))
                {
                    errMsg = "11月预算请输入数字！";
                    return false;
                }
                if (isrightRange(res.M11.ToString()) == false)
                {
                    errMsg = "11月" + errMsg;
                    return false;
                }
                if (!IsNum(res.M12.ToString()))
                {
                    errMsg = "12月预算请输入数字！";
                    return false;
                }
                if (isrightRange(res.M12.ToString()) == false)
                {
                    errMsg = "12月" + errMsg;
                    return false;
                }
                String StrDepartName = ultraGrid1.ActiveRow.Cells["DEPARTID"].Text.ToString().Trim();
                if (res.Validflag.ToString() == "")   //新增
                {
                    ConfigureOrgBudget bdg = new ConfigureOrgBudget();
                    bdg.Departid = res.Departid;
                    bdg.Year = res.Year;
                    DataTable dt = this.execute<DataTable>("com.hnshituo.pur.configure.service.ConfigureOrgBudgetService", "find", new object[] { bdg, 0, 0 });
                    if (dt != null && dt.Rows.Count > 0)
                    {
                        errMsg = "部门：" + StrDepartName + "，年份：" + res.Year + "  对应的预算信息已经存在！";
                        return false;
                    }
                }
                else   //修改
                {
                    //if (res.SaleOrg.ToString() != res.SaleOrgOld.ToString() || res.ProcessCode.ToString() != res.ProcessCodeOld.ToString()
                    //    || res.Year.ToString() != res.YearOld.ToString())
                    //{
                    //    DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreResBaseResourceAllocation.isReapt", new object[] { res.SaleOrg.ToString(), res.ProcessCode.ToString(), res.Year.ToString() }, this.ob);
                    //    if (dt != null && dt.Rows.Count > 0)
                    //    {
                    //        errMsg = "销售组织：" + res.SaleOrgDesc + "，工序名称：" + res.ProcessDesc + "，年份：" + res.Year + "  对应的记录已经存在！";
                    //        return false;
                    //    }
                    //}
                    ConfigureOrgBudget bdg = new ConfigureOrgBudget();
                    bdg.Departid = res.Departid;
                    bdg.Year = res.Year;
                    DataTable dt = this.execute<DataTable>("com.hnshituo.pur.configure.service.ConfigureOrgBudgetService", "find", new object[] { bdg, 0, 0 });
                    if (dt != null && dt.Rows.Count > 0)
                    {
                        DataRow[] rows = dt.Select("id<>'" + res.Id + "'");
                        int ii = rows.Count();
                        if (rows.Count() != 0)
                        {
                            errMsg = "部门：" + StrDepartName + "，年份：" + res.Year + "  对应的预算信息已经存在！";
                            return false;
                        }
                    }
                }
                return true;
            }
            catch (Exception ex)
            {
                errMsg = ex + "";
                //MessageUtil.ShowError(""+ex);
                return false;

            }
        }

        /// <summary>
        /// 判断是否为正数数字
        /// </summary>
        /// <param name="p"></param>
        /// <returns></returns>
        private bool IsNum(string str)
        {
            if (str != "")
            {
                return StringUtil.IsNumber(str);
            }
            return true;
        }

        private bool isrightRange(String str)
        {
            if (Convert.ToDouble(str) >= 2147483647/10000 || Convert.ToDouble(str) <= -2147483647/10000)
            {
                errMsg = "超出每月预算最大上限20亿！";
                return false;
            }
            return true;
        }

        /// <summary>
        /// 字符串转是否能转换成非负数
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public static bool Is_Below_zero(string str)
        {
            try
            {
                if (str.Equals(""))
                {
                    return true;
                }
                else
                {
                    if (StringUtil.IsDouble(str) && double.Parse(str) >= 0)
                        return true;
                    else
                        return false;
                }
            }
            catch
            {
                return false;
            }
        }
          
        /// <summary>
        /// 设置包含在指定列中的列只读
        /// </summary>
        /// <param name="band"></param>
        /// <param name="columnKeys"></param>
        public static void SetColumnsActive(UltraGridBand band, params string[] columnKeys)
        {
            foreach (UltraGridColumn gridColumn in band.Columns)
            {
                if (columnKeys.Contains(gridColumn.Key) == true)
                {
                    gridColumn.CellActivation = Activation.ActivateOnly;
                }
            }
        }

        /// <summary>
        /// 初始化Combox数据,加入数据筛选
        /// </summary>
        /// <param name="cmbx">ComboBox控件</param>
        /// <param name="dt">DataTable</param>
        /// <param name="filterCondition">RowFilter条件</param>
        public static void FillComboxItems(UltraComboEditor cmbx, DataTable dt, string valueCol, string textCol, string filterCondition)
        {
            if (dt != null && dt.Rows.Count > 0)
            {
                DataView dvw = dt.DefaultView;
                dvw.RowFilter = filterCondition;
                ArrayList aryTmp = new ArrayList();
                aryTmp.Add(new ValueListItem(" ", " "));
                for (int i = 0; i < dvw.Count; i++)
                {
                    aryTmp.Add(new ValueListItem(dvw[i][valueCol].ToString(), dvw[i][textCol].ToString()));
                }
                cmbx.DataSource = aryTmp;
                cmbx.DisplayMember = "DisplayText";
                cmbx.ValueMember = "DataValue";
            }
        }

        #region // 填充部门树
        private bool FillTreeData(List<CoreAppDepartment> lcad)
        {
            this.treeView4Combo1.Nodes.Clear();

            if (lcad == null || lcad.Count == 0) return false;

            string key = "";

            try
            {
                foreach (CoreAppDepartment cad in lcad)
                {
                    TreeNode tn = CreateOrFindRarenttNode(cad, null);
                    if (treeView4Combo1.Nodes.Find(tn.Name, false).Length == 0)
                    {
                        treeView4Combo1.Nodes.Add(tn);
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            return true;
        }
        #endregion
        private TreeNode CreateOrFindRarenttNode(CoreAppDepartment cad, TreeNode childNode)
        {
            TreeNode[] ptn = treeView4Combo1.Nodes.Find(cad.Departid, true);
            //TreeNode tn = null;
            //节点已经存在
            if (ptn.Length > 0)
            {
                if (childNode != null && ptn[0].Nodes.Find(childNode.Name, false).Length == 0) ptn[0].Nodes.Add(childNode);
                //如果已经是最上层组织，直接返回已有节点
                if (this.IsRoot(cad))
                {
                    return ptn[0];
                }
                //否则递归找上层组织
                else
                {
                    CoreAppDepartment dept = _dtOrg.Find(x => x.Departid == cad.Pid);
                    return CreateOrFindRarenttNode(dept, ptn[0]);
                }
            }

            //节点不存在
            //如果已经是最上层组织，创建并返回节点
            TreeNode tn = CreateCommonNode(cad);
            if (childNode != null) tn.Nodes.Add(childNode);
            if (this.IsRoot(cad))
            {
                return tn;
            }
            else
            {
                CoreAppDepartment dept = _dtOrg.Find(x => x.Departid == cad.Pid);
                return CreateOrFindRarenttNode(dept, tn);
            }
        }

        private TreeNode CreateCommonNode(CoreAppDepartment cad)
        {
            TreeNode tn = new TreeNode();
            tn.Name = cad.Departid;
            tn.Text = cad.Departname;
            return tn;
        }

        private Boolean IsRoot(CoreAppDepartment cad)
        {
            if (string.IsNullOrEmpty(cad.Pid)) return true;
            CoreAppDepartment dept = _dtOrg.Find(x => x.Departid == cad.Pid);
            if (dept == null) return true;
            return false;
        }



        #endregion

        #region 界面事件
        private void ultraGrid1_InitializeRow(object sender, InitializeRowEventArgs e)
        {
            if (e.Row.Cells["VALIDFLAG"].Value.ToString().Equals("无效"))
            {
                e.Row.Appearance.ForeColor = Color.Red;
            }
            else
            {
                e.Row.Appearance.ForeColor = Color.Black;
            }
        }

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            ultraGrid1.UpdateData();
            UltraGridRow ugr = ultraGrid1.ActiveRow;
            if (ugr == null)
                return;
            if (!Convert.ToBoolean(ugr.Cells["CHK"].Value))
            {
                for (int i = 0; i < ugr.Cells.Count; i++)
                {
                    if (!ugr.Cells[i].Column.Key.Equals("CHK"))
                        ugr.Cells[i].Activation = Activation.ActivateOnly;
                }
            }
            else
            {
                for (int i = 0; i < ugr.Cells.Count; i++)
                {
                    ugr.Cells[i].Activation = Activation.AllowEdit;
                }
            }
        }

        private void ultraGrid1_AfterRowInsert(object sender, RowEventArgs e)
        {

        }

        private void ultraGrid1_CellChange(object sender, CellEventArgs e)
        {

            if (e.Cell.Column.Key.Equals("M1")||e.Cell.Column.Key.Equals("M2")||e.Cell.Column.Key.Equals("M3")||e.Cell.Column.Key.Equals("M4")||e.Cell.Column.Key.Equals("M5")||e.Cell.Column.Key.Equals("M6")||e.Cell.Column.Key.Equals("M7")||e.Cell.Column.Key.Equals("M8")||e.Cell.Column.Key.Equals("M9")||e.Cell.Column.Key.Equals("M10")||e.Cell.Column.Key.Equals("M11")||e.Cell.Column.Key.Equals("M12"))
            {
                String sreNumOld = e.Cell.Value.ToString();
                ultraGrid1.UpdateData();
                String sreNumNew = e.Cell.Value.ToString();
                if (!Is_Below_zero(sreNumNew))
                {
                    e.Cell.Value = sreNumOld;
                }

            }
        }

        private void ultraGrid1_InitializeLayout(object sender, InitializeLayoutEventArgs e)
         {

         }

        #endregion

        private void cmbDept_SelectedIndexChanged(object sender, EventArgs e)
        {
            //if (opType == OperationType.Add)
            //{
            //    string deptid = this.cmbDept.SelectedValue == null ? "" : this.cmbDept.SelectedValue.ToString();
            //    if (deptid == null || deptid == "") return;
            //    CoreAppDepartment cad = _dtOrg.Find((CoreAppDepartment x) => x.Departid == deptid);
            //    if (cad == null) return;
            //    this.txtUserId.Text = cad.DepartNo;
            //}
        }

        private void txt_selectDept_EditorButtonClick(object sender, EditorButtonEventArgs e)
        {
            frmdepartment frm = new frmdepartment(this.ob);
            frm.ShowDialog();
            String strdeptId = frm.BuyerUnitCode;
            String strDeptName = frm.Fulltext;
            if (strdeptId != null && strdeptId!= "")
            {
                if (ultraGrid1.ActiveRow == null)
                {
                    return;

                }
                else
                {
                    UltraGridRow row = ultraGrid1.ActiveRow;
                    row.Cells["DEPARTID"].Value = strdeptId;
                    row.Cells["DEPARTNAME"].Value = strDeptName;
                }
            }

        }
    }
}