Пример #1
0
        public virtual string GetMailContentForAutoClosePOJob(int poSysNo)
        {
            string            returnString = string.Empty;
            PurchaseOrderInfo getPOInfo    = PurchaseOrderProcessor.LoadPO(poSysNo);

            if (null != getPOInfo)
            {
                WarehouseInfo getStockInfo      = InventoryBizInteract.GetWarehouseInfoBySysNo(getPOInfo.PurchaseOrderBasicInfo.StockInfo.SysNo.Value);
                string        getStockName      = getStockInfo.WarehouseName;
                string        getCompanyName    = "网信(香港)有限公司";
                string        getCompanyAddress = "香港九龙湾启祥道20号大昌行集团大厦8楼";
                string        getComapnyTel     = "(852)27683388";
                string        getCompanyWebsite = "";
                string        getStockAddress   = getStockInfo.ReceiveAddress;
                string        getStockContact   = getStockInfo.ReceiveContact;
                string        getStockTel       = getStockInfo.ReceiveContactPhoneNumber;
                switch (getPOInfo.PurchaseOrderBasicInfo.StockInfo.SysNo)
                {
                case 50:
                case 51:
                    break;

                case 52:
                    //香港:
                    getCompanyAddress = "香港九龙湾启祥道20号大昌行集团大厦8楼";
                    getComapnyTel     = "(852)27683388";
                    break;

                case 53:
                    ////广州:
                    //getCompanyAddress = "广东省广州市天河区中山大道西779号";
                    //getComapnyTel = "020-85559980,020-85559981";
                    break;

                //case 54:
                //    //成都:
                //    getCompanyAddress = "成都双流县大件路西南航空港新地物流园区(西南民大新校区对面)";
                //    getComapnyTel = "15982082844";
                //    break;
                //case 55:
                //    //武汉:
                //    getCompanyAddress = "武汉市东西湖区革新大道(四明路与五环路之间)长江物流园C库10号门";
                //    getComapnyTel = "13339983123";
                //    break;
                //case 59:
                //    //上海市闵行:
                //    getCompanyAddress = "上海市闵行区虹梅南路3988号2号库";
                //    getComapnyTel = "13122693665";
                //    break;
                default:
                    break;
                }

                KeyValueVariables keyValues = new KeyValueVariables();
                keyValues.Add("StockName", getPOInfo.PurchaseOrderBasicInfo.StockInfo.StockName);
                keyValues.Add("ETATime", getPOInfo.PurchaseOrderBasicInfo.ETATimeInfo.ETATime.Value.ToLongTimeString());
                keyValues.Add("CompanyName", getCompanyName);
                keyValues.Add("CompanyAddress", getCompanyAddress);
                keyValues.Add("CompanyTel", getComapnyTel);
                keyValues.Add("CompanyWebSite", getCompanyWebsite);
                keyValues.Add("StockAddress", getStockAddress);
                keyValues.Add("StockContact", getStockContact);
                keyValues.Add("StockTel", getStockTel);
                keyValues.Add("displayNo", "");


                string getOldSNNumber = PurchaseOrderProcessor.GetWareHouseReceiptSerialNumber(poSysNo);
                string numberString   = getOldSNNumber.Trim();
                if (getPOInfo.PurchaseOrderBasicInfo.PurchaseOrderStatus == PurchaseOrderStatus.InStocked)
                {
                    string number = "0";

                    if (getOldSNNumber.Trim().Equals("") == false)
                    {
                        number = getOldSNNumber.Trim();
                    }
                    numberString = number;
                }
                else
                {
                    numberString = "无";
                }
                keyValues.Add("numberString", numberString);
                keyValues.Add("shipTypeString", getPOInfo.PurchaseOrderBasicInfo.ShippingType.ShippingTypeName);

                decimal totalInPagedec = 0;
                string  totalInPage    = string.Empty;
                foreach (PurchaseOrderItemInfo item in getPOInfo.POItems)
                {
                    totalInPagedec += (item.Quantity.HasValue ? item.Quantity.Value : 0) * (item.OrderPrice.HasValue ? item.OrderPrice.Value : 0);
                }
                totalInPage = getPOInfo.PurchaseOrderBasicInfo.CurrencySymbol + totalInPagedec.ToString("#########0.00");
                keyValues.Add("totalInPage", totalInPage);

                string totalAmt         = string.Empty;
                string totalReturnPoint = string.Empty;
                if (getPOInfo.PurchaseOrderBasicInfo.PM_ReturnPointSysNo > 0)
                {
                    totalAmt         = getPOInfo.PurchaseOrderBasicInfo.CurrencySymbol + Convert.ToDecimal(Convert.ToDecimal(getPOInfo.PurchaseOrderBasicInfo.TotalAmt.ToString()) - Convert.ToDecimal(getPOInfo.PurchaseOrderBasicInfo.UsingReturnPoint)).ToString("#########0.00");
                    totalReturnPoint = "产品总价:" + getPOInfo.PurchaseOrderBasicInfo.CurrencySymbol + Convert.ToDecimal(getPOInfo.PurchaseOrderBasicInfo.TotalAmt.ToString()).ToString("#########0.00") + "    " + "使用返点:" + (Convert.ToDecimal(getPOInfo.PurchaseOrderBasicInfo.UsingReturnPoint)).ToString("#########0.00");
                }
                else
                {
                    totalAmt         = getPOInfo.PurchaseOrderBasicInfo.CurrencySymbol + Convert.ToDecimal(getPOInfo.PurchaseOrderBasicInfo.TotalAmt.ToString()).ToString("#########0.00");
                    totalReturnPoint = "";
                }
                keyValues.Add("totalAmt", totalAmt);
                keyValues.Add("totalReturnPoint", totalReturnPoint);
                keyValues.Add("PMName", getPOInfo.PurchaseOrderBasicInfo.ProductManager.UserInfo.UserName);
                keyValues.Add("CurrencyName", ObjectFactory <ICommonBizInteract> .Instance.GetCurrencyInfoBySysNo(getPOInfo.PurchaseOrderBasicInfo.CurrencyCode.Value).CurrencyName);

                keyValues.Add("entity.POID", getPOInfo.PurchaseOrderBasicInfo.PurchaseOrderID);
                keyValues.Add("DateTime.Now", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
                keyValues.Add("vendor.VendorName", getPOInfo.VendorInfo.VendorBasicInfo.VendorNameLocal);
                keyValues.Add("vendor.SysNo", getPOInfo.VendorInfo.SysNo.Value.ToString());
                keyValues.Add("vendor.Address", getPOInfo.VendorInfo.VendorBasicInfo.Address);
                keyValues.Add("vendor.Contact", getPOInfo.VendorInfo.VendorBasicInfo.Contact);
                keyValues.Add("vendor.Fax", getPOInfo.VendorInfo.VendorBasicInfo.Fax);
                keyValues.Add("entity.InTime", getPOInfo.PurchaseOrderBasicInfo.InTime.HasValue ? getPOInfo.PurchaseOrderBasicInfo.InTime.Value.ToString() : "");
                keyValues.Add("entity.PayTypeName", getPOInfo.PurchaseOrderBasicInfo.PayType.PayTypeName);
                keyValues.Add("entity.Memo", getPOInfo.PurchaseOrderBasicInfo.MemoInfo.Memo);
                keyValues.Add("entity.InStockMemo", getPOInfo.PurchaseOrderBasicInfo.MemoInfo.InStockMemo);
                keyValues.Add("SendTimeString", DateTime.Now.ToString());

                KeyTableVariables keyTables            = new KeyTableVariables();
                DataTable         productAccessoryList = new DataTable();

                DataTable productItemList = new DataTable();
                productItemList.Columns.Add("item.ProductID");
                productItemList.Columns.Add("item.IsVirtualStockProduct");
                productItemList.Columns.Add("item.ProductMode");
                productItemList.Columns.Add("item.BriefName");
                productItemList.Columns.Add("item.CurrencySymbol");
                productItemList.Columns.Add("item.OrderPrice");
                productItemList.Columns.Add("item.PurchaseQty");
                productItemList.Columns.Add("item.Quantity");
                productItemList.Columns.Add("item.PurchaseQtyOrderPrice");
                productItemList.Columns.Add("item.QuantityOrderPrice");

                getPOInfo.POItems.ForEach(x =>
                {
                    DataRow dr                       = productItemList.NewRow();
                    dr["item.ProductID"]             = x.ProductID;
                    dr["item.IsVirtualStockProduct"] = x.IsVirtualStockProduct;
                    dr["item.ProductMode"]           = x.ProductMode;
                    dr["item.BriefName"]             = x.BriefName;
                    dr["item.CurrencySymbol"]        = x.CurrencySymbol;
                    dr["item.OrderPrice"]            = x.OrderPrice.Value.ToString("#########0.00");
                    dr["item.PurchaseQty"]           = x.PurchaseQty.Value.ToString();
                    dr["item.Quantity"]              = x.Quantity.Value.ToString();
                    dr["item.PurchaseQtyOrderPrice"] = (x.PurchaseQty.Value * x.OrderPrice.Value).ToString("#########0.00");
                    dr["item.QuantityOrderPrice"]    = (x.Quantity.Value * x.OrderPrice.Value).ToString("#########0.00");
                    productItemList.Rows.Add(dr);
                });

                DataTable dt = PurchaseOrderProcessor.GetPurchaseOrderAccessories(poSysNo);
                if (dt.Rows.Count > 0)
                {
                    foreach (DataRow sr in dt.Rows)
                    {
                        DataRow dr = productAccessoryList.NewRow();
                        dr["ProductID"]            = dr["ProductID"].ToString();
                        dr["AccessoriesID"]        = dr["AccessoriesID"].ToString();
                        dr["AccessoriesIDAndName"] = dr["AccessoriesIDAndName"].ToString();
                        dr["Qty"] = dr["Qty"].ToString();
                        productAccessoryList.Rows.Add(dr);
                    }
                }
                keyTables.Add("tblProductItemsList", productItemList);
                keyTables.Add("tblProductAccessoryList", productItemList);

                MailMessage mailMsg = new MailMessage();
                EmailTemplateHelper.BuildEmailBodyByTemplate(mailMsg, "PO_AutoCloseMail", keyValues, keyTables, Thread.CurrentThread.CurrentCulture.Name);
                returnString = mailMsg.Body;
                return(returnString);
            }
            else
            {
                throw new BizException("未找到相关PO单数据!");
            }
        }