Beispiel #1
0
    protected void grid_CustomDataCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomDataCallbackEventArgs e)
    {
        string s = e.Parameters;

        if (s == "OK")
        {
            if (Request.QueryString["party"] != null && Request.QueryString["no"] != null)
            {
                string no     = SafeValue.SafeString(Request.QueryString["no"]);
                string whCode = SafeValue.SafeString(Request.QueryString["wh"]);
                for (int a = 0; a < list.Count; a++)
                {
                    string sql = "";
                    #region Do Out Det
                    int id  = list[a].id;
                    int qty = list[a].qty;
                    try
                    {
                        sql = string.Format("select * from Wh_DoDet where Id={0} ", id);
                        ASPxSpinEdit spin_Qty1 = this.grid.FindRowTemplateControl(a, "spin_Qty1") as ASPxSpinEdit;
                        ASPxSpinEdit spin_Qty2 = this.grid.FindRowTemplateControl(a, "spin_Qty2") as ASPxSpinEdit;
                        int          packQty   = SafeValue.SafeInt(spin_Qty1.Text, 0);
                        int          locaQty   = SafeValue.SafeInt(spin_Qty2.Text, 0);
                        DataTable    tab       = ConnectSql.GetTab(sql);
                        if (tab.Rows.Count == 1)
                        {
                            int      i           = 0;
                            string   product     = tab.Rows[i]["ProductCode"].ToString();
                            string   DoInNo      = tab.Rows[i]["DoNo"].ToString();
                            decimal  price       = SafeValue.SafeDecimal(tab.Rows[i]["Price"], 0);
                            string   currency    = SafeValue.SafeString(tab.Rows[i]["Currency"]);
                            decimal  exRate      = SafeValue.SafeDecimal(tab.Rows[i]["ExRate"], 1);
                            decimal  gst         = SafeValue.SafeDecimal(tab.Rows[i]["Gst"], 0);
                            string   gstType     = SafeValue.SafeString(tab.Rows[i]["GstType"]);
                            string   batchNo     = SafeValue.SafeString(tab.Rows[i]["BatchNo"]);
                            DateTime expiredDate = SafeValue.SafeDate(tab.Rows[i]["ExpiredDate"], DateTime.Today);
                            string   color       = SafeValue.SafeString(tab.Rows[i]["Color"]);
                            decimal  size        = SafeValue.SafeDecimal(tab.Rows[i]["Size"], 0);
                            string   packCode    = SafeValue.SafeString(tab.Rows[i]["PackCode"]);
                            string   unit        = SafeValue.SafeString(tab.Rows[i]["Unit"]);
                            int      balQty      = SafeValue.SafeInt(tab.Rows[i]["BalQty"], 0);

                            WhDoDet det = new WhDoDet();
                            if (gstType == "S")
                            {
                                gst = SafeValue.SafeDecimal(0.07, 0);
                            }
                            det.ProductCode = product;
                            det.Currency    = currency;
                            det.ExRate      = exRate;
                            det.Price       = price;
                            det.Qty1        = packQty;
                            det.Qty2        = locaQty;
                            det.Qty         = packQty * locaQty;
                            det.DoInNo      = DoInNo;
                            det.DoInId      = id.ToString();
                            det.Gst         = gst;
                            det.GstType     = gstType;
                            det.BalQty      = 0;
                            det.PreQty      = qty;
                            det.DoNo        = no;
                            det.BatchNo     = batchNo;
                            det.ExpiredDate = expiredDate;
                            det.Color       = color;
                            det.Size        = size;
                            det.DoType      = "OUT";
                            det.JobStatus   = "Draft";
                            det.PackCode    = packCode;
                            det.ContractNo  = SafeValue.SafeString(tab.Rows[i]["ContractNo"]);
                            det.DocAmt      = SafeValue.SafeDecimal(tab.Rows[i]["DocAmt"], 0);
                            det.GstAmt      = SafeValue.SafeDecimal(tab.Rows[i]["GstAmt"], 0);
                            det.DocAmt      = SafeValue.SafeDecimal(tab.Rows[i]["DocAmt"], 0);
                            det.LocAmt      = SafeValue.SafeDecimal(tab.Rows[i]["LocAmt"], 0);
                            if (balQty >= qty && packQty > 0 && locaQty > 0)
                            {
                                C2.Manager.ORManager.StartTracking(det, Wilson.ORMapper.InitialState.Inserted);
                                C2.Manager.ORManager.PersistChanges(det);
                                UpdateBalQty(id, 0);
                            }
                            else
                            {
                                e.Result = "Error, Pls refresh your Det";
                            }
                        }
                    }
                    catch (Exception ex)
                    {
                    }
                    #endregion
                }
            }
        }
    }
Beispiel #2
0
    public static string Import_Order(string filePath)
    {
        XmlDocument xmlDoc = new XmlDocument();
        string      doNo   = "";
        string      doType = "";

        if (filePath.Length > 0)
        {
            xmlDoc.Load(filePath);
            if (xmlDoc.SelectSingleNode("Order") != null)
            {
                XmlElement elem   = (XmlElement)xmlDoc.SelectSingleNode("Order");
                string     id     = SafeValue.SafeString(elem.GetAttribute("Id"));
                string     relaId = SafeValue.SafeString(elem.GetAttribute("RelaId"));

                bool isNew = false;
                WhDo whDo  = null;
                if (id.Length > 0 && relaId.Length == 0)// from company to warehouse
                {
                    Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(WhDo), "RelaId='" + id + "'");
                    whDo = C2.Manager.ORManager.GetObject(query) as WhDo;

                    if (whDo == null)
                    {
                        isNew       = true;
                        whDo        = new WhDo();
                        whDo.RelaId = id;
                        whDo.DoDate = DateTime.Today;


                        whDo.PartyId = SafeValue.SafeString(elem.GetAttribute("PartyId"));
                        //whDo.PartyId = EzshipHelper.GetPartyId(SafeValue.SafeString(elem.GetAttribute("PartyId")));
                        whDo.PartyName = SafeValue.SafeString(elem.GetAttribute("Party"));
                        whDo.PartyAdd  = SafeValue.SafeString(elem.GetAttribute("PartyAddress"));
                    }
                }
                else if (id.Length > 0 && relaId.Length > 0)// from warehouse to company
                {
                    Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(WhDo), "Id='" + relaId + "'");
                    whDo = C2.Manager.ORManager.GetObject(query) as WhDo;
                    if (whDo == null)
                    {
                        return("");
                        //isNew = true;
                        //whDo = new WhDo();
                        //whDo.RelatId = id;
                    }
                }
                else
                {
                    return("");
                }

                doType = "IN";
                string runType = "DOIN";//SIF/SIL/SIC
                if (SafeValue.SafeString(elem.GetAttribute("OrderType")) == "OUT")
                {
                    doType  = "OUT";
                    runType = "DOOUT";
                }
                #region ref
                whDo.PoNo   = SafeValue.SafeString(elem.GetAttribute("PoNo"));
                whDo.PoDate = SafeValue.SafeDate(elem.GetAttribute("PoDate"), DateTime.Today);
                //whDo.PartyId = EzshipHelper.GetPartyId(SafeValue.SafeString(elem.GetAttribute("Party")));
                //whDo.PartyName = SafeValue.SafeString(elem.GetAttribute("Party"));
                //whDo.PartyAdd = SafeValue.SafeString(elem.GetAttribute("PartyAddress"));
                //whDo.PartyPostalcode = SafeValue.SafeString(elem.GetAttribute("PartyPostal"));
                //whDo.PartyCity = SafeValue.SafeString(elem.GetAttribute("PartyCity"));
                //whDo.PartyCountry = SafeValue.SafeString(elem.GetAttribute("PartyCountry"));

                whDo.Priority     = SafeValue.SafeString(elem.GetAttribute("Type"));
                whDo.ExpectedDate = SafeValue.SafeDate(elem.GetAttribute("ExpectedDate"), DateTime.Today);
                whDo.DoStatus     = SafeValue.SafeString(elem.GetAttribute("DoStatus"));
                whDo.Remark1      = SafeValue.SafeString(elem.GetAttribute("Remark1"));
                whDo.Remark2      = SafeValue.SafeString(elem.GetAttribute("Remark2"));
                whDo.CollectFrom  = SafeValue.SafeString(elem.GetAttribute("PickFrom"));
                whDo.DeliveryTo   = SafeValue.SafeString(elem.GetAttribute("DeliveryTo"));

                //whDo.CustomerReference = SafeValue.SafeString(elem.GetAttribute("CustomsRef"));
                //whDo.CustomerDate= SafeValue.SafeDate(elem.GetAttribute("RefDate"), new DateTime(1753, 1, 1));

                whDo.CustomerReference = SafeValue.SafeString(elem.GetAttribute("OrderNo"));
                whDo.CustomerDate      = SafeValue.SafeDate(elem.GetAttribute("OrderDate"), new DateTime(1753, 1, 1));

                whDo.PartyInvNo   = SafeValue.SafeString(elem.GetAttribute("PartyInvNo"));
                whDo.PartyInvDate = SafeValue.SafeDate(elem.GetAttribute("PartyInvDate"), new DateTime(1753, 5, 1));
                //permit no
                whDo.PermitNo           = SafeValue.SafeString(elem.GetAttribute("PermitNo"));
                whDo.PermitApprovalDate = SafeValue.SafeDate(elem.GetAttribute("PermitApprovalDate"), new DateTime(1753, 5, 1));
                whDo.TptMode            = SafeValue.SafeString(elem.GetAttribute("TptMode"));
                whDo.PalletizedInd      = SafeValue.SafeBool(elem.GetAttribute("PalletizedInd"), true);
                whDo.EquipNo            = SafeValue.SafeString(elem.GetAttribute("EquipNo"));
                whDo.Personnel          = SafeValue.SafeString(elem.GetAttribute("Personnel"));
                //shipment
                whDo.Vessel  = SafeValue.SafeString(elem.GetAttribute("Vessel"));
                whDo.Voyage  = SafeValue.SafeString(elem.GetAttribute("Voyage"));
                whDo.Obl     = SafeValue.SafeString(elem.GetAttribute("OceanBl"));
                whDo.Hbl     = SafeValue.SafeString(elem.GetAttribute("HouseBl"));
                whDo.Pol     = SafeValue.SafeString(elem.GetAttribute("Pol"));
                whDo.Pod     = SafeValue.SafeString(elem.GetAttribute("Pod"));
                whDo.Eta     = SafeValue.SafeDate(elem.GetAttribute("Eta"), new DateTime(1753, 1, 1));
                whDo.Etd     = SafeValue.SafeDate(elem.GetAttribute("Etd"), new DateTime(1753, 1, 1));
                whDo.EtaDest = SafeValue.SafeDate(elem.GetAttribute("EtaDest"), new DateTime(1753, 1, 1));
                whDo.Vehicle = SafeValue.SafeString(elem.GetAttribute("Vehicle"));
                whDo.Coo     = SafeValue.SafeString(elem.GetAttribute("Coo"));
                whDo.Carrier = SafeValue.SafeString(elem.GetAttribute("Carrier"));
                //party
                whDo.AgentId      = EzshipHelper.GetPartyId(SafeValue.SafeString(elem.GetAttribute("Agent")));
                whDo.AgentName    = SafeValue.SafeString(elem.GetAttribute("Agent"));
                whDo.AgentZip     = SafeValue.SafeString(elem.GetAttribute("AgentZip"));
                whDo.AgentAdd     = SafeValue.SafeString(elem.GetAttribute("AgentAddress"));
                whDo.AgentTel     = SafeValue.SafeString(elem.GetAttribute("AgentTel"));
                whDo.AgentContact = SafeValue.SafeString(elem.GetAttribute("AgentContact"));
                whDo.AgentCountry = SafeValue.SafeString(elem.GetAttribute("AgentCountry"));
                whDo.AgentCity    = SafeValue.SafeString(elem.GetAttribute("AgentCity"));

                whDo.NotifyId      = EzshipHelper.GetPartyId(SafeValue.SafeString(elem.GetAttribute("Notify")));
                whDo.NotifyName    = SafeValue.SafeString(elem.GetAttribute("Notify"));
                whDo.NotifyZip     = SafeValue.SafeString(elem.GetAttribute("NotifyZip"));
                whDo.NotifyAdd     = SafeValue.SafeString(elem.GetAttribute("NotifyAddress"));
                whDo.NotifyTel     = SafeValue.SafeString(elem.GetAttribute("NotifyTel"));
                whDo.NotifyContact = SafeValue.SafeString(elem.GetAttribute("NotifyContact"));
                whDo.NotifyCountry = SafeValue.SafeString(elem.GetAttribute("NotifyCountry"));
                whDo.NotifyCity    = SafeValue.SafeString(elem.GetAttribute("NotifyCity"));

                whDo.ConsigneeId      = EzshipHelper.GetPartyId(SafeValue.SafeString(elem.GetAttribute("Cnee")));
                whDo.ConsigneeName    = SafeValue.SafeString(elem.GetAttribute("Cnee"));
                whDo.ConsigneeZip     = SafeValue.SafeString(elem.GetAttribute("CneeZip"));
                whDo.ConsigneeAdd     = SafeValue.SafeString(elem.GetAttribute("CneeAddress"));
                whDo.ConsigneeTel     = SafeValue.SafeString(elem.GetAttribute("CneeTel"));
                whDo.ConsigneeContact = SafeValue.SafeString(elem.GetAttribute("CneeContact"));
                whDo.ConsigneeCountry = SafeValue.SafeString(elem.GetAttribute("CneeCountry"));
                whDo.ConsigneeCity    = SafeValue.SafeString(elem.GetAttribute("CneeCity"));
                whDo.PermitBy         = SafeValue.SafeString(elem.GetAttribute("PermitBy"));
                whDo.OtherPermit      = SafeValue.SafeString(elem.GetAttribute("OtherPermit"));
                whDo.ModelType        = SafeValue.SafeString(elem.GetAttribute("ModelType"));

                if (isNew)
                {
                    doNo                = C2Setup.GetNextNo("", runType, DateTime.Today);
                    whDo.DoNo           = doNo;
                    whDo.DoType         = doType;
                    whDo.StatusCode     = "USE";
                    whDo.CreateBy       = EzshipHelper.GetUserName();
                    whDo.CreateDateTime = DateTime.Today;
                    Manager.ORManager.StartTracking(whDo, Wilson.ORMapper.InitialState.Inserted);
                    Manager.ORManager.PersistChanges(whDo);
                    C2Setup.SetNextNo("", runType, doNo, whDo.DoDate);
                }
                else
                {
                    doNo                = whDo.DoNo;
                    whDo.UpdateBy       = EzshipHelper.GetUserName();
                    whDo.UpdateDateTime = DateTime.Now;
                    Manager.ORManager.StartTracking(whDo, Wilson.ORMapper.InitialState.Updated);
                    Manager.ORManager.PersistChanges(whDo);
                }

                #endregion

                #region Delete
                if (!isNew)
                {
                    string sql_del = string.Format(@"delete from Wh_DoDet where DoNo='{0}'", doNo);
                    SafeValue.SafeInt(C2.Manager.ORManager.ExecuteScalar(sql_del), 0);

                    sql_del = string.Format(@"delete from Wh_DoDet2 where DoNo='{0}'", doNo);
                    SafeValue.SafeInt(C2.Manager.ORManager.ExecuteScalar(sql_del), 0);

                    sql_del = string.Format(@"delete from Wh_DoDet3 where DoNo='{0}'", doNo);
                    SafeValue.SafeInt(C2.Manager.ORManager.ExecuteScalar(sql_del), 0);
                }
                #endregion

                #region sku
                XmlNodeList nodeListCont = elem.SelectNodes("Sku");
                foreach (XmlNode xnMkg in nodeListCont)
                {
                    XmlElement elemSku = (XmlElement)xnMkg;
                    if (elemSku.Name == "Sku")
                    {
                        WhDoDet det = new WhDoDet();
                        det.DoNo           = doNo;
                        det.DoType         = doType;
                        det.LotNo          = SafeValue.SafeString(elemSku.GetAttribute("LotNo"));
                        det.BatchNo        = SafeValue.SafeString(elemSku.GetAttribute("BatchNo"));
                        det.CustomsLot     = SafeValue.SafeString(elemSku.GetAttribute("CustomsLot"));
                        det.ProductCode    = SafeValue.SafeString(elemSku.GetAttribute("Sku"));
                        det.Des1           = SafeValue.SafeString(elemSku.GetAttribute("Des"));
                        det.Qty1           = SafeValue.SafeInt(elemSku.GetAttribute("PackQty"), 0);
                        det.Qty2           = SafeValue.SafeInt(elemSku.GetAttribute("WholeQty"), 0);
                        det.Qty3           = SafeValue.SafeInt(elemSku.GetAttribute("LooseQty"), 0);
                        det.Qty4           = SafeValue.SafeInt(elemSku.GetAttribute("Expected"), 0);
                        det.Qty5           = SafeValue.SafeInt(elemSku.GetAttribute("Transit"), 0);
                        det.QtyPackWhole   = SafeValue.SafeInt(elemSku.GetAttribute("QtyPackWhole"), 0);
                        det.QtyWholeLoose  = SafeValue.SafeInt(elemSku.GetAttribute("QtyWholeLoose"), 0);
                        det.QtyLooseBase   = SafeValue.SafeInt(elemSku.GetAttribute("QtyLooseBase"), 0);
                        det.Uom1           = SafeValue.SafeString(elemSku.GetAttribute("PackUom"));
                        det.Uom2           = SafeValue.SafeString(elemSku.GetAttribute("WholeUom"));
                        det.Uom3           = SafeValue.SafeString(elemSku.GetAttribute("LooseUom"));
                        det.Uom4           = SafeValue.SafeString(elemSku.GetAttribute("BaseUom"));
                        det.Att1           = SafeValue.SafeString(elemSku.GetAttribute("Att1"));
                        det.Att2           = SafeValue.SafeString(elemSku.GetAttribute("Att2"));
                        det.Att3           = SafeValue.SafeString(elemSku.GetAttribute("Att3"));
                        det.Att4           = SafeValue.SafeString(elemSku.GetAttribute("Att4"));
                        det.Att5           = SafeValue.SafeString(elemSku.GetAttribute("Att5"));
                        det.Att6           = SafeValue.SafeString(elemSku.GetAttribute("Att6"));
                        det.Att7           = SafeValue.SafeString(elemSku.GetAttribute("Att7"));
                        det.Att8           = SafeValue.SafeString(elemSku.GetAttribute("Att8"));
                        det.Att9           = SafeValue.SafeString(elemSku.GetAttribute("Att9"));
                        det.Att10          = SafeValue.SafeString(elemSku.GetAttribute("Att10"));
                        det.CreateBy       = EzshipHelper.GetUserName();
                        det.CreateDateTime = DateTime.Now;
                        det.UpdateBy       = EzshipHelper.GetUserName();
                        det.UpdateDateTime = DateTime.Now;

                        Manager.ORManager.StartTracking(det, Wilson.ORMapper.InitialState.Inserted);
                        Manager.ORManager.PersistChanges(det);
                    }
                }
                #endregion

                #region PutAway
                XmlNodeList nodeListCont1 = elem.SelectNodes("PutAway");
                foreach (XmlNode xnMkg in nodeListCont1)
                {
                    XmlElement elemPutAway = (XmlElement)xnMkg;
                    if (elemPutAway.Name == "PutAway")
                    {
                        WhDoDet2 det = new WhDoDet2();
                        det.DoNo   = doNo;
                        det.DoType = doType;

                        det.LotNo          = SafeValue.SafeString(elemPutAway.GetAttribute("LotNo"));
                        det.Product        = SafeValue.SafeString(elemPutAway.GetAttribute("Product"));
                        det.Des1           = SafeValue.SafeString(elemPutAway.GetAttribute("Des"));
                        det.BatchNo        = SafeValue.SafeString(elemPutAway.GetAttribute("BatchNo"));
                        det.CustomsLot     = SafeValue.SafeString(elemPutAway.GetAttribute("CustomsLot"));
                        det.Location       = SafeValue.SafeString(elemPutAway.GetAttribute("Location"));
                        det.ProcessStatus  = SafeValue.SafeString(elemPutAway.GetAttribute("ProcessStatus"));
                        det.Qty1           = SafeValue.SafeInt(elemPutAway.GetAttribute("PackQty"), 0);
                        det.Qty2           = SafeValue.SafeInt(elemPutAway.GetAttribute("WholeQty"), 0);
                        det.Qty3           = SafeValue.SafeInt(elemPutAway.GetAttribute("LooseQty"), 0);
                        det.QtyPackWhole   = SafeValue.SafeInt(elemPutAway.GetAttribute("QtyPackWhole"), 0);
                        det.QtyWholeLoose  = SafeValue.SafeInt(elemPutAway.GetAttribute("QtyWholeLoose"), 0);
                        det.QtyLooseBase   = SafeValue.SafeInt(elemPutAway.GetAttribute("QtyLooseBase"), 0);
                        det.Uom1           = SafeValue.SafeString(elemPutAway.GetAttribute("PackUom"));
                        det.Uom2           = SafeValue.SafeString(elemPutAway.GetAttribute("WholeUom"));
                        det.Uom3           = SafeValue.SafeString(elemPutAway.GetAttribute("LooseUom"));
                        det.Uom4           = SafeValue.SafeString(elemPutAway.GetAttribute("BaseUom"));
                        det.Att1           = SafeValue.SafeString(elemPutAway.GetAttribute("Att1"));
                        det.Att2           = SafeValue.SafeString(elemPutAway.GetAttribute("Att2"));
                        det.Att3           = SafeValue.SafeString(elemPutAway.GetAttribute("Att3"));
                        det.Att4           = SafeValue.SafeString(elemPutAway.GetAttribute("Att4"));
                        det.Att5           = SafeValue.SafeString(elemPutAway.GetAttribute("Att5"));
                        det.Att6           = SafeValue.SafeString(elemPutAway.GetAttribute("Att6"));
                        det.Att7           = SafeValue.SafeString(elemPutAway.GetAttribute("Att7"));
                        det.Att8           = SafeValue.SafeString(elemPutAway.GetAttribute("Att8"));
                        det.Att9           = SafeValue.SafeString(elemPutAway.GetAttribute("Att9"));
                        det.Att10          = SafeValue.SafeString(elemPutAway.GetAttribute("Att10"));
                        det.CreateBy       = EzshipHelper.GetUserName();
                        det.CreateDateTime = DateTime.Now;
                        det.UpdateBy       = EzshipHelper.GetUserName();
                        det.UpdateDateTime = DateTime.Now;

                        Manager.ORManager.StartTracking(det, Wilson.ORMapper.InitialState.Inserted);
                        Manager.ORManager.PersistChanges(det);
                    }
                }
                #endregion

                #region Container
                XmlNodeList nodeListCont2 = elem.SelectNodes("Container");
                foreach (XmlNode xnMkg in nodeListCont2)
                {
                    XmlElement elemContainer = (XmlElement)xnMkg;
                    if (elemContainer.Name == "Container")
                    {
                        WhDoDet3 det = new WhDoDet3();
                        det.DoNo   = doNo;
                        det.DoType = doType;

                        det.ContainerNo    = SafeValue.SafeString(elemContainer.GetAttribute("ContainerNo"));
                        det.ContainerType  = SafeValue.SafeString(elemContainer.GetAttribute("ContainerType"));
                        det.SealNo         = SafeValue.SafeString(elemContainer.GetAttribute("SealNo"));
                        det.Weight         = SafeValue.SafeDecimal(elemContainer.GetAttribute("Weight"));
                        det.M3             = SafeValue.SafeDecimal(elemContainer.GetAttribute("M3"));
                        det.Qty            = SafeValue.SafeInt(elemContainer.GetAttribute("Qty"), 0);
                        det.PkgType        = SafeValue.SafeString(elemContainer.GetAttribute("PkgType"));
                        det.CreateBy       = EzshipHelper.GetUserName();
                        det.CreateDateTime = DateTime.Now;
                        det.UpdateBy       = EzshipHelper.GetUserName();
                        det.UpdateDateTime = DateTime.Now;
                        Manager.ORManager.StartTracking(det, Wilson.ORMapper.InitialState.Inserted);
                        Manager.ORManager.PersistChanges(det);
                    }
                }
                #endregion
            }
        }
        return("Type=" + doType + " , " + "No=" + doNo);
    }