public void Subscriptions()
{
DataTableForm form = new DataTableForm(this, typeof(SubscriptionJournal));
form.Options["select"] = "/members/document.html";
form.Options["id"] = "idDocument";
form.Options["table"] = "Document";
Form = form;
form.Show();
}
public void Journals()
{
DataTableForm form = new DataTableForm(this, typeof(JournalDoc));
form["idDocument"].Visible = false;
form.Options["table"] = "Document";
form.Select = "/accounting/document.html";
Form = form;
form.Show();
}
public void Types()
{
if (!SecurityOn || UserAccessLevel >= AccessLevel.ReadWrite)
{
InsertMenuOption(new MenuOption("New Membership Type", "/members/type.html?id=0&from=%2Fmembers%2Ftypes.html"));
}
DataTableForm form = new DataTableForm(this, typeof(MemberType));
Form = form;
form.Options["select"] = "/members/type.html";
form.Show();
}
public DataTableForm Contacts()
{
if (!GetCurrentCafe())
{
return(null);
}
DataTableForm form = new DataTableForm(this, typeof(Contact));
form.Select = "/home/editcontact";
form["Type"].MakeSelectable(ContactType.Select(Database));
InsertMenuOption(new MenuOption("New Contact", "/home/editcontact?id=0"));
return(form);
}
private void 数据库自检ToolStripMenuItem_Click(object sender, EventArgs e)
{
CloseForm();
Control frm;
if (!dictform.ContainsKey("DataTableForm"))
{
frm = new DataTableForm(sql);
dictform.Add("DataTableForm", frm);
}
else
{
frm = dictform["DataTableForm"];
}
OpenForm(frm);
}
internal void ViewDataFromTable(string tableName)
{
try
{
var app = GetCurrentApplication();
var form = new DataTableForm();
using (var connection = new OleDbConnection(app.ADOConnectString))
{
form.LoadData(connection, tableName);
form.ShowDialog();
}
}
catch (Exception ex)
{
RobotMessageBox.Show($"Exception while loading data from {tableName}: {ex.Message}");
}
}
public DataTableForm Forms()
{
string c = GetParameters["id"];
if (c == null)
{
if (!GetCurrentCafe())
{
return(null);
}
}
else
{
Utils.Check(Database.TryGet(int.Parse(c), out RepairCafe cafe), "Repair Cafe not found");
RCSession.RepairCafe = cafe;
GetCurrentCafe();
}
DataTableForm form = new DataTableForm(this, typeof(RepairForm), false, "Date", "FormNumber", "Name", "Email", "ItemType", "ItemForRepair", "Repairer");
form.Select = "/home/editform";
return(form);
}
public override void Default()
{
if (!SecurityOn || UserAccessLevel >= AccessLevel.ReadWrite)
{
InsertMenuOptions(
new MenuOption("New Member", "/members/detail.html?id=0"),
new MenuOption("Year End", "/members/yearend.html")
);
}
DataTableForm form = new DataTableForm(this, typeof(Full_Member));
Form = form;
form.Options["select"] = "/members/detail.html";
form.Remove("MemberTypeId");
form.Remove("NameAddressId");
form.Remove("Address");
form.Remove("PostCode");
form.Remove("Contact");
form["Hidden"].Options["nonZero"] = new JObject().AddRange(
"zeroText", "Current members only",
"nonZeroText", "Include left members"
);
form.Show();
}
