untitled

Transcription

1 A Leader of Enterprise e-business Solution API... 3 Class Cache... 5 Class ConnectionPool... 9 Class DataBind Class Log Class Module Class Monitor Class Repository User Data Store for.net UDS for.net UDS for.net UDS for.net FORCS Co., LTD 1

2 OZ API Developer's Guide (for.net) 2 FORCS Co., LTD

3 A Leader of Enterprise e-business Solution API Class Cache Class ConnectionPool Class DataBind Class Log Class Module Class Monitor Class Repository FORCS Co., LTD 3

4 OZ API Developer's Guide (for.net) API. API. Cache Connection Pool DataBind Log Module Monitor Repository.. Pool ADO.NET/ODBC,..,,.... API. OZServer.NET.dll SAP.Connector.dll Interop.MSScriptContr ol.dll. SAP. Jscript COM. 4 FORCS Co., LTD

5 A Leader of Enterprise e-business Solution Constructor Summary Cache(string url, string id, string pw, boolean autologin, boolean useusl) Method Summary OZAttributeList GetConfiguration() void SetConfiguration(OZAttributeList attrs) Constructor Detail ASP.NET public Cache(string url, string id, string pw, bool autologin, bool useusl) url id pw autologin useusl URL ex) string url = " ex) string id = "admin"; ex) string pw = "admin"; ex) boolean autologin = true; USL ex) boolean useusl = false; Method Detail getcacheconfigration FORCS Co., LTD 5

6 OZ API Developer's Guide (for.net) public OZAttributeList GetCacheConfigration () throws.,,,, setcacheconfiguration public void SetCacheConfiguration (OZAttributeList attrs) throws. ' ', ' ',, ' ', ' ' attrs Class (oz.framework.cp.) API Exception. API. - getmessage public String getmessage(). OZAttributeList (oz.util.ozattributelist.cs) of GetCacheConfigration, SetCacheConfiguration getcacheconfigration(), setcacheconfiguration(). - This[string key] {get; set; This[string key] {get; set; key. Key 6 FORCS Co., LTD

7 A Leader of Enterprise e-business Solution Property key. Key Value Active CACHE_FILE _PATH DM_CACHE_ FILE_PATH memorycach evalidtime diskcacheval idtime FreeMemory Percentage "true" "false" (string) (string) (Unit second) (Unit second) (%) ex) p["datamodule.active"] = "false"; ex) p["cache_file_path"] = "%OZ_HOME%/cache"; Data Module ex) p["dm_cache_file_path"] = "%OZ_HOME%/cache_dm/"; (:) ex) p["datamodule.memorycachevalidtime"] = "100"; (:) ex) p["datamodule.diskcachevalidtime"] = "100"; ex) p["datamodule.freememorypercentage"] = "20"; : ". -cachemngr.properties". Sample : CacheSample.java using System; using oz.framework.api; namespace sample{ /// <summary> /// Cache /// </summary> public class CacheTest{ public static void Main(){ string url = " string id = "admin"; string password = "admin"; Cache c = new Cache(url, id, password, true, true); oz.util.ozattributelist attrs = c.getconfiguration(); FORCS Co., LTD 7

8 OZ API Developer's Guide (for.net) Console.WriteLine(attrs); c.setconfiguration(attrs); 8 FORCS Co., LTD

9 A Leader of Enterprise e-business Solution Constructor Summary ConnectionPool(string url, string id, string pw, boolean autologin, boolean useusl) Method Summary void AddPool(ConnectionPoolInfo pool) void RemovePool(string alias) ConnectionPoolInfo[] GetPoolInfos() ConnectionPoolStatus[] GetPoolStatuses() ConnectionPoolInfo GetPoolInfo(string alias) void Save() Constructor Detail ASP.NET public ConnectionPool(string url, string id, string pw, boolean autologin, boolean useusl) url id pw autologin useusl URL ex) string url = " ex) string id = "admin"; ex) string pw = "admin"; ex) boolean autologin = true; USL ex) boolean useusl = false; FORCS Co., LTD 9

10 OZ API Developer's Guide (for.net) Method Detail AddPool public void AddPool(ConnectionPoolInfo pool) throws.,,,,, SID, DB, DB,,,,,, URL,, pool ConnectionPoolInfo RemovePool public void RemovePool(string alias) throws ConnectionPool. alias ConnectionPool GetPoolInfos public ConnectionPoolInfo[] GetPoolInfos() throws ConnectionPool. GetPoolStatuses public ConnectionPooStatus[] GetPoolStatuses() throws ConnectionPool. GetPoolInfo public ConnectionPoolInfo GetPoolInfo(String alias) throws ConnectionPool ConnectionPoolInfo. alias ConnectionPool Save public void Save() throws throws 10 FORCS Co., LTD

11 A Leader of Enterprise e-business Solution ConnectionPool. Class ConnectionPoolInfo(oz.framework.db.ConnectionPoolInfo). ConnectionPoolStatus(oz.framework.db.ConnectionPoolStatus) ConnectionPool. - ConnectionPool.. Status OK DRIVER_ERROR CONNECTION_ ERROT ConnectionPool ConnectionPool JDBC ConnectionPool DBMS Sample : ConnectionSample.java using System; using oz.framework.api; using oz.framework.db; namespace sample{ /// <summary> /// ConnectionPoolTest /// </summary> public class ConnectionPoolTest{ public static void Main(){ string url = " string id = "admin"; string password = "admin"; ConnectionPool cp = new ConnectionPool(url, id, password, true, true); FORCS Co., LTD 11

12 OZ API Developer's Guide (for.net) string alias = "connection_pool_test"; ConnectionPoolInfo poolinfo = new ConnectionPoolInfo(); poolinfo.alias = alias; poolinfo.vendor = "MSSQL"; poolinfo.serveraddress = " "; poolinfo.port = 1433; poolinfo.dbname = "OZDB"; poolinfo.user = "admin"; poolinfo.password = "admin"; poolinfo.maxconnections = 20; poolinfo.initialconnections = 5; poolinfo.timeout = 5; cp.addpool(poolinfo); ConnectionPoolInfo addedpoolinfo = cp.getpoolinfo(alias); Console.WriteLine(addedPoolInfo); cp.removepool(alias); ConnectionPoolInfo[] poolinfos = cp.getpoolinfos(); foreach(connectionpoolinfo cpi in poolinfos){ Console.WriteLine(cpi); ConnectionPoolStatus[] statuses = cp.getpoolstatuses(); foreach(connectionpoolstatus status in statuses){ Console.WriteLine(status); 12 FORCS Co., LTD

13 A Leader of Enterprise e-business Solution Constructor Summary DataBind(string url, string id, string pw, boolean autologin, boolean useusl) Method Summary void SetConfigration(OZAttributeList config) OZAttributeList GetConfigration() Constructor Detail ASP.NET public DataBind(string url, string id, string pw, boolean autologin, boolean useusl) url id pw autologin useusl URL ex) string url = " ex) string id = "admin"; ex) string pw = "admin"; ex) boolean autologin = true; USL ex) boolean useusl = false; Method Detail SetConfigration FORCS Co., LTD 13

14 OZ API Developer's Guide (for.net) public void SetConfigration(OZAttributeList config) throws DataBind, "databind.properties". config DataBind GetConfigration public OZAttributeList GetConfigration() throws DataBind, "databind.properties". - Key SetConfigration() GetConfigration() key. Key Value ConcurrentFetch Size ConcurrentFirstR ow FetchType "Concurrent" Stream. byte, 4096, 256. :,. FetchType "Concurrent"., 0. : 0. Sample : DataBindSample.java using System; using oz.util; using oz.framework.api; 14 FORCS Co., LTD

15 A Leader of Enterprise e-business Solution namespace sample{ /// <summary> /// DataBindTest /// </summary> public class DataBindTest{ public static void Main(){ string url = " string id = "admin"; string password = "admin"; DataBind db = new DataBind(url, id, password, true, true); OZAttributeList attrs = db.getconfiguration(); foreach(ozattribute attr in attrs){ Console.WriteLine(attr); db.setconfiguration(attrs); FORCS Co., LTD 15

16 OZ API Developer's Guide (for.net) Constructor Summary Log(string url, string id, string pw, boolean autologin, boolean useusl) Method Summary string GetConfiguration () Stream DownloadLog () Stream DownloadLog(string filename) void SetConfiguration (string config) string[] GetFileNames() Constructor Detail ASP.NET public Log(string url, string id, string pw, boolean autologin, boolean useusl) url id pw autologin useusl URL ex) string url = " ex) string id = "admin"; ex) string pw = "admin"; ex) boolean autologin = true; USL ex) boolean useusl = false; Method Detail 16 FORCS Co., LTD

17 A Leader of Enterprise e-business Solution GetConfiguration public string GetConfiguration() throws. DownloadLog public stream DownloadLog() throws. DownloadLog public stream DownloadLog(string filename) throws. filename SetConfiguration public void SetConfiguration(string logs) throws. logs, "key=value" ex) string logs="priority=debug" ex) string logs="console.layout=%r[%t]%p%c{1%x-%m%n GetFileNames public string[] GetFileNames() throws. Sample : LogSample.java using System; using System.IO; using oz.framework.api; namespace sample{ /// <summary> /// LogTest FORCS Co., LTD 17

18 OZ API Developer's Guide (for.net) /// </summary> public class LogTest{ public static void Main(){ string url = " string id = "admin"; string password = "admin"; Log log = new Log(url, id, password, true, true); string config = log.getconfiguration(); Console.WriteLine(config); string[] logs = log.getfilenames(); foreach(string s in logs){ Console.WriteLine(s); Stream logfile = log.downloadlog(); 18 FORCS Co., LTD

19 A Leader of Enterprise e-business Solution Constructor Summary Module(string url, string id, string pw, boolean autologin, boolean useusl) Method Summary Stream GetOZD(string item, string category, string[] urls) stream GetOZU(string item, string category, string[] urls) void AddODIParameter(string odiname, string key, string value) void AddODIParameter(string odiname, string item, string category,, IDictionary parameters) void AddParameter(string key, string value) void AddApplicationParameter(string key, string value) void SaveOZD(string filename, string item, string category, string[] urls) void SaveOZU(string filename, string item, string category, string[] urls) Constructor Detail ASP.NET public Module(string url, string id, string pw, boolean autologin, boolean useusl) url id pw autologin URL ex) string url = " ex) string id = "admin"; ex) string pw = "admin"; ex) boolean autologin = true; FORCS Co., LTD 19

20 OZ API Developer's Guide (for.net) useusl USL ex) boolean useusl = false; Method Detail getozd public stream GetOZD(string item, string category, string[] urls) throws SDM OZD. OZD urls. : API DM_TYPE="Momory", FetchType="Batch".. item ( OZR ) category urls OZD URL GetOZU public Stream getozu(string item, String category, String[] urls) throws SDM OZU. : API DM_TYPE="Momory", FetchType="Batch".. : "FetchUnit" "DM_PER_DATAMODULE". item category urls ( OZA ) OZU URL AddODIParameter public void AddODIParameter(string odiname, string key, string value) throws 20 FORCS Co., LTD

21 A Leader of Enterprise e-business Solution SDM ODI ODI. ODI ODI. odiname ODI key value ODI ODI AddODIParameter public void AddODIParameter(string odiname, string item, string category, IDictionary parameters) throws SDM ODI ODI. ODI ODI. ODI SDM SDM. odiname item category parameters ODI ODI ODI Key, Value Dictionary : OZU parameters OZU addodiparameter() paramhash null addapplicationparameter(key,value) ODI. ex) addapplicationparameter module.addapplicationparameter("odi.odinames", "sample"); module.addapplicationparameter("odi.sample.pcount", "1"); module.addapplicationparameter("odi.sample.args1", "deptid=501"); AddParameter public void AddParameter(string key, string value) throws SDM.. key value FORCS Co., LTD 21

22 OZ API Developer's Guide (for.net) AddApplicationParameter public void AddApplicationParameter(string key, string value) throws SDM. ODI ODI ODI. key ODI value ODI SaveOZD public void SaveOZD(string filename, string item, string category, string[] urls) throws OZD. : API DM_TYPE="Momory", FetchType="Batch".. filename item category Urls OZD (.ozr) (.ozr) OZD URL SaveOZU public void SaveOZU(string filename, string item, string category, string[] urls) throws OZU. : API DM_TYPE="Momory", FetchType="Batch".. : "FetchUnit" "DM_PER_DATAMODULE". filename item category OZU (.oza) (.oza) 22 FORCS Co., LTD

23 A Leader of Enterprise e-business Solution Urls OZU URL Sample : ModuleSample.java using System; using System.IO; using System.Collections; using oz.framework.api; namespace sample{ /// <summary> /// /// ModuleTest - Before start /// You need to customize parameters to run in your environment /// We don't provide oza, odi file for the test /// </summary> public class ModuleTest{ public static void Main(){ string url = " string id = "admin"; string password = "admin"; Module m = new Module(url, id, password, true, true); IDictionary parameters = new Hashtable(); parameters["rowcount"] = "10000"; parameters); m.addodiparameter(" 100.odi", ".oza", "/", "rowcount=10000"); m.addapplicationparameter("odi.odinames", " 100 "); m.addapplicationparameter("odi. 100.pcount", "1"); m.addapplicationparameter("odi. 100.args1", Stream ozufile = m.getozu(".oza", "/"); m = new Module(url, id, password, true, true); m.addodiparameter("parameter_test.odi", "odiparam", "this is odi parameter"); m.addodiparameter("parameter_test.odi", "odiparam2", "this is parameter 2"); m.addparameter( "formparam", "this is form parameter"); FORCS Co., LTD 23

24 OZ API Developer's Guide (for.net) Stream s = m.getozd("parameter_test.ozr", "/", " 24 FORCS Co., LTD

25 A Leader of Enterprise e-business Solution Constructor Summary Monitor(string ip, int port, string id, string pw, boolean autologin, boolean useusl) Monitor (string url, string id, string pw, boolean autologin, boolean useusl) Method Summary OZServerInfo GetServerInfo() MemoryStatus GetMemoryInfo() Stream DownloadLog() Constructor Detail ASP.NET public Monitor(string url, string id, string pw, boolean autologin, boolean useusl) url id pw autologin useusl URL ex) string url = " ex) string id = "admin"; ex) string pw = "admin"; ex) boolean autologin = true; USL ex) boolean useusl = false; Method Detail FORCS Co., LTD 25

26 OZ API Developer's Guide (for.net) GetServerInfo public OZServerInfo GetServerInfo() throws OZPAIException. GetMemoryInfo public MemoryStatus GetMemoryInfo() throws (,, ). DownloadLog rototype public stream DownloadLog() throws. Class MemoryStatus(oz.server.monitor.MemoryStatus) Server System. OZServerInfo(oz.server.monitor. OZServerInfo) Server Server System. - public string osname : Server OS public string osversion : Server OS public string FrameworkVersion : Server.NET Framework Version public string ServerVersion : public string ReleaseNumber : OZ Common Protocol public int ProtocolNumber : OZ Common Protocol public string DataModuleReleaseNumber : OZ Data Module Sample : MonitorSample.java using System; 26 FORCS Co., LTD

27 A Leader of Enterprise e-business Solution using oz.util; using oz.framework.api; using oz.framework.monitor; namespace sample{ /// <summary> /// MonitorTest /// </summary> public class MonitorTest{ public static void Main(){ string url = " string id = "admin"; string password = "admin"; Monitor m = new Monitor(url, id, password, true, true); OZServerInfo si = m.getserverinfo(); Console.WriteLine(si); MemoryStatus ms = m.getmemoryinfo(); Console.WriteLine(ms); System.IO.Stream monitorlog = m.downloadlog(); FORCS Co., LTD 27

28 OZ API Developer's Guide (for.net) Constructor Summary Repository(string url, string id, string pw, boolean autologin, boolean useusl) Method Summary // Configuration public void SetConfigration(OZAttributeList config) public OZAttributeList GetConfiguration() // User public int CreateUser(string username, string pwd, int groupid, string description) public void DeleteUser(int userid) public void UpdateUserName(int userid, string username) public string GetUserName(int userid) // UserLogin public void DisableLogin(string username) public void UpdateLoginDefault(int value) public void EnableLogin(string username) public void Logout(int userid) public bool IsLoggedIn(int userid) // UserPwd public bool CheckPassword(int userid, string password) public void UpdatePassword(int userid, string password) // UserDesc public void UpdateUserDescription(int userid, string description) 28 FORCS Co., LTD

29 A Leader of Enterprise e-business Solution public string GetUserDescription(int userid) // UserID public int GetGroupID(int userid) public int GetUserID(string username) public void UpdateGroupID(int groupid, int userid) // UserList public OZRepositoryUser[] GetUserInfos() public OZRepositoryUser[] GetUserInfos(int groupid) public OZRepositoryUser[] GetUserInfosOfItem(int itemid, byte Permission) public OZRepositoryUser[] GetUserInfosOfCategory(int categoryid, byte Permission) // Group public OZRepositoryUser[] GetUserInfosOfCategory(int categoryid, byte Permission) public int CreateGroup(string groupname, int parentgroupid) public int CreateGroup(string name, int parentgroupid, string description) public void DeleteGroup(int groupid) public void UpdateParentGroup(int groupid, int parentgroupid) public void UpdateGroupName(int groupid, string groupname) // GroupAdmin public void UpdateGroupAdministrator(int userid, int groupid) public bool IsGroupAdministrator(int userid, int groupid) // GroupList public OZRepositoryGroup[] GetChildGroupInfos(int groupid) public OZRepositoryGroup[] GetSubGroupInfos(int groupid) public OZRepositoryGroup GetGroupInfo(int groupid) public OZRepositoryGroup[] GetGroupInfosOfItem(int itemid, byte Permission) public OZRepositoryGroup[] GetGroupInfosOfCategory(int categoryid, byte Permission) FORCS Co., LTD 29

30 OZ API Developer's Guide (for.net) // Item public int CreateItem(string name, OZItemType type, string description, int categoryid, Stream itemdata) public int CreateItem(string name, OZItemType type, string description, string categoryname, Stream itemdata) public int GetItemID(string name, OZItemType type, int categoryid) public int GetItemID(string name, OZItemType type, string categoryname) public void DeleteItem(int id) public Stream GetItem(int id, int categoryid) public void UpdateItemName(int itemid, string itemname) public string GetItemPath(int itemid) public Stream GetItemDirectly(string name, OZItemType type, string categoryname) public Stream GetItemDirectly(string name, OZItemType type, string categoryname, bool compressed) public void UpdateItem(int id, Stream itemdata) public void UpdateItemDirectly(string name, OZItemType type, string categoryname, Stream itemdata) public bool HasItem(string name, OZItemType type, string categoryname) // InfoByItem public int GetCategoryID(int itemid) public void UpdateCategoryID(int categoryid, int newcategoryid, int itemid) // ItemList public OZRepositoryItem[] GetItemInfos() public OZRepositoryItem GetItemInfo(int id) public OZRepositoryItem[] GetItemInfos(int categoryid) public OZRepositoryItem[] GetItemInfos(string categoryname) public OZRepositoryItem[] GetItemInfos(int categoryid, int userid, byte Permission) public OZRepositoryItem[] GetItemInfos(string categoryname, int userid, byte Permission) public OZRepositoryItem[] GetItemInfosOfGroup(int categoryid, int groupid, byte Permission) 30 FORCS Co., LTD

31 A Leader of Enterprise e-business Solution public OZRepositoryItem[] GetItemInfosOfGroup(string categoryname, int groupid, byte Permission) public OZRepositoryItem[] GetItemInfosOfUser(int userid, byte Permission) public OZRepositoryItem[] GetItemInfosOfGroup(int groupid, byte Permission) // Category public int CreateCategory(string name, int parentcategoryid) public int CreateCategory(string categorypath) public void DeleteCategory(int id) public int GetCategoryID(string fullpath) public void UpdateParentCategory(int id, int parentcategoryid) public void UpdateCategoryName(int id, string name) public int GetItemCount(int categoryid) public OZRepositoryCategory[] GetCategoryInfos(int id) public OZRepositoryCategory[] GetCategoryInfosOfUser(int id, int userid, byte Permission) public OZRepositoryCategory[] GetCategoryInfosOfGroup(int id, int groupid, byte Permission) public OZRepositoryCategory GetCategoryInfo(int id) // CheckInOut public void CheckOut(int itemid, int userid, string checkoutfolder) public bool UndoCheckOutItem(int itemid, int userid) public bool CheckInItem(bool keepcheckout, int itemid, int userid, Stream itemdata) public bool IsCheckOutUser(int itemid, int userid) // History public void RollBackItem(int itemid, int itemversion) public Stream GetItemByVersion(int id, int version) public OZRepositoryHistory[] GetHistoryInfos(int itemid) public void ClearHistory(int itemid, int version) FORCS Co., LTD 31

32 OZ API Developer's Guide (for.net) Constructor Detail ASP.NET public Repository(string url, string id, string pw, boolean autologin, boolean useusl) url id pw autologin useusl URL ex) string url = " ex) string id = "admin"; ex) string pw = "admin"; ex) boolean autologin = true; USL ex) boolean useusl = false; Method Detail // Configuration SetConfiguration public void SetConfiguration(OZAttributeList config) throws Repository. Repository,, valid %OZ_HOME%conf /repository.properties. config GetConfiguration public OZAttributeList GetConfiguration() throws Repository. Repository,, valid %OZ_HOME%conf/repository.properties - Key SetConfiguration() GetConfiguration() key 32 FORCS Co., LTD

33 A Leader of Enterprise e-business Solution. Key Value REPOSITORY_TYPE REPOSITORY_FILE_P ATH REPOSITORY_ITEM_ NUMBER_PER_DIREC TORY REPOSITORY_HISTO RY_ITEM_VALID_DA YS REPOSITORY_ADD_C OMPRESSED_ITEM "RDB" "BUILTIN" "true" "false" ex) prop.setproperty("repository_type","rdb"); ex) prop.setproperty("repository_file_path","c:/temp_ repository"); ( : "500") ex) prop.setproperty("repository_item_number_per_ DIRECTORY","100"); ex) prop.setproperty("repository_history_item_vali D_DAYS","20"); ex) prop.setproperty("repository_add_compressed_i TEM","false"); // User CreateUser public int CreateUser(string username, string password, int groupid, string description) throws,,,, userid return. username password groupid description ID DeleteUser public void DeleteUser(int userid) throws ID. FORCS Co., LTD 33

34 OZ API Developer's Guide (for.net) userid ID UpdateUserName public void UpdateUserName(int userid, string username) throws ID. userid username ID GetUserName public string GetUserName(int userid) throws ID. userid ID // UserLogin DisableLogin public void DisableLogin(string username) throws. username UpdateLoginDefault public void UpdateLoginDefault(int value) throws ID. value ID EnableUserLogin public void EnableUserLogin(string username) throws. username Logout public void Logout(int userid) throws 34 FORCS Co., LTD

35 A Leader of Enterprise e-business Solution ID,. userid ID IsLoggedIn public bool IsLoggedIn(int userid) throws ID,. userid ID // UserPwd CheckPassword public bool CheckPassword(int userid, string password) throws. userid password ID UpdatePassword public void UpdatePassword(int userid, string password) throws ID. userid password ID // UserDesc UpdateUserDescription public void UpdateUserDescription(int userid, string description) throws ID. userid description ID GetUserDescription public string GetUserDescription(int userid) throws ID. FORCS Co., LTD 35

36 OZ API Developer's Guide (for.net) userid ID // UserID GetGroupID public int GetGroupID(int userid) throws ID ID. userid ID ID GetUserID public int GetUserID(string username) throws ID. username ID UpdateGroupID public void UpdateGroupID(int groupid, int userid) throws ID. groupid userid ID ID ID // UserList GetUserInfos public OZRepositoryUser[] GetUserInfos() throws repository user OZRepositoryUser. GetUserInfos public OZRepositoryUser[] GetUserInfos(int groupid) throws ID. groupid ID GetUserInfosOfItem 36 FORCS Co., LTD

37 A Leader of Enterprise e-business Solution public OZRepositoryUser[] GetUserInfosOfItem(int itemid, byte permission) throws ID Permission. itemid permission ID GetUserInfosOfCategory public OZRepositoryUser[] GetUserInfosOfCategory(int categoryid, byte permission) throws ID Permission. categoryid permission ID // Group CreateGroup public int CreateGroup(string groupname, int parentgroupid) throws, ID. groupname parentgroupid ID DeleteGroup public void DeleteGroup(int groupid) throws ID. groupid ID UpdateParentGroup public void UpdateParentGroup(int groupid, int parentgroupid) throws ID. groupid ID parentgroupid UpdateGroupName FORCS Co., LTD 37

38 OZ API Developer's Guide (for.net) public void UpdateGroupName(int groupid, string groupname) throws ID. groupid groupname ID // GroupAdmin UpdateUserGroupAdmin public void UpdateGroupAdministrator(int userid, int groupid) throws ID. userid groupid ID ID IsGroupAdministrator public bool IsGroupAdministrator(int userid, int groupid) throws ID. userid ID groupid ID // GroupList GetChildGroupInfos public OZRepositoryGroup[] GetChildGroupInfos(int groupid) throws ID. groupid ID GetSubGroupInfos public OZRepositoryGroup[] GetSubGroupInfos(int groupid) throws ID. (not recursively) groupid ID GetGroupInfo 38 FORCS Co., LTD

39 A Leader of Enterprise e-business Solution public OZRepositoryGroup GetGroupInfo(int groupid) throws ID. groupid ID GetGroupInfosOfItem public OZRepositoryGroup[] GetGroupInfosOfItem(int itemid, byte permission) throws ID permission. itemid ID permission GetGroupInfosOfCategory public OZRepositoryGroup[] GetGroupInfosOfCategory(int categoryid, byte permission) throws ID Permission. categoryid permission ID // Item CreateItem public int CreateItem(string itemname, OZItemType itemtype, string itemdescription, int categoryid, Stream itemdata) throwcs public int CreateItem(string itemname, OZItemType itemtype, string itemdescription, string categoryname, Stream itemdata) throwcs,, desc. ID,,, item ID. itemname itemtype itemdescription categoryid itemdata ID FORCS Co., LTD 39

40 OZ API Developer's Guide (for.net) categoryname GetItemId public int GetItemID(string itemname, OZItemType itemtype, int categoryid) throwcs public int GetItemID(string itemname, OZItemType itemtype, string categoryname) throwcs,, ID ID. ItemType OZItemInfo. itemname itemtype categoryid categoryname ID DeleteItem public void deleteitem(int itemid) throws. itemid ID GetItem public Stream getitem(int itemid) throws ID. itemid ID UpdateItemName public void UpdateItemName(int itemid, string itemname) throws ID. itemid itemname ID GetItemDirectly 40 FORCS Co., LTD

41 A Leader of Enterprise e-business Solution public Stream GetItemDirectly(string itemname, OZItemType itemtype, string categoryname) throws public Stream GetItemDirectly(string itemname, OZItemType itemtype, string categoryname, bool compresseditem) throws. itemname itemtype categoryname compresseditem UpdateItem public void updateitem(int itemid, stream itemdata) throws ID. itemid itemdata ID UpdateItemDirectly public void UpdateItemDirectly(string itemname, OZItemType itemtype, string categoryname, Stream itemdata) throws ID. itemname itemtype categoryname itemdata HasItem public bool HasItem(string itemname, OZItemType itemtype, string categoryname) throws. itemname itemtype categoryname FORCS Co., LTD 41

42 OZ API Developer's Guide (for.net) // InfoByItem GetCategoryID public int GetCategoryID(int itemid) throws ID ID. itemid ID UpdateCategoryID public void UpdateCategoryID(int categoryid, int newcategoryid, int itemid) throws ID. categoryid ID newcategoryid ID itemid ID // ItemList GetItemInfos public OZRepositoryItem[] GetItemInfos() throws. GetItemInfo public OZRepositoryItem getiteminfo(int itemid) throws ID. itemid ID GetItemInfos public OZRepositoryItem[] GetItemInfos(int categoryid) throws public OZRepositoryItem[] GetItemInfos(string categoryfullpath) throws public OZRepositoryItem[] GetItemInfos(int categoryid, int userid, byte permission) throws public OZRepositoryItem[] GetItemInfos(string 42 FORCS Co., LTD

43 A Leader of Enterprise e-business Solution categoryfullpath, int userid, byte permission) throws. categoryid categoryfullpath userid permission ID ID GetItemInfosOfGroup public OZRepositoryItem[] GetItemInfosOfGroup(int categoryid, int groupid, byte Permission) throws public OZRepositoryItem[] GetItemInfosOfGroup(string categoryfullpath, int groupid, byte permission) throws. categoryid groupid permission categoryfullpath ID ID GetItemInfosOfUser public OZRepositoryItem[] GetItemInfosOfUser(int userid, byte permission) throws ID Permission. userid permission ID GetItemInfosOfGroup public OZRepositoryItem[] GetItemInfosOfGroup(int groupid, byte permission) throws ID Permission. groupid permission ID FORCS Co., LTD 43

44 OZ API Developer's Guide (for.net) // Category CreateCategory public int CreateCategory(string categoryname, int parentcategoryid) throws, ID. categoryname parentcategoryid ID CreateCategory public int CreateCategory(string categorypath) throws, ID. categorypath DeleteCategory public void DeleteCategory(int categoryid) throws ID. categoryid ID GetCategoryID public int GetCategoryID(string fullpath) throws ID. fullpath ID UpdateParentCategory public void UpdateParentCategory(int categoryid, int parentcategoryid) throws ID. categoryid ID parentcategoryid ID 44 FORCS Co., LTD

45 A Leader of Enterprise e-business Solution UpdateCategoryName public void UpdateCategoryName(int categoryid, string categoryname) throws ID. categoryid categoryname ID GetItemCount public int GetItemCount(int categoryid) throws. categoryid ID GetCategoryInfos public OZRepositoryCategory[] GetCategoryInfos(int categoryid) throws. categoryid ID GetCategoryInfo public OZRepositoryCategory GetCategoryInfo(int categoryid) throws. categoryid ID GetCategoryInfosOfUser public OZRepositoryCategory[] GetCategoryInfosOfUser(int categoryid, int userid, byte Permission) throws ID permission. userid categoryid Permission ID ID GetCategoryInfosOfGroup FORCS Co., LTD 45

46 OZ API Developer's Guide (for.net) public OZRepositoryCategory[] GetCategoryInfosOfGroup(int groupid, int categorypid, byte permission) throws ID permission. groupid categoryid permission ID ID // CheckInOut checkout public void checkout(int itemid, int userid, string checkoutfolder) throws ID. itemid userid checkoutfolder ID ID undocheckout public void undocheckout(int itemid, int userid) throws ID. itemid userid ID ID checkin public void checkin(boolean keepchkout, int itemid, int userid, stream itemdata) throws ID. keepchkout itemid userid itemdata ID ID ischeckoutuser 46 FORCS Co., LTD

47 A Leader of Enterprise e-business Solution public boolean ischeckoutuser(int itemid, int userid) throws. itemid userid ID ID // History GetItemByVersion public Stream GetItemByVersion(int itemid, int itemversion) throws ID. itemid itemversion ID GetHistoryInfos public OZRepositoryHistory[] GetHistoryInfos(int itemid) throws. itemid ID ClearHistory public void clearhistory(int itemid, int itemversion) throws. itemid itemversion ID RollBack public void rollback(int itemid, int itemversion) throws. itemid itemversion ID Class FORCS Co., LTD 47

48 OZ API Developer's Guide (for.net) OZRepositoryUser(oz.framework.repository.OZRepositoryUser),,,,. - Name public string Name{get; ID public int ID{get; ID GroupList public System.Collections.IList GroupList {get; Description public string Description{get; PassWord public string PassWord{get; Permission public byte Permission{get; 0 : None( ) 1 : View( ) 3 : Read( ) 7 : Write( ) DirectPermission public byte DirectPermission{get; 48 FORCS Co., LTD

49 A Leader of Enterprise e-business Solution InDirectPermission public byte InDirectPermission{get; IsLoggedIn public bool IsLoggedIn{get; SessionID public int SessionID{get; ID IsLoginEnabled public bool IsLoginEnabled{get; OZRepositoryGroup(oz.framework.repository.OZRepositoryGroup),,,,. - Name public string Name{get; ID public int ID{get; ID ParentID public int ParentID{get; ID GroupAdmininistratorList public System.Collections.IList GroupAdministratorList {get; FORCS Co., LTD 49

50 OZ API Developer's Guide (for.net) DirectPermission public byte DirectPermission{get; InDirectPermission public byte InDirectPermission{get; Permission public byte Permission{get; Description public string Description{get; FullPath public string FullPath{get; OZRepositoryItem(oz.framework.repository.OZRepositoryItem),,,,. - Name public string Name{get; ID public int ID{get; ID Type 50 FORCS Co., LTD

51 A Leader of Enterprise e-business Solution public OZItemType Type{get; enum OZItemType{ ODI, OZR, SDM, USDM, OZD, IMG Description public string Description{get; CheckOutUserID public int CheckOutUserID{get; ID CheckOutUserName public string CheckOutUserName{get; CheckOutFolder public string CheckOutFolder{get; UpdateTime public string UpdateTime{get; IsCheckedOut public bool IsCheckedOut{get; DirectPermission public byte DirectPermission{get; InDirectPermission public byte InDirectPermission{get; FORCS Co., LTD 51

52 OZ API Developer's Guide (for.net) AdministratorList public System.Collections.IList AdministratorList{get; CategoryList System.Collections.IList CategoryList{get; OZRepositoryCategory(oz.framework.repository.OZRepositoryCategory). - Name public string Name{get; ID public int ID{get; ID ParentID public int ParentID{get; ID CategoryAdministratorList public System.Collections.IList CategoryAdministratorList {get; DirectPermission public byte DirectPermission{get; InDirectPermission 52 FORCS Co., LTD

53 A Leader of Enterprise e-business Solution public byte InDirectPermission{get; Permission public byte Permission{get; Description public string Description{get; FullPath public string FullPath{get; OZRepositoryHistory(oz.framework.repository.OZRepositoryHistory). - ItemPath public string ItemPath{get; ItemVersion public int ItemVersion{get; Date public string Date{get; CheckInUser public string CheckInUser{get; FORCS Co., LTD 53

54 OZ API Developer's Guide (for.net) Sample : RepositorySample.java using System; using System.IO; using System.Reflection; using System.Collections; using oz.util; using oz.framework.api; using oz.framework.repository; namespace sample{ /// <summary> /// RepositoryTest /// /// Before start /// You should modify file open logic. /// In this sample we handle project resource whose id is "sample.parameter_test.odi" /// as a file to upload /// </summary> public class RepositoryTest{ private static Repository s_repository = null; public static void Main(){ string url = " string id = "admin"; string password = "admin"; s_repository = new Repository(url, id, password, true, true); repositoryconfiguration(); categorytest(); itemtest(); grouptest(); usertest(); private static void repositoryconfiguration(){ OZAttributeList attrs = s_repository.getconfiguration(); Console.WriteLine(attrs); s_repository.setconfiguration(attrs); private static void historytest(int itemid){ const int version = 0; 54 FORCS Co., LTD

55 A Leader of Enterprise e-business Solution // you can store item using this input stream Stream input = s_repository.getitembyversion(itemid, version); OZRepositoryHistory[] historyinfos = s_repository.gethistoryinfos(itemid); foreach(ozrepositoryhistory history in historyinfos){ Console.WriteLine(history); s_repository.rollback(itemid, version); private static void checkinouttest(int itemid){ int userid = s_repository.getuserid("admin"); string checkoutfolder = "."; s_repository.checkout(itemid, userid, checkoutfolder); s_repository.undocheckout(itemid, userid); s_repository.checkout(itemid, userid, checkoutfolder); Assembly asm = Assembly.GetExecutingAssembly(); Stream item = asm.getmanifestresourcestream ("sample.parameter_test.odi"); try{ s_repository.checkin(false, itemid, userid, item); finally{ item.close(); private static void categorytest(){ int userid = s_repository.getuserid("admin"); int groupid = s_repository.getgroupid(userid); int categoryid = s_repository.createcategory("/poultry"); Console.WriteLine("Created category : {0", categoryid); int childcategoryid = s_repository.createcategory("chickens", cat egoryid); Console.WriteLine("Created child category : {0", childcategoryid); s_repository.deletecategory(childcategoryid); s_repository.updatecategoryname(categoryid, "Fishes"); int anothercategoryid = s_repository.createcategory("/category Test"); s_repository.updateparentcategory(categoryid, anothercategoryid); Console.WriteLine("Item count in category [{0] : {1", categoryid, s_repository.getitemcount(categoryid)); FORCS Co., LTD 55

56 OZ API Developer's Guide (for.net) OZRepositoryCategory[] categoryinfos = s_repository.getcategoryinfos(anothercategoryid); foreach(ozrepositorycategory category in categoryinfos){ Console.WriteLine(category); categoryinfos = s_repository.getcategoryinfosofuser(anothercategoryid, userid, 2); foreach(ozrepositorycategory category in categoryinfos){ Console.WriteLine(category); s_repository.deletecategory(categoryid); s_repository.deletecategory(anothercategoryid); private static void itemlisttest(int itemid){ int userid = s_repository.getuserid("admin"); int groupid = s_repository.getgroupid(userid); string categoryname = "/"; int categoryid = s_repository.getcategoryid(categoryname); OZRepositoryItem iteminfo = s_repository.getiteminfo(itemid); Console.WriteLine(itemInfo); OZRepositoryItem[] iteminfos = s_repository.getiteminfos(categoryid); foreach(ozrepositoryitem ii in iteminfos) Console.WriteLine(ii); iteminfos = s_repository.getiteminfos(categoryname, userid, 2); foreach(ozrepositoryitem ii in iteminfos) Console.WriteLine(ii); 2); iteminfos = s_repository.getiteminfosofgroup(categoryname, groupid, foreach(ozrepositoryitem ii in iteminfos) Console.WriteLine(ii); private static void itemtest(){ string itemname = "api test.odi"; string categoryname = "/api test"; string description = "item upload test"; int categoryid = s_repository.createcategory(categoryname); Stream item = Assembly.GetExecutingAssembly().GetManifestResourceStream ("sample.parameter_test.odi"); 56 FORCS Co., LTD

57 A Leader of Enterprise e-business Solution int itemid; try{ itemid = s_repository.createitem(itemname, OZItemType.ODI, description, categoryid, item); Console.WriteLine("Item uploaded : {0", itemid); finally{ item.close(); itemname = "Changed item name.odi"; s_repository.updateitemname(itemid, itemname); Console.WriteLine("Changed item name : {0", s_repository.getiteminfo(itemid).name); itemlisttest(itemid); checkinouttest(itemid); categorytest(); historytest(itemid); s_repository.deleteitem(itemid); s_repository.deletecategory(categoryid); private static void grouplisttest(int gropuid){ int userid = s_repository.getuserid("admin"); int groupid = s_repository.getgroupid(userid); OZRepositoryGroup gi= s_repository.getgroupinfo(groupid); Console.WriteLine(gi); private static void groupadministratortest(int groupid){ IList admins = s_repository.getgroupinfo(groupid).groupadministratorlist; Console.WriteLine(admins[0].ToString()); int userid = s_repository.createuser("test id", " ", groupid, ""); s_repository.updategroupadministrator(userid, groupid); admins = s_repository.getgroupinfo(groupid).groupadministratorlist; Console.WriteLine(admins[0].ToString()); s_repository.deleteuser(userid); private static void grouptest(){ int adminid = s_repository.getuserid("admin"); int rootgroupid = s_repository.getgroupid(adminid); string groupname = "forcs"; FORCS Co., LTD 57

58 OZ API Developer's Guide (for.net) group"); int groupid = s_repository.creategroup(groupname, rootgroupid, "test rootgroupid); int tempgroupid = s_repository.creategroup("temporary group", s_repository.updateparentgroup(groupid, tempgroupid); s_repository.updateparentgroup(groupid, rootgroupid); s_repository.deletegroup(tempgroupid); s_repository.updategroupname(groupid, "OZ XStudio"); groupadministratortest(groupid); grouplisttest(groupid); s_repository.deletegroup(groupid); private static void usertest(){ string username = "forcs"; string password = "111111"; string description = "test account"; int groupid = s_repository.getgroupid(s_repository.getuserid("admin")); int userid = s_repository.createuser(username, password, groupid, description); prevgroupid); int prevgroupid = s_repository.getgroupid(userid); int newgroupid = s_repository.creategroup("group for test", s_repository.updategroupid(newgroupid, userid); username = s_repository.getusername(userid); s_repository.updategroupid(prevgroupid, userid); s_repository.deletegroup(newgroupid); description = s_repository.getuserdescription(userid); Console.WriteLine("Password matches? " + s_repository.checkpassword(userid, "new password")); s_repository.updatepassword(userid, "new password"); Console.WriteLine("Password matches? " + s_repository.checkpassword(userid, "new password")); 58 FORCS Co., LTD

59 A Leader of Enterprise e-business Solution s_repository.updatelogindefault(userid); username = s_repository.getusername(userid); s_repository.disablelogin(username); s_repository.enablelogin(username); int categoryid = s_repository.createcategory("/user list test"); OZRepositoryUser[] userinfos = s_repository.getuserinfos(); foreach(ozrepositoryuser ui in userinfos) Console.WriteLine(ui); userinfos = s_repository.getuserinfos(groupid); foreach(ozrepositoryuser ui in userinfos) Console.WriteLine(ui); s_repository.deletecategory(categoryid); s_repository.deleteuser(userid); FORCS Co., LTD 59

60 OZ API Developer's Guide (for.net) 60 FORCS Co., LTD

61 A Leader of Enterprise e-business Solution User Data Store for.net UDS for.net UDS for.net UDS for.net FORCS Co., LTD 61

62 OZ API Developer's Guide (for.net) UDS(User Data Store) ADO.NET Interface,, CSV, XML ASP DataReader OZ User Data Source Interface ADO.NET DBMS Provider (ASP, ) UDS DataReader.. UDS SQL.. 62 FORCS Co., LTD

63 A Leader of Enterprise e-business Solution ADO.NET UDS. OZ Server Query String ADO.NET OZ Designer DataReader DBMS Provider DBMS ADO.NET DBMS Provider DBMS ADO.NET DBMS Provider DBMS DataReader.NET. DataReader ADO.NET System.Data.IDataReader Interface (implement)., DBMS DBMS ADO.NET DBMS Provider System.Data.IDataReader Interface Concrete DataReader. ADO.NET DBMS Provider System.Data.IDataReader Interface. OZ Server OZ Designer () Custom DataReader Custom ADO.NET DBMS Provider UDS(User Data Store) ADO.NET DBMS Provider Custom ADO.NET DBMS Provider System.Data.IDataReader interface DataReader. ADO.NET DBMS Provider. oz.uds. Interface Interface IDataReader Interface. oz.uds. interface 4. FORCS Co., LTD 63

64 OZ API Developer's Guide (for.net) using System; using System.Data; namespace oz.uds { public abstract class OZUserDataReaderStore : IOZUserDataStore { abstract public void Init(); abstract public IDataReader GetDataReader(string command); abstract public void FreeDataReader(IDataReader idr); abstract public void Close();. void Init() IDataReader GetDataReader(string command) UDS,. (). void FreeDataReader(IDataReader idr) void Close(). UDS,. : Init(), Close(). 64 FORCS Co., LTD

65 A Leader of Enterprise e-business Solution UDS GetDataReader. UDS Source UDS Main Command. using System; using System.Web; using System.Data; using System.Data.SqlClient; using System.Collections; using oz.uds; namespace oz.uds { public class UserDataReaderStore : OZUserDataReaderStore { public UserDataReaderStore() { public override IDataReader GetDataReader(string command) { // Command IDataReader. // Command OZ. public override void Close() { // UserDataSet. // DB Disconnection. public override void FreeDataReader(IDataReader reader) { FORCS Co., LTD 65

66 OZ API Developer's Guide (for.net) // GetDataReader IDataReader. // IDataReader Close. public override void Init() { // UDS. DB. DataReader DataReader DataReader. String ArrayList DataReader. oz oz.uds.dr API DataReader. oz DataReader. DataReader - string IDataReader API public ArrayDataReader(string[] fieldnames, string[][] data) public ArrayDataReader(string[] fieldnames, Type[] types, string[][] data) - ArrayList IDataReader API public ArrayListDataReader(ArrayList fieldnames, ArrayList[] data) public ArrayListDataReader(ArrayList fieldnames, ArrayList types, ArrayList[] data) - Dynamic DataReader API public DynamicDataReader(IDataReader reader) * Dynamic Field ArrayDataReader, ArrayListDataReader UDS #1 DB DataReader UDS. < UserDataReaderStore.cs> using System; 66 FORCS Co., LTD

67 A Leader of Enterprise e-business Solution using System.Web; using System.Data; using System.Data.SqlClient; using System.Collections; using oz.uds; namespace oz.uds { public class UserDataReaderStore : OZUserDataReaderStore, IOZUDS_ConnectionPoolRef { IDbConnection con; public UserDataReaderStore() { public override IDataReader GetDataReader(string command) { IDbCommand cmd = con.createcommand(); cmd.commandtext = command; return cmd.executereader(); public override void Close() { con.close(); public override void FreeDataReader(IDataReader reader) { reader.close(); public override void Init() { // oz server alias name private const string s_alias = "test"; public System.Collections.Hashtable Connections { set{ con = (IDbConnection)value[s_alias]; public string[] Aliases { get{ return new string[]{s_alias ; FORCS Co., LTD 67

68 OZ API Developer's Guide (for.net) UDS #2 DB DataTable UDS. < UserDataTableStore.cs> using System; using System.Web; using System.Data; using System.Collections; using System.Data.SqlClient; using oz.uds; namespace oz.uds { public class UserDataTableStore : OZUserDataTableStore, IOZUDS_ConnectionPoolRef { IDbConnection con; public UserDataTableStore() { public override DataTable GetDataTable(string command) { DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(); IDbCommand cmd = con.createcommand(); cmd.commandtext = command; da.selectcommand = (SqlCommand)cmd; da.fill(dt); return dt; public override void Close() { con.close(); public override void FreeDataTable(DataTable dt) { dt.dispose(); 68 FORCS Co., LTD

69 A Leader of Enterprise e-business Solution public override void Init() { private const string s_alias = "test"; public System.Collections.Hashtable Connections { set{ con = (IDbConnection)value[s_alias]; public string[] Aliases { get{ return new string[]{s_alias ; UDS #3 string Data UDS. < UserStringStore.cs> using System; using System.Web; using System.Data; using System.Collections; using oz.uds; using oz.uds.dr; namespace oz.uds { public class UserStringStore : OZUserDataReaderStore { string[] fieldname = {"field1", "field2"; string[][] data = { {"data11","data12", {"data21", "data22" ; public UserStringStore() { public override IDataReader GetDataReader(string command) { return new ArrayDataReader(fieldname,data); public override void Close() FORCS Co., LTD 69

70 OZ API Developer's Guide (for.net) { public override void FreeDataReader(IDataReader reader) { public override void Init() { 70 FORCS Co., LTD