/// <summary>
/// 插入
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(CriticalMass.TagNode.Model.tapi_tagnode_app model, IDbTransaction trn)
{
IDbConnection conn = trn.Connection;
string sqlCommandText = @"insert into tapi_tagnode_app(`did`,`app_name`,`app_desc`,`createTime`,`createBy`,`appkey`,`appsecret`,`status`,`audit`)values(@did,@app_name,@app_desc,@createTime,@createBy,@appkey,@appsecret,@status,@audit);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_app model)
{
IDbConnection conn = base.GetConnection();
string sqlCommandText = @"update tapi_tagnode_app set `did`=@did,`app_name`=@app_name,`app_desc`=@app_desc,`createTime`=@createTime,`createBy`=@createBy,`appkey`=@appkey,`appsecret`=@appsecret,`status`=@status,`audit`=@audit 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_app parameter)
{
IDbConnection conn = base.GetConnection();
string sql = @"SELECT count(0) FROM tapi_tagnode_app 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_app parameter, IDbTransaction trn)
{
if (string.IsNullOrWhiteSpace(where))
{
return(false);
}
IDbConnection conn = trn.Connection;
string sqlCommandText = @"delete from tapi_tagnode_app 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_app model, IDbTransaction trn)
{
IDbConnection conn = trn.Connection;
if (model.id <= 0)
{
return(false);
}
string sqlCommandText = @"update tapi_tagnode_app set " + field + " where id=@id";
return(conn.Execute(sqlCommandText, model, trn) > 0 ? true : false);
}
