/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Book.Model.Navigation model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Navigation(");
strSql.Append("pid,Name)");
strSql.Append(" values (");
strSql.Append("@pid,@Name)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@pid", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.pid;
parameters[1].Value = model.Name;
object obj = SqlHelperBook.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Book.Model.ShuSelf model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ShuSelf(");
strSql.Append("aid,name,sex,city,addtime)");
strSql.Append(" values (");
strSql.Append("@aid,@name,@sex,@city,@addtime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@aid", SqlDbType.Int, 4),
new SqlParameter("@name", SqlDbType.NVarChar, 50),
new SqlParameter("@sex", SqlDbType.NVarChar, 50),
new SqlParameter("@city", SqlDbType.NVarChar, 50),
new SqlParameter("@addtime", SqlDbType.DateTime)
};
parameters[0].Value = model.aid;
parameters[1].Value = model.name;
parameters[2].Value = model.sex;
parameters[3].Value = model.city;
parameters[4].Value = DateTime.Now;
object obj = SqlHelperBook.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 计算未审核的章节数量
/// </summary>
public int GetCount(int shi)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT Count(ID) from Contents");
strSql.Append(" where ");
if (shi > 0)
{
strSql.Append(" shi=" + shi + " and ");
}
strSql.Append(" state=@state and isdel=0");
SqlParameter[] parameters =
{
new SqlParameter("@state", SqlDbType.Int, 4)
};
parameters[0].Value = 0;
object obj = SqlHelperBook.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Book.Model.ShuFav model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ShuFav(");
strSql.Append("name,usid)");
strSql.Append(" values (");
strSql.Append("@name,@usid)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@name", SqlDbType.NVarChar, 50),
new SqlParameter("@usid", SqlDbType.Int, 4)
};
parameters[0].Value = model.name;
parameters[1].Value = model.usid;
object obj = SqlHelperBook.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Book.Model.ShuMu model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ShuMu(");
strSql.Append("nid,title,summary,img,aid,author,addtime,state,tags,types,length,click,good,gxtime,isover,isgood)");
strSql.Append(" values (");
strSql.Append("@nid,@title,@summary,@img,@aid,@author,@addtime,@state,@tags,@types,@length,@click,@good,@gxtime,@isover,@isgood)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@nid", SqlDbType.Int, 4),
new SqlParameter("@title", SqlDbType.VarChar, 200),
new SqlParameter("@summary", SqlDbType.VarChar, 500),
new SqlParameter("@img", SqlDbType.VarChar, 200),
new SqlParameter("@aid", SqlDbType.Int, 4),
new SqlParameter("@author", SqlDbType.VarChar, 50),
new SqlParameter("@addtime", SqlDbType.DateTime),
new SqlParameter("@state", SqlDbType.Int, 4),
new SqlParameter("@tags", SqlDbType.VarChar, 100),
new SqlParameter("@types", SqlDbType.TinyInt, 1),
new SqlParameter("@length", SqlDbType.Int, 4),
new SqlParameter("@click", SqlDbType.Int, 4),
new SqlParameter("@good", SqlDbType.Int, 4),
new SqlParameter("@gxtime", SqlDbType.DateTime),
new SqlParameter("@isover", SqlDbType.TinyInt, 1),
new SqlParameter("@isgood", SqlDbType.TinyInt, 1)
};
parameters[0].Value = model.nid;
parameters[1].Value = model.title;
parameters[2].Value = model.summary;
parameters[3].Value = model.img;
parameters[4].Value = model.aid;
parameters[5].Value = model.author;
parameters[6].Value = model.addtime;
parameters[7].Value = model.state;
parameters[8].Value = model.tags;
parameters[9].Value = model.types;
parameters[10].Value = model.length;
parameters[11].Value = 0;
parameters[12].Value = 0;
parameters[13].Value = DateTime.Now;
parameters[14].Value = 0;
parameters[15].Value = model.isgood;
object obj = SqlHelperBook.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 计算某用户收藏数量
/// </summary>
public int GetCount(int usid, int types)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT Count(ID) from Favorites");
strSql.Append(" where types=" + types + "");
strSql.Append(" and usid=" + usid + "");
object obj = SqlHelperBook.GetSingle(strSql.ToString());
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Book.Model.Contents model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Contents(");
strSql.Append("shi,title,summary,contents,addtime,state,jid,tags,aid,pid)");
strSql.Append(" values (");
strSql.Append("@shi,@title,@summary,@contents,@addtime,@state,@jid,@tags,@aid,@pid)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@shi", SqlDbType.Int, 4),
new SqlParameter("@title", SqlDbType.VarChar, 255),
new SqlParameter("@summary", SqlDbType.VarChar, 500),
new SqlParameter("@contents", SqlDbType.Text),
new SqlParameter("@addtime", SqlDbType.DateTime),
new SqlParameter("@state", SqlDbType.Int, 4),
new SqlParameter("@jid", SqlDbType.Int, 4),
new SqlParameter("@tags", SqlDbType.VarChar, 100),
new SqlParameter("@aid", SqlDbType.Int, 4),
new SqlParameter("@pid", SqlDbType.Int, 4)
};
parameters[0].Value = model.shi;
parameters[1].Value = model.title;
parameters[2].Value = model.summary;
parameters[3].Value = model.contents;
parameters[4].Value = model.addtime;
parameters[5].Value = model.state;
parameters[6].Value = model.jid;
parameters[7].Value = model.tags;
parameters[8].Value = model.aid;
parameters[9].Value = model.pid;
object obj = SqlHelperBook.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 计算某书本章节或分卷数量types(0单节/1分卷)
/// </summary>
public int GetCount(int shi, int jid, int types)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT Count(ID) from Contents");
strSql.Append(" where ");
strSql.Append(" shi=@shi and ");
if (jid > 0)
{
strSql.Append(" jid=" + jid + " ");
}
else
{
if (types == 0)
{
strSql.Append(" jid<>-1 ");
}
else
{
strSql.Append(" jid=-1 ");
}
}
SqlParameter[] parameters =
{
new SqlParameter("@shi", SqlDbType.Int, 4)
};
parameters[0].Value = shi;
object obj = SqlHelperBook.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Book.Model.Favorites model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Favorites(");
strSql.Append("favid,types,title,nid,sid,purl,usid,addtime)");
strSql.Append(" values (");
strSql.Append("@favid,@types,@title,@nid,@sid,@purl,@usid,@addtime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@favid", SqlDbType.Int, 4),
new SqlParameter("@types", SqlDbType.Int, 4),
new SqlParameter("@title", SqlDbType.NVarChar, 50),
new SqlParameter("@nid", SqlDbType.Int, 4),
new SqlParameter("@sid", SqlDbType.Int, 4),
new SqlParameter("@purl", SqlDbType.NVarChar, 200),
new SqlParameter("@usid", SqlDbType.Int, 4),
new SqlParameter("@addtime", SqlDbType.DateTime)
};
parameters[0].Value = model.favid;
parameters[1].Value = model.types;
parameters[2].Value = model.title;
parameters[3].Value = model.nid;
parameters[4].Value = model.sid;
parameters[5].Value = model.purl;
parameters[6].Value = model.usid;
parameters[7].Value = model.addtime;
object obj = SqlHelperBook.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 计算某用户书架数量
/// </summary>
public int GetCount(int UsID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT Count(ID) from ShuFav");
strSql.Append(" where UsID=@UsID ");
SqlParameter[] parameters =
{
new SqlParameter("@UsID", SqlDbType.Int, 4)
};
parameters[0].Value = UsID;
object obj = SqlHelperBook.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}