//tuanngoc step 1 for get data from QR code and then input to contruct database public static Import_FinishGood_WareHouse ConvertQR2DataTable(string txtInput, string warehouseName, DataGridView dtinput) { Import_FinishGood_WareHouse Temp = new Import_FinishGood_WareHouse(); string[] arraydata = Regex.Replace(txtInput, " ", "").TrimStart('s').TrimEnd('e').Split(';'); if (IdentifyQR.IsCorrectFormat(txtInput.Trim()) == true) { Temp.TransactionID = Regex.Replace(txtInput, " ", ""); // get full data Temp.UserID = Class.valiballecommon.GetStorage().UserName; // get user name Temp.STT = (dtinput.Rows.Count + 1).ToString("D4"); Temp.ProductOrder = ReturnProductOrder(arraydata[1]); //"B511-20100019";//"B511-20100154"; Temp.Product = arraydata[2]; Temp.Quantity = Convert.ToUInt32(arraydata[4]); Temp.LotNo = arraydata[7].Replace(Temp.Product, "");// Temp.Warehouse = warehouseName; Temp.dateImport = DateTime.Now; return(Temp); } return(null); }
static public bool IsDuplicate(List <Import_FinishGood_WareHouse> listInput, Import_FinishGood_WareHouse itemInput) { return(listInput.Any(x => x.LotNo == itemInput.LotNo) && listInput.Any(x => x.Product == itemInput.Product) && listInput.Any(x => x.ProductOrder == itemInput.ProductOrder) && listInput.Any(x => x.Quantity == itemInput.Quantity) //&& listInput.Any(x => x.STT == itemInput.STT) && listInput.Any(x => x.SubQR == itemInput.SubQR) && listInput.Any(x => x.TL101 == itemInput.TL101) && listInput.Any(x => x.TL102 == itemInput.TL102) && listInput.Any(x => x.TL103 == itemInput.TL103) && listInput.Any(x => x.TL104 == itemInput.TL104) && listInput.Any(x => x.TL111 == itemInput.TL111) && listInput.Any(x => x.TL112 == itemInput.TL112) && listInput.Any(x => x.TL113 == itemInput.TL113) && listInput.Any(x => x.TL114 == itemInput.TL114) && listInput.Any(x => x.TransactionID == itemInput.TransactionID) && listInput.Any(x => x.UserID == itemInput.UserID) && listInput.Any(x => x.Warehouse == itemInput.Warehouse) // have to check ); }
static public bool IsWrongWareHouse(List <Import_FinishGood_WareHouse> listInput, Import_FinishGood_WareHouse itemInput) { if (listInput.Count == 0) { return(false); } return(listInput.Any(x => x.Warehouse != itemInput.Warehouse)); }