MES_Client/TGMES/Core.StlMes.Client.Sale.UI.Balance/DlgBox/DlgSelectInvoceTransMnyAndOutStockMny.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Collections;
using System.Windows.Forms;
using CoreFS.CA06;
using Infragistics.Win.UltraWinGrid;
using Infragistics.Win;
using SaleBusiness = Core.StlMes.Client.Sale.BLL.SaleBusinessMgt;
namespace Core.StlMes.Client.Sale.UI.Balance.DlgBox
{
    public partial class DlgSelectInvoceTransMnyAndOutStockMny : Core.StlMes.Client.Sale.Common.FrmStyleBase.FrmUIBase
    {
        private Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Balance.SlmBalanceInfo slmBalanceInfo
           = null;
        private string saleOrg = "";
        private string custUser = "";
        private CoreFS.CA06.OpeBase _ob = null;

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





        public string _invocieFlag = "0";

        private Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Trans.YdmZcLoadVehicleMatMgt ydmZcLoadVehicleMatMgt
            = null;
        private Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.StaticData.PublicStaticVariable
            PublicStaticVariable = null;
        private Infragistics.Win.ValueList transTypelist = null;

        public DlgSelectInvoceTransMnyAndOutStockMny(CoreFS.CA06.OpeBase ob)
        {
            _ob = ob;
            InitializeComponent();
        }

        private Infragistics.Win.ValueList GetAgenCyFl()
        {
            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 GetStatusCd()
        {
            Infragistics.Win.ValueList lit = new Infragistics.Win.ValueList();
            lit.ValueListItems.Add("0", "输入");
            lit.ValueListItems.Add("1", "确认");
            lit.ValueListItems.Add("2", "开单");
            return lit;
        }

        private void InitDataSource()
        {


            dsMain = base.GetDataSetByColumnName(this.GetDataStructGridOne(), this.GetDataSetColumnType(),
                GetDataSetColumnCaption());
            dsGrid2 = base.GetDataSetByColumnName(this.GetGrid2DataStruct(), GetDataSetColumnType(), GetDataSet2ColumnCaption());
            this.ultraGrid2.DataSource = dsGrid2;

            dsGrid3 = base.GetDataSetByColumnName(this.GetDataStructGridThree(), GetDataSetColumnType(), GetDataSetColumnCaption());



            // transTypelist = PublicStaticVariable.Static_TransType_Tg(true).GetValueListDB;


            //this.ultraGrid2.DisplayLayout.Bands[0].Columns["STATUS_CD"].ValueList
            //            = GetStatusCd();

        }

        private void DlgSelectInvoceTransMnyAndOutStockMny_Load(object sender, EventArgs e)
        {
            PublicStaticVariable = new Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.StaticData.PublicStaticVariable(_ob);
            InitDataSource();
            ydmZcLoadVehicleMatMgt = new Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Trans.YdmZcLoadVehicleMatMgt(_ob);
            slmBalanceInfo = new Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Balance.SlmBalanceInfo(_ob);
            HiddenCol();
            base.SetGridStyle(ref this.ultraGrid2);
            Query();
            
        }

        private void Query()
        {
            DataSet ds = this.slmBalanceInfo.GetSlmBalanceTransMoneyByRegeditTime(this.dateTimePicker3.Value,
                this.dateTimePicker4.Value);


            if (this.textBox7.Text.Length > 0)
            {
                ds = Util.UtilDataSet.GetDataSetWithRowFilterWithApproximateMatch(ds, this.ASKPLAN_ID, this.textBox7.Text.Trim());
            }
           ds = Util.UtilDataSet.GetDataSetWithRowFilterWithApproximateMatch(ds, this.TICKETTYPE, "应收");
           // 只有应收，未开票显示
            // 末次
            if (this._invocieFlag == "0")
            {
                ds = Util.UtilDataSet.GetDataSetWithRowFilter(ds, this.INVOICENO, "");
               
            }
            else
            {
                ds = Util.UtilDataSet.GetDataSetWithRowFilter(ds, "INVOICENO_ORG", "");
            }

            Util.UtilDataSet.SetDataSetByMergeSameColumnName(ref this.dsGrid2, ds);
            remvoeMonyEqualsZero();
        }

        private void remvoeMonyEqualsZero()
        {
            try
            {
                foreach (DataRow dr in this.dsGrid2.Tables[0].Rows)
                {
                    if (Util.ConverObject.ConvertToDouble(dr["MONEY"].ToString()) == 0)
                    {
                        dr.Delete();
                    }

                }
            }
            catch
            {
            }

            this.dsGrid2.AcceptChanges();

        }

        private void HiddenCol()
        {


            //  this.ultraGrid2.DisplayLayout.Bands[0].Columns[this.STATUS_CD].Hidden = true;
            this.ultraGrid2.DisplayLayout.Bands[0].Columns[this.TRANS_PK].Hidden = true;
        }



        private string[] GetDataStructGridOne()
        {
            return new string[]
            {
                this.BILL_NO,
                CUSTOMER_NO,
                CUSTOMER_NM,
                STLMT_UNIT_NO,
                this.SALE_ORG,
                this.SALE_ORG_DESC,
             //   SPCL_LN_NM,
             //   DELIVY_PLACE_CODE,
               // DELIVY_PLACE_NAME,             
                RECEIV_NO,
                RECEIV_NM
            //    CARRY_COMPANY_CODE,
             //   CARRY_COMPANY_NAME                
            };
        }

        private string[] GetDataStructGridThree()
        {
            return new string[]
            {
                SELECT,
                TRANSMNY,
                TRANSNUM,    
                "TRANS_TYPE",
                "AGENCY_FL",
                "DESTINATION",
                "STATION_NO",
                "SPCL_LN_NO",
                  "DESTINATION",
                "PORT_NO",
                "CARRIER_UNIT",
                "RECEIVOR"
                ,RECEIV_ADDR,DELVRY_ADDR

            };
        }




        private string[] GetGrid2DataStruct()
        {
            return new string[] 
            {
                "TRANS_PK",
              TICKETTYPE,
                MONEY,
                "TICKETNUM",             
                 MONEY_TYPE,
                TRANS_PK,
                ASKPLAN_ID,            
                BUYERNAME,           
           //     STATIONNAME,
          //      LEASEDLINENAME,
                INCEPTCORPCODE,
               FORECORPNAME,
                TRANS_TYPE,
                MOTORMANNAME
             //   STATUS_CD
            };
        }

        private string[] GetHiddenCol()
        {
            return new string[] {   this.TRANS_TYPE,
                this.RECEIV_NO,
                this.STATION_NO,
                this.SPCL_LN_NO,
                this.VSTEL_CODE,
                this.VSTEL_DESC,
                DELIVY_PLACE_CODE,
                DELIVY_PLACE_NAME,
                  this.SALE_ORG,
                this.SALE_ORG_DESC,
                STLMT_UNIT_NO,
                CUSTOMER_NO,
            MONET_TYPE};
        }

        private Hashtable GetDataSetColumnType()
        {
            Hashtable hs = new Hashtable();
            hs.Add("SELECT", "System.Boolean");

            hs.Add("TRANSMNY", "System.Decimal");
            hs.Add("MONEY", "System.Decimal");
            hs.Add("TICKETNUM", "System.Decimal");
            hs.Add(this.TRANSNUM, "System.Decimal");

            return hs;
        }

        private Hashtable GetDataSetColumnCaption()
        {
            Hashtable hs = new Hashtable();
            hs.Add(LOADVEHICLE_NO, "装车单号");
            hs.Add(BILL_NO, "提货单号");
            hs.Add(TICKETTYPE, "单据类型");
            hs.Add(TALLYSHEET_NO, "理货单号");
            hs.Add(LOADVEHICLE_TYPE, "发货单类型（1实际、2虚拟)");
            hs.Add(AFFIRM_FLAG, "确认标志（1确认、0未确认）");
            hs.Add(VEHICLE_NO, "车船号");
            hs.Add(TRANS_TYPE, "运输方式");
            hs.Add(RECEIV_NO, "收货单位编码");
            hs.Add(RECEIV_NM, "收货单位名称");
            hs.Add(STATION_NO, "到站");
            hs.Add(STATION_NM, "到站名称");
            hs.Add(SPCL_LN_NO, "专用线");
            hs.Add(SPCL_LN_NM, "专用线名称");
            hs.Add(PORT, "港口/码头");
            hs.Add(SHIP_LOT_NO, "船批号");
            hs.Add(PLANT, "出货工厂");
            hs.Add(PLANT_DESC, "出货工厂描述");
            hs.Add(VSTEL_CODE, "装运点");
            hs.Add(VSTEL_DESC, "装运点描述");
            hs.Add(CARRIER_NO, "承运单号");
            hs.Add(CARRY_COMPANY_CODE, "承运公司代码");
            hs.Add(CARRY_COMPANY_NAME, "承运公司名称");
            hs.Add(STACKING_WT, "发货单重量");
            hs.Add(STACKING_PIECE, "发货单支数");
            hs.Add(STACKING_TOTL_LEN, "发货单总长度");
            hs.Add(WEIGH_FLAG, "是否需过磅");
            hs.Add(PONDER_NO, "过磅单号");
            hs.Add(PONDER_GROSS_WT, "过磅重量");
            hs.Add(OUT_STOCK_CODE, "出库库区代码");
            hs.Add(DELIVY_PLACE_CODE, "交货点代码");
            hs.Add(DELIVY_PLACE_NAME, "交货点名称");
            hs.Add(STLMT_UNIT_NO, "结算单位编码");
            hs.Add(STLMT_UNIT_NM, "结算单位名称");
            hs.Add(INFACTORY_TIME, "进厂时间");
            hs.Add(LOAD_TIME, "装车时间");
            hs.Add(DELIVY_TIME, "出厂时间");
            hs.Add(STACKING_PRINTS, "打印次数");
            hs.Add(THREE_READY_NO, "单据结齐号");
            hs.Add(HANDHELD_NO, "手持编号");
            hs.Add(HANDHELD_FLAG, "手持标志（1：已发送，2：退回，3：完成）';");
            hs.Add(MANAGEMENT_NO, "管理单位代码");
            hs.Add(MANAGEMENT_NAME, "管理单位名称");
            hs.Add(MEMO, "备注");
            hs.Add(VALIDFLAG, "有效标志(1:有效，0:无效)");
            hs.Add(CREATE_NAME, "创建人");
            hs.Add(CREATE_TIME, "创建时间");
            hs.Add(UPDATE_NAME, "修改人");
            hs.Add(UPDATE_TIME, "修改时间");
            hs.Add(DELETE_NAME, "删除人");
            hs.Add(DELETE_TIME, "删除时间");
            hs.Add(SELECT, "选择");
            hs.Add(MONET_TYPE, "支付类型");
            hs.Add(TRANSMNY, "运费");
            hs.Add(TRANSNUM, "票据数");

            hs.Add(RECEIV_ADDR, "指定地点");
            hs.Add(DELVRY_ADDR, "交货地点");


            return hs;

        }

        private Hashtable GetDataSet2ColumnCaption()
        {
            Hashtable hs = new Hashtable();
            hs.Add(TRANS_PK, "主键");
            hs.Add(ASKPLAN_ID, "提单号");
            hs.Add(TALLYSHEET_NO, "理货单号");
            hs.Add(LOADVEHICLE_NO, "装车单号");
            hs.Add(TRAINWAGON, "车号");
            hs.Add(BUYERCODE, "结算单位");
            hs.Add(BUYERNAME, "结算单位");
            hs.Add(FORECORPCODE, "销售组织");
            hs.Add(FORECORPNAME, "销售组织");
            hs.Add(FST_DRAWEE_UNIT, "首次受票人");
            hs.Add(STATIONCODE, "到站");
            hs.Add(STATIONNAME, "到站");
            hs.Add(LEASEDLINE, "专用线名称");
            hs.Add(LEASEDLINENAME, "专用线名称");
            hs.Add(INCEPTCORPCODE, "收货单位");
            hs.Add(TRANS_TYPE, "运输方式");
            hs.Add(MOTORMANNAME, "承运单位");
            hs.Add(DOCKNAME, "水运起始与目的港口");
            hs.Add(TICKETTYPE, "单据类型");
            hs.Add(TICKETNO, "单据号");
            hs.Add(MONEY_TYPE, "费用类型");
            hs.Add(MONEY, "金额");
            hs.Add(LOAD_TIME, "装车时间");
            hs.Add(INVOICENO, "结算单号");
            hs.Add(INVOICEDATE, "编单时间");
            hs.Add(INVOICE_ID, "编单人");
            hs.Add(STATUS_CD, "状态区分");
            hs.Add(REG_ID, "录入者");
            hs.Add(REG_DTIME, "录入时间");
            hs.Add(AFFRIM_ID, "确认人");
            hs.Add(AFFRIM_TIME, "确认时间");
            hs.Add(SELECT, "选择");
            hs.Add("TICKETNUM", "票据数");

            return hs;
        }


        private string SELECT = "SELECT";
        private string MONET_TYPE = "MONET_TYPE";
        private string TICKETNO = "TICKETNO";
        private string OUTSTOCKMNY = "OUTSTOCKMNY";

        private string DZFMNY = "DZFMNY";
        private string TRANSMNY = "TRANSMNY";
        private string TRANSNUM = "TRANSNUM";

        private string LOADVEHICLE_NO = "LOADVEHICLE_NO";
        private string BILL_NO = "BILL_NO";
        private string TALLYSHEET_NO = "TALLYSHEET_NO";
        private string LOADVEHICLE_TYPE = "LOADVEHICLE_TYPE";
        private string AFFIRM_FLAG = "AFFIRM_FLAG";
        private string VEHICLE_NO = "VEHICLE_NO";
        private string TRANS_TYPE = "TRANS_TYPE";
        private string RECEIV_NO = "RECEIV_NO";
        private string RECEIV_NM = "RECEIV_NM";
        private string STATION_NO = "STATION_NO";
        private string STATION_NM = "STATION_NM";
        private string SPCL_LN_NO = "SPCL_LN_NO";
        private string SPCL_LN_NM = "SPCL_LN_NM";
        private string PORT = "PORT";
        private string SHIP_LOT_NO = "SHIP_LOT_NO";
        private string PLANT = "PLANT";
        private string PLANT_DESC = "PLANT_DESC";
        private string VSTEL_CODE = "VSTEL_CODE";
        private string VSTEL_DESC = "VSTEL_DESC";
        private string CARRIER_NO = "CARRIER_NO";
        private string CARRY_COMPANY_CODE = "CARRY_COMPANY_CODE";
        private string CARRY_COMPANY_NAME = "CARRY_COMPANY_NAME";
        private string STACKING_WT = "STACKING_WT";
        private string STACKING_PIECE = "STACKING_PIECE";
        private string STACKING_TOTL_LEN = "STACKING_TOTL_LEN";
        private string WEIGH_FLAG = "WEIGH_FLAG";
        private string PONDER_NO = "PONDER_NO";
        private string PONDER_GROSS_WT = "PONDER_GROSS_WT";
        private string OUT_STOCK_CODE = "OUT_STOCK_CODE";
        private string DELIVY_PLACE_CODE = "DELIVY_PLACE_CODE";
        private string DELIVY_PLACE_NAME = "DELIVY_PLACE_NAME";
        private string STLMT_UNIT_NO = "STLMT_UNIT_NO";
        private string STLMT_UNIT_NM = "STLMT_UNIT_NM";
        private string INFACTORY_TIME = "INFACTORY_TIME";
        private string LOAD_TIME = "LOAD_TIME";
        private string DELIVY_TIME = "DELIVY_TIME";
        private string STACKING_PRINTS = "STACKING_PRINTS";
        private string THREE_READY_NO = "THREE_READY_NO";
        private string HANDHELD_NO = "HANDHELD_NO";
        private string HANDHELD_FLAG = "HANDHELD_FLAG";
        private string MANAGEMENT_NO = "MANAGEMENT_NO";
        private string MANAGEMENT_NAME = "MANAGEMENT_NAME";
        private string MEMO = "MEMO";
        private string VALIDFLAG = "VALIDFLAG";
        private string CREATE_NAME = "CREATE_NAME";
        private string CREATE_TIME = "CREATE_TIME";
        private string UPDATE_NAME = "UPDATE_NAME";
        private string UPDATE_TIME = "UPDATE_TIME";
        private string DELETE_NAME = "DELETE_NAME";
        private string DELETE_TIME = "DELETE_TIME";

        private string TRANS_PK = "TRANS_PK";
        private string ASKPLAN_ID = "ASKPLAN_ID";

        private string TRAINWAGON = "TRAINWAGON";
        private string BUYERCODE = "BUYERCODE";
        private string BUYERNAME = "BUYERNAME";
        private string FORECORPCODE = "FORECORPCODE";
        private string FORECORPNAME = "FORECORPNAME";
        private string FST_DRAWEE_UNIT = "FST_DRAWEE_UNIT";
        private string STATIONCODE = "STATIONCODE";
        private string STATIONNAME = "STATIONNAME";
        private string LEASEDLINE = "LEASEDLINE";
        private string LEASEDLINENAME = "LEASEDLINENAME";
        private string INCEPTCORPCODE = "INCEPTCORPCODE";
        private string MOTORMANNAME = "MOTORMANNAME";
        private string DOCKNAME = "DOCKNAME";
        private string TICKETTYPE = "TICKETTYPE";
        private string MONEY_TYPE = "MONEY_TYPE";
        private string MONEY = "MONEY";
        private string INVOICENO = "INVOICENO";
        private string INVOICEDATE = "INVOICEDATE";
        private string INVOICE_ID = "INVOICE_ID";
        private string STATUS_CD = "STATUS_CD";
        private string REG_ID = "REG_ID";
        private string REG_DTIME = "REG_DTIME";
        private string AFFRIM_ID = "AFFRIM_ID";
        private string AFFRIM_TIME = "AFFRIM_TIME";

        private string ORDER_NO = "ORDER_NO";
        private string ORDER_SEQ = "ORDER_SEQ";
        private string DELIVERY_NO = "DELIVERY_NO";
        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 AGENCY_FL = "AGENCY_FL";

        private string RECEIV_ADDR = "RECEIV_ADDR";
        private string DELVRY_ADDR = "DELVRY_ADDR";

        private string CUSTOMER_NO = "CUSTOMER_NO";
        private string CUSTOMER_NM = "CUSTOMER_NM";

        private string SALE_ORG = "SALE_ORG";
        private string SALE_ORG_DESC = "SALE_ORG_DESC";

        private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
        {
            if (e.Tool.Key == "Choose")
            {
                Choose();
            }

            if (e.Tool.Key == "Query")
            {
                this.Query();
            }
            if (e.Tool.Key == "Exit")
            {
                this.Close();
            }
        }


        public ArrayList Tranpk = new ArrayList();

        private void Choose()
        {
            if (this.ultraGrid2.Rows.Count == 0)
            {
                this.DialogResult = DialogResult.Cancel;
                return;
            }

            Infragistics.Win.UltraWinGrid.UltraGridRow ugr = this.ultraGrid2.ActiveRow;
            if (ugr == null)
            {
                Core.StlMes.Client.Sale.Util.MessageUtil.ShowError("请选择数据");
                return;
            }
            else
                ugr.Selected = true;
            string buyernameAdnForcode = ugr.Cells[this.BUYERNAME].Value.ToString()
                    + ugr.Cells[this.FORECORPNAME].Value.ToString() + ugr.Cells[this.MONEY_TYPE].Value.ToString();
            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugrs in this.ultraGrid2.Selected.Rows)
            {
                if (buyernameAdnForcode != ugrs.Cells[this.BUYERNAME].Value.ToString()
                    + ugrs.Cells[this.FORECORPNAME].Value.ToString() + ugrs.Cells[this.MONEY_TYPE].Value.ToString())
                {
                    Core.StlMes.Client.Sale.Util.MessageUtil.ShowError("只允许编制同结算单位，同销售组织，同费用类型数据");
                    return;
                }

              Tranpk.Add(ugrs.Cells["TRANS_PK"].Value.ToString());

            }

            if (Core.StlMes.Client.Sale.Util.MessageUtil.ShowYesNoAndQuestion("是否确认编制结算单") == DialogResult.No)
                return;

            this.DialogResult = DialogResult.OK;
        }
    }
}