private GeneralRecord selectClient(List <GeneralRecord> list) { GeneralRecord client = new GeneralRecord(); if (list.Count == 1) { client = list[0]; list.RemoveAt(0); } else { client = list[0]; int position = 0; for (int i = 0; i < list.Count; i++) { if (client.Queue_number > list[i].Queue_number) { client = list[i]; position = i; } } list.RemoveAt(position); } return(client); }
public void EnVipQueue(GeneralRecord record) { if (record.Queue_number > 0 && record.Customer_type == true) { business_vip_queue.Enqueue(record); } }
public void EnGeneralQueue(GeneralRecord record) { if (record.Queue_number > 0) { business_queue.Enqueue(record); } }
private void business_button_six_click(object sender, EventArgs e) { GeneralRecord record = new GeneralRecord(configureXml.getScreenForm_title(), false, userFormThree_button_six.Text, ++id_six, DateTime.Today); businessQueue_six.EnBusinessQueue(record); DB.insertTable(false, record.Business_name, record.Queue_number); Speech.getInstance().speechText("请取票"); printer.print(new StringBuilder(id_six.ToString()), new StringBuilder(userFormThree_button_six.Text), new StringBuilder(((businessQueue_six.getGeneralQueueCount() + businessQueue_six.getVipQueueCount()) - 1).ToString())); }
public void EnBusinessQueue(GeneralRecord record) { if (record.Queue_number > 0) { if (record.Customer_type == true) { this.EnVipQueue(record); } else { this.EnGeneralQueue(record); } } }
private List <GeneralRecord> getResultset(String sql) { if (getSqlCommand(sql)) { MySqlDataReader reader = sqlcmd.ExecuteReader(); List <GeneralRecord> list = new List <GeneralRecord>(); try { while (reader.Read()) { if (reader.HasRows) { GeneralRecord client = new GeneralRecord(); client.Business_name = reader.GetString(1); if (reader.GetString(2).Equals("True")) { client.Customer_type = true; } else { client.Customer_type = false; } client.Date = reader.GetDateTime(4); client.Queue_number = reader.GetInt32(5); list.Add(client); Console.WriteLine("取号:" + reader.GetString(5) + " 客户类型:" + reader.GetString(1) + " 客户业务:" + reader.GetString(2) + " 时间:" + reader.GetString(4)); } } } catch (Exception) { throw new Exception("查询失败了!"); } finally { reader.Close(); } return(list); } else { throw new Exception("sql语句执行失败!"); } }
public GeneralRecord DeBusinessQueue() { if (business_vip_queue.Count > 0) { GeneralRecord record = business_vip_queue.Dequeue(); DB.deleteRecord(record.Customer_type, record.Business_name, record.Queue_number); return(record); } else { if (business_queue.Count > 0) { GeneralRecord record = business_queue.Dequeue(); DB.deleteRecord(record.Customer_type, record.Business_name, record.Queue_number); return(record); } else { return(null); } } }