Как-то так
малость под себя допилил
Add(ChildForm,12807136,532,91)
{
}
BEGIN_SDK
Add(EditMulti,2252790,21,21)
{
WorkCount=1
DataCount=1
Width=678
Height=333
link(doWork1,10120050:doShowModal,[(28,27)(28,146)])
}
Add(MainForm,10120050,84,112)
{
Left=35
Top=105
Width=964
Height=647
Visible=1
Point(doShowModal)
link(onActivate,9796773:doWork3,[(184,118)(184,153)])
}
Add(ChildGroupBox,16596836,651,28)
{
}
BEGIN_SDK
Add(EditMulti,12324586,21,21)
{
WorkCount=3
DataCount=1
Width=720
Height=620
link(doWork1,2822035:doBringToFront,[])
link(doWork2,2822035:doSendToBack,[])
link(doWork3,8056583:doEvent1,[(81,41)(81,83)])
}
Add(GroupBox,2822035,147,21)
{
Width=956
Height=613
Align=5
Caption="На печать."
Point(doBringToFront)
Point(doSendToBack)
}
Add(Button,7347469,63,133)
{
Left=5
Top=20
Width=90
Caption="Отобразить"
}
Add(DoData,682558,210,84)
{
Data=String(<html><head></head><body><h3 align="center" style="color:Tomato">Домашняя бухгалтерия. РАСХОДЫ.</h3><table align="center" border="1" width="60%"><tr><td>Наименование расходов</td><td> Сумма1 </td><td> Сумма2 </td><td> Сумма3 </td><td> Сумма4 </td><td> Сумма5 </td><td> Сумма6 </td><td> Сумма7 </td></tr>)
link(onEventData,4584918:doWork1,[(473,90)])
}
Add(DoData,5200042,322,273)
{
Data=String(</table></body></html>)
link(onEventData,13862976:doWork2,[])
}
Add(Hub,8056583,140,77)
{
OutCount=8
link(onEvent1,7247405:doClear,[(482,83)(482,223)])
link(onEvent2,682558:doData,[])
link(onEvent3,3517164:doEnum,[(177,97)(177,216)])
link(onEvent4,14204559:doWork2,[(175,104)(175,258)])
link(onEvent5,6248942:doEvent1,[(167,111)(167,300)])
link(onEvent7,9199990:doClear,[(259,125)(259,405)])
link(onEvent8,5463605:doClear,[(217,132)(217,454)])
}
Add(StrList,7247405,525,210)
{
}
Add(HubEx,14204559,469,252)
{
link(onEvent,16251860:doEvent1,[(490,258)(490,125)])
}
Add(DoData,3641262,511,294)
{
link(onEventData,13482478:doMask,[])
link(Data,7247405:Text,[(517,274)(531,274)])
}
Add(WebBrowser,14981452,693,259)
{
Left=120
Top=15
Width=605
Height=510
Point(doFromText)
Point(doPreview)
}
Add(Button,5676408,658,343)
{
Left=5
Top=50
Width=90
Caption="Печать"
link(onClick,14981452:doPreview,[(692,349)(692,300)])
}
Add(ArrayEnum,3517164,217,210)
{
@Hint=#20:Подключаешь к своей |21:таблице к точке Array|
link(onItem,12801865:doSplit,[(268,216)(268,195)])
link(onEndEnum,10171220:doEvent1,[(257,223)(257,307)])
link(Array,12324586:Data1,[(223,105)(27,105)])
AddHint(30,-58,131,26,@Hint)
}
Add(FormatStr,3358128,406,210)
{
DataCount=8
Mask="<tr><td> %1 </td><td> %2 </td><td> %3 </td><td> %4 </td><td> %5 </td><td> %6 </td><td> %7 </td><td> %8 </td></tr>"
link(onFString,4584918:doWork2,[(467,216)(467,195)])
link(Str1,12801865:Part1,[(412,184)(328,184)(328,266)(279,266)])
link(Str2,12801865:Part3,[(419,184)(352,184)(352,254)(293,254)])
link(Str3,12801865:Part4,[(426,184)(359,184)(359,254)(300,254)])
link(Str4,12801865:Part5,[(433,184)(366,184)(366,254)(307,254)])
link(Str5,12801865:Part6,[(440,184)(373,184)(373,254)(314,254)])
link(Str6,12900287:Var3,[(447,198)(384,198)(384,233)])
link(Str7,8431962:Var2,[(454,184)(387,184)(387,254)(328,254)])
link(Str8,12801865:Part13,[(461,184)(408,184)(408,254)(363,254)])
}
Add(HubEx,4584918,469,189)
{
Angle=1
link(onEvent,14204559:doWork1,[])
}
Add(FormatStr,13482478,595,287)
{
DataCount=5
Mask=""
Point(doMask)
link(onFString,14981452:doFromText,[])
}
Add(Hub,6248942,448,294)
{
link(onEvent1,3641262:doData,[])
link(onEvent2,13482478:doString,[(476,307)(476,293)])
}
Add(MultiStrPart,12801865,273,189)
{
Char="\9"
Count=13
link(onSplit,5393464:doEvent1,[])
}
Add(Memo,13642479,609,105)
{
Left=15
Top=525
Width=925
}
Add(Hub,16251860,539,119)
{
link(onEvent1,13642479:doAdd,[(581,125)(581,111)])
link(onEvent2,7247405:doAdd,[(565,132)(565,174)(513,174)(513,216)])
}
Add(StrList,9199990,364,392)
{
link(Str,8431962:Var3,[(370,236)])
}
Add(ArraySum,4914408,378,455)
{
ArrayType=1
Delimiter="\9"
link(Array,9199990:Array,[])
}
Add(FormatStr,157244,434,546)
{
DataCount=8
Mask="<tr><td><b> Итого: </b></td><td> +++</td><td> +++ </td><td> ++++ </td><td> +++++</td><td> %6 </td><td> %7 </td><td> ++++++++ </td></tr>"
link(onFString,13862976:doWork3,[(519,552)(519,371)(466,371)])
link(Str6,2030785:Sum,[(475,534)(307,534)])
link(Str7,4914408:Sum,[(482,516)(384,516)])
}
Add(Hub,5393464,378,189)
{
OutCount=3
link(onEvent1,3358128:doString,[(399,195)(399,216)])
link(onEvent2,9199990:doAdd,[(404,202)(404,300)(352,300)(352,398)])
link(onEvent3,5463605:doAdd,[(404,209)(404,328)(268,328)(268,447)])
}
Add(Hub,10171220,266,301)
{
OutCount=3
link(onEvent1,5200042:doData,[(301,307)(301,279)])
link(onEvent2,4914408:doSum,[(329,314)(329,461)])
link(onEvent3,2030785:doSum,[(292,321)(292,415)(268,415)(268,510)])
}
Add(HubEx,13862976,462,273)
{
link(onEvent,14204559:doWork3,[(473,278)])
}
Add(GetDataEx,8431962,322,231)
{
link(Data,12801865:Part8,[])
}
Add(ArraySum,2030785,301,504)
{
ArrayType=1
Delimiter="\9"
link(onSum,157244:doString,[(383,510)(383,552)])
link(Array,5463605:Array,[])
}
Add(StrList,5463605,287,441)
{
link(Str,12900287:Var2,[(293,339)(377,339)])
}
Add(GetDataEx,12900287,371,228)
{
Angle=3
link(Data,12801865:Part7,[(321,233)])
}
END_SDK
Add(ChildGroupBox,9796773,252,133)
{
link(Data1,2252790:Data1,[(258,98)(27,98)])
}
BEGIN_SDK
Add(EditMulti,15694451,21,21)
{
WorkCount=3
DataCount=1
Width=720
Height=620
link(doWork1,8738447:doBringToFront,[])
link(doWork2,8738447:doSendToBack,[])
link(doWork3,15181694:doEvent1,[(81,41)(81,83)])
}
Add(GroupBox,8738447,147,21)
{
Width=956
Height=613
Align=5
Caption=""
Point(doBringToFront)
Point(doSendToBack)
}
Add(DoData,10659148,245,84)
{
Data=String()
link(onEventData,12313307:doWork1,[(473,90)])
link(Data,82158:Text,[])
}
Add(DoData,6550412,322,273)
{
Data=String(</table></body></html>)
link(onEventData,1875310:doWork2,[])
}
Add(Hub,15181694,140,77)
{
OutCount=8
link(onEvent1,14211770:doClear,[(482,83)(482,223)])
link(onEvent2,10659148:doData,[])
link(onEvent3,11882783:doEnum,[(177,97)(177,216)])
link(onEvent4,546942:doWork2,[(175,104)(175,258)])
link(onEvent5,12350044:doEvent1,[(167,111)(167,300)])
link(onEvent7,16390816:doClear,[(259,125)(259,405)])
link(onEvent8,4434477:doClear,[(217,132)(217,454)])
}
Add(StrList,14211770,525,210)
{
}
Add(HubEx,546942,469,252)
{
link(onEvent,14211770:doAdd,[(490,258)(490,125)(565,132)(565,174)(513,174)(513,216)])
}
Add(DoData,11899190,511,294)
{
link(onEventData,4515053:doMask,[])
link(Data,14211770:Text,[(517,274)(531,274)])
}
Add(WebBrowser,16257086,693,259)
{
Left=79
Top=15
Width=875
Height=596
Align=5
Point(doFromText)
Point(doPreview)
}
Add(ArrayEnum,11882783,217,210)
{
@Hint=#20:Подключаешь к своей |21:таблице к точке Array|
link(onItem,4003050:doSplit,[(268,216)(268,195)])
link(onEndEnum,9736086:doEvent1,[(257,223)(257,307)])
link(Array,15694451:Data1,[(223,105)(27,105)])
AddHint(30,-58,131,26,@Hint)
}
Add(FormatStr,11724555,406,210)
{
DataCount=8
Mask="<tr><td> %1 </td><td> %2 </td><td> %3 </td><td> %4 </td><td> %5 </td><td> %6 </td><td> %7 </td><td> %8 </td></tr>"
link(onFString,12313307:doWork2,[(467,216)(467,195)])
link(Str1,4003050:Part1,[(412,184)(328,184)(328,266)(279,266)])
link(Str2,4003050:Part3,[(419,184)(352,184)(352,254)(293,254)])
link(Str3,4003050:Part4,[(426,184)(359,184)(359,254)(300,254)])
link(Str4,4003050:Part5,[(433,184)(366,184)(366,254)(307,254)])
link(Str5,4003050:Part6,[(440,184)(373,184)(373,254)(314,254)])
link(Str6,5173517:Var3,[(447,198)(384,198)(384,233)])
link(Str7,9447706:Var2,[(454,184)(387,184)(387,254)(328,254)])
link(Str8,4003050:Part13,[(461,184)(408,184)(408,254)(363,254)])
}
Add(HubEx,12313307,469,189)
{
Angle=1
link(onEvent,546942:doWork1,[])
}
Add(FormatStr,4515053,595,287)
{
DataCount=5
Mask=""
Point(doMask)
link(onFString,16257086:doFromText,[])
}
Add(Hub,12350044,448,294)
{
link(onEvent1,11899190:doData,[])
link(onEvent2,4515053:doString,[(476,307)(476,293)])
}
Add(MultiStrPart,4003050,273,189)
{
Char="\9"
Count=13
link(onSplit,7317657:doEvent1,[])
}
Add(StrList,16390816,364,392)
{
link(Str,9447706:Var3,[(370,236)])
}
Add(ArraySum,11641580,378,455)
{
ArrayType=1
Delimiter="\9"
link(Array,16390816:Array,[])
}
Add(FormatStr,5835805,434,546)
{
DataCount=8
Mask="<tr><td><b> Итого: </b></td><td><center>------</center></td><td><center>------</center></td><td><center>------</center></td><td><center>------</center></td><td><b><center> %6 </center></b></td><td><b><center> %7 </center></b></td><td><center>------</center></td></tr>"
link(onFString,12176136:doEvent1,[(502,552)(502,461)])
link(Str6,12456890:Sum,[(475,534)(307,534)])
link(Str7,11641580:Sum,[(482,516)(384,516)])
}
Add(Hub,7317657,378,189)
{
OutCount=3
link(onEvent1,11724555:doString,[(399,195)(399,216)])
link(onEvent2,16390816:doAdd,[(404,202)(404,300)(352,300)(352,398)])
link(onEvent3,4434477:doAdd,[(404,209)(404,328)(268,328)(268,447)])
}
Add(Hub,9736086,266,301)
{
OutCount=3
link(onEvent2,11641580:doSum,[(329,314)(329,461)])
link(onEvent3,12456890:doSum,[(292,321)(292,415)(268,415)(268,510)])
}
Add(HubEx,1875310,462,273)
{
link(onEvent,546942:doWork3,[(473,278)])
}
Add(GetDataEx,9447706,322,231)
{
link(Data,4003050:Part8,[])
}
Add(ArraySum,12456890,301,504)
{
ArrayType=1
Delimiter="\9"
link(onSum,5835805:doString,[(383,510)(383,552)])
link(Array,4434477:Array,[])
}
Add(StrList,4434477,287,441)
{
link(Str,5173517:Var2,[(293,339)(377,339)])
}
Add(GetDataEx,5173517,371,228)
{
Angle=3
link(Data,4003050:Part7,[(321,233)])
}
Add(Hub,12176136,511,455)
{
link(onEvent1,1875310:doWork3,[(537,461)(537,371)(466,371)])
link(onEvent2,6550412:doData,[(537,468)(537,374)(310,374)(310,279)])
}
Add(ChildPanel,630608,63,364)
{
link(onEvent1,7844811:In,[])
}
BEGIN_SDK
Add(EditMulti,3907775,21,21)
{
EventCount=1
}
Add(Panel,5757991,35,105)
{
Left=2
Top=15
Width=77
Height=596
Align=1
BorderWidth=0
BevelWidth=0
}
Add(Button,13894097,63,21)
{
Left=5
Top=5
Width=60
Height=30
Caption="Печать"
link(onClick,3907775:onEvent1,[])
}
END_SDK
Add(LineBreak,13394926,651,301)
{
link(Out,16257086:doPreview,[(687,307)(687,300)])
Primary=[7844811,-546,63]
}
Add(StrList,82158,245,28)
{
Strings=#12:<html><head>|23:<style type="text/css">|9: BODY {|22: background: white;|4: }|10: TABLE {|32: border-collapse: collapse;|7: }|11: TD, TR {|17: padding: 1px;|26: text-align: center;|4: }|23: </style></head><body>|71:<h3 align="center" style="color:Tomato">Отчет о проделанной работе</h3>|45:<table align="center" border="1" width="60%">|4:<tr>|16:<td><b>Дата</td>|19:<td><b>Клиент </td>|22:<td><b>Сотрудник </td>|19:<td><b>Услуга </td>|19:<td><b>Модель </td>|22:<td><b>Стоимость </td>|27:<td><b>Вознаграждение </td>|21:<td><b>Штрихкод </td>|5:</tr>|
}
END_SDK
END_SDK
Add(Button,14880709,243,168)
{
Left=80
Top=5
Caption="К печати"
link(onClick,12807136:doWork1,[(470,174)(470,97)])
}
--- Добавлено в 2017-04-28 15:56:42
А можно HTML создавать и "напрямую" запросом к таблице в БД
а вот это кстати интересно!
Поиск
Друзья
Администрация