当前位置：文档之家 › Form学习笔记

Form学习笔记

  • 格式：docx
  • 大小：144.42 KB
  • 文档页数：15

一、ERP中消息的使用:FND_MESSAGE.SET_NAME('OMS','OMS_PI_STANDARD_ERROR_60');其中'OMS'系统当前应用，OMS_PI_STANDARD_ERROR_60是消息名称FND_MESSAGE.SET_TOKEN('SEGMENT1',:DETAILS.factory_code);其中'SEGMENT1'是消息中定义的变量，:DETAILS.factory_code是要传入到'SEGMENT1'变量中的值。

FND_MESSAGE.ERROR;--提示错误类型(ERROR,SHOW…)注意：SEGMENT1前面加&符号就是变量。

例子：IF :BLOCK.ITEM IS NULL THENFND_MESSAGE.SET_NAME('OMS','OMS_PI_STANDARD_ERROR_60');FND_MESSAGE.SET_TOKEN('SEGMENT1',:DETAILS.factory_code);FND_MESSAGE.ERROR;raiseform_trigger_failure;END IF;二、FORM调用互传参数(A form中传值调用B form)A form中的Trigger下写入：fnd_function.execute(function_name => 'OMS_MO_ORDER'—功能名,open_flag => 'Y'—默认,session_flag => 'SESSION'—默认,activate_flag => 'HEADER', --焦点在哪个Window上,other_params => 'QUERY_ONLY="' || 'YES' || '"' ||'p_header_id=' || v_mo_header_id);function_name为ERP中定义的功能名称other_params参数中的QUERY_ONLY为查询状态，QUERY_ONLY为form标准参数B form中的WHEN-NEW-FORM-INSTANCE (FORM级)触发器中写入以下代码if :parameter.p_header_id is not nullthenset_block_property('header',default_where,'mo_header_id =' || :parameter.p_header_id);go_block('header');execute_query;end if;其中:parameter.p_header_id的值就是从A FORM中传过来的。

注意：fnd_function.execute中的p_header_id必须和set_block_property中的p_header_id名称必须相同，不然form找不到参数。

三、调用pll动态创建列表Setup1在FORM级触发器WHEN-NEW-FORM-INSTANCE中加入以下代码：Create_ListBox --cust块客户类型('OMS_CUST_TYPE', ' Select Description,lookup_code '||' From OMS_ALL_LOOKUP_CODES_V '||' Where lookup_type = ''OMS_CM_CUST_TYPE'' ','CUST.CUSTOMER_TYPE');CUST.CUSTOMER_TYPE就是LIST BoxSetup2在PL/SQL Libraries 中创建过程Setup3在Procedure Body中写入以下代码--以一个查询语句设置一个LISTBOXPROCEDURE CREATE_LISTBOX(P_RECORDGROUP_NAME VARCHAR2,P_QUERY_SQL VARCHAR2,P_LIST_ITEM_NAME VARCHAR2) ISv_rg_idRecordGroup;v_g PLS_INTEGER;BEGINv_rg_id := Find_Group( P_RECORDGROUP_NAME );IF NOT Id_Null(v_rg_id) THENDelete_Group(v_rg_id );END IF;v_rg_id := Create_Group_From_Query(P_RECORDGROUP_NAME,P_QUERY_SQL); v_g := POPULATE_GROUP(P_RECORDGROUP_NAME);POPULATE_LIST(P_LIST_ITEM_NAME,P_RECORDGROUP_NAME);END;四、commit_form的过程分为两步第一步是post。

将数据块上的变化post到数据库，就是将用户创建、删除、修改记录的动作翻译为SQL 语句，在数据库上执行。

第二步是commit。

这里指的是数据库commit。

在此之前，commit_form过程会先检查各个数据块的状态。

如果数据块状态不等于'CHANGED'，后面的post-commit步骤不会进行。

我见过你所说的情况：原因是在非事务性forms触发器中直接使用DML语句去操作数据库，然后调用commit（或commit_form）。

因为直接使用DML语句，Forms的数据块状态不会相应改变，当然也就没有提交。

五、FORM中获取光标所在的TAB页面1. 在Form级触发器中添加触发WHEN-TAB-PAGE-CHANGED2. 在此触发器中写如下代码：DECLAREcanvas_id VARCHAR2(30); --标签页IDBEGINcanvas_id := GET_CANVAS_PROPERTY('标签画布名', topmost_tab_page);IF canvas_id='标签页1' then go_block('块1');end if;IF canvas_id='标签页2' then go_block('块2');end if;IF canvas_id='标签页3' then go_block('块3');end if;execute_query;END;六、设置时间DECLAREtimer_id Timer;one_minute NUMBER(5) := 60000;BEGINtimer_id := CREATE_TIMER('emp_timer', one_minute, REPEAT|NO_REPEAT); END;七、动态产生一个'LOV'框DECLARElv_id LOV;status BOOLEAN;BEGINlv_id := Find_LOV('lov_name'); ---'lov_name' 由导航器定义-- IFId_Null(lv_id) THEN-- lv_id := Find_LOV('lov_name1'); ---'lov_name1' 由导航器定义-- END IF;status := Show_LOV(lv_id,10,20);END;八、循环访问所有记录DECLAREcur_blkVARCHAR2(40) := :System.Cursor_Block;bk_id Block;BEGINbk_id := Find_Block(cur_blk);GO_BLOCK('SHOPPEDAYOVERTB_V');GO_RECORD(1);LOOPif get_block_property(bk_id,Update_Allowed)='TRUE' then:SHOPPEDAYOVERTB_V.import_flag:='N';UPDATE SHOPPEDAYOVERTB SET import_flag ='N' where SHOPPEDAYOVERTB.ROWID=:SHOPPEDAYOVERTB_V.ROW_ID;end if;EXIT WHEN (NAME_IN('ST_RECORD') = 'TRUE');NEXT_RECORD;END LOOP;commit;END;九、从当前form转到请求提交页面fnd_function.execute( function_name => 'FND_FNDRSRUN',open_flag => 'Y',session_flag => 'Y',other_params => 'DODT_REQ_ID="'||TO_CHAR(l_request_id)||'"');十、在R12中实现多OU编程A.首先最重要的是要在pre-form中初始化多OUBEGINAPP_STANDARD.EVENT(‘PRE-FORM’);//必须在APP_STANDARD.EVENT()后执行MO_GLOBAL.init ('INV');--参数可以使’S’—单OU，’M’-多OU，或者已经注册过的应用简称END;B.初始化后获取OU的信息，在Pre-form中获取OU信息，或在块上When-Create-Record获取OU信息Pre-formDECLAREl_default_org_id number;l_default_ou_name varchar2(240);l_ou_count number;BEGIN...mo_utils.get_default_ou(l_default_org_id, l_default_ou_name, l_ou_count);:PARAMETER.mo_default_org_id:= l_default_org_id;:PARAMETER.mo_default_ou_name := l_default_ou_name;:PARAMETER.mo_ou_count := l_ou_count;...END;When-Create-RecordIF :parameter.mo_default_org_id is not null and :_id is null THEN :_id := :parameter.mo_default_org_id);:block.operating_unit := :parameter.mo_default_ou_name;END IF;C.在各个触发器实现多OU的支持的代码When-Create-Record Trigger of Operating Unit Field BlockIF (:parameter.mo_default_org_id IS NOT NULL ) THEN-- Defaulting org_id from profile option:_id := :parameter.mo_default_org_id;:block.operating_unit := :parameter.mo_default_ou_name;-- Set policy contextmo_global.set_policy_context('S’,:_id);ELSEmo_global.set_policy_context('M', null);END IF;IF :<your block _id> is not null\IF :<block _id><>nvl(:<parameter.old_org_id>,-99) THEN -- Get the cache for current orgEND IF;ELSE-- Refresh the cache...END IF;When-Validate-Item Trigger of Operating Unit fieldIF (:<your block _id> IS NOT NULL ) THENIF :<block _id><>nvl(:<parameter.old_org_id>,-99) THENmo_global.set_policy_context('S', :_id);-- Get the cache for the current orgEND IF;ELSE -- :_id is nullmo_global.set_policy_context('M', null);-- Refresh the cacheEND IF;When-New-Record-Instance Trigger of Operating Unit Field Block IF (:<your block _id> IS NOT NULL ) THENIF :<block _id><>nvl(:<parameter.old_org_id>,-99) THEN mo_global.set_policy_context('S', :_id);-- Get the cache for the current orgEND IF;ELSE -- :_id is null, so set the context to multiplemo_global.set_policy_context('M', null);-- Refresh the cacheEND IF;Pre-Insert Trigger of Operating Unit Field BlockUse this trigger if the form allows the user to commit multiple records. IF (:<your block _id> IS NOT NULL ) THENIF :<block _id><>nvl(:<parameter.old_org_id>,-99) THEN mo_global.set_policy_context('S', :_id);-- Get the cache for the current orgEND IF;ELSE -- :_id is null, so set the context to multiplemo_global.set_policy_context('M', null);-- Refresh the cacheEND IF;Pre-Query Trigger of Operating Unit Field BlockBEGINIF :parameter.mo_ou_count = 1 THENmo_global.set_policy_context(‘S’,:parameter.mo_default_org_id);ELSEmo_global.set_policy_context('M', null);END IF;-- Other CodeEND;Pre-Record Trigger of Operating Unit Field Blockuse this trigger if the form forces the user to commit each record.IF (:parameter.current_record is not null and:parameter.current_record != :system.trigger_record) THENIF (:system.form_status in ('CHANGED','INSERT')) THENmo_global.set_policy_context('S', :parameter.old_org_id);-- Get the cache for the current org-- raise error message to the user to commit;-- raise form_trigger_failure;ELSE-- No pending commits.-- Reset the current record variable.:parameter.current_record := '';END IF;ELSE-- User has not navigated to another record.-- Do not reset the current record variable.null;END IF;Pre-Update TriggerUse this trigger if the form allows the user to commit multiple records commits that are in different operating units.IF (:<your block _id> IS NOT NULL ) THENIF :<block _id><>nvl(:<parameter.old_org_id>,-99) THENmo_global.set_policy_context('S', :_id);-- Get the cache for the current orgEND IF;END IF;十一、设置金额显示格式PROCEDURE FORMAT_PRICE(EVENT VARCHAR2) ISBEGINIF (EVENT IN ('WHEN-VALIDATE-ITEM','POST-QUERY'))THENAPP_ITEM_PROPERTY.SET_PROPERTY('LINES.SUGGESTED_PRICE',FORMAT_MASK, FND_ CURRENCY.GET_FORMAT_MASK(:ORDERS.CURRENCY_CODE,GET_ITEM_PROPERTY('LINES.S UGGESTED_PRICE',MAX_LENGTH)));APP_ITEM_PROPERTY.SET_PROPERTY('LINES.TOTAL_PRICE',FORMAT_MASK, FND_CU RRENCY.GET_FORMAT_MASK(:ORDERS.CURRENCY_CODE,GET_ITEM_PROPERTY('LINES.TOT AL_PRICE',MAX_LENGTH)));ELSEFND_MESSAGE.DEBUG('Invalid event passed to lines.format_price '||EVENT);END IF;END FORMAT_PRICE;十二、获取当前窗口GET_VIEW_PROPERTY(GET_ITEM_PROPERTY(:SYSTEM.CURSOR_ITEM,ITEM_CANVAS),WINDOW_NAME)十三、异常处理代码BEGINXxx;EXCEPTION WHEN OTHERS THEN:PACK_LINE_V.QUANTITY_CANCEL:=NULL;END;十四、提示框IF :CTR_PACK.SUM_QUERITY<sum_quantity and :PACK_HEADER_V.PACK_STATUS='SHIPPED' THENFND_MESSAGE.set_name('OMS','装箱数量不能小于已装柜数量！');FND_MESSAGE.error;raise form_trigger_failure;END IF;十五、信息提示框之基本用法1、messageUsage：message('提示信息');Effect：在FORMS 左下角会出现这个提示信息。

合集下载

新概念第四册课文翻译及学习笔记：Lesson18

新概念第四册课文翻译及学习笔记：Lesson18

新概念第四册课文翻译及学习笔记：Lesson18【课文】First listen and then answer the following question.听录音，然后回答以下问题。

What would you say is the main characteristic of porpoises?There has long been a superstition among mariners that porpoises will save drowning men by pushing them to the surface, or protect them from sharks by surrounding them in defensive formation. Marine Studio biologists have pointed out that, however intelligent they may be, it is probably a mistake to credit dolphins with any motive of lifesaving. On the occasions when they have pushed to shore an unconscious human being they have much more likely done it out of curiosity or for sport, as in riding the bow waves of a ship. In 1928 some porpoises were photographed working like beavers to push ashore a waterlogged mattress. If, as has been reported, they have protected humans from sharks, it may have been because curiosity attracted them and because the scent of a possible meal attracted the sharks. Porpoises and sharks are natural enemies. It is possible that upon such an occasion a battle ensued, with the sharks being driven away or killed.Whether it be bird, fish or beast, the porpoise is intrigued with anything that is alive. They are constantly after the turtles, who peacefully submit to all sorts of indignities. One young calf especially enjoyed raising a turtle to the surface with his snout and then shoving him across the tank like an aquaplane. Almost any day a young porpoise may be seen trying to turn a 300-pound sea turtle over by sticking his snout under the edge of his shell and pushing up for dear life. This is not easy, and may require two porpoises working together. In another game, as the turtle swims across the oceanarium, the first porpoise swoops down from above and butts his shell with his belly. This knocks the turtle down several feet. He no sooner recovers his equilibrium than the next porpoise comes along and hits him another crack. Eventually the turtle has been butted all the way down to the floor of the tank. He is now satisfied merely to try to stand up, but as soon as he does so a porpoise knocks him flat. The turtle at last gives up by pulling his feet under his shell and the game is over.RALPH NADING HILL Window in the Sea【New words and expressions 生词和短语】porpoise n. 海豚mariner n. 水手shark n. 鲨鱼formation n. 队形dolphin n. 海豚科动物unconscious adj. 不省人事beaver n. 海狸ashore adv. 上岸waterlogged adj. 浸满水的scent n. 香味ensue v. 接着发生intrigue v. 引起兴趣indignity n. 侮辱snout n. 口鼻部shove v. 硬推aquaplane n. 驾浪滑水板oceanarium n. 水族馆swoop v. 猛扑belly n. 腹部equilibrium n. 平衡butt v. 碰撞crack n. 重击【课文注释】1.however intelligent they may be，不管它们有多聪明，这是一个让步状语从句，相当于no matter how intelligent they may be。

form的用法和短语例句

form的用法和短语例句

form的用法和短语例句在英语中，“form”是一个多义词，可以用作名词、动词和短语。

在本文中，将探讨”form”的不同用法以及一些常见的短语例句。

作为名词的用法作为名词，“form”通常表示一种形式、表格或类型。

例如： - Please fill out this application form. - The students are required to submit a consent form signed by their parents. - This novel is written in the form of a diary.除了表示表格或形式外，“form”还可以指体格、形状或外貌。

例如： - She has a slim form that makes her a successful model. - The artist captured the graceful form of a dancer in his painting. - The sculpture beautifully captures the natural forms of the human body.作为动词的用法作为动词，“form”常用来表示组成、构成或塑造的意思。

例如： - The team was formed by a group of dedicated individuals. - Knowledge is formed through a combination of learning and experience. - The clouds began to form in the sky, indicating an upcoming storm.此外，“form”还可以表示形成某种看法、印象或关系。

例如： - Their friendship formed during a difficult time in their lives. - Over time, a strong bond formed between the teacher and her students. - The events of that day formed the basis for her decision to pursue a new career.短语例句除了单独使用外，“form”还常出现在多个短语中，以下是一些常见的短语例句： - Form a habit: It takes time to form a new habit, but consistency is key. - In the form of: The information was presented in the form of a detailed report. - Take the form of: His anger took the form of a stern lecture on responsibility. - Form an opinion:It’s important to gather all the facts before forming an opinion. - Form a circle: The children formed a circle around the storyteller.总的来说，“form”是一个多功能的词汇，在不同语境中有着不同的意义和用法。

FineReport帆软报表相关学习笔记,纪要

FineReport帆软报表相关学习笔记,纪要

FineReport帆软报表相关学习笔记,纪要作为⼀个学习Java的程序猿,来到公司之后却被外派出去学习ERP的相关开发,回来之后⼜让做"帆软"报表的填报报表,我也是相当的⽆赖啊由于以前没接触过帆软的报表系统,只有慢慢摸索着做了........(先⼼疼⾃⼰⼏秒,咱不哭)下⾯就写点⾃⼰在这期间的⼀些笔记,纪要,乱七⼋糟的,,,吧,随机更新,可能内容有点乱,⼤家看了不要烦躁,不要骂我哦(反正骂了我也不知道,哈哈哈/////////)1.oracle数据库，转换⽇期格式函数 to_date(20121223,yyyy-mm-dd)返回为：2012-12-23 to_char(sysdate,yyyy/mm/dd hh24:mi:ss)，返回值为2011/05/09 21:14:41 to_char(sysdate,hh24:mi:ss)，返回值为21:14:412.获取不同格式的当前时间 format(now(), "yyyyMMddHHmmss")，返回值为20180714150611 now()，返回值为当前时间 today()，返回值为当前⽇期3.在填报模板中，对于填报成功后的⼀些操作 (1) 填报成功直接关闭窗⼝ 点击模板>模板web属性>填报页⾯设置，然后添加填报成功事件，输⼊js脚本: window.close(); (2) 填报成功跳转到另⼀个窗⼝ 点击模板>模板web属性>填报页⾯设置，然后添加填报成功事件，输⼊js脚本: window.open("⽹址","_self");4.单元格为null时如何设置它的默认值为05. UUID随机数的⽣成及截取 ⽣成UUID: =UUID() 截取16位长度的UUID数: left(REPLACE(uuid(),'-',''),16)6.填报报表内容未填完就提交时报错 设置数据校验,添加保存7.填报报表显⽰值是中⽂,但是⼊库值是对应的代码(1234)设置: 单元格属性再多设置⼀次即可8.填报成功之后发送邮件并关闭窗⼝: 代码:var fm;if(this.options){fm = this.options.form;}if(fm == null) {fm = window.FR}fm.sentMail({xmlconf:"<?xml version=\"1.0\" encoding=\"UTF-8\"?><R xmlVersion=\"20151125\" releaseVersion=\"8.0.0\"class=\"com.fr.js.EmailJavaScript\"><Parameters/><EmailJS mailTo=\"邮箱地址\" cc=\"\" bcc=\"\" title=\"邮件抬头\" mainText=\"邮件内容\" showTplContent=\"false\"/><\/R>"});window.close(); //关闭窗⼝。

C#学习笔记12-17

C#学习笔记12-17

C#学习笔记121、Winform应用程序是一种智能客户端技术，我们可以使用winform应用程序帮助我们获得信息或者传输信息等。

2、属性Name：在后台要获得前台的控件对象，需要使用Name属性。

visible：指示一个控件是否可见。

Enabled：指示一个控件是否可用。

3、事件：发生一件事情。

注册事件。

（双击控件注册的都是控件默认被选中的那个事件。

）触发事件4、在Main函数当中创建的窗体对象，我们称之为这个Winform的主窗体。

也就意味着，当你将主窗体关闭后，整个应用程序都关闭了。

5、TextBox控件中的一些比较重要的属性WordWrap:指示文本框是否换行。

PasswordChar：让文本框显示一个单一的字符ScollBars：是否显示滚动条事件：TextChanged 当文本框中的内容发生改变的时候触发这个事件。

6、跑马灯练习abcde bcdeastring str="abcde";str=str.Substring(1)+str.Substring(0,1);7、Timer:在指定的时间间隔内做一件指定的事情。

8、简单记事本应用程序1)、在程序加载的时候，取消文本框的自动换行，以及让两个按钮和文本框隐藏2)、点击登陆，判断是否登陆成功3)、自动换行功能4)、保存文本到一个指定目录下。

9、单选和多选checkBox: checked：指示这个控件是否处于选中状态。

默认情况下，在一个窗体中，所有的单选按钮只允许选中一个，可以使用groupBox进行分组。

10、MDI窗体的设计1、首先确定一个父窗体。

将IsMdiContainer设置为true。

2、创建子窗体，并且设置他们的父窗体。

C#学习笔记131、Directory 操作文件夹（常用的方法）CreateDirectory 创建文件夹Delete 删除文件夹Move 剪切文件夹Exist 判断是否存在GetFiles 获得指定的目录下所有文件的全路径GetDirectory 获得指定目录下所有文件夹的全路径2、WebBrowser浏览器控件url3、ComboBox下拉框控件DropDownStyle：控制下拉框的外观样式名字：cbo+....案例：日期选择器4、点击更换图片:在程序加载的时候，将指定图片文件夹中所有的图片文件名读取到ListBox中5、石头剪刀布:石头1 剪刀2 布 3 玩家赢了： 1 2=-1 2 3=-1 3 1=2 平手：相减=0 另外一种情况：电脑赢了6、对话框OpenFileDialog SaveFileDialogOpenFileDialog ofd = new OpenFileDialog();ofd.Title = "Please choose";ofd.Multiselect = true;ofd.InitialDirectory = @"C:\Users\hongli\Desktop";ofd.Filter = "txt|*.txt";ofd.ShowDialog();7、进程:我们可以把计算机中每一个运行的应用程序都当做是一个进程。