如何让设置的参数为空时，则默认选取所有下拉固定项？

2015-08-11 02:41:58 136 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

MOS管栅极上拉/下拉电阻的作用与阻值选取指南在分立器件开关电路中，电阻虽小，却肩负着为高阻抗节点建立确定电平的重任。MOS管栅极因绝缘层存在而呈现极高输入阻抗，一旦悬空，周围电磁耦合或漏电流便可能悄然抬升栅源电压，引发毫无指令的误导通，甚至导致半桥直通烧毁。在栅极与源极之间配置上拉或下拉电阻，本质是为栅极电荷提供可控的泄放回路，既能固定静态偏置、抑制米勒干扰，也能在驱动输出高阻时确保可靠关断。从N沟道低边开关到隔离驱动场景，电阻值的选取需在功耗、关断速度与抗干扰能力间权衡，常见取值多在10kΩ至47kΩ。理解上拉与下拉电阻的物理作用，是设计稳定、抗干阅读详情

when c.Myfield1='23' then 'N56/N61' when c.Myfield1='24' then 'B170'

when c.Myfield1='25' then 'B171' end),(case when PerField3='01' then '人资部'  when PerField3='02' then '财务部' when 

PerField3='03' then '资讯部'

when PerField3='04' then '客服部' when PerField3='05' then '关务部'

when PerField3='06' then '计划部' when PerField3='07' then '资材部'

when PerField3='08' then '工程技术部' when PerField3='09' then '安全课'

when PerField3='10' then '运作部' when PerField3='11' then '压铸模具'

when PerField3='12' then '品保部' end ),EmpTypeName,b.EmpNo,EmpName,IDCardNo,DtName,c.PartName,bb,

LevelLevel,OverTime1,ComeDate,LeaveDate,PayNo6,PayNo16,PayNo17,

OverTime2,OverTime3,OverTimeAll,WTType2Num,WTType3Num,

PayNo21,PayNo22,PayNo23,PayNo25,PayNo26,PayNo2,PayNo3,PayNo4,

PayNo27,PayNo42,PayNo32,PayNo33,PayNo34,PayNo35,PayNo43,

PayNo37,PayNo38,PayNo39,PayNo40,PayNo13,PayNo14,PayNo15,PayNo16

PayNo5,PayNo7,PayNo8,PayNo9,PayNo10,PayNo21+PayNo22+PayNo23+PayNo24+PayNo29 as 公司成本,

PayNo28+PayNo30 as 个人成本,

PayNo11,PayNo12,PayNo43,PayNo18,PayNo20,PayNo24,PayNo28,PayNo29,PayNo30,ComeSourceNo

InComeTax,PayNo36,b.MyField1 as 入职结算差,b.MyField2 as 离职结算差 from PayMonthData a left join AttMonthData b on 

a.EmpID=b.EmpID and a.YYMM=b.YYMM left join PerEmployee c on a.EmpID=c.EmpID left join bbview on c.PartName=bbview.PartName

where a.YYMM='{YYMM}'  and PerField3!='' and PerField3 is not null and ComeSourceNo='08' and PayNo20>=0

order by PerField3,PartName

else 

select(case  when c.Myfield1='01' then 'B24' when c.Myfield1='05' then 'X241'

when c.Myfield1='06' then '其他' when c.Myfield1='15' then '办公人员'

when c.Myfield1='17' then '铣床' when c.Myfield1='18' then 'TMA'

when c.Myfield1='19' then '其他/保洁员' when c.Myfield1='20' then 'N12'

when c.Myfield1='21' then 'X340' when c.Myfield1='22' then 'B9'

when c.Myfield1='23' then 'N56/N61' when c.Myfield1='24' then 'B170'

when c.Myfield1='25' then 'B171' end),(case when PerField3='01' then '人资部'  when PerField3='02' then '财务部' when 

PerField3='03' then '资讯部'

when PerField3='04' then '客服部' when PerField3='05' then '关务部'

when PerField3='06' then '计划部' when PerField3='07' then '资材部'

when PerField3='08' then '工程技术部' when PerField3='09' then '安全课'

when PerField3='10' then '运作部' when PerField3='11' then '压铸模具'

when PerField3='12' then '品保部' end ),EmpTypeName,b.EmpNo,EmpName,IDCardNo,DtName,c.PartName,bb,

LevelLevel,OverTime1,ComeDate,LeaveDate,PayNo6,PayNo16,PayNo17,

OverTime2,OverTime3,OverTimeAll,WTType2Num,WTType3Num,

PayNo21,PayNo22,PayNo23,PayNo25,PayNo26,PayNo2,PayNo3,PayNo4,

PayNo27,PayNo42,PayNo32,PayNo33,PayNo34,PayNo35,PayNo43,

PayNo37,PayNo38,PayNo39,PayNo40,PayNo13,PayNo14,PayNo15,PayNo16

PayNo5,PayNo7,PayNo8,PayNo9,PayNo10,PayNo21+PayNo22+PayNo23+PayNo24+PayNo29 as 公司成本,

PayNo28+PayNo30 as 个人成本,

PayNo11,PayNo12,PayNo43,PayNo18,PayNo20,PayNo24,PayNo28,PayNo29,PayNo30,ComeSourceNo

InComeTax,PayNo36,b.MyField1 as 入职结算差,b.MyField2 as 离职结算差 from PayMonthData a left join AttMonthData b on 

a.EmpID=b.EmpID and a.YYMM=b.YYMM left join PerEmployee c on a.EmpID=c.EmpID left join bbview on c.PartName=bbview.PartName

where a.YYMM='{YYMM}'  and PerField3 is not null and ComeSourceNo='08' and PayNo20>=0

order by PerField3,PartName