U++ forum: Welcome to the forum

Re: Doing my own thing with the ADD button on GridCtrl? [message #23406 is a reply to message #23401]

Sat, 17 October 2009 02:17

sergeynikitin
Messages: 748
Registered: January 2008
Location: Moscow, Russia

Contributor

I use the following scheme (I found these options, analyzing the examples, and in particular HomeBudget). Total 2 cases: 1 - edit in place. 2-editing from a separate window.

For edit in place I use next Callbacks:

WhenUpdateRecord - When editing the line after the last field has lost focus, to perform writing to disc.
(I can issue a command grid.CancelUpdate () inside a CallBack to cancel the changes.)

WhenInsertRecord - When inserting/appending the line after the last field has lost focus, to perform writing to disc.
(I can issue a command grid.CancelInsert () inside a CallBack to cancel the changes.)

WhenRemoveRecord - When deleting the line, to perform writing to disc.
(I can issue a command grid.CancelRemove () inside a CallBack to cancel the changes.)

For edit in separate window I use next Callbacks:

WhenStartEditing + IsNewRecord() filter - When editing the line.

WhenInsertRecord - When inserting/appending the line
Moreover, it is necessary in the first lines of procedure to issue CallBack CommitNewRow - to reset the flag a new line.

WhenRemoveRecord - When deleting the line, to perform prompting in separate window and writing to disc.

Example for edit in place:
Setting Callbacks:

	Nomencl.WhenInsertRow = THISBACK(InsertNomencl);
	Nomencl.WhenUpdateRow = THISBACK(UpdateNomencl);
	Nomencl.WhenRemoveRow = THISBACK(RemoveNomencl);

Actually the Callbacks:

void DictNomencl::InsertNomencl()
{
	sql * Insert(NOMENCL)
		(NOM_NAME, Nomencl(NOM_NAME));
	Nomencl.Refresh();
	Nomencl(NOM_ID) = sql.GetInsertedId();
}
void DictNomencl::UpdateNomencl()
{
	sql * SqlUpdate(NOMENCL)
		(NOM_ID, Nomencl(NOM_ID))
		(NOM_NAME, Nomencl(NOM_NAME))
		.Where(NOM_ID == Nomencl(NOM_ID));
}
void DictNomencl::RemoveNomencl()
{
	int i = (int)(Nomencl(NOM_ID));
	sql * Delete(NOMENCL).Where(NOM_ID == i);

}

Example editing in separate window:
Setting Callbacks:

	Company.WhenInsertRow = THISBACK(InsertCompany);
	Company.WhenRemoveRow = THISBACK(RemoveCompany);
	Company.WhenStartEdit = THISBACK(UpdateCompany);

Actually the Callbacks:

void DictCompany::InsertCompany()
{
	DictEditCompany dlg;
	Company.CommitNewRow();
	if(dlg.Run() != IDOK) {
		Company.CancelInsert();
		return;
	}
	sql * dlg.ctrls.Insert(COMPANY);
	Company(COM_ID) = sql.GetInsertedId();
	Company(COM_NAME)=~dlg.tab1.COM_Name;
	dlg.SaveCompanyAddresses();
}
void DictCompany::UpdateCompany()
{
	if(Company.IsNewRow()) return;
	DictEditCompany dlg;
	dlg.Qptr = Company(COM_ID);
	sql * Select(dlg.ctrls).From(COMPANY).Where(COM_ID == dlg.Qptr);
	if(!dlg.ctrls.Fetch(sql))
		return;
	dlg.LoadCompanyAddresses();
	if(dlg.Run() != IDOK) {
		Company.CancelEdit();
		return;
	}
	sql * dlg.ctrls.Update(COMPANY).Where(COM_ID == dlg.Qptr);
	Company(COM_NAME)=~dlg.tab1.COM_Name;
	dlg.SaveCompanyAddresses();
}
void DictCompany::RemoveCompany()
{
	String p = t_("Delete company:")+String(Company(COM_NAME));
	if(PromptYesNo(p)){
		int i = (int)(Company(COM_ID));
		sql * Delete(COMPANY).Where(COM_ID == i);
	} else 
		Company.CancelRemove();

}

With this method GridCtrl himself work out almost all the logic, we can only issue a SQL command to put the data on the disk.

PS
This code works, but perhaps not the best. So I will sincerely grateful for even the smallest criticism and suggestions.

SergeyNikitin<U++>( linux, wine )
{
under( Ubuntu || Debian || Raspbian );
}

Report message to a moderator