摘要:protectedvoidgrid_ItemCreated(objectsender,DataGridItemEventArgse){if(e.Item.ItemType==ListItemType.Header){e.Item.SetRenderMethodDelegate(newRenderMethod(NewRenderMethod));}elseif(e.Item.ItemType==Li...
阅读全文
摘要:var OnInit;var OnNodeChecked;function initchecknode(TreeView1){ //获得需要初始化选择状态的节点的字符串. var selectedNodes = document.getElementById("corpList").value; var arrayNodes = new Array(); arrayNode...
阅读全文
摘要:包头: create or replace package GetMonthPlan is TYPE T_MonthPlan IS REF CURSOR; Procedure p_GetMonthStockPlan(sYear in varchar, sMonth in varchar, ...
阅读全文
摘要:--创建记录 TYPE REC_PERSON IS RECORD( PersonSID varchar2(50), PersonName varchar2(60), Gender varchar2(10), DepartSID varchar2(50), IsSaler char(1), IsAgent char(1), IsDel...
阅读全文
摘要:sSQL := 'alter session close database link ' || sDataSource; execute immediate sSQL;
阅读全文
摘要:TYPE V_CUR IS REF CURSOR; CUR V_CUR;open CUR for sSQL; LOOP FETCH CUR INTO R_PERSON; EXIT WHEN CUR%NOTFOUND; i := i+ 1; table_person_list(i) := R_PERSON; END LOOP; CLOSE CUR;
阅读全文
摘要:select NVL(count(Sequence_Name), 0) into nCount from all_sequences where Sequence_Owner = 'LSP' and Sequence_Name = 'SEQ_SHELFID'; if nCount > 0 then sSQL := 'drop sequence LSP.SEQ_SHE...
阅读全文
摘要:for cura in (select DeptId,parentId from lsp.lbi_department where parentId = curId order by DeptId) loop insert into TMP_TEST(id,parentId) values(cura.id,cura.parentId); Insert...
阅读全文
摘要:select count(*) into nCount from user_tables where table_name = 'TT_DEPARTPERSONRELATION';sSQL := 'Create global temporary table TT_DepartPersonRelation( DepartSID varchar2(50), Pers...
阅读全文
摘要:update f_shortforest forest set forest.forestquantity = (select (decode(sum(detail.quantity), null, 0, ...
阅读全文
摘要:MERGE INTO course cUSING (SELECT course_name, period,course_hoursFROM course_updates) cuON (c.course_name = cu.course_nameAND c.period = cu.period)WHEN MATCHED THENUPDATESET c.course_hours = cu.course...
阅读全文
摘要:后台代码: protected void Page_Load(object sender, System.EventArgs e) { // This page makes the contents of the dataset available as an XML file // that the javascript XmlHttp...
阅读全文
摘要:这一个简单的文本框控件主要实现在了IPostBackDataHandler, IEditableTextControl, ItextControl三个接口。IPostBackDataHandler IEditableTextControl主要有事件event EventHandler TextChanged;有ItextControl主要有一个Text属性接口说明:IPostBackDataHan...
阅读全文
摘要:第一次加载主要事件如下:1:TrackViewState2:OnPreRender3:SaveViewState()4:Render回传时页面加载主要事件如下: page.isPostBack1:TrackViewState2:LoadViewState3:LoadPostData4:RaisePostDataChangedEvent5RaisePostBackEvent6:OnPreRender...
阅读全文