public static string[] format(dispatchlist_t st) { string str; string[] strArray; str = format(st); strArray = str.Split(';'); return(strArray); }
public int updateDispatchStatus(dispatchlist_t st_dispatchlist) { string insertString; string[] insertStringSplitted; string connectionString; connectionString = "data source = " + gVariable.hostString + "; user id = root; PWD = ; Charset=utf8"; mySQLClass.getDatabaseInsertStringFromExcel(ref insertString, c_dispatchListFileName); insertStringSplitted = insertString.Split(',@'); try { MySqlConnection myConnection = new MySqlConnection("database = " + m_dbName + "; " + connectionString); myConnection.Open(); MySqlCommand myCommand = myConnection.CreateCommand(); if (st_dispatchlist.status == gVariable.MACHINE_STATUS_DISPATCH_COMPLETED) { myCommand.CommandText = "update "; myCommand.CommandText += "`" + c_dispatchListTableName + "` "; myCommand.CommandText += "set "; myCommand.CommandText += "`" + insertStringSplitted[OPERATOR_NAME_INDEX] + "`=" + st_dispatchlist.operatorName + ","; myCommand.CommandText += "`" + insertStringSplitted[RECEIVE_NUM_INDEX] + "`=" + st_dispatchlist.receiveNum + ","; myCommand.CommandText += "`" + insertStringSplitted[QUALIFY_NUM_INDEX] + "`=" + st_dispatchlist.qualifyNumber + ","; myCommand.CommandText += "`" + insertStringSplitted[UNQUALIFY_NUM_INDEX] + "`=" + st_dispatchlist.unqualifyNumber + ","; myCommand.CommandText += "`" + insertStringSplitted[COMPLETE_TIME_INDEX] + "`=" + st_dispatchlist.completeTime + ","; myCommand.CommandText += "`" + insertStringSplitted[STATUS_INDEX] + "`=" + st_dispatchlist.status + ","; myCommand.CommandText += "`" + insertStringSplitted[TOOL_LIFETIME_INDEX] + "`=" + st_dispatchlist.status + ","; myCommand.CommandText += "`" + insertStringSplitted[TOOL_USED_TIMES_INDEX] + "`=" + st_dispatchlist.status + ","; myCommand.CommandText += "`" + insertStringSplitted[OUTPUT_RATIO_INDEX] + "`=" + st_dispatchlist.status + ","; myCommand.CommandText += "`" + insertStringSplitted[REPORTER_INDEX] + "`=" + st_dispatchlist.status + ","; myCommand.CommandText += "`" + insertStringSplitted[STATUS_INDEX] + "`=" + st_dispatchlist.status + ","; myCommand.CommandText += "`" + insertStringSplitted[WORKSHIFT_INDEX] + "`=" + st_dispatchlist.status + ","; myCommand.CommandText += "`" + insertStringSplitted[RECEIVE_NUM_INDEX] + "`=" + st_dispatchlist.productScanTime; } myCommand.ExecuteNonQuery(); myConnection.Close(); return(0); } catch (Exception ex) { Console.WriteLine(c_dbName + ":" + c_productprintlistTableName + ": update product barcode failed! " + ex); } return(-1); }
public static string format(dispatchlist_t st) { string str = null; str += st.machineID + ";" + st.dispatchCode + ";" + st.planTime1 + ";" + st.planTime2 + ";"; str += st.productCode + ";" + st.productName + ";" + st.operatorName + ";" + st.forcastNum + ";"; str += st.receiveNum + ";" + st.qualifyNumber + ";" + st.unqualifyNumber + ";" + st.processName + ";"; str += st.startTime + ";" + st.completeTime + ";" + st.prepareTimePoint + ";" + st.status + ";"; str += st.toolLifeTimes + ";" + st.toolUsedTimes + ";" + st.outputRatio + ";" + st.serialNumber + ";"; str += st.reportor + ";" + st.workshop + ";" + st.workshift + ";" + st.salesOrderCode + ";"; str += st.BOMCode + ";" + st.customer + ";" + st.multiProduct + ";" + st.productCode2 + ";"; str += st.productCode3 + ";" + st.operatorName2 + ";" + st.operatorName3 + ";" + st.batchNum + ";"; str += st.productColor + ";" + st.rawMaterialCode + ";" + st.productLength + ";" + st.productDiameter + ";"; str += st.productWeight + ";" + st.slitWidth + ";" + st.printSize; return(str); }
public dispatchlist_t[] readallrecordOrdered() { dispatchlist_t?dd; string[] recordArray; dispatchlist_t[] st_dispatchlist; string commandText = "select * from `" + c_dispatchListTableName + "` order by id DESC"; recordArray = mySQLClass.databaseCommonReadingUnsplitted(m_dbName, commandText); if (recordArray != null) { st_dispatchlist = new dispatchlist_t[recordArray.Length]; for (int i = 0; i < recordArray.Length; i++) { dd = parseinput(recordArray[i]); st_dispatchlist[i] = dd.Value; } } return(st_dispatchlist); }
//return 0 written to table successfully // -1 exception occurred public int writerecord(dispatchlist_t st_dispatchlist) { int num; int index; string[] itemName; string insertString; string connectionString; connectionString = "data source = " + gVariable.hostString + "; user id = root; PWD = ; Charset=utf8"; mySQLClass.getDatabaseInsertStringFromExcel(ref insertString, c_dispatchListTableName); try { index = 0; itemName = insertString.Split(',', ')'); MySqlConnection myConnection = new MySqlConnection("database = " + c_dbName + "; " + connectionString); myConnection.Open(); MySqlCommand myCommand = myConnection.CreateCommand(); myCommand.CommandText = "insert into `" + c_dispatchListTableName + "`" + insertString; myCommand.Parameters.AddWithValue("@id", 0); myCommand.Parameters.AddWithValue(itemName[index++], st_dispatchlist.machineID); myCommand.Parameters.AddWithValue(itemName[index++], st_dispatchlist.dispatchCode); myCommand.Parameters.AddWithValue(itemName[index++], st_dispatchlist.planTime1); myCommand.Parameters.AddWithValue(itemName[index++], st_dispatchlist.planTime2); myCommand.Parameters.AddWithValue(itemName[index++], st_dispatchlist.productCode); myCommand.Parameters.AddWithValue(itemName[index++], st_dispatchlist.productName); myCommand.Parameters.AddWithValue(itemName[index++], st_dispatchlist.operatorName); myCommand.Parameters.AddWithValue(itemName[index++], st_dispatchlist.plannedNumber); myCommand.Parameters.AddWithValue(itemName[index++], st_dispatchlist.outputNumber); myCommand.Parameters.AddWithValue(itemName[index++], st_dispatchlist.qualifiedNumber); myCommand.Parameters.AddWithValue(itemName[index++], st_dispatchlist.unqualifiedNumber); myCommand.Parameters.AddWithValue(itemName[index++], st_dispatchlist.processName); myCommand.Parameters.AddWithValue(itemName[index++], st_dispatchlist.realStartTime); myCommand.Parameters.AddWithValue(itemName[index++], st_dispatchlist.realFinishTime); myCommand.Parameters.AddWithValue(itemName[index++], st_dispatchlist.prepareTimePoint); myCommand.Parameters.AddWithValue(itemName[index++], st_dispatchlist.status); myCommand.Parameters.AddWithValue(itemName[index++], st_dispatchlist.toolLifeTimes); myCommand.Parameters.AddWithValue(itemName[index++], st_dispatchlist.toolUsedTimes); myCommand.Parameters.AddWithValue(itemName[index++], st_dispatchlist.outputRatio); myCommand.Parameters.AddWithValue(itemName[index++], st_dispatchlist.serialNumber); myCommand.Parameters.AddWithValue(itemName[index++], st_dispatchlist.reportor); myCommand.Parameters.AddWithValue(itemName[index++], st_dispatchlist.workshop); myCommand.Parameters.AddWithValue(itemName[index++], st_dispatchlist.workshift); myCommand.Parameters.AddWithValue(itemName[index++], st_dispatchlist.salesOrderCode); myCommand.Parameters.AddWithValue(itemName[index++], st_dispatchlist.BOMCode); myCommand.Parameters.AddWithValue(itemName[index++], st_dispatchlist.customer); myCommand.ExecuteNonQuery(); myConnection.Close(); return(0); } catch (Exception ex) { Console.WriteLine(m_dbName + ":" + c_dispatchListTableName + ": write record failed!" + ex); } return(-1); }