public int SendDataToWebService(string referenceNo) { List <Picking> pickngList = new List <Picking>(); var script = @"SELECT [Delivery Order Tag], [Part No.], [Tag No.], [Scan DateTime] FROM FGPicking WHERE ([Delivery Order Tag] = @REFERENCENO)"; using (var conn = dbConnect.GetConnection()) { conn.Open(); using (var cmd = new SqlCeCommand(script, conn)) { cmd.Parameters.Add("REFERENCENO", referenceNo); var reader = cmd.ExecuteReader(); while (reader.Read()) { var pg = new Picking(); pg.PartNo = reader["Part No."].ToString(); pg.TagNo = reader["Tag No."].ToString(); pg.ScanDateTime = reader["Scan DateTime"].ToString(); pickngList.Add(pg); } } } int result = 0; if (pickngList.Count > 0) { Hashtable hs = new Hashtable(); hs.Add("referenceNo", referenceNo); hs.Add("pickingList", pickngList); var request = JsonConvert.SerializeObject(hs); var serviceReference = new ServicesBLService(); string userId = Session.GetCurrentUser().UserID; var response = serviceReference.insertPickingDetail(request, userId); if (response.Equals("success")) { result = 1; } } return(result); }
public int SendDataToWebService(string doCode) { List <ShippingTransaction> shippingList = new List <ShippingTransaction>(); List <OperationLog> logData = new List <OperationLog>(); var script = @"SELECT Shipping.[Delivery Order Tag], Shipping.[DO Part No.], FATHTag.[Tag No.], FATHTag.[Scan DateTime] FROM Shipping INNER JOIN FATHTag ON Shipping.[Delivery Order Tag] = FATHTag.[Delivery Order Tag] AND Shipping.[DO Part No.] = FATHTag.[Part No.] WHERE Shipping.[Delivery Order Tag] = @DELIVERYORDERTAG"; var logScript = @"SELECT [MenuID], [Operation DateTime], [UserID], [Event], [FieldName], [FieldValue], [Error Flag], [Error Msg ID] FROM TBL_OPER_LOG WHERE [MenuID] = @MENUID"; using (var conn = dbConnect.GetConnection()) { conn.Open(); using (var cmd = new SqlCeCommand(script, conn)) { cmd.Parameters.Add("DELIVERYORDERTAG", doCode); var reader = cmd.ExecuteReader(); while (reader.Read()) { var shipping = new ShippingTransaction(); shipping.PartNo = reader["DO Part No."].ToString(); shipping.TagNo = reader["Tag No."].ToString(); shipping.ScanDateTime = reader["Scan DateTime"].ToString(); shippingList.Add(shipping); } } using (var cmd = new SqlCeCommand(logScript, conn)) { cmd.Parameters.Add("MENUID", "M02"); var reader = cmd.ExecuteReader(); while (reader.Read()) { var log = new OperationLog( reader["MenuID"].ToString(), Session.GetCurrentUser().UserID, Convert.ToBoolean(reader["Event"]) == true ? OperationLog.LogEvent.Scan : OperationLog.LogEvent.ClickButton, reader["FieldName"].ToString(), reader["FieldValue"].ToString(), Convert.ToBoolean(reader["Error Flag"]) == true ? OperationLog.ErrorFlag.Error : OperationLog.ErrorFlag.NotError, reader["Error Msg ID"].ToString(), Convert.ToDateTime(reader["Operation DateTime"])); logData.Add(log); } } } int result = 0; if (shippingList.Count > 0) { Hashtable hs = new Hashtable(); hs.Add("doCode", doCode); hs.Add("shippingList", shippingList); hs.Add("logData", logData); var request = JsonConvert.SerializeObject(hs); var serviceReference = new ServicesBLService(); string userId = Session.GetCurrentUser().UserID; var response = serviceReference.insertShippingDetail(request, userId); if (response == "success") { result = 1; } } return(result); }