/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BCW.Model.Favgroup model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_Favgroup(");
strSql.Append("Types,Title,UsID,Paixu,AddTime)");
strSql.Append(" values (");
strSql.Append("@Types,@Title,@UsID,@Paixu,@AddTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Types", SqlDbType.Int, 4),
new SqlParameter("@Title", SqlDbType.NVarChar, 50),
new SqlParameter("@UsID", SqlDbType.Int, 4),
new SqlParameter("@Paixu", SqlDbType.Int, 4),
new SqlParameter("@AddTime", SqlDbType.DateTime)
};
parameters[0].Value = model.Types;
parameters[1].Value = model.Title;
parameters[2].Value = model.UsID;
parameters[3].Value = model.Paixu;
parameters[4].Value = model.AddTime;
object obj = SqlHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public BCW.Model.Favgroup GetFavgroup(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,Types,Title,UsID,Paixu,AddTime from tb_Favgroup ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
BCW.Model.Favgroup model = new BCW.Model.Favgroup();
using (SqlDataReader reader = SqlHelper.ExecuteReader(strSql.ToString(), parameters))
{
if (reader.HasRows)
{
reader.Read();
model.ID = reader.GetInt32(0);
model.Types = reader.GetInt32(1);
model.Title = reader.GetString(2);
model.UsID = reader.GetInt32(3);
model.Paixu = reader.GetInt32(4);
model.AddTime = reader.GetDateTime(5);
return(model);
}
else
{
return(null);
}
}
}
/// <summary>
/// 取得每页记录
/// </summary>
/// <param name="p_pageIndex">当前页</param>
/// <param name="p_pageSize">分页大小</param>
/// <param name="p_recordCount">返回总记录数</param>
/// <param name="strWhere">查询条件</param>
/// <returns>IList Favgroup</returns>
public IList <BCW.Model.Favgroup> GetFavgroups(int p_pageIndex, int p_pageSize, string strWhere, out int p_recordCount)
{
IList <BCW.Model.Favgroup> listFavgroups = new List <BCW.Model.Favgroup>();
string sTable = "tb_Favgroup";
string sPkey = "id";
string sField = "ID,Types,Title,UsID,Paixu,AddTime";
string sCondition = strWhere;
string sOrder = "ID Desc";
int iSCounts = 0;
using (SqlDataReader reader = SqlHelper.RunProcedureMe(sTable, sPkey, sField, p_pageIndex, p_pageSize, sCondition, sOrder, iSCounts, out p_recordCount))
{
//计算总页数
if (p_recordCount > 0)
{
int pageCount = BasePage.CalcPageCount(p_recordCount, p_pageSize, ref p_pageIndex);
}
else
{
return(listFavgroups);
}
while (reader.Read())
{
BCW.Model.Favgroup objFavgroup = new BCW.Model.Favgroup();
objFavgroup.ID = reader.GetInt32(0);
objFavgroup.Types = reader.GetInt32(1);
objFavgroup.Title = reader.GetString(2);
objFavgroup.UsID = reader.GetInt32(3);
objFavgroup.Paixu = reader.GetInt32(4);
objFavgroup.AddTime = reader.GetDateTime(5);
listFavgroups.Add(objFavgroup);
}
}
return(listFavgroups);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(BCW.Model.Favgroup model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_Favgroup set ");
strSql.Append("Types=@Types,");
strSql.Append("Title=@Title,");
strSql.Append("UsID=@UsID,");
strSql.Append("Paixu=@Paixu,");
strSql.Append("AddTime=@AddTime");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@Types", SqlDbType.Int, 4),
new SqlParameter("@Title", SqlDbType.NVarChar, 50),
new SqlParameter("@UsID", SqlDbType.Int, 4),
new SqlParameter("@Paixu", SqlDbType.Int, 4),
new SqlParameter("@AddTime", SqlDbType.DateTime)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.Types;
parameters[2].Value = model.Title;
parameters[3].Value = model.UsID;
parameters[4].Value = model.Paixu;
parameters[5].Value = model.AddTime;
SqlHelper.ExecuteSql(strSql.ToString(), parameters);
}
public RspAddFavorites AddFavorites(ReqAddFavorites _reqData)
{
RspAddFavorites _rspData = new RspAddFavorites();
//验证用户ID格式
if (_reqData.userId < 0)
{
_rspData.header.status = ERequestResult.faild;
_rspData.header.statusCode = Error.MOBILE_ERROR_CODE.MOBILE_PARAMS_ERROR;
return(_rspData);
}
//检查是否登录状态
if (Common.Common.CheckLogin(_reqData.userId, _reqData.userKey) == 0)
{
_rspData.header.status = ERequestResult.faild;
_rspData.header.statusCode = Error.MOBILE_ERROR_CODE.SYS_USER_NOLOGIN;
return(_rspData);
}
//检查帖子有效性
BCW.Model.Text model = new BCW.BLL.Text().GetText(_reqData.threadId);//GetTextMe
if (model == null)
{
_rspData.header.status = ERequestResult.faild;
_rspData.header.statusCode = Error.MOBILE_ERROR_CODE.BBS_THREAD_NOT_FOUND;
return(_rspData);
}
//是否存在此收藏记录
DataSet _ds = null;
_ds = new BCW.BLL.Favorites().GetList("TOP 1 ID", string.Format(" PUrl like '%bid={0}' and Types=1 and UsID={1}", _reqData.threadId, _reqData.userId));
if (_ds != null && _ds.Tables[0].Rows.Count > 0)
{
_rspData.header.status = ERequestResult.faild;
_rspData.header.statusCode = Error.MOBILE_ERROR_CODE.BBS_FAVORITES_EXISTS;
return(_rspData);
}
//如果没有默认收藏夹，先帮其创建一个再进行收藏
int _groupId = 0;
_ds = new BCW.BLL.Favgroup().GetList("Top 1 ID,Title", " UsID=" + _reqData.userId + " and Title='默认收藏'");
if (_ds == null || _ds.Tables[0].Rows.Count == 0)
{
BCW.Model.Favgroup _groupModel = new BCW.Model.Favgroup();
_groupModel.Types = 0;
_groupModel.Title = "默认收藏";
_groupModel.UsID = _reqData.userId;
_groupModel.Paixu = 0;
_groupModel.AddTime = DateTime.Now;
_groupId = new BCW.BLL.Favgroup().Add(_groupModel);
}
else
{
_groupId = int.Parse(_ds.Tables[0].Rows[0]["ID"].ToString());
}
//保存收藏
BCW.Model.Favorites _favoritesModel = new BCW.Model.Favorites();
_favoritesModel.Types = 1;
_favoritesModel.NodeId = _groupId;
_favoritesModel.UsID = _reqData.userId;
_favoritesModel.Title = model.Title;
_favoritesModel.PUrl = string.Format("/bbs/topic.aspx?forumid={0}&bid={1}", model.ForumId, _reqData.threadId);
_favoritesModel.AddTime = DateTime.Now;
int favid = new BCW.BLL.Favorites().Add(_favoritesModel);
_rspData.threadId = _reqData.threadId;
_rspData.isFavorites = true;
_rspData.header.status = ERequestResult.success;
return(_rspData);
}
