Exemple #1
0
        public DataSet ImportData(string billString, string orderId)
        {
            DataSet ds = GenerateEmptyTables();

            try
            {
                DzInspurWarehouseOperationService.WarehouseOperationServiceService ops = new DzInspurWarehouseOperationService.WarehouseOperationServiceService();
                string xml = "";
                switch (billString)
                {
                case "HITSHELF":     //上架
                    xml = ops.HitShelf(orderId);
                    break;

                case "STOCKTAKE":     //盘点
                    xml = ops.StockTake(orderId);
                    break;

                case "STOCKMOVE":     //下架
                    xml = ops.StockOut(orderId);
                    break;

                case "STOCKOUT":     //移位
                    xml = ops.StockMove(orderId);
                    break;
                }
                ds = ParseData(xml, ds);
            }
            catch (Exception e)
            {
                THOKUtil.ShowError("从浪潮下载数据出错,原因:" + e.Message);
            }
            return(ds);
        }
Exemple #2
0
        private List <string> ParsDateBill(string xml, string billType, List <string> list)
        {
            XmlDocument doc = new XmlDocument();
            DataSet     ds  = GenerateEmptyTables();

            try
            {
                doc.LoadXml(xml);
                if (doc.GetElementsByTagName("bb_result_info")[0].InnerText == "1")
                {
                    foreach (XmlNode billdata in doc.GetElementsByTagName("data"))
                    {
                        if (billType == billdata.FirstChild.InnerText)
                        {
                            foreach (XmlNode orderlist in billdata.ChildNodes[1])
                            {
                                DataRow billTableRow = ds.Tables["BILLTABLE"].NewRow();
                                billTableRow["bb_order_id"] = orderlist.InnerText;
                                list.Add(orderlist.InnerText);
                                ds.Tables["BILLTABLE"].Rows.Add(billTableRow);
                            }
                        }
                    }
                }
            }
            catch (Exception e)
            {
                THOKUtil.ShowError("从浪潮下载数据出错,原因:" + e.Message);
            }
            return(list);
        }
Exemple #3
0
        private DataSet ParseData(string xml, DataSet ds)
        {
            XmlDocument doc = new XmlDocument();

            try
            {
                doc.LoadXml(xml);
                foreach (XmlNode billNode in doc.GetElementsByTagName("head"))
                {
                    foreach (XmlNode detailNode in doc.GetElementsByTagName("data"))
                    {
                        DataRow detailRow = ds.Tables["DETAIL"].NewRow();
                        //主表信息
                        detailRow["bb_type"]             = billNode.SelectSingleNode("bb_type").InnerText;
                        detailRow["bb_order_id"]         = billNode.SelectSingleNode("bb_order_id").InnerText;
                        detailRow["bb_corporation_id"]   = billNode.SelectSingleNode("bb_corporation_id").InnerText;
                        detailRow["bb_corporation_name"] = billNode.SelectSingleNode("bb_corporation_name").InnerText;

                        //细表信息
                        detailRow["bb_detail_id"]       = detailNode.SelectSingleNode("bb_detail_id").InnerText;
                        detailRow["bb_operate_type"]    = detailNode.SelectSingleNode("bb_operate_type").InnerText == "A" ? "盘点" : detailNode.SelectSingleNode("bb_operate_type").InnerText == "B" ? "移出" : detailNode.SelectSingleNode("bb_operate_type").InnerText == "C" ? "移入" : "异常";
                        detailRow["bb_pallet_move_flg"] = detailNode.SelectSingleNode("bb_pallet_move_flg").InnerText;
                        detailRow["bb_cargo_no"]        = detailNode.SelectSingleNode("bb_cargo_no").InnerText;
                        if (billNode.SelectSingleNode("bb_type").InnerText == "STOCKTAKE")
                        {
                            detailRow["bb_shelf_no"] = detailNode.SelectSingleNode("bb_shelf_no").InnerText;
                        }
                        detailRow["bb_pallet_no"]     = detailNode.SelectSingleNode("bb_pallet_no").InnerText;
                        detailRow["bb_brand_id"]      = detailNode.SelectSingleNode("bb_brand_id").InnerText;
                        detailRow["bb_brand_name"]    = detailNode.SelectSingleNode("bb_brand_name").InnerText;
                        detailRow["bb_handle_num"]    = Convert.ToDouble(detailNode.SelectSingleNode("bb_handle_num").InnerText);
                        detailRow["bb_inventory_num"] = Convert.ToDouble(detailNode.SelectSingleNode("bb_inventory_num").InnerText);
                        detailRow["bb_unit"]          = detailNode.SelectSingleNode("bb_unit").InnerText;
                        detailRow["bb_cell_rfid"]     = detailNode.SelectSingleNode("bb_cell_rfid").InnerText;
                        detailRow["bb_stock_rfid"]    = detailNode.SelectSingleNode("bb_stock_rfid").InnerText;
                        detailRow["bb_unit_name"]     = detailNode.SelectSingleNode("bb_unit_name").InnerText;
                        detailRow["bb_area_type"]     = detailNode.SelectSingleNode("bb_area_type").InnerText;
                        detailRow["bb_data_time"]     = DateTime.Now;

                        ds.Tables["DETAIL"].Rows.Add(detailRow);
                    }
                }
            }
            catch (Exception e)
            {
                THOKUtil.ShowError("从浪潮下载数据出错,原因:" + e.Message);
            }
            return(ds);
        }
Exemple #4
0
        public List <string> ScanNewBill(string billString, string billType)
        {
            List <string> list = new List <string>();

            try
            {
                DzInspurWarehouseOperationService.WarehouseOperationServiceService ops = new DzInspurWarehouseOperationService.WarehouseOperationServiceService();
                string xml = ops.ScanNewBill();
                list = ParsDateBill(xml, billType, list);
            }
            catch (Exception e)
            {
                THOKUtil.ShowError("从浪潮ScanNewBill下载数据出错,原因:" + e.Message);
            }
            return(list);
        }