甯歌闂涓庡垎鏋?/div>
涓銆佸弬鏁拌緗?/h3>
鍏抽棴
涓銆佸弬鏁拌緗?/h3> 1.1銆佽彍鍗曚綅緗?/span>
涓氬姟琛ㄥ崟-鍚庡彴綆＄悊-鍑芥暟鍙傛暟瀹氫箟
1.2銆佹柊澧炲弬鏁?/span>
鍒楄〃紿椾綋
鏂板鍙傛暟
鍙傛暟綆縐幫細(xì)
鏍煎紡錛氬墠緙[鍙傛暟綆縐癩
鍏朵腑鈥滃墠緙鈥濆繀欏諱負(fù) PM2,涓旇澶у啓錛屸濆弬鏁扮畝縐扳滃垯瑕佺鍚堟鍒欒〃杈懼紡瀛楃,涓旂敤涓嫭鍙鋒嫭璧鋒潵錛屽惁鍒欐棤鏁堛?/p>
鐢ㄤ緥錛?nbsp;PM2[Name]
鍙傛暟鍚箟錛?/p>
鐩墠鏈変互涓嬪弬鏁板彲渚涢夋嫨錛屽嵆鍙栧綋鍓峆M2鐢ㄦ埛鐨勫叿浣撳?/p>
浜屻佽嚜鐢辨姤琛ㄨ剼鏈紩鐢ㄥ疄渚?/h3>
鏄劇ず褰撳墠鐢ㄦ埛鏈夋潈闄愮殑欏圭洰鏁版嵁
SQL鑴氭湰濡備笅錛?/p>
Select * from sdpa001 Where pa00101 in (select ps01303 from sdvw_GetXmRight where
pj00602='PM2[Name]' and ps01302 in(2,7) and ps01306 in(1,2))
鍏朵腑PM2[Name],灝辨槸鍙栧弬鏁頒腑璁劇疆鐨勫弬鏁扮畝縐幫紝鍊煎皢鑷姩鍙栧搴旂殑鍙傛暟鍚箟鍊箋?/p>
閰風(fēng)壒鎶ヨ〃涓句緥
鍙互閫氳繃鏌ョ湅鑴氭湰錛岀紪杈戝師鑴氭湰錛岀劧鍚庢洿鏂拌剼鏈嵆鍙?/p>
Select * from sdpa508_view
where proId in (select ps01303 from sdvw_GetXmRight where
pj00602='PM2[Name]' and ps01302 in(2,7) and ps01306 in(1,2))
