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