public int Add(Category entity) { try { StringBuilder strSQL = new StringBuilder(); strSQL.Append("INSERT INTO tb_category("); strSQL.Append("ChannelID,Title,SortID)"); strSQL.Append(" VALUES ("); strSQL.Append("@ChannelID,@Title,@SortID);"); DbCommand dbCommand = DB.DB.Db().GetSqlStringCommand(strSQL.ToString()); int result = DB.DB.Db().ExecuteNonQuery(dbCommand); return result; } catch (Exception ex) { Log.Log.logError(ex.Message); throw; } }
private Category FillEntity(DataRow dr) { Category entity = new Category { ID = DataTypeHelper.Convert<Int32>(dr["ID"]), ChannelID = DataTypeHelper.Convert<Int32>(dr["ChannelID"]), Title = DataTypeHelper.Convert<String>(dr["Title"]), SortID = DataTypeHelper.Convert<Int32>(dr["SortID"]), }; return entity; }
public bool Update(Category entity) { try { StringBuilder strSQL = new StringBuilder(); strSQL.Append("UPDATE tb_category SET "); strSQL.Append(" ChannelID=@ChannelID,"); strSQL.Append("Title=@Title,"); strSQL.Append("SortID=@SortID"); strSQL.Append(" WHERE ID=@ID;"); DbCommand dbCommand = DB.DB.Db().GetSqlStringCommand(strSQL.ToString()); DB.DB.Db().AddInParameter(dbCommand, "@ChannelID", DbType.Int32, entity.ChannelID); DB.DB.Db().AddInParameter(dbCommand, "@Title", DbType.String, entity.Title); DB.DB.Db().AddInParameter(dbCommand, "@SortID", DbType.Int32, entity.SortID); DB.DB.Db().AddInParameter(dbCommand, "@ID", DbType.Int32, entity.ID); DB.DB.Db().ExecuteNonQuery(dbCommand); return true; } catch (Exception ex) { Log.Log.logError(ex.Message); throw; } }
public bool Update(Category entity) { return dal.Update(entity); }
public int Add(Category entity) { return dal.Add(entity); }