using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Tool;
using Infragistics.Win;
using Infragistics.Win.UltraWinGrid;
using Pur.Balance;
using Pur.Entity;
using Pur.Entity.configureEntity;
using Pur.Pop_upWindow;
using Pur.PublicTools;
using Pur.require_plan;
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;

namespace Pur.balance
{
    public partial class FrmBalanceBillManage_Agree : FrmPmsBase
    {
        private string item = "";
        public FrmBalanceBillManage_Agree()
        {
            InitializeComponent();
        }

        protected override void OnLoad(EventArgs e)
        {
            base.OnLoad(e);
            ultraGrid2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
        }

        private void FrmBalanceBillManage_Agree_Load(object sender, EventArgs e)
        {
            dateBegin.Value = dateEnd.DateTime.AddDays(-3);
            InitColumns();
            SetSumCount();
            InitBindBox();
            InitNotice();
            ultraTabControl1.Tabs[0].Visible= false;
            
    //        DataTable dt = PublicServer.GetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.QueryUserId",
    //new Object[] { UserInfo.GetUserID() }, ob);

    //            if (dt == null || dt.Rows.Count == 0)
    //            {
    //                return;
    //            }
    //            else
    //            {
    //                if(!dt.Rows[0]["DEPT_NAME"].Equals("业务员"))
    //                {
    //                    FrmBalanceBillManage_Agree
    //                }else{

    //                }
    //                dt.Rows[0]["DEPT_NAME"] = 
    //            }
        }
        private void InitNotice()
        {
            ArrayList arrayList = new ArrayList();
            arrayList.Add("1233");
            DataTable dt = PublicServer.GetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.QueryNotice",
  new Object[] { arrayList }, ob);

            if (dt == null || dt.Rows.Count == 0)
            {
                return;
            }
            txt_notice.DataSource = dt;
            txt_notice.DisplayMember = "BASENAME";
            txt_notice.ValueMember = "BASECODE";
        }
        private void InitColumns()
        {
            string[] arrColumns = new string[] { "CHK", "ORG_NAME", "IS_DEPT", "SUPP_NAME", "ITEM_CLASS_CODE", "ITEM_CLASS_NAME", "PAY_TYPE_CODE", "PAY_TYPE_NAME", "TOTAL_REAL_PRICE", "BALANCE_NOTICE", "SUPP_CODE", "SUPP_BALANCE_CODE", "BANK_NAME", "BANK_ACCOUNT", "TOTAL_BUY_AMT", "TOTAL_BUY_AMT_TAX", "ACCOUNT_PERIOD", "FLAG", "IS_PRINT", "IS_PRINT_DESC", "CREATE_NAME", "CREATE_TIME", "REMARK", "ISAGREE_NAM", "ISAGREE_TIM", "MEM", "CONFIRMING", "BALANCE_NO" };
            string[] arrColumnsCaption = new string[] { "选择","科室", "审批状态", "供应商", "物料中类", "物料中类", "付款方式", "付款方式", "付款金额", "付款通知书", "供应商", "结算代码", "开户银行", "银行账号", "不含税金额", "含税金额", "会计期", "标志位", "是否打印", "是否打印", "创建人", "创建时间", "备注", "审批人", "审批时间", "审批备注", "是否确认", "结算编号" };
            PublicPur.InitColumns(arrColumns, arrColumnsCaption, dataTable2, ultraGrid2, new string[] { "ITEM_CLASS_CODE", "PAY_TYPE_CODE", "SUPP_CODE", "TOTAL_BUY_AMT", "TOTAL_BUY_AMT_TAX", "ACCOUNT_PERIOD", "FLAG", "IS_PRINT" }, false, null);
        }

        //设置统计风格
        private void SetSumCount()
        {
            PublicPur.SetupSummaryHeade(new String[] { "Count", "Sum" }, new String[] { "共{0}条", "{0}" }, new string[] { "BALANCE_NO", "TOTAL_REAL_PRICES" }, this.ultraGrid2.DisplayLayout.Bands[0], SummaryDisplayAreas.BottomFixed);
        }

        private void InitBindBox()
        {
            QueryTEM_CLASS_NAME();
            QueryPAY_TYPE_NAME();
            QuerySUPP_NAME();
        }

        //查询物料中类
        private void QueryTEM_CLASS_NAME()
        {
            PurmatclassEntity mat = new PurmatclassEntity();
            mat.Validflag = "1";
            mat.Parentcode = "W";
            DataTable dt = this.execute<DataTable>("com.hnshituo.pur.configure.service.MatClassService", "getMatClass", new object[] { mat });
            publicPms.FilComboboxAdd(ultraQueryTEM_CLASS_NAME, dt, "BASECODE", "BASENAME", "", true, "/", "");//绑定物料中类
            publicPms.FilComboboxAdd(ultraTEM_CLASS_NAME, dt, "BASECODE", "BASENAME", "", false, "/", "");//绑定物料中类
        }

        //查询付款方式
        private void QueryPAY_TYPE_NAME()
        {
            try
            {
                ultraPAY_TYPE_NAME.Items.Clear();

                DataTable dt = PublicServer.GetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.QueryPAY_TYPE_NAME",
    new Object[] { }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    return;
                }
                ultraPAY_TYPE_NAME.DataSource = dt;
                ultraPAY_TYPE_NAME.DisplayMember = "BASENAME";
                ultraPAY_TYPE_NAME.ValueMember = "BASECODE";

            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        //查询供应商
        private void QuerySUPP_NAME(string item)
        {
            try
            {
                ultraQuerySUPP_NAME.Items.Clear();
                ultraSUPP_NAME.Items.Clear();
            
                ArrayList arrayList = new ArrayList();
                arrayList.Add("");
                arrayList.Add("");
                arrayList.Add("");
                DataTable dt = PublicServer.GetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.QuerySUPP_NAME_",
    new Object[] { arrayList,item }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    return;
                }
                ultraQuerySUPP_NAME.DataSource = dt;
                ultraQuerySUPP_NAME.DisplayMember = "SUPP_NAME";
                ultraQuerySUPP_NAME.ValueMember = "SUPP_CODE";

                ultraSUPP_NAME.DataSource = dt;
                ultraSUPP_NAME.DisplayMember = "SUPP_NAME";
                ultraSUPP_NAME.ValueMember = "SUPP_CODE";
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }
        //查询供应商


        private void QuerySUPP_NAME()
        {
            try
            {
                ultraQuerySUPP_NAME.Items.Clear();
                ultraSUPP_NAME.Items.Clear();

                ArrayList arrayList = new ArrayList();
                arrayList.Add("");
                arrayList.Add("");
                arrayList.Add("");
                DataTable dt = PublicServer.GetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.QUERYSUPP_NAME",
    new Object[] { arrayList }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    return;
                }
                ultraQuerySUPP_NAME.DataSource = dt;
                ultraQuerySUPP_NAME.DisplayMember = "SUPP_NAME";
                ultraQuerySUPP_NAME.ValueMember = "SUPP_CODE";

                ultraSUPP_NAME.DataSource = dt;
                ultraSUPP_NAME.DisplayMember = "SUPP_NAME";
                ultraSUPP_NAME.ValueMember = "SUPP_CODE";
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        //菜单按钮事件
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    if (ultraTabControl1.SelectedTab.Index == 1)
                    {
                        QueryBalancePayRecord();
                    }
                    break;
                case "QueryIsAgree":
                    QueryIsAgree();//主管查询
                    break;
                case "QueryIsDept":
                    QueryIsDept();//主管部长查询
                    break;
                case "QueryAssist":
                    QueryAssist();//部长助理查询
                    break;
                case "QueryIsDepting":
                    QueryIsDepting();//部长查询
                    break;
                case "QueryIsBoss":
                    QueryIsBoss();//主管副总查询
                    break;
                case "QueryAll":
                    QueryAll();//查询全部
                    break;
                case "Confirm"://确认编制结算单
                    if (ultraTabControl1.SelectedTab.Index == 0)
                    {
                        ConfirmBalancePay();
                    }
                    break;
                case "Cancel"://取消编制结算单
                    CancelBalancePay();
                    break;
                case "Commit"://提报
                    DoCommit();
                    break;
                case "DoAgree"://主管审批
                    DoAgree();
                    break;
                case "DoAgreeDept"://主管部长审批
                    DoAgreeDept();
                    break;
                case "DoAgreeAssist"://部长助理审批
                    DoAgreeAssist();
                    break;
                case "DoAgreeDepting"://部长审批
                    DoAgreeDepting();
                    break;
                case "DoAgreeBoss"://主管副总审批
                    DoAgreeBoss();
                    break;
                case "Print"://打印
                    PrintBalancePay();
                    break;
                case "CancelPrint"://取消打印
                    CancelPrint();
                    break;
                case "Export":
                    GridHelper.ulGridToExcel(ultraGrid2, "付款通知书报表");
                    break;
                case "DoDelete":
                    DoDelete();//作废
                    break;
                case"Confrim":
                    Confirm();//付款确认
                    break;
                case"CancelConfirm":
                    CancelConfirm();//取消付款确认
                    break;
                case "QueryFinance":
                    QueryFinance();//财务查询
                    break;
                case "DoExamineFinance":
                    DoExamineFinance();//财务审批
                    break;

                case "Close":
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面？") == DialogResult.Yes)
                    {
                        this.Close();
                    }
                    break;
            }
        }

        private void DoExamineFinance()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    MessageUtil.ShowTips("只有选择了已编制记录页才能进行审批操作！");
                    return;
                }

                if (ultraGrid2.ActiveRow == null || dataTable2.Rows.Count == 0)
                {
                    return;
                }

                frmExamineShow Fex = new frmExamineShow();
                Fex.ShowDialog();
                if (Fex.Status == null)
                {
                    return;
                }
                if (Fex.Status.Equals("2"))
                {

                    ArrayList list = new ArrayList();
                    ultraGrid2.UpdateData();
                    DataRow[] arr = dataTable2.Select("CHK = 'True'");
                    if (arr.Length == 0)
                    {
                        MessageUtil.ShowTips("请选择要审批的数据！");
                        return;
                    }
                    foreach (DataRow dr in arr)
                    {
                        ArrayList all = new ArrayList();
                        all.Add(UserInfo.GetUserID());
                        all.Add(UserInfo.GetUserName());
                        all.Add(Fex.ExamineMessage);
                        all.Add(dr["BALANCE_NO"].ToString());
                        list.Add(all);
                    }

                    PublicServer.SetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.DoExamineFinance",
        new Object[] { list,this.CustomInfo }, ob);

                    QueryBalancePayRecord();

                    MessageUtil.ShowTips("审批成功！");
                }
                else if (Fex.Status.Equals("1"))
                {

                    ArrayList list = new ArrayList();
                    ultraGrid2.UpdateData();
                    DataRow[] arr = dataTable2.Select("CHK = 'True'");
                    if (arr.Length == 0)
                    {
                        MessageUtil.ShowTips("请选择要审批的数据！");
                        return;
                    }
                    foreach (DataRow dr in arr)
                    {
                        ArrayList all = new ArrayList();
                        all.Add(UserInfo.GetUserID());
                        all.Add(UserInfo.GetUserName());
                        all.Add(Fex.ExamineMessage);
                        all.Add(dr["BALANCE_NO"].ToString());
                        list.Add(all);
                    }

                    PublicServer.SetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.DontAgree",
        new Object[] { list }, ob);

                    QueryBalancePayRecord();

                    MessageUtil.ShowTips("审批成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        private void QueryFinance()
        {
            try
            {
                dataTable2.Rows.Clear();
                string[] arrColumns = new string[] { "CHK", "ORG_NAME", "IS_DEPT", "SUPP_NAME", "ITEM_CLASS_CODE", "ITEM_CLASS_NAME", "PAY_TYPE_CODE", "PAY_TYPE_NAME", "TOTAL_REAL_PRICES", "BALANCE_NOTICE", "SUPP_CODE", "SUPP_BALANCE_CODE", "BANK_NAME", "BANK_ACCOUNT", "TOTAL_BUY_AMT", "TOTAL_BUY_AMT_TAX", "ACCOUNT_PERIOD", "FLAG", "IS_PRINT", "IS_PRINT_DESC", "CREATE_NAME", "CREATE_TIME", "REMARK", "ISAGREE_NAM", "ISAGREE_TIM", "MEM", "CONFIRMING", "BALANCE_NO" };
                string[] arrColumnsCaption = new string[] { "选择", "科室", "审批状态", "供应商", "物料中类", "物料中类", "付款方式", "付款方式", "付款金额", "付款通知书", "供应商", "结算代码", "开户银行", "银行账号", "不含税金额", "含税金额", "会计期", "标志位", "是否打印", "是否打印", "创建人", "创建时间", "备注", "审批人", "审批时间", "审批备注", "是否确认", "结算编号" };
                PublicPur.InitColumns(arrColumns, arrColumnsCaption, dataTable2, ultraGrid2, new string[] { "ITEM_CLASS_CODE", "PAY_TYPE_CODE", "SUPP_CODE", "TOTAL_BUY_AMT", "TOTAL_BUY_AMT_TAX", "ACCOUNT_PERIOD", "FLAG", "IS_PRINT" }, false, new string[] { "CHK" });
                ArrayList arrayList = new ArrayList();
                String stuts = "";
                if (txtAgree.Text.Equals("待审批"))
                {
                    stuts = "1";
                }
                else if (txtAgree.Text.Equals("已审批"))
                {
                    stuts = "2";
                }
                else if (txtAgree.Text.Equals("全部"))
                {
                    stuts = "3";
                }
                if (chkDate.Checked)
                {
                    arrayList.Add(dateBegin.DateTime.ToShortDateString() + " 00:00:00");
                    arrayList.Add(dateEnd.DateTime.ToShortDateString() + " 23:59:59");
                }
                else
                {
                    arrayList.Add("0001/01/01 00:00:00");
                    arrayList.Add("9999/12/31 23:59:59");
                }
                if (chkTEM_CLASS_NAME.Checked)
                {
                    arrayList.Add(ultraQueryTEM_CLASS_NAME.Text.Trim());
                    arrayList.Add(ultraQueryTEM_CLASS_NAME.Text.Trim());
                    arrayList.Add(ultraQueryTEM_CLASS_NAME.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }
                if (chkSUPP_NAME.Checked)
                {
                    arrayList.Add(ultraQuerySUPP_NAME.Text.Trim());
                    arrayList.Add(ultraQuerySUPP_NAME.Text.Trim());
                    arrayList.Add(ultraQuerySUPP_NAME.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }
                if (chkBALANCE_NO.Checked)
                {
                    arrayList.Add(txtQueryBALANCE_NO.Text.Trim());
                    arrayList.Add(txtQueryBALANCE_NO.Text.Trim());
                    arrayList.Add(txtQueryBALANCE_NO.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }

                DataTable dt = PublicServer.GetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.QueryFinance",
    new Object[] { arrayList, stuts ,this.CustomInfo}, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    dataTable2.Rows.Clear();
                    return;
                }
                SetSumCount();
                GridHelper.CopyDataToDatatable(dt, dataTable2, true);//把dt复制给dataTable1

                GridHelper.RefreshAndAutoSize(ultraGrid2);
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }
        private void Confirm()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    MessageUtil.ShowTips("只有选择了已编制记录页才能进行审批操作！");
                    return;
                }

                if (ultraGrid2.ActiveRow == null || dataTable2.Rows.Count == 0)
                {
                    return;
                }                         
               
                    ArrayList list = new ArrayList();
                    ultraGrid2.UpdateData();
                    DataRow[] arr = dataTable2.Select("CHK = 'True'");
                    if (arr.Length == 0)
                    {
                        MessageUtil.ShowTips("请选择要确认的数据！");
                        return;
                    }
                    if (ultraGrid2.ActiveRow.Cells["IS_PRINT"].Text.Trim().Equals("1"))
                    {
                        MessageUtil.ShowTips("选中有未打印数据，不允许确认付款！");
                        return;
                    }
                    foreach (DataRow dr in arr)
                    {
                        ArrayList all = new ArrayList();
                        all.Add(UserInfo.GetUserID());
                        all.Add(UserInfo.GetUserName());
                        all.Add("1");
                        all.Add(dr["BALANCE_NO"].ToString());
                        list.Add(all);
                    }
                    PublicServer.SetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.DoConfirm",
        new Object[] { list }, ob);

                    QueryAll();

                    MessageUtil.ShowTips("付款确认成功！");
                }
            
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }
        private void CancelConfirm()
        {
            try
            {
                ArrayList list = new ArrayList();
                ultraGrid2.UpdateData();
                DataRow[] arr = dataTable2.Select("CHK = 'True'");
                if(arr.Length == 0)
                {
                    MessageUtil.ShowTips("请选择要取消确认的数据！");
                    return;
                }
                foreach(DataRow dr in arr)
                {
                    ArrayList all = new ArrayList();
                    all.Add(UserInfo.GetUserID());
                    all.Add(UserInfo.GetUserName());
                    all.Add("0");
                    all.Add(dr["BALANCE_NO"].ToString());
                    list.Add(all);
                }
                PublicServer.SetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.DoCancelConfirm",
        new Object[] { list }, ob);
                QueryAll();

                MessageUtil.ShowTips("付款取消确认成功！");
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }
        //查询全部
        private void QueryAll()
        {
            try
            {
                dataTable2.Rows.Clear();
                string[] arrColumns = new string[] { "CHK", "ORG_NAME", "IS_DEPT", "SUPP_NAME", "ITEM_CLASS_CODE", "ITEM_CLASS_NAME", "PAY_TYPE_CODE", "PAY_TYPE_NAME", "TOTAL_REAL_PRICES", "BALANCE_NOTICE", "SUPP_CODE", "SUPP_BALANCE_CODE", "BANK_NAME", "BANK_ACCOUNT", "TOTAL_BUY_AMT", "TOTAL_BUY_AMT_TAX", "ACCOUNT_PERIOD", "FLAG", "IS_PRINT", "IS_PRINT_DESC", "CREATE_NAME", "CREATE_TIME", "REMARK", "ISAGREE_NAM", "ISAGREE_TIM", "MEM", "CONFIRMING", "BALANCE_NO" };
                string[] arrColumnsCaption = new string[] { "选择", "科室", "审批状态", "供应商", "物料中类", "物料中类", "付款方式", "付款方式", "付款金额", "付款通知书", "供应商", "结算代码", "开户银行", "银行账号", "不含税金额", "含税金额", "会计期", "标志位", "是否打印", "是否打印", "创建人", "创建时间", "备注", "审批人", "审批时间", "审批备注", "是否确认", "结算编号" };
                PublicPur.InitColumns(arrColumns, arrColumnsCaption, dataTable2, ultraGrid2, new string[] { "ITEM_CLASS_CODE", "PAY_TYPE_CODE", "SUPP_CODE", "TOTAL_BUY_AMT", "TOTAL_BUY_AMT_TAX", "ACCOUNT_PERIOD", "FLAG", "IS_PRINT" }, false, new string[] { "CHK" });
                ArrayList arrayList = new ArrayList();
                String stuts = "";
                if (txtAgree.Text.Equals("待审批"))
                {
                    stuts = "1";
                }
                else if (txtAgree.Text.Equals("已审批"))
                {
                    stuts = "2";
                }
                else if (txtAgree.Text.Equals("全部"))
                {
                    stuts = "3";
                }
                if (chkDate.Checked)
                {
                    arrayList.Add(dateBegin.DateTime.ToShortDateString() + " 00:00:00");
                    arrayList.Add(dateEnd.DateTime.ToShortDateString() + " 23:59:59");
                }
                else
                {
                    arrayList.Add("0001/01/01 00:00:00");
                    arrayList.Add("9999/12/31 23:59:59");
                }
                if (chkTEM_CLASS_NAME.Checked)
                {
                    arrayList.Add(ultraQueryTEM_CLASS_NAME.Text.Trim());
                    arrayList.Add(ultraQueryTEM_CLASS_NAME.Text.Trim());
                    arrayList.Add(ultraQueryTEM_CLASS_NAME.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }
                if (chkSUPP_NAME.Checked)
                {
                    arrayList.Add(ultraQuerySUPP_NAME.Text.Trim());
                    arrayList.Add(ultraQuerySUPP_NAME.Text.Trim());
                    arrayList.Add(ultraQuerySUPP_NAME.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }
                if (chkBALANCE_NO.Checked)
                {
                    arrayList.Add(txtQueryBALANCE_NO.Text.Trim());
                    arrayList.Add(txtQueryBALANCE_NO.Text.Trim());
                    arrayList.Add(txtQueryBALANCE_NO.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }

                DataTable dt = PublicServer.GetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.QueryAll",
    new Object[] { arrayList, stuts }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    dataTable2.Rows.Clear();
                    return;
                }
                SetSumCount();
                GridHelper.CopyDataToDatatable(dt, dataTable2, true);//把dt复制给dataTable1

                GridHelper.RefreshAndAutoSize(ultraGrid2);
                foreach(UltraGridRow urg in ultraGrid2.Rows)
                {
                    if(urg.Cells["CONFIRMING"].Value.Equals("已确认"))
                    {
                        urg.Appearance.BackColor = Color.LightGreen;
                    }
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        //部长审批
        private void DoAgreeBoss()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    MessageUtil.ShowTips("只有选择了已编制记录页才能进行审批操作！");
                    return;
                }

                if (ultraGrid2.ActiveRow == null || dataTable2.Rows.Count == 0)
                {
                    return;
                }

                frmExamineShow Fex = new frmExamineShow();
                Fex.ShowDialog();
                if (Fex.Status == null)
                {
                    return;
                }
                if (Fex.Status.Equals("2"))
                {
                    //string userId = UserInfo.GetUserID();
                    //string user = UserInfo.GetUserName();
                    //string resion = Fex.ExamineMessage;
                    //string strBALANCE_NO = ultraGrid2.ActiveRow.Cells["BALANCE_NO"].Text.Trim();

                    ArrayList list = new ArrayList();
                    //IQueryable<UltraGridRow> uGrid = ultraGrid2.Rows.AsQueryable().Where(" CHK = 'True'");
                    //ultraGrid2.UpdateData();
                    ultraGrid2.UpdateData();
                    DataRow[] arr = dataTable2.Select("CHK = 'True'");
                    if (arr.Length == 0)
                    {
                        MessageUtil.ShowTips("请选择要审批的数据！");
                        return;
                    }
                    //if (uGrid.Count() == 0)
                    //{
                    //    MessageUtil.ShowTips("请选择要审批的数据！");
                    //    return;
                    // }
                    foreach (DataRow dr in arr)
                    {
                        ArrayList all = new ArrayList();
                        all.Add(UserInfo.GetUserID());
                        all.Add(UserInfo.GetUserName());
                        all.Add(Fex.ExamineMessage);
                        all.Add(dr["BALANCE_NO"].ToString());
                        list.Add(all);
                    }

                    PublicServer.SetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.DoBoss",
        new Object[] { list }, ob);

                    QueryBalancePayRecord();

                    MessageUtil.ShowTips("审批成功！");
                }
                else if (Fex.Status.Equals("1"))
                {

                    ArrayList list = new ArrayList();
                    ultraGrid2.UpdateData();
                    DataRow[] arr = dataTable2.Select("CHK = 'True'");
                    if (arr.Length == 0)
                    {
                        MessageUtil.ShowTips("请选择要审批的数据！");
                        return;
                    }
                    foreach (DataRow dr in arr)
                    {
                        ArrayList all = new ArrayList();
                        all.Add(UserInfo.GetUserID());
                        all.Add(UserInfo.GetUserName());
                        all.Add(Fex.ExamineMessage);
                        all.Add(dr["BALANCE_NO"].ToString());
                        list.Add(all);
                    }

                    PublicServer.SetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.DontAgree",
        new Object[] { list }, ob);

                    QueryBalancePayRecord();

                    MessageUtil.ShowTips("审批成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        //部长助理审批
        private void DoAgreeAssist()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    MessageUtil.ShowTips("只有选择了已编制记录页才能进行审批操作！");
                    return;
                }

                if (ultraGrid2.ActiveRow == null || dataTable2.Rows.Count == 0)
                {
                    return;
                }

                frmExamineShow Fex = new frmExamineShow();
                Fex.ShowDialog();
                if (Fex.Status == null)
                {
                    return;
                }
                if (Fex.Status.Equals("2"))
                {
                    //string userId = UserInfo.GetUserID();
                    //string user = UserInfo.GetUserName();
                    //string resion = Fex.ExamineMessage;
                    //string strBALANCE_NO = ultraGrid2.ActiveRow.Cells["BALANCE_NO"].Text.Trim();

                    ArrayList list = new ArrayList();
                    //IQueryable<UltraGridRow> uGrid = ultraGrid2.Rows.AsQueryable().Where(" CHK = 'True'");
                    //ultraGrid2.UpdateData();
                    ultraGrid2.UpdateData();
                    DataRow[] arr = dataTable2.Select("CHK = 'True'");
                    if (arr.Length == 0)
                    {
                        MessageUtil.ShowTips("请选择要审批的数据！");
                        return;
                    }
                    //if (uGrid.Count() == 0)
                    //{
                    //    MessageUtil.ShowTips("请选择要审批的数据！");
                    //    return;
                    // }
                    foreach (DataRow dr in arr)
                    {
                        ArrayList all = new ArrayList();
                        all.Add(UserInfo.GetUserID());
                        all.Add(UserInfo.GetUserName());
                        all.Add(Fex.ExamineMessage);
                        all.Add(dr["BALANCE_NO"].ToString());
                        list.Add(all);
                    }

                    PublicServer.SetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.DoAssist",
        new Object[] { list }, ob);

                    QueryBalancePayRecord();

                    MessageUtil.ShowTips("审批成功！");
                }
                else if (Fex.Status.Equals("1"))
                {

                    ArrayList list = new ArrayList();
                    ultraGrid2.UpdateData();
                    DataRow[] arr = dataTable2.Select("CHK = 'True'");
                    if (arr.Length == 0)
                    {
                        MessageUtil.ShowTips("请选择要审批的数据！");
                        return;
                    }
                    foreach (DataRow dr in arr)
                    {
                        ArrayList all = new ArrayList();
                        all.Add(UserInfo.GetUserID());
                        all.Add(UserInfo.GetUserName());
                        all.Add(Fex.ExamineMessage);
                        all.Add(dr["BALANCE_NO"].ToString());
                        list.Add(all);
                    }

                    PublicServer.SetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.DontAgree",
        new Object[] { list }, ob);

                    QueryBalancePayRecord();

                    MessageUtil.ShowTips("审批成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }
        //部长审批
        private void DoAgreeDepting()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    MessageUtil.ShowTips("只有选择了已编制记录页才能进行审批操作！");
                    return;
                }

                if (ultraGrid2.ActiveRow == null || dataTable2.Rows.Count == 0)
                {
                    return;
                }

                frmExamineShow Fex = new frmExamineShow();
                Fex.ShowDialog();
                if (Fex.Status == null)
                {
                    return;
                }
                if (Fex.Status.Equals("2"))
                {
                    //string userId = UserInfo.GetUserID();
                    //string user = UserInfo.GetUserName();
                    //string resion = Fex.ExamineMessage;
                    //string strBALANCE_NO = ultraGrid2.ActiveRow.Cells["BALANCE_NO"].Text.Trim();
                                        
                    ArrayList list = new ArrayList();
                    //IQueryable<UltraGridRow> uGrid = ultraGrid2.Rows.AsQueryable().Where(" CHK = 'True'");
                    //ultraGrid2.UpdateData();
                    ultraGrid2.UpdateData();
                    DataRow[] arr = dataTable2.Select("CHK = 'True'");
                    if (arr.Length == 0)
                    {
                        MessageUtil.ShowTips("请选择要审批的数据！");
                        return;
                    }
                    //if (uGrid.Count() == 0)
                    //{
                    //    MessageUtil.ShowTips("请选择要审批的数据！");
                    //    return;
                    // }
                    foreach (DataRow dr in arr)
                    {
                        ArrayList all = new ArrayList();
                        all.Add(UserInfo.GetUserID());
                        all.Add(UserInfo.GetUserName());
                        all.Add(Fex.ExamineMessage);
                        all.Add(dr["BALANCE_NO"].ToString());
                        list.Add(all);
                    }
                    
                    PublicServer.SetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.DoDepting",
        new Object[] { list }, ob);

                    PublicServer.SetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.DoBoss",
        new Object[] { list }, ob);

                    QueryBalancePayRecord();

                    MessageUtil.ShowTips("审批成功！");
                }
                else if (Fex.Status.Equals("1"))
                {

                    ArrayList list = new ArrayList();
                    ultraGrid2.UpdateData();
                    DataRow[] arr = dataTable2.Select("CHK = 'True'");
                    if (arr.Length == 0)
                    {
                        MessageUtil.ShowTips("请选择要审批的数据！");
                        return;
                    }
                    foreach (DataRow dr in arr)
                    {
                    ArrayList all = new ArrayList();
                    all.Add(UserInfo.GetUserID());
                    all.Add(UserInfo.GetUserName());
                    all.Add(Fex.ExamineMessage);
                    all.Add(dr["BALANCE_NO"].ToString());
                    list.Add(all);
                    }
                    
                    PublicServer.SetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.DontAgree",
        new Object[] { list }, ob);

                    QueryBalancePayRecord();

                    MessageUtil.ShowTips("审批成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }
        //主管部长审批
        private void DoAgreeDept()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    MessageUtil.ShowTips("只有选择了已编制记录页才能进行审批操作！");
                    return;
                }

                if (ultraGrid2.ActiveRow == null || dataTable2.Rows.Count == 0)
                {
                    return;
                }

                frmExamineShow Fex = new frmExamineShow();
                Fex.ShowDialog();
                if (Fex.Status == null)
                {
                    return;
                }
                if (Fex.Status.Equals("2"))
                {
                    ArrayList list = new ArrayList();
                    //IQueryable<UltraGridRow> uGrid = ultraGrid2.Rows.AsQueryable().Where(" CHK = 'True'");
                    //ultraGrid2.UpdateData();
                    ultraGrid2.UpdateData();
                    DataRow[] arr = dataTable2.Select("CHK = 'True'");
                    if (arr.Length == 0)
                    {
                        MessageUtil.ShowTips("请选择要审批的数据！");
                        return;
                    }
                    //if (uGrid.Count() == 0)
                    //{
                    //    MessageUtil.ShowTips("请选择要审批的数据！");
                    //    return;
                    // }
                    foreach (DataRow dr in arr)
                    {
                        ArrayList all = new ArrayList();
                        all.Add(UserInfo.GetUserID());
                        all.Add(UserInfo.GetUserName());
                        all.Add(Fex.ExamineMessage);
                        all.Add(dr["BALANCE_NO"].ToString());
                        list.Add(all);
                    }
                    PublicServer.SetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.DoDept",
        new Object[] { list }, ob);

                    QueryBalancePayRecord();

                    MessageUtil.ShowTips("审批成功！");
                }
                else if (Fex.Status.Equals("1"))
                {
                    ArrayList list = new ArrayList();
                    //IQueryable<UltraGridRow> uGrid = ultraGrid2.Rows.AsQueryable().Where(" CHK = 'True'");
                    //ultraGrid2.UpdateData();
                    ultraGrid2.UpdateData();
                    DataRow[] arr = dataTable2.Select("CHK = 'True'");
                    if (arr.Length == 0)
                    {
                        MessageUtil.ShowTips("请选择要审批的数据！");
                        return;
                    }
                    foreach (DataRow dr in arr)
                    {
                        ArrayList all = new ArrayList();
                        all.Add(UserInfo.GetUserID());
                        all.Add(UserInfo.GetUserName());
                        all.Add(Fex.ExamineMessage);
                        all.Add(dr["BALANCE_NO"].ToString());
                        list.Add(all);
                    }
                    PublicServer.SetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.DontAgree",
        new Object[] { list }, ob);

                    QueryBalancePayRecord();

                    MessageUtil.ShowTips("审批成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        //主管审批
        private void DoAgree()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    MessageUtil.ShowTips("只有选择了已编制记录页才能进行审批操作！");
                    return;
                }

                if (ultraGrid2.ActiveRow == null || dataTable2.Rows.Count == 0)
                {
                    return;
                }

                frmExamineShow Fex = new frmExamineShow();
                Fex.ShowDialog();
                if (Fex.Status == null)
                {
                    return;
                }
                if (Fex.Status.Equals("2"))
                {
                    ArrayList list = new ArrayList();
                    ultraGrid2.UpdateData();
                    DataRow[] arr = dataTable2.Select("CHK = 'True'");
                    if (arr.Length == 0)
                    {
                        MessageUtil.ShowTips("请选择要审批的数据！");
                        return;
                    }
                    foreach (DataRow dr in arr)
                    {
                        ArrayList all = new ArrayList();
                        all.Add(UserInfo.GetUserID());
                        all.Add(UserInfo.GetUserName());
                        all.Add(Fex.ExamineMessage);
                        all.Add(dr["BALANCE_NO"].ToString());
                        list.Add(all);
                    }
                    PublicServer.SetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.DoAgree",
        new Object[] { list }, ob);

                    QueryBalancePayRecord();

                    MessageUtil.ShowTips("审批成功！");
                }
                else if (Fex.Status.Equals("1"))
                {
                    ArrayList list = new ArrayList();
                    ultraGrid2.UpdateData();
                    DataRow[] arr = dataTable2.Select("CHK = 'True'");
                    if (arr.Length == 0)
                    {
                        MessageUtil.ShowTips("请选择要审批的数据！");
                        return;
                    }
                    foreach (DataRow dr in arr)
                    {
                        ArrayList all = new ArrayList();
                        all.Add(UserInfo.GetUserID());
                        all.Add(UserInfo.GetUserName());
                        all.Add(Fex.ExamineMessage);
                        all.Add(dr["BALANCE_NO"].ToString());
                        list.Add(all);
                    }
                    PublicServer.SetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.DontAgree",
        new Object[] { list }, ob);

                    QueryBalancePayRecord();

                    MessageUtil.ShowTips("审批成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }
        //提报
        private void DoCommit()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    MessageUtil.ShowTips("只有选择了已编制记录页才能进行提报操作！");
                    return;
                }

                if (ultraGrid2.ActiveRow == null || dataTable2.Rows.Count == 0)
                {
                    return;
                }

                if (MessageUtil.ShowYesNoAndQuestion("是否确认对此记录进行提报？") == DialogResult.Yes)
                {
                    string userId = UserInfo.GetUserID();
                    string user = UserInfo.GetUserName();
                    string strBALANCE_NO = ultraGrid2.ActiveRow.Cells["BALANCE_NO"].Text.Trim();

                    ArrayList all = new ArrayList();
                    all.Add(userId);
                    all.Add(user);
                    all.Add(strBALANCE_NO);
                    PublicServer.SetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.DoCommit",
        new Object[] { all, strBALANCE_NO }, ob);

                    QueryBalancePayRecord();

                    MessageUtil.ShowTips("提报成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        //提报
        private void DoDelete()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    MessageUtil.ShowTips("只有选择了已编制记录页才能进行提报操作！");
                    return;
                }

                if (ultraGrid2.ActiveRow == null || dataTable2.Rows.Count == 0)
                {
                    return;
                }

                if (MessageUtil.ShowYesNoAndQuestion("是否确认对此记录进行作废？") == DialogResult.Yes)
                {
                    string strBALANCE_NO = ultraGrid2.ActiveRow.Cells["BALANCE_NO"].Text.Trim();
                    PublicServer.SetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.DoDelete",
        new Object[] {  strBALANCE_NO }, ob);

                    QueryAll();
                    MessageUtil.ShowTips("作废成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        private void QueryBalancePayRecord()
        {
            try
            {
                dataTable2.Rows.Clear();
                ArrayList arrayList = new ArrayList();
                String stuts = "";
                if (txtAgree.Text.Equals("待审批"))
                {
                    stuts = "1";
                }
                else if (txtAgree.Text.Equals("已审批"))
                {
                    stuts = "2";
                }
                else if (txtAgree.Text.Equals("全部"))
                {
                    stuts = "3";
                }
                if (UserInfo.GetUserID() != null || UserInfo.GetUserID() != "")
                {
                    arrayList.Add(UserInfo.GetUserID());
                }
                else
                {
                    arrayList.Add("");
                }
                if (chkDate.Checked)
                {
                    arrayList.Add(dateBegin.DateTime.ToShortDateString() + " 00:00:00");
                    arrayList.Add(dateEnd.DateTime.ToShortDateString() + " 23:59:59");
                }
                else
                {
                    arrayList.Add("0001/01/01 00:00:00");
                    arrayList.Add("9999/12/31 23:59:59");
                }
                if (chkTEM_CLASS_NAME.Checked)
                {
                    arrayList.Add(ultraQueryTEM_CLASS_NAME.Text.Trim());
                    arrayList.Add(ultraQueryTEM_CLASS_NAME.Text.Trim());
                    arrayList.Add(ultraQueryTEM_CLASS_NAME.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }
                if (chkSUPP_NAME.Checked)
                {
                    arrayList.Add(ultraQuerySUPP_NAME.Text.Trim());
                    arrayList.Add(ultraQuerySUPP_NAME.Text.Trim());
                    arrayList.Add(ultraQuerySUPP_NAME.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }
                if (chkBALANCE_NO.Checked)
                {
                    arrayList.Add(txtQueryBALANCE_NO.Text.Trim());
                    arrayList.Add(txtQueryBALANCE_NO.Text.Trim());
                    arrayList.Add(txtQueryBALANCE_NO.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }

                DataTable dt = PublicServer.GetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.QueryBalancePayRecord",
    new Object[] { arrayList,stuts }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    dataTable2.Rows.Clear();
                    return;
                }
                SetSumCount();
                GridHelper.CopyDataToDatatable(dt, dataTable2, true);//把dt复制给dataTable1

                GridHelper.RefreshAndAutoSize(ultraGrid2);

                //foreach()
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        //科长查询
        private void QueryIsAgree()
        {
            try
            {
                dataTable2.Rows.Clear();
                string[] arrColumns = new string[] { "CHK", "ORG_NAME", "IS_DEPT", "SUPP_NAME", "ITEM_CLASS_CODE", "ITEM_CLASS_NAME", "PAY_TYPE_CODE", "PAY_TYPE_NAME", "TOTAL_REAL_PRICES", "BALANCE_NOTICE", "SUPP_CODE", "SUPP_BALANCE_CODE", "BANK_NAME", "BANK_ACCOUNT", "TOTAL_BUY_AMT", "TOTAL_BUY_AMT_TAX", "ACCOUNT_PERIOD", "FLAG", "IS_PRINT", "IS_PRINT_DESC", "CREATE_NAME", "CREATE_TIME", "REMARK", "ISAGREE_NAM", "ISAGREE_TIM", "MEM", "CONFIRMING", "BALANCE_NO" };
                string[] arrColumnsCaption = new string[] { "选择", "科室", "审批状态", "供应商", "物料中类", "物料中类", "付款方式", "付款方式", "付款金额", "付款通知书", "供应商", "结算代码", "开户银行", "银行账号", "不含税金额", "含税金额", "会计期", "标志位", "是否打印", "是否打印", "创建人", "创建时间", "备注", "审批人", "审批时间", "审批备注", "是否确认", "结算编号" };
                PublicPur.InitColumns(arrColumns, arrColumnsCaption, dataTable2, ultraGrid2, new string[] { "ITEM_CLASS_CODE", "PAY_TYPE_CODE", "SUPP_CODE", "TOTAL_BUY_AMT", "TOTAL_BUY_AMT_TAX", "ACCOUNT_PERIOD", "FLAG", "IS_PRINT" }, false, new string[] { "CHK" });
                ArrayList arrayList = new ArrayList();
                String stuts = "";
                if(txtAgree.Text.Equals("待审批"))
                {
                    stuts = "1";
                }
                else if(txtAgree.Text.Equals("已审批"))
                {
                    stuts = "2";
                }
                else if (txtAgree.Text.Equals("全部"))
                {
                    stuts = "3";
                }
                if (UserInfo.GetUserID()!=null||UserInfo.GetUserID() != "")
                {
                    arrayList.Add(UserInfo.GetUserID());
                }
                else
                {
                    arrayList.Add("");
                }
                if (chkDate.Checked)
                {
                    arrayList.Add(dateBegin.DateTime.ToShortDateString() + " 00:00:00");
                    arrayList.Add(dateEnd.DateTime.ToShortDateString() + " 23:59:59");
                }
                else
                {
                    arrayList.Add("0001/01/01 00:00:00");
                    arrayList.Add("9999/12/31 23:59:59");
                }
                if (chkTEM_CLASS_NAME.Checked)
                {
                    arrayList.Add(ultraQueryTEM_CLASS_NAME.Text.Trim());
                    arrayList.Add(ultraQueryTEM_CLASS_NAME.Text.Trim());
                    arrayList.Add(ultraQueryTEM_CLASS_NAME.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }
                if (chkSUPP_NAME.Checked)
                {
                    arrayList.Add(ultraQuerySUPP_NAME.Text.Trim());
                    arrayList.Add(ultraQuerySUPP_NAME.Text.Trim());
                    arrayList.Add(ultraQuerySUPP_NAME.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }
                if (chkBALANCE_NO.Checked)
                {
                    arrayList.Add(txtQueryBALANCE_NO.Text.Trim());
                    arrayList.Add(txtQueryBALANCE_NO.Text.Trim());
                    arrayList.Add(txtQueryBALANCE_NO.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }

                DataTable dt = PublicServer.GetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.QueryIsAgree",
    new Object[] { arrayList,stuts }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    dataTable2.Rows.Clear();
                    return;
                }
                SetSumCount();
                GridHelper.CopyDataToDatatable(dt, dataTable2, true);//把dt复制给dataTable1

                GridHelper.RefreshAndAutoSize(ultraGrid2);
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }


        //主管部长查询
        private void QueryIsDept()
        {
            try
            {
                dataTable2.Rows.Clear();
                string[] arrColumns = new string[] { "CHK", "ORG_NAME", "IS_DEPT", "SUPP_NAME", "ITEM_CLASS_CODE", "ITEM_CLASS_NAME", "PAY_TYPE_CODE", "PAY_TYPE_NAME", "TOTAL_REAL_PRICES", "BALANCE_NOTICE", "SUPP_CODE", "SUPP_BALANCE_CODE", "BANK_NAME", "BANK_ACCOUNT", "TOTAL_BUY_AMT", "TOTAL_BUY_AMT_TAX", "ACCOUNT_PERIOD", "FLAG", "IS_PRINT", "IS_PRINT_DESC", "CREATE_NAME", "CREATE_TIME", "REMARK", "ISAGREE_NAM", "ISAGREE_TIM", "MEM", "CONFIRMING", "BALANCE_NO" };
                string[] arrColumnsCaption = new string[] { "选择", "科室", "审批状态", "供应商", "物料中类", "物料中类", "付款方式", "付款方式", "付款金额", "付款通知书", "供应商", "结算代码", "开户银行", "银行账号", "不含税金额", "含税金额", "会计期", "标志位", "是否打印", "是否打印", "创建人", "创建时间", "备注", "审批人", "审批时间", "审批备注", "是否确认", "结算编号" };
                PublicPur.InitColumns(arrColumns, arrColumnsCaption, dataTable2, ultraGrid2, new string[] { "ITEM_CLASS_CODE", "PAY_TYPE_CODE", "SUPP_CODE", "TOTAL_BUY_AMT", "TOTAL_BUY_AMT_TAX", "ACCOUNT_PERIOD", "FLAG", "IS_PRINT" }, false, new string[] { "CHK" });
                ArrayList arrayList = new ArrayList();

                String stuts = "";
                if (txtAgree.Text.Equals("待审批"))
                {
                    stuts = "1";
                }
                else if (txtAgree.Text.Equals("已审批"))
                {
                    stuts = "2";
                }
                else if (txtAgree.Text.Equals("全部"))
                {
                    stuts = "3";
                }
                if (UserInfo.GetUserID() != null || UserInfo.GetUserID() != "")
                {
                    //if (UserInfo.GetUserID().Equals("yumzh"))
                    //{
                    //    arrayList.Add("yumz");
                    //}
                    //else
                    //{
                        arrayList.Add(UserInfo.GetUserID());
                    //}
                }
                else
                {
                    arrayList.Add("");
                }
                if (chkDate.Checked)
                {
                    arrayList.Add(dateBegin.DateTime.ToShortDateString() + " 00:00:00");
                    arrayList.Add(dateEnd.DateTime.ToShortDateString() + " 23:59:59");
                }
                else
                {
                    arrayList.Add("0001/01/01 00:00:00");
                    arrayList.Add("9999/12/31 23:59:59");
                }
                if (chkTEM_CLASS_NAME.Checked)
                {
                    arrayList.Add(ultraQueryTEM_CLASS_NAME.Text.Trim());
                    arrayList.Add(ultraQueryTEM_CLASS_NAME.Text.Trim());
                    arrayList.Add(ultraQueryTEM_CLASS_NAME.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }
                if (chkSUPP_NAME.Checked)
                {
                    arrayList.Add(ultraQuerySUPP_NAME.Text.Trim());
                    arrayList.Add(ultraQuerySUPP_NAME.Text.Trim());
                    arrayList.Add(ultraQuerySUPP_NAME.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }
                if (chkBALANCE_NO.Checked)
                {
                    arrayList.Add(txtQueryBALANCE_NO.Text.Trim());
                    arrayList.Add(txtQueryBALANCE_NO.Text.Trim());
                    arrayList.Add(txtQueryBALANCE_NO.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }

                DataTable dt = PublicServer.GetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.QueryIsDept",
    new Object[] { arrayList,stuts }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    dataTable2.Rows.Clear();
                    return;
                }
                SetSumCount();
                GridHelper.CopyDataToDatatable(dt, dataTable2, true);//把dt复制给dataTable1

                GridHelper.RefreshAndAutoSize(ultraGrid2);
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        //部长助理查询
        private void QueryAssist()
        {
            try
            {
                dataTable2.Rows.Clear();
                string[] arrColumns = new string[] { "CHK", "ORG_NAME", "IS_DEPT", "SUPP_NAME", "ITEM_CLASS_CODE", "ITEM_CLASS_NAME", "PAY_TYPE_CODE", "PAY_TYPE_NAME", "TOTAL_REAL_PRICES", "BALANCE_NOTICE", "SUPP_CODE", "SUPP_BALANCE_CODE", "BANK_NAME", "BANK_ACCOUNT", "TOTAL_BUY_AMT", "TOTAL_BUY_AMT_TAX", "ACCOUNT_PERIOD", "FLAG", "IS_PRINT", "IS_PRINT_DESC", "CREATE_NAME", "CREATE_TIME", "REMARK", "ISAGREE_NAM", "ISAGREE_TIM", "MEM", "CONFIRMING", "BALANCE_NO" };
                string[] arrColumnsCaption = new string[] { "选择", "科室", "审批状态", "供应商", "物料中类", "物料中类", "付款方式", "付款方式", "付款金额", "付款通知书", "供应商", "结算代码", "开户银行", "银行账号", "不含税金额", "含税金额", "会计期", "标志位", "是否打印", "是否打印", "创建人", "创建时间", "备注", "审批人", "审批时间", "审批备注", "是否确认", "结算编号" };
                PublicPur.InitColumns(arrColumns, arrColumnsCaption, dataTable2, ultraGrid2, new string[] { "ITEM_CLASS_CODE", "PAY_TYPE_CODE", "SUPP_CODE", "TOTAL_BUY_AMT", "TOTAL_BUY_AMT_TAX", "ACCOUNT_PERIOD", "FLAG", "IS_PRINT" }, false, new string[] { "CHK" });
                ArrayList arrayList = new ArrayList();
                String stuts = "";
                if (txtAgree.Text.Equals("待审批"))
                {
                    stuts = "1";
                }
                else if (txtAgree.Text.Equals("已审批"))
                {
                    stuts = "2";
                }
                else if (txtAgree.Text.Equals("全部"))
                {
                    stuts = "3";
                }
                if (chkDate.Checked)
                {
                    arrayList.Add(dateBegin.DateTime.ToShortDateString() + " 00:00:00");
                    arrayList.Add(dateEnd.DateTime.ToShortDateString() + " 23:59:59");
                }
                else
                {
                    arrayList.Add("0001/01/01 00:00:00");
                    arrayList.Add("9999/12/31 23:59:59");
                }
                if (chkTEM_CLASS_NAME.Checked)
                {
                    arrayList.Add(ultraQueryTEM_CLASS_NAME.Text.Trim());
                    arrayList.Add(ultraQueryTEM_CLASS_NAME.Text.Trim());
                    arrayList.Add(ultraQueryTEM_CLASS_NAME.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }
                if (chkSUPP_NAME.Checked)
                {
                    arrayList.Add(ultraQuerySUPP_NAME.Text.Trim());
                    arrayList.Add(ultraQuerySUPP_NAME.Text.Trim());
                    arrayList.Add(ultraQuerySUPP_NAME.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }
                if (chkBALANCE_NO.Checked)
                {
                    arrayList.Add(txtQueryBALANCE_NO.Text.Trim());
                    arrayList.Add(txtQueryBALANCE_NO.Text.Trim());
                    arrayList.Add(txtQueryBALANCE_NO.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }

                DataTable dt = PublicServer.GetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.QueryAssist",
    new Object[] { arrayList, stuts }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    dataTable2.Rows.Clear();
                    return;
                }
                SetSumCount();
                GridHelper.CopyDataToDatatable(dt, dataTable2, true);//把dt复制给dataTable1

                GridHelper.RefreshAndAutoSize(ultraGrid2);
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        //部长查询
        private void QueryIsDepting()
        {
            try
            {
                dataTable2.Rows.Clear();
                string[] arrColumns = new string[] { "CHK", "ORG_NAME", "IS_DEPT", "SUPP_NAME", "ITEM_CLASS_CODE", "ITEM_CLASS_NAME", "PAY_TYPE_CODE", "PAY_TYPE_NAME", "TOTAL_REAL_PRICES", "BALANCE_NOTICE", "SUPP_CODE", "SUPP_BALANCE_CODE", "BANK_NAME", "BANK_ACCOUNT", "TOTAL_BUY_AMT", "TOTAL_BUY_AMT_TAX", "ACCOUNT_PERIOD", "FLAG", "IS_PRINT", "IS_PRINT_DESC", "CREATE_NAME", "CREATE_TIME", "REMARK", "ISAGREE_NAM", "ISAGREE_TIM", "MEM", "CONFIRMING", "BALANCE_NO" };
                string[] arrColumnsCaption = new string[] { "选择", "科室", "审批状态", "供应商", "物料中类", "物料中类", "付款方式", "付款方式", "付款金额", "付款通知书", "供应商", "结算代码", "开户银行", "银行账号", "不含税金额", "含税金额", "会计期", "标志位", "是否打印", "是否打印", "创建人", "创建时间", "备注", "审批人", "审批时间", "审批备注", "是否确认", "结算编号" };
                PublicPur.InitColumns(arrColumns, arrColumnsCaption, dataTable2, ultraGrid2, new string[] { "ITEM_CLASS_CODE", "PAY_TYPE_CODE", "SUPP_CODE", "TOTAL_BUY_AMT", "TOTAL_BUY_AMT_TAX", "ACCOUNT_PERIOD", "FLAG", "IS_PRINT" }, false, new string[] { "CHK" });
                ArrayList arrayList = new ArrayList();
                String stuts = "";
                if (txtAgree.Text.Equals("待审批"))
                {
                    stuts = "1";
                }
                else if (txtAgree.Text.Equals("已审批"))
                {
                    stuts = "2";
                }
                else if (txtAgree.Text.Equals("全部"))
                {
                    stuts = "3";
                }
                if (chkDate.Checked)
                {
                    arrayList.Add(dateBegin.DateTime.ToShortDateString() + " 00:00:00");
                    arrayList.Add(dateEnd.DateTime.ToShortDateString() + " 23:59:59");
                }
                else
                {
                    arrayList.Add("0001/01/01 00:00:00");
                    arrayList.Add("9999/12/31 23:59:59");
                }
                if (chkTEM_CLASS_NAME.Checked)
                {
                    arrayList.Add(ultraQueryTEM_CLASS_NAME.Text.Trim());
                    arrayList.Add(ultraQueryTEM_CLASS_NAME.Text.Trim());
                    arrayList.Add(ultraQueryTEM_CLASS_NAME.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }
                if (chkSUPP_NAME.Checked)
                {
                    arrayList.Add(ultraQuerySUPP_NAME.Text.Trim());
                    arrayList.Add(ultraQuerySUPP_NAME.Text.Trim());
                    arrayList.Add(ultraQuerySUPP_NAME.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }
                if (chkBALANCE_NO.Checked)
                {
                    arrayList.Add(txtQueryBALANCE_NO.Text.Trim());
                    arrayList.Add(txtQueryBALANCE_NO.Text.Trim());
                    arrayList.Add(txtQueryBALANCE_NO.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }
                String flag = "0";
                if (UserInfo.GetDeptid().StartsWith("002001036"))
                {
                    flag = "2";
                }
                if (UserInfo.GetDeptid().StartsWith("002001029"))
                {
                    flag = "1";
                }
                String isWithAmtTax = "0";
                if (this.CustomInfo == "dl")
                {
                    isWithAmtTax = "1";
                }
                DataTable dt = PublicServer.GetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.QueryIsDepting",
    new Object[] { arrayList, stuts, flag, isWithAmtTax}, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    dataTable2.Rows.Clear();
                    return;
                }
                SetSumCount();
                GridHelper.CopyDataToDatatable(dt, dataTable2, true);//把dt复制给dataTable1

                GridHelper.RefreshAndAutoSize(ultraGrid2);
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        //副总查询
        private void QueryIsBoss()
        {
            try
            {
                dataTable2.Rows.Clear();
                string[] arrColumns = new string[] { "CHK", "ORG_NAME", "IS_DEPT", "SUPP_NAME", "ITEM_CLASS_CODE", "ITEM_CLASS_NAME", "PAY_TYPE_CODE", "PAY_TYPE_NAME", "TOTAL_REAL_PRICES", "BALANCE_NOTICE", "SUPP_CODE", "SUPP_BALANCE_CODE", "BANK_NAME", "BANK_ACCOUNT", "TOTAL_BUY_AMT", "TOTAL_BUY_AMT_TAX", "ACCOUNT_PERIOD", "FLAG", "IS_PRINT", "IS_PRINT_DESC", "CREATE_NAME", "CREATE_TIME", "REMARK", "ISAGREE_NAM", "ISAGREE_TIM", "MEM", "CONFIRMING", "BALANCE_NO" };
                string[] arrColumnsCaption = new string[] { "选择", "科室", "审批状态", "供应商", "物料中类", "物料中类", "付款方式", "付款方式", "付款金额", "付款通知书", "供应商", "结算代码", "开户银行", "银行账号", "不含税金额", "含税金额", "会计期", "标志位", "是否打印", "是否打印", "创建人", "创建时间", "备注", "审批人", "审批时间", "审批备注", "是否确认", "结算编号" };
                PublicPur.InitColumns(arrColumns, arrColumnsCaption, dataTable2, ultraGrid2, new string[] { "ITEM_CLASS_CODE", "PAY_TYPE_CODE", "SUPP_CODE", "TOTAL_BUY_AMT", "TOTAL_BUY_AMT_TAX", "ACCOUNT_PERIOD", "FLAG", "IS_PRINT" }, false, new string[] { "CHK" });
                ArrayList arrayList = new ArrayList();
                String stuts = "";
                if (txtAgree.Text.Equals("待审批"))
                {
                    stuts = "1";
                }
                else if (txtAgree.Text.Equals("已审批"))
                {
                    stuts = "2";
                }
                else if (txtAgree.Text.Equals("全部"))
                {
                    stuts = "3";
                }
                if (chkDate.Checked)
                {
                    arrayList.Add(dateBegin.DateTime.ToShortDateString() + " 00:00:00");
                    arrayList.Add(dateEnd.DateTime.ToShortDateString() + " 23:59:59");
                }
                else
                {
                    arrayList.Add("0001/01/01 00:00:00");
                    arrayList.Add("9999/12/31 23:59:59");
                }
                if (chkTEM_CLASS_NAME.Checked)
                {
                    arrayList.Add(ultraQueryTEM_CLASS_NAME.Text.Trim());
                    arrayList.Add(ultraQueryTEM_CLASS_NAME.Text.Trim());
                    arrayList.Add(ultraQueryTEM_CLASS_NAME.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }
                if (chkSUPP_NAME.Checked)
                {
                    arrayList.Add(ultraQuerySUPP_NAME.Text.Trim());
                    arrayList.Add(ultraQuerySUPP_NAME.Text.Trim());
                    arrayList.Add(ultraQuerySUPP_NAME.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }
                if (chkBALANCE_NO.Checked)
                {
                    arrayList.Add(txtQueryBALANCE_NO.Text.Trim());
                    arrayList.Add(txtQueryBALANCE_NO.Text.Trim());
                    arrayList.Add(txtQueryBALANCE_NO.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }

                DataTable dt = PublicServer.GetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.QueryIsBoss",
    new Object[] { arrayList, stuts }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    dataTable2.Rows.Clear();
                    return;
                }
                SetSumCount();
                GridHelper.CopyDataToDatatable(dt, dataTable2, true);//把dt复制给dataTable1

                GridHelper.RefreshAndAutoSize(ultraGrid2);
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        private void ConfirmBalancePay()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 0)
                {
                    MessageUtil.ShowTips("只有选择了未编制记录页才能进行编制操作！");
                    return;
                }

                if (txtSUPP_BALANCE_CODE.Text.Trim() == "")
                {
                    MessageUtil.ShowTips("结算代码不能为空！");
                    return;
                }
                if (txt_notice.Text.Trim() == "")
                {
                    MessageUtil.ShowTips("付款通知书不能为空！");
                    return;
                }
                if (ultraPAY_TYPE_NAME.Text.Trim() =="")
                {
                    if (MessageUtil.ShowYesNoAndQuestion("付款方式确定为空?") == DialogResult.Yes)
                    {
                        ultraPAY_TYPE_NAME.Text = "";
                    }              
                }
                if (txtTOTAL_REAL_PRICE.Text.Trim() == "")
                {
                    if (MessageUtil.ShowYesNoAndQuestion("付款金额确定为空?") == DialogResult.Yes)
                    {
                        txtTOTAL_REAL_PRICE.Text = "";
                    }
                }

                if (MessageUtil.ShowYesNoAndQuestion("是否生成付款通知书？") == DialogResult.Yes)
                {
                    string userId = UserInfo.GetUserID();
                    string user = UserInfo.GetUserName();

                    ArrayList all = new ArrayList();
                    all.Add(ultraTEM_CLASS_NAME.Value.ToString());
                    all.Add(ultraTEM_CLASS_NAME.Text.Trim());
                    all.Add(ultraPAY_TYPE_NAME.Value.ToString());
                    all.Add(ultraPAY_TYPE_NAME.Text.Trim());
                    all.Add(ultraSUPP_NAME.Value.ToString());
                    all.Add(ultraSUPP_NAME.Text.Trim());
                    all.Add(txtSUPP_BALANCE_CODE.Text.Trim());
                    all.Add(txtBANK_NAME.Text.Trim());
                    all.Add(txtBANK_ACCOUNT.Text.Trim());
                    all.Add("");
                    all.Add("");
                    all.Add(txtTOTAL_REAL_PRICE.Text.Trim());//付款金额
                    all.Add(remark.Text.ToString());//备注
                    all.Add(userId);
                    all.Add(user);
                    all.Add(txt_notice.Text.ToString()+"付款通知书");

                    PublicServer.SetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.ConfirmBalancePay",
        new Object[] { all }, ob);

                    MessageUtil.ShowTips("付款通知书生成成功！");
                    txt_notice.Clear();
                    ultraTEM_CLASS_NAME.Clear();
                    ultraPAY_TYPE_NAME.Clear();
                    txtTOTAL_REAL_PRICE.Clear();
                    ultraSUPP_NAME.Clear();
                    txtSUPP_BALANCE_CODE.Clear();
                    remark.Clear();

                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        private void CancelBalancePay()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    MessageUtil.ShowTips("只有选择了已编制记录页才能进行取消操作！");
                    return;
                }

                if (ultraGrid2.ActiveRow == null || dataTable2.Rows.Count == 0)
                {
                    return;
                }

                if (MessageUtil.ShowYesNoAndQuestion("是否确认对此记录取消编制？") == DialogResult.Yes)
                {
                    string userId = UserInfo.GetUserID();
                    string user = UserInfo.GetUserName();
                    string strBALANCE_NO = ultraGrid2.ActiveRow.Cells["BALANCE_NO"].Text.Trim();
              

                    ArrayList all = new ArrayList();
                    all.Add(userId);
                    all.Add(user);
                    all.Add(strBALANCE_NO);
                    PublicServer.SetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.CancelBalancePay",
        new Object[] { all, strBALANCE_NO }, ob);

                    QueryBalancePayRecord();

                    MessageUtil.ShowTips("撤销成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        private void PrintBalancePay()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    return;
                }

                this.Cursor = Cursors.WaitCursor;
                UltraGridRow ugr = ultraGrid2.ActiveRow;
                if (ugr == null)
                {
                    MessageUtil.ShowWarning("请选择您要打印的付款通知书！");
                    return;
                }
                string abc = ultraGrid2.ActiveRow.Cells["BALANCE_NO"].Text.Trim();
                string agree = ultraGrid2.ActiveRow.Cells["IS_DEPT"].Text.Trim();
                //if(!agree.Equals("部长同意"))
                //{
                //    MessageUtil.ShowWarning("付款通知书没有完全审批或审批不通过,不允许打印！");
                //    return;
                //}
                    string strurl = "";
                    //if (ob.MainUrl.StartsWith("http://127.0.0.1"))
                    //{
                    //strurl = "http://localhost:8075/webroot/decision/view/report?viewlet=RepPmsBalanceBillManagePay.cpt&op=view" + "&abc=" + abc;
                    //}
                    //else
                    //{
                    strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepPmsBalanceBillManagePay.cpt&op=view"+"&abc=" + abc;
                    //}
                    comm.printReport(this.ob, strurl, "付款通知书打印");
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认打印？") == DialogResult.Yes)
                    {

                        ArrayList all = new ArrayList();
                        all.Add("2");
                        all.Add("1");
                        all.Add(abc);
                        PublicServer.SetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.UpdateBalancePayFlag",
            new Object[] { all }, ob);

                        QueryBalancePayRecord();
                        PublicPur.ActiveOperateRow(ultraGrid2, "BALANCE_NO", abc);
                    //FrmRepExcel fBug = new FrmRepExcel(ob, strurl);
                    //fBug.AutoSize = true;
                    //fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
                    //fBug.WindowState = FormWindowState.Maximized;
                    //fBug.Text = "采购付款通知书";
                    //fBug.Show();
                }
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }
        }
        private void CancelPrint()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    return;
                }

                this.Cursor = Cursors.WaitCursor;
                UltraGridRow ugr = ultraGrid2.ActiveRow;
                if (ugr == null)
                {
                    MessageUtil.ShowWarning("请选择您要取消打印的付款通知书！");
                    return;
                }

                if (MessageUtil.ShowYesNoAndQuestion("是否确认取消打印？") == DialogResult.Yes)
                {
                    string strBALANCE_NO = ultraGrid2.ActiveRow.Cells["BALANCE_NO"].Text.Trim();

                    ArrayList all = new ArrayList();
                    all.Add("1");
                    all.Add("2");
                    all.Add(strBALANCE_NO);
                    PublicServer.SetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.UpdateBalancePayFlag",
        new Object[] { all }, ob);

                    QueryBalancePayRecord();
                    PublicPur.ActiveOperateRow(ultraGrid2, "BALANCE_NO", strBALANCE_NO);                
                }
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }
        }

        private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
        {

        }

        private void chkDate_CheckedChanged(object sender, EventArgs e)
        {
            ultraQuerySUPP_NAME.Enabled = chkSUPP_NAME.Checked;
        }

        private void chkTEM_CLASS_NAME_CheckedChanged(object sender, EventArgs e)
        {
            ultraQueryTEM_CLASS_NAME.Enabled = chkTEM_CLASS_NAME.Checked;
        }

        private void chkSUPP_NAME_CheckedChanged(object sender, EventArgs e)
        {
            ultraQuerySUPP_NAME.Enabled = chkSUPP_NAME.Checked;
        }

        private void chkBALANCE_NO_CheckedChanged(object sender, EventArgs e)
        {
            txtQueryBALANCE_NO.Enabled = chkBALANCE_NO.Checked;
        }

        private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (ultraTabControl1.SelectedTab.Index == 0)
            {

            }
            else if (ultraTabControl1.SelectedTab.Index == 1)
            {

            }
        }

        private void txtTOTAL_REAL_PRICE_TextChanged(object sender, EventArgs e)
        {
            if (!StringUtil.Is_Below_zero(txtTOTAL_REAL_PRICE.Text.Trim()))
            {
                txtTOTAL_REAL_PRICE.Text = "0";
            }
            else
            {
                if (ultraSUPP_NAME.Value != null && ultraSUPP_NAME.Text.Trim() != "")
                {
                    ArrayList arrayList = new ArrayList();
                    arrayList.Add(ultraSUPP_NAME.Value.ToString());
                    DataTable dt = PublicServer.GetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.QueryMoney",
       new Object[] { arrayList }, ob);
                    if (!dt.Rows[0]["WITH_AMT_TAX"].Equals("0"))
                    {
                        if (Convert.ToDouble(txtTOTAL_REAL_PRICE.Text.ToString()) > Convert.ToDouble(dt.Rows[0]["WITH_AMT_TAX"].ToString()))
                            MessageUtil.ShowTips("付款金额大于预计合同金额!");
                    }
                    
                }
            }
            //ultraTextEditor1.Text = BalanceClassCommon.NumGetStr(Convert.ToDouble(txtTOTAL_REAL_PRICE.Text.ToString().Trim()));
            ultraLabel3.Text = MoneySmallToBig(txtTOTAL_REAL_PRICE.Text.ToString().Trim());
        }

        private void ultraTEM_CLASS_NAME_TextChanged(object sender, EventArgs e)
        {
            if(ultraTEM_CLASS_NAME.Text.ToString()!=""||ultraTEM_CLASS_NAME.Text.ToString()!=null)
            {
                item = ultraTEM_CLASS_NAME.Text.ToString();
            }
            QuerySUPP_NAME(item);
        }

        private void ultraSUPP_NAME_TextChanged(object sender, EventArgs e)
        {
            try
            {
                txtBANK_NAME.Text = "";
                txtBANK_ACCOUNT.Text = "";

                if (ultraSUPP_NAME.Value != null && ultraSUPP_NAME.Text.Trim() != "")
                {
                    if(ultraPAY_TYPE_NAME.Text.Trim()!="")
                    {
                    ArrayList arrayList = new ArrayList();
                    arrayList.Add(ultraSUPP_NAME.Value.ToString());
                    arrayList.Add(ultraPAY_TYPE_NAME.Text.Trim().ToString());
                    DataTable dt = PublicServer.GetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.QuerySUPP_BANK",
      new Object[] { arrayList }, ob);

                    if (dt == null || dt.Rows.Count == 0)
                    {
                        return;
                    }
                    txtBANK_NAME.Text = dt.Rows[0]["BANK_NAME"].ToString();
                    txtBANK_ACCOUNT.Text = dt.Rows[0]["BANK_ACCOUNT"].ToString();
                    }
                    else if (ultraPAY_TYPE_NAME.Text.Trim() == "" || ultraPAY_TYPE_NAME.Text.Trim()==null)
                    {
                        ArrayList arrayList = new ArrayList();
                        arrayList.Add(ultraSUPP_NAME.Value.ToString());
                        DataTable dt = PublicServer.GetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.QuerySUPP_BANK1",
          new Object[] { arrayList }, ob);
                        if (dt == null || dt.Rows.Count == 0)
                        {
                            return;
                        }
                        txtBANK_NAME.Text = dt.Rows[0]["BANK_NAME"].ToString();
                        txtBANK_ACCOUNT.Text = dt.Rows[0]["BANK_ACCOUNT"].ToString();
                    }
                    ArrayList arrayList1 = new ArrayList();
                    arrayList1.Add(ultraSUPP_NAME.Value.ToString());
                  
                    DataTable dt1 = PublicServer.GetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.QuerySUPPbalanceCode",
       new Object[] { arrayList1 }, ob);
                    if(dt1 ==null||dt1.Rows.Count == 0)
                    {
                        txtSUPP_BALANCE_CODE.Text = "";
                    }
                    else
                    {
                        txtSUPP_BALANCE_CODE.Text = dt1.Rows[0]["BALANCE_CODE"].ToString();
                    }

                }
            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
                return;
            }
        }

        private void ultraPAY_TYPE_NAME_TextChanged(object sender, EventArgs e)
        {
            int num = 0;
            if(ultraSUPP_NAME.Value == null || ultraSUPP_NAME.Text.Trim() == "")
            {
                if (ultraSUPP_NAME.Text.Trim() == "" && ultraPAY_TYPE_NAME.Text.Trim() == "")
                {
                    MessageUtil.ShowTips("请先选择收款单位!");
                }
                ultraPAY_TYPE_NAME.Clear();
            }
            else
            {
                    ArrayList arrayList = new ArrayList();
                    arrayList.Add(ultraSUPP_NAME.Value.ToString());
                    arrayList.Add(ultraPAY_TYPE_NAME.Text.Trim().ToString());
                    DataTable dt = PublicServer.GetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.QuerySUPP_BANK",
      new Object[] { arrayList }, ob);

                    if (dt == null || dt.Rows.Count == 0)
                    {
                        return;
                    }
                    txtBANK_NAME.Text = dt.Rows[0]["BANK_NAME"].ToString();
                    txtBANK_ACCOUNT.Text = dt.Rows[0]["BANK_ACCOUNT"].ToString();
            }
               
        }

        #region 【将商品金额小写转换成大写】MoneySmallToBig
        /// <summary>
        /// 将商品金额小写转换成大写
        /// </summary>
        /// <param name="par">小写金额</param>
        /// <returns>处理后的大写金额</returns>
        public static string MoneySmallToBig(string par)
        {
            String[] Scale = { "分", "角", "元", "拾", "佰", "仟", "万", "拾", "佰", "仟", "亿", "拾", "佰", "仟", "兆", "拾", "佰", "仟" };
            String[] Base = { "零", "壹", "贰", "叁", "肆", "伍", "陆", "柒", "捌", "玖" };
            String Temp = par;
            string result = null;
            int index = Temp.IndexOf(".", 0, Temp.Length);//判断是否有小数点
            if (index != -1)
            {
                Temp = Temp.Remove(Temp.IndexOf("."), 1);
                for (int i = Temp.Length; i > 0; i--)
                {
                    int Data = Convert.ToInt16(Temp[Temp.Length - i]);
                    result += Base[Data - 48];
                    result += Scale[i - 1];
                }
            }
            else
            {
                for (int i = Temp.Length; i > 0; i--)
                {
                    int Data = Convert.ToInt16(Temp[Temp.Length - i]);
                    result += Base[Data - 48];
                    result += Scale[i + 1];
                }
            }
            return result;
        }
        #endregion

        private void FrmBalanceBillManage_Agree_Shown(object sender, EventArgs e)
        {
            ArrayList arrayList = new ArrayList();
            arrayList.Add(UserInfo.GetUserID());
            DataTable dt = PublicServer.GetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.QuerySignaturePay",
  new Object[] { arrayList }, ob);
            if (dt.Rows.Count > 0)
            {
                if (dt.Rows[0]["DEPT_NAME"].Equals("业务员"))
                {
                    if (toolMenu.Toolbars[0].Tools.Exists("Query")) { toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Confirm")) { toolMenu.Toolbars[0].Tools["Confirm"].InstanceProps.Visible = DefaultableBoolean.True; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Cancel")) { toolMenu.Toolbars[0].Tools["Cancel"].InstanceProps.Visible = DefaultableBoolean.True; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Commit")) { toolMenu.Toolbars[0].Tools["Commit"].InstanceProps.Visible = DefaultableBoolean.True; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Print")) { toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.True; }
                    if (toolMenu.Toolbars[0].Tools.Exists("CancelPrint")) { toolMenu.Toolbars[0].Tools["CancelPrint"].InstanceProps.Visible = DefaultableBoolean.True; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Close")) { toolMenu.Toolbars[0].Tools["Close"].InstanceProps.Visible = DefaultableBoolean.True; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryIsAgree")) { toolMenu.Toolbars[0].Tools["QueryIsAgree"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryIsDept")) { toolMenu.Toolbars[0].Tools["QueryIsDept"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryAssist")) { toolMenu.Toolbars[0].Tools["QueryAssist"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryIsBoss")) { toolMenu.Toolbars[0].Tools["QueryIsBoss"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryIsDepting")) { toolMenu.Toolbars[0].Tools["QueryIsDepting"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgree")) { toolMenu.Toolbars[0].Tools["DoAgree"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgreeDept")) { toolMenu.Toolbars[0].Tools["DoAgreeDept"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgreeDepDoAgreeting")) { toolMenu.Toolbars[0].Tools["DoAgreeDepting"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgreeAssist")) { toolMenu.Toolbars[0].Tools["DoAgreeAssist"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgreeBoss")) { toolMenu.Toolbars[0].Tools["DoAgreeBoss"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryFinance")) { toolMenu.Toolbars[0].Tools["QueryFinance"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoExamineFinance")) { toolMenu.Toolbars[0].Tools["DoExamineFinance"].InstanceProps.Visible = DefaultableBoolean.False; }

                }
                else if (dt.Rows[0]["DEPT_NAME"].Equals("主管"))
                {
                    if (toolMenu.Toolbars[0].Tools.Exists("Query")) { toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Confirm")) { toolMenu.Toolbars[0].Tools["Confirm"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Cancel")) { toolMenu.Toolbars[0].Tools["Cancel"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Commit")) { toolMenu.Toolbars[0].Tools["Commit"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Print")) { toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("CancelPrint")) { toolMenu.Toolbars[0].Tools["CancelPrint"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Close")) { toolMenu.Toolbars[0].Tools["Close"].InstanceProps.Visible = DefaultableBoolean.True; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryIsAgree")) { toolMenu.Toolbars[0].Tools["QueryIsAgree"].InstanceProps.Visible = DefaultableBoolean.True; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryIsDept")) { toolMenu.Toolbars[0].Tools["QueryIsDept"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryAssist")) { toolMenu.Toolbars[0].Tools["QueryAssist"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryIsBoss")) { toolMenu.Toolbars[0].Tools["QueryIsBoss"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryIsDepting")) { toolMenu.Toolbars[0].Tools["QueryIsDepting"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgree")) { toolMenu.Toolbars[0].Tools["DoAgree"].InstanceProps.Visible = DefaultableBoolean.True; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgreeDept")) { toolMenu.Toolbars[0].Tools["DoAgreeDept"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgreeDepting")) { toolMenu.Toolbars[0].Tools["DoAgreeDepting"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgreeAssist")) { toolMenu.Toolbars[0].Tools["DoAgreeAssist"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgreeBoss")) { toolMenu.Toolbars[0].Tools["DoAgreeBoss"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryFinance")) { toolMenu.Toolbars[0].Tools["QueryFinance"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoExamineFinance")) { toolMenu.Toolbars[0].Tools["DoExamineFinance"].InstanceProps.Visible = DefaultableBoolean.False; }

                }
                else if (dt.Rows[0]["DEPT_NAME"].Equals("主管部长"))
                {
                    if (toolMenu.Toolbars[0].Tools.Exists("Query")) { toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Confirm")) { toolMenu.Toolbars[0].Tools["Confirm"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Cancel")) { toolMenu.Toolbars[0].Tools["Cancel"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Commit")) { toolMenu.Toolbars[0].Tools["Commit"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Print")) { toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("CancelPrint")) { toolMenu.Toolbars[0].Tools["CancelPrint"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Close")) { toolMenu.Toolbars[0].Tools["Close"].InstanceProps.Visible = DefaultableBoolean.True; }
                    //if (toolMenu.Toolbars[0].Tools.Exists("QueryIsAgree")) { toolMenu.Toolbars[0].Tools["QueryIsAgree"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryIsDept")) { toolMenu.Toolbars[0].Tools["QueryIsDept"].InstanceProps.Visible = DefaultableBoolean.True; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryAssist")) { toolMenu.Toolbars[0].Tools["QueryAssist"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryIsDepting")) { toolMenu.Toolbars[0].Tools["QueryIsDepting"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryIsBoss")) { toolMenu.Toolbars[0].Tools["QueryIsBoss"].InstanceProps.Visible = DefaultableBoolean.False; }
                    //if (toolMenu.Toolbars[0].Tools.Exists("DoAgree")) { toolMenu.Toolbars[0].Tools["DoAgree"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgreeDept")) { toolMenu.Toolbars[0].Tools["DoAgreeDept"].InstanceProps.Visible = DefaultableBoolean.True; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgreeDepting")) { toolMenu.Toolbars[0].Tools["DoAgreeDepting"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgreeAssist")) { toolMenu.Toolbars[0].Tools["DoAgreeAssist"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgreeBoss")) { toolMenu.Toolbars[0].Tools["DoAgreeBoss"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryFinance")) { toolMenu.Toolbars[0].Tools["QueryFinance"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoExamineFinance")) { toolMenu.Toolbars[0].Tools["DoExamineFinance"].InstanceProps.Visible = DefaultableBoolean.False; }

                }
                else if (dt.Rows[0]["DEPT_NAME"].Equals("部长助理"))
                {
                    if (toolMenu.Toolbars[0].Tools.Exists("Query")) { toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Confirm")) { toolMenu.Toolbars[0].Tools["Confirm"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Cancel")) { toolMenu.Toolbars[0].Tools["Cancel"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Commit")) { toolMenu.Toolbars[0].Tools["Commit"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Print")) { toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("CancelPrint")) { toolMenu.Toolbars[0].Tools["CancelPrint"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Close")) { toolMenu.Toolbars[0].Tools["Close"].InstanceProps.Visible = DefaultableBoolean.True; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryIsAgree")) { toolMenu.Toolbars[0].Tools["QueryIsAgree"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryIsDept")) { toolMenu.Toolbars[0].Tools["QueryIsDept"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryAssist")) { toolMenu.Toolbars[0].Tools["QueryAssist"].InstanceProps.Visible = DefaultableBoolean.True; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryIsDepting")) { toolMenu.Toolbars[0].Tools["QueryIsDepting"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryIsBoss")) { toolMenu.Toolbars[0].Tools["QueryIsBoss"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgree")) { toolMenu.Toolbars[0].Tools["DoAgree"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgreeDept")) { toolMenu.Toolbars[0].Tools["DoAgreeDept"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgreeDepting")) { toolMenu.Toolbars[0].Tools["DoAgreeDepting"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgreeAssist")) { toolMenu.Toolbars[0].Tools["DoAgreeAssist"].InstanceProps.Visible = DefaultableBoolean.True; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgreeBoss")) { toolMenu.Toolbars[0].Tools["DoAgreeBoss"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryFinance")) { toolMenu.Toolbars[0].Tools["QueryFinance"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoExamineFinance")) { toolMenu.Toolbars[0].Tools["DoExamineFinance"].InstanceProps.Visible = DefaultableBoolean.False; }

                }
                else if (dt.Rows[0]["DEPT_NAME"].Equals("部长"))
                {
                    if (toolMenu.Toolbars[0].Tools.Exists("Query")) { toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Confirm")) { toolMenu.Toolbars[0].Tools["Confirm"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Cancel")) { toolMenu.Toolbars[0].Tools["Cancel"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Commit")) { toolMenu.Toolbars[0].Tools["Commit"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Print")) { toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("CancelPrint")) { toolMenu.Toolbars[0].Tools["CancelPrint"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Close")) { toolMenu.Toolbars[0].Tools["Close"].InstanceProps.Visible = DefaultableBoolean.True; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryIsAgree")) { toolMenu.Toolbars[0].Tools["QueryIsAgree"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryIsDept")) { toolMenu.Toolbars[0].Tools["QueryIsDept"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryAssist")) { toolMenu.Toolbars[0].Tools["QueryAssist"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryIsDepting")) { toolMenu.Toolbars[0].Tools["QueryIsDepting"].InstanceProps.Visible = DefaultableBoolean.True; }
                    //if (toolMenu.Toolbars[0].Tools.Exists("QueryIsBoss")) { toolMenu.Toolbars[0].Tools["QueryIsBoss"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgree")) { toolMenu.Toolbars[0].Tools["DoAgree"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgreeDept")) { toolMenu.Toolbars[0].Tools["DoAgreeDept"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgreeDepting")) { toolMenu.Toolbars[0].Tools["DoAgreeDepting"].InstanceProps.Visible = DefaultableBoolean.True; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgreeAssist")) { toolMenu.Toolbars[0].Tools["DoAgreeAssist"].InstanceProps.Visible = DefaultableBoolean.False; }
                    //if (toolMenu.Toolbars[0].Tools.Exists("DoAgreeBoss")) { toolMenu.Toolbars[0].Tools["DoAgreeBoss"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryFinance")) { toolMenu.Toolbars[0].Tools["QueryFinance"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoExamineFinance")) { toolMenu.Toolbars[0].Tools["DoExamineFinance"].InstanceProps.Visible = DefaultableBoolean.False; }

                }
                else if (dt.Rows[0]["DEPT_NAME"].Equals("主管副总"))
                {
                    if (toolMenu.Toolbars[0].Tools.Exists("Query")) { toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Confirm")) { toolMenu.Toolbars[0].Tools["Confirm"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Cancel")) { toolMenu.Toolbars[0].Tools["Cancel"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Commit")) { toolMenu.Toolbars[0].Tools["Commit"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Print")) { toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("CancelPrint")) { toolMenu.Toolbars[0].Tools["CancelPrint"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Close")) { toolMenu.Toolbars[0].Tools["Close"].InstanceProps.Visible = DefaultableBoolean.True; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryIsAgree")) { toolMenu.Toolbars[0].Tools["QueryIsAgree"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryIsDept")) { toolMenu.Toolbars[0].Tools["QueryIsDept"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryAssist")) { toolMenu.Toolbars[0].Tools["QueryAssist"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryIsDepting")) { toolMenu.Toolbars[0].Tools["QueryIsDepting"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryIsBoss")) { toolMenu.Toolbars[0].Tools["QueryIsBoss"].InstanceProps.Visible = DefaultableBoolean.True; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgree")) { toolMenu.Toolbars[0].Tools["DoAgree"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgreeDept")) { toolMenu.Toolbars[0].Tools["DoAgreeDept"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgreeDepting")) { toolMenu.Toolbars[0].Tools["DoAgreeDepting"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgreeAssist")) { toolMenu.Toolbars[0].Tools["DoAgreeAssist"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgreeBoss")) { toolMenu.Toolbars[0].Tools["DoAgreeBoss"].InstanceProps.Visible = DefaultableBoolean.True; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryFinance")) { toolMenu.Toolbars[0].Tools["QueryFinance"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoExamineFinance")) { toolMenu.Toolbars[0].Tools["DoExamineFinance"].InstanceProps.Visible = DefaultableBoolean.False; }

                } else if(!String.IsNullOrWhiteSpace(this.CustomInfo)){
                    if (toolMenu.Toolbars[0].Tools.Exists("Query")) { toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Confirm")) { toolMenu.Toolbars[0].Tools["Confirm"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Cancel")) { toolMenu.Toolbars[0].Tools["Cancel"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Commit")) { toolMenu.Toolbars[0].Tools["Commit"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Print")) { toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("CancelPrint")) { toolMenu.Toolbars[0].Tools["CancelPrint"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("Close")) { toolMenu.Toolbars[0].Tools["Close"].InstanceProps.Visible = DefaultableBoolean.True; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryIsAgree")) { toolMenu.Toolbars[0].Tools["QueryIsAgree"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryIsDept")) { toolMenu.Toolbars[0].Tools["QueryIsDept"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryAssist")) { toolMenu.Toolbars[0].Tools["QueryAssist"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryIsDepting")) { toolMenu.Toolbars[0].Tools["QueryIsDepting"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryIsBoss")) { toolMenu.Toolbars[0].Tools["QueryIsBoss"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgree")) { toolMenu.Toolbars[0].Tools["DoAgree"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgreeDept")) { toolMenu.Toolbars[0].Tools["DoAgreeDept"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgreeDepting")) { toolMenu.Toolbars[0].Tools["DoAgreeDepting"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgreeAssist")) { toolMenu.Toolbars[0].Tools["DoAgreeAssist"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoAgreeBoss")) { toolMenu.Toolbars[0].Tools["DoAgreeBoss"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("QueryFinance")) { toolMenu.Toolbars[0].Tools["QueryFinance"].InstanceProps.Visible = DefaultableBoolean.True; }
                    if (toolMenu.Toolbars[0].Tools.Exists("DoExamineFinance")) { toolMenu.Toolbars[0].Tools["DoExamineFinance"].InstanceProps.Visible = DefaultableBoolean.True; }
                }
            }
            if (this.CustomInfo == "dl")
            {
                if (toolMenu.Toolbars[0].Tools.Exists("QueryIsDepting")) { toolMenu.Toolbars[0].Tools["QueryIsDepting"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("DoAgreeDepting")) { toolMenu.Toolbars[0].Tools["DoAgreeDepting"].InstanceProps.Visible = DefaultableBoolean.True; }
            }
        }

    }
}