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