private bool CheckCustomerPartNo(GenericCode code) { var script = @"SELECT COUNT(*) FROM Shipping WHERE ([Delivery Order Tag] = @DELIVERYORDERTAG) AND ([DO Part No.] = @PARTNO) AND ([Customer Part No.] = @PARTNO)"; using (var conn = dbConnect.GetConnection()) { conn.Open(); using (var cmd = new SqlCeCommand(script, conn)) { cmd.Parameters.Add("DELIVERYORDERTAG", code["Delivery Order Tag"]); cmd.Parameters.Add("PARTNO", code["Customer Part No."]); return(Convert.ToInt32(cmd.ExecuteScalar()) > 0); } } }
public bool DuplicateTagNo(GenericCode code) { var script = @"SELECT COUNT(*) FROM FGPicking WHERE ([Tag No.] = @DATA) AND ([Delivery Order Tag] = @DELIVERYORDERTAG)"; using (var conn = dbConnect.GetConnection()) { conn.Open(); using (var cmd = new SqlCeCommand(script, conn)) { cmd.Parameters.Add("DELIVERYORDERTAG", code["Delivery Order Tag"]); cmd.Parameters.Add("TAGNO", code["Tag No."].ToString()); int rowAffected = Convert.ToInt32(cmd.ExecuteScalar()); return(rowAffected > 0); } } }
public bool IsTagNoDuplicate(GenericCode code) { var script = @"SELECT COUNT(*) FROM FATHTag WHERE ([Delivery Order Tag] = @DELIVERYORDERTAG) AND ([Part No.] = @PARTNO) AND ([Tag No.] = @TAGNO)"; using (var conn = dbConnect.GetConnection()) { conn.Open(); using (var cmd = new SqlCeCommand(script, conn)) { cmd.Parameters.Add("DELIVERYORDERTAG", code["Delivery Order Tag"]); cmd.Parameters.Add("PARTNO", code["FATH Part No."]); cmd.Parameters.Add("TAGNO", code["FATH Tag No."]); return(Convert.ToInt32(cmd.ExecuteScalar()) > 0); } } }
public static GenericCode ConvertDataToGenericCode(string data) { var fathTag = new GenericCode(); var sp = (char)10; if (data.Contains(sp)) { var tag = data.Split(sp).ToArray <string>(); fathTag["Part No."] = tag[0]; fathTag["Part Name"] = tag[1]; fathTag["Qty."] = Convert.ToInt32((((tag[2].Split(':').ToArray())[1]).Trim()).Split(' ')[0]); fathTag["Model"] = ((tag[3].Split(':').ToArray())[1]).Trim(); fathTag["Customer"] = ((tag[4].Split(':').ToArray())[1]).Trim(); fathTag["Tag No."] = ((tag[5].Split(':').ToArray())[1]).Trim(); fathTag["Production Date"] = ((tag[6].Split(':').ToArray())[1]).Trim(); } return(fathTag); }
public int UpdateFATHTag(GenericCode code) { var script = @"INSERT INTO FATHTag ([Delivery Order Tag], [Part No.], [Qty.], [Tag No.], [Scan DateTime]) VALUES(@DELIVERYORDERTAG, @PARTNO, @QTY, @TAGNO, @SCANDATETIME)"; using (var conn = dbConnect.GetConnection()) { conn.Open(); using (var cmd = new SqlCeCommand(script, conn)) { cmd.Parameters.Add("DELIVERYORDERTAG", code["Delivery Order Tag"]); cmd.Parameters.Add("PARTNO", code["FATH Part No."]); cmd.Parameters.Add("QTY", code["FATH Qty."]); cmd.Parameters.Add("TAGNO", code["FATH Tag No."]); var dt = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); cmd.Parameters.Add("SCANDATETIME", dt.ToString()); return(cmd.ExecuteNonQuery()); } } }
public int UpdateCustomerQty(GenericCode code) { var script = @"UPDATE Shipping SET [Customer Qty.] = @QTY, [Scan DateTime] = @SCANDATETIME WHERE ([Delivery Order Tag] = @DELIVERYORDERTAG) AND ([DO Part No.] = @PARTNO)"; using (var conn = dbConnect.GetConnection()) { conn.Open(); using (var cmd = new SqlCeCommand(script, conn)) { cmd.Parameters.Add("DELIVERYORDERTAG", code["Delivery Order Tag"]); cmd.Parameters.Add("PARTNO", code["Customer Part No."]); var dt = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); cmd.Parameters.Add("SCANDATETIME", dt.ToString()); cmd.Parameters.Add("QTY", code["Customer Qty."]); return(cmd.ExecuteNonQuery()); } } }
public int UpdateCustomerPathNo(GenericCode code) { bool isExists = CheckCustomerPartNo(code); if (!isExists) { var script = @"INSERT INTO Shipping([Delivery Order Tag], [DO Part No.], [Customer Part No.], [Scan DateTime]) VALUES(@DELIVERYORDERTAG, @PARTNO, @PARTNO, @SCANDATETIME)"; using (var conn = dbConnect.GetConnection()) { conn.Open(); using (var cmd = new SqlCeCommand(script, conn)) { cmd.Parameters.Add("DELIVERYORDERTAG", code["Delivery Order Tag"]); cmd.Parameters.Add("PARTNO", code["Customer Part No."]); var dt = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); cmd.Parameters.Add("SCANDATETIME", dt.ToString()); return(cmd.ExecuteNonQuery()); } } } return(0); }