work diary

预防性维修批量上传

  1. 准备好表格。表格有专门的模板。(见另一excel文件). 去掉表头,选中表格其他部分,贴在记事本里,另存为.txt文件。
  2. 在地址栏输入代码:
  3. 回车。选择放文件的路径
  4. 点击执行按钮。显示了结果。
  5. 重新到地址栏输入代码:sm35,然后执行。
  6. 然后在这几个界面,选中刚才上穿的行,点击process:
  7. 最后进入到ip03 ,检查一下是否上传成功。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15005154/viewspace-592245/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/15005154/viewspace-592245/

SELECT `a`.`id` AS `id`, `a`.`user_id` AS `user_id`, `a`.`diary_date` AS `diary_date`, `a`.`time_id` AS `time_id`, `c`.`dept_id` AS `dept_id`, `c`.`name` AS `name`, `c`.`post_id` AS `post_id`, `d`.`reviewer_id` AS `reviewer_id`, `nw`.`jigou` AS `jigou`,( CASE WHEN ( `a`.`time_id` = 0 ) THEN '上午' WHEN ( `a`.`time_id` = 1 ) THEN '下午' ELSE '晚上' END ) AS `timename`,( CASE WHEN ( `a`.`is_submit` = 0 ) THEN '未提交' ELSE '已提交' END ) AS `submitname`, `a`.`is_submit` AS `is_submit`, `a`.`model_id` AS `model_id`, `a`.`content` AS `content`, `a`.`system_time` AS `system_time`, `a`.`day_state` AS `day_state`, `a`.`time_start` AS `time_start`, `a`.`time_end` AS `time_end`, `a`.`address` AS `address`, `a`.`content_join` AS `content_join`, `a`.`diary_state` AS `diary_state`, `a`.`syfid` AS `syfid`, `b`.`name` AS `modelname`, `e`.`rank1` AS `rank1`, `e`.`review_name` AS `review_name`, `e`.`review_state` AS `review_state`, `e`.`writing_state` AS `writing_state`, `e`.`status_name` AS `status_name` FROM ((((( `work_diary` `a` LEFT JOIN `work_template` `b` ON (( `a`.`model_id` = `b`.`id` ))) LEFT JOIN `sys_user` `c` ON (( `a`.`user_id` = `c`.`id` ))) LEFT JOIN `work_jigou` `nw` ON (( `nw`.`id` = `c`.`dept_id` ))) LEFT JOIN `sys_review` `d` ON ((( `a`.`user_id` = `d`.`user_id` ) AND ( `b`.`type` = `d`.`code` )))) LEFT JOIN `view_my_worklist` `e` ON ((( `a`.`user_id` = `e`.`user_id` ) AND ( `a`.`diary_date` = `e`.`diary_date` ))))优化,只要结果,不要分析和思路
03-20
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值