/// <summary>
/// 保存阅读记录
/// </summary>
/// <param name="reading"></param>
public void SaveReadings(rData reading, string cid)
{
TF.RunSafty.Model.TAB_ReadHistory readingHistory = new TF.RunSafty.Model.TAB_ReadHistory();
rData data = reading;
if (data != null && data.ReaderArray != null)
{
foreach (fReader trainman in data.ReaderArray)
{
if (data.TypeList != null)
{
foreach (fTypeList fType in data.TypeList)
{
foreach (rFile file in fType.FileList)
{
readingHistory = new TF.RunSafty.Model.TAB_ReadHistory();
readingHistory.SiteGUID = cid;
readingHistory.strTrainmanGUID = trainman.TrainmanGUID;
readingHistory.strFileGUID = file.strFileGUID;
readingHistory.DtReadTime = file.dtReadTime;
bllRead.Add(readingHistory);
//更新阅读计划里边的第一次阅读时间、阅读次数
bllPlan.UpdateReadTime(file.strFileGUID, trainman.TrainmanGUID, file.dtReadTime);
}
}
}
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(TF.RunSafty.Model.TAB_ReadHistory model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TAB_ReadHistory set ");
strSql.Append("strFileGUID=@strFileGUID,");
strSql.Append("strTrainmanGUID=@strTrainmanGUID,");
strSql.Append("DtReadTime=@DtReadTime,");
strSql.Append("SiteGUID=@SiteGUID");
strSql.Append(" where nId=@nId");
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),
new SqlParameter("@nId", SqlDbType.Int, 4)
};
parameters[0].Value = model.strFileGUID;
parameters[1].Value = model.strTrainmanGUID;
parameters[2].Value = model.DtReadTime;
parameters[3].Value = model.SiteGUID;
parameters[4].Value = model.nId;
int rows = (int)SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(TF.RunSafty.Model.TAB_ReadHistory 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));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TF.RunSafty.Model.TAB_ReadHistory DataRowToModel(DataRow row)
{
TF.RunSafty.Model.TAB_ReadHistory model = new TF.RunSafty.Model.TAB_ReadHistory();
if (row != null)
{
if (row["nId"] != null && row["nId"].ToString() != "")
{
model.nId = int.Parse(row["nId"].ToString());
}
if (row["strFileGUID"] != null)
{
model.strFileGUID = row["strFileGUID"].ToString();
}
if (row["strTrainmanGUID"] != null)
{
model.strTrainmanGUID = row["strTrainmanGUID"].ToString();
}
if (row["DtReadTime"] != null)
{
model.DtReadTime = row["DtReadTime"].ToString();
}
if (row["SiteGUID"] != null)
{
model.SiteGUID = row["SiteGUID"].ToString();
}
}
return(model);
}
public string RecordUpload(string input, string cid)
{
Upload_Out model = new Upload_Out();
{
Newtonsoft.Json.Converters.JsonVirtualConverter <jsBase> jvc = new Newtonsoft.Json.Converters.JsonVirtualConverter <jsBase>("stepID", t =>
{
switch (t)
{
case "1004":
return(new Reading());
case "1012":
return(new printData());
default:
return(null);
}
});
List <jsBase> array = Newtonsoft.Json.JsonConvert.DeserializeObject <List <jsBase> >(input, jvc);
TF.RunSafty.Model.TAB_ReadHistory read = new TF.RunSafty.Model.TAB_ReadHistory();
try
{
if (array != null)
{
foreach (jsBase t in array)
{
if (t is Reading)
{
Reading reading = (Reading)t;
SaveReadings(reading.data, cid);
}
else if (t is printData)
{
printData print = (printData)t;
SavePrintData(print.data, cid);
}
}
}
model.result = "0";
model.returnStr = "提交成功";
}
catch (Exception ex)
{
TF.CommonUtility.LogClass.logex(ex, "");
model.result = "1";
model.returnStr = "提交失败:" + ex.Message;
}
string result = Newtonsoft.Json.JsonConvert.SerializeObject(model);
return(result);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TF.RunSafty.Model.TAB_ReadHistory GetModel(int nId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 nId,strFileGUID,strTrainmanGUID,DtReadTime,SiteGUID from TAB_ReadHistory ");
strSql.Append(" where nId=@nId");
SqlParameter[] parameters =
{
new SqlParameter("@nId", SqlDbType.Int, 4)
};
parameters[0].Value = nId;
TF.RunSafty.Model.TAB_ReadHistory model = new TF.RunSafty.Model.TAB_ReadHistory();
DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
