/// <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 e)
{
Kernel.Core.SaveException(e);
}
}
/// <summary>
/// load a bill for user
/// </summary>
private static void LoadBill()
{
try
{
MySqlCommand cmd =
new MySqlCommand(MySqlCommandType.SELECT).Select("bills").Where("ClientName", bClient).And("ID", BillNO);
MySqlReader r = new MySqlReader(cmd);
if (r.Read())
{
bMList = r.ReadString("Medics");
}
r.Close();
}
catch (Exception ee)
{
Kernel.Core.SaveException(ee);
}
}
