//保存巡检记录
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);
}