摘要: 1 for c in (select column_value from table(f_split(V_FileID, ','))) loop 2 --若没有填写资格开始结束时间,则填入 3 select count(*) 4 into numDataCount 5 from ly_zg_jzfbt z 6 w... 阅读全文
posted @ 2019-03-27 20:51 王小鹏 阅读(1759) 评论(0) 推荐(0) 编辑
摘要: 外链接 select d.user_id,d.user_realname,u.fax,u.userphone,u.office_phone,u.room_num, (select decode(count(*),'0','授权查看','取消授权') from oa_userbigrole r where r.user... 阅读全文
posted @ 2019-03-27 20:49 王小鹏 阅读(95) 评论(0) 推荐(0) 编辑
摘要: 1 protected void btnImport_Click(object sender, EventArgs e) 2 { 3 string strName = ""; 4 string strFileTailName = ""; 5 String strError = string.Empty; 6 ... 阅读全文
posted @ 2019-03-27 20:46 王小鹏 阅读(165) 评论(0) 推荐(0) 编辑
摘要: 1 /* 2 办件流转 3 */ 4 procedure P_DoFileFlow(varError out varchar2, 5 varWaitID in varchar2, 6 varFlowID in varchar2,... 阅读全文
posted @ 2019-03-27 20:45 王小鹏 阅读(221) 评论(0) 推荐(0) 编辑