MES_Client/TGMES/Core.StlMes.Client.Pms/balance/FrmBalanceBillManage_Pay.cs

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_Pay : FrmPmsBase
    {
        private string item = "";
        public FrmBalanceBillManage_Pay()
        {
            InitializeComponent();
        }

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

        private void FrmBalanceBillManage_Pay_Load(object sender, EventArgs e)
        {
            InitColumns();
            SetSumCount();
            InitBindBox();
            InitNotice();
           
    //        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_Pay
    //                }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[] { "BALANCE_NO", "BALANCE_NOTICE", "IS_DEPT", "ITEM_CLASS_CODE", "ITEM_CLASS_NAME", "PAY_TYPE_CODE", "PAY_TYPE_NAME", "SUPP_CODE", "SUPP_NAME", "SUPP_BALANCE_CODE", "BANK_NAME", "BANK_ACCOUNT", "TOTAL_BUY_AMT", "TOTAL_BUY_AMT_TAX", "TOTAL_REAL_PRICE", "ACCOUNT_PERIOD", "FLAG", "IS_PRINT", "IS_PRINT_DESC", "CREATE_NAME", "CREATE_TIME", "REMARK", "ISAGREE_NAM", "ISAGREE_TIM", "MEM", "CONFIRMING" };
            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_PRICE" }, 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", "getMatClassPay", 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 "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 "Close":
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面？") == DialogResult.Yes)
                    {
                        this.Close();
                    }
                    break;
            }
        }

        //主管副总审批
        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);

                    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 QueryBalancePayRecord()
        {
            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_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, 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.GetUserName().Equals("admin") && (UserInfo.GetUserID() != null || UserInfo.GetUserID() != ""))
                {
                    arrayList.Add(UserInfo.GetUserID());
                }
                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;
                }

                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", "BALANCE_NO", "ORG_NAME", "BALANCE_NOTICE", "IS_DEPT", "ITEM_CLASS_CODE", "ITEM_CLASS_NAME", "PAY_TYPE_CODE", "PAY_TYPE_NAME", "SUPP_CODE", "SUPP_NAME", "SUPP_BALANCE_CODE", "BANK_NAME", "BANK_ACCOUNT", "TOTAL_BUY_AMT", "TOTAL_BUY_AMT_TAX", "TOTAL_REAL_PRICE", "ACCOUNT_PERIOD", "FLAG", "IS_PRINT", "IS_PRINT_DESC", "CREATE_NAME", "CREATE_TIME", "REMARK", "ISAGREE_NAM", "ISAGREE_TIM", "MEM" };
                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;
                }

                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", "BALANCE_NO","ORG_NAME", "BALANCE_NOTICE", "IS_DEPT", "ITEM_CLASS_CODE", "ITEM_CLASS_NAME", "PAY_TYPE_CODE", "PAY_TYPE_NAME", "SUPP_CODE", "SUPP_NAME", "SUPP_BALANCE_CODE", "BANK_NAME", "BANK_ACCOUNT", "TOTAL_BUY_AMT", "TOTAL_BUY_AMT_TAX", "TOTAL_REAL_PRICE", "ACCOUNT_PERIOD", "FLAG", "IS_PRINT", "IS_PRINT_DESC", "CREATE_NAME", "CREATE_TIME", "REMARK", "ISAGREE_NAM", "ISAGREE_TIM", "MEM" };
                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;
                }

                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", "BALANCE_NO", "ORG_NAME", "BALANCE_NOTICE", "IS_DEPT", "ITEM_CLASS_CODE", "ITEM_CLASS_NAME", "PAY_TYPE_CODE", "PAY_TYPE_NAME", "SUPP_CODE", "SUPP_NAME", "SUPP_BALANCE_CODE", "BANK_NAME", "BANK_ACCOUNT", "TOTAL_BUY_AMT", "TOTAL_BUY_AMT_TAX", "TOTAL_REAL_PRICE", "ACCOUNT_PERIOD", "FLAG", "IS_PRINT", "IS_PRINT_DESC", "CREATE_NAME", "CREATE_TIME", "REMARK", "ISAGREE_NAM", "ISAGREE_TIM", "MEM" };
                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.QueryIsDepting",
    new Object[] { arrayList,stuts }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    dataTable2.Rows.Clear();
                    return;
                }

                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();
                    if (ultraGrid2.ActiveRow.Cells["IS_DEPT"].Text.Trim().Equals("部长同意"))//主管副总批准
                    {
                        MessageUtil.ShowTips("部长同意已经批准不允许撤销！");
                        return;
                    }
                    if (ultraGrid2.ActiveRow.Cells["CONFIRMING"].Text.Trim().Equals("已确认付款"))
                    {
                        MessageUtil.ShowTips("已确认付款不允许撤销编制！");
                        return;
                    }
                    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();
                String orgName = ultraGrid2.ActiveRow.Cells["ORG_NAME"].Text.Trim();
                if (ultraGrid2.ActiveRow.Cells["ORG_NAME"].Text.Trim().Contains("供应部"))
                    orgName = "1";
                else
                    orgName = "2";
                if (ultraGrid2.ActiveRow.Cells["CONFIRMING"].Text.Trim().Equals("已确认付款"))
                {
                    MessageUtil.ShowWarning("选中数据已经确认付款，不允许再次打印！");
                    return;
                }
                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 + "&ORG_NAME=" + orgName;
                    //}
                    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 (ultraGrid2.ActiveRow.Cells["CONFIRMING"].Text.Trim().Equals("已确认付款"))
                {
                    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 (!txtTOTAL_REAL_PRICE.Text.ToString().Substring(0,1).Equals("-"))
                        {
                            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()));
                if (!txtTOTAL_REAL_PRICE.Text.ToString().Equals("")&&!txtTOTAL_REAL_PRICE.Text.ToString().Substring(0, 1).Equals("-"))
                {
                    ultraLabel3.Text = MoneyToUpper(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;
        }

        /// <summary>
        /// 金额转换成中文大写金额（改）
        /// </summary>
        /// <param name="LowerMoney">eg:10.74</param>
        /// <returns></returns>
        public static string MoneyToUpper(string LowerMoney)
        {
            string functionReturnValue = null;
            bool IsNegative = false; // 是否是负数
            if (LowerMoney.Trim().Substring(0, 1) == "-")
            {
                // 是负数则先转为正数
                LowerMoney = LowerMoney.Trim().Remove(0, 1);
                IsNegative = true;
            }
            string strLower = null;
            string strUpart = null;
            string strUpper = null;
            int iTemp = 0;
            // 保留两位小数 123.489→123.49　　123.4→123.4
            LowerMoney = Math.Round(double.Parse(LowerMoney), 2).ToString();
            if (LowerMoney.IndexOf(".") > 0)
            {
                if (LowerMoney.IndexOf(".") == LowerMoney.Length - 2)
                {
                    LowerMoney = LowerMoney + "0";
                }
            }
            else
            {
                LowerMoney = LowerMoney + ".00";
            }
            strLower = LowerMoney;
            iTemp = 1;
            strUpper = "";
            while (iTemp <= strLower.Length)
            {
                switch (strLower.Substring(strLower.Length - iTemp, 1))
                {
                    case ".":
                        strUpart = "圆";
                        break;
                    case "0":
                        strUpart = "零";
                        break;
                    case "1":
                        strUpart = "壹";
                        break;
                    case "2":
                        strUpart = "贰";
                        break;
                    case "3":
                        strUpart = "叁";
                        break;
                    case "4":
                        strUpart = "肆";
                        break;
                    case "5":
                        strUpart = "伍";
                        break;
                    case "6":
                        strUpart = "陆";
                        break;
                    case "7":
                        strUpart = "柒";
                        break;
                    case "8":
                        strUpart = "捌";
                        break;
                    case "9":
                        strUpart = "玖";
                        break;
                }

                switch (iTemp)
                {
                    case 1:
                        strUpart = strUpart + "分";
                        break;
                    case 2:
                        strUpart = strUpart + "角";
                        break;
                    case 3:
                        strUpart = strUpart + "";
                        break;
                    case 4:
                        strUpart = strUpart + "";
                        break;
                    case 5:
                        strUpart = strUpart + "拾";
                        break;
                    case 6:
                        strUpart = strUpart + "佰";
                        break;
                    case 7:
                        strUpart = strUpart + "仟";
                        break;
                    case 8:
                        strUpart = strUpart + "万";
                        break;
                    case 9:
                        strUpart = strUpart + "拾";
                        break;
                    case 10:
                        strUpart = strUpart + "佰";
                        break;
                    case 11:
                        strUpart = strUpart + "仟";
                        break;
                    case 12:
                        strUpart = strUpart + "亿";
                        break;
                    case 13:
                        strUpart = strUpart + "拾";
                        break;
                    case 14:
                        strUpart = strUpart + "佰";
                        break;
                    case 15:
                        strUpart = strUpart + "仟";
                        break;
                    case 16:
                        strUpart = strUpart + "万";
                        break;
                    default:
                        strUpart = strUpart + "";
                        break;
                }

                strUpper = strUpart + strUpper;
                iTemp = iTemp + 1;
            }

            strUpper = strUpper.Replace("零拾", "零");
            strUpper = strUpper.Replace("零佰", "零");
            strUpper = strUpper.Replace("零仟", "零");
            strUpper = strUpper.Replace("零零零", "零");
            strUpper = strUpper.Replace("零零", "零");
            strUpper = strUpper.Replace("零角零分", "整");
            strUpper = strUpper.Replace("零分", "整");
            strUpper = strUpper.Replace("零角", "零");
            strUpper = strUpper.Replace("零亿零万零圆", "亿圆");
            strUpper = strUpper.Replace("亿零万零圆", "亿圆");
            strUpper = strUpper.Replace("零亿零万", "亿");
            strUpper = strUpper.Replace("零万零圆", "万圆");
            strUpper = strUpper.Replace("零亿", "亿");
            strUpper = strUpper.Replace("零万", "万");
            strUpper = strUpper.Replace("零圆", "圆");
            strUpper = strUpper.Replace("零零", "零");

            // 对壹圆以下的金额的处理
            if (strUpper.Substring(0, 1) == "圆")
            {
                strUpper = strUpper.Substring(1, strUpper.Length - 1);
            }
            if (strUpper.Substring(0, 1) == "零")
            {
                strUpper = strUpper.Substring(1, strUpper.Length - 1);
            }
            if (strUpper.Substring(0, 1) == "角")
            {
                strUpper = strUpper.Substring(1, strUpper.Length - 1);
            }
            if (strUpper.Substring(0, 1) == "分")
            {
                strUpper = strUpper.Substring(1, strUpper.Length - 1);
            }
            if (strUpper.Substring(0, 1) == "整")
            {
                strUpper = "零圆整";
            }
            functionReturnValue = strUpper;

            if (IsNegative == true)
            {
                return "负" + functionReturnValue;
            }
            else
            {
                return functionReturnValue;
            }
        }
        #endregion

        private void FrmBalanceBillManage_Pay_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("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; }
                }
                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; }
                }
                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; }
                }
                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; }
                }
                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; }
                }
                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; }

                }
            }
        }

    }
}