| 123456789101112131415161718192021 |
- ALTER TABLE `bigpartpurchase`
- ADD COLUMN `purchase_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '申购类型 0 无效 1 暂估 2 垫付',
- ADD COLUMN `funder_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '垫资人id';
- ALTER TABLE `bigpartuse` ADD COLUMN greenFodderNumber varchar(255) NOT NULL DEFAULT '' COMMENT '青贮单号';
- # SELECT * FROM apisql WHERE sqlname = 'insertBigPartUse'
- INSERT INTO bigpartuse (
- pastureId,
- departmentId,
- useForm,
- listType,
- applicatId,
- receiveTime,
- empId,
- useType,
- oddCode,
- note,
- greenFodderNumber
- ) VALUES ( ?,(select departmentId from bigpartapply where applyCode = ? ),?,?,?,?,?,?,?,?,?)
- # pastureId,oddCode,useForm,listType,applicatId,receiveTime,empId,useType,oddCode,note,greenFodderNumber
|
