MES_Client/TGMES/Core.StlMes.Client.Sale.UI.Balance/BalanceAccount/FrmBalanceTicketsAline.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;

namespace Core.StlMes.Client.Sale.UI.Balance.BalanceAccount
{
    public partial class FrmBalanceTicketsAline  : Core.StlMes.Client.Sale.Common.FrmStyleBase.FrmUIBase
    {
        public FrmBalanceTicketsAline()
        {
            InitializeComponent();
        }

        DataSet dsMain = new DataSet();

        DataSet dsGrid2 = new DataSet();
        DataSet dsGrid3 = new DataSet();

        private Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Balance.SlmBalanceInfo slmBalanceInfo = null;
        private Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.StaticData.PublicStaticVariable publicStaticVariable = null;
        private Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Trans.YdmZcLoadVehicleMatMgt ydmZcLoadVehicleMatMgt
         = null;

        private void InitOb()
        {
            ydmZcLoadVehicleMatMgt = new Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Trans.YdmZcLoadVehicleMatMgt(this.ob);
            slmBalanceInfo = new Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Balance.SlmBalanceInfo(this.ob);
 
        }

        private void InitDataSource()
        {
            dsMain = base.GetDataSetByColumnName(GetDataStructMain(), GetTbColumnNameAndDataType(),
               base.ConvertListStringArrayToHashTable(GetDataStructCaption()));
            this.ultraGrid1.DataSource = dsMain;

            dsGrid2 = base.GetDataSetByColumnName(this.GetGrid2DataStruct(), null, base.ConvertListStringArrayToHashTable(GetDataStructCaption()));
            this.ultraGrid2.DataSource = dsGrid2;

            dsGrid3 = base.GetDataSetByColumnName(this.GetGrid3DataStruct(), GetTbColumnNameAndDataType(), base.ConvertListStringArrayToHashTable(GetDataStructCaption()));
            this.ultraGrid3.DataSource = dsGrid3;

         
        }

        private void HiddenColumn()
        {
            try
            {
                this.ultraGrid1.DisplayLayout.Bands[0].Columns[this.CUSTOMER_NO].Hidden = true;
                this.ultraGrid1.DisplayLayout.Bands[0].Columns[this.CARRY_COMPANY_CODE].Hidden = true;
                this.ultraGrid1.DisplayLayout.Bands[0].Columns[this.RECEIV_NO].Hidden = true;
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["SUPPLY_UNIT"].Hidden = true;

                this.ultraGrid1.DisplayLayout.Bands[0].Columns[this.BILL_STATUS].Hidden = true;

                this.ultraGrid1.DisplayLayout.Bands[0].Columns[this.CARRY_COMPANY_NAME].Hidden = true;
              //  this.ultraGrid1.DisplayLayout.Bands[0].Columns[this.LOADVEHICLE_TYPE].Hidden = true;
               // this.ultraGrid1.DisplayLayout.Bands[0].Columns[this.TRANSMNY_TICKET_STATUS].Hidden = true;

                this.ultraGrid2.DisplayLayout.Bands[0].Columns[this.ORD_PK].Hidden = true;
                this.ultraGrid2.DisplayLayout.Bands[0].Columns[this.ORD_LN_PK].Hidden = true;
                this.ultraGrid2.DisplayLayout.Bands[0].Columns[this.ORD_LN_DLY_PK].Hidden = true;

                this.ultraGrid3.DisplayLayout.Bands[0].Columns[this.ORD_PK].Hidden = true;
                this.ultraGrid3.DisplayLayout.Bands[0].Columns[this.ORD_LN_PK].Hidden = true;
                this.ultraGrid3.DisplayLayout.Bands[0].Columns[this.ORD_LN_DLY_PK].Hidden = true;
            }
            catch
            { }
        }

        private void InitGridValeList()
        {
            try
            {
                this.ultraGrid1.DisplayLayout.Bands[0].Columns[this.LOADVEHICLE_TYPE]
                    .ValueList = GetLoadTypeStatusList();
            }
            catch
            { 
            }

            try
            {
                this.ultraGrid2.DisplayLayout.Bands[0].Columns["AGENCY_FL"]
                    .ValueList = GetAgnflStatusList();
            }
            catch
            {
            }

            try
            {
                this.ultraGrid2.DisplayLayout.Bands[0].Columns["TRANS_TPE"]
                    .ValueList = GetTransTpe();
            }
            catch
            {
            }

            try
            {
                this.ultraGrid3.DisplayLayout.Bands[0].Columns["TRANSIT_TYP"]
                    .ValueList = GetTransTpe();
            }
            catch
            {
            }

            try
            {
                this.ultraGrid3.DisplayLayout.Bands[0].Columns["AGENCY_FL"]
                    .ValueList = GetTransStatusList();
            }
            catch
            {
            }

        }


        protected override System.Collections.Hashtable GetTbColumnNameAndDataType()
        {
            System.Collections.Hashtable hs = new System.Collections.Hashtable();
            hs.Add( "BILL_CK","System.Boolean");
              hs.Add( "OUTSTOCK_CK","System.Boolean");
              hs.Add( "TRANSMNY_CK","System.Boolean");
              hs.Add(this.SELECT, "System.Boolean");
            return hs;
        }

        private Infragistics.Win.ValueList GetLoadTypeStatusList()
        {
            Infragistics.Win.ValueList lit = new Infragistics.Win.ValueList();
            lit.ValueListItems.Add("1", "实单");
            lit.ValueListItems.Add("2", "虚单");
            return lit;
        }

        private Infragistics.Win.ValueList GetAgnflStatusList()
        {
            Infragistics.Win.ValueList lit = new Infragistics.Win.ValueList();
            lit.ValueListItems.Add("0", "不代办");
            lit.ValueListItems.Add("1", "代办");
            return lit;
        }

        private Infragistics.Win.ValueList GetTransStatusList()
        {
            Infragistics.Win.ValueList lit = new Infragistics.Win.ValueList();
            lit.ValueListItems.Add("0", "无客户代办");
            lit.ValueListItems.Add("1", "TPCO代办");
            lit.ValueListItems.Add("2", "客户代办");
            return lit;
        }

        private Infragistics.Win.ValueList GetTransTpe()
        {
            Infragistics.Win.ValueList lit = new Infragistics.Win.ValueList();
            lit.ValueListItems.Add("110501", "汽运");
            lit.ValueListItems.Add("110502", "铁运");
            lit.ValueListItems.Add("110503", "船运");
            return lit;
        }

        private void InitCellAllowEdit()
        {
            foreach (string s in new string[] { this.BILL_CK,this.OUTSTOCK_CK,this.TRANSMNY_CK})
            {
            this.ultraGrid1.DisplayLayout.Bands[0].Columns[s].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
            this.ultraGrid1.DisplayLayout.Bands[0].Columns[s].CellAppearance.BackColor = base.GetEditColor();
            }

            foreach (string s in new string[] { this.SELECT, this.TRANSMNY, "STAMP_DUTY_MONEY", "DISBURASES_BILL", "TRANS_NO" })
            {
                this.ultraGrid3.DisplayLayout.Bands[0].Columns[s].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                this.ultraGrid3.DisplayLayout.Bands[0].Columns[s].CellAppearance.BackColor = base.GetEditColor();
            }
        }



       

        private void FrmBalanceTicketsAline_Load(object sender, EventArgs e)
        {
            this.dateTimePicker1.Value = System.DateTime.Now.AddMonths(-1);
            this.dateTimePicker3.Value = System.DateTime.Now.AddMonths(-1);
            dateTimePicker3.Enabled = false;
            dateTimePicker4.Enabled = false;
            this.radioButton1.Checked = true;
            InitOb();
            InitDataSource();
            HiddenColumn();
            InitGridValeList();
            base.SetGridStyle(ref this.ultraGrid1,ref this.ultraGrid2,ref this.ultraGrid3);
            InitCellAllowEdit();

            this.ultraGrid2.DisplayLayout.Bands[0].Columns["OUTSTOCKMNY"].MaskInput = "-nn,nnn,nnn.nnnnn";
            
        }


        protected override System.Collections.Hashtable GetGridColumnLength()
        {
            System.Collections.Hashtable hs = new System.Collections.Hashtable();
            hs.Add(this.LOADVEHICLE_TYPE, 60);
            hs.Add(this.BILL_TICKET_STATUS, 60);
            hs.Add(this.OUTSTOCK_TICKET_STATUS, 60);
            hs.Add(this.TRANSMNY_TICKET_STATUS, 60);

            hs.Add(this.ACT_COUNT, 60);
            hs.Add(this.ACT_WEIGHT, 60);
            hs.Add(SEND_NUM, 60);

            hs.Add(this.BILL_CK, 40);
            hs.Add(this.OUTSTOCK_CK, 60);
            hs.Add(this.TRANSMNY_CK, 40);
            hs.Add(this.CREATE_TIME, 100);

            hs.Add("ORDERNO", 110);
            hs.Add("JUDGE_STOVE_NO", 60);
            hs.Add("BATCH_NO", 50);
            hs.Add("QUANTITY", 50);
            hs.Add("WEIGHT", 90);
            hs.Add(this.SELECT, 50);
            hs.Add(this.TRANSMNY, 70);


            

            return hs;
        }


        private string _activeBillNo = "";

        public override void Query()
        {
            this._activeBillNo = "";
            Query01();
        }

        public void Query01()
        {
            DataSet ds = null;
            DateTime date3 = new DateTime();
            DateTime date4 = new DateTime();
            if (uchkDate.Checked)
            {
                date3=dateTimePicker3.Value;
                date4=dateTimePicker4.Value;
            }
            if (this.textBox7.Text.Trim().Length > 0)
            {
                if (this.radioButton1.Checked)  // 未对齐
                    ds = ydmZcLoadVehicleMatMgt.GetBillNoAfterCloseByBillno(this.textBox7.Text.Trim());
                else if (this.radioButton2.Checked) // 已对齐
                    ds = ydmZcLoadVehicleMatMgt.GetAlineBillNoAfterCloseByBillno(this.textBox7.Text.Trim());
                else if (this.radioButton3.Checked) // 已发送
                    ds = ydmZcLoadVehicleMatMgt.GetSendSuccessBillNoAfterCloseByBillno(this.textBox7.Text.Trim());
            }
            else
            {
                if (this.radioButton1.Checked) // 未对齐
                    ds = ydmZcLoadVehicleMatMgt.GetBillNoAfterCloseByBillCreateTime(this.dateTimePicker1.Value,
                        this.dateTimePicker2.Value,date3,date4);
                else if (this.radioButton2.Checked) // 已对齐
                    ds = ydmZcLoadVehicleMatMgt.GetAlineBillNoAfterCloseByBillCreateTime(this.dateTimePicker1.Value,
                        this.dateTimePicker2.Value,date3,date4);
                else if (this.radioButton3.Checked) // 已发送
                    ds = ydmZcLoadVehicleMatMgt.GetSendSuccessBillNoAfterCloseByBillCreateTime(this.dateTimePicker1.Value,
                       this.dateTimePicker2.Value,date3,date4);
            }
            if (!this.UserInfo.GetUserName().Equals("admin"))
                ds = base.GetDataSetByFilterDeptId(ds);
            ds = Util.UtilDataSet.GetDataSetWithRowFilter(ds, "SUPPLY_UNIT", this.CustomInfo);
            Core.StlMes.Client.Sale.Util.UtilDataSet.SetDataSetByMergeSameColumnName(ref this.dsMain, ds);
            
         
            try
            {
                if (this.radioButton1.Checked)
                {
                    foreach (DataRow dr in dsMain.Tables[0].Rows)
                    {
                        dr[this.BILL_CK] = (dr[this.BILL_TICKET_STATUS].ToString() == "N") ? true : false;
                        dr[this.OUTSTOCK_CK] = (dr[this.OUTSTOCK_TICKET_STATUS].ToString() == "N"
                            || dr[this.OUTSTOCK_TICKET_STATUS].ToString() == "OK"
                            ) ? true : false;
                        dr[this.TRANSMNY_CK] = (dr[this.TRANSMNY_TICKET_STATUS].ToString() == "N"
                            || dr[this.TRANSMNY_TICKET_STATUS].ToString() == "OK"
                            ) ? true : false;

                   
                    }
                }

                if (this.radioButton2.Checked || this.radioButton3.Checked)
                {
                    foreach (DataRow dr in dsMain.Tables[0].Rows)
                    {
                        dr[this.BILL_CK] = true;
                        dr[this.OUTSTOCK_CK] = true;
                        dr[this.TRANSMNY_CK] = true;
                    }
                }
            }
            catch
            { }

          

            if (_activeBillNo.Length == 0)
                return;

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

        private void QueryGrid2()
        {
            dsGrid2.Clear();
            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)
                    return;
                string loadvtype = ugr.Cells[this.LOADVEHICLE_TYPE].Value.ToString();
                string bill_sts = ugr.Cells[this.BILL_STATUS].Value.ToString();
                DataSet ds = null;
                if (loadvtype == "1" || bill_sts == "4" || bill_sts == "5" || bill_sts == "6")
                {
                     ds = this.ydmZcLoadVehicleMatMgt.GetAlineBillMateByBillNo(ugr.Cells[this.BILL_NO].Value.ToString());
                }
                else
                {
                    ds = this.ydmZcLoadVehicleMatMgt.GetAlineVirtualBillMateByBillNo(ugr.Cells[this.BILL_NO].Value.ToString());
                }
                Core.StlMes.Client.Sale.Util.UtilDataSet
                    .SetDataSetByMergeSameColumnName(ref this.dsGrid2, ds);
            }
            catch
            { 
            }
        }

        private void QueryGrid3()
        {
            this.dsGrid3.Clear();
            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)
                    return;
                DataSet ds = this.ydmZcLoadVehicleMatMgt.GetAlineTransDeliveryByBillNo(ugr.Cells[this.BILL_NO].Value.ToString());

                if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
                    return;
                DataRow[] dr0 = ds.Tables[0].Select(" AGENCY_FL = '0' ");
                DataRow[] dr1 = ds.Tables[0].Select(" AGENCY_FL = '1' ");
                DataRow[] dr2 = ds.Tables[0].Select(" AGENCY_FL = '2' ");

                DataSet dsClone = ds.Clone();
                if (dr0 != null && dr0.Length > 0)
                {
                    dsClone.Tables[0].Rows.Add(dr0[0].ItemArray);
                }
                if (dr1 != null && dr1.Length > 0)
                {
                    dsClone.Tables[0].Rows.Add(dr1[0].ItemArray);
                }
                if (dr2 != null && dr2.Length > 0)
                {
                    dsClone.Tables[0].Rows.Add(dr2[0].ItemArray);
                }

                Core.StlMes.Client.Sale.Util.UtilDataSet
                    .SetDataSetByMergeSameColumnName(ref this.dsGrid3, dsClone);
                SetDataSetGrid3();
                SetGrid3TicketNumAndMoney(ugr.Cells[this.BILL_NO].Value.ToString());
            }
            catch
            {
            }
        }

        private void SetGrid3TicketNumAndMoney(string billno)
        {
            if (this.dsGrid3 == null || this.dsGrid3.Tables.Count == 0 || this.dsGrid3.Tables[0].Rows.Count == 0)
                return;
            DataSet ds = this.slmBalanceInfo.GetSlmBalanceTransMoneyAskPlanid(billno);
            ds = Util.UtilDataSet.GetDataSetWithRowFilter(ds, "MONEY_TYPE", "运费");
            if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
                return;
            double ticketnum = 0;
            double money = 0;
            double stampDutyMoney = 0;
            string _disburasesbill = "";
            string _no = "";
            foreach (DataRow dr in this.dsGrid3.Tables[0].Rows)
            {
                ticketnum = 0;
                money = 0;
                stampDutyMoney = 0;
                string rowfilter = string.Format(@"  ASKPLAN_ID = '{0}' and AGENCY_FL = '{1}' ",

                    billno
                    , dr["AGENCY_FL"].ToString());
                DataRow[] drs = ds.Tables[0].Select(rowfilter);
                if (drs == null || drs.Length == 0)
                    continue;
                foreach (DataRow drm in drs)
                {
                    money = money + Util.ConverObject.ConvertToDouble(drm["MONEY"]);
                    stampDutyMoney = stampDutyMoney + Util.ConverObject.ConvertToDouble(drm["STAMP_DUTY_MONEY"]);
                    if (_disburasesbill.Equals(""))
                        _disburasesbill =  drm["DISBURASES_BILL"].ToString();
                    else
                        _disburasesbill = _disburasesbill + ";" + drm["DISBURASES_BILL"].ToString();

                    if (_no.Equals(""))
                        _no = drm["TRANS_NO"].ToString();
                    else
                        _no = _no + ";" + drm["TRANS_NO"].ToString();
                }
                dr["TRANSMNY"] = money;
                dr["STAMP_DUTY_MONEY"] = stampDutyMoney;
                dr["DISBURASES_BILL"] = _disburasesbill;
                dr["TRANS_NO"] = _no;

            }
        }

          //SELECT,
          //      TRANSMNY,
          //      "TICKETTYPE",

        private void SetDataSetGrid3()
        {
            try
            {
                foreach (DataRow dr in dsGrid3.Tables[0].Rows)
                {
                    dr["TICKETTYPE"] = GetTicketType(dr["AGENCY_FL"].ToString(),
                        "",  ""
                        
                        );
                    dr[this.SELECT] = false;
                }
            }
            catch
            { 
            }
 
        }

        private string GetTicketType(string agfl,string indexno,string recdliv)
        {
            return (agfl == "0") ? "报销" : (agfl == "1") ? "应收" : "冲减应收";
            if (recdliv == "TPCO库房" && agfl == "1")
                return "应收";
            if (recdliv == "TPCO库房" && agfl == "0")
                return "无";
            if (recdliv == "TPCO库房车板" && agfl == "1")
                return "报销";
            if (recdliv == "指定地点" && agfl == "1" && indexno == "1")
                return "报销";
            if (recdliv == "指定地点" && agfl == "0" && indexno == "1")
                return "冲减应收";
            if (recdliv == "指定地点" && agfl == "1" && indexno != "1")
                return "应收";
            if (recdliv == "指定地点" && agfl == "0" && indexno != "1")
                return "无";
            return "无";
        }

        // 确认对齐
        public override void Affrim()
        {
            if (this.ultraGrid1.Rows.Count == 0)
                return;
            if (this.ultraGrid1.Rows.Count == 1)
                this.ultraGrid1.Rows[0].Activated = true;
            Infragistics.Win.UltraWinGrid.UltraGridRow ugre = null;
            ugre = this.ultraGrid1.ActiveRow;
            if (ugre == null)
            {
                Core.StlMes.Client.Sale.Util.MessageUtil.ShowError("请选择需要确认的行");
                return;
            }
            ugre.Selected = true;
            this.ultraGrid1.UpdateData();
            this.ultraGrid3.UpdateData();

            System.Collections.ArrayList list = new System.Collections.ArrayList();

            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugr in this.ultraGrid1.Selected.Rows)
            {

                string[] temp = null;
                string billck = "0";
                string outck = "0";
                string transck = "0";
                string billno = ugr.Cells[this.BILL_NO].Value.ToString();

                billck = (ugr.Cells[this.BILL_CK].Value.ToString().ToUpper() == "TRUE") ? "1" : "0";
                outck = (ugr.Cells[this.OUTSTOCK_CK].Value.ToString().ToUpper() == "TRUE") ? "1" : "0";
                transck = (ugr.Cells[this.TRANSMNY_CK].Value.ToString().ToUpper() == "TRUE") ? "1" : "0";

                if (outck == "1")
                {
                    if (ugr.Cells[this.LOADVEHICLE_TYPE].Value.ToString() == "2" &&
                        (ugr.Cells[this.BILL_STATUS].Value.ToString() == "0"
                        || ugr.Cells[this.BILL_STATUS].Value.ToString() == "1"
                        || ugr.Cells[this.BILL_STATUS].Value.ToString() == "2"
                        || ugr.Cells[this.BILL_STATUS].Value.ToString() == "3"))
                    {
                        Core.StlMes.Client.Sale.Util.MessageUtil.ShowError("虚单且未进行二次关闭，不允许确认出库费");
                        return;
                    }


                }

                if (transck == "1" && ugr.Cells[this.TRANSMNY_TICKET_STATUS].Value.ToString() == "N")
                {
                    int index = 0;
                    // 先检查有没有输入运费
                    if (this.ultraGrid3.Rows.Count > 0)
                    {
                        foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugrs in this.ultraGrid3.Rows)
                        {
                            if (ugrs.Cells["TICKETTYPE"].Value.ToString() == "无")
                                continue;
                            string transmoney = ugrs.Cells[TRANSMNY].Value.ToString();
                            if (transmoney.Length == 0)
                            {
                                Core.StlMes.Client.Sale.Util.MessageUtil.ShowError("无运费维护，不能确认运费");
                                return;
                            }

                            //if (Core.StlMes.Client.Sale.Util.ConverObject.ConvertToDouble(transmoney) == 0)
                            //{
                            //    Core.StlMes.Client.Sale.Util.MessageUtil.ShowError("无运费维护，不能确认运费");
                            //    return;

                            //}
                            index++;


                        }

                        // 防止界面输入数值，但是没有保存，从后台查询数据校验

                        DataSet dstransmny = this.slmBalanceInfo.GetSlmBalanceTransMoneyAskPlanid(billno);
                        dstransmny = Util.UtilDataSet.GetDataSetWithRowFilter(dstransmny, "MONEY_TYPE", "运费");
                        try
                        {
                            if (index > dstransmny.Tables[0].Rows.Count)
                            {
                                Core.StlMes.Client.Sale.Util.MessageUtil.ShowError("无运费维护，不能确认运费");
                                return;
                            }
                        }
                        catch
                        {
                        }
                    }

                }

                temp = new string[] { ugr.Cells[this.BILL_NO].Value.ToString(),
                billck,outck,transck                
                };
                list.Add(temp);
            }
               

            if (list.Count == 0)
                return;
            string errMsg = "";
            this.ydmZcLoadVehicleMatMgt.AffrimAline(list, CoreFS.SA06.CoreUserInfo.UserInfo
                .GetUserName(), out errMsg);
            if (errMsg.Length > 0)
            {
            }
            else
            {
                Core.StlMes.Client.Sale.Util.MessageUtil.ShowTips("操作成功");
            }

            this.Query01();
        }

        // 取消对齐
        public override void UnAffrim()
        {
            if (this.ultraGrid1.Rows.Count == 0)
                return;
            if (this.ultraGrid1.Rows.Count == 1)
                this.ultraGrid1.Rows[0].Activated = true;
            Infragistics.Win.UltraWinGrid.UltraGridRow ugr = null;
            ugr = this.ultraGrid1.ActiveRow;
            if (ugr == null)
            {
                Core.StlMes.Client.Sale.Util.MessageUtil.ShowError("请选择需要取消确认的行");
                return;
            }

            this.ultraGrid1.UpdateData();
            System.Collections.ArrayList list = new System.Collections.ArrayList();
            string[] temp = null;
            string billck = "0";
            string outck = "0";
            string transck = "0";

            billck = (ugr.Cells[this.BILL_CK].Value.ToString().ToUpper() == "TRUE") ? "1" : "0";
            outck = (ugr.Cells[this.OUTSTOCK_CK].Value.ToString().ToUpper() == "TRUE") ? "1" : "0";
            transck = (ugr.Cells[this.TRANSMNY_CK].Value.ToString().ToUpper() == "TRUE") ? "1" : "0";
            temp = new string[] { ugr.Cells[this.BILL_NO].Value.ToString(),
                billck,outck,transck                
                };
                list.Add(temp);


            if (list.Count == 0)
                return;
            string errMsg = "";
            this.ydmZcLoadVehicleMatMgt.UnAffrimAline(list, CoreFS.SA06.CoreUserInfo.UserInfo
                .GetUserName(), out errMsg);
            if (errMsg.Length > 0)
            {
            }
            else
            {
                Core.StlMes.Client.Sale.Util.MessageUtil.ShowTips("操作成功");
            }
            this.Query01();
        }


        public override void Export()
        {
            Core.StlMes.Client.Sale.Util.UtilUltraGrid.ExportGridDataToExcel(this.Text, this.ultraGrid1);
        }

        // 保存运费
        public override void Add()
        {



            if (this.ultraGrid3.Rows.Count == 0)
                return;

            Infragistics.Win.UltraWinGrid.UltraGridRow ugs = this.ultraGrid1.ActiveRow;
            if(ugs == null ) return;
            if(ugs.Cells["TRANSMNY_TICKET_STATUS"].Value.ToString() == "已对齐" || ugs.Cells["TRANSMNY_TICKET_STATUS"].Value.ToString()  == "发送结算")
            {
                Core.StlMes.Client.Sale.Util.MessageUtil.ShowError("运费已经确认或结算接收，不允许保存");
                return;
            }

            this.ultraGrid3.UpdateData();
            string errMsg = "";
            string err = "";
            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugr in this.ultraGrid3.Rows)
            {
                if (ugr.Cells[this.SELECT].Value.ToString().ToUpper() == "TRUE")
                {
                    if (ugr.Cells["TICKETTYPE"].Value.ToString() == "无")
                        continue;
                    string billno = this.ultraGrid1.ActiveRow.Cells[this.BILL_NO].Value.ToString();
                    string transmoney = ugr.Cells[TRANSMNY].Value.ToString();
                    string stampDutyMoney = ugr.Cells["STAMP_DUTY_MONEY"].Value.ToString();
                    string tickettype = ugr.Cells["TICKETTYPE"].Value.ToString();
                    string agencyfl = ugr.Cells["AGENCY_FL"].Value.ToString();
                    string disburasesbill = ugr.Cells["DISBURASES_BILL"].Value.ToString();
                    string transNo = ugr.Cells["TRANS_NO"].Value.ToString();
                    string delvaddr = "";
                 //   string delvaddr = ugr.Cells["DELVRY_ADDR"].Value.ToString();
                    //string ordpk = ugr.Cells["ORD_PK"].Value.ToString();
                    //string ordLnPk = ugr.Cells["ORD_LN_PK"].Value.ToString();
                    //string ordLndPk = ugr.Cells["ORD_LN_DLY_PK"].Value.ToString();
                    //string indexNo = ugr.Cells["INDEX_SEQ"].Value.ToString();
                    string ordpk = "";
                    string ordLnPk = "";
                    string ordLndPk = "";
                    string indexNo = "";

                    this.slmBalanceInfo.SaveTransMoneyWithAlineTicket(billno,
                        transmoney,tickettype,agencyfl,delvaddr,ordpk,ordLnPk,ordLndPk,indexNo,
                        CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName(), "0", disburasesbill, transNo, stampDutyMoney, out errMsg);
                    if (errMsg.Length > 0)
                    {
                        return;
                       
                    }
             

                }
            }

            Core.StlMes.Client.Sale.Util.MessageUtil.ShowTips("操作成功");
            QueryGrid3();
        }

        // 发送结算
        public override void Send1()
        {
            if (this.ultraGrid1.Rows.Count == 0)
                return;
            if (this.ultraGrid1.Rows.Count == 1)
                this.ultraGrid1.Rows[0].Activated = true;
            Infragistics.Win.UltraWinGrid.UltraGridRow ugr1 = null;
            ugr1 = this.ultraGrid1.ActiveRow;
            if (ugr1 == null)
            {
                Core.StlMes.Client.Sale.Util.MessageUtil.ShowError("请选择需要发送的行");
                return;
            }

            string errMsg = "";
            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugr in this.ultraGrid1.Selected.Rows)
            {
                string billck = (ugr.Cells[this.BILL_TICKET_STATUS].Value.ToString() == "已对齐") ? "1" : "0";
                string outck = (ugr.Cells[this.OUTSTOCK_TICKET_STATUS].Value.ToString() == "已对齐"
                    || ugr.Cells[this.OUTSTOCK_TICKET_STATUS].Value.ToString() == "OK"
                    ) ? "1" : "0";
                string transck = (ugr.Cells[this.TRANSMNY_TICKET_STATUS].Value.ToString() == "已对齐"
                    || ugr.Cells[this.TRANSMNY_TICKET_STATUS].Value.ToString() == "OK"
                    ) ? "1" : "0";

                this.ydmZcLoadVehicleMatMgt.AcceptTicketBySendTicketToInvoice(ugr.Cells[this.BILL_NO].Value.ToString(),
                    GetoutStockMny(ugr.Cells[this.BILL_NO].Value.ToString()), ugr.Cells[this.LOADVEHICLE_TYPE].Value.ToString(), billck, outck, transck,
                    CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName(),

                    out errMsg
                    );
                if (errMsg.Length > 0)
                {
                    Core.StlMes.Client.Sale.Util.MessageUtil.ShowError(ugr.Cells[this.BILL_NO].Value.ToString() + "发送失败!" + errMsg);
                    return;
                }
            }
            if (errMsg.Length == 0)
            {
                Core.StlMes.Client.Sale.Util.MessageUtil.ShowTips("发送成功");
 
            }
            this.Query01();
        }

        public override void Send()
        {
            if (this.ultraGrid1.Rows.Count == 0)
                return;
            if (this.ultraGrid1.Rows.Count == 1)
                this.ultraGrid1.Rows[0].Activated = true;
            Infragistics.Win.UltraWinGrid.UltraGridRow ugr = null;
            ugr = this.ultraGrid1.ActiveRow;
            if (ugr == null)
            {
                Core.StlMes.Client.Sale.Util.MessageUtil.ShowError("请选择需要发送的行");
                return;
            }

            string errMsg = "";

            string billck = (ugr.Cells[this.BILL_TICKET_STATUS].Value.ToString() == "已对齐") ? "1" : "0";
            string outck = (ugr.Cells[this.OUTSTOCK_TICKET_STATUS].Value.ToString() == "已对齐"
                || ugr.Cells[this.OUTSTOCK_TICKET_STATUS].Value.ToString() == "OK"
                ) ? "1" : "0";
            string transck = (ugr.Cells[this.TRANSMNY_TICKET_STATUS].Value.ToString() == "已对齐"
                || ugr.Cells[this.TRANSMNY_TICKET_STATUS].Value.ToString() == "OK"
                ) ? "1" : "0";

            this.ydmZcLoadVehicleMatMgt.AcceptTicketBySendTicketToInvoice(ugr.Cells[this.BILL_NO].Value.ToString(),
                GetoutStockMny(ugr.Cells[this.BILL_NO].Value.ToString()), ugr.Cells[this.LOADVEHICLE_TYPE].Value.ToString(), billck, outck, transck,
                CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName(),

                out errMsg
                );

            if (errMsg.Length == 0)
            {
                Core.StlMes.Client.Sale.Util.MessageUtil.ShowTips("发送成功");

            }
            this.Query01();
        }

        public override void UnSend()
        {
            if (this.ultraGrid1.Rows.Count == 0)
                return;
            if (this.ultraGrid1.Rows.Count == 1)
                this.ultraGrid1.Rows[0].Activated = true;
            Infragistics.Win.UltraWinGrid.UltraGridRow ugr = null;
            ugr = this.ultraGrid1.ActiveRow;
            if (ugr == null)
            {
                Core.StlMes.Client.Sale.Util.MessageUtil.ShowError("请选择需要发送的行");
                return;
            }

            this.ultraGrid1.UpdateData();

            string errMsg = "";

            string billck = "0";
            string outck =  "0";
            string transck = "0";

            if (ugr.Cells[this.BILL_CK].Value.ToString().ToUpper() == "TRUE" &&
                ugr.Cells[this.BILL_TICKET_STATUS].Value.ToString() == "发送结算")
            {
                billck = "1";
            }
            if (ugr.Cells[this.OUTSTOCK_CK].Value.ToString().ToUpper() == "TRUE" &&
             ( ugr.Cells[this.OUTSTOCK_TICKET_STATUS].Value.ToString() == "发送结算"
                  || ugr.Cells[this.OUTSTOCK_TICKET_STATUS].Value.ToString() == "OK")
                ) 
              
            {
                outck = "1";
            }
            if (ugr.Cells[this.TRANSMNY_CK].Value.ToString().ToUpper() == "TRUE" &&
              (ugr.Cells[this.TRANSMNY_TICKET_STATUS].Value.ToString() == "发送结算"
                || ugr.Cells[this.TRANSMNY_TICKET_STATUS].Value.ToString() == "OK")
                )
            {
                transck = "1";
            }

            this.ydmZcLoadVehicleMatMgt.RollBackTicketBySendTicketToInvoice(ugr.Cells[this.BILL_NO].Value.ToString(),
            ugr.Cells[this.LOADVEHICLE_TYPE].Value.ToString(), billck, outck, transck,
              CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName(),  out errMsg
              );

            if (errMsg.Length == 0)
            {
                Core.StlMes.Client.Sale.Util.MessageUtil.ShowTips("取消发送成功");

            }
            this.Query01();
           
        }

        private System.Collections.ArrayList GetoutStockMny(string billno)
        {
              
            System.Collections.ArrayList list = new System.Collections.ArrayList();
            if (this.ultraGrid2.Rows.Count == 0)
                return list;
            string[] temp = null;
            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugr in this.ultraGrid2.Rows)
            {
                if (ugr.Cells["TICKETYPE"].Value.ToString() == "无" || Core.StlMes.Client.Sale.Util.ConverObject.ConvertToDouble
                    (ugr.Cells["OUTSTOCKMNY"].Value) == 0)
                    continue;
                string billNo = billno;
                string ORD_PK = ugr.Cells["ORD_PK"].Value.ToString();
                string ORD_LN_PK = ugr.Cells["ORD_LN_PK"].Value.ToString();
                string ORD_LN_DLY_PK = ugr.Cells["ORD_LN_DLY_PK"].Value.ToString();
                string AGENCY_FL = ugr.Cells["AGENCY_FL"].Value.ToString();
                string ORDER_NO = ugr.Cells["ORDERNO"].Value.ToString().Split('/')[0];
                string ORDER_SEQ = ugr.Cells["ORDERNO"].Value.ToString().Split('/')[1];
                string DELVRY_ADDR = ugr.Cells["DELVRY_ADDR"].Value.ToString();
                string TRANS_TYPE = ugr.Cells["TRANS_TPE"].Text;
                string MOTORMANNAME = this.ultraGrid1.ActiveRow.Cells["CARRY_COMPANY_NAME"].Value.ToString();
                string money = ugr.Cells["OUTSTOCKMNY"].Value.ToString();
                string moneytype = ugr.Cells["TICKETYPE"].Value.ToString();
                string weight = ugr.Cells["WEIGHT"].Value.ToString(); //
               
                temp = new string[] { billNo, ORD_PK, ORD_LN_PK, ORD_LN_DLY_PK, AGENCY_FL, ORDER_NO, ORDER_SEQ
                ,DELVRY_ADDR,TRANS_TYPE,MOTORMANNAME,money,moneytype,weight
                };
                list.Add(temp);
            }
            return list;
 
        }


        private   System.Collections.Generic.List< string[]> GetDataStructCaption()
        {
            List<string[]> list = new List<string[]>();
            list.Add(new string[] { CREATE_TIME ,"创建时间"});
            list.Add(new string[] { BILL_TICKET_STATUS, "货款状态" });
            list.Add(new string[] { OUTSTOCK_TICKET_STATUS, "出库费状态" });
            list.Add(new string[] { TRANSMNY_TICKET_STATUS, "运费状态" });
            list.Add(new string[] { BILL_NO, "提单号" });
            list.Add(new string[] { LOADVEHICLE_TYPE, "提单类型" });
            list.Add(new string[] { CUSTOMER_NM, "订货单位" });
            list.Add(new string[] { RECEIV_NM, "收货单位" });
            list.Add(new string[] { CARRY_COMPANY_NAME, "承运公司" });
            list.Add(new string[] { ACT_COUNT, "支数" });
            list.Add(new string[] { ACT_WEIGHT, "重量" });
            list.Add(new string[] { SEND_NUM, "实发数" });

            list.Add(new string[] { "BILL_CK", "货款" });
            list.Add(new string[] { "OUTSTOCK_CK", "出库费" });
            list.Add(new string[] { "TRANSMNY_CK", "运费" });

            list.Add(new string[] { "ORDERNO", "合同号" });
            list.Add(new string[] { "JUDGE_STOVE_NO", "炉号" });
            list.Add(new string[] { "BATCH_NO", "批号" });
            list.Add(new string[] { "AGENCY_FL", "是否代办" });

            list.Add(new string[] { "DELVRY_ADDR", "交货地点" });
            list.Add(new string[] { "TRANS_TPE", "出厂方式" });

            list.Add(new string[] { "TICKETYPE", "票据类型" });
            list.Add(new string[] { "OUTSTOCKMNY", "费用" });
            list.Add(new string[] { "TKP", "付费标志" });

            list.Add(new string[] { "INDEX_SEQ", "序号" });
            list.Add(new string[] { "DESTINATION", "目的地" });
            list.Add(new string[] { "SPCL_LN_NM", "专用线" });
            list.Add(new string[] { "STATION_NM", "到站" });

            list.Add(new string[] { SELECT, "选择" });
            list.Add(new string[] { TRANSMNY, "运费" });
            list.Add(new string[] { "STAMP_DUTY_MONEY", "印花税" });

            list.Add(new string[] { "RECEIV_ADDR", "指定地点" });
            list.Add(new string[] { "TICKETTYPE", "单据类型" });
            list.Add(new string[] { "VIRSTS", "虚单理货状态" });
            list.Add(new string[] { "PLINE_NAME", "产线" });

            list.Add(new string[] { "QUANTITY", "提单支数" });
            list.Add(new string[] { "WEIGHT", "提单重量" });
            list.Add(new string[] { "INVOICEDATE", "打印时间" });
            list.Add(new string[] { "MANAGEMENT_NAME", "区域" });
            list.Add(new string[] { "SALE_ORG_DESC", "销售组织" });
            list.Add(new string[] { "SUPPLY_UNIT_DESC", "制造商" });
            list.Add(new string[] { "DISBURASES_BILL", "代垫单号" });
            list.Add(new string[] { "TRANS_NO", "运费发票号" });
            list.Add(new string[] { "TRANS_AREA", "出库地点" });
            return list;
        }


        private string[] GetDataStructMain()
        {
            return new string[] 
            {
                 this.BILL_CK,
               this.OUTSTOCK_CK,
                this.TRANSMNY_CK,
                CREATE_TIME,
                "INVOICEDATE",
                BILL_TICKET_STATUS,
                OUTSTOCK_TICKET_STATUS,
                TRANSMNY_TICKET_STATUS,
                BILL_NO,
                LOADVEHICLE_TYPE,
                "VIRSTS",
                CUSTOMER_NO,
                CUSTOMER_NM,
                RECEIV_NO,
                RECEIV_NM,
                "MANAGEMENT_NAME",
                CARRY_COMPANY_CODE,
                CARRY_COMPANY_NAME,
                ACT_COUNT,
                ACT_WEIGHT,       
                "QUANTITY",
                "WEIGHT",
                SEND_NUM,
               "TRANS_TPE",
                LOADVEHICLE_TYPE,
                BILL_STATUS,
                "TRANS_AREA",
                "SALE_ORG_DESC",
                "SUPPLY_UNIT_DESC"
            };
        }

        

        private string[] GetGrid2DataStruct()
        {
            return new string[] 
            {
                "ORDERNO",
                "JUDGE_STOVE_NO",
                "BATCH_NO",
                "PLINE_NAME",
                "QUANTITY",
                "WEIGHT",
                "ORD_PK",
                "ORD_LN_PK",
                "ORD_LN_DLY_PK",
                "AGENCY_FL",
                "DELVRY_ADDR",
                "TRANS_TPE",
                "TICKETYPE",
                "OUTSTOCKMNY",
                "TKP"
            };
        }

        private string[] GetGrid3DataStruct()
        {
            return new string[] 
            {
                SELECT,
                TRANSMNY,
                "STAMP_DUTY_MONEY",
                "TICKETTYPE",
               // "INDEX_SEQ",
                "AGENCY_FL",
                "DISBURASES_BILL",
                "TRANS_NO"
                //"TRANSIT_TYP",
                //"DESTINATION",
                //"STATION_NM",
                //"SPCL_LN_NM",
                //"DELVRY_ADDR" ,
                //"RECEIV_ADDR",
                //"ORD_PK",
                // "ORD_LN_PK",
                //  "ORD_LN_DLY_PK"
            };
        }

        private string CREATE_TIME = "CREATE_TIME";
        private string CUSTOMER_NO = "CUSTOMER_NO";
        private string CUSTOMER_NM = "CUSTOMER_NM";
        private string RECEIV_NO = "RECEIV_NO";
        private string RECEIV_NM = "RECEIV_NM";
        private string CARRY_COMPANY_CODE = "CARRY_COMPANY_CODE";
        private string CARRY_COMPANY_NAME = "CARRY_COMPANY_NAME";
        private string ACT_COUNT = "ACT_COUNT";
        private string ACT_WEIGHT = "ACT_WEIGHT";
        private string BILL_NO = "BILL_NO";
        private string SEND_NUM = "SEND_NUM";
        private string LOADVEHICLE_TYPE = "LOADVEHICLE_TYPE";
        private string BILL_TICKET_STATUS = "BILL_TICKET_STATUS";
        private string OUTSTOCK_TICKET_STATUS = "OUTSTOCK_TICKET_STATUS";
        private string TRANSMNY_TICKET_STATUS = "TRANSMNY_TICKET_STATUS";
        private string BILL_CK = "BILL_CK";
        private string OUTSTOCK_CK = "OUTSTOCK_CK";
        private string TRANSMNY_CK = "TRANSMNY_CK";

        private string ORD_PK = "ORD_PK";
        private string ORD_LN_PK = "ORD_LN_PK";
        private string ORD_LN_DLY_PK = "ORD_LN_DLY_PK";
        private string SELECT = "SELECT";
        private string TRANSMNY = "TRANSMNY";
        private string BILL_STATUS = "BILL_STATUS";

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            this.QueryGrid2();
            QueryGrid3();
        }

        private void textBox7_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (e.KeyChar == 13)
            {
                this.Query();
            }
        }

        private void uchkDate_CheckedChanged(object sender, EventArgs e)
        {
            if (uchkDate.Checked)
            {
                dateTimePicker3.Enabled = true;
                dateTimePicker4.Enabled = true;
            }
            else
            {
                dateTimePicker3.Enabled = false;
                dateTimePicker4.Enabled = false;
            }
        }

                



       
    }
}