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);
}
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);
}
// バーコードプリント機能
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));
// 品目番号が２１～３０桁が存在する場合に印字
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();
}