/// <summary>
/// 搜索足迹
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public static List <MFootmarks> SearchMarks(string search, int inUID)
{
string sql = @" SELECT * FROM nw_Footmarks WHERE UID = @inUID AND FmTitle LIKE '%' + @inSearch + '%' ORDER BY MarkTime DESC ";
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@inSearch", SqlDbType.NVarChar),
new SqlParameter("@inUID", SqlDbType.Int, 32)
};
paras[0].Value = search;
paras[1].Value = inUID;
DataTable dt = SqlHelper.ExecuteDataTable(CommandType.Text, sql, "", paras);
List <MFootmarks> list = new List <MFootmarks>();
foreach (DataRow item in dt.Rows)
{
MFootmarks model = new MFootmarks
{
FmID = Convert.ToInt32(item["FmID"]),
UID = Convert.ToInt32(item["UID"]),
ArticleID = Convert.ToInt64(item["ArticleID"]),
MarkTime = Convert.ToDateTime(item["MarkTime"]),
FmTitle = item["FmTitle"].ToString()
};
list.Add(model);
}
return(list);
}
/// <summary>
/// 获取足迹列表
/// </summary>
/// <param name="inUID"></param>
/// <returns></returns>
public static List <MFootmarks> GetFootmarks(int inUID)
{
string sql = @" SELECT * FROM nw_Footmarks WHERE UID = @inUID ORDER BY MarkTime DESC ";
SqlParameter para = new SqlParameter("@inUID", SqlDbType.Int, 32)
{
Value = inUID
};
DataTable dt = SqlHelper.ExecuteDataTable(CommandType.Text, sql, "", para);
List <MFootmarks> list = new List <MFootmarks>();
foreach (DataRow item in dt.Rows)
{
MFootmarks model = new MFootmarks
{
FmID = Convert.ToInt32(item["FmID"]),
UID = Convert.ToInt32(item["UID"]),
ArticleID = Convert.ToInt64(item["ArticleID"]),
MarkTime = Convert.ToDateTime(item["MarkTime"]),
FmTitle = item["FmTitle"].ToString()
};
list.Add(model);
}
return(list);
}
/// <summary>
/// 更新足迹记录
/// </summary>
/// <param name="inModel"></param>
/// <returns></returns>
public static int UpdateFootmark(MFootmarks inModel)
{
string sql = @" UPDATE nw_Footmarks SET MarkTime = @inMarkTime WHERE FmID = @inFmID ";
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@inMarkTime", SqlDbType.DateTime),
new SqlParameter("@inFmID", SqlDbType.Int, 32)
};
paras[0].Value = inModel.MarkTime;
paras[1].Value = inModel.FmID;
int result = SqlHelper.ExecuteNonQuery(CommandType.Text, sql, paras);
return(result);
}
/// <summary>
/// 创建足迹记录
/// </summary>
/// <param name="inModel"></param>
/// <returns></returns>
public static int CreateFootmark(MFootmarks inModel)
{
StringBuilder sql = new StringBuilder();
sql.Append(" INSERT INTO nw_Footmarks ( ");
sql.Append(" UID, ArticleID, MarkTime, FmTitle ) VALUES ( ");
sql.Append(" @inUID, @inArticleID, @inMarkTime, @inFmTitle ) ");
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@inUID", SqlDbType.Int, 32),
new SqlParameter("@inArticleID", SqlDbType.BigInt, 64),
new SqlParameter("@inMarkTime", SqlDbType.DateTime),
new SqlParameter("@inFmTitle", SqlDbType.NVarChar, 200)
};
paras[0].Value = inModel.UID;
paras[1].Value = inModel.ArticleID;
paras[2].Value = inModel.MarkTime;
paras[3].Value = inModel.FmTitle;
int result = SqlHelper.ExecuteNonQuery(CommandType.Text, sql.ToString(), paras);
return(result);
}
/// <summary>
/// 更新足迹记录
/// </summary>
/// <param name="inModel"></param>
/// <returns></returns>
public static int UpdateFootmark(MFootmarks inModel)
{
return(Data.DFootmarks.UpdateFootmark(inModel));
}
