\u5c06\u67d0\u4e2a\u5b50\u76ee\u5f55\u4e0b\u7684\u6240\u6709\u6587\u6863\u5171\u4eab\u7ed9\u67d0\u4e2a\u4eba\u67e5\u770b\u6743\u9650<\/p>\n
insert into docshare(docid,sharetype,seclevel,rolelevel,sharelevel,userid,foralluser,downloadlevel) select id,1,0,0,1,\u7528\u6237id,0,1 from docdetail where seccategory=\u5b50\u76ee\u5f55id<\/p>\n
\u8003\u52e4\u8868 \u79fb\u52a8\u8f68\u8ff9\u4e1a\u52a1\u7b7e\u5230\u8868
\n–\u8003\u52e4\u7b7e\u5230\u8868\uff1a
\nselect * from hrmschedulesign;
\n–\u79fb\u52a8\u8f68\u8ff9\u7b7e\u5230\u8868\uff1a(\u5305\u542b \u8003\u52e4\u7b7e\u5230\u8868hrmschedulesign\u7684\u6570\u636e)
\nselect * from mobile_sign;<\/p>\n
8.0\u4e2d\u5c06\u7b2c\u4e00\u4e2a\u8282\u70b9\u6279\u91cf\u8bbe\u7f6e\u4e3a\u53ef\u5f3a\u5236\u5f52\u6863\u3002
\nupdate workflow_function_manage ss
\nset pigeonhole = ‘1’
\nwhere exists (select *
\nfrom (select workflowid, min(operatortype) nodeid
\nfrom workflow_function_manage
\nwhere operatortype > 0
\ngroup by workflowid) t
\nwhere t.workflowid = ss.workflowid
\nand t.nodeid = ss.operatortype)<\/p>\n
\u4eba\u5458\u5934\u50cf\u3001\u4eba\u5458\u7167\u7247\u8def\u5f84\u5b58\u50a8\u6570\u636e\u8868\u5b57\u6bb5\uff1a
\n1.\u4eba\u5458\u7684\u7167\u7247\u5b58\u653e\u5728\u670d\u52a1\u5668\u7684\u8def\u5f84 \u67e5\u8be2\u5982\u4e0b\uff1a
\n–imagefile\u8868\u5b57\u6bb5filerealpath\u5b58\u50a8\u6587\u4ef6\u8def\u5f84
\nselect a.id,
\na.loginid,
\na.lastname,
\na.status,
\na.resourceimageid,
\nb.imagefileid,
\nb.imagefilename,
\nb.imagefiletype,
\nb.filerealpath
\nfrom hrmresource a, imagefile b
\nwhere a.resourceimageid = b.imagefileid
\nand id=24
\nand (a.resourceimageid != 0 or a.resourceimageid != ”);
\n–2\u3001\u4eba\u5458\u5934\u50cf\u76f8\u5173\uff1a
\n–HrmResource\u8868\u5b57\u6bb5messagerurl\u5b58\u50a8\u6587\u4ef6\u8def\u5f84
\nselect HrmResource. from HrmResource where id=’\u4eba\u5458id’;
\n–imagefile\u8868\u5b57\u6bb5filerealpath\u5b58\u50a8\u6587\u4ef6\u8def\u5f84
\nselect * from imagefile where filerealpath =’\u6587\u4ef6\u8def\u5f84’;
\nselect messagerurl from HrmResource;<\/p>\n
\u5982\u4f55\u5220\u9664\u5de5\u4f5c\u5fae\u535a
\nselect * from blog_discuss where userid= \u53d1\u8868\u4ebaid order by id desc
\n\u8fd9\u4e2a\u67e5\u8be2\u8fd9\u4e2a\u4eba\u53d1\u8868\u7684\u6240\u6709\u5185\u5bb9
\ndelete from blog_discuss where id=\u5fae\u535aid
\n\u627e\u5230\u5185\u5bb9\u540e\uff0c\u7528id\u5220\u9664<\/p>\n
\u5982\u679c\u8981\u5728\u3010\u8bf7\u5047\u7c7b\u578b\u3011\u4e3a”\u5176\u5b83\u5e26\u85aa\u5047”\u4e0b\u7684\u3010\u5176\u4ed6\u8bf7\u5047\u7c7b\u578b\u3011
\n\u589e\u52a04\u4e2a\u7c7b\u578b\uff1a{\u6362\u4f11\u3001\u8282\u80b2\u624b\u672f\u5047\u3001\u770b\u62a4\u5047\u3001\u751f\u7406\u5047}
\nSQL\u8bed\u53e5\u5982\u4e0b\uff1a
\n(1)\u5148\u67e5\u8be2\uff1a\u901a\u8fc7\u539f\u3010\u5176\u4ed6\u8bf7\u5047\u7c7b\u578b\u3011\u4e2d’\u54fa\u4e73\u5047’\u6765\u786e\u5b9a\u5176fieldid\u503c\u4e3a655
\nselect * from workflow_SelectItem where selectname=’\u54fa\u4e73\u5047’;
\nselect * from workflow_SelectItem where fieldid=655;<\/p>\n
(2)\u6267\u884c\u5982\u4e0b\u65b0\u589e\u8bed\u53e5\uff1a
\ninsert into workflow_SelectItem(fieldid,isbill,selectvalue,selectname,listorder,isdefault,isAccordToSubCom) values(655,1,12,’\u6362\u4f11’,12.00,’n’,0)
\ngo
\ninsert into workflow_SelectItem(fieldid,isbill,selectvalue,selectname,listorder,isdefault,isAccordToSubCom) values(655,1,13,’\u8282\u80b2\u624b\u672f\u5047’,13.00,’n’,0)
\ngo
\ninsert into workflow_SelectItem(fieldid,isbill,selectvalue,selectname,listorder,isdefault,isAccordToSubCom) values(655,1,14,’\u770b\u62a4\u5047’,14.00,’n’,0)
\ngo
\ninsert into workflow_SelectItem(fieldid,isbill,selectvalue,selectname,listorder,isdefault,isAccordToSubCom) values(655,1,15,’\u751f\u7406\u5047’,15.00,’n’,0)
\ngo<\/p>\n
(3)\u5c4f\u853d\u6389\u4e0d\u9700\u8981\u7684\u5047\u522b\uff1a
\nupdate workflow_SelectItem set workflow_SelectItem.Cancel=’1′ where fieldid=655 and id=89
\ngo<\/p>\n
\u67e5\u8be2OA\u6d41\u7a0b\u4e2d\u8282\u70b9\u51fa\u73b0\u8d85\u65f6\u5185\u5bb9\u7684\u8bb0\u5f55\u6570
\nselect A.*,B.workflowname,c.lastname from workflow_requestLog A left outer join workflow_base B
\non A.workflowid=B.id
\nleft outer join hrmresource C
\non A.operator=c.id
\nwhere A.remark like ‘%\u8be5\u5ba1\u6279\u8282\u70b9\u5df2\u8d85\u65f6\uff0c\u7cfb\u7edf\u9ed8\u8ba4\u540c\u610f\u5e76\u8df3\u8fc7%’
\norder by workflowid<\/p>\n
\u67e5\u8be2OA\u6d41\u7a0b\u4e2d\u8282\u70b9\u51fa\u73b0\u8d85\u65f6\u5185\u5bb9\u7684\u8bb0\u5f55\u6570\uff08\u589e\u52a0\u4e86\u6d41\u7a0b\u6807\u9898\u540d\uff09
\nselect A.*,B.workflowname as ‘\u8d85\u65f6\u6d41\u7a0b\u540d’,c.lastname as ‘\u8d85\u65f6\u64cd\u4f5c\u4eba\u540d’,D.requestname as ‘\u8d85\u65f6\u6d41\u7a0b\u6807\u9898’
\nfrom workflow_requestLog A left outer join workflow_base B
\non A.workflowid=B.id
\nleft outer join hrmresource C
\non A.operator=c.id
\nleft outer join workflow_requestbase D
\non A.requestid=D.requestid
\nwhere A.remark like ‘%\u8be5\u5ba1\u6279\u8282\u70b9\u5df2\u8d85\u65f6\uff0c\u7cfb\u7edf\u9ed8\u8ba4\u540c\u610f\u5e76\u8df3\u8fc7%’
\norder by workflowid<\/p>\n
E7\u90e8\u95e8\u3001\u5206\u90e8\u81ea\u5b9a\u4e49\u81ea\u5b57\u6bb5\u8868\u76f8\u5173\uff1a
\n–\u5206\u90e8\u8868
\nselect * from hrmsubcompany;
\n–\u5206\u90e8\u81ea\u5b9a\u4e49\u8868:fieldname\u5b57\u6bb5\u503c\u5bf9\u5e94\u5c31\u662f\u5206\u90e8\u8868\u4e2d\u5bf9\u5e94\u7684\u4e00\u5217
\nselect * from subcompanydefinefield;
\n–\u548c\u6d41\u7a0b\u5173\u8054\u8868\uff1a\u5173\u8054\u5206\u90e8\u81ea\u5b9a\u4e49\u5b57\u6bb5 subcompanyfield
\nselect * from workflow_groupdetail;
\n–\u90e8\u95e8\u8868
\nselect * from hrmdepartment;
\n–\u90e8\u95e8\u81ea\u5b9a\u4e49\u8868:fieldname\u5b57\u6bb5\u503c\u5bf9\u5e94\u5c31\u662f\u90e8\u95e8\u8868\u4e2d\u5bf9\u5e94\u7684\u4e00\u5217
\nselect * from departmentdefinefield;
\n–\u548c\u6d41\u7a0b\u5173\u8054\u8868\uff1a\u5173\u8054\u90e8\u95e8\u81ea\u5b9a\u4e49\u5b57\u6bb5 deptfild
\nselect * from workflow_groupdetail;
\n——E8\u5206\u90e8\u3001\u90e8\u95e8 \u81ea\u5b9a\u4e49\u5b57\u6bb5\u8868\uff1a
\n–1\u3001\u5206\u90e8\u57fa\u7840\u8868
\nSELECT * FROM HrmSubCompany
\n–2\u3001\u5206\u90e8\u81ea\u5b9a\u4e49\u5b57\u6bb5\u6570\u636e\u5b58\u50a8\u8868
\nSELECT * FROM HrmSubcompanyDefined
\n–3\u3001\u90e8\u95e8\u57fa\u7840\u8868
\nSELECT * FROM HrmDepartment
\n–4\u3001\u90e8\u95e8\u81ea\u5b9a\u4e49\u5b57\u6bb5\u6570\u636e\u5b58\u50a8\u8868
\nSELECT * FROM HrmDepartmentDefined
\n–5\u3001\u5206\u90e8\u3001\u90e8\u95e8\u81ea\u5b9a\u4e49\u5b57\u6bb5\u7c7b\u578b\u4fe1\u606f\u5b58\u50a8\u8868\uff1a
\n–\u901a\u8fc7\u5206\u7ec4\u8868hrm_fieldgroup\u4e2dgrouptype\u503c\u533a\u522b\u662f\u5206\u90e8\u3001\u90e8\u95e8\u81ea\u5b9a\u4e49\u5b57\u6bb5\uff1a
\n–\u4e2a\u4eba\u57fa\u7840\u4fe1\u606f\u56fa\u5b9a\u5b57\u6bb5\uff08grouptype:-1\uff09\u3001\u4e2a\u4eba\u4fe1\u606f\u56fa\u5b9a\u5b57\u6bb5\uff08grouptype:1\uff09\u3001\u5de5\u4f5c\u4fe1\u606f\u56fa\u5b9a\u5b57\u6bb5\uff08grouptype:3\uff09\u3001\u5206\u90e8\uff08grouptype:4\uff09\u3001\u90e8\u95e8\uff08grouptype:5\uff09\u6240\u6709\u5b57\u6bb5\u5b9a\u4e49
\nSELECT * FROM hrm_formfield;
\n–6\u3001\u5206\u7ec4\u8868
\nSELECT * FROM hrm_fieldgroup;<\/p>\n
\u4fee\u6539\u6388\u6743\u9875\u9762
\n\\ecology\\systeminfo\\version.jsp
\n\u524d\u7aef\u7248\u672c\u4fee\u6539\u9875\u9762\uff08\u5173\u952e\u5b57showVersion\uff09
\n\\ecology\\wui\\theme\\ecology8\\page\\toolbar.jsp
\n\u540e\u7aef\u7248\u672c\u4fee\u6539\u9875\u9762\uff08\u5173\u952e\u5b57showVersion\uff09
\n\\ecology\\wui\\theme\\ecology8\\page\\toolbarForMiddle.jsp<\/p>\n
\u4fee\u6539\u6388\u6743\u540d\u79f0
\nselect * from
\nHtmlLabelInfo where indexid=23714<\/p>\n
update HtmlLabelInfo set labelname = ‘XXXXXXXXXXX’ where indexid = ‘23714’ and languageid = ‘7’
\nupdate HtmlLabelInfo set labelname = ‘XXXXXXXXXXX’ where indexid = ‘23714’ and languageid = ‘8’
\nupdate HtmlLabelInfo set labelname = ‘XXXXXXXXXXX’ where indexid = ‘23714’ and languageid = ‘9’<\/p>\n
\u4fee\u6539\u4eba\u4e8b\u6863\u6848\u72b6\u6001
\n\u4fee\u6539\u67d0\u4e00\u4e2a\u4ebaupdate HrmResource set status=1 where id= \uff1f\uff1f\u3001
\n\u6570\u636e\u5e93\u8868\u4e3a\uff1aHrmResource\u6267\u884c\u4ee5\u4e0b\u8bed\u53e5
\nupdate HrmResource set status=1
\n0\uff1a\u8bd5\u7528
\n1\uff1a\u6b63\u5f0f
\n2\uff1a\u4e34\u65f6
\n3\uff1a\u8bd5\u7528\u5ef6\u671f
\n4\uff1a\u89e3\u8058
\n5\uff1a\u79bb\u804c
\n6\uff1a\u9000\u4f11
\n7\uff1a\u65e0\u6548<\/p>\n
\u4fee\u6539\u6240\u6709\u4eba\u7684\u5bc6\u7801\u4e3a1
\nupdate hrmresource set password=’C4CA4238A0B923820DCC509A6F75849B’
\n\u66f4\u6539\u6240\u6709\u7ba1\u7406\u5458\u7684\u5bc6\u7801\u4e3a1
\nupdate hrmresourcemanager set password=’C4CA4238A0B923820DCC509A6F75849B’<\/p>\n
\u67e5\u8be2\u4e0b\u67d0\u4e2a\u76ee\u5f55\u7684\u6587\u6863\u5171\u4eab\u60c5\u51b5
\nselect a.docsubject,a.doccreatedate, a.doccreatetime
\n,case when b.type=1 then ‘\u4e2a\u4eba’ when b.type=2 then ‘\u5206\u90e8’ when b.type=3 then ‘\u90e8\u95e8’ when b.type=5 then ‘\u6240\u6709\u4eba’ else ‘\u5176\u4ed6’ end \u6743\u9650\u7c7b\u578b
\n,b.content,h.lastname,s.subcompanyname,d.departmentname
\n,case when b.sharelevel=1 then ‘\u67e5\u770b’ when b.sharelevel=2 then ‘\u7f16\u8f91’ when b.sharelevel=3 then ‘\u5168\u90e8’ else ‘\u5176\u4ed6’ end \u5171\u4eab\u60c5\u51b5
\nfrom DocDetail a join shareinnerdoc b on a.id=b.sourceid and a.seccategory=\u76ee\u5f55id
\nleft join HrmResource h on b.content=h.id and b.type=1
\nleft join HrmSubCompany s on b.content=s.id and b.type=2
\nleft join HrmDepartment d on b.content=d.id and b.type=3
\norder by a.doclastmoddate ,a.doclastmodtime desc<\/p>\n
\u7edf\u8ba1\u67d0\u4eba\u5728\u67d0\u6bb5\u65f6\u95f4\u5185\u5728\u7cfb\u7edf\u5404\u534f\u4f5c\u533a\u7684\u53d1\u8a00\u60c5\u51b5\u2014\u2014
\nselect items.id \u534f\u4f5c\u7f16\u53f7,items.name \u534f\u4f5c\u540d\u79f0
\n,hrm.lastname \u53d1\u8a00\u4eba,discuss.createdate \u53d1\u8868\u65e5\u671f,discuss.createtime \u53d1\u8868\u65f6\u95f4
\n,discuss.floornum \u697c\u53f7,discuss.remark \u53d1\u8a00\u5185\u5bb9
\nfrom cowork_discuss discuss
\njoin cowork_items items on discuss.coworkid = items.id
\njoin hrmresource hrm on discuss.discussant = hrm.id
\nwhere hrm.loginid=’\u4eba\u5458\u767b\u5f55\u53f7’ and discuss.createdate between ‘\u5f00\u59cb\u65e5\u671f’ and ‘\u7ed3\u675f\u65e5\u671f’
\norder by items.createdate,items.name,discuss.createdate,discuss.createtime;<\/p>\n
\u6279\u91cf\u9690\u85cf\u524d\u53f0\u5de6\u4fa7\u83dc\u5355sql
\nupdate leftmenuconfig set visible = 0 where infoid = ‘\u83dc\u5355ID’
\n\u6279\u91cf\u9690\u85cf\u540e\u53f0\u83dc\u5355sql
\nupdate mainmenuconfig set visible = 0 where infoid = ‘\u83dc\u5355ID’<\/p>\n
\u5220\u9664\u5df2\u53d1\u9001\u7684\u5185\u90e8\u90ae\u4ef6
\nselect* from rom mailresource where subject like ‘%\u90ae\u4ef6\u6807\u9898%’
\ndelete from mailresource where subject like ‘%\u90ae\u4ef6\u6807\u9898%’<\/p>\n
–\u67e5\u8be2\u6d41\u7a0b\u5bf9\u5e94\u6570\u636e\u5e93\u8868\u540d\uff1a
\nselect b.tablename from workflow_bill b ,workflow_base s,workflow_requestbase t where t.requestid=’35389′ and t.workflowid = s.id and b.id=s.formid
\n–\u67e5\u8be2\u67d0\u6761\u6d41\u7a0b\u5bf9\u5e94\u6570\u636e\u5e93\u8868\u5355\u5185\u5bb9\uff1a
\nselect * from formtable_main_60 where requestid=’35389′
\n–\u4fee\u6539\u67d0\u6761\u6d41\u7a0b\u5bf9\u5e94\u6570\u636e\u5e93\u8868\u5355\u5185\u5bb9\uff1a
\nupdate formtable_main_60 set sqrq=’2015-08-04′ ,lcbh=’308201508041961′ where requestid=’35387′
\n–\u67e5\u8be2\u8be5\u6d41\u7a0b\u5bf9\u5e94\u7684\u7b7e\u5b57\u610f\u89c1\u680f\u4f4d\uff1a
\nselect * from workflow_requestlog where requestid=’35389’and operatedate=’2015-11-03′
\n–\u4fee\u6539\u8be5\u6d41\u7a0b\u5bf9\u5e94\u7684\u7b7e\u5b57\u610f\u89c1\u680f\u4f4d\uff1a
\nupdate workflow_requestlog set operatedate=’2015-08-04′ where requestid=’35389’and operatedate=’2015-11-03′
\n–\u67e5\u8be2\u6d41\u7a0b\u7684\u6d41\u7a0b\u72b6\u6001
\nSelect * from workflow_currentoperator where requestid=’35389’and operatedate=’2015-11-03′
\n–\u4fee\u6539\u6d41\u7a0b\u7684\u6d41\u7a0b\u72b6\u6001
\nupdate workflow_currentoperator set receivedate=’2015-08-04′ where requestid=’35389’and receivedate=’2015-11-03′
\n–\u67e5\u8be2\u6d41\u7a0b\u7684\u6d41\u7a0b\u6807\u9898
\nSelect * from workflow_requestbase where requestid=’35387′
\n–\u4fee\u6539\u6d41\u7a0b\u7684\u6d41\u7a0b\u6807\u9898\u3001\u6d41\u7a0b\u72b6\u6001\u680f\u76ee\u3001\u67e5\u8be2\u6d41\u7a0b\u9875\u9762\u4e2d\u7684\u521b\u5efa\u65f6\u95f4\u3001\u66f4\u65b0\u65f6\u95f4
\nupdate workflow_requestbase set createdate=’2015-08-04′,lastoperatedate=’2015-08-04′,requestmark=’308201508041961′,
\nrequestname=’JZHT-3.08\u4ed8\u6b3e\u5ba1\u6279\u6d41\u7a0b\uff08\u975e\u9500\u552e\uff09-\u603b\u90e8-\u65b9\u6b63-2015-08-04’where requestid=’35388′
\n–\u67e5\u8be2\u6d41\u7a0b\u7684\u6d41\u7a0b\u72b6\u6001
\nSelect * from workflow_currentoperator where requestid=’35389’and operatedate=’2015-11-04′
\nSelect * from workflow_currentoperator where requestid=’35389’and receivedate = ‘2015-11-03′
\n–\u4fee\u6539\u6d41\u7a0b\u7684\u6d41\u7a0b\u72b6\u6001
\nupdate workflow_currentoperator set operatedate=’2015-08-04′ where requestid=’35389’and operatedate=’2015-11-04′
\nupdate workflow_currentoperator set receivedate=’2015-08-04′ where requestid=’35389’and receivedate=’2015-11-04’<\/p>\n
\u67e5\u8be2\u5df2\u7ecf\u5b89\u88c5\u4e86\u54ea\u4e9b\u5347\u7ea7\u5305\uff1a
\nselect * from ecologyuplist order by label<\/p>\n
\u5df2\u7ecf\u4f7f\u7528\u7684\u6d6e\u70b9\u6570\uff0c\u9700\u8981\u4fee\u6539\u5c0f\u6570\u4f4d\uff08\u53ea\u9002\u7528\u4e8eSQL server\uff0c3\u4e3a\u5176\u4e2d\u5c0f\u6570\u4f4d\uff09\uff1a
\nupdate workflow_billfield set fielddbtype = ‘decimal(15,3)’ where id = \u5b57\u6bb5ID
\nalter table formtable_main_* alter column float1 decimal(15,3) null *\u4e3a\u8868\u5355ID
\n\u6216\u8005\u65b0\u5efa\u4e00\u4e2a\u5b57\u6bb5\uff0c\u7136\u540e\u5c06\u5386\u65f6\u6570\u636e\u4fdd\u5b58\u4e0b\u6765\uff0c\u518d\u5220\u9664\u5b57\u6bb5\uff1b
\nupdate formtable_main_\u8868\u5355ID set \u65b0\u5b57\u6bb5=\u65e7\u5b57\u6bb5;<\/p>\n
\u5982\u4f55\u5c06\u5386\u53f2\u7684\u6587\u6863\u5171\u4eab\u7ed9\u67d0\u4e2a\u90e8\u95e8\u3002
\ninsert into shareinnerdoc (sourceid,type,content,seclevel,sharelevel,srcfrom,opuser,sharesource,downloadlevel)
\nselect id,3,\u90e8\u95e8id,\u5b89\u5168\u7ea7\u522b,1,3,\u90e8\u95e8id,0,1 from docdetail where seccategory = \u5b50\u76ee\u5f55id
\ninsert into docshare (docid,sharetype,seclevel,rolelevel,sharelevel,departmentid,roleid,foralluser,orggroupid,downloadlevel)
\nselect id,3,\u5b89\u5168\u7ea7\u522b,2,1,\u90e8\u95e8id,0,0,0,1 from docdetail where seccategory = \u5b50\u76ee\u5f55id<\/p>\n
\u5c06\u6240\u6709\u76ee\u5f55\u7684\u662f\u5426\u5141\u8bb8\u9ed8\u8ba4\u5171\u4eab\u3001\u975e\u9ed8\u8ba4\u5171\u4eab\uff0c\u52fe\u9009\u4e3a\u201c\u662f\u201d\uff1a
\nupdate DocSecCategory set allownModiMShareL=1,shareable=1
\n\u5c06\u6240\u6709\u76ee\u5f55\u7684\u7981\u6b62\u6587\u6863\u4e0b\u8f7d\u4e0d\u52fe\u9009\uff1a
\nupdate DocSecCategory set nodownload=0<\/p>\n
\u600e\u6837\u67e5\u8be2\u67d0\u4e2a\u7528\u6237\uff08\u5982ID=174)\u5979\u66fe\u7ecf\u9000\u56de\u8fc7\u7684\u6709\u54ea\u4e9b\u6d41\u7a0b\uff1f
\nSELECT t.typename AS ‘\u7c7b\u578b’, b.workflowname AS ‘\u8def\u5f84\u540d\u79f0’, r.requestname AS ‘\u6d41\u7a0b\u8bf7\u6c42\u540d\u79f0’, r.requestid
\nFROM workflow_currentoperator c, workflow_requestbase r, workflow_base b, workflow_type t
\nWHERE c.requestid = r.requestid AND c.workflowid = b.id AND c.workflowtype = t.id
\nAND c.ISreject = 1 and c.userid = 174<\/p>\n
\u534f\u52a9\u533a\u8981\u5220\u9664\u67d0\u4e2a\u4eba\u7684\u67d0\u6761\u56de\u590d\u8bb0\u5f55
\n\u53c2\u8003\u811a\u672c\uff1a
\nselect * from cowork_items where id=\u4e3b\u9898id
\nselect * from cowork_discuss where coworkid=\u4e3b\u9898id
\ndelete cowork_discuss where coworkid=\u4e3b\u9898id and id=\u4f60\u8981\u5220\u7684\u56de\u590did<\/p>\n
select * from MailResourceFile
\n\u67e5\u8be2\u6211\u7684\u901a\u4fe1 \u90ae\u4ef6\u7684\u9644\u4ef6\uff08\u90ae\u4ef6\u7684\u9644\u4ef6\u5730\u5740\uff09
\nselect * from MailResource
\n\u67e5\u8be2\u6211\u7684\u901a\u4fe1 \u90ae\u4ef6\u4fe1\u606f\uff08\u5305\u62ec\u90ae\u4ef6\u4e3b\u9898\uff0c\u63a5\u6536\u4eba\uff0c\u53d1\u9001\u4eba\uff0c\u5185\u5bb9\u7b49\uff09<\/p>\n
\u5df2\u8fdb\u884c\u7684\u7f51\u4e0a\u8c03\u67e5\uff0c\u9700\u8981\u518d\u52a0\u4e00\u4e2a\u6295\u7968\u4eba\u3002
\ninsert into votingshare(votingid,sharetype,resourceid)values(votingid,1,resourceid)
\ninsert into votingsharedetail(votingid,resourceid)values(votingid,resourceid)<\/p>\n
\u9700\u8981\u6bcf\u5e741\u67081\u53f7\u628a\u5e74\u5047\u5927\u4e8e5\u5929\u7684\u5168\u90e8\u8c03\u6574\u4e3a5\u5929\uff0c\u5176\u5b83\u4e0d\u53d8\uff0c\u5982\u4f55\u6279\u91cf\u64cd\u4f5c\uff1f
\nupdate HrmAnnualManagement set annualdays = 5 where annualdays > 5<\/p>\n
\u67e5\u8be2A\u7684\u6240\u6709\u5f85\u529e\u6d41\u7a0b\uff1a
\nselect distinct(a.requestid),b.requestname from workflow_currentoperator a,workflow_requestbase where isremark in \uff080,1,8,9\uff09 and a.requestid = b.requestid and useid = A\u7684id<\/p>\n
\u8d44\u4ea7\u5220\u9664\u6b65\u9aa4
\nselect * from CptCapitalAssortment
\nselect * from cptcapital
\nselect * from CptUseLog
\nselect * from CptCapitalShareInfo
\nselect * from CptShareDetail
\n–\u9996\u5148\u67e5\u8be2\u9700\u8981\u5220\u9664\u7684\u8d44\u4ea7 isdata=2\u8868\u793a\u8d44\u4ea7
\nselect * from cptcapital where isdata=2
\n–\u786e\u8ba4\u8d44\u4ea7\u5220\u9664\u7684\u8d44\u4ea7ID\u540e\u5f00\u59cb\u5220\u9664\u4ee5\u4e0b\u51e0\u4e2a\u8868\u6570\u636e
\ndelete from CptUseLog where capitalid in(select id from cptcapital where isdata=2)
\ndelete from CptCapitalShareInfo where relateditemid in(select id from cptcapital where isdata=2)
\ndelete from CptShareDetail where cptid in (select id from cptcapital where isdata=2)
\ndelete from cptcapital where isdata=2
\n–\u5982\u679c\u6e05\u7a7a\u6240\u6709\u6570\u636e\u5305\u62ec\u8d44\u4ea7\u8d44\u6599\u8bf7\u76f4\u63a5\u5220\u9664\u8868\u6570\u636e\u4e0d\u9700\u8981where\u6761\u4ef6\uff0c\u6e05\u7a7a\u4e0a\u8ff0\u8868\u540e\u8fd8\u9700\u5bf9\u8d44\u4ea7\u7ec4\u6570\u636e\u505a\u4e0b\u66f4\u6539
\nupdate CptCapitalAssortment set capitalcount=0<\/p>\n
\u628a\u6240\u6709\u5ba2\u6237\u5171\u4eab\u7ed9\u67d0\u4e2a\u4eba\u7f16\u8f91\u6743\u9650
\ninsert into crm_shareinfo (relateditemid,sharetype,sharelevel,userid,contents)
\nselect id,1,2,\u4eba\u5458id,\u4eba\u5458id from crm_customerinfo<\/p>\n
\u67e5\u8be2\u67d0\u4e2a\u65f6\u95f4\u6bb5\u67d0\u4e2a\u4eba\u5904\u7406\u8fc7\u7684\u6d41\u7a0bid\uff0c\u6d41\u7a0b\u540d\u79f0\u4ee5\u53ca\u521b\u5efa\u4eba\uff1a
\nselect requestid,(select requestname from workflow_requestbase where requestid = a.requestid),(select lastname from hrmresource where id =(select creater from workflow_requestbase where requestid = a.requestid)) from workflow_currentoperator a where a.operatedate = ‘2012-11-12′ and a.operatetime >=’14:00:00′ and a.operatetime <=’15:00:00’ and userid = 1<\/p>\n
\u67e5\u8be2oa\u7cfb\u7edf\u6d41\u7a0b\u7684\u4f7f\u7528\u60c5\u51b5\uff1a select c.id,c.workflowname,(case d.num when 1 then 0 else d.num end) from workflow_base c, (select a.id, count() as num from workflow_base a left join workflow_requestbase b on a.id = b.workflowid group by a.id ) d where c.id = d.id order by d.num desc,c.id<\/em><\/p>\n \u5220\u9664\u5458\u5de5\u7684\u5de5\u4f5c\u4fe1\u606f delete from HrmStatusHistory where resourceid=\u201c\u4eba\u5458ID\u201d <\/em><\/p>\n \u5728\u6570\u636e\u5e93\u4e2d\u5c06\u5df2\u7ecf\u529e\u7ed3\u4f46\u51fa\u73b0\u5728\u4ee3\u529e\u4e8b\u5b9c\u4e2d\u7684\u6d41\u7a0b\u4ece\u5f85\u529e\u4e2d\u53bb\u9664\u7684sql\uff1a <\/em><\/p>\n update workflow_currentoperator set isremark=’2′ where isremark=’0′ and requestid=<\/em>** and exists(select 1 from workflow_requestbase a where workflow_currentoperator.requestid=a.requestid and a.currentnodetype=’3′)<\/p>\n \u6d41\u7a0b\u4e0d\u80fd\u4fee\u6539\u63d0\u793a\u88ab\u7b7e\u51fa\u89e3\u51b3\u529e\u6cd5\uff1a update workflow_base set isedit=0 where id=\u6d41\u7a0bID<\/p>\n \u67e5\u8be2\u67d0\u6bb5\u671f\u95f4\u5185\u672a\u767b\u9646\u7cfb\u7edf\u7684\u4eba\u5458\uff1a select * from HrmResource where not exists (select distinct relatedid from sysmaintenancelog where relatedid = HrmResource.id and operatetype = 6 and operatedate between ‘2007-01-01’ and ‘2007-12-31’ ) and status in (0,1,2,3)<\/p>\n \u636e\u6587\u6863\u5b58\u653e\u8def\u5f84\u67e5\u8be2\u6587\u6863\u7684\u65b9\u6cd5\u5982\u4e0b\uff1a select a.id,a.docsubject,a.doccreatedate,a.doccreatetime from docdetail a,docimagefile b where a.id=b.docid and exists(select 1 from imagefile c where c.imagefileid=b.imagefileid and c.filerealpath=’\u6587\u6863\u5b58\u653e\u8def\u5f84’)<\/p>\n \u6bcf\u4eba\u6bcf\u5929\u6700\u540e\u4e00\u6b21\u767b\u9646\u7cfb\u7edf\u7684\u65f6\u95f4 select relatedid,(select lastname from hrmresource where id = relatedid),operatedate,max(operatetime) from sysmaintenancelog where operatetype = 6 group by relatedid,operatedate order by relatedid ,operatedate \u5728\u67d0\u4e2a\u671f\u95f4\u5185\u6bcf\u4eba\u6bcf\u5929\u6700\u540e\u4e00\u6b21\u767b\u9646\u7cfb\u7edf\u7684\u65f6\u95f4 select relatedid,(select lastname from hrmresource where id = relatedid),operatedate,max(operatetime) from sysmaintenancelog where operatetype = 6 and operatedate between ‘2012-01-01’ and ‘2012-12-31’ group by relatedid,operatedate order by relatedid ,operatedate<\/p>\n \u5982\u5ba2\u6237\u4e0d\u5c0f\u5fc3\u8bef\u5220\u6389\u5ba2\u6237\uff0c\u53ef\u4ee5\u901a\u8fc7\u4ee5\u4e0b\u65b9\u6cd5\u6062\u590d\u3002 select * from CRM_CustomerInfo where name = ” update CRM_CustomerInfo set deleted =1 where name =”<\/p>\n \u5c06\u6240\u6709\u5206\u90e8\u4e0b\u7684\u67d0\u4e2a\u5de6\u4fa7\u83dc\u5355\u9690\u85cf update leftmenuconfig set visible = 0 where infoid = \u83dc\u5355id and resourcetype = 2<\/p>\n \u67e5\u8be2\u6d41\u7a0b\u7684\u8868\u5355\u4fe1\u606f \u5148\u83b7\u53d6\u5230\u6d41\u7a0b\u7684workflowid\uff08\u53ef\u901a\u8fc7\u65b0\u5efa\u6d41\u7a0b\u65f6\u5019\u901a\u8fc7\u5730\u5740\u680f\u83b7\u53d6\u5230id\uff09 select * from workflow_base where id=[workflowid]\uff0c\u5f97\u5230formid\u548cisbill\u7684\u503c isbill\u4e3a1\u7684\u60c5\u51b5 select * from workflow_bill where id=[formid] tablename\u5c31\u662f\u8be5\u8868\u5355\u6570\u636e\u5b58\u653e\u7684\u6570\u636e\u5e93\u8868 isbill\u4e3a0\u7684\u60c5\u51b5 select * from workflow_form where requestid=[\u6d41\u7a0bid]<\/p>\n \u67e5\u8be2\u4e0d\u6ee13\u4e2a\u6708\u79bb\u804c\u7684\u5458\u5de5 Oracle: select * from (select a.id,a.loginid,a.lastname,add_months(to_date(a.createdate,’rrrr_mm_dd’),\u5bf9\u6bd4\u6708\u4efd) as stardate,to_date(b.hiredate,’rrrr-mm-dd’) as enddate from hrmresource a,( select max(h1.changedate) as hiredate ,resourceid from HrmStatusHistory h1 where h1.type_n = 5 group by resourceid ) b where a.id = b.resourceid and a.status = 5) where stardate > enddate \u67e5\u8be2\u6d41\u7a0b\u4ee3\u7406\u7684\u8be6\u7ec6\u60c5\u51b5\uff0c\u5305\u62ec\u4ee3\u7406\u4eba\u548c\u88ab\u4ee3\u7406\u4eba\u8d26\u53f7\uff0c\u59d3\u540d\uff0c\u4ee3\u7406\u6d41\u7a0b\uff0c\u5f00\u59cb\u7ed3\u675f\u65f6\u95f4\uff1a \u8f6c\u8f7d\u8bf7\u6ce8\u660e\uff1a\u8d6b\u975e\u57df<\/a> » \u3010\u6cdb\u5faeOA\u3011\u5e38\u7528SQL\u8bed\u53e5<\/a><\/p>","protected":false},"excerpt":{"rendered":" \u5c06\u67d0\u4e2a\u5b50\u76ee\u5f55\u4e0b\u7684\u6240\u6709\u6587\u6863\u5171\u4eab\u7ed9\u67d0\u4e2a\u4eba\u67e5\u770b\u6743\u9650 insert into docshare(docid,sharetype,seclevel,rolelevel,sharelevel,userid,foralluser,downloadlevel) se […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24,19],"tags":[1162,428,1161],"class_list":["post-10075","post","type-post","status-publish","format-standard","hentry","category-code","category-ecology-","tag-id","tag-select","tag-1161"],"_links":{"self":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/10075","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10075"}],"version-history":[{"count":2,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/10075\/revisions"}],"predecessor-version":[{"id":10077,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/10075\/revisions\/10077"}],"wp:attachment":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10075"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10075"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10075"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\nSQLServer:
\nselect * from (select a.id,a.loginid,a.lastname,a.createdate as a,CONVERT(varchar(12),DATEADD(MONTH,\u5bf9\u6bd4\u6708\u4efd,a.createdate),23) as createdate,b.hiredate
\nfrom hrmresource a,(select max(h1.changedate) as hiredate ,resourceid from HrmStatusHistory h1 where h1.type_n = 5 group by resourceid ) b
\nwhere a.id = b.resourceid and a.status = 5) c where c.createdate > c.hiredate
\n\u628a \u5bf9\u6bd4\u6708\u4efd \u6362\u6210 3 \u5373\u53ef\u67e5\u8be2\u4e0d\u6ee1\u4e09\u4e2a\u6708\u5c31\u79bb\u804c\u7684\u5458\u5de5\uff0c\u6539\u621012\u5c31\u53ef\u4ee5\u67e5\u8be2\u4e0d\u6ee1\u4e00\u5e74\u79bb\u804c\u7684\u5458\u5de5\uff0c\u4f9d\u6b21\u7c7b\u63a8<\/p>\n
\n
\nselect c.loginid as \u4ee3\u7406\u4eba\u8d26\u53f7, c.lastname as \u4ee3\u7406\u4eba\u59d3\u540d,d.loginid as \u88ab\u4ee3\u7406\u4eba\u8d26\u53f7,d.lastname as \u88ab\u4ee3\u7406\u4eba\u59d3\u540d,c.workflowname as \u4ee3\u7406\u6d41\u7a0b,c.begindate as \u5f00\u59cb\u65e5\u671f,
\nc.begintime as \u5f00\u59cb\u65f6\u95f4,c.enddate as \u7ed3\u675f\u65e5\u671f,c.endtime as \u7ed3\u675f\u65f6\u95f4 from
\n(select h.loginid ,h.lastname,w.begindate,w.begintime,w.enddate,w.endtime ,w.agentid,b.workflowname from workflow_agent w,hrmresource h, workflow_base b
\nwhere w.agenterid = h.id and w.workflowid = b.id) c,
\n(select r.loginid ,r.lastname,a.agentid from workflow_agent a,hrmresource r where a.beagenterid = r.id) d
\nwhere c.agentid = d.agentid<\/p>\n