//Gets the latest WorkOrder number and sets it as the _WorkOrder public void FindLastWorkOrder() { DBMaster dbmaster = new DBMaster(); DataTable dt = dbmaster.queryDB(ConfigurationManager.AppSettings["workOrdersDBName"].ToString(), "WorkOrderDetails", "WorkOrder", "DateOfProduction = (select MAX(DateOfProduction) from WorkOrderDetails);"); string latestWorkOrder = dt.Rows[0][0].ToString(); _workOrder = latestWorkOrder; }
ErrorLogger _logger = new ErrorLogger(); // The logger for this classs public HomeForm() // The initial start up Constructor { InitializeComponent(); this.Icon = Icon = Icon.ExtractAssociatedIcon(System.Reflection.Assembly.GetExecutingAssembly().Location); DBMaster dbMaster = new DBMaster(); dbMaster.GetDBNames(); // This method sets all the Database names required for the application to work InitialConditions(); //Sets all the conditions (Mainly Display Conditions) }
//This function gets the db logs of specific work order between the starting and ending time and a specific camera set and master number private DataTable GetDataBaseTable(DateTime start, DateTime end, int cs, int m) { DBMaster dbMaster = new DBMaster(); string condition = "LogTime >= '" + Convert.ToDateTime(start).ToString("yyyy-MM-dd HH:mm:ss") + "' and LogTime <= '" + Convert.ToDateTime(end).ToString("yyyy-MM-dd HH:mm:ss") + "' and CameraSet = " + cs + " and PCNumber = " + (m - 1) + ";"; DataTable dt = dbMaster.queryDB(ConfigurationManager.AppSettings["EventLogDBName"].ToString(), "[AllEvents]", "CONVERT(varchar,LogTime,120) AS LogTime,EventMessage,CurrentWorkOrder,NextWorkOrder", condition); return(dt); }
public WorkOrderRangeDisplayForm(DateTime from, DateTime to) { InitializeComponent(); this.Icon = Icon = Icon.ExtractAssociatedIcon(System.Reflection.Assembly.GetExecutingAssembly().Location); WorkOrderDetailsGridView.RowHeadersVisible = false; DBMaster dbMaster = new DBMaster(); DataTable dt = dbMaster.queryDB(ConfigurationManager.AppSettings["workOrdersDBName"].ToString(), "WorkOrderDetails", "WorkOrder,ProductCode,DateOfProduction", "DateOfProduction >='" + Convert.ToDateTime(from).ToString("yyyy-MM-dd hh:mm:ss tt") + "' AND DateOfProduction <= '" + Convert.ToDateTime(to).ToString("yyyy-MM-dd hh:mm:ss tt") + "';"); WorkOrderDetailsGridView.DataSource = dt; }
//Gets the number of Camera Sets And Masters from the DataBase private void GetCSMasters() { DBMaster dbMaster = new DBMaster(); DataTable cameraSetDt = dbMaster.queryDB(ConfigurationManager.AppSettings["webSpectorDBName"].ToString(), "CameraSets", "CSID,CSNUMPCs", ConfigurationManager.AppSettings["noConditions"].ToString()); MasterComboBox.Items.Clear(); CameraSetComboBox.Items.Clear(); CheckForLoomSystem(cameraSetDt); SetComboBoxValues(cameraSetDt); }
//Finds the next work Order and the previous Work Order private static DataTable getWorkOrderSequenceDetails() { DBMaster dbMaster = new DBMaster(); DataTable workOrderdt = dbMaster.fetchWorkOrderDetails(ConfigurationManager.AppSettings["workOrdersDBName"].ToString(), _workOrder); _WODetails = new List <string>(); _WODetails.Add(workOrderdt.Rows[0]["NEXTWORKORDER"].ToString()); _WODetails.Add(workOrderdt.Rows[0]["PREVIOUSWORKORDER"].ToString()); return(workOrderdt); }
//Finds the files which are relevant to be parsed in order to find the required work order private List <string> findFiles(string key, int cs, int m, bool isLoomSystem) { string path = ""; DBMaster dbMaster = new DBMaster(); bool frontEnd = false; if (cs == 0) { frontEnd = true; } if (!frontEnd) { string pcName = ""; if (isLoomSystem) { pcName = ConfigurationManager.AppSettings["genericErrorFolderPathLoomSystem"].ToString(); path = pcName; } else { //FOR PINCROFT PC1-- // pcName = "PC1CS" + cs.ToString() + "M" + m.ToString(); // FOR PINCROFT PC2-- // pcName = "PC2CS" + cs.ToString() + "M" + m.ToString(); // GENERIC PC Name pcName = dbMaster.queryDB(ConfigurationManager.AppSettings["webSpectorDBName"].ToString(), "PC_List", "PCName", "PCName like '%CS" + cs.ToString() + "M" + m.ToString() + "'").Rows[0]["PCName"].ToString(); path = ConfigurationManager.AppSettings["genericErrorFolderPath"].ToString().Replace("XXXXX", pcName); } } else { // Generic PC Name string pcName = dbMaster.queryDB(ConfigurationManager.AppSettings["webSpectorDBName"].ToString(), "PC_List", "PCName", "PCName like '%F1'").Rows[0]["PCName"].ToString(); //FOR PENCROFT PC1 //string pcName = "PC1F1"; //FOR PENCROFT PC2 // string pcName = "PC2F1"; path = ConfigurationManager.AppSettings["genericErrorFolderPath"].ToString().Replace("XXXXX", pcName); } List <string> files = checkDirectory(key, path, cs, m); return(files); }
private DataTable GetSystemNames() { DataTable systemNames = new DataTable(); systemNames.Columns.Add("SystemName"); systemNames.Columns.Add("CameraSet"); systemNames.Columns.Add("Master"); DBMaster obj = new DBMaster(); DataTable cameraSetDt = obj.queryDB(ConfigurationManager.AppSettings["webSpectorDBName"].ToString(), "CameraSets", "CSID,CSNumPCs", ConfigurationManager.AppSettings["noConditions"].ToString()); if (cameraSetDt.Rows.Count > 0) { string frontEndName = "FrontEnd"; int cs = 0; int m = 0; DataRow frontEndRow = systemNames.NewRow(); frontEndRow["SystemName"] = frontEndName; frontEndRow["CameraSet"] = cs; frontEndRow["Master"] = m; systemNames.Rows.Add(frontEndRow); foreach (DataRow dr in cameraSetDt.Rows) { int cameraSetID = 0; Int32.TryParse(dr["CSID"].ToString(), out cameraSetID); int numPCs = 0; Int32.TryParse(dr["CSNumPCs"].ToString(), out numPCs); for (int i = 1; i <= numPCs; i++) { DataRow row = systemNames.NewRow(); string name = "CS" + cameraSetID + "M" + i; row["SystemName"] = name; row["CameraSet"] = cameraSetID; row["Master"] = i - 1; systemNames.Rows.Add(row); } } } return(systemNames); }