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();
}
