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 public OZAttributeList GetCacheConfigration () throws FORCS Co., LTD 5

6 OZ API Developer's Guide (for.net).,,,,. 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 Property key. 6 FORCS Co., LTD

7 A Leader of Enterprise e-business Solution Key Value Active CACHE_FILE_ PATH DM_CACHE_FI LE_PATH memorycache ValidTime diskcachevali dtime FreeMemoryPe rcentage "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.cs 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(); Console.WriteLine(attrs); c.setconfiguration(attrs); FORCS Co., LTD 7

8 OZ API Developer's Guide (for.net) 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 ConnectionPool. 10 FORCS Co., LTD

11 A Leader of Enterprise e-business Solution Class ConnectionPoolInfo(oz.framework.db.ConnectionPoolInfo). ConnectionPoolStatus(oz.framework.db.ConnectionPoolStatus) ConnectionPool. - ConnectionPool.. Status OK DRIVER_ERROR CONNECTION_ERROR ConnectionPool ConnectionPool JDBC ConnectionPool DBMS Sample : ConnectionPoolTest.cs 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); string alias = "connection_pool_test"; FORCS Co., LTD 11

12 OZ API Developer's Guide (for.net) ConnectionPoolInfo poolinfo = new ConnectionPoolInfo(); poolinfo.alias = alias; poolinfo.vendor = "MSSQL"; poolinfo.items["serveraddress"] = " "; poolinfo.items["portno"] = "1433"; poolinfo.items["dbname"] = "QATEST"; poolinfo.items["user"] = "user1"; poolinfo.items["password"] = "user123"; 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 ConcurrentFetchSize ConcurrentFirstRow FetchType "Concurrent" Stream. byte, 4096, 256. :,. FetchType "Concurrent"., 0. : 0. Sample : DataBindTest.cs using System; using oz.util; using oz.framework.api; namespace sample 14 FORCS Co., LTD

15 A Leader of Enterprise e-business Solution /// <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(stringdictionaryentry attr in attrs) Console.WriteLine(attr.Key + " : " + attr.value); 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; 16 FORCS Co., LTD

17 A Leader of Enterprise e-business Solution Method Detail 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%c1%x-%m%n GetFileNames public string[] GetFileNames() throws. Sample : LogSample.cs using System; using System.IO; using oz.framework.api; FORCS Co., LTD 17

18 OZ API Developer's Guide (for.net) namespace sample /// <summary> /// LogTest /// </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="Memory", FetchType="Batch".. item ( OZR ) category urls OZD URL GetOZU public Stream getozu(string item, String category, String[] urls) throws SDM OZU. : API DM_TYPE="Memory", 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 key value ODI 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 Urls OZU (.oza) (.oza) OZU URL 22 FORCS Co., LTD

23 A Leader of Enterprise e-business Solution Sample : ModuleSample.cs 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"); Stream s = m.getozd("parameter_test.ozr", "/", " FORCS Co., LTD 23

24 OZ API Developer's Guide (for.net) 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; 24 FORCS Co., LTD

25 A Leader of Enterprise e-business Solution Method Detail 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 FORCS Co., LTD 25

26 OZ API Developer's Guide (for.net) Sample : MonitorSample.cs using System; 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(); 26 FORCS Co., LTD

27 A Leader of Enterprise e-business Solution 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) FORCS Co., LTD 27

28 OZ API Developer's Guide (for.net) 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) 28 FORCS Co., LTD

29 A Leader of Enterprise e-business Solution // 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) FORCS Co., LTD 29

30 OZ API Developer's Guide (for.net) 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) 30 FORCS Co., LTD

31 A Leader of Enterprise e-business Solution 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 FORCS Co., LTD 31

32 OZ API Developer's Guide (for.net). 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. 32 FORCS Co., LTD

33 A Leader of Enterprise e-business Solution 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 FORCS Co., LTD 33

34 OZ API Developer's Guide (for.net) public void Logout(int userid) throws 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 34 FORCS Co., LTD

35 A Leader of Enterprise e-business Solution public string GetUserDescription(int userid) throws ID. 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 OZRepositoryUser. GetUserInfos public OZRepositoryUser[] GetUserInfos(int groupid) throws ID. FORCS Co., LTD 35

36 OZ API Developer's Guide (for.net) groupid ID GetUserInfosOfItem 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. 36 FORCS Co., LTD

37 A Leader of Enterprise e-business Solution groupid ID parentgroupid UpdateGroupName 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 FORCS Co., LTD 37

38 OZ API Developer's Guide (for.net) public OZRepositoryGroup[] GetSubGroupInfos(int groupid) throws ID. (not recursively) groupid ID GetGroupInfo 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 38 FORCS Co., LTD

39 A Leader of Enterprise e-business Solution,, desc. ID,,, item ID. itemname itemtype itemdescription categoryid itemdata categoryname ID 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 FORCS Co., LTD 39

40 OZ API Developer's Guide (for.net) ID. itemid itemname ID GetItemDirectly 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 40 FORCS Co., LTD

41 A Leader of Enterprise e-business Solution. itemname itemtype categoryname // 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 FORCS Co., LTD 41

42 OZ API Developer's Guide (for.net) 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 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 42 FORCS Co., LTD

43 A Leader of Enterprise e-business Solution GetItemInfosOfGroup public OZRepositoryItem[] GetItemInfosOfGroup(int groupid, byte permission) throws ID Permission. groupid permission ID // 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 FORCS Co., LTD 43

44 OZ API Developer's Guide (for.net) UpdateParentCategory public void UpdateParentCategory(int categoryid, int parentcategoryid) throws ID. categoryid parentcategoryid ID ID 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 44 FORCS Co., LTD

45 A Leader of Enterprise e-business Solution ID permission. userid categoryid Permission ID ID GetCategoryInfosOfGroup 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 FORCS Co., LTD 45

46 OZ API Developer's Guide (for.net) ID. keepchkout itemid userid itemdata ID ID ischeckoutuser 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 46 FORCS Co., LTD

47 A Leader of Enterprise e-business Solution public void rollback(int itemid, int itemversion) throws. itemid itemversion ID Class OZRepositoryUser(oz.framework.repository.OZRepositoryUser),,,,. - Name public string Nameget; ID public int IDget; ID GroupList public System.Collections.IList GroupList get; Description public string Descriptionget; PassWord public string PassWordget; Permission public byte Permissionget; FORCS Co., LTD 47

48 OZ API Developer's Guide (for.net) 0 : None( ) 1 : View( ) 3 : Read( ) 7 : Write( ) DirectPermission public byte DirectPermissionget; InDirectPermission public byte InDirectPermissionget; IsLoggedIn public bool IsLoggedInget; SessionID public int SessionIDget; ID IsLoginEnabled public bool IsLoginEnabledget; OZRepositoryGroup(oz.framework.repository.OZRepositoryGroup),,,,. - Name public string Nameget; ID 48 FORCS Co., LTD

49 A Leader of Enterprise e-business Solution public int IDget; ID ParentID public int ParentIDget; ID GroupAdmininistratorList public System.Collections.IList GroupAdministratorList get; DirectPermission public byte DirectPermissionget; InDirectPermission public byte InDirectPermissionget; Permission public byte Permissionget; Description public string Descriptionget; FullPath public string FullPathget; OZRepositoryItem(oz.framework.repository.OZRepositoryItem),,,,. FORCS Co., LTD 49

50 OZ API Developer's Guide (for.net) - Name public string Nameget; ID public int IDget; ID Type public OZItemType Typeget; enum OZItemType ODI, OZR, SDM, USDM, OZD, IMG Description public string Descriptionget; CheckOutUserID public int CheckOutUserIDget; ID CheckOutUserName public string CheckOutUserNameget; CheckOutFolder public string CheckOutFolderget; UpdateTime public string UpdateTimeget; IsCheckedOut 50 FORCS Co., LTD

51 A Leader of Enterprise e-business Solution public bool IsCheckedOutget; DirectPermission public byte DirectPermissionget; InDirectPermission public byte InDirectPermissionget; AdministratorList public System.Collections.IList AdministratorListget; CategoryList System.Collections.IList CategoryListget; OZRepositoryCategory(oz.framework.repository.OZRepositoryCategory). - Name public string Nameget; ID public int IDget; ID ParentID public int ParentIDget; ID CategoryAdministratorList FORCS Co., LTD 51

52 OZ API Developer's Guide (for.net) public System.Collections.IList CategoryAdministratorList get; DirectPermission public byte DirectPermissionget; InDirectPermission public byte InDirectPermissionget; Permission public byte Permissionget; Description public string Descriptionget; FullPath public string FullPathget; OZRepositoryHistory(oz.framework.repository.OZRepositoryHistory). - ItemPath public string ItemPathget; ItemVersion public int ItemVersionget; 52 FORCS Co., LTD

53 A Leader of Enterprise e-business Solution Date public string Dateget; CheckInUser public string CheckInUserget; Sample : RepositorySample.cs 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(); FORCS Co., LTD 53

54 OZ API Developer's Guide (for.net) 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; // 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); 54 FORCS Co., LTD

55 A Leader of Enterprise e-business Solution 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)); 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) FORCS Co., LTD 55

56 OZ API Developer's Guide (for.net) 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"); 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, ""); 56 FORCS Co., LTD

57 A Leader of Enterprise e-business Solution 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"; int groupid = s_repository.creategroup(groupname, rootgroupid, "test group"); 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); FORCS Co., LTD 57

58 OZ API Developer's Guide (for.net) 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")); 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); 58 FORCS Co., LTD

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

60 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.. 60 FORCS Co., LTD

61 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 61

62 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(). 62 FORCS Co., LTD

63 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 63

64 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; using System.Web; using System.Data; using System.Data.SqlClient; using System.Collections; 64 FORCS Co., LTD

65 A Leader of Enterprise e-business Solution 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 65

66 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(); public override void Init() 66 FORCS Co., LTD

67 A Leader of Enterprise e-business Solution 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() public override void FreeDataReader(IDataReader reader) FORCS Co., LTD 67

68 OZ API Developer's Guide (for.net) public override void Init() 68 FORCS Co., LTD