/// <summary> /// 增加一条数据 /// </summary> public int AddReadHistory(MDSelfServiceMachine.MDReadHistory model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TAB_ReadHistory("); strSql.Append("strFileGUID,strTrainmanGUID,DtReadTime,SiteGUID)"); strSql.Append(" values ("); strSql.Append("@strFileGUID,@strTrainmanGUID,@DtReadTime,@SiteGUID)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@strFileGUID", SqlDbType.VarChar, 50), new SqlParameter("@strTrainmanGUID", SqlDbType.VarChar, 50), new SqlParameter("@DtReadTime", SqlDbType.VarChar, 50), new SqlParameter("@SiteGUID", SqlDbType.VarChar, 50) }; parameters[0].Value = model.strFileGUID; parameters[1].Value = model.strTrainmanGUID; parameters[2].Value = model.DtReadTime; parameters[3].Value = model.SiteGUID; object obj = SqlHelper.ExecuteScalar(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
// 保存阅读记录 public JsonModel SaveReadings(string Data) { MDSelfServiceMachine.MDReadHistory readingHistory = new MDSelfServiceMachine.MDReadHistory(); DBReadingRecord dbs = new DBReadingRecord(); Reading reading = Newtonsoft.Json.JsonConvert.DeserializeObject <Reading>(Data); JsonModel model = new JsonModel(); try { if (reading.data != null && reading.data.ReaderArray != null) { foreach (fReader trainman in reading.data.ReaderArray) { if (reading.data.TypeList != null) { foreach (fTypeList fType in reading.data.TypeList) { foreach (rFile file in fType.FileList) { readingHistory = new MDSelfServiceMachine.MDReadHistory(); readingHistory.SiteGUID = trainman.cid; readingHistory.strTrainmanGUID = trainman.TrainmanGUID; readingHistory.strFileGUID = file.strFileGUID; readingHistory.DtReadTime = file.dtReadTime; dbs.AddReadHistory(readingHistory); //更新阅读计划里边的第一次阅读时间、阅读次数 dbs.UpdateReadTime(file.strFileGUID, trainman.TrainmanGUID, file.dtReadTime); } } } } } model.result = "0"; model.returnStr = "提交成功"; } catch (Exception ex) { TF.CommonUtility.LogClass.logex(ex, ""); model.result = "1"; model.returnStr = "提交失败:" + ex.Message; } return(model); }