kpt_xdmy/doc/mbudget/sqlup.sql

update apisql 
set 
params ='pastureId,deptId,feeType,monthBudget,monthLimit,budgetMonth',
sqlstr =
"INSERT INTO month_budget(
	pastureId,
	deptId,
	feeType,
	monthBudget,
	monthLimit,
	budgetMonth
)VALUES(
?,?,?,?,?,?
)"
where sqlname ='insertMonthbudget';

update apisql
set params='monthBudget,monthLimit,id',
sqlstr ="update month_budget set monthBudget=?,monthLimit=? where id = ?"
where sqlname ='updateMonthbudget';

update dictlist set label = '饲养头数月预算' where label = '饲养头数月预算,';

update apisql 
set sqlstr =
"select
	mb.`budgetMonth`,
	mb.`feeType`,
	mb.`id`,
	mb.`monthBudget`,
	mb.`monthLimit`,
	mb.`pastureId`,
	p.`name` pastureName,
	mb.deptId,
	ifnull(d.name, '') deptName
from
	month_budget mb
inner join pasture p
on
	p.id = mb.pastureId
left join department d
on
	d.id = mb.deptId
where
	(p.`name` =?
		or ?= '现代牧业')
	and (mb.`feeType` = ?
		or ?= '')
	and (mb.deptId =?
		or ?= '' )
order by
	mb.`budgetMonth` desc ,
	mb.`feeType` desc,
	mb.id desc"
where sqlname ='getMonthbudgetlist';