MES_Client/TGMES/Core.StlMes.Client.Pms/ck/PurExcDeliveryOk.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 CoreFS.CA06;using Pur.Entity;
using Core.Mes.Client.Comm.Control;
using Pur.Entity.ck;
using Infragistics.Win.UltraWinGrid;
using System.Collections;
using Core.Mes.Client.Comm.Tool;
using Pur.Entity.require_planEntiy;
using com.hnshituo.pur.vo;
using Pur.configure;

namespace Pur.ck
{
    public partial class PurExcDeliveryOk : FrmPmsBase
    {
        public PurExcDeliveryOk()
        {
            InitializeComponent();
        }

        
        UltraGridRow Qgr = null;
        public PurExcDeliveryOk(OpeBase ob, UltraGridRow ugr)
        {

            
            this.ob = ob;
            InitializeComponent();
            Qgr = ugr;
        }
        /// <summary>
        /// 工具栏
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void barsManagerButon_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
        {
             
            switch (e.Tool.Key.ToString())
            {

                case "conFirmation":
                    {

                        Add_PurExcSub();
                        
                    }
                    break;
                case "ESC":
                    {
                        this.Close();
                    }
                    break;
            }
        
        }
        /// <summary>
        /// 生成子单
        /// </summary>
        private void Add_PurExcSub()
        {
             ultraGrid1.UpdateData(); 
            DataTable dt_b = new DataTable();
            ArrayList list1 = new ArrayList();
            ArrayList list2 = new ArrayList();

           
            //Edm.BollCode = Qgr.Cells["BollCode"].Value.ToString();
            //Edm.DeliverSheetId = Qgr.Cells["DeliverSheetId"].Value.ToString(); 



           
           
            dt_b = dataTable3.Clone();
            DataRow[] rows = dataTable3.Select("Songqty<>'' or Songqty is not null or Songqty <>'0'");
            foreach (DataRow row in rows)
            {
                dt_b.ImportRow(row);//复制行数据
            }
            for (int i = 0; i < dt_b.Rows.Count; )
            {
                int t = 2;
                ExcDeliverySubM Edm = new ExcDeliverySubM();
                Edm.CreateName = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName();
                Edm.CreateUserid = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserID();
                Edm.CreateTime = DateTime.Now;
                Edm.Validflag = "1";
                Edm.Status = "1";
                Edm.DeliveryType = Qgr.Cells["DeliveryType"].Value.ToString();
                Edm.NoticeId = Qgr.Cells["NoticeId"].Value.ToString();
                Edm.OrderId = Qgr.Cells["OrderId"].Value.ToString();
                Edm.SuppCode = Qgr.Cells["SuppCode"].Value.ToString();
                Edm.SuppName = Qgr.Cells["SuppName"].Value.ToString();
                Edm.Remark = Qgr.Cells["Remark"].Value.ToString();
                Edm.CompanyCode = Qgr.Cells["CompanyCode"].Value.ToString();
                Edm.CompanyName = Qgr.Cells["CompanyName"].Value.ToString();
                Edm.DeliveryId = Qgr.Cells["DeliveryId"].Value.ToString(); 

                String str = this.execute<String>("com.hnshituo.pur.utils.service.UtilsService", "getSubId", new object[] { });
                Edm.DeliverySubId = str;
                Edm.DeliveryLocation = dt_b.Rows[i]["DeliveryLocation"].ToString();
                
                Edm.DeliveryLocationCode = dt_b.Rows[i]["DeliveryLocationCode"].ToString();
                

                ExcDeliverySubC TheB = new ExcDeliverySubC();
                TheB.DeliverySubId = str;


                list1.Add(Edm);
                //this.execute("com.hnshituo.pur.ck.service.ExcDeliverySubMService", "insert", new object[] { Edm });
                for (int j = 1; j < dt_b.Rows.Count;)
                {
                    ExcDeliverySubC TheC = new ExcDeliverySubC();
                    TheC.DeliverySubId = str;


                    if (dt_b.Rows[i]["deliveryLocationCode"].ToString() == dt_b.Rows[j]["deliveryLocationCode"].ToString())
                    {


                        TheC.DeliverySubLineSqe = str + t.ToString();
                        TheC.CreateName = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName();
                        TheC.CreateTime = DateTime.Now;
                        TheC.CreateUserid = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserID();

                        TheC.NoticeId = Qgr.Cells["NoticeId"].Value.ToString();
                        TheC.OrderId = Qgr.Cells["OrderId"].Value.ToString();
                        TheC.DeliveryId = Qgr.Cells["DeliveryId"].Value.ToString();

                        TheC.OrderLineSqe = dt_b.Rows[j]["UPDATENAME"].ToString();
                        TheC.DeliveryLineSqe = dt_b.Rows[j]["DELETENAME"].ToString();
                        TheC.Qty = Convert.ToDouble(dt_b.Rows[j]["Songqty"].ToString());

                        TheC.Validflag = "1";
                        TheC.ItemCode = dt_b.Rows[j]["ItemCode"].ToString();
                        TheC.ItemDesc = dt_b.Rows[j]["ItemDesc"].ToString();
                        //TheC.ItemDescE = dt_b.Rows[j]["ItemDescE"].ToString();
                        TheC.ItemModel = dt_b.Rows[j]["ItemModel"].ToString();
                        TheC.ItemName = dt_b.Rows[j]["ItemName"].ToString();
                        TheC.ItemSpec = dt_b.Rows[j]["ItemSpec"].ToString();
                        //TheC.ItemUom = dt_b.Rows[j]["ItemUom"].ToString();
                       // TheC.ItemUomConefficient =Convert.ToDouble(dt_b.Rows[j]["ItemUomConefficient"].ToString());
                       // TheC.ItemUseUom = dt_b.Rows[j]["ItemUseUom"].ToString();
                        TheC.WeightUnit = dt_b.Rows[j]["WeightUnit"].ToString();

                        list2.Add(TheC);
                        //this.execute("com.hnshituo.pur.ck.service.ExcDeliverySubCService", "insert", new object[] { TheC });
                        t++;
                        

                        RequirePlanD Rqpd = new RequirePlanD();
                        Rqpd.MrLineId = dt_b.Rows[j]["MrLineId"].ToString();
                        Rqpd.QtyDelivery = Convert.ToDouble(dt_b.Rows[j]["Songqty"].ToString()) + (dt_b.Rows[j]["qtyDelivery"].ToString() == null ? 0 : Convert.ToDouble(dt_b.Rows[j]["qtyDelivery"].ToString()));

                        CoreResult re = this.GetJsonService().execute<CoreResult>("com.hnshituo.pur.requireplan.service.RequirePlanDService", "doUpdate", new object[] { Rqpd });

                        dt_b.Rows.RemoveAt(j);


                    }
                    else
                    {
                        j++;
                    }

                }
                TheB.DeliverySubLineSqe = str + "1";
                TheB.CreateName = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName();
                TheB.CreateTime = DateTime.Now;
                TheB.CreateUserid = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserID();

                TheB.OrderLineSqe = dt_b.Rows[i]["UPDATENAME"].ToString();
                TheB.DeliveryLineSqe = dt_b.Rows[i]["DELETENAME"].ToString();
                TheB.Qty = Convert.ToDouble(dt_b.Rows[i]["Songqty"].ToString());

                TheB.NoticeId = Qgr.Cells["NoticeId"].Value.ToString();
                TheB.OrderId = Qgr.Cells["OrderId"].Value.ToString();
                TheB.DeliveryId = Qgr.Cells["DeliveryId"].Value.ToString(); 
                TheB.Validflag = "1";
                TheB.ItemCode = dt_b.Rows[i]["ItemCode"].ToString();
                TheB.ItemDesc = dt_b.Rows[i]["ItemDesc"].ToString();
                //TheB.ItemDescE = dt_b.Rows[i]["ItemDescE"].ToString();
                TheB.ItemModel = dt_b.Rows[i]["ItemModel"].ToString();
                TheB.ItemName = dt_b.Rows[i]["ItemName"].ToString();
                TheB.ItemSpec = dt_b.Rows[i]["ItemSpec"].ToString();
                //TheB.ItemUom = dt_b.Rows[i]["ItemUom"].ToString();
               // TheB.ItemUomConefficient =Convert.ToDouble(dt_b.Rows[i]["ItemUomConefficient"].ToString());
               // TheB.ItemUseUom = dt_b.Rows[i]["ItemUseUom"].ToString();
                TheB.WeightUnit = dt_b.Rows[i]["WeightUnit"].ToString();
                list2.Add(TheB);

                RequirePlanD Rqpd1 = new RequirePlanD();
                Rqpd1.MrLineId = dt_b.Rows[i]["MrLineId"].ToString();
                Rqpd1.QtyDelivery = Convert.ToDouble(dt_b.Rows[i]["Songqty"].ToString())+ (dt_b.Rows[i]["qtyDelivery"].ToString()==null?0:Convert.ToDouble(dt_b.Rows[i]["qtyDelivery"].ToString()));

                this.GetJsonService().execute("com.hnshituo.pur.requireplan.service.RequirePlanDService", "doUpdate", new object[] { Rqpd1 });


                //this.GetJsonService().execute("com.hnshituo.pur.ck.service.ExcDeliverySubCService", "insert", new object[] { TheB });
                dt_b.Rows.RemoveAt(i);
            }

           
            CoreResult cRt = this.GetJsonService().execute<CoreResult>("com.hnshituo.pur.ck.service.ExcDeliverySubMService", "insert_id", new object[] { list1, list2 });
            if (cRt.Resultcode == 0)
            {
                MessageUtil.ShowTips("送货子单生成成功！ ");
            }
            else
            { 
                MessageUtil.ShowTips("送货子单生成失败！"+cRt.Resultmsg);
            }

            

        }

        /// <summary>
        /// 界面加载
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void PurExcDeliveryOk_Load(object sender, EventArgs e)
        {

            ultraTextEditor2.Text = Qgr.Cells["orderId"].Value.ToString();
            ultraTextEditor3.Text = Qgr.Cells["suppName"].Value.ToString();
            ultraTextEditor4.Text = Qgr.Cells["deliveryId"].Value.ToString();
            ExcDeliveryC Edc = new ExcDeliveryC();

            Edc.DeliveryId = Qgr.Cells["DeliveryId"].Value.ToString();

            DataTable dt = this.GetJsonService().execute<DataTable>("com.hnshituo.pur.ck.service.ExcDeliveryCService", "find_ExcDC", new object[] { Edc });
            GridHelper.CopyDataToDatatable(dt, dataTable2, true);

            DataTable dt1 = this.GetJsonService().execute<DataTable>("com.hnshituo.pur.requireplan.service.RequirePlanDService", "getRD_forExcDeliveryC", new object[] { });

            for (int i = 0; i < dt1.Rows.Count; )
            {
                if (!dataTable2.Rows.Contains(dt1.Rows[i]["purlineid"].ToString()))
                {
                    dt1.Rows.RemoveAt(i);
                }
                else
                {
                    i++;
                }
            }
                GridHelper.CopyDataToDatatable(dt1, dataTable3, true);

                string[] strColum1 = new string[] { "Songqty", "remark" };

                ConfigureClassCommon.setGridActivation(ultraGrid1.DisplayLayout.Bands[0], strColum1);

            
        }

       
    }
}