/// <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); }