public static List <Product> GetProductListByJob(string jobNumber)
{
List <Product> productList = new List <Product>();
var SQL = "SELECT P.Record_Number AS 'Record Number', J.job_Number AS 'Job Number', J.Description AS 'Description', p.Mold_Number AS 'Mold #', A.Company AS 'Customer', P.Color_Standard_Folder_Created AS 'Folder Created'" +
"FROM jobs J " +
"INNER JOIN Address A ON J.Customer_Code = A.Mold_Code " +
"INNER JOIN JobLayout JL ON J.Job_Number = JL.Job_Number " +
"INNER JOIN ProductsExpandedView P ON JL.Product_And_Revision_Number = P.Record_Number " +
"WHERE J.job_Number = " + jobNumber;
SqlDataReader reader = PPDataAccess.ExecuteDataReader(SQL);
string recordNumber = "";
string queryJobNumber = "";
string customer = "";
string description = "";
string moldNumber = "";
Boolean folderCreated = false;
while (reader.Read())
{
recordNumber = reader["Record Number"].ToString();
queryJobNumber = reader["Job Number"].ToString();
customer = reader["Customer"].ToString();
description = reader["Description"].ToString();
moldNumber = reader["Mold #"].ToString();
folderCreated = reader["Folder Created"].Equals(DBNull.Value) ? false : true;
productList.Add(new Product(recordNumber, customer, description, moldNumber, queryJobNumber, folderCreated));
}
return(productList);
}
public Form1()
{
InitializeComponent();
PPDataAccess.SetToProduction();
SelectPrinter();
LoadProductList();
this.WindowState = FormWindowState.Minimized;
this.Show();
this.WindowState = FormWindowState.Normal;
}
public string setAsPrinted()
{
string message = "";
var SQL = "UPDATE Products SET Color_Standard_Folder_Created = 1 WHERE Record_Number = " + RecordNumber;
if (!PPDataAccess.ExecuteNonQuery(SQL))
{
message = "Error connecting to Database!!!";
}
return(message);
}
public static List <Product> GetProductList()
{
List <Product> productList = new List <Product>();
var SQL = "SELECT P.Record_Number AS 'Record Number'," +
"A.Company AS Customer," +
"P.Description," +
"P.Revision," +
"P.Customer_Product_Number as 'Customer Product Number'," +
"P.mold_Number as 'Mold #'," +
"LastRun as 'Last Run'" +
"FROM ProductsLatestRevision PL " +
"INNER JOIN ProductsExpandedView P ON PL.Record_Number = P.Record_Number " +
"INNER JOIN Address A ON P.Company_Code = A.Mold_Code " +
"LEFT OUTER JOIN(SELECT Customer_Code, Job_Item_Number, Max(Order_Date) AS LastRun FROM Jobs WHERE Status NOT IN ('CC', 'AB') GROUP BY Customer_Code, Job_Item_Number) LastJob ON P.Company_Code = LastJob.Customer_Code AND P.Customer_Product_Number = LastJob.Job_Item_NUmber " +
"WHERE P.Is_Active = 1 " +
"AND ISNULL(P.Color_Standard_Folder_Created, 0) = 0 " +
"AND P.Colors > 0 " +
"ORDER BY 'Last Run' DESC, Customer, Description, Revision ASC";
SqlDataReader reader = PPDataAccess.ExecuteDataReader(SQL);
string recordNumber = "";
string customer = "";
string description = "";
string revision = "";
string customerProductNumber = "";
string moldNumber = "";
DateTime?lastRun = null;
while (reader.Read())
{
recordNumber = reader["Record Number"].ToString();
customer = reader["Customer"].ToString();
description = reader["Description"].ToString();
revision = reader["Revision"].ToString();
customerProductNumber = reader["Customer Product Number"].ToString();
moldNumber = reader["Mold #"].ToString();
lastRun = reader["Last Run"].Equals(DBNull.Value) ? (DateTime?)null : DateTime.Parse(reader["Last Run"].ToString());
productList.Add(new Product(recordNumber, customer, description, revision, customerProductNumber, moldNumber, lastRun));
}
return(productList);
}
public void toggleFolderCreated()
{
var SQL = "UPDATE Products SET Color_Standard_Folder_Created = " + (FolderCreated ? "1" : "null") + " WHERE Record_Number = " + RecordNumber;
PPDataAccess.ExecuteNonQuery(SQL);
}
