EEP2012 WEB????

1
EEP2012WEB????

• Andy Kao

2
????(?)
?? ???? ??
????? EEP?? ?? Server(Model)?? 70
????? ???? 15
????? ??HTML?? ????? 60
???? 12001315
????? Wizard ???? ????? 70
????? ???? 15
????? ?????? ?????? 70
????? ???? 10
????? ???? 50
3
????(?)
?? ???? ??
????? ??????? ???? 70
????? ???? 15
????? Server Method?? 50
???? 12001315
????? ???? ???? 70
????? ???? 15
????? ???? WEB???? 80
????? ???? 10
????? Web???? ???? 40
4
EEP ????
5
EEP??
EEP Workflow Foundation
EEP2010 / EEP2012
VS2010 / 2012(C,VB)
ASP.NET
jQuery
WinForm
Base Class Library
CLR (Common Language Runtime )
Windows
Web
6
EEP??

• ??????/??
• ??????/??
• ??? 80/20??
• ??? ??/??
• N-Tier??/??

7
N-Tier?SOA??
8
jQuery???MVC
9
EEP jQuery??

• ?????jQuery??(v1.7??)
• ??MVC????,????
• ????? EasyUI??,??????
• ?????????????
• ??????Wizard????
• ?????C????Server Method
• ??jQuery Mobile??????
• ???EEP workflow ??

10
jQuery???????
EEP????????????
Run
????JS?HTML
11
EEP ????
12
EEP2012??

• SETUP EEP2012
• initEEP (InfoRemoteModule,Srvtools)
• OPEN Solution1.sln
• Export Template
• EEPServer.EXE
• DB Manager
• Create System Table

13
EEP????
14
HTML????
15
????
DB Server
A/P Server
IIS Server
Database
select
DataGrid
InfoCommand
dump
Insert/Update/Delete
Get Columns
Binding
UpdateComp
Infolight.js
Insert/Update/Delete
HTML
Binding
16
Server???(Model)

• ??EEP Server Wizard
• (SBASIC.DLL)
• ???? Customers , Products
• Employee , Region
• ???EEP Net Server?

17
Server???

• InfoCommand
• CommandText,CommandType
• KeyFields,SelectPaging
• SecStyle, SiteControl
• UpdateComp
• ExceptJoin, FieldAttr, ServerModify
• Insert/Delete/Modify/Apply(Before/After)

18
?HTML?? jQuery

• ????? ??JQSINGLE(??WCUSTOMERS)
• ??datagrid?infolight-options
• remoteName'SBASIC.Customers',tableName'Cu
  stomers'
• ??thead

ltth data-options"field'CustomerID',width80,edit
or'text'"gt????lt/thgt ltth data-options"field'Comp
anyName',width100,editor'text'"gt????lt/thgt ltth
data-options"field'ContactName',width80,align'
right',editor'text'"gt???lt/thgt ltth
data-options"field'ContactTitle',width80,align
'right',editor'text'"gt??lt/thgt ltth
data-options"field'Address',width250,editor'te
xt'"gt????lt/thgt ltth data-options"field'City',widt
h80,align'center',editor'text'"gt??lt/thgt ltth
data-options"field'Region',width80,align'cente
r',editor'text'"gt??lt/thgt ltth data-options"field
'LastOrderedDate',width80,editor'text'"gt????lt/th
gt

• ??EEPManager

19
?HTML????

• ??????, ?query div??lttablegt??

lttrgtlttdgt????lt/tdgt lttdgtltinput type"text"
name"id" id"txt" infolight-options"field'Custo
merID',condition'',dataType'string'"gtlt/tdgt lt/tr
gtlttrgtlttdgt????lt/tdgt lttdgtltinput type"text"
name"id" id"Text1" infolight-options"field'Com
panyName',condition'',dataType'string'"gtlt/tdgt lt
/trgtlttrgtlttdgt???lt/tdgt lttdgtltinput type"text"
name"id" id"Text2" infolight-options"field'Con
tactName',condition'',dataType'string'"gtlt/tdgt lt
/trgtlttrgtlttdgt????lt/tdgt lttdgtltinput type"text"
name"id" id"Text3" infolight-options"field'Las
tOrderedDate',condition'gt',dataType'date'"gtlt/td
gt lttdgt?lt/tdgt lttdgtltinput type"text" name"id"
id"Text4" infolight-options"field'LastOrderedDa
te',condition'lt',dataType'date'"gtlt/tdgt lt/trgt
20
editDialog (????)

• ??div dlglttablegt???

lttrgtlttdgt????lt/tdgtlttdgtltinput class"easyui-validat
ebox" type"text" width"100" infolight-options"f
ield'CustomerID',form'ff'" name"CustomerID"
data-options"requiredtrue"gtlt/inputgtlt/tdgtlt/trgt ltt
rgtlttdgt????lt/tdgtlttdgtltinput class"easyui-validateb
ox" type"text" infolight-options"field'CompanyN
ame',form'ff'" name"CompanyName"
gtlt/inputgtlt/tdgtlt/trgt lttrgtlttdgt???lt/tdgtlttdgtltinput
class"easyui-validatebox" type"text"
infolight-options"field'ContactName',form'ff'"
name"ContactName"gtlt/inputgtlt/tdgtlt/trgt lttrgtlttdgt??lt
/tdgtlttdgtltinput class"easyui-validatebox"
type"text" infolight-options"field'ContactTitle
',form'ff'" name"ContactTitle"gtlt/inputgtlt/tdgtlt/tr
gt lttrgtlttdgt??lt/tdgtlttdgtltinput class"easyui-validat
ebox" type"text" infolight-options"field'Addres
s',form'ff'" name"Address"gtlt/inputgtlt/tdgtlt/trgt ltt
rgtlttdgt??lt/tdgtlttdgtltinput class"easyui-validatebox
" type"text" infolight-options"field'City',form
'ff'" name"City"gtlt/inputgtlt/tdgtlt/trgt lttrgtlttdgt??lt
/tdgtlttdgtltinput class"easyui-validatebox"
type"text" infolight-options"field'Region',form
'ff'" name"Region"gtlt/inputgtlt/tdgtlt/trgt lttrgtlttdgt??
??lt/tdgtlttdgtltinput class"easyui-validatebox"
type"text" infolight-options"field'LastOrderedD
ate',form'ff'" name"LastOrderedDate"gtlt/inputgtlt/t
dgtlt/trgt
21
???????

• ??dlg?infolight-options
• remoteName'SBASIC.Customers',tableName'Cu
  stomers'
• displaynormal
• (Dialog??)??datagrid?infolight-options??
• editDialog'dlg' ,editMode'Dialog'
• (Expand??)
• editDialog'dlg' ,editMode'Expand'
• (Continue??)
• editDialog'dlg' ,editMode 'Continue'
• class"easyui-dialog"??
• (Switch??)
• editDialog'dlg' ,editMode'Switch'
• ?? displaynone

22
???????

• ??dlg?easyui-validatebox infolight-options?
• ????
• defaultValue'??????'
• ????
• defaultValue'remote_today
• ??dlg?easyui-validatebox? data-options?
• ????
• data-options"requiredtrue"
• ???
• data-options"requiredtrue"

23
Wizard????
24
Wizard?????

• ??EEP jQuery Wizard
• ?? jQuerySingle1??????(WPRODUCT)

25
????

• DataGrid???Query??
• ??QueryAutoColumn??

26
Wizard?????

• ??EEP jQuery Wizard
• ?? jQuerySingle2??????(WEMPLOYEE)

27
?????
28
Default????
ltscriptgt function getaddress()
return '???' lt/scriptgt

• ?? JQDefault??
• ???(HireDate) _TODAY
• ??(Country) ????
• ??(Address) DefaultMethodgetaddress (Client)

29
JS?Debug

• ?IE?, ??ltF12gt
• ???????????
• ?????, ??????

30
Validate????
public bool validatecity(string value)
string str value.Substring(0,3) if
(str "???" value "???") return true
else return false function
CheckPostal(value) if (value0 gt '0'
value0 lt '9') return true
else return false

• ?? JQValidate??
• ???? (EmployeeID) CheckNullTrue
• ???? (LastName) CheckNullTrue
• ??(City) CheckNullTrue,
• RangeFrom A, RangeTo Z
• ??(Address) CheckNullTrue,
• CallMethodvalidatecity (Remote)
• ????(PostalCode) CheckNullTrue,
• CallMethodCheckPostal (Client)
• ????,?dataForm??
• duplicateChecktrue

31
Remote?Debug

• ?IE??WebDevServer?Port No.
• ?VS????/?????
• ?? WebDev.WebServer?ASP.NET??
• ?????, ??Debug???

32
Dialog??
Switch??
Expand??
Continue??
33
??????
34
??????
DB Server
A/P Server
IIS Server
Database
select
Master InfoCommand
dump
Insert/Update/Delete
InfoDataSource
Infolight.js
UpdateComp
Insert/Update/ Delete
Insert/Update/Delete
Binding
Detail InfoCommand
Relation
UpdateComp
Master DataGrid
Detail DataGrid
35
Server?????(Model)

• ??EEP Server Wizard (SORDERS.DLL)
• UpdateComp?ServerModifyGetMaxTrue
• SORDER???EEP Net Server?

36
Wizard????

• ??EEP jQuery Wizard
• ?? jQueryMasterDetail1??????(WORDERS)

37
???????

• ??datagrid??Columns
• ?infoCombobox???????,??EditorOptions
  RemoteName,ValueMember, DisplayMember

38
??????
39
???Control Type

• TextBox
• ValidateBox
• NumberBox
• CheckBox
• DateBox
• PassWord
• ComboBox
• ComboGrid
• RefVal
• FileUpload

40
CheckBox??

• Editor???CheckBox (WPRODUCT)
• EditorOptions??on1,off0
• ???? Bit(True/False), int(1/0), Char (Y/N)
• ???? Format L,?,?

41
DateBox??
if (.fn.datebox) .fn.datebox.defaults.formatt
er function (date) var y
date.getFullYear() var m date.getMonth()
1 var d date.getDate() return y '.'
(m lt 10 ? ('0' m) m) '.' (d lt
10 ? ('0' d) d)

• Editor???DateBox (WORDERS)
• ???? DateTime, Date, Varchar(8), Varchar(10)
• ???? Format yyyy.mm.dd, mm/dd/yyyy, YYY.mm.dd
• DateBox???? js\local\easyui-lang-zh_TW.js?

42
Combox??

• Editor???CheckBox (WEMPLOYEE/??)
• ??Items??(???)
• ??EditorOptions RemoteName,ValueMember,
• DisplayMember

43
Refval??

• ??dataform??Columns (WORDERS)
• ?infoRefVal???????

44
ColumnMatch??

• Refval??EditOptions
• ??ColumnMatch

45
ComboGrid??

• ??dataform??Columns (WORDERS)
• ?infoComboGrid???????

46
Image???

• Columns Editor???infoFileUpload (WEMPLOYEE)
• ??Filterjpgpng?UploadFolderFolderFiles/Photos

47
Image???

• ??Format?Image,FolderFiles/Photos,Height60
• ??JQImageContainer
• ??Height,Width,AutoSize

48
????
49
????

• ??EEP jQuery Wizard
• ?? jQueryQuery1????(WORDERQRY)
• ??NewLine?DefaultValue

50
???????

• Total??(sum/count/max/min/average)
• Format N2(????,)
• Frozen True (????)
• Sortable True(??)

51
Excel ??

• datagrid?ToolItems???Icon
• ?? Icon?icon-excel
• OnClick?exportGrid

52
Format??

• ?? yyyy mm dd YYY . - /
• (yyyy.mm.dd mm/dd/yyyy)
• ?? Nn Cn (C2, N3)
• ?? L,x1,x2 (L,?,?)
• ?? ?? X O (?OO???)
• ?? Image, File,
• (Image,FolderFiles,Height60)

53
FormatScript???

• ?? dataGrid?Columns.FormatScript?colorValue
• ????colorValue?JS??
• ltscript type"text/javascript"gt
• function colorValue(val, row)
• if (val gt 100)
• return "ltdiv style\"colorRed\"gt"
  val "lt/divgt"
• return val
• lt/scriptgt

54
???????
55
Identity??

• Server?InfoCommand??ServerModifyGetMaxTrue
• (SORDERS)
• DataForm?ShowApplyButtonTrue (WORDERS)

56
Detail?AutoSeq

• ??JQAutoSeq (WORDERS)
• ??BindingObjectID?dataGridDetail
• ??FieldName?Owner,NumDig?3

57
AutoNumber??

• EEP Server Wizard (SPURCHASE.DLL)
• ??AutoNumber, ??AutoID, UpdateComp, TargetColumn,
  GetFixed, NumDig, StartValue, Step
• EEP jQuery Wizard, Master/Details (WPURCHASE)

58
Transaction??
59
Transaction??
DB Server
Database
select
A/P Server
InfoCommand
Insert/Delete/Update
Active
UpdateComp
Update (inc/dec/replace)
Trans Mode AutoAppend Exception Ignore AlwaysAppe
nd
Apply
Client
InfoDataSet
60
Transaction???
Orders
DB Server
A/P Server
select
Customers
Insert/Delete/Update
Master InfoCommand
Inc OrderedAmout Replace LastOrderedDate
Client
Order Details
Master UpdateComp
Active
select
Detail InfoCommand
Apply
Insert/Delete/Update
Products
Inc UnitsOnOrder Replace LastOrderedPrice
Master CDS
Detail UpdateComp
Apply
Detail CDS
61
Transaction??

• Orders Transaction Customers
• OrderDate Replace LastOrderedDate
• Order Details Transaction Products
• UnitPrice Replace LastUnitPrice
• Quantity Inc UnitsOnOrder

62
Server Method ??
63
Server Method??
DB Server
A/P Server
iiS Server
Call
Database
ServiceManager
select
Aspx Code
Server Method1 Server Method2 Server
Method3 Server Method4 ..
Update
Remote Call
Browser
InfoCommand
JS Call
64
Server Method??

• ??Server Method (SORDERS)
• public object CallTest(object objParam)
• string str objParam0.ToString()
• string sql "select avg(UnitPrice) as
  AvgPrice from Order Details Where ProductID"
• sql sql str
• DataSet Tmp ExecuteSql("View_Orders"
  , sql, "ERPS", true)
• string retvalTmp.Tables0.Rows0"A
  vgPrice".ToString()
• object ret
• ret new object 0, retval
• return ret
• ??ServiceManager
• ?? ServiceName(????) , DelegateName(????)

65
Client????

• ??HTML Button (WORDERS)
• ltinput id"Button1" type"button" value"Call
  Method" onclick"serverMethod()"/gt
• DataGrid???ToolItems
• ????Icon, OnClick"serverMethod" Text"Average
  Price"

66
Client????

• Client script
• ltscriptgt
• function serverMethod()
• var row ('dataGridDetail').datagri
  d('getSelected')
• .ajax(
• type "POST",
• url '../handler/jqDataHandle.ashx
  ?RemoteNameSORDERS.Orders',
• data "modemethodmethod"
  "CallTest" "parameters" row.ProductID,
• cache false, async true,
• success function (data)
• alert(data)
• )
• lt/scriptgt

67
Server?Debug

• ?VS????/?????
• ?? EEP NetServer.EXE??
• ?????, ??Debug???

68
????
69
????

• Login (Users/AD)
• Menus (By Users/Groups)
• JQSecurity
• JQSecurityColumn
• InfoCommand.SecStyle
• ????

70
JQSecurity??

• ??JQSecurity (WORDERS)
• ??Alias, MenuID
• ??Export, Add All ????
• ?EEPManager???
• (???, ?????????/??)

71
JQSecurityColumn??

• ??JQSecurityColumn (WORDERS)
• ??BindingObjectID,Columns (Master/Detail????,
  ??Ship?????)
• ????JQSecurity, ???Export
• ?EEPManager???
• (???, ???????)

72
Row????

• ??Server? InfoCommand.SecStyle
• (SBASIC.Customers)
• SecStyle User,Group,Role,Org,OrgShare
• ??SecFieldName (ServiceRole)
• ?Build Server?DLL

73
??????
ltscriptgt function CheckOrderStatus(rowData)
if (rowData.OrderStatus 'Y'
rowData.OrderStatus '')
return false return
true lt/scriptgt
74
????
75
??????

• ??JQMultiLanguage (WEMPLOYEE)
• ??Active,Alias,GroupIndex
• ??Edit, ???????XML?
• (?????XML?DB??)
• ??Button, Click?
• protected void Button1_Click(object sender,
  EventArgs e)
• JQMultiLanguage1.GroupIndex
  JQClientTools.LanguageGroups.English
• JQMultiLanguage1.SetLanguage(false)
• JQScriptManager1.Locale "en"

76
????
77
????

• ????????????
• (document).ready(function ()
• ("dataFormMaster").form(
• onLoadSuccess function ()
• var obj ("comboname'Count
  ry'.info-combobox", "dataFormMaster")
• var val obj.combobox('getVal
  ue')
• obj ("comboname'City'.in
  fo-combogrid", "dataFormMaster")
• obj.combogrid('setWhere',
  "Country '" val "'")
• )
• )

• WEMPLOYEE???(Combo)????(ComboGrid)
• ??Combo??OnSelect??FilterCountry
• function FilterCountry(val)
• var obj ("comboname'City'.info-c
  ombogrid", "dataFormMaster")
• obj.combogrid('setWhere', "Country
  '" val.Country "'")

78
?????

• ?? easyui-tabs ??? (WORDERS)
• ltdiv id"Div1" class"easyui-tabs" style"width
  700px height 360px"gt
• ltdiv style"padding 20px "
  title"????"gtTab1lt/divgt
• ltdiv style"overflow auto padding 20px "
  title"????"gtTab2lt/divgt
• lt/divgt
• ??DataGrid?DataForm

79
??DataForm

• ?? JQDialog (WORDERS)
• ?? DataGrid(Details)?EditDailogID
• ?? JQDataForm
• ?? JQDataForm?RemoteName,TableName
• ?? Refresh Schema
• ?? Columns (??ProductID?Refval)
• ?? ParentObjectID,RelationColumns
• ?? JQDailog?BindingObjectID,EditMode

80
??Web ASP .Net??
81
WEB????

• ??EEPWebClient??
• EEP Web Client Wizard (WSingle3) (WCUSTOMERS2)
• ??UpdatePanel???
• ??EEPManager

82
?jQuery??WEB??

• ??EEPWebClient??Web.Config/ ltsystem.webgt
• ltwebServicesgt
• ltprotocolsgt
• ltadd name"HttpGet"/gt
• ltadd name"HttpPost"/gt
• lt/protocolsgt
• lt/webServicesgt
• ??JQWebClient??Web.Config/ ltappSettingsgt
• ltappSettingsgt
• ltadd key"EEPWebClient" value"http//localh
  ost1552/EEPWebClient"/gt
• lt/appSettingsgt
• ??InitEEP?WebClient Directory ???

83
WEB ????
84
Web ????

• ?? IIS 7.0?ASP.NET 4.0
• IIS???????
• C\Windows\Microsoft.NET\Framework\v4.0.3031
  9gt aspnet_regiis -i
• ???????? (? C\EEPTEST)
• ??IIS????????ASP.NET???
• ??IIS?ISAPI?CGI?ASP.NET 4.0?????
• ??????????, ????????
• ?VS???Publish WebSite
• ????InitEEP?WebClient Directory

85
????
86
?????

• ??Wizard Create Solution
• ??Solution Name,?? JQuery

87
Q A