MES_Client/TGMES/Core.StlMes.Client.Sale.SaleFundMgt/FundUI/UIFrm/FrmFundInOutQuery.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using Infragistics.Win.UltraWinGrid;
namespace Core.StlMes.Client.Sale.SaleFundMgt.FundUI.UIFrm
{
    public partial class FrmFundInOutQuery : FrmFundBase
    {
        public FrmFundInOutQuery()
        {
            InitializeComponent();
        }

        private DataSet dsMain = new DataSet();
        private DataSet dsDetail = new DataSet();



        private string _buyercode = "";
        private string _buyercodeNotChooseInfo = "未选择客户名称";
        FundBLL.ValueList.PubValueList PubValueList = null;
        private Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Fund.FundBll fundBll = null;

        private string _busiseq = "";

        private System.Collections.Hashtable _hsDept = null;
        private void FrmFundInOutQuery_Load(object sender, EventArgs e)
        {
            this.checkBox1.Checked = true;
            this.dateTimePicker2.Value = System.DateTime.Now.AddDays(-System.DateTime.Now.Day+1);
            fundBll = new Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Fund.FundBll(this.ob);
            PubValueList = new Core.StlMes.Client.Sale.SaleFundMgt.FundBLL.ValueList.PubValueList(this.ob);

            dsDetail = base.GetDataSetByColumnName(GetTbColumn_SEL_FUND_CUST_FUNDINOUT(),
            new System.Collections.Hashtable(), base.GetFundColumnNameAndCaption());
            this.ultraGrid1.DataSource = dsDetail;
            Init();
            base.SetGridStyle(ref this.ultraGrid1);
            _hsDept = this.GetDeptIdAndSaleArea();
            this.ultraGrid1.DisplayLayout.Bands[0].Columns[this.BUSISEQ].Width = 110;

        }

        private void SetForeColor()
        {
            try
            {
                foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugrs in this.ultraGrid1.Rows)
                {
                    if (ugrs.Cells[this.ISVALID].Value.ToString() == "0")
                        ugrs.Appearance.ForeColor = Color.Red;
                }
            }
            catch
            { }
        }

        private void Init()
        {
            try
            {
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["BUYERCODE"].ValueList
                   = PubValueList.GetCustomerInfo();

                this.ultraGrid1.DisplayLayout.Bands[0].Columns[this.PREBUYERCODE].ValueList
                  = PubValueList.GetCustomerInfo();
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["ISVALID"].ValueList
                  = GetIsValid();

                this.ultraGrid1.DisplayLayout.Bands[0].Columns["MONEY_DELIVER"].ValueList
                  = GetMoneyDel();

                
            }
            catch
            { }

            //this.ultraGrid1.DisplayLayout.Bands[0].Columns["BUYERCODE"].MergedCellStyle = Infragistics.Win.UltraWinGrid.MergedCellStyle.Always;
            //this.ultraGrid1.DisplayLayout.Bands[0].Columns["SECONDACCOUNT"].MergedCellStyle = Infragistics.Win.UltraWinGrid.MergedCellStyle.Always;
            //this.ultraGrid1.DisplayLayout.Bands[0].Columns["BALANCESUBJECT"].MergedCellStyle = Infragistics.Win.UltraWinGrid.MergedCellStyle.Always;

            

          
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            if (ToolbarKey == "Query")
            {
                this.Query();
            }
            if (ToolbarKey == "Close")
            {
                this.Close();
            }
            if (ToolbarKey == "Export")
            {
                Core.StlMes.Client.Sale.Util.UtilUltraGrid.ExportGridDataToExcel("回款记录", this.ultraGrid1);
            }

            if (ToolbarKey == "Affrim")
            {
                this.Affrim();
            }

            if (ToolbarKey == "UnAffrim")
            {
                this.UnAffrim();
            }

        }

        private void UnAffrim()
        {
            try
            {
                Infragistics.Win.UltraWinGrid.UltraGridRow ugr = null;

                if (this.ultraGrid1.Rows.Count == 0)
                    return;
                if (this.ultraGrid1.Rows.Count == 1)
                    ugr = this.ultraGrid1.Rows[0];
                else
                    ugr = this.ultraGrid1.ActiveRow;
                if (ugr == null)
                {
                    Core.StlMes.Client.Sale.Util.MessageUtil.ShowError(" 请选择需要撤销审核的行 ");
                    return;
                }

                if (ugr.Cells[this.ISVALID].Value.ToString() == "0")
                {
                    Core.StlMes.Client.Sale.Util.MessageUtil.ShowError(" 未审核状态，不需要撤销 ");
                    return;
                }

                string busiseq = ugr.Cells[BUSISEQ].Value.ToString();
                string balnacesub = ugr.Cells[BALANCESUBJECT].Value.ToString();
                string buyercode = ugr.Cells[BUYERCODE].Value.ToString();
                string fundtype = ugr.Cells[FUNDTYPE].Value.ToString();
                string billno = "";
                double money = -Core.StlMes.Client.Sale.Util.ConverObject.ConvertToDouble(ugr.Cells[INOUTMONEY].Value);
                string import = base.GetUserName();
                string importtime = "";
                string inouttime = "";
                string remark = "";
                string orderno = "";
                double leavemny = 0;
                string seccount = ugr.Cells[SECONDACCOUNT].Value.ToString();
                string err = "";
                _busiseq = busiseq;
                base.GetIInstanceCustInout().UnAffrimFundRecord(busiseq, balnacesub, buyercode, fundtype, billno,
                    money, import, importtime, inouttime, remark,orderno, leavemny, seccount, out err);
                if (err.Length == 0)
                {
                    this.Query();
                    //     this.QueryInOutDetail();
                    Core.StlMes.Client.Sale.Util.MessageUtil.ShowTips(base._MessageSuccess);
                }
                else
                {
                    //  Core.StlMes.Client.Sale.Util.MessageUtil.ShowError(err);
                }

            }
            catch
            { }
        }

        private void Affrim()
        {
            try
            {
                Infragistics.Win.UltraWinGrid.UltraGridRow ugr = null;

                if (this.ultraGrid1.Rows.Count == 0)
                    return;
                if (this.ultraGrid1.Rows.Count == 1)
                    ugr = this.ultraGrid1.Rows[0];
                else
                    ugr = this.ultraGrid1.ActiveRow;
                if (ugr == null)
                {
                    Core.StlMes.Client.Sale.Util.MessageUtil.ShowError(" 请选择需要确认的行 ");
                    return;
                }

                if (ugr.Cells[this.ISVALID].Value.ToString() == "1")
                {
                    Core.StlMes.Client.Sale.Util.MessageUtil.ShowError(" 已经确认,不能重复确认 ");
                    return;
                }

                string busiseq = ugr.Cells[BUSISEQ].Value.ToString();
                string balnacesub = ugr.Cells[BALANCESUBJECT].Value.ToString();
                string buyercode = ugr.Cells[BUYERCODE].Value.ToString();
                string fundtype = ugr.Cells[FUNDTYPE].Value.ToString();
                string billno = "";
                double money = Core.StlMes.Client.Sale.Util.ConverObject.ConvertToDouble(ugr.Cells[INOUTMONEY].Value);
                string import = base.GetUserName();
                string importtime = "";
                string inouttime = "";
                string remark = "";
                string orderno = "";
                double leavemny = 0;
                string seccount = ugr.Cells[SECONDACCOUNT].Value.ToString();
                string err = "";
                _busiseq = busiseq;
                base.GetIInstanceCustInout().AffrimFundRecord(busiseq, balnacesub, buyercode, fundtype, billno,
                    money, import, importtime, inouttime, remark, orderno, leavemny, seccount, out err);
                if (err.Length == 0)
                {
                    this.Query();
                    //     this.QueryInOutDetail();
                    Core.StlMes.Client.Sale.Util.MessageUtil.ShowTips(base._MessageSuccess);
                }
                else
                {
                    //  Core.StlMes.Client.Sale.Util.MessageUtil.ShowError(err);
                }

            }
            catch
            { }
        }

        private void Query()
        {
            string balanceSubject = base.GetSaleOrgDesc();
            string buyercode = this._buyercode;
            Boolean isOpenFilter = true;
            string begintime = this.dateTimePicker2.Value.ToString(base._dateTimeFormatYyyyMmdd);
            string endtime = this.dateTimePicker3.Value.ToString(base._dateTimeFormatYyyyMmdd);
            if (!this.checkBox1.Checked)
            {
                begintime = System.DateTime.Now.AddYears(-100).ToString(base._dateTimeFormatYyyyMmdd);
                endtime = System.DateTime.Now.AddYears(2).ToString(base._dateTimeFormatYyyyMmdd);

            }

            DataSet ds = null;
            if (buyercode.Length > 0)
            {
                ds = base.GetIInstanceCustInout().GetSelFundCustFundInOutByBalanceAndBuyercodeAndTime
                 (balanceSubject, buyercode, begintime, endtime);
            }
            else
            {
                ds = base.GetIInstanceCustInout().GetSelFundCustFundInOutByBalanceAndTime(balanceSubject, begintime, endtime);
            }

            System.Collections.ArrayList list = new System.Collections.ArrayList();
            string deptName = "";
            try
            {
                list = (System.Collections.ArrayList)_hsDept[CoreFS.SA06.CoreUserInfo.UserInfo.GetDeptid()];
            }
            catch
            {
            }

            if ( list != null && list.Count > 0)
            {
                if (this.CustomInfo == "1")
                {
                    object[] obj = list.ToArray();
                    string[] s = new string[obj.Length];
                    for (int i = 0; i < s.Length; i++)
                    {
                        s[i] = obj[i].ToString();
                    }
                    if (isOpenFilter)
                    {
                        ds = Core.StlMes.Client.Sale.Util.UtilDataSet.GetDataSetWithRowFilter(ds, "SECONDACCOUNT", s);
                    }
                }
            }

            DataSet dsgm = new DataSet();

   

            try
            {
                if (dsgm.Tables[0].Rows.Count > 0)
                {
                    dsgm.Tables[0].TableName = ds.Tables[0].TableName;
                    ds.Merge(dsgm);
                }
            }
            catch
            { 
            }

           
            Core.StlMes.Client.Sale.Util.UtilDataSet.SetDataSetByMergeSameColumnName(ref this.dsDetail, ds);

            try
            {
                foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugrs in this.ultraGrid1.Rows)
                {
                    if (ugrs.Cells[this.BUSISEQ].Value.ToString() == this._busiseq)
                        ugrs.Activated = true;
                    break;
                }
            }
            catch
            { }

            SetForeColor();
        }

        private Infragistics.Win.ValueList GetIsValid()
        {
            Infragistics.Win.ValueList lit = new Infragistics.Win.ValueList();
            lit.ValueListItems.Add("0", "无效");
            lit.ValueListItems.Add("1", "有效");
            return lit;
        }

        private Infragistics.Win.ValueList GetMoneyDel()
        {
            Infragistics.Win.ValueList lit = new Infragistics.Win.ValueList();
            lit.ValueListItems.Add("0", "无");
            lit.ValueListItems.Add("1", "制造");
            lit.ValueListItems.Add("2", "集团");
            return lit;
        }

        private System.Collections.Hashtable GetDeptIdAndSaleArea()
        {
            System.Collections.Hashtable hs = new System.Collections.Hashtable();
            try
            {
                string sql = "  select * from slm_base_sale_area_typ where validflag = '1' ";
                DataSet ds = base.ExecuteReader(sql);

                if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
                {
                    return hs;
                }
                System.Collections.ArrayList list = null;
                foreach (DataRow dr in ds.Tables[0].Rows)
                {
                    list = new System.Collections.ArrayList();
                    if (hs.ContainsKey(dr["DEPARTID"].ToString()))
                    {
                        list = (System.Collections.ArrayList)hs[dr["DEPARTID"].ToString()];
                        list.Add(dr["SALE_AREA_DESC"].ToString());
                        hs.Remove(dr["DEPARTID"].ToString());
                        hs.Add(dr["DEPARTID"].ToString(), list);
                    }
                    else
                    {
                        list.Add(dr["SALE_AREA_DESC"].ToString());
                        hs.Add(dr["DEPARTID"].ToString(), list);
                    }



                }
            }
            catch
            { }

            return hs;

        }
        public string[] GetTbColumn_SEL_FUND_CUST_FUNDINOUT()
        {
            return new string[] 
            {
                "BUSISEQ",
                "BALANCESUBJECT",
                  "SECONDACCOUNT",
                "BUYERCODE",               
                "INOUTMONEY",
                "INOUTTIME",
                "FUNDTYPE",
                "BILLNO",
                "ISVALID",
                "MONEY_DELIVER",
                "PREBUYERCODE",
                "REMARK",
                "ORDERNO",
                "IMPORTOR",
                "IMPORTTIME",
                "AFFRIMPER",
                "AFFRIMDATE"
            };

        }

        private void button1_Click(object sender, EventArgs e)
        {
            UIDlgBox.DlgCustChoose custChoose = new Core.StlMes.Client.Sale.SaleFundMgt.FundUI.UIDlgBox.DlgCustChoose(this.ob);
            custChoose.CustUse = "100202";
            custChoose.SaleOrg = base.GetSaleOrg();
            custChoose.ShowDialog();
            if (custChoose.DialogResult == DialogResult.OK)
            {
                this.textBox1.Text = custChoose.customerName;
                _buyercode = custChoose.customerNo;
                this.Query();
            }
        }

        private string BALANCESUBJECT = "BALANCESUBJECT";
        private string BILLNO = "BILLNO";
        private string BUSISEQ = "BUSISEQ";
        private string BUYERCODE = "BUYERCODE";
        private string FUNDTYPE = "FUNDTYPE";
        private string IMPORTOR = "IMPORTOR";
        private string IMPORTTIME = "IMPORTTIME";
        private string INOUTMONEY = "INOUTMONEY";
        private string INOUTTIME = "INOUTTIME";
        private string ISVALID = "ISVALID";
        private string LEAVEMONEY = "LEAVEMONEY";
        private string REMARK = "REMARK";
        private string TOTALMONEY = "TOTALMONEY";
        private string UPDATETIME = "UPDATETIME";

        private string MONEY_DELIVER = "MONEY_DELIVER";
        private string PREBUYERCODE = "PREBUYERCODE";

        private string SECONDACCOUNT = "SECONDACCOUNT";

    }
}