示例#1
0
 /// <summary>
 /// Create a new tinpshipping object.
 /// </summary>
 /// <param name="shippingsysid">Initial value of the shippingsysid property.</param>
 public static tinpshipping Createtinpshipping(global::System.String shippingsysid)
 {
     tinpshipping tinpshipping = new tinpshipping();
     tinpshipping.shippingsysid = shippingsysid;
     return tinpshipping;
 }
示例#2
0
 /// <summary>
 /// Deprecated Method for adding a new object to the tinpshipping EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.
 /// </summary>
 public void AddTotinpshipping(tinpshipping tinpshipping)
 {
     base.AddObject("tinpshipping", tinpshipping);
 }
示例#3
0
        public void DoShipping(tinpshipping shipping, List<tinpshippingdtlctn> lstshippingdtlctn, tinpshippingplan shippingplan, bool isDoShipping)
        {
            try
            {
                dbInstance.BeginTransaction();

                List<MESParameterInfo> lstParams = new List<MESParameterInfo>() {
                            new MESParameterInfo(){ParamName="shippingsysid",ParamValue=shipping.shippingsysid}
                        };

                List<tinpshippingdtlctn> lstctn = shippingDtlCtnDal.GetSelectedObjects<tinpshippingdtlctn>(lstParams);
                foreach (tinpshippingdtlctn shippingdtlctn in lstctn)
                {
                    packingRecDtlDal.UpdateIsShipped(shippingdtlctn.customerid,shippingdtlctn.custorderno, shippingdtlctn.cartonno, Public_Flag.N.ToString());
                }

                shippingDtlCtnDal.DoDelete<tinpshippingdtlctn>(lstParams);

                shippingDtlDal.DoUpdateStatusByShippingSysId(shipping.shippingsysid, isDoShipping ? MES_ShippingStatus.Shipped.ToString() : MES_ShippingStatus.Created.ToString());

                List<MESParameterInfo> lstPlanParams = new List<MESParameterInfo>() {
                            new MESParameterInfo(){ParamName="shippingplanno",ParamValue=shippingplan.shippingplanno}
                        };
                List<tinpshippingplan> lstShippingplan = shippingPlanDal.GetSelectedObjects<tinpshippingplan>(lstPlanParams);
                if (lstShippingplan.Count > 0)
                {
                    shippingPlanDal.DoUpdate<tinpshippingplan>(shippingplan);
                }
                else
                {
                    shippingPlanDal.DoInsert<tinpshippingplan>(shippingplan);
                }

                List<tinpshipping> lstShipping = baseDal.GetSelectedObjects<tinpshipping>(lstParams);
                if (lstShipping.Count > 0)
                {
                    tinpshipping shippingmdl = lstShipping[0];
                    shippingmdl.packingboxno = shipping.packingboxno;
                    shippingmdl.blno = shipping.blno;
                    shippingmdl.containerno = shipping.containerno;
                    shippingmdl.loadingtype = shipping.loadingtype;
                    //shippingmdl.contractno = shipping.contractno;
                    shippingmdl.shippingstatus = isDoShipping ? MES_ShippingStatus.Shipped.ToString() : MES_ShippingStatus.Created.ToString();
                    shippingmdl.lastmodifeduser = CurrentContextInfo.CurrentUser;
                    shippingmdl.lastmodifiedtime = Function.GetCurrentTime();
                    if (isDoShipping)
                    {
                        shippingmdl.shippeddate = Function.GetCurrentTime();
                    }
                    baseDal.DoUpdate<tinpshipping>(shippingmdl);
                }
                else
                {
                    shipping.shippingstatus = isDoShipping ? MES_ShippingStatus.Shipped.ToString() : MES_ShippingStatus.Created.ToString();
                    shipping.lastmodifeduser = CurrentContextInfo.CurrentUser;
                    shipping.lastmodifiedtime = Function.GetCurrentTime();
                    shipping.createduser = CurrentContextInfo.CurrentUser;
                    shipping.createdtime = Function.GetCurrentTime();
                    if (isDoShipping)
                    {
                        shipping.shippeddate = Function.GetCurrentTime();
                    }
                    baseDal.DoInsert<tinpshipping>(shipping);
                }

                string eventgroup = Function.GetGUID();
                List<tinpreceivingctndtl> lstReceivingRec = new List<tinpreceivingctndtl>();
                foreach (tinpshippingdtlctn shippingdtlctn in lstshippingdtlctn)
                {
                    shippingDtlCtnDal.DoInsert<tinpshippingdtlctn>(shippingdtlctn);
                    packingRecDtlDal.UpdateIsShipped(shippingdtlctn.customerid,shippingdtlctn.custorderno, shippingdtlctn.cartonno,Public_Flag.Y.ToString());

                    if (isDoShipping)
                    {
                        List<MESParameterInfo> lstRecParams = new List<MESParameterInfo>() {
                            new MESParameterInfo(){ParamName="customerid",ParamValue=shippingdtlctn.customerid},
                            new MESParameterInfo(){ParamName="custorderno",ParamValue=shippingdtlctn.custorderno},
                            new MESParameterInfo(){ParamName="cartonno",ParamValue=shippingdtlctn.cartonno}
                        };

                        List<tinpreceivingctndtl> lstRec = receivingCtnDtlDal.GetSelectedObjects<tinpreceivingctndtl>(lstRecParams);
                        foreach (tinpreceivingctndtl rec in lstRec)
                        {
                            rec.cartonstatus = MES_CartonStatus.Finished.ToString();
                            rec.cartonlocation = MES_CartonLocation.Shipped.ToString();
                            lstReceivingRec.Add(rec);
                            //receivingCtnDtlDal.DoUpdate(rec);
                        }
                    }

                    #region Update CustomerOrder History
                    tinpcustorderhistory history = new tinpcustorderhistory();
                    history.customerid = shippingdtlctn.customerid;
                    history.cartonno = shippingdtlctn.cartonno;
                    history.cartonqty = 0;
                    history.custorderno = shippingdtlctn.custorderno;
                    history.size = "";
                    history.styleno = "";
                    history.color = "";
                    history.eventgroup = eventgroup; ;
                    history.eventname = "Shipping";
                    history.pairqty = 0;
                    history.refsysid = shipping.shippingsysid;
                    history.remark = "";

                    history.eventtime = Function.GetCurrentTime();
                    history.eventuser = CurrentContextInfo.CurrentUser;
                    history.ohsysid = Function.GetGUID();
                    history.shift = CurrentContextInfo.Shift;
                    history.workgroup = CurrentContextInfo.WorkGroup;

                    custOrderHistoryDal.DoInsert<tinpcustorderhistory>(history);
                    #endregion
                }

                foreach (tinpreceivingctndtl rec in lstReceivingRec)
                {
                    receivingCtnDtlDal.DoUpdate(rec);
                }

                dbInstance.Commit();
            }
            catch (Exception ex)
            {
                dbInstance.Rollback();
                throw ex;
            }
            finally
            {
                dbInstance.CloseConnection();
            }
        }
示例#4
0
        private void DoShipping(bool isDoShipping)
        {
            wsINP.IwsINPClient client = new wsINP.IwsINPClient();
            try
            {
                baseForm.SetCursor();
                baseForm.ValidateData(this);

                List<tinpshippingdtlctn> lstshippingdtlctn = new List<tinpshippingdtlctn>();

                foreach (string key in ht.Keys)
                {
                    DataTable dt = ht[key] as DataTable;
                    int ctnqty = 0;
                    foreach (DataRow row in dt.Rows)
                    {
                        if (row["ck"].ToString().Equals("Y"))
                        {
                            tinpshippingdtlctn shippingdtlctn = new tinpshippingdtlctn();
                            shippingdtlctn.shippingsysid = ShipingSysId;
                            shippingdtlctn.customerid = row["customerid"].ToString();
                            shippingdtlctn.custorderno = key;
                            shippingdtlctn.cartonno = row["cartonno"].ToString();
                            shippingdtlctn.pairqty = Convert.ToInt16(row["pairqty"].ToString());
                            lstshippingdtlctn.Add(shippingdtlctn);
                            ctnqty++;
                        }
                    }
                    if (ctnqty > getPlanQty(key) || (isDoShipping && ctnqty != getPlanQty(key)))
                    {
                        throw new Exception(UtilCulture.GetString("Msg.R01024"));
                    }
                }

                tinpshipping shipping = new tinpshipping();
                shipping.shippingsysid = ShipingSysId;
                shipping.packingboxno = this.txtPackingBoxNo.Text;
                shipping.shippingno = this.txtShipNo.Text;
                shipping.containerno = this.txtContainerNo.Text;
                shipping.blno = this.txtBlNo.Text;
                //shipping.contractno = this.txtContractNo.Text;
                if (this.cmbLoadingType.SelectedItem != null)
                {
                    shipping.loadingtype = ((ValueInfo)this.cmbLoadingType.SelectedItem).ValueField;
                }

                tinpshippingplan shippingplan = new tinpshippingplan();
                shippingplan.shippingplanno = ((ValueInfo)this.cmbShippingPlanNo.SelectedItem).DisplayField;
                shippingplan.loadingdate = Convert.ToDateTime(this.dtLoadingDt.Value);
                shippingplan.boxqty = this.txtBoxQty.Text;
                shippingplan.deliverybill = this.txtBlNo.Text;
                shippingplan.inshipno = this.txtInShipNo.Text;
                shippingplan.commissionedqty = Convert.ToInt16(this.numCommissionedQty.Value);
                shippingplan.commissionedvolume = this.numCommissionedVolume.Value;
                shippingplan.commissionedweight = this.numCommissionedWeight.Value;
                shippingplan.startport = this.txtStartPort.Text;
                shippingplan.destinationport = this.txtDestinationPort.Text;
                shippingplan.unloadport = this.txtUnloadPort.Text;
                shippingplan.voyage = this.txtVoyage.Text;

                client.DoShipping(baseForm.CurrentContextInfo, shipping, lstshippingdtlctn.ToArray<tinpshippingdtlctn>(),shippingplan, isDoShipping);

                baseForm.CreateMessageBox(Public_MessageBox.Information, MessageBoxButtons.OK, null, UtilCulture.GetString("Msg.R00028"));

                this.Close();

            }
            catch (Exception ex)
            {
                baseForm.CreateMessageBox(Public_MessageBox.Error, MessageBoxButtons.OK, null, ex.Message);
            }
            finally
            {
                baseForm.ResetCursor();
                baseForm.CloseWCF(client);
            }
        }
示例#5
0
 public void DoShipping(ContextInfo contextInfo, tinpshipping shipping, List<tinpshippingdtlctn> lstshippingdtlctn, tinpshippingplan shippingplan, bool isDoShipping)
 {
     contextInfo.Action = MES_ActionType.Insert;
     ShippingBll bll = new ShippingBll(contextInfo);
     bll.CallAccessControl();
     bll.DoShipping(shipping, lstshippingdtlctn,shippingplan, isDoShipping);
     GC.Collect();
 }