///<summary>
///向数据库中添加一条记录
///</summary>
///<param name="model">要添加的实体</param>
public bool Insert(weibo model)
{
const string sql = @"INSERT INTO [dbo].[weibo] (objectId,uid,access_token,expires_in) VALUES (@objectId,@uid,@access_token,@expires_in)";
int res = SqlHelper.ExecuteNonQuery(sql, new SqlParameter("@objectId", model.objectId.ToDBValue()), new SqlParameter("@uid", model.uid.ToDBValue()), new SqlParameter("@access_token", model.access_token.ToDBValue()), new SqlParameter("@expires_in", model.expires_in.ToDBValue()));
return(res > 0);
}
/// <summary>
/// 查询单个模型实体
/// </summary>
/// <param name="id">objectId</param>);
/// <returns>实体</returns>);
public weibo QuerySingleById(string objectId)
{
const string sql = "SELECT TOP 1 objectId,uid,access_token,expires_in from weibo WHERE [objectId] = @objectId";
using (var reader = SqlHelper.ExecuteReader(sql, new SqlParameter("@objectId", objectId)))
{
if (reader.HasRows)
{
reader.Read();
weibo model = SqlHelper.MapEntity <weibo>(reader);
return(model);
}
else
{
return(null);
}
}
}
///<summary>
///分页查询一个集合
///</summary>
///<param name="index">页码</param>
///<param name="size">页大小</param>
///<param name="wheres">条件匿名类</param>
///<param name="orderField">排序字段</param>
///<param name="isDesc">是否降序排序</param>
///<returns>实体集合</returns>
public IEnumerable <weibo> QueryList(int index, int size, object wheres = null, string orderField = "objectId", bool isDesc = true)
{
List <SqlParameter> list = null;
string where = wheres.parseWheres(out list);
orderField = string.IsNullOrEmpty(orderField) ? "objectId" : orderField;
var sql = SqlHelper.GenerateQuerySql("weibo", new string[] { "objectId", "uid", "access_token", "expires_in" }, index, size, where, orderField, isDesc);
using (var reader = SqlHelper.ExecuteReader(sql, list.ToArray()))
{
if (reader.HasRows)
{
while (reader.Read())
{
weibo model = SqlHelper.MapEntity <weibo>(reader);
yield return(model);
}
}
}
}
/// <summary>
/// 根据主键更新一条记录
/// </summary>
/// <param name="model">更新后的实体</param>
/// <returns>执行结果受影响行数</returns>
public bool Update(weibo model)
{
return(_dao.Update(model));
}
/// <summary>
/// 向数据库中添加一条记录
/// </summary>
/// <param name="model">要添加的实体</param>
/// <returns>是否成功</returns>
public bool Insert(weibo model)
{
return(_dao.Insert(model));
}
/// <summary>
/// 根据主键更新一条记录
/// </summary>
/// <param name="model">更新后的实体</param>
/// <returns>是否成功</returns>
public bool Update(weibo model)
{
const string sql = @"UPDATE [dbo].[weibo] SET uid=@uid,access_token=@access_token,expires_in=@expires_in WHERE [objectId] = @objectId";
return(SqlHelper.ExecuteNonQuery(sql, new SqlParameter("@objectId", model.objectId.ToDBValue()), new SqlParameter("@uid", model.uid.ToDBValue()), new SqlParameter("@access_token", model.access_token.ToDBValue()), new SqlParameter("@expires_in", model.expires_in.ToDBValue())) > 0);
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
var method = context.Request["action"];
using (worldEntities db = new worldEntities())
{
if (method == "look")
{
var pageIndex = Convert.ToInt32(context.Request["pageIndex"]);
var list = db.weibo.Where(a => true).OrderByDescending(a => a.ID).Skip((pageIndex - 1) * 5).Take(5).ToList();
var count = list.Count();
var listSer = JsonConvert.SerializeObject(list);
context.Response.Write(listSer);
}
if (method == "page")
{
var list = db.weibo.Where(a => true).ToList();
var count = list.Count();
var pageCount = (count + 5 - 1) / 5;
context.Response.Write(pageCount);
}
if (method == "add")
{
var con = context.Request["con"];
if (!string.IsNullOrEmpty(con))
{
weibo entity = new weibo();
entity.Content = con;
entity.Acc = 0;
entity.Ref = 0;
var startTime = TimeZone.CurrentTimeZone.ToLocalTime(new DateTime(1970, 1, 1));
var time = (int)(DateTime.Now - startTime).TotalSeconds;
entity.Times = time;
db.weibo.Add(entity);
db.SaveChanges();
var list = db.weibo.Where(a => true).OrderByDescending(a => a.ID).FirstOrDefault();
var listSer = JsonConvert.SerializeObject(list);
context.Response.Write(listSer);
}
}
if (method == "del")
{
var con = context.Request["con"];
if (!string.IsNullOrEmpty(con))
{
var intId = Convert.ToInt32(con);
var dbQ = db.Set <weibo>();
var entity = dbQ.Where(a => a.ID == intId).FirstOrDefault();
dbQ.Remove(entity);
db.SaveChanges();
}
}
if (method == "ref")
{
var con = context.Request["con"];
if (!string.IsNullOrEmpty(con))
{
var intId = Convert.ToInt32(con);
var dbQ = db.Set <weibo>();
var entity = dbQ.Where(a => a.ID == intId).FirstOrDefault();
entity.Ref++;
db.SaveChanges();
}
}
if (method == "acc")
{
var con = context.Request["con"];
if (!string.IsNullOrEmpty(con))
{
var intId = Convert.ToInt32(con);
var dbQ = db.Set <weibo>();
var entity = dbQ.Where(a => a.ID == intId).FirstOrDefault();
entity.Acc++;
db.SaveChanges();
}
}
}
}
