/// <summary>
/// 插入
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(CriticalMass.TagNode.Model.tapi_tagnode_developers model, IDbTransaction trn)
{
IDbConnection conn = trn.Connection;
string sqlCommandText = @"insert into tapi_tagnode_developers(`username`,`password`,`createBy`,`createTime`,`modifyBy`,`modifyTime`)values(@username,@password,@createBy,@createTime,@modifyBy,@modifyTime);SELECT ifnull(@@IDENTITY,0)";
return(conn.Query <int>(sqlCommandText, model, trn).First());
}
/// <summary>
/// 更新
/// </summary>
/// <param name="model">模型</param>
/// <returns></returns>
public bool Update(CriticalMass.TagNode.Model.tapi_tagnode_developers model)
{
IDbConnection conn = base.GetConnection();
string sqlCommandText = @"update tapi_tagnode_developers set `username`=@username,`password`=@password,`createBy`=@createBy,`createTime`=@createTime,`modifyBy`=@modifyBy,`modifyTime`=@modifyTime where id=@id";
return(conn.Execute(sqlCommandText, model) > 0 ? true : false);
}
/// <summary>
/// 是否存在
/// </summary>
/// <param name="where">条件</param>
///<param name="parameter">参数</param>
/// <returns></returns>
public bool Exists(string where, CriticalMass.TagNode.Model.tapi_tagnode_developers parameter)
{
IDbConnection conn = base.GetConnection();
string sql = @"SELECT count(0) FROM tapi_tagnode_developers WHERE {0} ";
int res = conn.Query <int>(string.Format(sql, where), parameter).First();
return(res > 0);
}
/// <summary>
/// 删除记录
/// </summary>
/// <param name="id">id</param>
/// <returns></returns>
public bool Del(string where, CriticalMass.TagNode.Model.tapi_tagnode_developers parameter, IDbTransaction trn)
{
if (string.IsNullOrWhiteSpace(where))
{
return(false);
}
IDbConnection conn = trn.Connection;
string sqlCommandText = @"delete from tapi_tagnode_developers where " + where;
return(conn.Execute(sqlCommandText, parameter, trn) > 0 ? true : false);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="model">模型</param>
/// <returns></returns>
public bool Update(string field, CriticalMass.TagNode.Model.tapi_tagnode_developers model, IDbTransaction trn)
{
IDbConnection conn = trn.Connection;
if (model.id <= 0)
{
return(false);
}
string sqlCommandText = @"update tapi_tagnode_developers set " + field + " where id=@id";
return(conn.Execute(sqlCommandText, model, trn) > 0 ? true : false);
}