Example #1
0
        public static List <TfImport> LoadUserListFromExcelFile(string path)
        {
            var tf = new List <TfImport>();

            foreach (var line in File.ReadAllLines(path))
            {
                var    columns = line.Split(',');
                double dBuff;
                double.TryParse(columns[4].Trim(), out dBuff);

                string buff = columns[0].Trim();
                if (buff.IndexOf("Supplier Name") < 0 && buff != "" && buff != string.Empty)
                {
                    tf.Add(new TfImport
                    {
                        ItemNumber      = columns[1].Trim(),
                        ItemName        = columns[2].Trim(),
                        SupplierName    = columns[0].Trim(),
                        SupplierInvoice = columns[5].Trim(),
                        Delivery        = columns[3].Trim(),
                        DeliveredQTY    = dBuff.ToString("#,##0"),
                        Validity        = VBStrings.Left(columns[0].Trim(), 0)
                    });
                }
            }

            return(tf);
        }
Example #2
0
        public static List <TfImport> LoadUserListFromPremacFile(string path)
        {
            var tf = new List <TfImport>();

            foreach (var line in File.ReadAllLines(path))
            {
                var    columns = line.Split('?');
                double dBuff;
                double.TryParse(columns[11].Trim(), out dBuff);

                string buff = columns[0].Trim();
                if (buff.IndexOf("(CPFXE049)") < 0 && buff.IndexOf("SupplierCD") < 0 && buff != "" && buff != string.Empty)
                {
                    tf.Add(new TfImport
                    {
                        ItemNumber      = columns[2].Trim(),
                        ItemName        = columns[3].Trim(),
                        SupplierName    = columns[1].Trim(),
                        SupplierInvoice = columns[30].Trim(),
                        Delivery        = columns[10].Trim(),
                        DeliveredQTY    = dBuff.ToString("#,##0"),
                        Validity        = VBStrings.Left(columns[0].Trim(), 0)
                    });
                }
            }

            tf.Sort((a, b) => a.ItemNumber.CompareTo(b.ItemNumber));
            return(tf);
        }
Example #3
0
        // バーコードプリント機能
        public static void printBarCode(string itemNo, string itemName, string supplier, string invoice, string date, string qty, string validity)
        {
            //itemNo = "A32-164D-X";
            //itemName = "SHAFT";
            //supplier = "SHINDENSHA CO.,LTD.";
            //invoice = "NDCV160129";
            //date = "2017/12/31";
            //qty = "2500";
            //validity = string.Empty; //"2017/12/31";

            long   rtn;
            int    x, y;
            string printerName = "SEWOO Label Printer";

            int    xdots, model; // ydots;
            string TwoBAR_Command;
            string QRCode_data = itemNo + ";" + itemName + ";" + supplier + ";" + invoice + ";" + date + ";" + qty + ";" + validity;

            /* 1. LK_OpenPrinter() */
            if (LKBPRINT.LK_OpenPrinter(printerName) != LKBPRINT.LK_SUCCESS)
            {
                return;
            }

            /* 2. LK_SetupPrinter() */
            rtn = LKBPRINT.LK_SetupPrinter("102", // 10~104 (Unit is mm)
                                           "54",  // 5~350 (Unit is mm)
                                           0,     // 0=Label with Gap, 1=Label with Black Mark, 2=Label with Continuous.
                                           "3",   // if(MediaType==0) <GapHeight> else <BlackMarkHeight>. (Unit is mm)
                                           "0",   // if(MediaType==0) <not used> else <distance from BlackMark to perforation>. (Unit is mm)
                                           8,     // 0 ~ 15
                                           6,     // 2 ~ 6 (Unit is Inch)
                                           1      // 1 ~ 9999 copies
                                           );

            if (rtn != LKBPRINT.LK_SUCCESS)
            {
                LKBPRINT.LK_ClosePrinter(); return;
            }

            /* 3-1. page 1 test */
            LKBPRINT.LK_StartPage();

            // QR Code のプリントアウト
            // bx,y,Q,1,z,L,"DATA"
            // x = x position.
            // y = y position
            // z = Cell Size. (2 ~ 16)
            // L = ECC Level(L or M or Q or H)
            x              = 80 * 8;
            y              = 32 * 8;
            xdots          = 4; //3
            model          = 1;
            TwoBAR_Command = string.Format("b{0},{1},Q,{2},{3},L,\"{4}\"\r\n", x, y, model, xdots, QRCode_data);
            LKBPRINT.LK_DirectCommand(TwoBAR_Command);

            // 文字列のプリントアウト

            x = 5 * 8;
            y = (6 + 9 * 0 - 1) * 8;
            LKBPRINT.LK_PrintDeviceFont(x, y, 0, 4, 1, 1, 0, itemName);

            x = 5 * 8;
            y = (6 + 9 * 0 + 4) * 8;
            LKBPRINT.LK_PrintDeviceFont(x, y, 0, 5, 1, 1, 0, VBStrings.Left(itemNo, 20));

            // 品目番号が21~30桁が存在する場合に印字
            if (itemNo.Length >= 21)
            {
                x = 70 * 8;
                y = (6 + 9 * 0 - 1) * 8;
                LKBPRINT.LK_PrintDeviceFont(x, y, 0, 4, 1, 1, 0, VBStrings.Mid(itemNo, 21, 10));
            }

            x = 5 * 8;
            y = (6 + 9 * 1 + 5) * 8;
            LKBPRINT.LK_PrintDeviceFont(x, y, 0, 4, 1, 1, 0, supplier);

            x = 5 * 8;
            y = (6 + 9 * 2 + 1) * 8;
            LKBPRINT.LK_PrintDeviceFont(x, y, 0, 5, 1, 1, 0, invoice);

            x = 5 * 8;
            y = (6 + 9 * 2 + 11) * 8;
            LKBPRINT.LK_PrintDeviceFont(x, y, 0, 4, 1, 1, 0, "R: ");

            x = (5 + 5) * 8;
            y = (6 + 9 * 2 + 11) * 8;
            LKBPRINT.LK_PrintDeviceFont(x, y, 0, 4, 1, 1, 0, date);

            if (validity != string.Empty)
            {
                x = (5 + 28) * 8;
                y = (6 + 9 * 2 + 11) * 8;
                LKBPRINT.LK_PrintDeviceFont(x, y, 0, 4, 1, 1, 0, "V: ");

                x = (5 + 33) * 8;
                y = (6 + 9 * 2 + 11) * 8;
                LKBPRINT.LK_PrintDeviceFont(x, y, 0, 4, 1, 1, 0, validity);
            }

            x = 5 * 8;
            y = (6 + 9 * 4) * 8;
            LKBPRINT.LK_PrintDeviceFont(x, y, 0, 5, 1, 1, 0, qty);


            LKBPRINT.LK_EndPage();

            /* 4. LK_ClosePrinter() */
            LKBPRINT.LK_ClosePrinter();
        }