package com.dev.lock.history;
|
|
import com.base.Com;
|
import com.dev.lock.data.ElectLock_RecordState;
|
import com.dev.lock.data.ElectLock_Report;
|
import com.sql.Sql_Mysql;
|
|
public class InsertDataToMysql_Task_SQL {
|
|
/**
|
* 构造年度开锁记录表
|
* @param sql
|
* @param lock_id
|
* @param report
|
* @return
|
*/
|
public static String getInsertLock_Report_TableDataStr(int lock_id,ElectLock_Report report) {
|
String sql_str_upd = " UPDATE " + Sql_Mysql.Lock_Report_Table +
|
" SET month1 = " + report.month1 +
|
" ,month2 = " + report.month2 +
|
" ,month3 = " + report.month3 +
|
" ,month4 = " + report.month4 +
|
" ,month5 = " + report.month5 +
|
" ,month6 = " + report.month6 +
|
" ,month7 = " + report.month7 +
|
" ,month8 = " + report.month8 +
|
" ,month9 = " + report.month9 +
|
" ,month10 = " + report.month10 +
|
" ,month11 = " + report.month11 +
|
" ,month12 = " + report.month12 +
|
" ,quarter1 = " + report.quarter1 +
|
" ,quarter2 = " + report.quarter2 +
|
" ,quarter3 = " + report.quarter3 +
|
" ,quarter4 = " + report.quarter4 +
|
" ,year_count = " + report.year_count +
|
" WHERE lock_id = " + lock_id +
|
" AND record_year = " + report.record_year;
|
return sql_str_upd;
|
}
|
|
|
/**
|
* 构造锁具开关锁，记录表
|
* @param sql
|
* @param lock_id
|
* @param report
|
* @return
|
*/
|
public static String getInsertLock_His_TableDataStr(int lock_id,ElectLock_RecordState state) {
|
String sql_str_upd = " INSERT INTO " + Sql_Mysql.Lock_His_Table + lock_id + "_" + Com.getDateTimeFormat(state.record_time, Com.DTF_Y) + " "
|
+ " (lock_id,record_time,lock_state,unlock_type,unlock_id) "
|
+ " VALUES("
|
+ lock_id
|
+ ",'" + Com.getDateTimeFormat(state.record_time, Com.DTF_YMDhms)
|
+ "'," + state.lock_state
|
+ "," + state.unlock_type
|
+ "," + state.unlock_id +
|
");";
|
return sql_str_upd;
|
}
|
|
}
|
