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