/// <remarks/> public System.IAsyncResult BeginUpdateInventoryCount(InventoryCount[] inventoryCountList, System.AsyncCallback callback, object asyncState) { return this.BeginInvoke("UpdateInventoryCount", new object[] { inventoryCountList}, callback, asyncState); }
public static void SendInventoryCount() { Int16 iWrittenToDB = 0; using (var cnn = new SQLiteConnection(Common.getDBConnection())) { try { string sql = ""; SasolWax.OneMobileWS_Wax.InventoryCount inventoryCountItem; DataTable dtInventoryCount = new DataTable(); SQLiteCommand cmd = new SQLiteCommand(cnn); SQLiteDataAdapter da = new SQLiteDataAdapter(cmd); cnn.Open(); if (IsTableExists(cnn, "InventoryCount")) { sql = "SELECT * FROM InventoryCount;"; cmd.CommandText = sql; da.Fill(dtInventoryCount); List<SasolWax.OneMobileWS_Wax.InventoryCount> iCountList = new List<SasolWax.OneMobileWS_Wax.InventoryCount>(); foreach (DataRow dr in dtInventoryCount.Rows) { inventoryCountItem = new InventoryCount(); inventoryCountItem.dBagWeight = Convert.ToDecimal(dr["dBagWeight"].ToString()); inventoryCountItem.dtCount = Convert.ToDateTime(dr["dtCount"].ToString()); inventoryCountItem.iBagStation = dr["iBagStation"].ToString(); inventoryCountItem.iCountQuantity = Convert.ToInt32(dr["iCountQuantity"].ToString()); inventoryCountItem.ifkUser = Convert.ToInt16(dr["ifkUser"].ToString()); inventoryCountItem.ifkVersion = Convert.ToInt16(dr["ifkVersion"].ToString()); inventoryCountItem.ipk = Convert.ToInt32(dr["ipk"].ToString()); inventoryCountItem.sBatchCode = dr["sBatchCode"].ToString(); inventoryCountItem.sSerial = dr["sSerial"].ToString(); inventoryCountItem.sStockCode = dr["sStockCode"].ToString(); inventoryCountItem.sWarehouse = dr["sWarehouse"].ToString(); inventoryCountItem.gUID = new Guid(dr["gUID"].ToString().Trim()); iCountList.Add(inventoryCountItem); iWrittenToDB++; } cnn.Close(); Common.wsWax.UpdateInventoryCount(iCountList.ToArray()); } } catch (System.Exception ex) { } } }
public void UpdateInventoryCount(InventoryCount[] inventoryCountList) { this.Invoke("UpdateInventoryCount", new object[] { inventoryCountList}); }