//保存巡检记录 public bool SaveInspectionRecord(Model._XJmodel inspectionRecord) { SQLiteParameter[] sqlParams = new SQLiteParameter[6]; sqlParams[0] = new SQLiteParameter(PARAM_LCNUM, DbType.String, 20); sqlParams[1] = new SQLiteParameter(PARAM_STATUS, DbType.String, 10); sqlParams[2] = new SQLiteParameter(PARAM_PTIME, DbType.DateTime, 8); sqlParams[3] = new SQLiteParameter(PARAM_RTIME, DbType.DateTime, 8); sqlParams[4] = new SQLiteParameter(PARAM_WORKER, DbType.String, 20); sqlParams[5] = new SQLiteParameter(PARAM_REMARKS, DbType.String, 30); sqlParams[0].Value = inspectionRecord.lcNumber; sqlParams[1].Value = inspectionRecord.getStatus; sqlParams[2].Value = inspectionRecord.getBjtime; if (inspectionRecord.getRecordTime == null) { sqlParams[3].Value = DBNull.Value; } else { sqlParams[3].Value = inspectionRecord.getRecordTime; } sqlParams[4].Value = inspectionRecord.getWorker; sqlParams[5].Value = inspectionRecord.getContent == null ? "" : inspectionRecord.getContent; SQLiteDBHelper sdb = new SQLiteDBHelper(Program.g_dbPath); return(sdb.ExecuteNonQuery(INSERT_XJ, sqlParams) > 0); }
public string buildXunjianData(Model._XJmodel inspectionRecord) { string str = ""; Program.WriteLog(" 组装需要上传巡检数据"); List <TrainRemoteControl.WebModel.InspectionRecords> inspectRecordsList = new List <WebModel.InspectionRecords>(); TrainRemoteControl.WebModel.InspectionRecords inspect = new WebModel.InspectionRecords(); inspect.lcNum = Program.g_lcNumber; inspect.id = new Random().Next(1, 999999); inspect.planTime = DateTime.Now; inspect.recordTime = DateTime.Now; inspect.status = 1; inspect.worker = inspectionRecord.getWorker; inspect.trainInfo = null; inspectRecordsList.Add(inspect); str = Program.ScriptSerialize(inspectRecordsList); Program.WriteLog(" 组装后数据" + str); return(str); }