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