public f_Item_Master(ref Inventory_System_API IE, string Partno) { InitializeComponent(); x = IE; SetUp_IM_Table(); _PartNo = Partno; Load_ItemMaster(); List <FS_Item> L_filtered = L.Where(l => l.ItemNo.Contains(_PartNo)).ToList(); List2Table(L_filtered); dgv_ItemMaster.DataSource = T; tb_PartNo.Text = Partno; Triggered = false; }
static void load_tags_from_CSV(ref Inventory_System_API x) { CDF_to_DataTable y = new CDF_to_DataTable(',', "tags.csv", true); DataTable TicketTags = new DataTable(); List <TicketTag> L = new List <TicketTag>(); TicketTags = y.Start_Conversion(); foreach (DataRow R in TicketTags.Rows) { //L.Add(TicketTagLogic.DataRow2Tag(R)); L.Add(Inventory_System_API.TicketTag_DataRow2Tag(R)); } for (int j = 0; j < L.Count; j++) { x.CreateCountTiket(L[j]); } }
public void Load_MOTags_From_SQL(ref Inventory_System_API x) { //SQL DBMNG = new SQL("FSSERV", "FSDBMR", "AmalAdmin", "Amalgamma16"); CAPA_INVContext context = new CAPA_INVContext(); SQL DBMNG = context.DB_MNG_FS; DataTable TicketMOTags = new DataTable(); List <MOTag> L = new List <MOTag>(); MOTag MOTag2Save = new MOTag(); MOTag MOTag2Compare = new MOTag(); string _query = @"SELECT * FROM [FSDBMR].[dbo].[_CAP_AC_MOTAGS] ORDER BY MOHeaderKey, MOLineKey "; TicketMOTags = DBMNG.Execute_Query(_query); int MOTagHeaderID = 0; foreach (DataRow R in TicketMOTags.Rows) { MOTag2Compare = MOTagLogic.DataRow2MOTag(R); MOTagLine _moTagLine = new MOTagLine(); if ((MOTag2Save.MO != MOTag2Compare.MO) || (MOTag2Save.MO_Ln != MOTag2Compare.MO_Ln)) { MOTag2Save = MOTag2Compare; int counter = x.CreateMOHeaderTag(MOTag2Save); MOTag2Compare = x.LoadMOHeaderTag(counter); MOTagHeaderID = MOTag2Compare.MOTagID; } _moTagLine = MOTagLineLogic.DataRow2MOTagLine(R); _moTagLine.MOTagID = MOTagHeaderID; x.CreateMOTagLine(_moTagLine); //L.Add(MOTagLogic.DataRow2MOTag(R)); //x.CreateCountTiket(TicketTagLogic.DataRow2Tag(R)); } //for (int j = 0; j < L.Count; j++) //{ // x.CreateMOHeaderTag(L[j]); //} context.Dispose(); }
static void load_MOtags_from_CSV(ref Inventory_System_API x) { CDF_to_DataTable y = new CDF_to_DataTable(',', "MO tags Headers.csv", true); DataTable MOTags = new DataTable(); List <MOTag> L = new List <MOTag>(); MOTags = y.Start_Conversion(); foreach (DataRow R in MOTags.Rows) { //L.Add(TicketTagLogic.DataRow2Tag(R)); L.Add(Inventory_System_API.MOTag_DataRow2Tag(R)); } //x.CreateMOHeaderTag(L[0]); for (int j = 0; j < L.Count; j++) { x.CreateMOHeaderTag(L[j]); } }
static void Load_Tags_From_Random(ref Inventory_System_API x, int No_Tags) { DataTable TicketTags = new DataTable(); List <TicketTag> L = new List <TicketTag>(); Random r = new Random(); TicketTags.Columns.Add("Counter", typeof(int)); TicketTags.Columns.Add("ItemNumber", typeof(string)); TicketTags.Columns.Add("ItemDescription", typeof(string)); TicketTags.Columns.Add("ItemReference1", typeof(string)); TicketTags.Columns.Add("ItemUM", typeof(string)); TicketTags.Columns.Add("Stockroom", typeof(string)); TicketTags.Columns.Add("Bin", typeof(string)); TicketTags.Columns.Add("InventoryCategory", typeof(string)); TicketTags.Columns.Add("InventoryQuantity", typeof(int)); TicketTags.Columns.Add("LotNumber", typeof(string)); string[] SKT = { "FG", "JZ", "3", "J", "NO" }; string[] BIN = { "01", "02", "03", "04", "05", "NORTH", "BIN", "B", "QC", "J01", "NORTH" }; string[] IC = { "O", "H", "I" }; int last_tag = x.GetLastCounter(); for (int i = 1; i < No_Tags; i++) { TicketTags.Rows.Add(i + last_tag, "201100", "Test Part", "87", "EA" , SKT[r.Next(0, SKT.Count())] , BIN[r.Next(0, BIN.Count())] , IC[r.Next(0, IC.Count())] , r.Next(1, 512) , "TestLot-" + r.Next(1, 365).ToString()); } foreach (DataRow R in TicketTags.Rows) { L.Add(TicketTagLogic.DataRow2Tag(R)); } for (int j = 0; j < L.Count; j++) { x.CreateCountTiket(L[j]); } }
static void Main(string[] args) { Inventory_System_API x = new Inventory_System_API("RC IE"); SQL DB_MNG = new SQL("RSSERVER", "CAPA_INV", "inv_sys", "Capsonic2017!"); //Inventory_System_API x = new Inventory_System_API("Otro"); //Inventory_System_API x = new Inventory_System_API(4); //Inventory_System_API x = new Inventory_System_API(); //x.CreateInventoryEvent("TEST", "Test"); string q = @"SELECT Ticket.TicketCounter, TicketCount.TagCountKey, TicketCount.CounterInitials, TicketCount.CountedDate, TicketCount.TicketKey, TicketCount.ItemNumber, TicketCount.ItemDescription, TicketCount.ItemRef, TicketCount.UM, TicketCount.LotNumber, TicketCount.CountQTY, TicketCount.ReCountQty, TicketCount.InventoryQty, TicketCount.BIN, TicketCount.IC, TicketCount.Verified, TicketCount.BlankTag, TicketCount.VoidTag, TicketCount.ItemNumber_FSKey, TicketCount.STK, FS_ItemMaster.FS_ItemMaster_Key FROM Ticket INNER JOIN TicketCount ON Ticket.TicketKey = TicketCount.TicketKey INNER JOIN FS_ItemMaster ON TicketCount.ItemNumber = FS_ItemMaster.ItemNumber WHERE(TicketCount.ItemNumber_FSKey = 0) AND(TicketCount.VoidTag = 0) OR (TicketCount.ItemNumber_FSKey IS NULL) order by Ticket.TicketCounter"; string _q = @"SELECT Ticket.TicketCounter, TicketCount.TagCountKey, TicketCount.CounterInitials, TicketCount.CountedDate, TicketCount.TicketKey, TicketCount.ItemNumber, TicketCount.ItemDescription, TicketCount.ItemRef, TicketCount.UM, TicketCount.LotNumber, TicketCount.CountQTY, TicketCount.ReCountQty, TicketCount.InventoryQty, TicketCount.BIN, TicketCount.IC, TicketCount.Verified, TicketCount.BlankTag, TicketCount.VoidTag, TicketCount.ItemNumber_FSKey, TicketCount.STK, FS_ItemMaster.FS_ItemMaster_Key, FS_ItemMaster.ItemNumber_FSKey AS FS_ItemM_CostKey FROM Ticket INNER JOIN TicketCount ON Ticket.TicketKey = TicketCount.TicketKey INNER JOIN FS_ItemMaster ON TicketCount.ItemNumber = FS_ItemMaster.ItemNumber WHERE TicketCount.ItemNumber_FSKey <> FS_ItemMaster.ItemNumber_FSKey"; DataTable T = DB_MNG.Execute_Query(_q); for (int i = 0; i < T.Rows.Count; i++) { string update = @"UPDATE [CAPA_INV].[dbo].[TicketCount] SET [ItemNumber_FSKey] = " + T.Rows[i]["FS_ItemM_CostKey"].ToString() + " WHERE TagCountKey=" + T.Rows[i]["TagCountKey"].ToString(); DB_MNG.Execute_Command(update); } //TicketTag z = new TicketTag(); //int tag = 0; //z = x.LoadTag(tag); }
static void Main(ref Inventory_System_API IE) { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); Application.Run(new f_BalanceAdj(ref IE)); }
public f_MOTags(ref Inventory_System_API IE) { InitializeComponent(); cb_InvEvent.Items.AddRange(_LoadEvents().ToArray()); x = IE; }
public f_MassiveTagVerify(ref Inventory_System_API IE) { InitializeComponent(); x = IE; SetUpTable(); }