///<summary>
///向数据库中添加一条记录
///</summary>
///<param name="model">要添加的实体</param>
public bool Insert(TqgItem model)
{
const string sql = @"INSERT INTO [dbo].[TqgItem] (num_iid,title,total_amount,click_url,category_name,zk_final_price,end_time,sold_num,start_time,reserve_price,pic_url) VALUES (@num_iid,@title,@total_amount,@click_url,@category_name,@zk_final_price,@end_time,@sold_num,@start_time,@reserve_price,@pic_url)";
int res = SqlHelper.ExecuteNonQuery(sql, new SqlParameter("@num_iid", model.num_iid.ToDBValue()), new SqlParameter("@title", model.title.ToDBValue()), new SqlParameter("@total_amount", model.total_amount.ToDBValue()), new SqlParameter("@click_url", model.click_url.ToDBValue()), new SqlParameter("@category_name", model.category_name.ToDBValue()), new SqlParameter("@zk_final_price", model.zk_final_price.ToDBValue()), new SqlParameter("@end_time", model.end_time.ToDBValue()), new SqlParameter("@sold_num", model.sold_num.ToDBValue()), new SqlParameter("@start_time", model.start_time.ToDBValue()), new SqlParameter("@reserve_price", model.reserve_price.ToDBValue()), new SqlParameter("@pic_url", model.pic_url.ToDBValue()));
return(res > 0);
}
/// <summary>
/// 查询单个模型实体
/// </summary>
/// <param name="id">num_iid</param>);
/// <returns>实体</returns>);
public TqgItem QuerySingleById(long num_iid)
{
const string sql = "SELECT TOP 1 num_iid,title,total_amount,click_url,category_name,zk_final_price,end_time,sold_num,start_time,reserve_price,pic_url from TqgItem WHERE [num_iid] = @num_iid";
using (var reader = SqlHelper.ExecuteReader(sql, new SqlParameter("@num_iid", num_iid)))
{
if (reader.HasRows)
{
reader.Read();
TqgItem model = SqlHelper.MapEntity <TqgItem>(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 <TqgItem> QueryList(int index, int size, object wheres = null, string orderField = "uuid", bool isDesc = true)
{
List <SqlParameter> list = null;
string where = wheres.parseWheres(out list);
orderField = string.IsNullOrEmpty(orderField) ? "uuid" : orderField;
var sql = SqlHelper.GenerateQuerySql("TqgItem", new string[] { "num_iid", "title", "total_amount", "click_url", "category_name", "zk_final_price", "end_time", "sold_num", "start_time", "reserve_price", "pic_url" }, index, size, where, orderField, isDesc);
using (var reader = SqlHelper.ExecuteReader(sql, list.ToArray()))
{
if (reader.HasRows)
{
while (reader.Read())
{
TqgItem model = SqlHelper.MapEntity <TqgItem>(reader);
yield return(model);
}
}
}
}
/// <summary>
/// 根据主键更新一条记录
/// </summary>
/// <param name="model">更新后的实体</param>
/// <returns>执行结果受影响行数</returns>
public bool Update(TqgItem model)
{
return(_dao.Update(model));
}
/// <summary>
/// 向数据库中添加一条记录
/// </summary>
/// <param name="model">要添加的实体</param>
/// <returns>是否成功</returns>
public bool Insert(TqgItem model)
{
return(_dao.Insert(model));
}
/// <summary>
/// 根据主键更新一条记录
/// </summary>
/// <param name="model">更新后的实体</param>
/// <returns>是否成功</returns>
public bool Update(TqgItem model)
{
const string sql = @"UPDATE [dbo].[TqgItem] SET title=@title,total_amount=@total_amount,click_url=@click_url,category_name=@category_name,zk_final_price=@zk_final_price,end_time=@end_time,sold_num=@sold_num,start_time=@start_time,reserve_price=@reserve_price,pic_url=@pic_url WHERE [num_iid] = @num_iid";
return(SqlHelper.ExecuteNonQuery(sql, new SqlParameter("@num_iid", model.num_iid.ToDBValue()), new SqlParameter("@title", model.title.ToDBValue()), new SqlParameter("@total_amount", model.total_amount.ToDBValue()), new SqlParameter("@click_url", model.click_url.ToDBValue()), new SqlParameter("@category_name", model.category_name.ToDBValue()), new SqlParameter("@zk_final_price", model.zk_final_price.ToDBValue()), new SqlParameter("@end_time", model.end_time.ToDBValue()), new SqlParameter("@sold_num", model.sold_num.ToDBValue()), new SqlParameter("@start_time", model.start_time.ToDBValue()), new SqlParameter("@reserve_price", model.reserve_price.ToDBValue()), new SqlParameter("@pic_url", model.pic_url.ToDBValue())) > 0);
}
