public string AddECBrowseDetails(dynamic requestData)
{
try
{
string BrowseDetails = JsonConvert.SerializeObject(requestData);
var q = JsonConvert.DeserializeObject <ECBrowseDetails>(BrowseDetails);
lock (Lock)
{
//详情页是否包含
var IsPV = (from v in db.ECBrowseDetails
where v.ECURL == q.ECURL
select v).FirstOrDefault();
//如果详情里面没有这
if (IsPV == null)
{
ECBrowse newqECBrowse = new ECBrowse();
newqECBrowse.ECURL = q.ECURL;
newqECBrowse.PV = 1;
newqECBrowse.UV = 1;
//db.ECBrowse.Add(newqECBrowse);
var sql = string.Format("INSERT INTO [dbo].[ECBrowse]([ECURL],[PV],[UV],[Transpond]) VALUES('{0}',{1},{2},0)", newqECBrowse.ECURL, newqECBrowse.PV, newqECBrowse.UV);
dataContext.ExecuteNonQuery(CommandType.Text, sql);
}
else
{
//查找EC总的是否有
var qECBrowse = (from v in db.ECBrowse
where v.ECURL == q.ECURL
select v).FirstOrDefault();
if (qECBrowse != null)
{
qECBrowse.PV = qECBrowse.PV + 1;
var IsUV = (from v in db.ECBrowseDetails
where v.ECURL == q.ECURL && v.OpenId == q.OpenId
select v).FirstOrDefault();
Thread.Sleep(500);
if (IsUV == null)
{
qECBrowse.UV = qECBrowse.UV + 1;
}
var sqlPVUV = string.Format("UPDATE [dbo].[ECBrowse] SET [PV] = {0},[UV] = {1} WHERE Id={2}", qECBrowse.PV, qECBrowse.UV, qECBrowse.Id);
dataContext.ExecuteNonQuery(CommandType.Text, sqlPVUV);
}
}
}
db.ECBrowseDetails.Add(q);
db.SaveChanges();
return("OK");
}
catch (Exception)
{
return("No");
}
}
public string AddECWXTranspondDetails(dynamic requestData)
{
try
{
string BrowseDetails = JsonConvert.SerializeObject(requestData);
var q = JsonConvert.DeserializeObject <ECWXTranspondDetails>(BrowseDetails);
//是否包含
var IsUV = (from v in db.ECWXTranspondDetails
where v.ECBrowseURL == q.ECBrowseURL && v.OpenId == q.OpenId
select v).FirstOrDefault();
//查找EC总的是否有
var qECBrowse = (from v in db.ECBrowse
where v.ECURL == q.ECBrowseURL
select v).FirstOrDefault();
if (IsUV == null)
{
if (qECBrowse == null)
{
ECBrowse newqECBrowse = new ECBrowse();
newqECBrowse.ECURL = q.ECBrowseURL;
newqECBrowse.Transpond = 1;
db.ECBrowse.Add(newqECBrowse);
}
else
{
qECBrowse.Transpond = qECBrowse.Transpond + 1;
db.Entry <ECBrowse>(qECBrowse).State = EntityState.Modified;
}
}
else
{
qECBrowse.Transpond = qECBrowse.Transpond + 1;
db.Entry <ECBrowse>(qECBrowse).State = EntityState.Modified;
}
db.ECWXTranspondDetails.Add(q);
db.SaveChanges();
return("OK");
}
catch (Exception)
{
return("No");
}
}
