/// <summary>
/// get bill nubmer
/// </summary>
public static void LBN()
{
try
{
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT).Select("bills").Order("ID", true);
MySqlReader r = new MySqlReader(cmd);
BillNO = r.Read() ? r.ReadUInt32("ID") : 0;
r.Close();
}
catch (Exception ee)
{
Program.SaveException(ee);
}
}
/// <summary>
/// load a bell for user
/// </summary>
private static void LoadBill()
{
try
{
MySqlCommand cmd =
new MySqlCommand(MySqlCommandType.SELECT).Select("bills").Where("Name", Client).And("ID", BillNO);
MySqlReader r = new MySqlReader(cmd);
if (r.Read())
{
MList = r.ReadString("Medic");
}
r.Close();
}
catch (Exception ee)
{
Program.SaveException(ee);
}
}